Cycle counting: how to set up an ABC count program

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 inventoryCycle counting
How much is countedEverything, at onceA few items every working day
OperationsUsually stopped for the countKeep running
Errors foundOnce a year, long after they happenedWithin weeks, while the cause can still be found
Who countsEveryone available, often rushedA small trained team
Main purposeValuing inventory for the booksKeeping 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.

ClassShare of annual valueCounted a yearTypical tolerance
AAbout the first 80%12, about monthly0% to 1%
BThe next 15%4, about quarterly2%
CThe last 5%1 or 25%

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

  1. Pick what is due, most important first, and print or download the list.
  2. Count blind. The sheet should not show the system quantity, or counters tend to find it.
  3. Mind the timing. Count when the location is not being picked or received, or note the transactions in flight.
  4. Recount anything outside tolerance before adjusting, ideally with a different person.
  5. Post the adjustment in your ERP, with a reason code.
  6. 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

Contact us

Scroll to Top