You check the system: 24 bottles of shampoo. You check the shelf: 15. Where did nine bottles go? Every business that holds stock eventually faces this question. This article explains the most common causes of stock differences, how to investigate them, and a simple control process that keeps your numbers trustworthy.
If you are building good habits from scratch (reorder levels, spot counts, slow movers), start with Stock control basics for shops. This article focuses on what to do when the numbers are wrong.
A stock difference is almost always one of two things: a movement that wasn't recorded, or a movement that was recorded wrongly. Here are the usual suspects.
The supplier drops off goods while the owner is out and the paperwork goes into a drawer. The system shows less stock than you really have, and you may reorder something you don't need.
Ten cartons recorded as ten pieces, or the other way round, is one of the biggest sources of error. Each product needs a clear unit, and purchases should be checked against the supplier invoice.
The same delivery is entered twice, by two staff members or once from the invoice and once from the delivery note.
A busy moment, a regular customer who "will pay later", or an item handed over while the system was offline. If it isn't recorded, stock stays too high.
A cashier picks "Coca-Cola 330ml" instead of "Coca-Cola 500ml". Total sales may still be right, but both products' stock is now wrong. Barcode scanning reduces this dramatically.
Broken items thrown away, expired products removed, or goods taken for the family or staff, all without a record.
Stock carried from the warehouse to the shop without recording a transfer. The total is right, but each location is wrong.
It happens, but it's often blamed too early. Rule out recording errors first. They are more common and easier to fix.
Counts done in a hurry, items stored in two places, or counting while sales continue can all create false differences.
| When | What to do | Who |
|---|---|---|
| Every delivery | Check goods against purchase order and invoice; record received quantities the same day | Receiving staff; manager approves |
| Every sale | Scan barcodes; never hand over goods without recording the sale | Cashiers |
| Every breakage or expiry | Record an adjustment with reason "damaged" or "expired" | Any staff; manager reviews |
| Every transfer | Record the transfer before moving stock | Store manager |
| Weekly | Cycle count 2–3 categories; investigate differences | Manager |
| Monthly | Review the adjustments report by reason and by staff | Owner |
| Yearly | Full stock count | Whole team |
Scanning removes most wrong-product errors at checkout and during receiving. For items without barcodes, print your own labels.
Decide whether you sell by piece, pack or carton, and name products accordingly, for example "Instant noodles (pack of 5)".
Give each staff member their own account. Restrict who can make adjustments and who can delete transactions. When every action is linked to a person, careless mistakes drop.
"I'll enter it later" is the root of most stock differences. Record deliveries, transfers and breakage immediately.
A business with many unexplained adjustments has a process problem, even if the stock numbers look correct after each count.
When staff can type anything as a reason, adjustment reports become useless. Agree a short list and use it every time:
| Reason | Use when | What it tells you |
|---|---|---|
| Damaged | Breakage in store or in transit | Handling or storage problems |
| Expired | Product passed its date | Over-ordering or poor rotation |
| Supplier short delivery | Fewer units than invoiced, found later | Receiving checks need tightening |
| Internal use | Goods used by the business or staff | Costs that should be expenses |
| Count correction | Count differs and no cause found | Unexplained loss; investigate if it repeats |
A rising number of "count correction" adjustments is the clearest sign that a process somewhere isn't being followed.
A mini-mart finds 9 bottles of shampoo missing. The manager recounts and finds 3 in the display basket. Reviewing movements, she sees 12 bottles were received last week, but the supplier invoice says 6. The delivery had been entered twice. After correcting the duplicate purchase, the difference disappears completely. No theft, no loss: just a recording error that would have led to an unnecessary reorder.
Paper and spreadsheets make investigation slow because there is no automatic history of movements. If you spend hours each month reconciling stock, compare your options in Inventory software vs Excel and read our inventory management guide.
KyeFlow records every sale, purchase and return against the product, supports barcode scanning and label printing, and gives each staff member their own login and permissions. On the Standard and Premium plans you also get stock counts, adjustments, transfers and inventory reports, so differences can be traced back to specific movements.
Key takeaways
A difference between the quantity your records show and the quantity physically in stock.
Scan barcodes, give each product one clear unit, record deliveries and breakage immediately, give staff individual logins, and do regular cycle counts.
Investigate first. Many differences come from duplicate or missing entries that should be corrected directly. Use adjustments, with a reason, for genuine losses or when the cause cannot be found.
Tired of chasing missing stock? KyeFlow keeps a record of every movement, so differences are easier to trace. Try KyeFlow free for 7 days on the Basic plan.
