Almost every business that holds stock knows the moment: the count is finished, the figures go into the system, and the difference is larger than anyone can explain. The usual reaction is to adjust the books to the count and move on. That fixes the number for a day and leaves the cause exactly where it was.
A stock difference is not one problem. It is the sum of several small ones, and each has its own fix. Here is where we look first.
Movements that never reach the system
Goods leave the warehouse for a sample, a replacement, a branch that ran short, or the office kitchen. Each one is small and each one is sensible, and none of them is recorded. Over a month they add up to a difference nobody can trace, because there is no document to trace.
The fix is a rule rather than software: nothing leaves without a document, however small. A transfer, an internal consumption, a scrap record. Once every exit has a paper trail, the count stops being a surprise.
Units that do not agree
Purchasing buys by the carton, the warehouse counts by the piece, and sales sells by the pack. If the conversion between them is wrong in the system — or does not exist, and people convert in their heads — every transaction adds a small error in the same direction.
Counting on a day that suits nobody
A count taken while goods are still being received and shipped is a count of a moving target. Freeze movements for the count, or count by location in a fixed order and record what moved while you were counting.
- Every exit from the warehouse has a document.
- Units of measure and their conversions are set once, in the system.
- Counts happen with movements frozen, or recorded while counting.
- Differences are explained before they are adjusted.
Adjusting the books to the count is the last step, not the first. Find out why first — or the same difference comes back next month.