Bringing years of history into QuickBooks: what to keep, what to summarise

Every QuickBooks migration reaches the same fork: how much history do you actually bring across? It feels like a data question, but it’s really a judgement call about value versus risk — and getting it wrong in either direction costs you. Bring too much and you inherit years of someone else’s mess in a bloated file; bring too little and you lose the reporting continuity the client expected.

The three approaches

1. Opening balances only

You carry account balances as of the cutover date and start clean. Fastest, lowest risk, smallest file. The cost: no transaction-level history in QuickBooks — prior years live only in the old system or in reports you keep on file.

2. Opening balances plus summarised history

You bring opening balances, and add summarised monthly journal entries for the profit-and-loss history you want — one entry per month, per account, capturing the totals. You get trend reporting and year-over-year comparisons without importing thousands of individual transactions. This is the sweet spot for most migrations.

3. Full transaction detail

You bring every historical invoice, bill, payment and journal. You get complete drill-down history — and a larger, slower file, plus far more places for the migration to go wrong. Reserve this for cases where the detail is genuinely needed (audit, litigation, a business that reports at transaction level).

What history actually costs you

• File size and performance grow with every transaction, especially in Desktop.
• Reconciliation effort multiplies — every year of detail is another year to tie out.
• Error surface expands: more rows means more chances for a duplicate, a skipped line, or a mis-mapped account.
• Inherited mess — importing years of a messy source file just moves the mess into a fresh system.

How to bring summarised history

1. Pull a monthly profit-and-loss (and, if needed, balance-sheet movement) from the source for each historical period.
2. Create one journal entry per month that posts those totals to the matching QuickBooks accounts.
3. Confirm each period’s journal ties to the source report for that month.

This gives clean historical reporting in QuickBooks with a tiny fraction of the rows — and almost none of the error risk of full detail.

How to bring full detail (if you must)

1. Import lists first — chart of accounts, names, items — so every transaction has something to reference.
2. Import transactions in order, oldest to newest.
3. Reconcile each period to the source as you go, rather than discovering a years-old gap at the end.