Free stock count template for Excel, CSV, and print
Choose the columns your counters need, then download a modern .xlsx workbook, CSV file, or printable count sheet.
No signup or upload is required for a physical inventory count, cycle count, or spot check.
Check for pre-count item-list changes Compare the list used for the pack with the latest export
What the template includes
The starter template keeps the important fields visible and avoids spreadsheet clutter. Use Mobile import for product rows with source-row proof, Location import for storage places, Count control for zero-count evidence, or Variance review for reason approval and pending-review closeout.
- SKU
- Barcode
- Product name
- Location
- Bin
- Mobile import CSV
- Source row ID
- Import action
- Import checked at
- Import result
- Location import CSV
- Location import handoff
- Location code
- Zone owner
- Target finish
- Escalation contact
- Label status
- Spot-check result
- Expected quantity
- Counted quantity
- Variance
- Reason-code approval status
- Recount completed at
- Pending review cleared at
- Movement cutoff
- Freeze status
- Zero-count confirmation
- Reason code
- Sign-off evidence
- Count-pack checklist
- Notes
When to use each format
Use CSV when you plan to import the list into an app. Use the .xlsx workbook when you want an editable Excel worksheet. Use print when counters will write quantities by hand.
- CSV for barcode lists and imports
- Mobile import CSV with source row, action, checked-at, and result proof
- Location import CSV with code, zone owner, target finish, escalation, import result, and spot-check proof
- Variance review CSV with reason approval, recount, and pending-review closeout
- Modern .xlsx workbook for editable counts and variance review
- Printable sheet for manual counts
Location import handoff
Before counters scan by place, make the Location import CSV a small handoff packet. Load one row per storage place, name the zone owner and escalation path, prove the label is ready, and record the import result before product rows are released.
- One row per aisle, shelf, bin, room, van, or other count place
- Stable Location name and Location code that match the label counters will scan
- Zone owner, target finish, escalation contact, label status, setup verification, import result, spot-check result, and fix note
- Import locations before product rows, then spot-check one location scan in each zone
Move from typing to scanning
If your list already has barcodes, import the CSV into Mobile Inventory and scan items with a phone instead of typing counted quantities manually.
- Scan barcodes with the phone camera
- Split counting work across people
- Export counts to Excel or CSV
Workflow
| Step | Action | Details |
|---|---|---|
| Step1 | ActionChoose the count type | DetailsFull stocktake, cycle count, or spot count. |
| Step2 | ActionSelect columns | DetailsKeep only the count, control, reason approval, and sign-off fields your team needs. |
| Step3 | ActionDownload or print | DetailsExport CSV, mobile import proof file, location-import handoff file, modern .xlsx workbook, printable sheet, or count-pack checklist. |
| Step4 | ActionReconcile | DetailsCompare expected and counted quantities after the count. |
Stock count glossary
A stock keeping unit: the internal item code used to identify one product or variant.
A scannable code such as UPC, EAN, or GTIN that should point to one item or package.
The difference between expected quantity and counted quantity after a stock count.
A recurring count of selected items, locations, or categories instead of the whole inventory.
A count where counters do not see the expected quantity while entering the physical quantity.
The point when stock movements are paused or controlled so the count matches system data.
Download tools
FAQ
Is this a real Excel file?
Yes. The Excel option downloads a genuine editable .xlsx workbook; CSV and printable outputs are also available.
Can I add locations and bins?
Yes. Enable Location and Bin for count sheets, or use the Location import preset to create one clean Location name row per storage place with code, zone owner, target finish, escalation contact, label status, import result, spot-check result, and fix note.
Can I import the CSV into Mobile Inventory?
Yes. Use Mobile import for products and counts with source row ID, import action, checked-at, and result columns, or Location import when you need to load storage places before scanning.
Can I make a checklist for the count pack?
Yes. Select Count control for cutoff and freeze checks, or Variance review for reason approval, recount closeout, pending-review release, and supervisor sign-off.