Create an Inventory Count Sheet: Template & Guide
How to build a clean inventory count sheet in Excel or Google Sheets in five minutes, with an automatic expected-vs-counted comparison. Column template included.
A good inventory count sheet doesn’t have to be complicated. It needs exactly five columns: a line number, the barcode, an item description, the expected quantity and the counted quantity. The spreadsheet calculates the variance for you. Here’s the complete structure you can copy straight into Excel, Apple Numbers or Google Sheets.
The template at a glance
| No. | Barcode (UPC/EAN) | Item description | Expected | Counted | Variance |
|---|---|---|---|---|---|
| 1 | 036000291452 | Sample item A | 50 | 48 | −2 |
| 2 | 012345678905 | Sample item B | 30 | 30 | 0 |
| 3 | … | … | … | … | =Counted−Expected |
The sample barcodes are for illustration only. Replace them with your own values.
Build it yourself in 4 steps
- Create the column headers: In row 1, enter: No., Barcode, Item description, Expected, Counted, Variance.
- Add the variance formula: In the first variance cell (e.g. F2), enter
=E2-D2and drag it down. Negative values show shortages. - Add a totals row: Below the table, enter
=SUM(F2:F100)so you can see the total variance at a glance. - Format the barcode column as text: This matters so Excel doesn’t drop the leading zero from UPCs (036000291452 becomes 36000291452) or turn long numbers into scientific notation (e.g. 4.00638E+12). Select the column → Format → Text.
Fill in the barcodes automatically
The most tedious part is typing in the barcodes. That’s exactly what Scan2List: Inventory Scanner takes off your hands: you photograph the shelf, the app reads all the codes at once and exports them as a CSV. Open that CSV right in your spreadsheet, and the barcode column fills up in seconds instead of you typing every number by hand.
Tip: You can skip the spreadsheet reconciliation if you load the list into the Inventory mode of Scan2List first. Then the app compares while you take photos and shows you what is missing, where the quantity is off and what is not on the list. How the inventory count works with the app ›
Our 5-step inventory count guide covers the whole process, from preparation to reconciliation. If you want to know which barcode types are detected, check out the barcode types comparison.
Tips for a clean inventory count sheet
- Use a separate list for each area or shelf. That makes it easier to match items later.
- Note the date, area and person responsible at the top of the sheet. That’s important for a traceable audit trail at year-end.
- Check variances right away while you’re still on site, so you can correct counting errors immediately.
- Archive the finished sheet as a PDF so there’s a record that can’t be changed.
Fill in the barcode column automatically instead of typing.
Keep reading: Physical inventory count · Perpetual inventory & cycle counting · Inventory shrinkage · Inventory template for Excel
Step by step: Use case: inventory with your iPhone, with a free template and a picture for every step.