Migrate to Xero: UK HMRC and ICO checklist with Keystone tips
Yes, most businesses running an ageing or unsupported system should migrate to Xero now, and the first task is practical rather than technical: pick a conversion date and export a full trial balance and backup of your legacy records before you touch the new software. If you are VAT registered or approaching your year end, build that timing into your plan rather than rushing the switch mid-quarter.
TL;DR:
Migration planning should include exporting a trial balance and backing up your legacy system at least a week before go-live to allow time for troubleshooting.
Choose a conversion date that aligns with month or year-end to avoid splitting reporting periods and reconcile balances immediately after import to ensure accuracy.
Simplifying or rationalizing your chart of accounts reduces potential errors and speeds up bookkeeping once in Xero, especially when importing transaction history.
Use a test import to identify formatting issues early, and connect bank feeds only after all other data is confirmed correct to prevent mismatches.
Complex setups with multiple entities, custom fields, or payroll may require engaging a specialist or using paid add-ons for a successful migration.
Table of Contents
Pre-migration checklist: backups, exports and decisions to make
Choosing the conversion date and planning your migration timetable
How to prepare and map your data so imports land cleanly in Xero
Run a test migration, import files and reconcile opening balances
Data portability, GDPR and HMRC considerations during migration
Keystone Financial Advisory: practical lessons and where we add value
What a migration to Xero typically moves
A standard migration carries across your chart of accounts, opening balances, customer and supplier records, outstanding invoices, and a defined window of transaction history. Xero’s own conversion offer commonly covers up to 24 months of financial history, which is usually enough for reporting continuity without importing years of low-value detail.
Most businesses choose one of three routes:
Manual or self-service import using Xero’s built-in tools for smaller data sets.
A conversion tool, such as Xero’s partner Movemybooks, for structured bulk transfers.
An assisted migration handled by an accountant or specialist for complex setups.
Once live, most businesses notice the immediate benefits quickly: automated bank feeds, fewer manual reconciliations, and software built for Making Tax Digital compatibility. Very old or low-value transaction-level detail is usually left out of the import and archived instead.
Pre-migration checklist: backups, exports and decisions to make
Preparation determines whether your migration is smooth or painful. Work through these steps before you touch the new system:
Export a full trial balance and key reports as of the day before your chosen conversion date.
Take a complete backup of your legacy accounting system, including attachments and audit trails.
Gather VAT records, payroll data and recent bank statements, and check your current software contract for any data-export restrictions.
Decide how much transaction history to import and whether to simplify your chart of accounts rather than copying it as is.
Tell staff and stakeholders what’s changing, and book training sessions and follow-up checkpoints in advance.
Pro Tip: Run your backup and export a week before go-live, not the night before. It gives you time to fix a corrupted file or missing report without delaying the whole project.
Choosing the conversion date and planning your migration timetable
Your conversion date sets the opening balances that Xero builds everything on, so run your trial balance the day before that date and use those figures as your starting point. Where practical, choose the first of a month or your financial year end, since this avoids splitting a reporting period across two systems.
Exceptions exist. A business with a complex VAT position mid-quarter may prefer to wait until after the return is filed rather than reconcile two systems at once.
A typical timetable runs in stages:
Planning and data preparation.
A test import to catch formatting issues early.
Reconciliation against your legacy trial balance.
A short parallel run before switching over fully.
Practitioner guidance suggests allowing four to eight weeks for this sequence in a typical setup, longer for multi-entity or payroll-heavy businesses.
How to prepare and map your data so imports land cleanly in Xero
Start by extracting your trial balance, open invoice and credit note lists, supplier and customer records, and recent bank statements from your legacy system in a usable format such as CSV.
Mapping your chart of accounts is where most migrations go wrong. Don’t copy your old structure line for line: rationalise codes you no longer use and group ones that only ever get used for the same purpose. A leaner chart of accounts speeds up day-to-day bookkeeping once you’re live.
Keep detailed transaction history for the current and prior VAT periods.
Archive older, reconciled transactions rather than importing them individually.
Retain original source documents separately, even after they’re summarised in Xero.
HMRC requires that core accounting and VAT records, including invoices, bank statements and ledgers, be retained for set minimum periods, with different record types carrying different retention lengths. This applies to your original records regardless of which software holds your current data, so migrating to Xero does not shorten what you need to keep on file. Our guide to HMRC-ready software setup covers this in more detail.
Run a test migration, import files and reconcile opening balances
Before touching live data, run a small test import to check date formats, currency settings and how contacts land in Xero. This catches formatting problems while the stakes are low.
For the real import, follow this sequence:
Import your chart of accounts first, since everything else maps against it.
Bring in conversion balances next, matching your trial balance exactly.
Add outstanding invoices and credit notes.
Import remaining transaction history.
Connect bank feeds last, once the rest of the data is confirmed correct.
Once everything is in, reconcile the opening balances in Xero against your legacy trial balance line by line and correct any mismatches immediately rather than letting them carry forward.
Pro Tip: A mismatched opening balance almost always traces back to a rounding difference or a account mapped to the wrong nominal code, check both first before assuming the data itself is wrong.
When to use conversion tools and when to hire a specialist
Free or low-cost conversion tools handle standard chart of accounts and a defined history window well, but they typically struggle with custom fields, complex tracking categories or multi-currency setups.
Consider hiring a specialist when:
You run multiple entities or need consolidated reporting.
Payroll history and year-to-date figures need careful handling.
You rely on bespoke integrations that need remapping.
Past reconciliations are messy and need cleaning up before they move across.
When evaluating a provider, check their Xero partner status, ask for references from similar businesses, and get a clear statement on how they handle your data and what happens if the engagement ends. Free migration offers usually cover the standard data set; anything beyond that, such as deep historical detail or custom workflows, is typically a paid add-on.
Data portability, GDPR and HMRC considerations during migration
Before you give notice on your existing software, check the contract for data-export clauses. ICAEW guidance warns that some providers restrict exports or cut access immediately once a contract ends, so arrange your export first.
If any part of your data will be processed or hosted outside the country, check whether this counts as a restricted transfer under ICO guidance and whether contractual safeguards are needed.
Confirm your migrated records satisfy HMRC’s retention rules and remain compatible with Making Tax Digital for VAT.
Ask any migration partner for a written data-handling statement and relevant security certifications.
Migration is not only a technical task. It is a business transformation that touches contracts, processes and data ownership.
Short post-go-live checklist and onboarding plan
The weeks after go-live matter as much as the migration itself. Work through this list in the first quarter:
Verify bank feeds are pulling correctly and reconcile the first few weeks of transactions manually as a check.
Confirm VAT submissions are set up correctly and user permissions match who should have access.
Book follow-up checkpoints at one week, one month and three months to catch issues while they’re small.
Archive your legacy system backup somewhere safe and keep original source documents on file per retention rules.
Train staff on daily tasks in Xero and set up a simple dashboard so you can see whether the team has actually adopted it.
Keystone Financial Advisory: practical lessons and where we add value
The migrations that go wrong usually fail on one small thing: a chart of accounts copied without review, or an opening balance nobody checked against the trial balance. We see this repeatedly, and it is almost always avoidable with a short reconciliation check before go-live.
A migration is also a natural point to automate parts of your bookkeeping you have been doing manually for years, which lowers ongoing costs rather than just moving the same work onto new software.
— Shoaib
Sources
For retention periods, see HMRC’s record-keeping notice. For restricted transfers, see ICO guidance. For planning support, see Vicedomini Softworks’ migration guide.
FAQ
What are the downsides of using Xero?
Some businesses find Xero’s standard plans limit certain features, such as multi-currency support or advanced reporting, to higher pricing tiers. Complex or highly customised setups can also take longer to configure than simpler off-the-shelf systems.
Does HMRC recognise Xero?
Yes, Xero appears on HMRC’s list of software compatible with Making Tax Digital for VAT, meaning it can be used to file VAT returns digitally. You should still confirm your specific setup meets the digital links requirement before relying on it for submissions.
Is it easy to migrate from QuickBooks to Xero?
Most standard QuickBooks setups migrate reasonably smoothly using Xero’s conversion tools, which can carry across up to 24 months of history. Complex setups with custom fields, multiple entities or messy historical reconciliations usually benefit from specialist help rather than a self-service import.
How much does it cost to migrate to Xero?
Xero’s standard self-service conversion is offered free through its partner tools, covering a defined data set and history window. Beyond that, costs depend on the complexity of your data and whether you hire a specialist such as an accountant to manage the process, so get a quote based on your specific setup, for example through KeystoneFA’s accounting services, which start from £99 to £199 per month.
Recommended