Why Inventory Does Not Match After a QuickBooks Migration

Inventory rarely migrates cleanly from QuickBooks Desktop to Online. The four usual causes are a different costing method between the two systems, items that arrived as non-inventory, quantities rebuilt rather than transferred, and a starting value entered at the wrong cost. The Inventory Valuation Summary in both systems is the report that tells them apart — the trial balance only tells you a gap exists.

Why is inventory the account that always breaks?

Because inventory is not a stored number. It is a calculation.

Cash is a balance: $4,151.74 in Desktop is $4,151.74 in Online. Inventory value is the product of quantities, costs, and a costing method, recalculated by whichever system is holding it. Change any one of those three inputs and the value changes, even when every transaction migrated perfectly.

What are the four causes, and how do I tell them apart?

Cause	Tell-tale sign	Where to look
Costing method differs	Quantities match, values do not	Inventory Valuation Summary, both systems
Items arrived as non-inventory	Item exists but has no quantity on hand	Products and Services list in Online
Quantities rebuilt from a start date	Value is right going forward, wrong historically	The FIFO or costing start date in Online
Starting value entered wrong	One or two items are badly out, the rest fine	Edit item, Starting Value

The first column of that table is the whole diagnostic. If quantities agree and values do not, it is a costing question. If quantities are zero, the item did not come across as an inventory item at all.

Does the costing method actually differ?

Sometimes, and this is worth checking rather than assuming. QuickBooks Online has historically used FIFO, and now also offers Moving Average Cost. QuickBooks Desktop supports average cost, and Enterprise adds more options.

If your Desktop file used average cost and the Online file is calculating FIFO, values will differ on every item that had more than one purchase at more than one price — which is most of them. Nothing is broken; the two systems are answering a different question.

What matters is that you know which method the new file is using, and that your accountant knows too, because it changes cost of goods sold going forward.

Why is cost of goods sold wrong as well?

Because COGS and inventory value are two halves of the same calculation. If the value of what you sold was computed differently, the expense side moves with it.

A common post-migration report is that quantity left inventory correctly but the dollar value stayed put and never reached COGS. That shows up as inventory too high and COGS too low by the same amount — which is a useful signature, because the two errors are equal and opposite.

What is the fastest way to find the specific item?

Compare the Inventory Valuation Summary from both systems side by side. It lists every item with quantity on hand and asset value, so a mismatch narrows from "inventory is off by $225" to "this one item is off by $225" in a single pass.

The trial balance can only ever tell you the control account disagrees. It has no knowledge of items, which is why starting there and stopping there leaves you nowhere.

What the numbers usually look like

Inventory variances are rarely round. In a test migration we ran, inventory came across $225.00 light on a $3,200.00 balance — a 7% difference that is far too small to notice on a balance sheet and far too large to ignore once found.

The offsetting entry appeared in Opening Balance Equity at $208.83, which is not the same number. That gap matters: the two figures differ because more than one thing moved. Assuming a single cause because you found a single offset is how the second problem gets missed.

Two export details that distort the comparison itself: QuickBooks Desktop CSV exports stop at 32,770 rows, and Excel exports carry full float precision, so a value shown as 129,191.99 is stored as 129191.98999999999. Truncating instead of rounding costs a cent on nearly every line — which then looks like a real variance.

Quick reference

Question	Answer
Is an inventory variance normal?	Common, but never ignorable
Which report settles it?	Inventory Valuation Summary, both systems
Do quantities matching rule out a problem?	No — values can still differ by costing method
Does a zero quantity mean it failed?	Usually the item arrived as non-inventory
Should I adjust to force a match?	Not until you know which of the four causes it is

The free check compares your trial balances and flags the inventory control account with the amount and the likely cause, so you know which of the four to chase.