How-to
How to switch from QuickBooks Online without losing your history
What to export before you cancel, how to pick a cutover date, what goes wrong while you run two systems, and a checklist that proves nothing was lost.
The short answer
Pick a cutover date on the first day of a month. Keep QuickBooks® Online open until your new books match, then export your files and cancel.
QuickBooks is a registered trademark of Intuit Inc. Xero is a trademark of Xero Limited. This comparison is independent and is not sponsored, endorsed, or approved by Intuit or Xero.
On this page
How do you prove nothing was lost?
You prove a QuickBooks Online move lost nothing by comparing the old and new books account by account, as of your cutover date, before you cancel. A trial balance always balances, so matching totals prove very little. Run every report on the accrual basis in both systems. Intuit’s own help says to use accrual when you match aging reports to the balance sheet.
Ten checks prove the move, starting with every account on the trial balance agreeing to the cent.
| Check | Where to find it in QuickBooks Online | It matches when |
|---|---|---|
| 1. Every account on the trial balance | Trial Balance report, ending on your cutover date | Each account agrees to the cent |
| 2. Net income for each year you moved | Profit and Loss report, one full year at a time | Each year agrees, which catches an entry in the wrong year |
| 3. What customers owe, in total and by customer | Accounts receivable aging summary, aged by report date | The total equals A/R on both trial balances, and each customer agrees |
| 4. Each open invoice | Accounts receivable aging detail, same date | Each invoice is open with the same number, date and balance |
| 5. What you owe vendors, bill by bill | Accounts payable aging summary and detail | Same test as steps 3 and 4, for bills |
| 6. Each bank and card balance | Reconcile, History by account, plus your bank statement | Both systems agree with the statement once uncleared items count |
| 7. Uncleared checks and deposits | The reconciliation report for a reconciliation through your cutover date | Each one is open in the new system |
| 8. Payments not yet deposited | The Undeposited Funds account on the trial balance | Each payment waiting there waits in the new system too |
| 9. A few real documents | Five invoices and bills from different years | Each one opens with its lines and its attachment |
| 10. Anything entered after the copy | Audit log, filtered by Date Changed from the day of the copy | Each entry is in the new system. Then run step 1 again |
Each report is under Reports, then Standard reports. Find it by name, set the period to end on your cutover date, and set the method to Accrual. The accounts receivable aging summary sits under Who owes you. Reconciliation history is under All Apps, Accounting, Reconcile. The audit log is under Settings.
Watch step 3. Intuit’s help says the aging report ages from today by default, not from the report date, and that’s usually why it disagrees with the balance sheet. Choose Customize report, then in General options set Aging to Report date, and run it again.
Step 7 needs one thing first. Reconcile each account in QuickBooks through your cutover date, then open that reconciliation’s report and read its uncleared list. Once each item is open in the new system, your first reconciliation there works.
When a number is off, the size of the difference is your best clue. A difference equal to one invoice usually means a missing invoice. A difference in only one year usually means an entry in the wrong year. Our guide to reconciling an account in QuickBooks walks through finding a difference that won’t come to zero.
How much of your QuickBooks Online history can you keep?
That depends on the route. Conversion tools read QuickBooks Online directly and rebuild your transactions in the new system. One of them is Q2X, a QuickBooks Online to Xero™ conversion app in Xero’s App Store, whose base conversion Xero pays for. An export keeps a copy you can read. Here’s how the routes compare, from each vendor’s own page plus what a report export can’t hold, as of October 2026.
Q2X says it moves all your history, and Xero’s free conversion brings your current and prior fiscal year. An Excel export keeps any years you pick, but only as reports you can read.
| Route | What comes over | How far back | What stays behind |
|---|---|---|---|
| Xero’s free conversion (Jet Convert) | Chart of accounts, contacts, and transactions such as invoices and bills | Current and prior fiscal year. More than two years may cost extra | Payroll information |
| Q2X (Xero App Store, US businesses) | Chart of accounts, contacts, invoices, bills, payments, journal entries, tax rates and QBO Payroll | All history, Q2X says | Projects, recurring schedules, bank rules and tax agencies. Files and tracked inventory listed as coming soon |
| QuickBooks Online’s Excel export | Reports and lists, as Excel files in one zip file | The date range you pick | The invoices and payments behind each report, and how they connect |
| Opening balances only | Your balances on the cutover date | None | Every past transaction, which stays in QuickBooks and your exports |
Xero’s free conversion covers two years. That handles recent lookups. It doesn’t cover a question about a return from three years back, or a customer disputing a 2022 invoice. Whatever you don’t move lives in your Excel exports, and only there once read-only access ends.
Payroll is its own move. Xero says payroll information doesn’t come over in its own conversions, while Q2X says it converts QuickBooks Online Payroll. Either way, talk to your payroll provider before you switch. If you’re still choosing where to go, our Xero vs QuickBooks comparison lays out where each one is stronger.
What should you export before you cancel QuickBooks Online, and by when?
Export first and cancel last, once your cutover date has passed and the tie-out above matches. Intuit’s read-only access after you cancel has a deadline, and the IRS asks you to keep most records longer than that. Our guide to exporting everything from QuickBooks Online has every deadline, where each kind of data exports from and what you can still reach after you cancel.
When should you switch from QuickBooks Online?
On the first day of a month. The first day of a quarter is better, and the first day of your fiscal year is best, because then a whole year’s reports come from one system. When you set up a bank account in QuickBooks, Intuit’s help says most businesses start tracking from the beginning of the year, so the books match the bank from the start.
A mid-year date works too, as long as the whole year’s history lands in the new system. Otherwise its year-to-date reports start in the middle.
Then write down two things and send them to everyone who works in your books, your bookkeeper and accountant included. The first is the cutover date. The second is the hour after which nobody enters anything in QuickBooks.
What goes wrong when you run both systems?
Digits’ guide for firms moving books into Digits says most run a parallel close for one accounting period, usually a month. However long you run both, the trouble starts when both systems take the same work.
The bank feed lands in both. When you connect a bank to QuickBooks, Intuit says the bank sends anywhere from 90 days to 24 months of history. A new system’s feed can reach back the same way and repeat lines QuickBooks already holds. Our guide to switching accounting software shows how to set the feed’s start date so nothing lands twice.
The copy goes stale. A conversion like Q2X copies your books once, and Digits says changes made in the old system after the start date won’t sync to Digits. If your bookkeeper enters 30 bills in QuickBooks the next morning, none of them reach the new books unless someone enters them again. The same goes for a 2025 entry someone fixes in QuickBooks after the copy. The two systems now disagree about a year you thought was done, and nothing tells you.
Before the cutover, everything goes into QuickBooks. After it, nothing does. Run the checklist above on the first copy, then again once the last QuickBooks entry has moved over.
How does a switch to Imprest work?
Imprest imports your full QuickBooks Online history, every transaction back to your first, with its attachments. It only reads QuickBooks, so nothing there changes. Until you switch, QuickBooks stays your books. What you enter there syncs over on its own every day or two, or sooner when you press Sync Now.
If someone tries to enter something in Imprest in the meantime, Imprest stops and asks them to record it in QuickBooks, so nothing gets counted twice. Before you switch, it compares every account on QuickBooks’ trial balance with its own as of the last sync, to the cent, and shows you any difference. That covers step 1 of the checklist. Do the other nine yourself. When you’re ready, the switch pulls from QuickBooks one last time and stops syncing for good.
Recurring templates, sales tax rates, bank feeds, payroll records, estimates, purchase orders, past reconciliations and the audit log don’t come over. You set those up fresh and keep QuickBooks read-only for the records that stay there. The steps are on the switching page.
Frequently asked questions
Can I import a QuickBooks Online Excel export into another accounting system?
Your lists, usually yes. Your transactions, only as journal lines at best. The export holds reports like the General Ledger, which show lines and totals but not the invoices and payments behind them or how they connect. To move the documents themselves, you need a conversion tool that reads QuickBooks directly.
How many years of history can I move from QuickBooks Online to Xero?
As of October 2026, Xero’s free conversion through Jet Convert brings your current and prior fiscal year. Xero says moving more than two years of data may cost an extra fee. Q2X, a conversion app in Xero’s App Store, says it moves all your history.
How long should I run QuickBooks and my new system together?
Digits’ guide for firms moving books into Digits says most run a parallel close for one accounting period, usually a month. However long you run both, keep one system as the books on any given day, and compare the two as of your cutover date before you cancel.
When can I cancel QuickBooks Online?
After your cutover date has passed, the tie-out matches, and your exports open on your own computer. Read-only access starts the day you cancel, so canceling later gives you more time, though you keep paying for QuickBooks until then.
Sources
- Intuit, “Cancel your QuickBooks Online subscription or Intuit Enterprise Suite contract” (US), updated October 30, 2026, checked October 31, 2026
- Intuit, “Export reports, lists, and more from QuickBooks Online,” updated August 3, 2026, checked October 30, 2026
- Intuit, “Match your aging reports,” updated August 4, 2026, checked October 30, 2026
- Intuit, “Run an accounts receivable aging report,” updated August 5, 2026, checked October 30, 2026
- Intuit, “Year-end guide for QuickBooks Online,” updated August 21, 2026, checked October 30, 2026
- Intuit, “Undo or remove transactions from reconciliations in QuickBooks Online,” updated August 24, 2026, checked October 30, 2026
- Intuit, “How do I view, print, or export a reconciliation report?”, updated August 5, 2026, checked October 31, 2026
- Intuit, “Use the audit log in QuickBooks Online,” checked October 30, 2026
- IRS, “How long should I keep records?”, updated June 30, 2026, checked October 30, 2026
- Xero, “Convert from QuickBooks” (US), checked October 30, 2026
- Xero App Store, Q2X listing (US), checked October 31, 2026
- Q2X, q2x.app (what converts, history, Xero’s subsidy), checked October 31, 2026
- Intuit, “Enter and manage opening balances in QuickBooks Online,” updated August 25, 2026, checked October 31, 2026
- Intuit, “Connect bank and credit card accounts to QuickBooks Online,” updated October 1, 2026, checked October 31, 2026
- Digits, “Running a Parallel Close,” checked October 31, 2026