Monday – Friday, 09:00 – 18:00 (UTC+3) WhatsApp 24/7

Expiry Date Tracking Sheet: Batches, FEFO Rank and Reorder List (Excel)

A free Excel sheet that tracks consumables batch by batch, works out status and FEFO rank from the label date and collects the items that fall to the minimum quantity into an order list; you enter the minimum quantity, order quantity and warning days.

Short answer

What is an expiry date tracking sheet, and how do you fill it in?

An expiry date tracking sheet is a list that follows consumables whose label carries a use-by / expiry or best-before date, batch by batch: each batch’s label date, the quantity left and its status for today (Expired, Expiring soon, In date) in one place. The Excel workbook below ranks the batches of the same item by label date (FEFO rank), compares the total of the batches that have not expired with a minimum quantity and collects the items that fall to it or below into an order list. You enter the minimum quantity, the order quantity and the warning days; the file suggests none of them.

Free expiry date tracking sheet (Excel)

Enter the items you track on the Items sheet and each batch’s label date and quantity left on the Batches sheet. Status, days left, FEFO rank, the Order List and the Expiry Alerts list are calculated for you; an undated batch, an item name that is not on Items and a duplicate item are flagged. Prints on A4; no sign-up.

The workbook is a recording and listing tool; it suggests no shelf life, warning days, minimum quantity or order quantity. Rows starting “EXAMPLE —” are examples and their figures are not real: clear them and enter your own records.

What the sheet is and who fills it in

With consumables such as tea, coffee, cleaning and hygiene supplies or chemicals, the same product often sits in the store in several batches with different label dates. Looking at the total is not enough; the sheet works from the quantity that has not expired (what to do with an expired batch is your organization’s decision). That is why it has two layers: the Items sheet holds each item’s rule (minimum quantity, order quantity) and the Batches sheet holds each batch’s label date and quantity left. The only link between a batch and its item is the item name: the name on Batches is written the same as on Items.

The sheet is filled in by the organization that knows its items and batches. AKSCO does not provide stock management, counting or storage services and does not hold stock; it only takes the Order List and quotes.

Items sheet: minimum quantity and order quantity

Each row is one item. Enter the item name, the group (Food/catering, Cleaning/hygiene, Chemical, Stationery/consumables, Other) and the unit. The minimum quantity is the amount you do not want to fall below; the order quantity is the amount you want to buy in one order. Your organization sets both; the file suggests no values. A blank minimum quantity makes the item show Missing data; a blank order quantity makes the suggested order show “Order qty?”.

Example rows on the Items sheet (inputs)
Item nameGroupUnitMinimum quantityOrder quantity
EXAMPLE — Filter coffee 500 gFood/cateringpack2040
EXAMPLE — Tea bags (box of 100)Food/cateringbox3060
EXAMPLE — Liquid hand soap 5 LCleaning/hygienecanister612
EXAMPLE — Surface disinfectant 1 LCleaning/hygienebottle2448
EXAMPLE — Floor cleaning concentrate 5 LChemicalcanister4blank
EXAMPLE — Instant drink powderFood/cateringboxblank24

The six EXAMPLE rows in the file (the Note, In-date quantity, Status, Suggested order and Check columns are not shown). In-date quantity and Status depend on the label dates and on the day you open the file, so they are not given here. The figures only show how the calculation works and are not recommendations. The order quantity of the concentrate and the minimum quantity of the drink powder are left blank on purpose.

Each item name must be different: leading, trailing or double spaces and upper/lower case are ignored. If the same name appears on two rows, it is flagged and both items show Missing data, so the same batches are not counted twice and no wrong order is suggested.

Batches sheet: batch, label date, quantity left

Each row is one batch; products of the same item with different label dates go on separate rows. Enter the item name (as on Items), the batch / lot number, the storage location, the date on the label and the quantity left. Enter whichever date the label carries, use-by / expiry or best-before; the file does not tell them apart. If a batch is used up, enter 0 as the quantity left.

Example rows on the Batches sheet (inputs)
Item nameBatch / lotDate on the labelQuantity leftNote
EXAMPLE — Filter coffee 500 gLOT-A1012026-08-3115
EXAMPLE — Filter coffee 500 gLOT-A1022027-02-2830
EXAMPLE — Tea bags (box of 100)LOT-B2012027-06-3045
EXAMPLE — Tea bags (box of 100)LOT-B2022027-06-3020same date
EXAMPLE — Liquid hand soap 5 LLOT-C3012027-01-154
EXAMPLE — Surface disinfectant 1 LLOT-D401blank30no date entered
EXAMPLE — Surface disinfectant 1 LLOT-D4022026-12-150quantity left 0
EXAMPLE — Floor cleaning concentrate 5 LLOT-E5012027-09-303
EXAMPLE — Unknown itemLOT-X9012027-03-315not on Items

