Balance Sheet and Inventory Valuation Disagree on Inventory Asset
QuickBooks users find the Balance Sheet and Inventory Valuation reports show different totals for Inventory Asset — here is how to track down the cause.
When the Balance Sheet says one thing about the value of your inventory and the Inventory Valuation report says another, the difference is almost never random. It traces back to transactions that touch the Inventory Asset account without using inventory items — or to adjustments that were posted the wrong way. Here is how to find and fix the mismatch.
Why the Two Reports Disagree
The Balance Sheet Standard and the Inventory Valuation Detail report pull from different underlying data. The Balance Sheet reflects every transaction that posts to the Inventory Asset account, regardless of whether an inventory item is attached. The Inventory Valuation Detail report only reflects transactions that involve actual inventory items. When a bill, a check, a credit card charge, or a journal entry hits the Inventory Asset account directly — typically through the Expenses tab rather than the Items tab — it shows up on the Balance Sheet but is invisible to the Inventory Valuation report. The same applies to inventory adjustments that are offset to the Inventory Asset account instead of a COGS or expense account, and to inactive inventory items that still carry a non-zero value.
Step 1: Open Both Reports Side by Side
Close all open QuickBooks windows first — from the Window menu, choose Close All. This keeps the workspace clean and prevents confusion between overlapping reports.
Open the Inventory Valuation Detail report by going to the Reports menu, selecting Inventory, and choosing Inventory Valuation Detail. Set the Dates dropdown to All.
Next, open the Balance Sheet Standard from the Reports menu under Company and Financial. Click Customize Report, set the date range to All, set the report basis to Accrual, and select OK.
On the Balance Sheet, double-click the Inventory Asset amount. This quick-zoom opens a Transaction by Account detail report. In the Total By dropdown on that report, choose Item Detail.
Now tile the two reports vertically — from the Window menu, select Tile Vertically — and compare them line by line.
Step 2: Look for the “No Item” Section
If the reports are not identical, scroll to the bottom of the Transaction Detail report. Any transactions that hit the Inventory Asset account without an associated inventory item appear in a section labeled No Item. These are the entries that inflate or deflate the Balance Sheet figure without affecting the Inventory Valuation report.
To see the scope of the problem at a glance, build a summary report. From the Reports menu, choose Custom Reports, then Summary. On the Display tab, set Display Rows By to Item Type. Click the Advanced button and, under Display Rows, choose Non-zero. Go to the Filters tab and set the Account filter to Inventory Asset. Run the report. If a No Item row appears, double-click the amount to drill down to the source transaction and edit it by associating the correct inventory item.
Step 3: Hunt Down Journal Entries
Journal entries are a frequent offender. To isolate them, go to the Reports menu, choose Accountant and Taxes, then Transaction Detail by Account. On the Display tab, set Dates to All. On the Filters tab, set Account to Inventory Asset and Transaction Type to Journal. Run the report.
Every transaction on this list is a journal entry that posted directly to Inventory Asset. These should be deleted and re-entered properly — not as journal entries, but through the correct inventory workflow.
Step 4: Check Inventory Adjustments
Inventory adjustments that offset to the Inventory Asset account instead of an expense or COGS account create the same kind of phantom variance. To find them, open the Transaction Detail by Account report again. Set Dates to All, then on the Filters tab set Account to Inventory Asset. Under the “Include split detail?” option, select “For detail accounts matching” and choose Inventory Adjustment from the dropdown. Set Transaction Type to Inventory Adjustment and run the report.
Double-click any transaction on the report to open and review it. Adjustments that were entered incorrectly should be deleted and re-entered from the Vendors menu under Inventory Activities, using Adjust Quantity/Value on Hand, with the adjustment offset to the proper expense or COGS account — not back to Inventory Asset.
Inactive Items With Non-Zero Value
Inactive inventory items that still carry a quantity or value can also throw the reports out of alignment. These items no longer appear on active lists but their balances remain part of the Inventory Asset total. Review inactive items and zero them out with a proper inventory adjustment if they should no longer hold value.
The Bottom Line
The Inventory Valuation report and the Balance Sheet should always agree on the Inventory Asset total. When they do not, the discrepancy lives in transactions that bypass inventory items entirely — journal entries, expense-tab postings, and misdirected adjustments. Tracking them down through the Transaction Detail by Account report, filtered for the Inventory Asset account and sorted by Item Detail, will surface every offender in the No Item section. Fixing those transactions at the source, rather than papering over the difference with a journal entry, is what brings the two reports back into alignment. For users dealing with broader reporting discrepancies tied to damaged company files, the root cause may extend beyond posting errors — but in most cases, the fix is a matter of finding the transactions that QuickBooks cannot match to an item.