abc cycle counting

Abc Cycle Counting

ABC cycle counting is a way to count stock in small batches all year. Our guide shows how to start this week. You count high-value items often and low-value items less often. Small teams use it in place of one big yearly count.

You need one export from your accounting package, a spreadsheet, and a simple schedule. You will learn how to sort items, set a count schedule, handle mismatches, and spot when paper sheets slow you down. Every step uses plain tools you already own. The 2025 plan fits teams of 5 to 100 staff.

Book a call

What Is ABC Cycle Counting?

ABC cycle counting is a method that splits your stock into three groups. Each group gets its own count schedule. The once-a-year full count shrinks into a small task done every day or week.

The Pareto rule is an idea that a small share of items drives most of the value. Count those items most. For a longer look, read what is abc classification in inventory management.

Counting by ABC class puts your count time where the money sits.

What Do A, B and C Items Mean?

Annual usage value is the number that ranks every item: units sold in a year times unit cost.

  • A items are about the top 20% of items and make up about 80% of spend.
  • B items sit in the middle and matter less than A items do.
  • C items are many items that carry low value each.

The 80/20 split is a rule of thumb, not a law. A items are few, and they hold most of your money.

What Is ABC Cycle Counting?, in figures
A items are about the top 20% of items and make up about 80% of spend.

We build it for your operation, and the first look is free

If you would rather not compare products, describe how your operation already works and we build the system around it.

No build cost. You see it running on your own process first, and the monthly subscription starts only once it is live.

Book a call

Why Is a Yearly Count Not Enough?

A yearly physical inventory count is a full stop-and-count of every item. The IRS says in Publication 538: "To figure taxable income, you must value your inventory at the beginning and end of each tax year." Valuing stock is a duty. Doing it in one big push is a choice.

Big counts cost you in four ways:

  • You must close the warehouse or pay your crew overtime.
  • Errors sit hidden for months until the count day arrives.
  • Tired counters make more mistakes late in the long day.
  • Small teams feel the pain most, since every person is needed.

Cycle counting vs physical inventory comes down to timing. Small counts find errors while the cause is fresh.

How Does ABC Cycle Counting Work?, in figures
Step 2: Rank by Value, Then Draw the Lines The usual split is A at 20% of items, B at 30%, and C at 50% .
The team who would use abc cycle counting, mid-task

How Does ABC Cycle Counting Work?

Three moves make ABC cycle counting work: rank items, split them into groups, and set how often each group is counted. You then count a few items each day and fix the cause of each error.

The next three steps show each move in order.

Not sure this is the right shape for your operation

Describe how the work runs today. We map it on a call and show you what it would look like built around that, before you spend anything.

Book a call

Step 1: Pull Your Item and Usage Data

One export is the only start you need. Pull the item list, unit cost, and yearly units from your accounting package or a spreadsheet. Remove duplicate and retired items first.

Messy data in old sheets or printed pages is the most common obstacle. Give the cleanup one hour.

Step 2: Rank by Value, Then Draw the Lines

The usual split is A at 20% of items, B at 30%, and C at 50%. First multiply yearly units by unit cost. Sort the list from high to low. Then draw the lines.

Adjust the split to fit your products. Fast movers can join the A group even when they cost little.

Step 3: Set Your Cycle Count Schedule

A cycle count schedule is a plan that says how often each group gets counted. Use this table as a start:

GroupCount how often
A itemsMonthly
B itemsQuarterly
C itemsOnce or twice a year

Shorten the cycle for high-theft items or groups with many errors. Lengthen it if staff time is short. An ABC cycle count schedule is yours to tune.

A Simple Example for a Small Distributor

Ten items a day is the load for a small distributor. This is a made-up example, not a client result. Say the shop has 1,000 items and 200 are A items. A monthly count of 200 items over 20 work days is 10 items a day. That is 15 to 30 minutes of work.

The daily load is small. The warehouse never stops.

How Do You Run Cycle Counts Day to Day?

A daily count is a four-step task:

The manual process abc cycle counting replaces
  1. Print or show a short count list each morning.
  2. Count blind if you can, and hide the system number.
  3. Recount the item when the gap is large.
  4. Record the result in your sheet the same day.

