Free AuditEnterprise AIShelfSense
Back to Blog
Dairy & BakeryNov 16, 20267 min read

Cycle Counting by Expiry Risk: Weekly vs Quarterly Counts

ABC cycle counting ranks by value. Add days-to-expiry: three risk bands, a weekly count list for short-dated stock, and how to read a variance.

SE

ShelfLifePro Editorial Team

Inventory management insights for retail and pharmacy

Why value-ranked counts miss expiring stock

ABC cycle counting has a simple logic. You rank items by how much money they tie up, count the expensive "A" items often, and count the cheap "C" items rarely. For a hardware store, that works fine. A box of screws doesn't go bad between counts.

A grocery store is different. A tub of yogurt might be a "C" item by value. It's cheap, it moves steadily, and nobody worries about it. But it has a few weeks of life on the day it arrives. If you only count it every quarter, the count tells you about stock that's already been sold, thrown out, or quietly sitting behind newer tubs past its date.

So value ranking answers "where is the money?" It doesn't answer "where is the clock?" A store selling perishables needs both questions on the schedule.

How a short-dated variance builds up

Here's how the gap opens. Product comes in, gets received at the case count on the invoice, and goes to the cooler. Some of it gets stocked in front of older product instead of behind it. A few units expire and get pulled by whoever notices, and they go in the dumpster without being logged.

Nothing in the system knows about those pulled units. On paper they're still in stock. The reorder logic sees enough on hand and orders less, or orders the same, depending on how it's set up. Either way, the number on the screen drifts away from what's in the cooler.

With a slow-moving dry good, that drift stays small for months. With a short-dated item, it compounds every week, because every unpulled or unlogged expiry adds to it. By the time a quarterly count catches it, you can't tell which week it happened or why.

Three expiry risk bands

The fix is to add a second ranking: days of shelf life left when product typically lands on your shelf. Group categories into three bands, then set count frequency by band rather than by value alone.

For example, a typical neighborhood grocery store might set the bands like this:

  • Short band (under 21 days of life at receiving): fresh dairy, deli meats and cheeses, fresh bread, packaged salads, fresh meat and seafood, cut fruit. Count weekly.
  • Medium band (21 to 90 days): hard cheese, eggs, refrigerated juice, tortillas, some frozen prepared items, baby food pouches. Count monthly.
  • Long band (over 90 days): canned goods, dry pasta, cereal, household goods, most frozen staples. Count quarterly, with ABC value ranking deciding the order within the band.

The exact cut-offs are yours to choose. Pick thresholds that match how fast your own suppliers' product arrives and sells, and write them down so the bands don't drift every time someone new does the schedule.

Value still matters inside each band. A high-value short-band item, like fresh seafood or a premium cheese, goes at the top of the weekly list. A cheap long-band item can wait for the quarter.

The weekly count list for the short band

The weekly list should be short enough that someone actually finishes it. If it takes all morning, it gets skipped the first busy week and never comes back.

Keep the list to the short-band categories and count by date, not just by quantity. For each item, record:

  • Item and size as it appears on the shelf tag.
  • Units on shelf and in the backroom, counted separately.
  • Units by date, grouped into "this week", "next week", and "later".
  • Units pulled since last count, from the waste log if you keep one.
  • System on-hand at the time of the count.

Splitting units by date is the part that turns a count into something useful. A matching total with half the units dated this week is a markdown problem, not an inventory problem, and you want to see it while there's still time to act.

Pick one day and one time slot. Before the morning delivery is usually cleanest, because the backroom isn't mixed with fresh cases yet. If you already walk the shelves for dates, fold the count into that walk; our guide to an expiry management daily routine covers how to fit date checks around opening tasks.

Free log

Get the day-old & markdown rotation log

For product that lives hours: markdown steps with times, day-old transfers at close, and an honest waste column. Printable PDF + Excel. See what's inside.

Instant download. No spam, unsubscribe in one click.

