Quickbooky

Accounting News

Inventory

When QuickBooks Online shows a negative quantity on hand

Stock that drops below zero in QuickBooks Online usually means a missing bill, a bad count, or an oversell. Here is how the numbers get corrected.

COMMUNITY ISSUESQUICKBOOKY

QuickBooks Online, inventory desk. A quantity that reads below zero is not a rounding error. The books are reporting that more units left the shelf than were ever recorded as arriving. QuickBooks Online permits that gap, and it will keep carrying it forward until someone closes it. The answer that settled the question for the people who raised it names a short list of causes and one step that clears most of them.

The first place a negative count appears

The Inventory Valuation Detail report is usually where the number surfaces, not the invoice that caused it. Run the report with the period set to All Dates and read the quantity column. Anything below zero is stock you sold without receiving, received without recording, or counted wrongly at some earlier point. Note the shortfall against each item. That figure is the size of the hole, and it tells you how far back the records need checking.

A quicker view of what has run out

The product list is the second place to look. In Products and services, the Low stock and Out of stock filters each carry a View all link at the top of the list, which collects every affected item in one screen. Use the report to measure each gap and the list to see how widespread the problem is before you start correcting anything.

Purchase orders do not move stock, bills do

An open purchase order is a promise, not a delivery. QuickBooks Online adds to quantity on hand only once the purchase is recorded as a bill, which is why a file full of open orders can sit beside a negative count for weeks without anyone noticing. Convert the open orders, then check the quantity on each bill line before saving. A bill saved with nothing in the received quantity moves no stock at all.

The mechanics here are not tied to a particular release; they hold across QuickBooks Online generally, though menu wording shifts from time to time. What does not shift is the order of events: bill first, count second.

Selling into a negative balance is allowed

QuickBooks Online will not stop you invoicing an item you do not physically hold. That is deliberate, because plenty of businesses ship before the paperwork catches up. The consequence is that an oversell posts quietly, and the only trace is the negative figure sitting on the valuation report afterwards.

The setting that people go looking for, a switch that blocks the sale outright, does not exist. What exists is a per item reorder point and a quantity tracking option on the product record. An item set up as a service, or one without quantity tracking enabled, will never carry a count in the first place, so start by confirming the item is tracked at all.

Reorder points and the warning that does not always fire

A reorder point is the closest thing to a guardrail the software offers. Set one on the item and QuickBooks Online flags it as low stock once the count reaches that level, which gives you room to buy before the number turns negative. Set your expectations carefully, though: the warning does not reliably appear on the invoice itself when you oversell. Shortages are found after the fact, on the list and on the report, not at the moment of sale.

Costing while the quantity sits below zero

QuickBooks Online values inventory on a first in, first out basis. When quantity is negative there are no cost layers left to draw from, so the cost attached to later sales may not reflect what you actually paid for the goods. Margins on the valuation report can read better or worse than reality until the shortfall is filled. Treat cost figures on a negative item as provisional rather than as numbers to file against.

Clearing the number and keeping it clear

Sequence matters more than speed. Convert the open purchase orders to bills with the correct received quantities, recount the shelf, then adjust the item so the record matches the physical stock. Adjusting first only hides the cause, and the shortage returns the next time someone sells the item.

Once the count is accurate and the receipts are recorded, the cost layers rebuild from real purchases and the valuation report starts telling the truth again. The problem was never that QuickBooks Online miscounted. It recorded exactly what it was told, including the sales it should never have been able to make.

← Back to Community Issues