SocialBrand

Home / Insights / Your stock ledger is lying to you

Stock ledger integrity

Your stock ledger is lying to you

Phantom stock is inventory existing on paper only: a stock figure the system displays for units no shelf holds. Its mirror is negative stock, units the system says cannot exist while customers keep buying them. Both come from the same disease, a ledger recording movements it never understood, and both quietly decide what your store orders next.

Walk into any supermarket back office and ask for the stock report on one product. The system answers instantly, with confidence, to the exact unit. Twenty-four units of long-grain rice. Now walk to the shelf. Count. There are nine.

Nobody stole fifteen bags of rice. Nobody is incompetent. The ledger is doing exactly what ledgers do when nobody audits their claims: it kept the arithmetic and lost the truth.

How a ledger learns to lie

A stock ledger has one job. Yesterday’s stock, plus what arrived, minus what sold, equals today’s stock. Simple. Except a real store breaks the equation a dozen ways before lunch.

Receipts land on one product code while sales ring on another. The same bottle lives on two barcodes, one selling, one hoarding claims. The bakery receipts flour and sells bread, so the flour code grows a mountain of stock it never sold and the bread code sells stock it never received. A case cost gets captured as a unit cost and one shelf of paper cups becomes a small fortune on paper. A barcode gets recycled and inherits a stranger’s history.

None of this looks like a crisis. Each error is one line among thousands. The ledger swallows them all and keeps answering to the exact unit.

We have stood in stores where a single bread line ran more than eleven thousand units negative while the shelves sold out every morning. We have found a packaging code carrying close to four hundred thousand units of printed bread bags on the books, received over years and never scanned out. We have watched a water line sell fifty thousand units without a single receipt ever touching its code. Every one of those stores had ordered off those numbers the day before.

The lie that costs the most is the quiet one

Negative stock at least announces itself. A minus on a report looks wrong, someone eventually asks about it and the trail leads somewhere useful.

Phantom stock is worse, because it fails silently. A line claiming stock it does not have never triggers a reorder. The ordering system looks at the claim, sees plenty, and moves on. The shelf sits empty. The customer reaches, finds nothing, buys it at the store down the road and tells no one. No report anywhere records the sale you lost, because as far as the system knows, you had stock the whole time.

Multiply one phantom line by a few hundred, which is what a neglected ledger accumulates, and a store is bleeding turnover through holes no report will ever show. The report is the hole.

Presence is proven by sales or counts. Nothing else.

The way out starts with one rule, and it is the founding rule of how we work: a product is present because it sold recently or because a person counted it recently. A stock figure on a screen proves nothing. It is a claim, and claims get audited.

This sounds obvious and changes everything. It means the age of a stock figure matters as much as its value. It means a quiet line with a fat claim is not an asset, it is a question. It means the annual stocktake, that heroic weekend of chaos and casual labour, is eleven months too late for most of the errors it finds.

What to do about it, starting Monday

You do not need a platform to start. You need a different habit.

  1. Rank your claims. Pull your stock report sorted by value. The top of the list is where fiction costs most. For each of the top twenty lines ask one question: when did this last sell, or when was it last counted? A big claim with no recent proof goes on tomorrow’s count list.
  2. Count a little every day. Thirty well-chosen lines inside a normal shift. Value first, oldest proof first. A store doing this proves thousands of lines a quarter, concentrated exactly where the money and the doubt overlap, and errors get caught in days instead of at year-end.
  3. Fix receiving at source. When a count exposes a break, chase the movement, not the number. If receipts post to a different code than sales, correcting the quantity tonight buys you a clean number until next week’s delivery breaks it again. The receiving fix ends it permanently.
  4. Respect the two worlds. Anything made in store, bakery, butchery, deli, will never obey buy-and-sell arithmetic on its ingredient codes. Those lines need production rules, not adjustment journals. Stop punishing fresh departments for a ledger design problem.
  5. Only then, trust the number. Once a line’s claim is proven, ordering off it stops being gambling. This is why we refuse to automate a store’s ordering before its ledger earns it. Automation built on phantom stock is a machine for repeating mistakes faster.

The uncomfortable question

Here is the test worth running this week. Pick the ten highest-value stock claims in your business and stand in front of each one. If more than one of the ten is fiction, your ledger is lying to you at the top of the range, where it hurts most, and it is lying further down too.

We built a free, twenty-question checklist for exactly this walk: the Store Data Health Checklist. It takes an hour and tells you whether your numbers deserve your trust. If the answer is no, that is not bad news. It is the first true number your store has produced in a while, and everything we do starts from there.

PG van der Westhuizen is the founder of SocialBrand and has run South African retail floors for more than three decades, including the Checkers Sixty60 dark store pilot in Cape Town, where a phantom stock record becomes a failed customer order inside the hour. SocialBrand rebuilds stores’ profitability at socialbrand.africa.

Is your ledger telling the truth?

The Store Health Audit answers it with evidence. Fixed fee, one store, findings in rand.

See the auditFree checklist