Expiry Date Tracker (Supermarkets, Perfume & Cosmetics) – Free Excel Template for Retail Stores
Sell it before it expires – not after. Track every batch by expiry date. The sheet counts the days left, colours items Expired / Sell now (≤30 days) / Watch (≤90 days) / OK, and calculates the money...
Sell it before it expires – not after. Track every batch by expiry date. The sheet counts the days left, colours items Expired / Sell now (≤30 days) / Watch (≤90 days) / OK, and calculates the money at risk so you can discount, move to the front or return to the supplier in time.
Table Of Content

Why it matters
Store operations are a chain of small routines – opening checks, stock counts, rosters, deliveries, expiry dates. When one routine is skipped, customers notice: empty shelves, expired products, slow service. A simple shared sheet turns these routines into habits that every branch follows the same way.
What’s inside the template
You fill in: SKU / Barcode, Product, Category, Branch, Batch / Lot, Qty, Unit Cost, Expiry Date, Action, Notes.
Calculated automatically:
- Days Left
- Status
- Value at Risk – Qty × cost for items expired or within 30 days
How to use it, step by step
- Record each product batch with its quantity, cost and expiry date.
- Sort or filter by Days Left every Saturday.
- Choose an action for every red/yellow line and update the quantity after selling.
- Many suppliers accept returns 60–90 days before expiry – check your agreement.
The dashboard: numbers to watch
- Batches tracked
- Expired
- Sell now (≤30 days)
- Value at risk
Summary tables: Batches by expiry status, Value at risk by category.
Example from the template
| SKU / Barcode | Product | Days Left | Status | Value at Risk |
|---|---|---|---|---|
| 6281007030011 | Fresh yogurt 1 kg | 8 | Sell now | 70,000 |
| 3614272049529 | Eau de parfum 100 ml | 79 | Watch | – |
| 5000159407236 | Chocolate bar 50 g | 201 | OK | – |
Download the template free
Free, no registration. Two versions: English and Arabic (right-to-left). Works in Excel, Google Sheets and WPS.
Browse all 60 templates in the ProSite Library
Need help running your store?
ProSite fits out, opens and runs retail stores in Baghdad and Erbil – store fit-out, visual merchandising, operations teams, IT setup and manager training. Call or WhatsApp us on +964 780 930 9998.




[…] Stores Retail Staff Performance Appraisal (KPI Score) – Free Excel Template for Retail Stores Expiry Date Tracker (Supermarkets, Perfume & Cosmetics) – Free Excel Template for Retail Stor… Home/Retail Guides/New Store Opening Plan & Countdown – Free […]