Summarize with AI

Discuss this page

Choose your assistant for a short summary and practical next steps.

If the prompt is not filled in, paste the copied text. Your assistant may need you to paste the page content.

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.

Worked example with 12 fictional products
8Shop floor
5Stockroom
13Total
SKUShop floorStockroomTotal
SKU-0018513
SKU-00221214
SKU-0034610
SKU-004707
SKU-005088
SKU-006538
SKU-007628
SKU-008314
SKU-009426
SKU-010279
SKU-0115510
SKU-012347

The workbook is a reconciliation example. It contains zone totals and stores barcodes as text so leading zeros stay intact.

Download example XLSX

Try 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