Switching QuickBooks Enterprise from Average Cost to FIFO Without Distorting COGS

Changing your Enterprise file to FIFO costing restates inventory value and COGS; here is how our engineers run the switch without distorting either.

QuickBooks Desktop Enterprise can move an inventory company from average cost to FIFO, and the file will reprice every layer it holds. That repricing touches the Inventory Asset account and cost of goods sold on everything already sold. Done in a hurry, it moves your margins with no transaction behind the move. This is how our engineers run the switch: entry frozen, the change rehearsed in a restored copy, and sign-off before the live file moves.

When should you make the switch?

Pick a clean boundary, usually the day after a month or quarter closes, with every bill, invoice, and adjustment for that period entered. A restatement is far easier to defend when it starts from closed books. Avoid mid-period changes; reports pulled later will straddle two costing methods with no note to explain the seam.

Three conditions gate the timing. FIFO is available only in Enterprise editions that include Advanced Inventory, so confirm your licence includes it. Plan the change as one-way; the file will not let you flip back to average cost afterwards. And the inventory must be clean before you touch costing, which is the next phase.

Clean the inventory before you freeze anything

Negative quantity on hand poisons both costing methods, and a FIFO conversion run over negative layers produces costs nobody can audit. Run an inventory valuation report grouped by item and fix any negatives before anything else; our QuickBooks negative quantity on hand repair covers the stubborn cases. Then run Verify on the file and let Rebuild finish if it reports errors. A file that cannot pass Verify should not be asked to restate itself.

Freeze the file at the moment of change

Schedule a window when nobody needs the file, ideally outside business hours. Every user logs out, including remotes and anyone who leaves a session open overnight. Switch to single-user mode, logged in as the admin, and pause everything that writes silently: web connector syncs, third-party integrations, bank feeds, scheduled reports.

Save your baseline reports outside the file: the Inventory Valuation Summary, the standard balance sheet, and cost of goods sold by item for the trailing quarter. Then take a full backup with verification and store it away from the working folder. That backup is your first rollback point. Nothing that follows touches the live file.

Rehearse the switch in a restored copy

Restore that backup to a separate test file, never over the live original. Open it and confirm it matches: same item counts, same valuation total, same Inventory Asset balance as your baseline. The costing setting lives in the Items and Inventory company preferences. Choose the change there and read the warning the file gives you. Let the recalculation run to completion without interruption. On a large item list the repricing takes real time, so do not cancel it halfway.

Measure the restatement and get it signed off

In the test copy, rerun the baseline reports. Quantities on hand must be identical after the switch; only unit costs should move. Items you held longest, or bought through sharp price swings, will show the widest gaps between average and FIFO value. Write the total difference down. That number is the restatement your accountant must approve.

A costing change is a change in accounting policy, not a rounding artifact. Your accountant decides how the restatement is disclosed, whether prior-period reports are reissued, and whether the timing suits the tax position. If reviewers or lenders read these books, agree with them on the period in which reported inventory moves. Get the approval in writing against the test numbers. Our notes on working papers and the month-end close cover what a valuation change does to a set of books.

Cut over the live file

With sign-off in hand, repeat the freeze exactly: users out, single-user mode, background syncs paused. Take a fresh full backup immediately before the change and store it beside the first. This second backup is the rollback point for the live file. If the live result differs from the rehearsal in any way you cannot explain, restore it and stop; the test copy already told you what the numbers should be.

Run the same switch, expect the same restatement you measured, then run Verify on the finished file. Bring the users back only after the checks below pass.

Signs the switch went cleanly

A clean switch leaves quantities untouched and unit values restated. The Inventory Asset balance ties to the Inventory Valuation Summary to the cent, on both accrual and cash views of the balance sheet. The live restatement matches the rehearsal within rounding. Verify passes with no errors. You hold the before and after reports, the written sign-off, and two dated backups kept as the audit trail. Multi-user mode is back on, and your margins finally mean what they say.

Keep going

Your Desktop doesn’t have to end when Intuit says so.

Start with the master survival guide, or jump straight to the fix you need.