Skip to content

Laboratory Inventory List: Reagents, Lots and Expiry

A laboratory inventory list for a small lab: reagents, media, standards and consumables with lot numbers, expiry and opened-on dates, and a free spreadsheet.

By Koa Sterling. Product specialist at TaroStack and small business owner. Yes, I am a real human, and I actually sit in front of a computer and write these articles. Reviewed November 21, 2026 · 6 min read

A small lab's inventory matters for a reason an ordinary stockroom's doesn't: what's on the shelf decides whether the results can be trusted. A calibration buffer past its date, a sleeve of plates from a lot nobody recorded, a standard opened months ago, each one puts a question mark over every reading it touched. So a laboratory inventory list keeps the usual columns, what's on hand, a level to reorder at, the supplier and the location, and adds three that are the point of the exercise: the lot number, the expiry date, and the date a container was opened. Below is a list for a made-up quality lab at a small food maker, how to handle dates and lots, and the file.

The short version

  • One row for each reagent, medium, standard and consumable, in the unit you order.
  • Record the lot number and expiry of every delivery.
  • Write the opened-on date on the container and in the list.
  • Use the earliest expiry first.
  • Reorder calibration materials before they run out: without them nothing can be measured.
  • Hazardous materials have their own storage and record rules as well.
  • TaroStack keeps stock by lot and expiry, counted on a phone. More below.

An example list

Counted on a Friday.

Item Unit On hand Reorder at Unit cost Value Status
Ethanol, 70% L 12 8 $9.40 $112.80 OK
pH buffer, 4.01 500 mL bottle 3 2 $14.00 $42.00 OK
pH buffer, 7.00 500 mL bottle 2 2 $14.00 $28.00 REORDER
Plate count agar plates sleeve of 20 6 5 $31.00 $186.00 OK
Sterile sample bags box of 100 4 3 $38.50 $154.00 OK
Pipette tips, 1000 uL box of 96 14 10 $6.20 $86.80 OK

Eight rows in all, $719.10 at cost, with two to reorder: the pH 7 buffer and the water activity standard. Both are calibration materials, and that's the category to watch: they're cheap, and when they run out the pH meter and the water activity meter can't be checked, so nothing they measure can be signed off.

Lots, expiry and opened dates

Received Item Lot Quantity Expires Note
Oct 12 Plate count agar plates 2609114 6 sleeves Dec 20, 2026 Use first
Sep 3 pH buffer, 7.00 B7-3301 2 bottles Sep 30, 2027 Opened Oct 1
Aug 20 Water activity standard, 0.76 WA-5512 10 vials Aug 31, 2027

The lot number goes on the list because it goes on the result. If a batch of plates turns out to be faulty, the lot tells you which tests used it. Record the lot of the buffer or standard with each calibration too.

Two dates, not one. The expiry printed on a bottle is for the bottle unopened. Once it's open, a lab may work to a shorter clock. This lab discards opened buffer after three months. That's its own rule: use the maker's instructions for each product, and write your rule down. Then write the opened date on the bottle with a marker, and in the note column. The buffer in the example was opened October 1, so it's done on January 1, months before its printed date.

First expiry first. New deliveries go behind old ones. The file marks anything inside 60 days of its date USE FIRST. The idea is the same as in a kitchen: see FEFO vs FIFO.

What goes on a separate record

  • Instruments. A pH meter or balance isn't stock. It has a service and calibration history: see scale calibration log and equipment maintenance log template.
  • Hazardous materials. Flammables, corrosives and anything with a safety data sheet come with storage and record duties this sheet doesn't cover. Follow your safety program.
  • Samples. Retained samples have their own log, with the product lot they came from.

For a food maker, the lab's results connect to production: pH and water activity are in pH testing for acidified foods and water activity for food makers, and shelf life in shelf life testing.

Get the list

Download the laboratory inventory list. Four sheets: inventory with value and REORDER, lots with expiry dates and days left, a count sheet that works out each difference and what it's worth, and a read-me. It's an ordinary Excel file with no macros, and it works in Google Sheets, LibreOffice and Numbers.

Where this stops working

The list works when one careful person keeps it. It strains when the lot of buffer used for Tuesday's calibration has to be found from a result recorded in a different notebook, or when the same supplies are split between the lab and the production floor. The sheet knows what's on the shelf. It doesn't know which bottle was used for which reading, unless someone wrote that down too.

How TaroStack does it

TaroStack keeps lab supplies the way it keeps ingredients: by lot, with dates.

Receiving records each delivery's lot and expiry. Scanning a supplier's GS1-128 case label fills them in.

Expiry alerts come before a date arrives, and stock goes out first-expired-first-out by default.

Stock is held by location: the lab, the refrigerator, the production floor.

Batch records carry your own checklist fields, so a pH or water activity reading taken on a batch is recorded with that batch.

A reorder list in days of cover, with each supplier's lead time.

The job Spreadsheet In TaroStack
What expires in the next two months Open the lots sheet An alert
Which lot of plates is on the shelf Read the sleeve Stock by lot
The pH reading for a batch A lab notebook A field on the batch
When to reorder buffer When someone notices The reorder list

TaroStack isn't a laboratory information system: it doesn't hold test methods, results by sample or instrument records, and it has no opened-on date of its own, so keep that on the bottle and in a note. Stock, lots, expiry and reordering are on every plan, from $9.99 a month (50 items). The first 14 days are free, with no credit card. If you'd like a hand setting up, ask, and we'll do it with you.

Questions people also ask

What should a laboratory inventory list include?

Each reagent, medium, standard and consumable with its quantity, unit, reorder level, supplier and location, plus the lot number, the expiry date and the date each container was opened.

How do you track reagent expiry dates?

Record the lot and expiry of each delivery when it arrives, write the opened date on the container, use the earliest expiry first, and review what expires in the next 60 days each month.

Why record lot numbers for lab supplies?

So a result can be tied to the materials used to get it. If a lot of media or a calibration standard is found to be faulty, the lot number shows which tests it affected.

We use AI to help with the research for these articles. Every one is read, checked against its sources and edited by Koa before it's published. Spot a mistake? Tell us and we'll fix it and say so. How we write these.

Let’s get your stack in order.

Get TaroStack

Sign up now for your free 14 day trial. No credit card required.