Cycle counting template — ABC tiers, schedule, variance log.

The short answer

A cycle count template needs three linked parts: an ABC classification ranking SKUs by annual usage value, a rotating schedule that counts A items most often and C items least, and a variance log recording counted against expected so you can tell whether accuracy is improving or you are just counting more.

Worked example

Rank every SKU by annual usage value (unit cost x annual units sold), then sort descending. The SKUs making up the first 80% of that value are your A tier — typically around 20% of the catalog — and get counted monthly. The next 15% of value is B, counted quarterly. The final 5% is C, counted once a year. A 900-SKU catalog usually lands near 180 A items, so about 9 counts a working day keeps the A tier current without a shutdown.

Why a rotating count beats an annual shutdown

A full physical count gives you one accurate day a year and costs you a day of trading. By the following week the number has drifted again, and you have no idea which SKUs drifted or why. Cycle counting trades that single perfect snapshot for continuous, uneven accuracy that is highest exactly where errors cost the most.

It also turns counting into a feedback loop. When the same SKU shows variance three cycles running, that is a process signal — a mislabelled bin, a picking error, a receiving shortcut — and you can go fix the cause rather than repeatedly correcting the symptom.

The variance log is the point, not the count

Counting tells you today's number. The log tells you whether your process is getting better. Record counted quantity, expected quantity, the difference, and a reason code, and after one full rotation you can see which locations and which SKUs generate the errors.

Track variance as a percentage of value, not as a count of incidents. Twenty single-unit discrepancies on C items matter far less than one twelve-unit discrepancy on your highest-margin A item, and an incident count treats them as equal.

Frequently asked questions

What is ABC analysis in inventory?

ABC analysis ranks SKUs by annual usage value — unit cost multiplied by annual units sold. The A tier is the roughly 20% of SKUs making up about 80% of that value, B is the next 15%, and C is the remaining 5%. It tells you where attention is worth spending.

How often should I cycle count each tier?

A common starting cadence is A monthly, B quarterly, C annually. The principle is that counting frequency should follow the cost of being wrong, so tighten the A cadence if your A items move fast or carry high margin.

What counts as an acceptable variance?

Set the threshold by tier rather than using one number. A tolerance that is sensible for a low-value C item is far too loose for an A item where the same percentage represents real money. Anything above the tier's threshold should trigger a recount before an adjustment is posted.