How to Cycle Count Inventory in a Small Shop (10 Minutes a Week)
You don't need a yearly all-weekend count to know what's on your shelves. A cycle count checks a small slice of your stock every week, so mistakes get caught while they're still small and cheap.
What a cycle count is
A cycle count means counting a few products on a schedule instead of everything at once. Over a few months every product gets counted, and the ones that matter most get counted more often. Big retailers have worked this way for decades. It works even better in a small shop, because a dozen items takes about ten minutes.
Step 1: Rank your products by money, not by count
Not every product deserves the same attention. Rank them by how much money they move in a year (units sold × unit cost is a good start). Then split them into three groups:
- A items: the top 20% or so. They usually carry most of your sales dollars. Count these every month.
- B items: the next 30%. Count these every quarter.
- C items: the rest. Count these twice a year.
In a spreadsheet, a SUMPRODUCT of units and cost gives each product's yearly value, and sorting by that column gives you the ranking in a minute.
Step 2: Spread the counts across the weeks
Add up how many counts you need in a year (A items × 12, B × 4, C × 2) and divide by 52. For a shop with 125 products, that's usually about a dozen items a week. Make a simple calendar so each week has its own short list, mixing a few A items with some B and C items.
Step 3: Count blind
Print the list without the quantity your system says you have. When you know the "right" answer, you tend to find it. A blind count keeps the numbers honest. Count what's on the shelf, write it down, and only then compare.
Tip: count at a quiet time, before you pack the day's orders. Stock that's mid-shipment is the most common source of false errors.
Step 4: Recount before you change anything
When a count doesn't match, don't fix the number right away. Recount it, ideally on a different day. If the second count agrees with the first, adjust your system and write down a reason: a receiving error, a mis-pick, damage, or "unknown."
Step 5: Put a dollar value on every miss
Being off by 3 candles and off by 3 sweatshirts are not the same problem. Multiply each difference by its unit cost and track the total each month. That number tells you if your accuracy is getting better and where the money is leaking.
Step 6: Look for patterns, not just errors
After a month or two, the reasons start to repeat. If most misses trace back to receiving, check deliveries against the order before anything goes on the shelf. If they trace to one location, that shelf needs a better label or less clutter. Fixing the cause is what makes the next count cleaner.
What good looks like
It's common for a small shop to be off on a good share of its products without knowing it. A steady weekly routine is how you get to 95% or better and stay there. More important than the score: you stop overselling, you stop running out of your best sellers, and you know what's sitting on the shelf.
Want this done for you?
The Cycle Count Starter Kit builds the A/B/C ranking, the 52-week calendar and blind count sheets for you, and prices every miss in dollars. Excel and Google Sheets.