QuickBooks condense data error on a big file: fix or split

Why does Condense Data fail or stall?

Damage in the file. Intuit lists running file utilities (verify, rebuild or condense) among the causes of an unrecoverable error.
Transactions it can’t remove. Open transactions, unlinked invoices, payments and bills, payments still in Undeposited Funds, and sales tax not paid through Pay Sales Tax all stay.
Payroll it must keep. Payroll for an employee whose W-2 hasn’t been reviewed stays in the file.
Too little to remove. Intuit says Condense won’t be available if there’s no significant change to file size.

On Intuit’s community forum, a QuickBooks 2020 Enterprise user reported a condense on a 450 MB file that ran more than 36 hours, then failed with an unrecoverable error.

How do you get a stuck condense to finish?

A condense can’t be undone, so every step runs on a copy. Intuit’s steps cover Pro and Premier 2012 and newer, and Enterprise 12.0 and newer.

1. Back up the file. Go to File > Switch to Single-user Mode, then File > Back up Company > Create Local Backup. Select Local Backup, then Next. Select Browse to pick a folder, then OK, then Save it now and Next.

2. Restore it as a copy. Go to File > Open or Restore Company > Restore a backup copy > Next > Local Backup > Next. Pick the .qbb file, choose a new folder and a new file name, and select Save.

3. Verify, then rebuild. On the copy, go to File > Utilities > Verify Data. If it finds a problem, select Rebuild Now, then verify again. For errors that remain, select Expand All in the Verify Results window and See Online Article for each. Intuit says to contact support if the first rebuild took 2+ hours.

4. Reconcile and save the reports. Reconcile all accounts and save the reconciliation and discrepancy reports as PDFs, since a condense can wipe them.

5. Save the item history you use. Item-based reports for the condensed years go blank, including sales and purchase, job costing, and A/R and A/P aging. Save the ones you still quote from.

6. Pick the date. Closed transactions before it are removed and summarized. If you track inventory, use the last day of a monthly reporting period.

7. Preview what can’t be removed. Go to File > Utilities > Condense Data and select Yes if asked about budget data. Select Remove the transactions you select from your company file, then Next. Select Transactions before a specific date, enter the date, and select Create a report showing which transactions cannot be removed. This removes nothing. Link the stray payments, deposit what’s in Undeposited Funds, and clear the other items on the report.

8. Run the condense. Close every transaction window and stay in single-user mode. Repeat step 7 without the report option, then:

Choose a summary option and select Next (use Help Me Choose if unsure).
Choose how inventory is condensed and select Next.
Clear any recommended removals you want to keep, and select Next.
Clear any unused list entries you want to keep, select Next, then Begin Condense.

QuickBooks saves an archive copy of the file in its original folder before it starts.

If the file has a lot of edited, voided or deleted transactions, Keep all transactions, but remove audit trail info to date keeps every transaction and trims only the audit trail.

How do you check the condense worked?

Compare the totals. Run the accrual Balance Sheet and Profit and Loss for the condensed years in the original and the copy. Account-based reports stay accurate, so the totals should match.
Run Verify Data again on the condensed copy.
Check the size. Press F2 or Ctrl+1 and compare Total Targets and List Information with the original.
Know what changed. Cash-basis reports for the condensed years are inaccurate, class reports show the summaries as unclassified, and sales tax liability reports lose taxable and nontaxable detail.
Find the condensed receivables. A/R Collections shows them under “No Name,” and A/R Aging hides them until you remove the default Names filter.

Then make the condensed copy your working file and keep the original untouched.

When should you split the file or start fresh instead?

The condense fails on a copy that verifies clean.
You’d lose item history you still sell from.
Your lists are full. Pro and Premier allow 14,500 items and 14,500 names in total; Enterprise allows more than 100,000 of each. Check under List Information with F2 or Ctrl+1.

In Enterprise or an Accountant edition: go to File > New Company from Existing Company File, select Browse, open the old file, name the new one, and select Create Company. Intuit says it copies “your preferences, sales tax items, memorized reports, and chart of accounts.” Bank and credit card accounts, your EIN and payroll aren’t copied.

In any edition: back up and restore the file under a new name in its own folder, as in steps 1 and 2. In the copy, go to File > Utilities > Condense Data, select All Transactions, then Next, and follow the prompts. Then go to Reports > Reports Center, open Transaction List by Date, and start the dates before your oldest transaction. The list should be empty.

Either way, set opening balances with your accountant and re-enter the open invoices, bills and orders.

Keep the old file where you can open it: the IRS says to keep records for 3 years in most cases, and employment tax records for at least 4 years after the tax is due or paid, whichever is later.

If you’re leaving Desktop anyway, QuickBooks Online imports files of up to 5,000,000 targets, or you can move only lists and balances. Check your file with the Desktop to Online readiness checker, and see what distributors lose moving from Enterprise to Online.

What are your options?

Option	Good for	Watch for
Condense a copy yourself	Files that verify clean, with old years you no longer report on	No undo; item reports for those years go blank
Start a new file from the old one	Files that won’t condense, or lists near the limit	Opening balances and open items entered by hand
Move to QuickBooks Online with lists and balances	Owners already planning to leave Desktop (support dates for Desktop 2024)	Features distributors use that Online lacks
Hire a file repair service	Damage that Rebuild Data can’t fix	Who holds your file, and checking balances after
Bring in an outside team (Cleanups & bulk changes)	Splitting a large file and checking every balance	Needs a copy of the file and time with your bookkeeper

FAQ

Can I undo a condense in QuickBooks Desktop? No. Intuit says “Once you condense your company file, it can’t be undone,” so restore your backup or the archive copy instead.

Does Condense Data work in QuickBooks Desktop Enterprise? Yes. Intuit’s steps apply to Enterprise 12.0 and newer.

Why is Condense Data grayed out or unavailable? Intuit says Condense won’t be available if it wouldn’t change the file size significantly.

Will my Balance Sheet change after a condense? It shouldn’t. Account-based reports stay accurate, so compare totals with the original to confirm.