Xero Migration Checklist for US Businesses | Logiframe US

Written by Wienanto Tanuwidjaja | Aug 11, 2026, 2:52:12 AM

Before anything

Decide These First

Four decisions shape everything after them, and all four are expensive to revisit once data is loaded.

The conversion date. The date after which Xero is the record and the old system is not. A period start is far easier than a mid-period date, because a mid-year conversion also requires year-to-date profit and loss balances rather than just a balance sheet.
How much history to bring. Balances only, or transaction detail, and for how long. More history is not automatically better; it is more to verify.
The chart of accounts. Migration is the one cheap moment to fix a chart that grew by accident. After go-live, changes mean restating comparatives.
What belongs in tracking rather than in accounts. Department, location, fund and service line go in tracking categories, not in a proliferation of accounts. Xero gives you two tracking categories, so choose them deliberately.

The reasoning behind each of these is set out in Setup & Migration . This page assumes they are settled and covers the execution.

The sequence

The Checklist

Six phases. Each has a check that proves it is done, because “imported” is not the same as “correct”.

Phase 1: Close the old system properly

Task	Done when
Reconcile every bank, card and processor account up to the conversion date	Each one agrees to a statement, with outstanding items listed individually
Tie aged receivables and aged payables to their control accounts	Subledger and balance sheet agree to the cent
Clear or explain suspense, rounding and clearing accounts	Zero, or every item named with a reason
Run and save the final trial balance, balance sheet, aged AR and aged AP	Saved as PDFs outside the old system, dated the conversion date
Lock the period in the old system	Nobody can post into it after you start

This phase is the one most often skipped and it is the one that matters most. Migrating an unreconciled file carries the problem into Xero and adds a conversion date to it. If the old file does not reconcile, stop and fix that first.

Phase 2: Build the Xero organisation

Task	Done when
Set organisation details, financial year end, time zone and base currency	Financial settings match your actual fiscal year, not the default
Build or import the chart of accounts	Every account has the right type, and account types drive where things land on the reports
Set up tax rates and sales tax settings	Rates match what you actually charge and collect
Create the two tracking categories and their options	Named for the two dimensions you decided on, not for everything you might want
Add users at the right permission level	Nobody has more access than their role needs
Set up inventory items, if Xero will own inventory	Each tracked item has its inventory asset, COGS and sales accounts attached

Phase 3: Load balances and open items

Task	Done when
Enter conversion balances from the final trial balance	Total debits equal total credits and the adjustments line is zero
Enter outstanding customer invoices individually	The list matches the saved aged receivables report, invoice by invoice
Enter outstanding supplier bills individually	The list matches the saved aged payables report, bill by bill
Enter inventory opening quantities and average costs	Total value agrees with the inventory figure on the trial balance
Import transaction history, if you decided to bring it	Spot-checked against the old system, not assumed

Receivables and payables go in as individual open items, not as a single balance. A lump sum reconciles to nothing, cannot be chased, and cannot be matched when the customer pays.

Phase 4: Connect everything

Task	Done when
Connect bank and credit card feeds	Feeds deliver from the conversion date, with no gap and no duplicate period
Connect payment processors and e-commerce channels	Each channel posts through its own clearing account, not straight to revenue
Connect document capture	A test bill arrives, is coded, and lands where you expect
Connect payroll	A test run posts to the correct accounts, with liabilities landing where they should
Rebuild bank rules and repeating transactions	Recurring invoices, bills and journals exist in Xero, not just in the old system

Phase 5: Verify before anyone relies on it

This is the phase that separates a migration from a data transfer. It is covered in full in the next section.

Phase 6: Go live

Task	Done when
Run the first period in Xero and close it properly	The close completes and the balance sheet substantiates
Set the lock date on conversion balances	Nobody can quietly adjust the opening position later
Keep the old system readable but not writable	Access retained for reference, posting disabled
Tell your CPA the conversion date and send the final reports from the old system	They have the bridge between the two files before year end, not during it

The part people skip

How to Know It Worked

Seven checks. Run all of them before anyone makes a decision from the new file.

The trial balance matches. Xero’s balance sheet at the conversion date equals the saved trial balance from the old system, line by line.
The adjustments line is zero. Any figure there is a difference Xero absorbed for you, and it will sit in the books from day one.
Aged receivables ties, and so does the detail. Not just the total. The same customers, the same invoices, the same dates.
Aged payables ties the same way.
Inventory value agrees with both the old system and the trial balance figure.
Bank feeds start exactly at the conversion date. The two most common outcomes are a gap, which loses transactions, and an overlap, which duplicates them.
A test transaction of each type posts correctly. An invoice, a bill, a payment, a payroll run. Follow each one to the balance sheet.

