The expiry tracking Excel template that does the maths for you
Batch-level rows, days-left and status formulas, colour-coded alerts, and a live value-at-risk summary — built by people who make expiry-tracking software for a living. Drop your email, get the .xlsx.
What's inside
Batch-level tracker sheet
- One row per batch — item, category, batch/lot number, quantity, unit cost, received and expiry dates
- Days-left and status columns compute themselves
- Rows turn amber at 7 days out, red once expired
- 500 rows ready to type into, sample rows show the format
Live summary tiles
- Total stock value at a glance
- Value expiring within 30 days — the ₹ number that matters
- Already-expired value (pull-now list)
- Count of items needing action today
A how-to-use sheet, honestly written
- The daily 10-minute routine that keeps it accurate
- What each status means and what to do about it
- What a spreadsheet cannot do — written plainly, because it is true
Honest note from the makers: this template works well up to a few hundred SKUs. Past that, the person maintaining it becomes the single point of failure — that's the problem our software exists to solve. The template says so on its last sheet.
Email it to me
No credit card. No sales call. Instant .xlsx + occasional expiry-management tips.
Frequently asked questions
How do I track expiry dates in Excel?
One row per batch (not per product), with an expiry-date column and a days-left formula like =ExpiryDate-TODAY(). Add conditional formatting so rows change colour as dates approach, and a status column that tells you what to do. This template has all of that pre-built.
Does the template work in Google Sheets?
Yes. Upload the .xlsx to Google Drive and open with Google Sheets — the formulas (IF, SUMIFS, COUNTIFS, TODAY) and colour rules carry over.
Is it really free? What is the catch?
Really free, and the file is not locked behind anything — we ask for an email so we can send occasional expiry-management tips (unsubscribe in one click). The honest catch is on the last sheet: a spreadsheet depends entirely on the person updating it. When that stops scaling, we would like to be the software you think of.
Prefer to understand the method first? Read why Excel-based expiry tracking eventually fails or the expiration date tracking software buyer's guide.