QuickBooks Inventory Problems: Fixing Stock Counts and Valuation
Stock counts that drift, average cost surprises, and an inventory asset that will not tie out: common QuickBooks stock problems and practical fixes.
Inventory is the most common trouble spot we hear about from QuickBooks users. The symptoms repeat across small retailers, wholesalers, and the accountants who support them: quantities that refuse to match a shelf count, cost of goods sold that moves on its own, and a balance sheet that no longer agrees with the inventory reports. Here is what causes each pattern and what to do about it.
The stock problems we see most often
Four patterns account for most of the inventory questions we get. Quantities on hand drift away from the physical count, usually after an import or a batch of backdated entries. Average cost shifts without any obvious purchase. The Inventory Asset account stops matching the inventory valuation reports. And month-end counts surface differences no single transaction can explain.
Each pattern has a distinct cause, so the fix starts with working out which one you have.
Why does a sale change the cost of older items?
QuickBooks Online values every stock item at its average cost. The average recalculates each time you record a purchase. Sell before you buy, and the program has no cost to work with, so it lets the quantity go negative and restates the average when the purchase finally lands.
Backdated sales are the usual trigger, because entry order and document order stop matching. The damage is not theoretical. It flows into cost of goods sold, gross margin, and the Inventory Asset balance.
Prevention is simple: enter purchases before the sales they cover, and avoid backdating a sale across its own purchase. Negative quantities that already exist need deliberate correction, not a shrug at the next count.
Does the balance sheet agree with the inventory valuation report?
It should, to the penny. Run the Inventory Valuation Summary and compare its total with the Inventory Asset account on the balance sheet for the same date. When the two disagree, look first for journal entries posted directly to the inventory account.
QuickBooks tracks item costs behind the scenes. A manual entry changes the account without touching the items, and the reports split apart. Adjustments dated into a closed period cause the same split. The repair is to reverse the manual entry and make the correction through the inventory quantity adjustment tool, which updates the items and the ledger together.
How should a physical count be entered?
Count during a quiet window, with sales and purchases paused or clearly cut off. Enter the differences through the inventory quantity adjustment tool, dated the day of the count. Add a memo naming who counted and why the adjustment was made; six months later that memo is the only clue left.
Resist the temptation to post a journal entry straight to the Inventory Asset account. It looks faster and costs more later.
A routine that keeps stock accurate
Three checks, run monthly, catch nearly everything early. Compare the valuation summary total with the Inventory Asset balance. Review the item list for negative quantities, which almost always points to backdating. Cycle-count a handful of items each month instead of one exhausting annual count.
Start with one comparison this week: run the valuation summary, note its total, and set it beside the balance sheet figure for the same date. If the two agree, your problem is process, not data. If they still disagree after the entries above are cleaned up, the company file itself may be damaged. That is repair work rather than bookkeeping, and it is what we do.