Stock Never Matches the System? Causes and Real Fixes
The shelf says 9, the system says 12. Where stock discrepancies really come from — entry mistakes, shrinkage, theft — and how to squeeze them down.
“The system says 12, the shelf has 9.” If you run a store, you have said this sentence. A gap of three units sounds harmless. Multiply it across hundreds of SKUs, every month, and the money leaking out adds up fast — no receipt, no alarm, no trace.
The good news: stock discrepancies almost always follow a pattern. And patterns can be hunted down.
The four doors a discrepancy walks through
Before suspecting anyone, map out where gaps can actually enter. In our experience, the ranking looks like this.
Data entry mistakes come first, and they are the least suspected. A delivery of 24 gets keyed in as 42. A wholesale carton sale gets rung up as one piece. A customer return is physically accepted but never recorded. One product ends up with two codes because it was created twice under slightly different names. Nobody meant any harm — yet the accumulated damage often beats theft.
Shrinkage comes second. Items break on display, expired food gets thrown out without a record, loose goods spill during repacking. Shrinkage itself is normal. Unrecorded shrinkage is the problem, because it dresses itself up as a mystery gap.
Goods leaving without a transaction is the sensitive one. The owner grabs an item “and will log it later” — then forgets. Samples handed to customers. And yes, theft, by visitors or by staff. Internal theft tends to be small and steady, which is precisely why an annual stocktake never catches it.
Finally, receiving problems. The supplier ships short, but the delivery note gets signed without a recount. That discrepancy was born before the goods ever reached a shelf.
Follow the pattern, not your gut
You can only shrink a discrepancy once you can see its shape, and you can only see its shape if you count often. A store that counts once a year will never know whether the gap came from January or November. So step one is always the same: shorten the distance between counts with rotating cycle counts.
Once you have a few rounds of data, ask three questions.
Which items keep going missing? Small, high-value goods point in a different direction than bulk ingredients. Is the gap one-directional? Gaps that swing both plus and minus are usually entry errors; gaps that are always negative, on the same items, suggest goods walking out untransacted. And when did it start? Match the timeline against changes — a new hire, a new supplier, longer opening hours, a big promotion.
A pharmacy owner once told us their children’s cough syrup went short every weekend. Not theft. The weekend cashier was a part-timer who did not know the 60 ml and 100 ml bottles carried different codes, so she scanned whichever came up first. A five-minute training problem, not a police problem.
Closing the doors one by one
For entry errors, the cure is less typing. Scan barcodes at the register and at goods receiving instead of keying codes. One product, one SKU — hunt down the duplicates. Deliveries get physically counted before the delivery note is signed, and any gap against the purchase order is logged on the spot, not “later”.
For shrinkage, build it a proper lane. Set up clear adjustment reasons in your system: breakage, expiry, internal use, samples. Staff need to know that logging a broken item is not shameful — hiding it is. Once shrinkage is recorded honestly, you can budget for it, and whatever remains is the real mystery worth investigating.
For untransacted goods, rely on systems and layout rather than suspicion. Keep small high-value items near the register or behind glass. Make sure every stock adjustment records who did it and when — that audit trail alone is a decent deterrent. In Tenavora, every stock movement (sale, receipt, adjustment, transfer) carries a user and a timestamp, so “who changed this number and when” always has an answer.
For receiving, get in the habit of ordering with a formal purchase order, so there is a reference quantity before the truck arrives — we cover that in getting started with POs.
A sane target
Zero discrepancy is a myth; even global retail chains live with shrinkage around 1–2% of revenue. A realistic goal for a small store: push unexplained discrepancies below half a percent of sales value, and make sure the rest is shrinkage that is recorded and explainable.
Start by recording, not accusing. Nine out of ten discrepancy cases we see are solved by fixing a process — and a fixed process is exactly what makes the tenth case, the genuine theft, impossible to hide.