MarCat

Expiry date tracking in a supermarket: a simple system that works

How a supermarket keeps expired food off the shelf: reading pack dates, FEFO stacking, a monthly near-expiry walk, distributor returns and an Excel sheet.

By Swarbhanu Gupta, who has run Banjara supermarket in Ahmedabad since January 2025 (billing on MarCat since April 2026) · 13 November 2026 · updated 21 November 2026

Expired food on a supermarket shelf costs you twice. Once when you throw it away, and again when a customer finds it, because the story travels further than the pack.

A register works for a few lines. For the whole store, stock and inventory management software with batch tracking does the remembering.

Most stores do not have an expiry problem because they are careless. They have one because thousands of packs, each with a different date, arrive every week, and nobody has a simple system for watching them. This guide gives you one. It works on paper, in Excel or alongside any billing software.

Step 1: read the dates the same way every time

Food packs in India carry date marks under the FSSAI labelling rules. FSSAI allows short forms, so your staff will see different words on different brands:

On the pack Means
Mfg, Mfd, MFD Date of manufacture
Pkd, Pkg. date Date of packing
Exp, EXP, ED Expiry date
Use By, UB Use by date
BBD, Best before Best before date

Two things trip people up:

  • "Best before 9 months from manufacture." There is no date to read. You add 9 months to the Mfg date yourself. Teach every person who fills shelves to do this.
  • Date formats differ. Some packs show only month and year (MAY 2026), others day, month and year (21/05/26 or 21 MAY 2026). Read the format before reading the date.

Whatever the label, the rule at the shelf is simple: anything past its expiry or use by date comes off the shelf the same day.

Step 2: decide how closely to watch each section

Not every item needs the same attention. Split your store into three groups:

Group Examples How often to check
Short life Milk, curd, paneer, bread, eggs Every day, at opening
Medium life Biscuits, snacks, ready mixes, sauces, chocolates Every month, everything expiring in the next 60 days
Long life Rice, atta, dal, oil, detergents, toiletries Every month, everything expiring in the next 90 days

The short life group gets a daily routine because the dates are close. The other two are where stores lose money quietly, because nobody looks until it is too late.

Step 3: capture the date when the stock arrives

The easiest moment to note an expiry date is at the receiving desk, when the cartons are still sealed and in one place.

  1. Look at one pack per line on the supplier bill.
  2. Write the earliest expiry date for that line on the bill itself, next to the item, or in your sheet.
  3. Mark the carton with the expiry month in thick marker. "EXP 03/27" on the side of the box saves a search later.
  4. Check short-dated deliveries. If a pack arrives with very little life left, raise it with the delivery person before you accept it.

Step 4: stack by expiry, not by arrival

FEFO means first expiry, first out. The pack that expires first goes to the front.

Most of the time this is the same as first in, first out, because the older delivery expires first. But not always. Sometimes a newer delivery has an earlier date than the stock already on the shelf. Shelf fillers who only follow "old stock in front" will get this wrong.

So the rule for whoever fills the shelf: look at the date, not the delivery. Earliest date in front, latest at the back.

Step 5: a monthly near-expiry walk

Once a month, on a fixed date, one person walks the store with the near-expiry list:

  1. Pull the list of everything expiring in the next 60 or 90 days (see the Excel sheet below).
  2. Check each line on the shelf and in the store room. Count what is actually there.
  3. Decide for each line:
    • Return it, if the distributor's terms allow.
    • Move it to the front or to a near-the-counter spot.
    • Sell it below MRP. The MRP is the maximum price, and selling below it is allowed.
    • Bundle it with a fast seller.
  4. Write down what you did. Next month you will see which items keep coming back on the list. Those are buying problems.

Step 6: agree return terms before you need them

Returns of near-expiry or expired goods depend on your distributor. Some take them back, some exchange them, some do neither. Under GST, a supplier may issue a credit note when goods are returned to them, but whether they take the goods back is their decision.

So ask each distributor, at the start:

  • Do you take back near-expiry or expired stock? Up to how many days before expiry?
  • Is it a credit note, an exchange or nothing?
  • Who collects it, and how often?

Get the answers in writing. Then for every return, make sure you get a proper document back, so your stock and your accounts both show it.

An Excel near-expiry sheet

If your billing software does not show expiry dates, a simple sheet does the job:

A: Item B: Barcode C: Batch D: Qty E: Expiry date F: Days left
Biscuit 200 g 8901234567890 B2611 24 15/01/2027 =E2-TODAY()
Sauce 500 g 8901234567891 S0926 12 30/11/2026 =E3-TODAY()
Noodles 70 g 8901234567892 N1026 60 10/03/2027 =E4-TODAY()

How to set it up:

  1. Format column E as a date and column F as a number.
  2. In F2 type =E2-TODAY() and copy it down.
  3. Select column F, go to Home > Conditional Formatting > Highlight Cells Rules > Less Than, type 30, and choose red.
  4. Before every near-expiry walk, sort by column F, smallest first.

Add a new row for each new batch from the receiving desk. Delete rows when that batch is sold out or returned.

Where software helps

The weak point of a sheet is that someone has to type every batch and delete it when it sells out. Software that records batch, MRP and cost with every purchase, and moves stock on every sale, at least keeps the "how many are left" column right without extra typing. The date checks and the walk itself still need a person.

How MarCat handles it

We have run Banjara, our own supermarket in Ahmedabad, since January 2025, and it has billed on MarCat since April 2026. To be plain: MarCat does not send expiry alerts and does not find expiry dates on its own. It works from the expiry date you enter at purchase, and the near-expiry walk above still needs a person. What MarCat does that helps:

  • Purchase entry with batch. Every purchase moves stock automatically, with batch, MRP and cost tracking, so you know how much of each line you hold.
  • Expiry Tracker report. For stock where the batch expiry was entered at purchase, it shows the stock value expiring this week, in the next 15 days and in the next 3 months. That is your list for the near-expiry walk. More on batch and expiry billing software for supermarkets.
  • Returns to the distributor. Expired or damaged goods sent back are tracked through return settlement and credit notes.
  • Dead stock in view. Stock movement reports surface lines that stopped moving, which are often the ones that go past their date.
  • Reorder suggestions based on what has actually sold.

If you want to talk about how your store handles stock, message us on WhatsApp at +91 96787 65518.

Questions

What is FEFO in a supermarket?
FEFO means first expiry, first out. The pack with the earliest expiry date goes to the front of the shelf and is sold first, even if it arrived later than another pack.
How often should a supermarket check expiry dates?
It depends on shelf life. Milk, bread and other short-life items need a look every day. Packaged foods with long shelf life can be checked in a monthly near-expiry walk, looking at everything that expires in the next 60 days.
What do Mfg, Pkd, Exp, Use by and BBD mean on a food pack?
Mfg is the date of manufacture, Pkd the date of packing, Exp the expiry date, Use by the date by which the food should be used, and BBD the best before date. Some packs say best before a number of months from manufacture or packing, so you add the months to that date.
Can I return near-expiry or expired stock to the distributor?
Only if the distributor agrees. Many have return terms for near-expiry or expired goods. Ask for those terms in writing when you start buying, and get a credit note or a proper document for every return.
How do I track expiry dates in Excel?
Keep one row per item and batch with the expiry date. Add a column with =expiry_date-TODAY() for days left, and colour rows red when days left are under 30. Sort by days left before every near-expiry walk.