Every warehouse sees it eventually: the system says one quantity, the shelf shows another. Inventory differences are rarely a mystery. Most come from a short list of causes, and once you know where to look, tracing them is a methodical task. This guide explains why inventory numbers do not match and how to work back from a difference to its source.
Two numbers describing the same stock
The system balance is the result of every transaction posted since the last count: receipts, shipments, transfers, returns, write-offs and adjustments. The physical count is what is actually there at one moment. A difference means that at least one physical event was not recorded, was recorded wrongly, or the count itself was wrong. Keeping all three possibilities in mind stops people from jumping to the conclusion that stock was stolen.
It also helps to look at differences in both directions. Surpluses are as informative as shortages: stock that appears from nowhere was either received without a document, returned without a record or moved from somewhere it is now missing. Ignoring surpluses hides half the story.
Timing and cut-off problems
The most frequent cause of large but harmless differences is timing. A delivery arrives and is put away before the receipt is posted, or goods are shipped and the shipment is posted the next morning. If the count happens in between, the numbers disagree even though nothing is lost. Goods in transit between two sites can also be missing from both or counted in both.
Units of measure and item master errors
If an item is held in boxes of twelve in the system but counted in pieces, the difference looks dramatic. Similar problems come from duplicate item codes, where the same product exists twice and stock is split between them, or from conversion factors that changed when a supplier changed packaging. These differences often appear as round multiples, which is a useful clue.
- Box versus piece versus kilogram confusion
- Duplicate codes for the same product
- Changed pack sizes not updated in the system
- Wrong conversion factors between units
Picking, receiving and location errors
Physical handling errors are the next group. A picker takes the wrong size or colour, so one item is short and a similar item is over. A receiver books a delivery under the wrong code. Stock is put away in the wrong location, so it is counted as missing in one place and as an unknown surplus in another. These differences often come in pairs, and matching them is one of the quickest ways to reduce the variance list.
Counting errors belong in this group too. A pallet counted twice, a back row of cartons missed, or a full box assumed to be full when it was opened: these are why every significant difference should be recounted, ideally by a different person, before anyone starts searching the documents.
Unposted transactions and real losses
Some movements happen without paperwork: damaged goods thrown away without a write-off, samples given to customers, items used internally, returns placed back on the shelf without a return document. Each one makes the system higher than reality.
Only after these explanations are exhausted should a difference be treated as a real, unexplained loss. Real losses do happen, through theft, damage or spoilage, and they need management attention. But they should be the conclusion of an investigation, not the starting assumption.
How to trace a difference step by step
Work through differences in order of value, starting with the largest. For each one, follow the same sequence so that nothing is skipped and the result can be explained to finance and head office.
- Recount the item and its neighbouring locations
- Check the unit of measure and conversion factor
- Look for a matching surplus or shortage in similar items
- Review documents posted around the cut-off
- Check transit, returns and quarantine locations
- Ask the warehouse team about unrecorded movements
- Record the cause, or mark the line as unexplained
Stopping the same differences from coming back
Once causes are known, group them. If most differences come from units of measure, fix the item master. If they come from receiving, review how deliveries are checked and booked. If they cluster around one shift, one zone or one product family, look at training, layout or labelling there. Share the summary with the warehouse team as well as finance: people who see why differences happen are much more likely to prevent them. Regular cycle counting makes this feedback loop much faster. Any adjustments and their accounting treatment should be agreed with your local accountant or auditor.
Key takeaways
- Most inventory differences come from timing, units, handling errors or missing paperwork.
- Surpluses and shortages in similar items often cancel out and point to a picking swap.
- Trace differences in order of value, using the same steps every time.
- Treat real losses as the conclusion of an investigation, not the first assumption.