Inventory Count Sheet Template
Run a physical or cycle count — track location, lot number, expiry, and variance in one sheet.
Download Free Count SheetCSV format — opens directly in Excel, Google Sheets, or Numbers. No signup.
What's in the template
- sku / item_name
- What you’re counting
- location
- Aisle, shelf, or room
- lot_number
- Lot or batch identifier
- expiry_date
- Expiration date, if applicable
- system_quantity
- What your records expect
- counted_quantity
- What you physically counted
- variance
- counted minus system
- notes
- Damage, mislabeling, etc.
How to run a count with it
- Export or copy your current on-hand quantities into sku, item_name, location, lot_number, expiry_date, and system_quantity before the count starts.
- Print the sheet or open it on a tablet, and walk each location physically counting stock.
- Fill in counted_quantity for every row as you go — don't skip rows that match what you expect.
- Calculate variance (counted_quantity − system_quantity) and use notes to record why a variance happened, where known.
- Investigate any non-zero variance before adjusting your records, and update system quantities once the count is confirmed.
The limits of a spreadsheet count
A static sheet works for a small, single-person count, but it breaks down at scale. There's no barcode scanning to reduce data-entry errors, no draft-saving if you have to stop mid-count and resume later, and no audit trail showing who counted what and when — which matters if you ever need to explain an inventory adjustment. See cycle counting best practices for a rundown of how frequent, smaller counts avoid the once-a-year fire drill.
When you outgrow this template
Nstock can import this CSV directly to seed item and location records, then replace the spreadsheet with barcode-driven counting. See barcode cycle counting for what a scanning-based workflow looks like, or use the reorder point calculator to turn a count's system_quantity and variance into a concrete reorder trigger for that SKU.
Frequently asked questions
How do I use this count sheet in Excel or Google Sheets?
Download the file and open it in Excel or Google Sheets — it's CSV, which both read natively. Pre-fill sku, item_name, location, lot_number, and system_quantity from your current records before the count starts. During the physical count, walk the floor and fill in counted_quantity for each row, then let variance = counted_quantity minus system_quantity flag discrepancies to investigate.
Is this for a full physical count or cycle counting?
Either. The columns work the same way whether you're doing one big annual physical count of everything, or cycle counting — smaller, more frequent counts of a subset of locations or SKUs on a rotation. For cycle counts, filter your source data to just the locations or SKUs due this cycle before you pre-fill the sheet.
Can this template save my progress mid-count or scan barcodes?
No — it's a static spreadsheet, so there's no draft-saving across devices, no barcode scanning to speed up data entry, and no audit trail of who counted what and when. For a large count with multiple people counting different locations at once, that usually means manually merging several copies of the sheet afterward.
Is this inventory count sheet template really free?
Yes. The template is free to download and use with no signup or account required.
Count with a barcode scanner, not a clipboard
Nstock imports this CSV directly, scans lots into the system, flags variances automatically, and keeps a full audit trail of every count — no spreadsheet merging required.