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.

9 min readPublished November 1, 2026

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
  1. How do you prove nothing was lost?
  2. How much history can you keep?
  3. What to export, and by when
  4. When should you switch?
  5. What goes wrong running both?
  6. How a switch to Imprest works

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.

Ten checks that prove a QuickBooks Online move lost nothing, with where to find each number and when it matches, as of October 2026
CheckWhere to find it in QuickBooks OnlineIt matches when
1. Every account on the trial balanceTrial Balance report, ending on your cutover dateEach account agrees to the cent
2. Net income for each year you movedProfit and Loss report, one full year at a timeEach year agrees, which catches an entry in the wrong year
3. What customers owe, in total and by customerAccounts receivable aging summary, aged by report dateThe total equals A/R on both trial balances, and each customer agrees
4. Each open invoiceAccounts receivable aging detail, same dateEach invoice is open with the same number, date and balance
5. What you owe vendors, bill by billAccounts payable aging summary and detailSame test as steps 3 and 4, for bills
6. Each bank and card balanceReconcile, History by account, plus your bank statementBoth systems agree with the statement once uncleared items count
7. Uncleared checks and depositsThe reconciliation report for a reconciliation through your cutover dateEach one is open in the new system
8. Payments not yet depositedThe Undeposited Funds account on the trial balanceEach payment waiting there waits in the new system too
9. A few real documentsFive invoices and bills from different yearsEach one opens with its lines and its attachment
10. Anything entered after the copyAudit log, filtered by Date Changed from the day of the copyEach 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.

Ways to keep your QuickBooks Online history, compared by what comes over, how far back it goes and what stays behind, as of October 2026
RouteWhat comes overHow far backWhat stays behind
Xero’s free conversion (Jet Convert)Chart of accounts, contacts, and transactions such as invoices and billsCurrent and prior fiscal year. More than two years may cost extraPayroll information
Q2X (Xero App Store, US businesses)Chart of accounts, contacts, invoices, bills, payments, journal entries, tax rates and QBO PayrollAll history, Q2X saysProjects, recurring schedules, bank rules and tax agencies. Files and tracked inventory listed as coming soon
QuickBooks Online’s Excel exportReports and lists, as Excel files in one zip fileThe date range you pickThe invoices and payments behind each report, and how they connect
Opening balances onlyYour balances on the cutover dateNoneEvery 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.