ive Numbers to Check Before Your Monthly Inventory Count
A monthly count is most useful when it tells you where to investigate, not just how much to adjust. Before anyone starts counting, capture five pieces of information so you can separate real stock differences from timing and paperwork.
1. The count cutoff. Record the exact time sales, receiving, transfers, and production movements stop being included in the snapshot. If the count starts at 6:00 PM and a delivery is posted at 6:20 PM, your physical and system quantities will not represent the same point in time. Either hold activity or document those movements for reconciliation.
2. System on-hand quantity. Save a dated item-by-location extract rather than relying on a live inventory screen after counting begins. Include the item code, unit of measure, bin or location, and system quantity. The report is your reference snapshot, not proof that the quantity is correct.
3. Physical counted quantity. Assign each shelf or bin to a counter and capture the measured amount in the item's actual unit. Write a clear conversion rule when a supplier uses cases but your stock system uses eaches or kilograms. Example: three sealed cases containing 12 units each represent 36 units, not three.
4. Quantity variance. Calculate physical count minus system on-hand. If the system shows 25 pieces and the count finds 21, the variance is negative four pieces. Before adjusting, check whether four units were sold, transferred, damaged, or received near the cutoff but posted afterward.
5. Extended value and repeat occurrences. Multiply the absolute quantity difference by a consistently defined unit cost to rank investigation priorities. A two-piece error in an expensive item can matter more than a twenty-piece error in a low-cost supply. Compare with prior counts to spot recurring problems; the same item drifting every month deserves a process fix.
A practical review workflow:
- First verify the count and units of measure.
- Then trace receipts, transfers, returns, sales, and work orders in timestamp order.
- Document the supported explanation for each material variance.
- Recount when physical evidence remains unclear.
- Only then approve the final inventory adjustment.
Example: A freezer item shows 84 units on hand and a physical count of 72. A twelve-unit transfer was picked before the cutoff but posted after it. When you reconcile that transfer to the snapshot, the apparent shortage may disappear. Record the transfer number and timing rather than describing it as unexplained shrinkage.
The takeaway: record the timing, quantity, unit, value, and recurrence before reporting a variance. A good count is a repeatable investigation, not simply a number in a spreadsheet.
This guide is general educational information for small businesses. Adapt the process to your stock system and internal controls.