Run the first close before you trust it

The real verification is completing one month-end in Xero. Everything that was configured wrongly surfaces during a close, because a close is the only process that touches every part of the file. Discovering it then is cheap. Discovering it in month four is not.

The failure modes

Where Migrations Go Wrong

Migrating a file that does not reconcile. The most expensive mistake available. The problem arrives in Xero unchanged, and now there is a conversion date sitting in the middle of it, which makes the clean-up harder rather than easier.
Conversion balances that do not balance. Xero will plug the difference into an adjustments figure. The file looks complete and carries an unexplained amount forever.
Receivables and payables entered as totals. Nothing to match a payment against, no aging that means anything, and no way to chase.
A bank feed gap or overlap. Either transactions are missing from the first weeks or they are counted twice. Both show up as a reconciliation that will not agree, usually a month later.
Recreating the old chart of accounts exactly. Migration is the cheapest moment to fix a chart of accounts. Copying the mess across means living with it for years.
Nobody owns it. A migration with no single named owner stalls between the bookkeeper who assumes the accountant is handling it and the accountant who assumes the opposite.
Going live mid-period for convenience. A mid-period conversion requires year-to-date profit and loss balances as well as a balance sheet, and every comparative report is split across two systems for the rest of the year.

A special case

Moving Payroll

Payroll migration follows different rules from the rest of the file, and mid-year moves carry real complexity.

Payroll is cumulative. Year-to-date gross, taxes withheld and employer contributions all have to carry across correctly or your filings and W-2s will not agree. That makes the tidy moments a quarter boundary or, best of all, the start of a calendar year.

Since August 2026, Xero Payroll powered by Gusto runs inside Xero, covering federal, state and local tax calculations and filings, direct deposit and contractor payments. If payroll currently sits in a separate system, moving it is worth pricing, though not necessarily at the same time as the accounting migration. Two changes at once doubles what can go wrong in a period where you also need to close the books.

Prefer a quarter or year boundary so year-to-date figures start clean.
Reconcile payroll liabilities before you move , because a liability account that does not clear in the old system will not clear in the new one either.
Run one cycle in parallel if you can , and compare gross, net and every tax line.

Timing

How Long It Takes

The import is hours. The migration is weeks, and most of that is attention rather than effort.

A clean, simple file with balances only, a handful of accounts and one bank account can be built, loaded and verified in a few days of concentrated work.
A typical small business with several accounts, integrations, inventory or payroll should plan on two to four weeks from decision to first close, spread across other work.
A file that needs cleaning first is two projects. Do the clean-up as its own piece with its own scope, then migrate. Combining them means neither finishes cleanly.

The calendar matters more than the hours. Aim to go live at a period start, and avoid running a migration through a month you also need to close under pressure.

Questions

Commonly Asked

How do I migrate from QuickBooks to Xero?

In six phases: close and reconcile the old system to a conversion date and save the final reports; build the Xero organisation with financial settings, chart of accounts, tax rates, tracking categories and users; load conversion balances plus outstanding invoices and bills as individual items; connect bank feeds, integrations and payroll; verify against the saved reports; then run and close the first period. Migration tooling handles the data movement. The decisions and the verification are the work.

What should I check after migrating to Xero?

That the balance sheet at the conversion date matches the old system's final trial balance line by line, that the conversion balances adjustments line is zero, that aged receivables and payables tie in detail rather than just in total, that inventory value agrees, that bank feeds start exactly at the conversion date with no gap or overlap, and that a test invoice, bill, payment and payroll run each post correctly. Then complete one month-end close, which is what surfaces anything configured wrongly.

What conversion date should I choose?

A period start, ideally the start of a financial year. A mid-period conversion requires year-to-date profit and loss balances as well as a balance sheet, and leaves comparative reporting split across two systems for the rest of the year. The convenience of starting immediately is usually outweighed by a year of awkward reports.

Should I bring transaction history into Xero?

Only as much as you will use. Balances alone are sufficient for a clean start and are far quicker to verify. History is useful for comparative reporting and for answering questions about prior periods, but everything you import is something you should check, and unchecked history is worse than none because it looks authoritative.

How long does a Xero migration take?

A simple file with balances only can be built and verified in a few days. A typical small business with several accounts, integrations, inventory or payroll should plan two to four weeks from decision to first close. A file that needs cleaning up first is two projects, and combining them means neither finishes properly.

Can I migrate if my books are behind?

You can, and you should not. An unreconciled file arrives in Xero unchanged, with a conversion date now sitting in the middle of the problem, which makes the eventual clean-up harder. Fix the reconciliation first, in the system where the history already sits, then migrate a file you can verify.

View full post