When the Shelf Count Disagrees with the Stock Sheet
Trace the movement, recount the relevant locations and keep the reason beside a stock correction.
Published 2026-10-15 · Fragrentis editorial team
A stock sheet says eight units, but the shelf shows six. Before changing the number, make the discrepancy a small investigation. A correction that explains nothing can make the next count harder to trust.
Define what the number includes
Check whether the record covers the display shelf, the back room or both. Decide how testers, reserved items and damaged stock are identified in your system. Two accurate counts can disagree if they refer to different groups of items.
Write down the product identifier and the time of the count. Use the same identifier when checking transactions. A similar bottle or a different size should not become a substitute for the item you are investigating.
Check movement before making an adjustment
Look for sales, receipts, returns and internal transfers between the last reliable count and the new one. Include items moved for display or set aside for an existing customer. Use whatever records your store already keeps; do not invent an event to make the arithmetic balance.
For an invented example, a record of eight units and a shelf count of six may become consistent when two units are found in a clearly labelled reserve area. If those units cannot be found or documented, the explanation remains unknown.
Keep the reason beside the correction
Recount the relevant locations before editing the stock record. If an adjustment is necessary, record the old figure, new figure, date and reason. A reason can honestly say “unexplained after recount and transaction check.” It should not accuse a staff member or assume theft without evidence.
Then choose one small process improvement related to what you found. Reserved stock may need a clearer label; a display transfer may need a consistent record. Changing every procedure after one mismatch can make it difficult to see what actually helped.
The aim is a traceable stock number and a repeatable response. A discrepancy is easier to work with when the next person can see what was counted, what was checked and why the final number changed.
Leave a useful handover note
A handover can read: “Counted the shelf and back-room bin at closing; checked the reserve area; found two reserved units; no adjustment made.” If you did adjust the record, include the reference to the count sheet rather than relying on memory. The note should explain the outcome without exposing customer details unnecessarily. A clear location and transaction reference is usually more useful for the next stock check than a lengthy account of the events of the day.
A Fragrentis editorial publication. Editorial policy and disclosure.