What to do when your QuickBooks stock count is wrong

Sooner or later every product business runs into it: QuickBooks says 12, the shelf has 9, or QuickBooks shows a negative quantity for something you can see in front of you. Before you adjust anything, it's worth finding out why — otherwise the same gap reopens next month.

The usual causes

Timing: sold but not shipped

QuickBooks Online reduces quantity on hand when an invoice is saved. If goods are still waiting for delivery, the shelf will show more than QuickBooks. That isn't an error — it's expected. Check this first; it explains many "wrong" counts. (See how to tell which stock is already sold.)

Bills entered late, or without items

If stock arrives but the bill is entered weeks later — or entered against an expense account instead of the item — QuickBooks doesn't know you have it. That's a common cause of negative quantities.

Wrong item on the invoice

Selling "Table – Oak" when the customer took "Table – Walnut" leaves both items wrong. It's especially common with similar products and variants.

Returns, damages and samples

Goods come back, get damaged, or go out as samples without a matching transaction.

Duplicate or inconsistent items

Two items for the same product, or a non-inventory item used for something you actually stock.

How to investigate one item

1. Run Inventory Valuation Detail for the item over the period in question. It lists every transaction that moved its quantity.
2. Compare against what physically happened: deliveries received, orders shipped, returns.
3. Look for the gaps — a delivery with no bill, a sale on the wrong item, a return never recorded.
4. Fix the underlying transaction where you can (with your bookkeeper or accountant, especially for closed periods), rather than just adjusting the quantity.

Running a stocktake that actually helps

A good count is less about counting harder and more about recording properly:

• Pick a cut-off. Count at a moment when nothing is moving, or record exactly which orders were shipped before the count.
• Separate "not counted" from "zero". A blank should mean nobody has counted it yet; 0 should mean someone looked and there are none. Many spreadsheets and systems blur the two — and that's how real gaps get hidden.
• Count by area, not by list. Walk the building in order and count what's there, including items not on your list.
• Record who counted what. When a figure looks odd, you know who to ask.
• Adjust in QuickBooks with an inventory quantity adjustment, using the right adjustment account agreed with your accountant, and keep the count sheets as support.

Keeping it right afterwards

• Cycle counts — count a small section every week instead of everything once a year.
• Enter bills when goods arrive, against the inventory item, not later.
• Scan to pick, so the wrong variant can't be sold or shipped by accident (see barcode scanning with QuickBooks Online).
• A clear process for returns and damages.

Where a warehouse layer helps — and where it doesn't

Our warehouse layer for QuickBooks Online turns the whole stock list into the count sheet, filterable by category or status, keeps blank and zero distinct, and records who entered each figure. It also flags negative and oversold stock so problems surface early. One honest limit: QuickBooks Online's API doesn't provide an inventory-adjustment document for us to post, so the count produces the figures and a person posts the correction in QuickBooks. We don't pretend otherwise.

Frequently asked questions

Why is my QuickBooks inventory not accurate?

Common causes are goods sold but not yet shipped, bills entered late or without the inventory item, the wrong item on invoices, unrecorded returns or damages, and duplicate items. Inventory Valuation Detail shows every transaction that moved an item's quantity.

Why does QuickBooks show negative inventory?

Usually because stock was sold before the bill or purchase that brought it in was entered, or the purchase was recorded against an expense account instead of the inventory item.

How do I fix inventory quantity in QuickBooks Online?

Find and correct the cause first, then use an inventory quantity adjustment with the adjustment account your accountant recommends, keeping your count sheets as support.

QuickBooks and QuickBooks Online are trademarks of Intuit Inc. Rinko Books' warehouse software works with QuickBooks Online; it is an independent product and is not made, endorsed, certified or sponsored by Intuit.