The nine EXAMPLE rows in the file (the Storage location column is not shown; in the file the Note column starts with “EXAMPLE” or “EXAMPLE —”, shortened here). Dates are fixed in the file; days left, Status and FEFO rank are calculated for the day you open the file, so they are not given here. The figures and dates are not recommendations.

A batch with a quantity left but a blank or invalid label date is flagged and shows Date missing. A row with a blank item name or quantity left counts as an error and goes into no calculation. A batch whose item name is not on the Items sheet is flagged and counts towards no item’s in-date quantity; the reason is shown in the row’s Check column.

How the status is set

On the Batches sheet, Status follows the first rule in the order below that applies. Days left is the date on the label minus today’s date and is recalculated every time you open the file.

Batch status: first rule that applies
OrderConditionStatusNote
1Quantity left is 0Used upWhatever the date; no warning
2Label date blank or invalidDate missingNot counted in the in-date quantity; the row is flagged
3Days left below 0ExpiredThe day on the label itself does not count as past; the batch becomes Expired the next day
4Days left equal to or less than warning daysExpiring soonOnly if you have entered warning days
5OtherwiseIn date

The rule is the same as on the Batches sheet in the file. Days left 0 (the label date is today) does not count as Expired; that is this file’s rule.

Warning days is the single cell on the Summary sheet and is blank by default. How many days before the label date a batch should show Expiring soon is your organization’s decision; the file suggests no number of days. If the cell is blank, Expiring soon is not used and batches that have not expired show In date. A whole number of 1 or more is valid; if you enter 0, a decimal or text, the Status line warns and Expiring soon is not used.

The file does not say what the date on the label means or what to do with an expired batch: that decision is your organization’s. The file marks the batch as Expired, leaves it out of the in-date quantity and shows it on the Expiry Alerts list.

FEFO rank

FEFO (first expired, first out) means the batch whose date runs out first goes out first. For the same item, the file ranks the batches that have not expired (Expiring soon and In date) by label date: the earliest date is 1. Batches with the same date get the same rank and the next rank is skipped (e.g. 1, 1, 3). In the example the two tea bag batches have the same date; both are 1. Expired, undated and used-up batches are not ranked. The rank changes with the day you open the file: with the example dates, as long as 2027-02-28 has not passed, the filter coffee batch dated 2027-02-28 is 1, because the batch dated 2026-08-31 has expired.

FEFO rank is a listing: your organization decides the order in which stock is issued.

In-date quantity and suggested order

In-date quantity is the total quantity left in the Expiring soon and In date batches of the same item; expired, undated and used-up batches are not counted. If the in-date quantity is at or below the minimum quantity the item shows Reorder; if it is above, Sufficient. Suggested order = minimum quantity + order quantity − in-date quantity; the result is rounded up to a whole number.

Worked example: with a minimum quantity of 6, an order quantity of 12 and 4 left in batches that have not expired, the suggested order is 6 + 12 − 4 = 14 (these are the figures of the EXAMPLE soap row in the file, assuming the soap batch’s label date has not passed).

If the minimum quantity is blank or invalid, the order quantity is filled in but invalid, the item name is duplicated or the item has an undated batch, the item shows Missing data and no order is suggested. The logic is similar to the consumables stock card (a threshold plus an order quantity minus what is on hand); that file calculates a balance from receipts and issues, while this sheet looks at the label dates of the batches. This sheet does not count orders already placed or pack multiples: an item you have ordered shows Reorder until the new batch is entered on the Batches sheet.

Items whose status is Reorder are collected on the Order List sheet with the item name, group, unit and suggested quantity. Copy the list as values (Paste Special → Values) into an e-mail or a new sheet and add the model, packaging and the delivery date you want. The list contains no prices or brands.

AKSCO is a corporate supplier based in Türkiye that works without a catalogue and does not hold stock; it does not provide stock management, counting or storage services. We take the Order List, source the items and show the items we can quote for line by line in a written quote. On standard items we aim to quote the same business day. Custom production, imports or 50+ line lists can take longer; when they do, we tell you the timeline in writing on the day we receive the request.

We deliver across Türkiye’s 81 provinces and ship abroad under the Incoterm agreed for the order. Scope: Food & Catering Supplies, Office Kitchen & Breakroom and Cleaning & Hygiene Products. A quote request creates no obligation to order.

