How Much Transaction History Should You Migrate to QuickBooks?

Two to three years of detail is the right answer for most businesses — here is how the retention rules, Intuit’s target ceiling, and the true cost of condensing set your number.

What the IRS actually requires — and what it does not

The IRS ties record retention to the period of limitations, not a flat number of years. Its current guidance (reviewed 30 June 2026): keep records 3 years in the ordinary case; 3 years from filing or 2 years from the date you paid the tax, whichever is later, for a credit or refund claim; 7 years for a worthless-securities or bad-debt claim; 6 years if you under-report income by more than 25% of the gross income shown on the return; indefinitely if you filed no return or a fraudulent one; and at least 4 years for employment tax records, from when the tax became due or was paid, whichever is later. Property records run until the period of limitations expires for the year you dispose of the asset, which can outlast every period above.

Notice what none of it says: in your accounting software. A backup of the legacy company file, or saved PDF and Excel exports of the core reports, satisfies retention. Migration is a convenience decision, not a compliance one — which is what lets most businesses move three years instead of eleven.

Intuit’s ceiling: 4,000,000 targets

Moving from QuickBooks Desktop to QuickBooks Online, the volume question has a published limit. Intuit’s migration documentation (updated 21 August 2026) tells you to press F2 or Ctrl+1 in Desktop, open the Product Information window, and confirm your Total Targets count is below 4,000,000. Above that, you must condense before you can proceed.

A target is a line on a transaction, not a transaction: a thirty-line invoice is roughly thirty targets, a two-line bill is two. File size in megabytes is a poor proxy, and an inventory-heavy or job-costed business burns through the count far faster than a service firm at the same revenue. Read the number before you pick the years.

Two deadlines come from the same document. The window to move your data depends on how the QuickBooks Online account was created: 90 calendar days if you signed up yourself, 180 calendar days if your accountant signed up for you. If you run payroll, Intuit advises waiting 2 to 3 business days after a payroll run for the sync, and finishing the migration at least 7 business days before the next scheduled payroll.

On the number you will find elsewhere: many guides still quote a 350,000-target ceiling. It is stale. Verify any threshold against Intuit’s live documentation — including this one, which has moved once already.

Condensing is not free. Here is the bill.

Over the ceiling, the obvious move is to condense and keep every year. Intuit’s own Condense Data documentation explains why that trade is worse than it looks: condensing cannot be undone, and it summarises the condensed period’s detail into journal entries. The listed consequences are specific:

• Item-based reports go blank — Sales and Purchase, Job Costing, and A/R and A/P Aging detail, because the items they draw from are gone.
• Cash-basis reports for the period become inaccurate, since the links from cash in to income and cash out to expenses are severed.
• Class reporting collapses — summarised transactions carry no class, so P&L by Class shows everything unclassified.
• Sales Tax Liability shows zero tax collected, because the invoices that carried it no longer exist.
• Reconciliation reports may be incorrect or missing, though your next reconciliation’s opening balance stays correct, since condensed entries count as cleared.

Accrual P&L, Balance Sheet, Cash Flows and Trial Balance survive, and open transactions are not condensed at all. But the honest framing is that condensing to fit under the ceiling destroys the very detail you were trying to carry over. Near the limit, migrating fewer years cleanly beats migrating more years hollowed out.

The “lists and balances only” option

Intuit’s export flow offers a second path most people click past: instead of Bring all your company data, choose Bring only list and balances — customers, vendors, chart of accounts, employees and items, with balances, no transaction history. It is the fastest, cleanest conversion available, and the right call more often than people expect: a business changing accountants, a file thick with junk, or anyone whose real goal is a clean start on a correct chart of accounts.

How many years, by situation

• Service business, clean books, no inventory — 2 full fiscal years plus the current year to date.
• Inventory or job costing — 2 years of detail at most, and read the target count first. These files hit the ceiling soonest and lose the most to condensing.
• Raising debt, or selling within 24 months — 3 years. Lenders and buyers ask for three years of statements, and a live system beats an archive for that.
• Open audit, litigation, or an NOL carryforward — migrate 3 years and never retire the legacy file. The archive is the record.
• Leaving a non-QuickBooks system (Sage, NetSuite, Xero, FreshBooks) — 1 to 2 years. Cross-platform history is the expensive part, and mapping risk rises with every extra year.

Keep the old years reachable without migrating them

Four steps before cutover. Back up the legacy file to two places. Export the full-history core reports — P&L, Balance Sheet, Trial Balance, GL detail, A/R and A/P Aging, Sales Tax Liability — to PDF and Excel, one per fiscal year, with every reconciliation report alongside. Keep one machine or hosted seat able to open the old file read-only for as long as the longest retention period runs, and write down where it all lives. An afternoon’s work that replaces years you would otherwise drag through the migration. Our conversion mistakes guide covers the rest of the pre-flight list; how long a conversion takes explains why target count, not years, sets the clock.

The bottom line

Migrate the history you will use, retain the rest properly, and let the archive do the archive’s job. Two to three years of detail plus accurate opening balances gives almost every small business correct balances, real comparatives, and a file that converts cleanly the first time. High target counts, deep inventory, or a non-QuickBooks source is where a scoped fixed-fee conversion pays for itself; the Desktop-to-Online walkthrough covers the mechanics once scope is settled.