Payroll and accounting migrations punish bad timing more than bad tooling. The mechanics of moving from QuickBooks to Xero are well trodden and largely solved. What goes wrong is opening balances that do not tie out, VAT periods that straddle two systems, and reconciliations nobody finished before the switch.<\/p>\n
This guide covers the whole move in the order that keeps your accounts defensible. Involve your accountant or bookkeeper from step one \u2014 not because the software is hard, but because they are the person who signs off the year-end that this affects.<\/p>\n
Everything else follows from this.<\/p>\n
Best: the first day of a new financial year.<\/strong> No part-year data to reconcile. Your opening balances are simply last year’s closing balances, already agreed and signed off.<\/p>\n Acceptable: the first day of a VAT quarter or tax quarter.<\/strong> Filings align cleanly to one system or the other.<\/p>\n Avoid: mid-period.<\/strong> You will file a return using data split across two systems, and reconciling that is genuinely unpleasant.<\/p>\n Pick the date, then work backwards. Do not start moving data until you have one.<\/p>\n Before exporting anything, get QuickBooks into a state your accountant would be happy to sign off.<\/p>\n That trial balance is your reference document. Everything after this is checked against it.<\/p>\n You are legally required to retain accounting records for several years \u2014 six in the UK for limited companies, generally seven in the US, five to seven in Australia and Canada depending on circumstances. That obligation stays with you regardless of which software you use.<\/p>\n Export and store, outside both systems:<\/p>\n Do this before you cancel anything. Access ends when the subscription does.<\/p>\n You have three realistic options, and most small businesses over-choose.<\/p>\n Opening balances only.<\/strong> Start Xero with a trial balance as at the changeover date, plus open invoices and bills. History stays in QuickBooks as an archive. Fastest, cleanest, and sufficient for most businesses.<\/p>\n Opening balances plus current year.<\/strong> Lets you run full-year comparatives in Xero for the year of the switch. More work; sometimes worth it.<\/p>\n Full history.<\/strong> Conversion services exist that move several years of transaction detail. Genuinely useful for some businesses, and considerably more expensive and error-prone than people expect.<\/p>\n Unless you have a specific reason, take opening balances only. You keep the QuickBooks export as your historical record.<\/p>\n Order matters here.<\/p>\n This is the step that determines whether the migration succeeded.<\/p>\n Enter your trial balance as at the changeover date via Xero’s conversion balances screen. Then enter open items individually:<\/p>\n Then check: does the total of your entered invoices equal the receivables figure on your trial balance? Does the payables total match? Does the balance sheet in Xero agree with the QuickBooks trial balance, line by line?<\/p>\n If it does not tie out, stop and fix it now.<\/strong> Every month you wait makes it harder, and an unexplained difference in opening balances is exactly what an accountant or auditor will find later.<\/p>\n Only after opening balances are agreed. Set each feed to start from the changeover date so you do not import transactions already covered by your opening balances \u2014 duplicating those is the most common post-migration mess.<\/p>\n Confirm the feed connects to your specific bank and stays connected. Xero’s reconciliation experience is its main strength, but only if the feed is reliable.<\/p>\n None of this migrates. Budget time for it:<\/p>\n Rebuild recurring invoices first if you bill on a cycle. Missing a billing run during a migration is an avoidable and embarrassing cash flow problem.<\/p>\n Keep QuickBooks readable \u2014 do not cancel yet. Process one full month in Xero, then compare the numbers against what QuickBooks would have produced.<\/p>\n Check specifically:<\/p>\n Only after a clean month, and after your accountant has looked at it, cancel QuickBooks.<\/p>\n Conversion services can move multiple years of transaction detail, at a cost and with some risk of mismatch. Most small businesses are better served by taking opening balances only and keeping the QuickBooks export as an archive.<\/p>\n The first day of a new financial year. Second best is the start of a VAT or tax quarter. Mid-period switches mean filing a return from data split across two systems.<\/p>\n It stays in QuickBooks unless you pay for a full conversion. Export your reports and invoice records before cancelling \u2014 you are required to retain them, and that obligation is yours, not the vendor’s.<\/p>\n Setup and opening balances take a day or two for a straightforward business. Add rebuilding templates, rules and integrations, plus one month of parallel running before you cancel. Call it six weeks end to end, most of it waiting.<\/p>\n You can do the mechanics yourself. You should still have your accountant agree the opening balances, because those become the foundation of every report and year-end filing afterwards. An error there is expensive later and cheap now.<\/p>\n File any return covering the period before the changeover from QuickBooks. Configure Xero’s tax settings and scheme correctly before the first transaction. If you are in the UK, confirm Making Tax Digital is set up and connected in Xero before your first submission is due.<\/p>\n Pick your changeover date and put it in the calendar, then ask your accountant to review your QuickBooks trial balance as at that date. Everything else follows from those two things.<\/p>\n If you are still choosing rather than committed, our guides to the best accounting software<\/a> and which trials are worth taking<\/a> cover what to test before you commit to a move.<\/p>\n","protected":false},"excerpt":{"rendered":" Payroll and accounting migrations punish bad timing more than bad tooling. The mechanics of moving from QuickBooks to Xero are well trodden and largely solved. What goes wrong is opening balances that do not tie out, VAT periods that straddle two systems, and…<\/p>\n","protected":false},"author":7,"featured_media":90304,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[9],"tags":[75],"class_list":["post-90047","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tutorials","tag-tutorials"],"yoast_head":"\nStep 1: Close Out QuickBooks Properly<\/h2>\n
\n
Step 2: Export Your Reports Before You Need Them<\/h2>\n
\n
Step 3: Decide What Actually Needs to Move<\/h2>\n
Step 4: Set Up Xero Before Importing<\/h2>\n
\n
Step 5: Enter Opening Balances<\/h2>\n
\n
Step 6: Connect Bank Feeds<\/h2>\n
Step 7: Rebuild What Does Not Transfer<\/h2>\n
\n
Step 8: Run Parallel for One Period<\/h2>\n
\n
Common Mistakes to Avoid<\/h2>\n
\n
FAQs<\/h2>\n
Can I transfer all my QuickBooks history to Xero?<\/h3>\n
When is the best time to switch?<\/h3>\n
Will I lose my invoice history?<\/h3>\n
How long does the migration take?<\/h3>\n
Do I need an accountant to do this?<\/h3>\n
What happens to my VAT records?<\/h3>\n
Key Takeaways<\/h2>\n
\n
Next Steps<\/h2>\n