The Expiry Alerts list

The Expiry Alerts sheet sorts the batches whose status is Expired or Expiring soon by label date, earliest first: item, batch / lot number, storage location, date on the label, days left, quantity left and status. That way the shelves to check are on a single list. Expiring soon batches appear only if you have entered warning days. The list is rebuilt for the day you open the file, every time, so no example list is shown on this page.

What this sheet does not do

  • It suggests no values: shelf life, warning days, minimum quantity and order quantity are decisions for you or the person responsible.
  • It does not say what to do with an expired batch: that decision is your organization’s; the file only marks and lists it.
  • It is not a stock management, counting or storage service: you count and enter the quantity left yourself; to keep a balance from receipts and issues, use the consumables stock card.
  • It does not cover medicines, first aid or medical supplies. AKSCO does not supply medical devices.

Obligations on labelling, storage and conditions of use are not the subject of this sheet; ask the person responsible in your organization or your legal adviser.

Using the Excel file

  1. Items. Enter one row for each item you track; set the minimum quantity and the order quantity yourself.
  2. Batches. Enter one row for each batch: pick the item name from the list and enter the date on the label and the quantity left.
  3. Clear the EXAMPLE rows. Delete the contents of the input cells (Delete key); do not delete the row, the formulas are in it. If they are not cleared, the Status line warns.
  4. Enter warning days if you want. The cell on the Summary sheet can stay blank; if it does, Expiring soon is not used.
  5. Read the Status lines. The line at the top of each sheet counts errors and warnings.
  6. Take the lists. The Order List and Expiry Alerts are prepared automatically.

Items has 100 rows and Batches 300. If you need more, insert rows inside the table (between the first and last row) and copy the row above; Summary and the lists read the whole table, but a row added below the table is not counted (explained on the How to Use sheet). The Order List has 100 rows and Expiry Alerts 300; the Status line shows any number that does not fit. Dates are shown as year-month-day. The file sends no notification or e-mail; the warnings appear when you open it.

Frequently Asked Questions

What is an expiry date tracking sheet, and which sheets does this one have?

An Excel file that follows consumables whose label carries a date, batch by batch. The Items sheet holds the minimum quantity and order quantity, the Batches sheet each batch’s label date and quantity left; the Order List collects items whose status is Reorder and Expiry Alerts collects expired and expiring batches. Summary shows the counts and the warning days.

Should I enter the use-by / expiry date or the best-before date?

Enter whichever date is on the label; the file does not tell them apart and applies the same rule to both. Your organization decides what the date means and what to do once it has passed.

How is the FEFO rank calculated?

For the same item, the batches that have not expired (Expiring soon and In date) are ranked by label date: the earliest date is 1, batches with the same date get the same rank and the next rank is skipped (1, 1, 3). Expired, undated and used-up batches are not ranked. The rank is a listing; your organization decides the order of issue.

How many warning days should I use for Expiring soon?

The file does not suggest a number. The warning days cell on the Summary sheet is blank by default and your organization enters the value (a whole number of 1 or more). If the cell is blank, Expiring soon is not used; if you enter 0, a decimal or text, the Status line warns.

What should be done with an expired batch?

The file does not make that decision; your organization decides what to do with an expired batch. The file marks the batch as Expired, leaves it out of the in-date quantity and shows it on the Expiry Alerts list.

When does an item show Reorder, and how is the suggested order calculated?

When the in-date quantity (the quantity left in batches that have not expired) is at or below the minimum quantity, the item shows Reorder. Suggested order = minimum quantity + order quantity − in-date quantity, rounded up to a whole number; if no order quantity is entered, it shows “Order qty?”. If the minimum quantity is blank or the item has an undated batch, the item shows Missing data and no order is suggested.

Can it be used for medicines, first aid or medical supplies?

No, they are outside the scope of this file. AKSCO does not supply medical devices.

Does AKSCO hold stock, and how do I send the Order List?

AKSCO is a corporate supplier in Türkiye that works without a catalogue; it does not hold stock and does not provide stock management, counting or storage services. Send the item name, unit and quantity from the Order List through the quote request form, or e-mail the table as an Excel file; we show the items we can quote for line by line in a written quote. A quote request creates no obligation to order.

Send your list — your quote is ready within 1 business day.

A list, a photo or an Excel file — whatever is easiest. On standard items we aim to quote the same business day. Custom production, imports or 50+ line lists can take longer; when they do, we tell you the timeline in writing on the day we receive the request.