Negative stock: why it happens and how to fix it properly

What is negative stock?

Negative stock is a quantity on hand below zero: the records show more units issued than received. Physically you cannot sell a rack you never had, so a negative figure always means the records are out of step with the shelf.

The goods usually exist. What is missing is the document that brought them in, or a document put them in the wrong place, or counted them in the wrong unit. Treat a negative balance as a pointer to a missing or wrong document, not as a stock problem to be typed over.

Why does stock go negative?

Almost every case of negative stock comes from one of five causes. They are worth checking in this order, because the first is by far the most common.

1. Invoicing before the bill is posted. The goods arrived, the sales counter sold them, and the supplier bill is still sitting in a tray. The sale issues stock that the records do not have yet.
2. Wrong warehouse. The bill put 20 racks into the Main godown, but the invoice took them out of the Ukkadam store. The organisation has stock; one warehouse is negative and another is overstated.
3. Unit mismatch. The bill was entered as 10 boxes, the invoice as 60 pieces. If the product has one unit, either the bill or the invoice is wrong by a factor of six.
4. Untracked opening stock. Stock on the shelf on day one was never entered, or was entered as a quantity without a cost. The first few sales then dig below zero.
5. Transfers recorded on one side only. Someone noted the goods leaving one godown and never recorded them arriving, or the reverse, outside a single transfer document.

Negative stock quietly bends your average cost and cost of goods sold

Under weighted average cost, the order of documents decides the cost of every sale. When a sale goes out before the purchase that covers it, it leaves at the old average, and the purchase then lands on a negative balance and pushes the average to a figure nobody paid.

Here is one week of the steel rack 4 shelf at Lakshmi Steel Furnitures, the fictional Coimbatore business on this site. It starts with 10 racks at ₹3,000. A bill for 20 racks at ₹3,324 from Tamil Nadu Steels arrives the same day that 15 racks are invoiced to Ravi Stores at ₹4,990 each. The only difference between the two columns is which document was posted first.

The ₹3,240 does not vanish. It sits in closing stock at an average of ₹3,432, which is higher than any price Lakshmi Steel paid, and it will come out as extra cost on later sales. Profit for this week is flattered and a later week pays for it. Across fifty products and a busy month, these small shifts make the margin report hard to trust.

Different systems treat the negative balance differently. Some carry the negative value as shown here; others restart the average at the next receipt's cost. Either way the cost of the sale was decided before the real cost was known, which is why the fix is to post documents in the order things happened. See weighted average cost explained for the formula.

How do you fix negative stock in the right order?

Fix negative stock by finding the movement that should have come first and posting the document that was missing, not by typing a new quantity. Work through these steps in order and stop as soon as the balance is right.

1. 1

   Find the movement

   Open the product's movement history for the warehouse that is negative and find the first row where the balance crossed zero. The document on that row is the issue that ran ahead of its receipt.

2. 2

   Post the missing bill, or an adjustment with a reason

   If a supplier bill is missing, post it with its real cost and the date the goods arrived. If the goods came from somewhere without a bill, such as opening stock that was never entered, post a stock adjustment with the cost and a reason that says so.

3. 3

   Correct the warehouse by a transfer

   If the organisation has the stock but the wrong warehouse is negative, post a transfer from the warehouse that holds the surplus. A transfer moves units at the current average, so total stock value does not change.

4. 4

   Then count

   Only after the documents are in place, count the product on the shelf and post an adjustment in count mode for any difference that is left, with a reason. Counting first hides the missing document inside a write-off.

Unit mismatches need one more step. Decide the one unit the product is counted in, then correct whichever document used the other unit. In a system where posted documents cannot be edited, that means cancelling the wrong document, which reverses it, and posting it again in the right unit.

How do you stop stock going negative again?

Prevention is mostly posting discipline: stock that arrives is entered before stock that leaves. A short checklist covers the rest.

• Only physical goods are marked as tracked; services and labour charges are not, so they never create stock balances
• Each product has one unit, and bills, invoices and counts all use it
• Supplier bills are posted the day the goods arrive, before the sales counter sells them
• Opening stock is entered for every product, with a quantity and a cost, before the first invoice
• Every move between godowns is one transfer document, never two separate entries
• Posted documents are never edited; corrections are a cancellation and a new document
• Negative balances are reviewed weekly and fixed in the order above
• Stock value is checked against the Inventory account at month end

The last item is the self-check. If stock value and the Inventory account agree, every movement reached the books. If they differ, something moved outside a posted document. For a full count routine, read the stock audit and physical count guide.

How does SimpleERP handle stock movements?

In SimpleERP, stock moves only through posted documents: bills, invoices, credit and debit notes, adjustments, transfers and work orders. Nobody types a stock quantity. Posting an invoice writes the stock issue, cost of goods sold, the receivable and GST in one step, and posted documents are immutable, so a cancellation reverses rather than deletes.

• Weighted average cost per product across the organisation, with quantities per warehouse.
• Selling below zero is refused by default. The database stops the invoice, transfer or adjustment and names the product and warehouse.
• Negative stock can be allowed in settings. Then the next receipt restarts the average at its own cost, instead of blending into a negative balance.
• Stock adjustments in count mode with a reason, and transfers between warehouses.
• Opening stock by product dialog, by adjustment or by product CSV import.
• The stock screen shows total stock value beside the Inventory account balance and their difference.

That means every negative balance can be traced to a document, and every fix is a document with a date and an audit trail. Read more on the inventory management page, or start with the inventory management guide.