Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesOperations & Supply ChainSpecialized InventoryBatch & Expiry Date Tracker

SpreadsheetSpecialized InventoryFree

Batch & Expiry Date Tracker

Track every lot with its expiry date, days left and what to use, discount or dispose of first.

Shown with sample data

Colour

Batch & Expiry Date Tracker

Track every lot with its expiry date, days left and what to use, discount or dispose of first.

Batches expiring in 14 days
3
Expired batches
1
Value at risk
$350.20
Value at risk by category
  • Supplements$198
  • Chilled$124.20
  • Ambient$28
Share of value at risk by category
  • Supplements$19857%
  • Chilled$124.2035%
  • Ambient$288%

How to use it

  1. 1Add a row when each batch is received.
  2. 2Pick from the batch with the fewest days left.
  3. 3Discount or move stock flagged Expiring soon.
  4. 4Remove and record anything Expired.

In this workbook

  • About
  • What’s included
  • How to use
  • Related resources

About this template

First expired, first out, made easy. Record each batch with its lot number, quantity and expiry date; the sheet counts the days left, flags stock that is expiring soon or already expired and values what is at risk so you can act before it is written off.

Who it’s for

  • Food, drink and supplement stock
  • Medicines and medical consumables
  • Traceability if a batch is recalled

What’s included

  • Batches sheet: One row per batch.
  • Summary by Category sheet: Value at risk and Qty and the number of entries for each category, calculated from the Batches sheet.

How to use it

  1. 1Add a row when each batch is received.
  2. 2Pick from the batch with the fewest days left.
  3. 3Discount or move stock flagged Expiring soon.
  4. 4Remove and record anything Expired.
Related searchesexpiry trackerbatch trackinglot numberfefoshelf life

Details

Format
Spreadsheet
Category
Specialized Inventory
Sheets
2
Setup
10 min
Level
Beginner
Price
Free

Download a copy

Downloads need a free account.

SpreadsheetSpecialized InventoryFree

Batch & Expiry Date Tracker

Track every lot with its expiry date, days left and what to use, discount or dispose of first.

A free account keeps your copy safe so you can come back to it. Have one? Log in

Download a copy

Downloads need a free account.

Details

Format
Spreadsheet
Category
Specialized Inventory
Sheets
2
Setup
10 min
Level
Beginner
Price
Free

Your copy is private to you.

More specialized inventory templates

View all
Bill of Materials & Product Cost Sheet2 sheets

Cost per unit

$8

Gross margin

45%

Price for target margin

$19

ABCD
1ComponentTypeUnitQty per unit
2Soy waxMaterialkg0.22
3Fragrance oilMaterialml18
4Cotton wickMaterialeach1
5Glass jar 220mlPackagingeach1
Bill of materials
SpreadsheetSpecialized Inventory

Bill of Materials & Product Cost Sheet

List every component of a product with quantity, waste and cost to get a true unit cost and margin.

10 min setupPreview
Tool & Equipment Checkout Log2 sheets

Items out now

3

Overdue

3

Returned needing attention

1

ABCD
1ItemAsset tagCategoryTaken by
2Hammer drillPT-014Power toolsMarco D.
3Laser levelTE-003Test equipmentAsha P.
4Torque wrenchHT-022Hand toolsSam K.
5Angle grinderPT-009Power toolsJordan L.
Checkout log
SpreadsheetSpecialized Inventory

Tool & Equipment Checkout Log

Sign tools and equipment out and back in, and see what is overdue and who has it.

10 min setupPreview

Practical guides and new resources, monthly.

One short email with new templates, calculators and how-tos. Unsubscribe any time.

GraviPointThe Centre of Productivity

Find the right resource. Make it work for you. Get things done with spreadsheets, documents, forms and calculators you can use right in your browser.

support@gravipoint.com
  • @gravipoint
  • @GraviPoint
  • GraviPoint
  • 𝕏@gravipoint

Templates

  • All templates
  • Budgets & expenses
  • Invoices & billing
  • Project management
  • HR & people
  • Inventory & stock
  • Sales & CRM
  • Financial calculators

Popular

  • Monthly budget
  • Invoice
  • Employee shift schedule
  • Weekly timesheet
  • Project plan & Gantt chart
  • Inventory tracker
  • Expense report
  • Mortgage calculator

Solutions

  • Individuals & households
  • Freelancers & consultants
  • Founders & startups
  • Small business owners
  • Teams & operations
  • Students & educators

Company

  • About
  • Features
  • Pricing
  • Community
  • Journal
  • Contact
© 2026 GraviPoint. All rights reserved.
  • Privacy
  • Terms
  • Help centre
  • FAQ