Free AuditEnterprise AIShelfSense
Back to Blog
InventoryMar 202613 min read

Expiry Date Tracking for Small Businesses (2026)

The complete guide to batch-level expiry tracking — from initial audit to FEFO enforcement to tiered alerts. For grocery, pharmacy, and specialty food.

You are losing money every week and you can prove it in 10 minutes

Walk into your stockroom right now. Pull out every product that is within 30 days of its expiry date. Add up the cost price. That number — the one you are probably looking at with some discomfort — is what you stand to lose in the next month from expiry alone.

For a typical small business dealing in perishable or date-sensitive goods, this exercise reveals a loss of 2-5% of inventory value. A convenience store with $80,000 in stock discovers $2,000-4,000 at immediate risk. A small pharmacy with $150,000 in stock finds $4,000-7,500 in near-expiry products. A specialty food store with $60,000 in stock identifies $1,500-3,000 that needs to move fast or get written off.

Expiry date tracking is not a nice-to-have. It is the difference between managing your inventory and watching it depreciate in real time.

Free Tool

Not sure how much you're losing to expiry?

Run a free inventory waste audit — find your bleeding SKUs in 60 seconds. No sign-up required.

Run free audit

What expiry date tracking actually means

Let's be precise, because the term gets used loosely.

Product-level tracking means you know you have 50 units of Product X. This is basic inventory management. Every POS system does this.

Batch-level expiry tracking means you know you have 30 units of Product X from Batch A (expiring June 15) and 20 units from Batch B (expiring September 30). This is what "expiry date tracking" should mean, and what most small businesses don't do.

The difference matters enormously. With product-level tracking, you might sell 10 units of Product X this week. But which 10? If your staff grabbed from Batch B (September expiry) because it was on top, the 30 units of Batch A (June expiry) are now 7 days closer to becoming waste.

Batch-level tracking ensures you always know:

  • Which units expire first
  • How many days remain for each batch
  • What your total exposure is (value of products within each expiry window)
  • Which batches need action (markdown, return, donate, dispose)

The four pillars of an expiry tracking system

Pillar 1: Capture at receiving

Every shipment that arrives must be logged with batch-specific information:

  • Product name and SKU
  • Batch or lot number
  • Expiry date (or best-before date)
  • Quantity received
  • Supplier and invoice reference

This is the foundation. If batch data isn't captured at receiving, it can't be tracked downstream. The most common failure point for small businesses isn't choosing the wrong software — it's skipping data entry at receiving because "it takes too long."

Modern systems solve this with invoice scanning: photograph the supplier's invoice, and OCR extracts every line item including batch numbers and dates. What used to take 20 minutes of manual entry takes 60 seconds.

Pillar 2: FEFO at every transaction

First-expiry, first-out (FEFO) is the rule that the batch closest to expiry gets sold first. In a well-configured system, this happens automatically at the POS — when a product is scanned, the system deducts from the nearest-expiry batch without the cashier needing to think about it.

