QuickBooks Migration Guide for UK Small Businesses
A clean move to QuickBooks Online comes down to four things: tidy books before you export, a chart of accounts that imports without errors, opening balances that match your last filed accounts, and a VAT set-up that keeps your Making Tax Digital link intact. This guide walks through each in the order you will do them, with the UK-specific traps that generic guides skip.
TL;DR
Reconcile everything and agree a cut-over date (ideally a month or VAT quarter end) before you export a single file.
Import your chart of accounts by CSV, then bring in opening balances and open invoices and bills rather than years of raw transactions.
Keep a digital link to HMRC for VAT: copy-pasting between systems is not allowed under Making Tax Digital.
Run old and new systems side by side for one period, and keep read-only access to the old one.
Budget time to train the people who will use the new software every day.
Table of Contents
Decide what you are actually migrating
Most founders say “migration” and mean one of three different jobs:
Starting point | What usually works best |
Another cloud package (for example Xero) | Export lists and reports, import the chart of accounts, then post opening balances |
Spreadsheets | Build a clean chart of accounts and import customers, suppliers and opening balances |
QuickBooks Desktop | Use Intuit’s own conversion route, then check the results against your trial balance |
The automated route matters less than you might think. Intuit’s Xero conversion guide is written for US accounts, and it requires a Xero US organisation and a QuickBooks Online US subscription. A UK business moving from Xero should therefore plan on exports and imports rather than assume a one-click transfer, and should check what Intuit currently offers for UK files before relying on any automated option.
Step 1: Clean the books before you move them
A migration copies your problems across faithfully. Before exporting:
Reconcile every bank, card and loan account up to the cut-over date.
Clear or explain items sitting in suspense or “ask my accountant” accounts.
Merge duplicate customers and suppliers, and archive the ones you no longer use.
Check that your VAT return filed for the last period agrees with the VAT control account.
Agree your cut-over date. A month end is fine; a VAT quarter end is cleaner, because one return then sits entirely in one system.
Our month end close checklist is a good way to get to a defensible set of closing figures. If you want a broader view of the set-up side, see our guide to HMRC-ready accounting software set-up.
Step 2: Import your chart of accounts
The chart of accounts is the skeleton of everything else, so do it first. QuickBooks lets you import it from a spreadsheet, which Intuit says is best done when first setting up your company.
How to prepare the file:
Export your chart of accounts from the old system, or build one in a spreadsheet.
Keep these columns: Account Name, Type, Detail Type, and optionally a Number.
Write sub-accounts into the Account Name column in the format Intuit’s page shows.
Save as CSV, Excel or Google Sheets.
In QuickBooks Online, go to Settings, choose Import data, then Chart of Accounts, and upload the file.
The usual snag is mapping. Your old account types will not match QuickBooks’ Type and Detail Type values word for word, so expect to edit that column by hand. Take the chance to simplify: if you have 140 accounts and use 60, import 60. Fewer accounts make VAT and management reporting easier to trust.
Step 3: Bring across opening balances, not history
For most small companies the sensible approach is to post a trial balance as at the cut-over date, then add:
open sales invoices and supplier bills, so debtors and creditors still age correctly;
bank balances as at the cut-over date, with unreconciled items listed;
fixed asset cost and depreciation balances;
the VAT, PAYE and corporation tax liabilities that sit on the balance sheet;
director’s loan account balances.
Keep the old system’s reports (profit and loss, balance sheet, aged debtors and creditors, and the transaction detail) as PDFs and spreadsheets. Your accountant, and potentially HMRC, may ask for the history later.
If you do want comparative figures, import a monthly summary journal for the prior year instead of thousands of individual lines. It is quicker and far less error-prone.
Step 4: Protect your VAT and Making Tax Digital position
This is the part where UK migrations go wrong most expensively. HMRC says all VAT-registered businesses must use compatible software to keep VAT records and file returns. Its guidance on keeping VAT records also lists the records you must keep digitally.
In practice:
Re-authorise the software with HMRC under your Government Gateway login, and check the VAT scheme, period dates and rate settings before the first return.
Do not bridge two systems by copying and pasting figures. The rules on digital links are set out in VAT Notice 700/22, and a manual re-key between programs breaks the chain.
If you are on a special scheme, confirm it is set up correctly. Our explainer on the cash accounting VAT scheme shows what changes in the records.
Trading in other currencies? Set up the home currency and exchange-rate handling before importing anything. See multi-currency bookkeeping for startups.
Step 5: Check the numbers before you switch
Never go live on trust. After the import, run these checks:
The trial balance in QuickBooks equals the trial balance you exported, line by line.
Aged debtors and creditors total the control accounts.
Bank balances match the statements on the cut-over date.
A test VAT return calculation looks sensible against the last filed return.
It also helps to know what a clean handover looks like. This accountant handover checklist from a UK record-keeping app for sole traders is aimed at tradespeople, but the discipline of tax-ready records and tidy exports applies to any business changing systems.
Step 6: Run in parallel, then retire the old system
For one month or one VAT period, enter transactions in the new system only, but keep the old one open for reference. Do not cancel the old subscription the day you go live. Take full exports first and confirm you can open them.
That caution is not theoretical. When a bookkeeping provider collapsed in 2025, ICAEW noted that customers worried about access to their data, including one who had just paid for a migration. Your own copies are your insurance.
Then switch off bank feeds in the old system so you do not double-import, and record the date you stopped using it.
Plan for people, not just data
The ACCA’s research on cloud accounting adoption found that successful transitions tend to come with full leadership commitment and proper training, rather than an assumption that the new software works like the old. Underestimating the time needed for training and adjustment is a common source of friction afterwards. Block out time for whoever raises invoices, approves bills and runs payroll to learn the new screens, and agree who owns the bank reconciliation each week.
Our perspective
We see the same pattern with founders who come to us mid-migration: the software is rarely the problem. The problem is that nobody decided what “finished” means. A migration is done when the opening balances agree to the last filed accounts, VAT is connected to HMRC, and someone is named as responsible for the month end.
Our view is that most small companies are better served by a lighter chart of accounts, opening balances instead of full history, and one month of parallel running. It takes slightly longer in week one and saves a great deal of cleaning up at year end. We pair modern digital tools with traditional accounting discipline, and that is where we put our effort on a move like this.
— Shoaib
Want a second pair of eyes on your move?
If you would rather not do this alone, we handle bookkeeping, VAT filing, payroll, accounts preparation and tax planning for UK founders and small businesses, and our published accounting packages run from £99 to £199 per month. See our services and tell us where your books stand today. If you are weighing up another platform, our Xero migration checklist covers the HMRC and data protection points in the same spirit.
FAQ
Can I import my chart of accounts into QuickBooks Online from a spreadsheet?
Yes. Prepare a file with Account Name, Type and Detail Type columns, with Number optional, then go to Settings, Import data, Chart of Accounts. Intuit recommends doing this when you first set up the company. Expect to correct some account types by hand.
How do I migrate from Xero to QuickBooks Online in the UK?
Reconcile Xero to your cut-over date, export your chart of accounts, contact lists, trial balance and aged reports, then import the lists and post opening balances in QuickBooks. Intuit’s automated Xero conversion page is written for US accounts, so do not assume it applies to a UK organisation.
Do I need to bring all my old transactions across?
Usually not. Opening balances, open invoices and bills, and saved reports from the old system are enough for most small companies. Import prior-year summaries only if you need comparatives.
Will migrating break Making Tax Digital for VAT?
It will if you bridge systems by copy and paste. Reconnect the new software to HMRC, check your VAT scheme and period settings, and keep digital records throughout. If you are unsure, ask your accountant before your next return is due.
Sources
Recommended