Picture a small distributor on a Monday morning. The system says there are 24 boxes of a certain item. A customer wants 20. Someone walks to the shelf and finds 17, or 31, or none at all because the boxes were moved to another aisle last week. Nobody did anything dramatic. The number was simply wrong, and it was wrong for a dozen small reasons that piled up over months.
If this sounds familiar, the first thing to know is that it is normal. The second is that it is not random. Stock numbers drift for a handful of recurring reasons, and many of them can be made much less likely by design.
Why the number drifts
The system only knows what someone told it. Every gap between the shelf and the screen is a movement that happened physically but was never recorded, or was recorded wrongly. These are the usual suspects:
- Unrecorded movements. A part is taken for an urgent job, a sample goes out, a return is put back on the shelf. Nobody opens the system for something that takes ten seconds.
- Receiving errors. A delivery is entered with a typo, such as 100 instead of 10, or is received against the wrong item, or the paperwork is entered days after the goods arrive.
- Units of measure. The supplier sells by the box, you sell by the unit, and the system holds one number for both. A dozen, a pack and a single piece become the same thing on the screen.
- Damage, loss and theft. Goods break, expire or disappear, and a write-off is rarely anyone's favorite task.
- Timing. An order is picked but not yet shipped, or shipped but not yet invoiced. Depending on when you look, the "right" number is different.
- Look-alike items. Two products with similar codes get swapped, so one is over and the other is under, and a combined total can still look fine.
None of these is carelessness in the usual sense. They are what happens when recording stock depends on people remembering to do an extra step after the real work is finished.
Why it costs more than it seems
A wrong number does damage in both directions. If the system says you have stock that you don't, you promise something you can't deliver. If it says you are out of something you actually have, you buy again, or you turn down a sale. Over time people stop trusting the screen, start keeping their own notes and checking the shelf before answering every question. At that point the system is no longer saving anyone time, and the shelf walk you were trying to avoid has simply moved to every single order.
What a well-built system changes
A custom system can't make people perfect, but it can make the right thing the easy thing. In practice that usually means:
- Recording at the moment of the movement. Receiving, picking and returns are done on a phone, tablet or handheld scanner where the work happens, not on a form that gets typed later. A barcode scan is faster than typing and avoids the typo.
- One unit, clearly converted. The system stores each item in a single base unit and knows that a box holds a given number of them, so the conversion is done by software, not by whoever is in a hurry.
- Checks at the point of entry. If a delivery quantity is far above what was ordered, the system asks for confirmation. If a pick would take stock below zero, it flags it rather than silently allowing it.
- Every change leaves a trail. Each movement records who, when and why. When a number is wrong, you can trace how it got there instead of guessing, and that is how the same mistake stops repeating.
- Adjustments are explicit. Damage, loss and corrections go through a visible adjustment with a reason, rather than someone quietly overwriting the quantity.
- Counting is built in. The system helps you compare shelf and screen on a schedule (a topic for a separate article), so drift can be caught in weeks rather than discovered at year end.
The point is not surveillance. It is that a number you can trace is a number you can fix.
Be realistic about the goal
Perfect accuracy is not the target, and I would be suspicious of anyone who promises it. The goal is that the number is right often enough, and wrong in ways that are visible and explainable, so people can rely on it for decisions like what to promise a customer or when to reorder.
A practical first step
Before changing anything, pick twenty items and compare shelf to screen this week. For each difference, write down the most likely cause: unrecorded movement, receiving, unit of measure, damage, timing. You will probably find that two or three causes explain most of the gap. That short list is your real requirement, and it tells you whether you need a spreadsheet discipline fix, a better process, or a system built around how your warehouse actually works.