FEFO prevents the accumulation of aging stock. Without it, newer stock naturally gets sold first (it's on top, it's in front, it's more accessible), and older stock slowly expires in the back.

Pillar 3: Tiered alerts

Different expiry windows require different actions. A product expiring in 90 days needs monitoring. A product expiring in 7 days needs immediate action. The alert system should reflect this:

  • Green zone (60-90+ days): Monitor. No action required.
  • Amber zone (15-60 days): Start clearance strategies — markdowns, bundle deals, returns to suppliers.
  • Red zone (0-14 days): Urgent. Markdown aggressively, donate, or prepare for disposal.

The alerts should arrive proactively — via email or mobile notification — not in a dashboard someone needs to remember to check.

Pillar 4: Reporting and analysis

After 3 months of batch-level tracking, the data reveals patterns:

  • Which product categories have the highest waste rates?
  • Which suppliers deliver products with shorter remaining shelf life?
  • Which days of the week do you receive the most near-expiry deliveries?
  • What is your overall recovery rate (percentage of near-expiry items saved through markdown/return vs. expired)?

These patterns inform purchasing decisions, supplier negotiations, and staffing.

Setting up expiry tracking: week by week

Week 1: Audit and baseline

Conduct a physical inventory count focused on expiry dates. For every product in your store:

  • Record the product, quantity, and expiry date
  • Calculate days remaining to expiry
  • Flag everything under 30 days as "immediate attention"
  • Sum the value of at-risk stock

This audit takes 2-4 hours for a small store (500-1,500 SKUs). The baseline number becomes your "before" metric.

Week 2: Configure your system

If you already have POS or inventory software, check whether it supports batch-level tracking. Many systems have this capability but it's not activated. Look for:

  • Batch/lot number fields on product records
  • Expiry date fields on inventory receipts
  • FEFO option in POS settings

If your current system doesn't support batch tracking, evaluate a dedicated shelf life management system that integrates with your POS.

Week 3: Start batch receiving

Beginning today, every delivery gets logged with batch and expiry data. Don't try to retroactively batch-track existing stock — that's the audit from Week 1. Focus on new receipts.

Within one product lifecycle (typically 1-6 months), your entire inventory will be batch-tracked as old stock sells through and new batch-tracked stock replaces it.

Week 4: Activate FEFO and alerts

Turn on FEFO enforcement at the POS. Configure your alert thresholds. Run your first automated expiry report.

Compare the value of at-risk stock now vs. your Week 1 baseline. The improvement starts here.

Strategies for near-expiry products

Prevention is the goal, but even the best tracking system will identify products that are approaching expiry. Here's the playbook:

Markdown pricing

The most direct approach. A product at 50% off that sells is infinitely more valuable than a product at full price that expires.

Tiered markdown schedule:

  • 30 days out: 10-15% off
  • 14 days out: 25-30% off
  • 7 days out: 40-50% off

Automate this if your POS supports it. Manual markdowns are inconsistent and often too late.

Bundle deals

Pair a near-expiry product with a popular full-shelf-life product at a combined discount. The fast-mover drives the sale, and the near-expiry product rides along.

Supplier returns

Many suppliers accept returns of near-expiry stock, typically 60-90 days before the expiry date. The key is knowing the return window for each supplier and processing returns before the deadline. Your expiry tracking system should alert you when products are approaching return deadlines — not just expiry dates.

Donation

For food businesses, donating near-expiry (but still safe) products to food banks is both socially responsible and operationally sensible. Many jurisdictions offer tax incentives for food donations. Track donations by product, quantity, and value for tax documentation.

Industry-specific considerations

Grocery and convenience stores

  • Focus categories: Dairy, bread, deli, fresh produce, refrigerated beverages
  • Key challenge: High SKU count with varying shelf lives (1 day for bread to 12 months for canned goods)
  • Critical metric: Shrink rate by category (target: under 2% for packaged goods, under 5% for produce)
  • FEFO importance: High — customers naturally select from the front of the shelf, making back-row stock vulnerable

Pharmacies

  • Focus categories: Prescription medications, OTC medicines, supplements, medical supplies
  • Key challenge: Regulatory compliance — expired drugs cannot legally be sold and require documented disposal
  • Critical metric: Expired drug write-off as percentage of purchases (target: under 1%)
  • FEFO importance: Critical — dispensing a near-expiry medication when a longer-dated batch is available is both wasteful and poor patient care

Specialty food stores

  • Focus categories: Artisan cheeses, charcuterie, specialty chocolates, imported goods, organic products
  • Key challenge: Long lead times for imported/specialty items make over-ordering tempting; many items have shorter shelf lives than mainstream equivalents
  • Critical metric: Dead stock value (products past their sell-by window even if not technically expired)
  • FEFO importance: High — premium products have premium costs; expiry waste hits margins harder

Bakeries and food service

  • Focus categories: Ingredients (flour, dairy, eggs), prepared items, display products
  • Key challenge: Multiple inventory layers (raw ingredients, work-in-progress, finished goods) each with different shelf lives
  • Critical metric: Daily waste as percentage of daily production cost
  • FEFO importance: Essential at the ingredient level — oldest flour, butter, and eggs should be used first

Common mistakes to avoid

Mistake 1: Tracking expiry dates in a spreadsheet

Spreadsheets don't enforce FEFO. They don't send alerts. They go stale the moment someone forgets to update them. They are a snapshot, not a system. Use them for the initial audit (Week 1), then move to purpose-built software.

Mistake 2: Applying FEFO to storage but not to sales

Your stockroom is perfectly organized with nearest-expiry stock in front. But your POS doesn't know about batches, so when a sale is recorded, it deducts from "inventory" generically. The stockroom looks right, but the system data diverges from reality.

Mistake 3: Setting it and forgetting it

Expiry tracking is not a one-time setup. It requires daily attention to alerts, weekly review of at-risk stock, and monthly analysis of trends. The system automates the data; the actions still require human decision-making.

Mistake 4: Over-ordering because of FOMO

Fear of stockouts drives over-ordering, which drives expiry waste. The solution is data: if your sales velocity for Product X is 5 units per week and you have 12 units with 3 weeks of shelf life, you don't need to reorder yet. The system should show this calculation and prevent impulse reorders.

Measuring success

After 3 months of batch-level expiry tracking, measure:

  • Waste reduction: Compare monthly expiry write-offs (before vs. after). Target: 50-70% reduction.
  • Recovery rate: Of products that entered the 30-day window, what percentage was sold, returned, or donated vs. expired? Target: 80%+ recovery.
  • Margin improvement: Your gross margin should improve as waste decreases. Even a 1% improvement on $500,000 in annual revenue is $5,000.
  • Time savings: How much time does your staff spend on manual shelf checks, date verification, and expiry reporting? With automation, this typically drops by 70-80%.

The technology investment

Expiry tracking solutions for small businesses range from $30-200/month depending on features and scale. At the lower end, basic batch tracking with alerts. At the upper end, full FEFO POS integration, supplier return management, demand forecasting, and multi-location support.

The ROI is straightforward: if the software costs $100/month and prevents $500/month in expiry waste, the system pays for itself 5x over.

ShelfLifePro provides batch-level expiry tracking, FEFO enforcement at the POS, automated email alerts, and compliance reporting — starting at a price point built for small businesses.

The bottom line

Expiry date tracking is not about compliance or technology. It is about money. Every product that expires on your shelf is money you paid for, stored, and then threw away. Every product saved from expiry through timely markdown, return, or sale is revenue recovered.

The businesses that track expiry at the batch level lose 0.5-1% of inventory value to expiry. The ones that don't lose 3-5%. On $100,000 in annual inventory, that is a $2,000-4,000 difference. Compounded over 5 years, it is $10,000-20,000 — the price of a store renovation, a new vehicle, or a significant equipment upgrade.

Start the stockroom audit today. The numbers will make the case for you.

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.