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.
