Negative stock: what it means and how to fix it

Negative stock: what it means and how to fix it

One ordinary day you open your inventory record and the balance of a product says -3. There are no "minus three units" on the shelf: physical inventory is never negative. What is negative is the record, and that is almost never a mystery or a quirk of the software: it is a sign that somewhere along the way the process broke down. This article explains what negative stock means, why it happens, why you should fix it quickly, and how to do it in an orderly way, without covering up the problem with an adjustment that explains nothing.

What negative stock (or negative inventory) means

You have negative stock when the balance of a product in the kardex falls below zero. In plain terms, it means that according to the records, more goods went out than came in: more was sold, transferred, consumed, or returned than the system had counted. If the kardex shows a balance of 2 units and someone records a sale of 5, the result is -3.

Here is the point many business owners understand too late: the sale that left the balance negative may have been completely legitimate. If the customer took those units, they physically existed; what was missing was the record of the inbound movement. The goods may have arrived days earlier in a purchase that had not been documented yet, and the system, which only knows what has been entered, "oversold" because it never knew that stock existed.

It helps to be clear about what a negative balance is not:

• It is not missing goods that someone must pay for: investigate first.
• It is not an error that fixes itself over time: the longer you wait, the harder it is to reconstruct what happened.
• It does not justify a blind adjustment to "put the balance at zero": that hides the cause and leaves costs miscalculated.
• It is a concrete invitation to review how inbound and outbound movements are being recorded.

A kardex example: when the balance falls to -3

Let us look at a concrete case. A hardware store sells 9 W LED light bulbs and keeps its inventory record in a program. On Apr 1 the opening balance records 10 units. On Apr 5, 8 are sold. On Apr 12, 10 units arrive from the supplier with purchase invoice C-882; the person who receives the goods puts them on the shelf and leaves "the invoice to be recorded later". On Apr 15, 5 more bulbs are sold. This is how the kardex looks in the system:

The system never saw purchase C-882, because the inbound movement was never recorded. When the 5 bulbs were sold on Apr 15, the program only knew about 2 available units, and the balance fell to -3. On the shelf, meanwhile, there are 7 bulbs: the 10 original ones plus the 10 that arrived on Apr 12, minus the 13 sold. The gap between the system balance (-3) and the physical count (7) is exactly the size of the entry that was never recorded: 10 units.

This example shows the typical pattern: a negative balance almost always appears after an outbound movement, but the cause lies in an earlier inbound movement that was never recorded on time. If you only look at the Apr 15 sale, you will never find the problem.

Why negative stock is almost always a process error

No negative balance appears by chance. Behind each one there is a concrete cause, and in practice it is almost always one of these:

All these causes share something: the record does not reflect what actually happened to the goods. The system is not "failing" and the product did not evaporate: a document was recorded late, twice, in the wrong unit, or never. Once you understand that, fixing it stops being a leap of faith and becomes a procedure.

Why leaving negative stock unfixed is serious

A negative balance is not a cosmetic problem in the kardex: it has real, measurable consequences for the business.

• The inventory "lies". If the system says a product is at -3, nobody knows how much there really is. People lose trust in the tool and start deciding "by what they see on the shelf", which is exactly what the record is supposed to prevent.
• Purchase decisions go wrong. If you trust the negative balance, you believe there is no stock and you buy too much; or worse, you stop selling a product that is actually in the warehouse. Both cost money.
• Costs fall out of line. If the system never recorded the inbound movement, it does not know its cost either. Cost of sales is miscalculated, margins are not real, and any per-product profitability analysis loses its value.
• Taxes and reports fall out of line. Inventory that does not match reality ends up affecting declarations, stocktakes and audits, and explains those uncomfortable differences that show up at period end.
• A real problem stays hidden. When a negative balance is not investigated, it may be covering an actual loss: theft, shrinkage, or a counting error nobody detected. Investigating on time lets you find it.

How to fix negative stock, step by step