Reading a variance in a short-dated category

When the shelf count comes in lower than the system, it's tempting to call it theft. In a short-band category, check the boring explanations first.

Here's what a shortfall in short-dated stock usually points to, in the order worth checking:

  • Unlogged expiry pulls. Someone threw product out without recording it. Look at the bin and ask the closing crew.
  • Receiving errors. The invoice said a certain number of cases, fewer came off the truck, and nobody checked. Compare recent invoices to what was actually stocked.
  • Unrecorded in-store use. Deli items used in prepared foods, milk used at the coffee station, bread used for sandwiches.
  • Damage. Crushed cartons, leaking containers, torn packages tossed during stocking.
  • Theft. Real, but it's the conclusion you reach after the other four are ruled out.

A count higher than the system also means something. With short-dated goods it often means sales are ringing under the wrong item code, so one product looks overstocked while its neighbor looks oversold. It can also mean a delivery was stocked but never received in the system.

For a fuller look at where losses come from in each department, see our breakdown of shrinkage by department in a grocery store.

Worked example: a yogurt count

Worked example: say a store's system shows 60 cups of a single-serve yogurt flavor on hand at the Monday count. The shelf and backroom together hold 44. That's a shortfall of 16 cups, and the date split shows 12 of the 44 expire this week.

Suppose the staff check the waste log first and find nothing logged for yogurt in the last week. They ask the closing crew, who say they pulled "a handful" of expired cups on Thursday. Then they check the last two invoices against the receiving notes and find one delivery was a case short and nobody flagged it. That accounts for most of the gap without any theft at all.

Say the fix in this example is three things: pulled product gets written on the waste log before it hits the bin, receiving counts cases against the invoice before the driver leaves, and the 12 cups dated this week get moved to the front and marked down. Next Monday's count tells you whether those changes held.

Under a quarterly schedule, the same gap would have been mixed in with three months of other drift, and the short case would have been impossible to trace back to one delivery.

Setting the schedule with paper or software

You can run this on paper. A clipboard with the weekly list, a printed band chart taped inside the backroom door, and a waste log next to the bin will get you most of the way. The weak spot is the "system on-hand" column: someone has to look it up for every line, and that's the step that gets skipped.

A spreadsheet helps with the arithmetic and lets you see whether the same items show up with variances week after week. It doesn't help with the discipline of logging pulls as they happen, which is where the variance comes from in the first place.

If you need a refresher on running the full wall-to-wall count that cycle counting sits alongside, our physical inventory count guide walks through the setup. Cycle counts don't replace it, but they make the big count less of a shock.

To get started without building anything, download the department date-check logs (produce, dairy, meat, deli). They give you a ready-made sheet for the short band, so the weekly count and the date check happen on the same page.

Trying it in your store

Start small. Pick two short-band categories, dairy and deli for example, and count them weekly for a month before adding the rest. You'll learn which variances are recurring and which were one-offs, and you'll find out whether your chosen count day actually works.

If you'd rather have expiry dates and stock levels in one place instead of across a clipboard and a spreadsheet, ShelfLifePro serves grocery stores and supermarkets, and there's a 14-day free trial, no credit card required. Run your weekly short-band count alongside it for two weeks and see whether the variances get easier to explain.

SE

ShelfLifePro Editorial Team

The ShelfLifePro editorial team covers inventory management, expiry tracking, and waste reduction for pharmacies, supermarkets, and retail businesses worldwide.

One question, optional

What would stop you from trying ShelfLifePro?

See what batch-level tracking actually looks like

ShelfLifePro tracks expiry by batch, automates FEFO rotation, and sends markdown alerts before stock expires. 14-day free trial, no credit card required.

Prefer to talk it through? Book a 30-min call

Newsletter

The monthly expiry-tracking brief

One short email a month, only when there is something worth reading. FEFO tactics, markdown math, and real-world waste-reduction wins. Unsubscribe anytime.

No spam. Unsubscribe in one click.