Inventory counts in Google Sheets

• Setup time ~1 min to set up
• Difficulty Beginner
• Sheet mode Update · one row per SKU

How a stock count usually works

A physical inventory count — a stocktake — reconciles what your system thinks you have against what is actually on the shelf. Done on paper or from memory it is slow and full of typos; scanning turns every item into a single tap and a clean row you can work with afterwards.

1. Decide what you are counting Set a scope before you start — the whole warehouse, one aisle, or a single product category. Counting in zones keeps it manageable and lets several people split the floor without counting the same shelf twice.
2. Scan instead of typing Scan each item’s barcode and its SKU and product name fill the row automatically. Enter the quantity you actually see on the shelf — that is the only number you type.
3. Re-scan to correct, not duplicate The sheet runs in Update mode, so scanning the same SKU again jumps back to its existing row instead of adding a second line. A miscount is a five-second fix.
4. Compare against your records Because the counts live in Google Sheets, you can paste your system’s expected quantities in the next column and let the variances jump out — shrinkage, mis-picks and receiving errors all show up as a mismatch.
5. Adjust, then keep the record Feed the corrections back into your system and keep the sheet as the audit trail: what was counted, by whom, and when.