The golden rule is this: investigate first, adjust later. An inventory adjustment that brings the balance to zero without understanding the cause fixes nothing: it hides the error, leaves the cost miscalculated, and guarantees that the same problem returns next week.

1. List every product with a negative balance. Include the balance, the date it went negative, and the last document that moved it. This defines the scope of the work.
2. Count those products physically. A targeted count, only the problem products, takes minutes and gives the first clue: if the physical count is higher than the balance, an inbound movement is probably missing; if it is lower, an outbound movement is missing or there is a real loss.
3. Rebuild the movement history from the last time the balance was correct. Review the kardex movement by movement, documents at hand, until you find the exact point where the balance stopped making sense.
4. Look for unrecorded inbound movements: purchase invoices, delivery notes, waybills, transfers between branches, and customer returns that were left pending. Compare them against what the kardex shows as entries.
5. Fix the cause, not the symptom. If you found the unrecorded purchase, record it with its real date and supporting document, even if it goes back days or weeks. The kardex must tell the true story.
6. Only if a real difference against the physical count remains after all this, make the adjustment: with supporting documents (the signed count), with authorization, and with a written reason. The adjustment must remain visible in the kardex as one more movement, with its reference.

Every adjustment needs backup. A signed count, an authorization, and a note explaining why turn an inventory adjustment into internal control; without them, it is just another error recorded on top of the first one. And if more than one person records movements in the business, define who can make adjustments and cancellations: that permission should not be open to everyone.

How the kardex should look after the fix

In the hardware store example, the right fix was not "put the balance at 7 with a magic adjustment" but recording purchase C-882 of Apr 12 with its real date. This is how the kardex ends up:

The final balance (7) matches the physical count, the cost of the bulbs sold now includes the 10 units from the purchase, and the kardex tells a complete story: every movement has its date, its document, and its effect on the balance. That is the goal of an inventory system like Kardex Tauro: every inbound and outbound movement recorded in order, with a balance that can always be explained, movement by movement.

How to prevent negative stock

Prevention comes down to one simple principle: in the kardex, the inbound movement always comes before the outbound one. If that order is respected, it is almost impossible for a balance to go negative for administrative reasons. Concrete policies help make it happen:

• Record receipts on the same day the goods arrive. Recording a purchase is not a chore "to do when there is time": it is what gives the product its existence inside the system.
• Apply the "do not sell what has not been received" policy. If the goods arrived but the supplier invoice has not, record the entry anyway using the delivery note or waybill as support, and reconcile the accounting document later. Reconciling a pending delivery note is easier than explaining a negative balance.
• Run periodic counts of the problem products. Products that have gone negative before, fast movers, and items sold by loose units deserve a quick count every week or every two weeks. Ten minutes of counting saves hours of reconstruction.
• Control who can make adjustments and cancellations. If anyone can "fix" a balance, nobody will ever know what really happened. Adjustment permissions should stay with one or two responsible people.
• Prevent two people from recording the same movement. Assign one person per document type (purchases, sales, returns) and watch for duplicate documents, especially around shift changes.
• Review units of measure. Many negative balances are born from a bad conversion: goods sold by unit were bought by the box, or kilos were mixed with pounds. Define one unit per product and stick to it in purchases, sales, and counts.

In short

A negative balance is not a mystery: it is an incomplete record. It almost always means an inbound movement was recorded late or never, and the right solution is never a magic adjustment but a procedure: identify the product, count the physical stock, rebuild the movements, find the missing entry, fix the cause, and adjust only with support if needed. The underlying goal is inventory reconciliation: the balance in the kardex should match what is on the shelf.

The next time negative stock shows up, do not cover it up: investigate. The procedure is the same whether you work with Kardex Tauro or with a well-kept spreadsheet: orderly recording of inbound and outbound movements, periodic counts, and documented adjustments. That is how inventory starts telling the truth again and purchase decisions are made with reliable numbers.