A shelf count can look wrong even when every item is accounted for. The stock record might describe 9:00, while the person counting sees 9:10, after a delivery and several picks. Before changing a quantity, bring the record and the physical observation to the same moment.
Define exactly what you are counting
Choose one named shelf, bin or small stock area. List the product codes and variants within that boundary. A count of shelf A2 cannot be compared with a whole-store total. If your records only track the whole store, use this exercise to investigate the shelf, not to replace the store balance.
Specify the counting unit: individual notebooks, packs of three, or another defined unit. Record full packs and loose items separately, then convert using the verified pack size. Keep damaged stock, returns awaiting inspection and other stock statuses separate where your records distinguish them. Note unexpected products rather than ignoring them.
Save a dated reference quantity
Save the recorded on-hand quantity for the same product, location, unit and status, with the date and exact reference time. Use the recorded physical on-hand figure; an available-to-sell figure may exclude reserved goods that are still physically present.
Check known pending receipts, picks and transfers before starting. Resolve or explicitly document cases where the physical movement and its record fall on opposite sides of the reference time. Saving a report does not itself prevent stock from moving. Keep the saved version unchanged so you can explain the later comparison.
Control movements around each observation
The simplest approach is an agreed short pause in movements through the selected area. Coordinate it with whoever handles replenishment and picking, following the store's normal procedures. Other areas can continue operating.
If movements must continue during the wider counting session, give one person responsibility for recording every arrival and departure through the count boundary. Record the physical movement time, product, quantity, unit, direction, source or destination, transaction reference and whether the stock record has been updated.
Keep each individual product count stable while it is being observed. If someone adds or removes that product mid-count, stop and recount it once the movement is clear. Write the observation time beside the result. If you cannot establish a reliable quantity at a known moment, arrange a controlled recount rather than estimating.
Compare quantities from the same moment
For each product, start with the saved reference quantity. Add documented physical arrivals after that reference and before the observation; subtract documented departures in that interval. This gives the expected quantity at the observation time, provided the earlier timing exceptions have been resolved.
Use the saved baseline for this calculation. Adding the same movements to a live balance that already includes them would count them twice. Retain the movement log and posting details so you can also explain the current balance when review finishes.
A small worked example
In this fictional example, a shop counts individual blue notebooks on shelf A2. Its saved 9:00 record shows 24. During the session, six notebooks arrive at 9:03 and four leave at 9:06. Both movements are logged and recorded against A2.
No notebooks move while the counter observes them at 9:10. The count is 25. The expected quantity at that moment is 24 + 6 - 4 = 26, giving a difference of 25 - 26 = -1. An immediate recount, with movements still paused, also finds 25.
At 9:15, after counting resumes elsewhere, three more notebooks leave A2 and that movement is recorded. The live record now shows 23, while A2 physically holds 22. Entering the earlier count of 25 as the current balance would create a new error.
Review finds that one notebook moved from A2 to A3 the previous afternoon without a recorded transfer. A3 has one more than its record, and the transfer evidence confirms the move. The responsible person records that missing transfer once through the normal process. A2's record becomes 22, A3 gains one, and the store total is unchanged. No additional shortage adjustment is needed.
Investigate before closing the count
For any remaining difference, check the product variant, unit conversion, nearby locations, pending transactions and possible double counts. Keep both the original count and any recount. A discrepancy alone does not establish its cause.
Have the responsible reviewer decide whether a missing transaction, corrected count or inventory adjustment is appropriate. Follow the installed system's counting procedure: some workflows calculate a difference against a snapshot, while others expect a current quantity. Verify the resulting balance and ensure the same correction has not been applied twice.
Fields for a reusable count sheet
- Count ID, date, location boundary, counter and reviewer.
- Product code, variant, stock status, unit and pack conversion.
- Saved record quantity, reference time and report reference.
- Movement log, transaction references and posting status.
- Observation time, first count, recount and expected quantity.
- Difference, investigation evidence and proposed resolution.
- Approved correction reference, verification time and final status.
Use zero for verified absence; a blank means uncounted. Leave unresolved lines clearly marked for review. A useful count ends with an explainable result, not simply a matching number.
