Data migration · Xero

Last reviewed: 13 November 2026. Xero is widely used in the UK, Australia and New Zealand, and by international groups. Businesses move into Xero when their accountant works in it, and out of Xero when they consolidate on Zoho or QuickBooks. Xero imports contacts, chart of accounts, invoices, bills, manual journals and conversion balances from CSV, and exports reports and data for migration out.

At a glance
Into XeroChart of accounts, contacts, conversion balances, invoices, bills and manual journals by CSV.
Out of XeroReports and data exports converted to Zoho Books or QuickBooks import formats.
Key mappingTracking categories, VAT or GST rates, and multi-currency open items.
UK pointVAT records must remain compliant with Making Tax Digital across the switch.

Part of our accounting data migration series. For the method, cutover choices and compliance points that apply to every migration, start with the accounting data migration guide.

Routes

RouteTypical reasonPoints to watch
Xero to Zoho BooksMoving to the Zoho suite with CRM, inventory and payrollTracking categories to reporting tags; VAT schemes
Xero to QuickBooks OnlineGroup or advisor standardises on QuickBooksAccount and detail types; classes and locations
Zoho Books or QuickBooks to XeroUK accountant works in XeroConversion date and conversion balances; MTD VAT continuity

Steps

  1. Agree the conversion date and lock the source period.
  2. Export the trial balance, aged receivables and payables, contacts and transactions in scope.
  3. Set up the destination: tax rates, currencies, tracking or reporting dimensions, and chart of accounts.
  4. Import contacts and accounts, then conversion or opening balances, then open invoices and bills.
  5. Reconcile the balance sheet, profit and loss, aged reports and VAT or GST reports against the source.
  6. Reconnect bank feeds and integrations and archive the old file.

UK VAT and MTD

For VAT-registered UK businesses, digital records and digital links must be maintained under Making Tax Digital. Plan the switch at the end of a VAT period, file the period's return from the old system, and start the next period in the new one. Our note on Xero year-end and VAT work for UK practices covers the accounting side.

Other routes: QuickBooks Online to Zoho Books, Zoho Books to QuickBooks Online.

Frequently asked questions

Can Xero data be moved to Zoho Books?

Yes. Xero data is exported and converted to Zoho Books import formats for chart of accounts, contacts, opening balances, open invoices and bills, and transactions, then reconciled against Xero reports.

What are conversion balances in Xero?

They are the opening balances entered in Xero as at the conversion date, the day the business starts using Xero, so that reports carry on from the previous system.

How are Xero tracking categories migrated?

They are mapped to reporting tags in Zoho Books, or to classes and locations in QuickBooks Online, depending on how management reports are built.

When should a UK VAT-registered business switch software?

At the end of a VAT period, so that the return for that period is filed from one system and the next period starts cleanly in the other, keeping Making Tax Digital records intact.

Can multi-currency invoices be migrated?

Yes. Open foreign-currency invoices and bills are brought across with their original currency and exchange rate so that later receipts produce correct gains or losses.

Planning to switch accounting software?
We map your chart of accounts, masters and open items, migrate the data through the destination software's own import tools, and reconcile the trial balance, receivables, payables, stock and tax ledgers before you go live. Migrations from other software are assessed on what it can export and the destination can import; the scope and cutover date are agreed in writing before we start.
Accounting data migrationAccounting support for US, UK and UAE businessesBook a consultation

This article is for general information and does not constitute advice on any specific case. Import and export features, file formats and plan limits of each software change with new releases; the position described is as published by the vendors on the date of review. Software names are trademarks of their respective owners and are used only to describe the systems involved; no affiliation or endorsement is implied. Firm details: Somesh Chandak & Associates, Chartered Accountants, Unit 119, 1st Floor, Centura Square IT Park, SG Barve Road, Wagle Estate, Thane West 400604. FRN 158694W.