How is the action chosen?

By the days left until expiry: the “Soon” and “Critical” thresholds and their discounts are set in “Settings”. Expired batches go to the write-off list.

Is the cost of losses calculated?

Yes, the summary shows the purchase value of goods at risk and of expired goods.

No, batches are recorded by product name and delivery number.

No. The file works in Excel 2007 and newer and in LibreOffice, and all calculations use ordinary formulas.

← All templates

Product Expiry Date Tracker — Excel Template

Track product batches and their expiry dates: what to sell first, what to mark down and what to write off. An “Act today” list and a loss summary.

390 ₽

≈ 4 USD

Blank template + filled-in example · Excel 2007+, LibreOffice, Google Sheets

Payment is processed securely by YooKassa in Russian rubles. If your card is declined, email us at info@хижняков.рф and we will arrange another way to pay.

What it is for

In a shop or warehouse, goods spoil if the expiry date is not noticed in time. The template tracks batches, counts the days left until expiry, sets a status (“Soon”, “Critical”, “Expired”) and suggests a discount for markdown.

What is inside

“Settings”: how many days before expiry count as “Soon” and “Critical” (14 and 3 by default) and the discount for each status.
“Batches”: product, category, batch, quantity, purchase and selling price, expiry date; days left, status, discount and discounted price are calculated automatically.
“Act today”: an automatic list of batches that should be marked down or written off, with the discount and the amount at risk.
“Summary”: how many batches are expired, critical and soon to expire, the value of goods at risk, a chart.

Who it suits

Shop owners, warehouse managers, and sellers of food, cafés and pharmacies who watch expiry dates.

Compatibility

Excel 2007 and newer, LibreOffice. No macros. The file is in English. Rates, thresholds and reference values are set in the parameters: check them against current rules before use. The calculation is approximate.

Questions and answers

How is the action chosen?: By the days left until expiry: the “Soon” and “Critical” thresholds and their discounts are set in “Settings”. Expired batches go to the write-off list.
Is the cost of losses calculated?: Yes, the summary shows the purchase value of goods at risk and of expired goods.
How many batches can I track?: Up to 300 batches.
Is a barcode needed?: No, batches are recorded by product name and delivery number.
Are macros needed?: No. The file works in Excel 2007 and newer and in LibreOffice, and all calculations use ordinary formulas.