A blind count is a count made without seeing the system number. Avoid busy picking hours. A quiet window gives cleaner counts.

What Do You Do When Counts Do Not Match?

Cycle count variance is the gap between the system number and the shelf number. Check four things first: recent receipts, picks, returns, and transfers. Then look for a wrong unit of measure or a wrong bin.

A tolerance is a limit that tells you when to act. Adjust small gaps and look into large ones. Fix the cause, not just the number. A fixed cause stops the same error next month.

Other Ways to Pick What to Count

A trigger count is a count set off by an event. Add triggers on top of ABC cycle counting:

  • Count an item when its stock hits zero.
  • Count after a receiving error or a big pick.
  • Count items with past mismatches more often.

Triggers sit beside your ABC groups and do not replace them.

Reviewing the figures abc cycle counting produces

Which Mistakes Break ABC Cycle Counting?

Five mistakes cause most failures:

  • Nobody updates the A, B, and C groups as sales change.
  • Staff count during the busy picking times of the day.
  • The process has no owner who checks that counts happen.
  • Someone adjusts numbers without finding the cause of the gap.
  • The team skips C items forever and never counts them.

Refresh your groups once or twice a year. Re-rank after a season, a new product line, or a big customer change. Groups that go stale count the wrong items.

The comparison is easier when one option is built for you

Off-the-shelf means fitting your process to the software. We do it the other way round, and the first look costs nothing.

Book a call

Can You Run Cycle Counts With a Spreadsheet and Your Accounting Software?

A spreadsheet is a fine start for cycle counts. Accounting software is a tool that tracks quantity on hand and posts adjustments after a count. The spreadsheet holds the count sheet. This pair works well at the start.

Close detail from the work abc cycle counting supports

The risks grow with time:

  • Sheets get lost or saved under the wrong name.
  • Versions pile up in email with no clear latest copy.
  • No one keeps a history of past counts and gaps.

When Do Spreadsheets Stop Working?

Spreadsheets are a weak fit once you see missed counts, arguments over numbers, or hours spent building lists. Inventory counting software is a tool that does three jobs. It builds the daily list, takes entries on a phone, and keeps variance history.

A custom tool can sit next to your accounting package. It replaces only the manual parts. You need no big ERP and no long move.

What Results Can You Expect?

Three goals drive cycle counting. These are goals, not promises.

  • More accurate stock means fewer stockouts and fewer surprises on the shelf.
  • Counts run daily, so the warehouse never shuts down for a full count.
  • Better data helps buying, so pair it with how to calculate cycle stock to plan orders.

Inventory accuracy is the measure of how well system numbers match the shelf. Steady small counts build trust in those numbers.

Next Steps for Your Warehouse

One export starts the work. Make it this week and build your first A list. Run ABC cycle counts for a month before you change any tools.

If sheets and manual steps slow you down, talk to a local Columbus, Ohio team. The Software Society builds software around how you already work.

Frequently asked questions

What is cycle counting in a warehouse?

Cycle counting is a method of counting a small part of your stock on a set schedule. You count a few items each day or week. Every item gets counted several times a year.

What is considered a cycle count?

A cycle count is any planned count of a small group of items, done while the warehouse keeps running. A count of 10 A items on a Tuesday morning is one. A full-site count is not.

Is cycle counting better than a yearly physical count?

For most small warehouses, yes. Small counts find errors sooner and avoid shutdowns. Some accountants still ask for a yearly count, so check first.

How many items should we count per day?

Divide the items in a group by the work days in its cycle. With 200 A items counted monthly over 20 days, you count 10 a day.

Can a small warehouse do it?

Yes. A small team needs one item export, a spreadsheet, and 15 to 30 minutes a day. The method scales down well.

Do we still need a yearly count?

Ask your auditor or accountant. Some need a full physical inventory count. Others accept cycle counts with solid records of each count and adjustment.

Start with a free first look

A 30 minute call, your operation mapped, and a clear picture of what we would build. No obligation and nothing to install.

Book a call

Related guides

More on the same work.

Guides

Common questions