Cycle counting template and workflow
Cycle counting splits inventory checking into smaller recurring counts, so teams can keep stock accurate without one large shutdown.
Use this page when you want to count selected items or locations regularly instead of counting everything at once.
Choose the cycle
Start with a simple plan: high-value or fast-moving items more often, slow-moving items less often.
- A items weekly or monthly
- B items monthly or quarterly
- C items quarterly or annually
Keep the sheet short
A cycle count sheet should be smaller and more focused than a full stocktake sheet.
- SKU
- Barcode
- Location
- Expected quantity
- Counted quantity
- Variance
- Reason
Use variance thresholds
Decide when a difference needs recounting, manager approval, or system adjustment.
- High-value differences
- Repeated variances
- Negative stock risk
Workflow
| Step | Action | Details |
|---|---|---|
| 1 | Select items | Pick SKUs, bins, or categories for this cycle. |
| 2 | Prepare list | Generate a focused template or CSV. |
| 3 | Count | Scan or write quantities for the selected scope. |
| 4 | Review | Investigate differences before posting adjustments. |
| 5 | Schedule next cycle | Keep a recurring plan instead of one-off checks. |
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 cycle counting the same as a physical inventory count?
No. A physical inventory count usually covers all stock. Cycle counting checks smaller groups on a recurring schedule.
What should I count first?
Start with high-value, fast-moving, or error-prone items because those differences usually matter most.
Can cycle counts use barcodes?
Yes. Barcode scanning is useful because cycle counts are repeated often and speed matters.