How to Conduct a Disciplined Physical Stock Count
What is an inventory count sheet?
An inventory count sheet is a physical or digital recording sheet used by store staff to tally shelf and backroom stock during a stocktake. Standardized sheets ensure counters record item identification, counted quantities, and discrepancy notes in a consistent format.
Blind counts vs. expected quantity counts
A 'blind count' sheet omits expected quantities, forcing staff to count physical units without anchoring to computer records. This prevents confirmation bias where counters assume the recorded quantity must be correct. Include the Expected Quantity column only when performing spot audits or variance investigations where immediate reconciliation on the sales floor is required.
Best practices for count day execution
- Divide your store and stockroom into numbered bays or shelves before count day.
- Count in pairs where possible: one person calls items and counts, the second logs and verifies.
- Mark counted shelves with colored tape or stickers to prevent duplicate counting.
- Store returned or damaged items in a clearly marked 'DO NOT COUNT' quarantine area prior to the audit.
Reconciling variances after the count
Once physical counting is complete, compare counted quantities against inventory records. Focus first on high-value and high-velocity discrepancies. Investigate whether differences are due to unrecorded vendor deliveries, cashier scanning errors, shrinkage, or misplaced backroom stock before finalizing record adjustments.
Worked example · illustrative figures
Fill a count row without mixing units
Use SKU, Barcode, Expected Quantity, Counted Quantity and Variance for this comparison. The generator creates a blank sheet; these figures show how a completed row can be read.
Example item · CSV row 1
- SKU
- BEV-MILK-001
- Barcode
- 012345678905
- Unit
- pieces
- Recorded
- 24
- Counted
- 22
- Variance
- -2
- Counted 22 − recorded 24 = −2 pieces. Use the same unit for both quantities.
- Recount the shelf and check stock movements before recording a cause. For a blind count, leave Expected Quantity off and compare after counting.
For the same task on a phone, Retail Scan & Stock lets you scan items, record physical quantities and share the completed count as CSV or Excel.
View the example count CSVThe sample CSV has English headings and illustrative figures.
Related Stocktake Guides
- Retail Stocktake Checklist: Step-by-Step Store Guide →
- How to Do a Physical Inventory Count in Small Business →
- Inventory Variance Calculator →
Compare the same SKU, count cutoff and unit of measure. Unit cost is optional; leave it blank when unknown.
- Inventory Accuracy Calculator →
Use one count cutoff and consistent units. Absolute discrepancies must be added per SKU before totaling.
