QuickBooks Enterprise Won't Condense Advanced Inventory FIFO Files
Advanced Inventory files on FIFO costing resist Enterprise's built-in Condense Data tool. We show how to confirm the cause and still shrink the file.
A busy QuickBooks Enterprise file grows year after year, and the built-in Condense Data utility exists to give that space back. It works, right up to the moment the company combines Advanced Inventory with FIFO costing. Then the wizard stops short. Here we show how to confirm that FIFO is the blocker, and which routes can still shrink the file.
Is FIFO costing really the blocker?
Check the setting first. Open Edit > Preferences > Items & Inventory, go to the Company Preferences tab, and open the Advanced Inventory settings. If the inventory costing method reads FIFO, the file sits on the one combination the condense tool will not process. Advanced Inventory on average costing condenses normally. FIFO is what stops it.
Preferences alone do not prove the refusal. The cheapest proof is a condense attempt on a throwaway copy, with the file size watched before and after.
Before any condense attempt, on a copy or otherwise:
- Run Verify Data (File > Utilities > Verify Data). A file that fails cannot be condensed by any method until the damage is repaired.
- Work in single-user mode with every other workstation signed out, and log in as the Admin.
- Take a full local backup and store it away from the live file.
Then run the test:
- Choose File > Back Up Company > Create Local Backup and let it finish.
- Restore that backup into a separate folder under a different file name.
- Open the test company, press F2, and note the file size and list counts on the Product Information window.
- Switch the test file to single-user mode and choose File > Utilities > Condense Data.
- Ask the wizard to remove closed transactions before a cutoff date a few years back, then let it run to the end.
- Press F2 again and compare the numbers.
Two outcomes confirm the blocker. The wizard may stop before the options screen and report that this file cannot be condensed. Or it may report success while the file ends within a few percent of its starting size, with every transaction count unchanged. Both results, on a FIFO file with Advanced Inventory, point to the same exclusion. A genuine condense leaves the file clearly smaller and the old transactions summarized.
The condense tool's problem with FIFO layers
The built-in utility condenses by deleting closed transactions and writing summary journal entries in their place. FIFO costing cannot survive that shortcut. An item's value under FIFO depends on the exact cost and order of every purchase and every build that fed it. Collapse those transactions into journal lines and the cost layers lose their basis, so item valuations and cost of goods sold drift away from the inventory reports.
The exclusion is therefore deliberate. Intuit's condense leaves Advanced Inventory files on FIFO costing out of detail removal, while the same file on average costing goes through. Switching the company back to average costing is not an escape either: once transactions have been costed under FIFO, the method is locked. The setting that caused the problem cannot be undone from inside the program.
Routes that still shrink the file
A condense service built for this combination works past the exclusion. Our engineers summarize the closed years, then rebuild inventory valuation for the FIFO items and assemblies, so quantities and the Inventory Asset balance land where they should. In our experience the file typically comes out 40 to 80 percent smaller, depending on how many years are removed. Everything after the cutoff keeps full detail; earlier transactions become summary entries that preserve every account balance. Our QuickBooks SuperCondense service handles this combination.
If the file only needs to be smaller rather than shorter, removing the audit trail is a lighter option. It clears the record of deleted and voided transactions without touching costing or item history at all. Our audit trail removal service covers it.
Files headed for QuickBooks Online face a second wall: the 14,500 list name limit. Condensing removes transactions, not list entries, so a file crowded with inactive items, customers, or vendors stays over the line no matter how far back it is condensed. A preparation pass that trims transactions and lists together is the safer route; our QuickBooks Online file preparation service covers it.
Where this workaround stops
No route applies to a file that fails Verify Data. Damage comes first and condense second; condensing a damaged file tends to spread the damage through the summaries. If the test copy will not verify, stop and have the file repaired before anything else touches it.
A file that refuses to condense is not a file you have to keep living with. The exclusion blocks one built-in tool. It does not block every route out.