Cycle Count Schedule: How Many Items to Count Each Day

To build a cycle count schedule, multiply the number of items in each ABC class by how many times a year that class should be counted. Add the totals and divide by the number of counting days you actually have. For example, a shop with 1,200 SKUs that counts A items monthly, B items quarterly and C items twice a year needs to count 17 items a day across 240 counting days.

Most answers stop at “count A items more often”. This page goes further. You get the formula with each part explained, a fully worked example where every figure adds up, and the rotation calendar that tells your team which items to count on day 1, day 21 and day 120.

You also get a copy-ready SOP, recount rules, the edge cases that break schedules (holidays, new SKUs, packed parcels, multiple locations), and the exact steps to run each day’s count in Cash Flow Inventory.

The cycle count schedule formula

A cycle count checks part of your stock in turn. Over a year, every item gets counted at least once, and your most important items get counted many times. If you want the wider set of methods first, our guide to cycle counting methods and best practices covers them. This page focuses on the arithmetic of the ABC method, because that is where most schedules go wrong.

Items per day = (A items × A counts per year + B items × B counts per year + C items × C counts per year) ÷ counting days per year

Here is what each part means:

• Items in each class: the number of stocked SKUs or variants in A, B and C. If you have not classified yet, start with ABC analysis and inventory classification. Services and non-stocked items do not count, so leave them out.
• Counts per year: how often you want each item in that class counted. Twelve means monthly and four means quarterly.
• Counting days per year: the days someone will actually count. Five days a week for 48 weeks gives 240. Do not divide by 365 unless you truly count every day.

Run the same formula for each class on its own and you get a per-class daily quota. That split is what makes the calendar work.

Starting frequencies by ABC class

These are decision rules, not laws. Begin here, then move items between classes or change frequencies once you have three months of count results.

Accounting standards such as IAS 2 Inventories require inventory to be measured correctly. They do not prescribe a count frequency, so your frequencies are a business decision. Agree them with your accountant or auditor if a year-end stock figure depends on them.

Worked example: items to count each day

The chart shows why ABC scheduling matters. A items are only one tenth of the range, yet they take more than a third of all counts. C items are 70% of the range, but each one is counted only twice.

When the number does not divide evenly

Real numbers rarely come out as tidy as 17. Suppose you had 250 counting days instead. You would get 1,440 ÷ 250 = 5.76 A items, 960 ÷ 250 = 3.84 B items and 1,680 ÷ 250 = 6.72 C items. Round each class up, to 6, 4 and 7. Rounding up means each rotation finishes a few days early, which builds in slack. Rounding down means the rotation runs past its target and you quietly miss counts.

The cycle count calendar, worked out

Number the items in each class in shelf order (aisle, then bay, then shelf). Then give each counting day the next block from each class. Counters walk one short route instead of crossing the store, and you can see at a glance where each class’s rotation stands.

In calendar terms, every A item is counted once every 4 working weeks, every B item once every 12 weeks and every C item once every 24 weeks. Twelve, four and two counts fit inside 48 weeks, so the 4 spare weeks are true buffer.

How to set up your cycle count schedule: step by step

1. List only stocked items. Remove services, non-stocked items and dead SKUs with no stock. Count variants (size, colour) as separate items, because each one sits in its own spot and can be wrong on its own.
2. Classify A, B and C. Use annual consumption value (units sold × cost per unit). Then promote small, high-theft and frequently mis-picked items by hand.
3. Choose frequencies. Start with 12, 4 and 2, or 12, 4 and 1 if you are short of staff.
4. Count your real counting days. Take working days per week × weeks you will count. Leave out peak season, stock-take weeks and public holidays.
5. Calculate per-class daily quotas with the formula, rounding each class up.
6. Time a test day. Count one day’s list and record the minutes. If it runs over 45–60 minutes, counting will be rushed. Lower the C frequency or add a counter.
7. Number items in shelf order and build the rotation calendar like the table above.
8. Write recount and approval rules (below) before the first count, not after the first argument.
9. Review quarterly. Reclassify, move error-prone items up a class and check that each rotation is on track.

Recount and tolerance rules

• A items: recount any difference at all. Escalate to the manager if it is confirmed.
• B items: recount if the difference is more than 2 units or more than a value you set, for example the price of one unit.
• C items: recount if the difference is more than 5% of the expected quantity or above your value limit.
• Any item that is wrong twice in a row moves up one class for the next quarter.

Common cycle count schedule mistakes

• Dividing by 365 or 260. If you only count on 230 days, a schedule built on 260 will fall about a month behind by year-end.
• One daily number with no class split. Counters drift to easy C shelves, and A items quietly miss their monthly count.
• Counting while goods are being received. Stock half put away creates false variances. Finish receiving first; our goods receiving SOP keeps that step clean.
• Adjusting without a reason. An adjustment with no cause fixes the number today and lets the same error happen tomorrow.
• Leaving counts open. Unapproved counts pile up, the system figure stays wrong, and reorder decisions are based on bad stock. That is how you get avoidable stockouts.
• Never revisiting classes. Last year’s C item may be this year’s best seller.

