QuickBooks to Xero switch left transactions missing? Rebuild from the last month that ties
A business owner recently described a familiar problem in public: they moved their books from QuickBooks to Xero, used a conversion service, and found months of transactions that had been reconciled in QuickBooks were missing in Xero. The advice that came back, and that others repeated, was simple: go back to the last bank statement that ties out, re-reconcile forward from there, and keep the old QuickBooks file until a full year matches.
That is sound practice, and this guide walks through it step by step. It doesn't depend on how the conversion was done or who did it. The bank statements are the record both systems should agree with, so they are where you start.
Before you change anything: keep the old QuickBooks file
- Don't cancel or delete QuickBooks yet. Intuit says that after you cancel a QuickBooks Online subscription you have read-only access to the data for one year, and you can export it to Excel or to a desktop version of QuickBooks up to a year after you cancel. If you cancel during or at the end of a free trial, the data is available for 90 days. Intuit recommends exporting or printing your data before you cancel (Intuit: what happens to my QuickBooks Online data after I cancel, updated Aug 5, 2026).
- Xero says the same about the old file. Its QuickBooks switch page suggests holding on to your old QuickBooks file, as the IRS sets rules on how long to keep business records (Xero US: switch from QuickBooks to Xero).
- Save what you'll compare against. While you still have full access, export or print, for each bank and card account, the month-end balances and the reconciliation history from QuickBooks. You'll check Xero against these and against the statements.
- Get every statement PDF. Download the bank and card statements for the whole period from online banking, one file per account per month, named by account and period so a missing month is obvious.
1. Find the last month that ties
Do this for one account at a time. A month "ties" when three things agree: the bank statement, Xero, and the transactions behind Xero's figure.
- Start with the statements. For each statement: opening balance + deposits − withdrawals = closing balance, to the cent. Each closing balance must equal the next statement's opening balance. If the statements themselves don't chain, a statement or page is missing; see check a bank statement PDF is complete before you import it.
- Compare Xero to each statement's closing balance. Working back from the most recent month, check Xero's balance for the account on each statement's closing date against that statement's closing balance. Note every month where they differ.
- Check the month's activity, not only the balance. A balance can match by coincidence when a missing item and an extra one cancel out. For the month you think ties, compare Xero's total money in and total money out for the period with the statement's deposit and withdrawal totals.
- The anchor is the last month where all of this holds. Every month after it is suspect, even if a later month seems to match again.
Also check the starting point. In Xero, the conversion date is the date you start recording transactions in Xero and is always the first of a month, and conversion balances are the closing balances in your previous system on the day before the conversion date; for bank accounts you enter their opening balances (Xero Central: Convert to Xero). If the bank account's opening balance in Xero doesn't equal the closing balance on the statement for the day before the conversion date, fix that question first, with whoever looks after the file, because it shifts every month after it.
2. Decide which statement months to rebuild
- Every month after the anchor, up to the most recent statement, for each affected account. If eight months are missing or short, that is eight statement-months per account to rebuild.
- Every account, not only the main checking account: savings, credit cards and any account that was closed during the period. A transfer between two accounts is only right when both sides are in.
- Card statements by their own cycle. Card billing periods don't follow calendar months, so make sure the cycles together cover the whole gap.
- Stop where a bank feed takes over. If a Xero bank feed already brings in the newest months, the rebuilt files should end the day before the first feed line. See importing transactions older than your Xero bank feed.
Before importing anything, decide what happens to the partial lines Xero already holds for those months. Either remove them and import whole months from the statements, or import only the missing lines. Don't do both. If you're not sure, agree it with your accountant or bookkeeper first, since it changes what's already reconciled. The duplicate checks are covered in the same guide.
3. Rebuild forward, one statement at a time
- Turn each statement into a file Xero accepts. For a CSV, Xero needs only Date and Amount to create statement lines, with income and expenses in the same Amount column, income positive and expenses negative. Delete opening and closing balance columns, since Xero calculates the balance from the transactions, plus the account number and any empty rows (Xero Central: import a bank statement in CSV format). Payee, description and reference make reconciling easier.
- Tie out the file before you import it. The file's rows should add up to the statement: opening balance + the file's amounts = closing balance. A file that doesn't tie has a missing, doubled or mis-signed row, and it's far easier to find before it's in Xero.
- Import oldest month first. In Xero, go to Accounting → Bank accounts, open the account's menu and choose Import a Statement. Assign the columns, confirm the date format if asked, review the lines and complete the import (Xero Central).
- Reconcile that month, then check it. After each month, Xero's balance for the account should equal that statement's closing balance. Only then move to the next month.
For the full import walkthrough, see how to import bank statements into Xero from a PDF. If Xero rejects a file or reads dates wrongly, see Xero bank statement import errors.
4. Keep QuickBooks until a full year matches
When the rebuilt months are in and reconciled, compare month-end balances for each account across three sources: the statement, Xero and the old QuickBooks file. Keep QuickBooks, or a full export of it, until twelve consecutive months agree for every account. Keep the tie-out sheets and reconciliation reports with the year's records, so whoever prepares the tax return can see how each month was checked.
Plan this around the read-only window. If you've already cancelled QuickBooks Online, note the date: Intuit gives one year of read-only access and export after you cancel (Intuit).
The same check-every-month routine, with a sample tie-out table, is in how pros do catch-up. Gathering statements a client can't find? See bookkeeping catch-up from PDF statements.
Where LedgerReady fits
Step 3 is the part we do. Send the statement PDFs for the months after your anchor. For each statement-month you get a Xero CSV, a QBO file, a plain CSV and a tie-out sheet showing opening balance + net activity = closing balance, with any difference shown, so you can see each month ties before it goes into Xero. It costs $15 per digital statement-month, or $149 for a 12-month catch-up of one account, and we aim to deliver within 12 hours. Eight months of one account in single months comes to 8 × $15 = $120. Your first statement-month can be free, so you can test us on one of the missing months first. Full prices are on the pricing section. If the output doesn't reconcile to the statement's opening and closing balances and we can't fix it, you don't pay for that statement.
What we don't do
- We are not accountants or CPAs. Nothing here is accounting or tax advice, and the tie-out sheet is not an audit, review or attestation.
- We don't migrate QuickBooks files or company data, and we don't log in to your QuickBooks or Xero. We work only from the statement PDFs you send.
- We don't import into Xero for you, reconcile your Xero file, or decide which existing lines to remove. That stays with you or your bookkeeper.
- We don't fix categories or account coding. Any category in our files is a suggestion for your review.
Xero and QuickBooks details are from the Xero and Intuit pages linked above, as read on 8 Nov 2026. Menus, offers and limits change, so check their current help if something differs.
Skip the manual work
We turn statement PDFs into QBO, Xero and CSV files plus a tie-out sheet. $15 per statement-month, $149 for a 12-month catch-up. Prefer to check it yourself? Our tie-out checker runs in your browser. See how pros do catch-up.
Bank menus change; labels here were accurate to our knowledge in Oct 2026, so check your bank's help pages if something differs.