How to count stock on the shop floor and in the stockroom
Count both areas of one shop once. Reconcile products stored in two places with a worked example and a 12-SKU Excel worksheet.
Published:
Set one scope and one unit
Mark the shop floor and stockroom as separate zones with a shared cutoff. Use the same SKU and unit in both. If the floor count is in pieces and the back room has cartons, convert the cartons to pieces before adding.
Count each zone and record transfers
Finish one zone before moving to the next. Write down movements between zones during the count. If four units move from a shelf that you already counted to the stockroom you are about to count, check the source tally and the destination before including them.
Reconcile by SKU
Add both zone counts only once. In the example, SKU-001 has 8 units on the floor and 5 in the stockroom, for a confirmed total of 13. A blank barcode is fine when the same internal SKU identifies the same product in both zones.
| SKU | Shop floor | Stockroom | Total |
|---|---|---|---|
| SKU-001 | 8 | 5 | 13 |
| SKU-002 | 2 | 12 | 14 |
| SKU-003 | 4 | 6 | 10 |
| SKU-004 | 7 | 0 | 7 |
| SKU-005 | 0 | 8 | 8 |
| SKU-006 | 5 | 3 | 8 |
| SKU-007 | 6 | 2 | 8 |
| SKU-008 | 3 | 1 | 4 |
| SKU-009 | 4 | 2 | 6 |
| SKU-010 | 2 | 7 | 9 |
| SKU-011 | 5 | 5 | 10 |
| SKU-012 | 3 | 4 | 7 |
The workbook is a reconciliation example. It contains zone totals and stores barcodes as text so leading zeros stay intact.
Download example XLSXTry counting one shelf
Save a draft count on your phone. Review the counts for both zones and export the completed count. If you use separate counts, compare their files by SKU and reconcile transfers in the worksheet.
See the shop inventory app