Cycle counting means counting a small part of your inventory on a regular schedule, instead of counting everything once a year. Over the year every item gets counted, the most valuable items get counted most often, and the warehouse never has to shut down for a weekend. This guide shows how to set one up.
Cycle counting vs a physical inventory
| Annual physical inventory | Cycle counting | |
|---|---|---|
| How much is counted | Everything, at once | A few items every working day |
| Operations | Usually stopped for the count | Keep running |
| Errors found | Once a year, long after they happened | Within weeks, while the cause can still be found |
| Who counts | Everyone available, often rushed | A small trained team |
| Main purpose | Valuing inventory for the books | Keeping records accurate for planning |
Many companies with a reliable cycle count program reduce or stop the annual count. Whether you can depends on your auditors and lenders, so ask your accountant before you drop it.
The ABC method
Rank items by annual value, which is units used a year times unit cost. The few items that make up most of the value are A items, and they deserve the most attention. See ABC-XYZ classification for how to rank them.
| Class | Share of annual value | Counted a year | Typical tolerance |
|---|---|---|---|
| A | About the first 80% | 12, about monthly | 0% to 1% |
| B | The next 15% | 4, about quarterly | 2% |
| C | The last 5% | 1 or 2 | 5% |
These are common starting points, not rules. Count more often where errors keep turning up, or where a single shortage would stop production.
How many counts a day you need
Counts per working day = (A items × A counts a year + B items × B counts a year + C items × C counts a year) ÷ working days a year
With 200 A items, 300 B items and 500 C items, counted 12, 4 and 1 times a year, that is 2,400 + 1,200 + 500 = 4,100 counts a year. Over 250 working days, it comes to 16.4 counts a day, or 82 a week. A items take 59% of the counting, even though they are only a fifth of the items. Try your own numbers in the cycle count schedule calculator.
How to run a count
- Pick what is due, most important first, and print or download the list.
- Count blind. The sheet should not show the system quantity, or counters tend to find it.
- Mind the timing. Count when the location is not being picked or received, or note the transactions in flight.
- Recount anything outside tolerance before adjusting, ideally with a different person.
- Post the adjustment in your ERP, with a reason code.
- Find the cause of the largest differences: receipts not booked, picks from the wrong bin, unreported scrap or units of measure mixed up.
Measure the program
The number to track is inventory record accuracy: the share of counts within tolerance. Many operations aim for 95% or better. Track it by class and by location, because a low figure in one place points to the process that needs fixing. Our guide to the inventory accuracy formula shows how to calculate it, with and without tolerances.
Spreadsheet or software?
A spreadsheet works for a few hundred items in one location. It gets hard to keep the schedule, the tolerances and the history straight beyond that. The Statadventure cycle counting page schedules counts by ABC class from your own data, gives you a blind count sheet, measures record accuracy and produces the adjustments to post. It is in every plan.
See a count program on sample data
The live demo needs no account. Use the sample company or load your own files, which stay in your browser tab.
Frequently asked questions
What is ABC cycle counting?
A cycle count program where items are counted more or less often depending on their annual value: A items most often, C items least.
How often should A items be counted?
A common starting point is monthly. Count more often if errors are frequent or a shortage would be costly.
Can cycle counting replace a physical inventory?
Often, once record accuracy is high and stable, but it depends on your auditors and lenders. Ask your accountant first.
Try the Statadventure live tools
Inventory tools for US manufacturers: reorder point, safety stock, EOQ and landed cost, with the inputs and assumptions shown.
Open the live tools