Inventory Valuation Summary Doesn't Match Balance Sheet: Fix
No account needed for your first conversions. We never store your bank login.
Your Inventory Valuation Summary and your balance sheet disagree for one of three reasons: transactions were posted straight to the Inventory Asset account without using an inventory item, inventory items with quantity on hand were made inactive, or the two reports are not being run on the same date and basis. The balance sheet includes inactive items and item-less postings. The valuation report does not. Find the gap in the Transaction Detail report's No Item section and the difference usually explains itself in a few minutes.
This is one of the most common month-end stalls in a product business, and it is almost never a QuickBooks bug. The two reports read different data. The balance sheet reports the general ledger balance of the Inventory Asset account, built from whatever hit that account. The Inventory Valuation Summary reports quantity on hand multiplied by cost, built from the item records. Anything that changes one without changing the other opens a gap.
| Cause | What it does | Where to look |
|---|---|---|
| Bill, check or card charge coded to Inventory Asset on the Expenses tab | Raises the GL balance, no item quantity created | No Item section of the Transaction Detail report |
| Journal entry to Inventory Asset | Same. Journal entries cannot carry inventory items | No Item section |
| Inventory adjustment offset to Inventory Asset instead of COGS | Nets itself out of the GL, quantity still moves | Inventory adjustment list |
| Inactive item with quantity on hand | Still in the balance sheet, dropped from the valuation report | Item list with Include inactive turned on |
| Reports run on different dates | Any activity between the two dates shows as a difference | Report header dates |
| Reports run on different bases | Cash basis balance sheet reports inventory differently | Report basis in Customize Report |
Why doesn't my Inventory Valuation Summary match the balance sheet?
Because the two reports are built from different records. The balance sheet reports the general ledger balance of the Inventory Asset account, so it includes anything posted to that account by any means. The Inventory Valuation Summary is built from the item list, so it only counts quantity on hand times cost for active inventory items. A transaction that touches the account without touching an item appears in one report and not the other, and the difference is exactly that transaction.
Start by ruling out the trivial causes. Confirm both reports carry the same as-of date, then confirm the balance sheet is running on the same basis you intend to compare. Two reports run a week apart in a busy month will differ for perfectly good reasons and send you hunting for a problem that does not exist.
Do inactive inventory items cause the difference?
Yes, and this is the cause people miss most often. Intuit is explicit about it: the balance sheet displays both active and inactive inventory, while the Inventory Valuation Summary displays only active inventory items. An item made inactive while it still had quantity on hand keeps its value in the Inventory Asset account but vanishes from the valuation report, so the balance sheet reads higher by exactly that item's value.
To check, open the item list and turn on Include inactive, then look for anything with a number in the On Hand column. Discontinued products are the usual suspects. Somebody cleaned up the item list at year end without first zeroing the quantities.
What is the No Item section on the Transaction Detail report?
It is where QuickBooks puts every posting to the Inventory Asset account that carries no inventory item, which makes it the fastest way to find the difference. Double click the Inventory Asset figure on your balance sheet to open the Transaction by Account detail, then set Total By to Item Detail. Postings without an item collect under a heading called No Item, and that group is normally the whole discrepancy.
Read the list rather than fixing it row by row. A pattern usually emerges: one person coding vendor bills to Inventory Asset on the Expenses tab instead of entering the items, or a recurring journal entry somebody set up years ago to true up a number.
How do I find the exact transactions causing the difference?
- Fix the dates first. Run the balance sheet and the Inventory Valuation Summary as of the same date, and note the two Inventory Asset figures and the difference between them.
- Check the report basis. Set the balance sheet to accrual in Customize Report, then re-run it. If the difference disappears, basis was your whole problem.
- Open the detail. Double click the Inventory Asset amount on the balance sheet to open the Transaction by Account detail report, and set the date range to All.
- Group by item. In the Total By dropdown choose Item Detail. Everything posted without an inventory item collects under No Item.
- Total the No Item group. Compare that subtotal to the difference you noted in step one. In most files they match, and you now have the exact list of transactions to correct.
- Check inactive items. If a gap remains, open the item list, turn on Include inactive, and look for inactive items still carrying quantity on hand.
- Correct at the source. Re-enter item-less bills and checks using the Items tab, re-point inventory adjustments to a COGS or shrinkage account, and zero or reactivate the inactive items. Then re-run both reports.
Can a journal entry to Inventory Asset cause this?
Always, because a journal entry cannot carry an inventory item. QuickBooks journal entries post to accounts only, so a JE that debits or credits Inventory Asset moves the balance sheet without moving a single unit of quantity on hand. The valuation report cannot follow it, and the two reports separate by the amount of the entry and stay separated until somebody removes it.
This matters most for the year-end adjustment an outside accountant hands you. If the entry books an inventory value change, the file will not tie again until the underlying item quantities or costs are corrected to match. Ask what the entry was meant to represent before you post it, and prefer an inventory quantity or value adjustment, which does move both sides.
Should I post an entry to force the two reports to agree?
No. A plug entry hides the cause and guarantees the same difference reappears next month, larger. Worse, it makes the balance sheet agree with a valuation report that is itself wrong, so you lose the only check you had. Fix the transactions that created the gap, then let the reports agree on their own.
There is one narrow exception. If the file has years of accumulated error and the underlying transactions are inside a closed period, correcting them is not always possible. In that case document what you found, agree a correcting entry with whoever signs the return, and post it in the current period with a memo that names the cause. That is a decision, not a plug.
How do I fix an inactive item that still has quantity on hand?
You have three options and they are not equivalent. Reactivate the item, which brings its value back into the valuation report and makes the two reports agree immediately. Or use an inventory adjustment to set the quantity to zero, which writes the value off to whichever account you choose as the offset. Or use a value adjustment to set the new value to zero while leaving the quantity alone.
Pick by what actually happened. If you still hold the goods, reactivate. If the goods are gone, adjust the quantity to zero and offset to a shrinkage or obsolescence account, not back to Inventory Asset, because offsetting to Inventory Asset nets the entry out and leaves the quantity change stranded.
Does QuickBooks Online have the same problem?
It has a narrower version of it. QuickBooks Online only tracks inventory on Plus and Advanced, values everything on FIFO with no option to change, and gives you far fewer ways to post to the Inventory Asset account without an item. You can still do it with a journal entry or an expense coded to the asset account, and that is the usual cause when the QuickBooks Online inventory valuation report and the balance sheet disagree.
Desktop is the harder file to keep clean because it values inventory at weighted average cost, with FIFO available only in Enterprise with Advanced Inventory, and because it offers more routes to the account. The diagnosis is the same on both: find the postings with no item attached.
Why does the difference change when I re-run the report for a past date?
Because inventory cost is recalculated, not frozen. QuickBooks Desktop values inventory at weighted average cost, and that average is computed from the transactions in the file at the moment you run the report. Enter or edit a purchase dated last March today and the average cost from March forward is recomputed, so a valuation report you ran in April no longer produces the same number.
This is why a difference can appear in a period you already closed and reconciled. Before you assume new errors were introduced, check whether anyone backdated a bill, changed a quantity on an old item receipt, or edited a cost. Running the Voided/Deleted Transactions report and the Audit Trail for the period usually finds it in a minute.
What if the two reports are off by only a few cents?
Small differences are usually rounding on weighted average cost rather than a real error. An average cost carried to more decimal places than the display shows gets rounded on each transaction, and across thousands of units those roundings do not perfectly cancel. A gap of a few cents on a six figure inventory balance is noise.
Set a materiality threshold and stop chasing below it. What matters is the direction of travel: a difference that is stable at a few cents is rounding, while a difference that grows month over month is a posting habit that needs correcting no matter how small it starts.
How often should I check this?
Every month, as part of the close, before you look at gross margin. An inventory difference distorts cost of goods sold, so any margin number you calculate while the reports disagree is fiction. Comparing the two Inventory Asset figures takes under a minute once you know where to look, and catching a difference in the month it appears is the difference between correcting two transactions and correcting two hundred.
It is worth adding the check to a written close routine rather than trusting memory. The QuickBooks month-end close checklist covers where it fits alongside the bank and credit card reconciliations.
Inventory that is counted and forecast in a dedicated inventory management system tends to stay clean in QuickBooks, because the quantity decisions happen somewhere purpose built and only the resulting values are posted. Where the count lives in a spreadsheet and the accounting is done from memory, this reconciliation is the report that tells you first.
Related guides: If your cost of goods sold is negative or your quantities have gone below zero, start with negative inventory and COGS cleanup. If the balance sheet itself will not balance, that is a different problem covered in balance sheet out of balance. For the wider file, see the QuickBooks cleanup checklist and the chart of accounts cleanup. And if the bank side of the close is still fed by hand, converting your statements with the CSV to QBO converter removes the slowest step in the month.