How to read a stock count report
A count report can be long, with thousands of lines. Most readers either look only at the total or give up. A better approach is to read it in layers: first the overall picture, then the biggest items, then the patterns.
1. The total gap
Start with the overall difference in money and in quantity. Look at both. A small difference in value can hide a large difference in quantity (many cheap items), and the opposite is also possible.
Express the gap as a percentage of total stock value. This lets you compare with earlier counts and with other warehouses.
2. The largest deviations
Sort the differences by value, from the biggest down. In most counts, a short list of items accounts for the majority of the total gap. These are the lines that deserve investigation first.
For each large difference, check three things: whether it was recounted, whether a document was missing or late, and whether the item is easy to confuse with another one.
3. Recurring locations and categories
Look at where differences cluster: a particular shelf, a category, a supplier, a shift. A pattern points to a process cause such as wrong labelling, a weak receiving routine or poor access control.
Compare with the previous count
Is the gap getting smaller or larger? Are the same items on the list again? Progress, or its absence, tells you whether your actions after the last count actually worked.
Turn the report into decisions
- Assign an owner to every large difference.
- Mark each as data error, process error, damage or loss.
- Decide what changes in the process to prevent it.
- Set a date to check that the change worked.
Questions to ask while reading
- Is the biggest difference one item or many small ones?
- Do the differences lean in one direction, mostly shortages or mostly surpluses?
- Are the problem items in one location, one category or one shift?
- Were these items problematic in earlier counts?
Present it clearly to management
Management does not need all the lines. Summarise the total gap, the three or four biggest causes, what has been done already and what decisions you need. A one-page summary with a clear next step is far more likely to be read and acted upon.
A report that is only filed has no value. Its purpose is to start corrections, in the records first and in the process second.