Home / Insights / Xero & Automation

Xero & Automation

Moving from QuickBooks to Xero

How to plan a QuickBooks Online to Xero migration for a Singapore company: scope, cut-over date, opening balances, GST codes and the checks to run before going live.

By Aether Digital · Last reviewed 23 November 2026

A migration has worked when the trial balance in Xero at the cut-over date agrees to the trial balance in QuickBooks at the same date, account by account, and open receivables and payables agree to their aged reports. Everything else in the project exists to make that reconciliation pass.

1. Decide the scope

There are two sensible options:

  • Balances only. Bring in the closing trial balance, open invoices and open bills at the cut-over date. History stays in QuickBooks. This is quicker and cleaner.
  • Balances plus history. Bring in one or more years of transactions as well. This gives comparatives inside Xero but takes longer and carries more risk of mismatches.

For most SMEs, balances only, plus comparative figures loaded as monthly journals, is enough.

2. Choose the cut-over date

Pick a period end, ideally a financial year end or a GST quarter end. Cutting over mid-quarter means one GST return drawn from two systems, which is where errors happen. Close the final period in QuickBooks fully before you start: reconcile the banks, clear suspense and file the GST return for that period from QuickBooks.

3. Map the chart of accounts and tax codes

  • Map every QuickBooks account to a Xero account. Use the move to retire unused accounts and merge duplicates.
  • Map tax codes one by one. Standard-rated, zero-rated, exempt, out-of-scope and blocked input tax must each land on the right Xero tax rate, or the first GST return from Xero will be wrong.
  • Decide tracking categories now if you report by location, department or entity.

4. Bring in the opening position

  • Enter conversion balances at the cut-over date.
  • Import open sales invoices and supplier bills individually, so they can be matched to receipts and payments later. Do not bring receivables and payables in as a single lump.
  • Load the fixed asset register with cost and accumulated depreciation.
  • Set bank account opening balances to the reconciled statement balance, and list unpresented items.

5. Connect and configure

  • Connect bank feeds and check the first imported statement line follows the cut-over balance with no gap or overlap.
  • Set up invoice templates, payment terms, user roles and approval rules.
  • Recreate recurring invoices and bills.

6. Prove it

Run these checks before anyone posts live transactions:

  1. Trial balance in Xero equals trial balance in QuickBooks at cut-over, by account.
  2. Aged receivables and payables in Xero equal the same reports in QuickBooks.
  3. Bank balances equal the reconciled balances.
  4. GST control account equals the amount carried over, normally nil if the last return was filed from QuickBooks.
  5. Retained earnings and current-year earnings are split correctly.

Keep the reconciliation as a working paper.

7. Keep the old records accessible

IRAS requires companies to keep records for at least five years from the relevant Year of Assessment, and GST-registered businesses to keep GST records for at least five years. If history stays in QuickBooks, export the general ledger, trial balances and GST reports for the retained years before the subscription ends, and store them where they can be retrieved.

Common mistakes

  • Cutting over before the last period is closed.
  • Importing receivables as one balance, then being unable to match payments.
  • Tax codes mapped by name instead of by treatment.
  • Bank feeds overlapping the conversion balance, doubling transactions.
  • No written reconciliation, so no one can show the migration was correct.

Sources

This article is general information as at the review date. It is not tax, accounting or investment advice and does not create a client relationship. Prepared with AI assistance and published by Aether Digital.

Related: Xero & Automation ยท Accounting & Bookkeeping

Tell us about your finance function

Share a few details and we will respond with next steps and, where appropriate, a proposal. Or email [email protected].