Edge cases a generic schedule misses

Small ranges

With 300 SKUs, the same frequencies come to about 4 items a day. That is too little to be worth setting up daily. Count weekly instead: divide the yearly counts by 48 weeks and do the whole batch in one session.

Multiple locations

Each shop or warehouse needs its own schedule, because the same SKU can be right in one place and wrong in another. Calculate the daily number per location from that location’s stocked items.

New SKUs mid-year

Add new items to the end of their class list and count them within two weeks of first receipt. The first count after launch catches setup errors such as the wrong unit, pack size or barcode.

Seasonal items

Count seasonal stock just before the season, so you reorder from true numbers, and again just after, so you know what to carry over. Our guide to SOS analysis for seasonal items helps you decide which items count as seasonal.

Holidays, Ramadan and peak weeks

Do not try to count through your busiest weeks. The 4 buffer weeks in the example exist for this. Pause the rotation, then resume from the same day number. Never restart from day 1.

Expiry-dated stock

For food, cosmetics or pharmacy lines, write off expired lots before counting. Otherwise counters record stock you cannot sell, and the count looks fine while the value is overstated.

Year-end and audits

If your auditor or tax adviser relies on a perpetual system instead of a full stocktake, they will want evidence that cycle counts ran on schedule and that differences were approved. Tax rules on inventory, such as those described in IRS Publication 538 for US businesses, expect consistent, supportable records. Keep the count history.

How to do this in Cash Flow Inventory

Cycle counts run from Inventory › Stock counts. Full instructions are in the stock counts and reconciliation guide. Here is how to run the daily schedule above.

1. Make sure the people counting have the stock count rights, and the manager has the approve right. Set this up under settings, users and permissions.
2. Open Inventory › Stock counts and choose Start a count.
3. Choose Some categories if your categories match your shelf blocks, or Chosen items to pick exactly today’s 17 items from your rotation list.
4. Choose the Location and give a Count name that matches your calendar, such as “Cycle day 021”. Then pick the categories or items.
5. Set Items per sheet. Tick One category per sheet if two people split the aisles.
6. Decide whether to tick Freeze stock while counting. For a short daily count during trading hours, leaving it unticked is usually better. The sheet remembers what the system had when it was made, and on approval only the difference is added to today’s on hand, so sales recorded while you counted are kept. Freeze only if nothing should move until approval.
7. Choose who it is Counted by and start the count.
8. Open each sheet and enter the quantity counted for each line, saving as you go. Lines start blank, so “not counted yet” is never mistaken for zero. Saving a line sets its counted figure; it does not add to the earlier one.
9. Products picked onto a parcel that is still waiting for the courier show “packed on PL-… — not stock, don’t count”. Skip those units.
10. Review the differences, give a reason where needed, and accept the lines you agree with. Approve the sheet, either all differences or the accepted ones only. Approval posts the stock movements and the journal in one step, with a full trail.

Approve the same day. Only one open count is allowed per location at a time, so an open count from yesterday stops you starting today’s.

For your doubt list, use the quick spot check. From Inventory › Products › Variants, tick a few variants and count them in a small window. With the approve right, stock is corrected at once; otherwise the count goes for approval.

For expiry-dated lines, use Write off expired stock on the same screen before counting. Choose the location, Expired on or before and optionally a category. It is refused while a frozen count holds the location, so run it first.

Services and not-stocked items are left out of count sheets automatically. Check each product’s type in the item types guide so your SKU total matches what the sheets will show. When you close the month, the approved counts support the stock value you sign off in period close and lock.

Frequently asked questions

How many items should I cycle count per day?

Multiply the items in each ABC class by its counts per year, add them up, and divide by your counting days. For 1,200 SKUs counted 12, 4 and 2 times a year over 240 days, that is 17 items a day. Your number depends on your range size and frequencies, not on a fixed rule.

How often should A, B and C items be counted?

A common starting point is monthly for A, quarterly for B and once or twice a year for C. Increase the frequency for small, valuable or error-prone items. Reduce C counts if the daily workload is more than your team can do accurately.

Can cycle counting replace a full annual stocktake?

Often yes, if every item is counted at least once in the year, differences are investigated and approved, and the records are kept. Whether your auditor or tax adviser accepts it is their call, so agree the approach with them before year-end.

What should I do if we miss a counting day?

Do not double up the next day if that would rush the count. Carry on from the missed day number and use one of your buffer weeks to catch up. If you have no buffer left, recalculate the daily quota with the remaining counting days.

Should I count by item or by location?

Count by item, but check every place that item lives, including overflow, returns and display. Counting a single bin and missing the back stock is one of the most common causes of false differences.

A schedule only helps if counting, review and approval happen in the same place as your sales and purchases. If you want daily cycle counts that post straight to stock and the books, look at Cash Flow Inventory’s inventory management software or start a free trial and run day 1 of your rotation this week.