Skip to content

Apothecary Inventory Template: Herbs by Lot and Date

A free apothecary inventory template for an herbal business: dried herbs by the pound with supplier lots and best-by dates, bases, bottles, finished stock.

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 19, 2026 · 5 min read

An apothecary's shelf is dozens of jars that look alike, bought from different suppliers in different years, some grown in your own garden. An apothecary inventory template gives each herb a row with the pounds on hand, a reorder amount and a cost, and then does what the jar's label usually doesn't: records which lot each bag was, where it came from and when it should be used by. When you make a syrup or a salve, the lots that went in get written on the batch. That chain, from the wholesaler's bag to the bottle a customer holds, is what makes it a business. A filled-in example and the file are below.

The short version

  • Herbs in pounds (or ounces for the costly ones), one row each.
  • Every bag received gets a row: supplier, lot, date, best-by.
  • Garden-grown herbs get a lot too: the plant and the day it was picked.
  • Bases, bottles and tins on the same sheet.
  • TaroStack records the herb lots in every batch you make. More below.

An example sheet

Elder & Oak Apothecary is a made-up Pennsylvania herbal business making teas, salves and elderberry syrup. Six of its ten rows:

Item Unit On hand Reorder at Unit cost Value Status
Elderberries, dried lb 14 10 $16.50 $231.00 OK
Peppermint leaf, cut lb 6 4 $11.00 $66.00 OK
Calendula flowers lb 3 3 $22.00 $66.00 REORDER
Chamomile flowers lb 5 4 $19.50 $97.50 OK
Beeswax pastilles lb 9 5 $9.80 $88.20 OK
Olive oil gal 3 2 $31.00 $93.00 OK

Honey, amber bottles, tins and 62 bottles of elderberry syrup make ten rows and $1,313.40. Calendula is at its reorder amount, and since it comes from the garden, "reorder" means it has to last until July or be bought in.

The lots sheet

Received Item Lot Quantity Best by Note
Sep 9 Elderberries, dried EB-24-7716 25 lb Sep 30, 2027 Certificate of analysis on file
Jul 22 Calendula flowers CAL-0722 4 lb Jul 22, 2027 Picked and dried in July
Mar 3 Peppermint leaf, cut PM-24-1150 11 lb Dec 15, 2026
Nov 10 Elderberry syrup, 4 oz ES-1110 96 Feb 10, 2027 Elderberries EB-24-7716

Three things to notice.

The wholesaler's lot is on the bag and often on a certificate of analysis they'll send if you ask. Keep the certificate with the row. Imported botanicals do get recalled, and that lot number is how you'd know if yours is one.

The garden calendula has a lot you made up: CAL-0722, picked July 22. It deserves the same row as a purchased herb.

The syrup's row names the elderberry lot it was made from. Ninety-six bottles, batch ES-1110, three months refrigerated on this maker's own shelf-life judgment. If EB-24-7716 is ever a problem, you know which bottles.

The sheet flags the peppermint from March as USE FIRST inside 30 days of its date.

A word on what you can say

How you describe an herbal product decides how it's regulated. A tea sold as a tea is a food. The same herbs sold with a claim to treat something are another matter. That's beyond this template; a starting point is structure function claims and, for batch paperwork, herbal products batch record.

Get the template

Download the apothecary inventory template. Four sheets: inventory with value and REORDER, lots with days left, a count sheet that fills itself, 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

Thirty herbs, six products, small batches every week. Each batch draws a few ounces from several jars, and the lot numbers have to be copied from the lots sheet onto the batch notes by hand. It's the copying that fails, usually on the busiest day.

How TaroStack does it

TaroStack copies the lots for you.

Each product is a recipe. Elderberry syrup: berries, honey, water, a bottle, a label. Record a batch of 96 and the ingredients come off stock from the lot due first. The batch record notes which lots were used, automatically.

Garden herbs are received too. Receive your own calendula with no supplier and your own lot, at a cost you set.

Dates watched. Lots near their best-by are flagged, and stock is used first-expired-first-out.

Your checks on the batch. Add fields of your own (pH, simmer time, a label check) with initials.

One report. From a wholesaler's lot to every batch it went into and every customer who got a bottle.

The job Template In TaroStack
Lots in a batch Copied by hand Recorded with the batch
Ounces left in each jar Subtract after each batch Come off as you make
Herbs near their date Read the sheet An alert
Who got batch ES-1110 Order emails One report

Recipes, batches, lots and recalls are on every plan, from $9.99 a month (5 recipes) or $39 a month (50 recipes). 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

How do herbalists keep track of inventory?

A row for each herb with the weight on hand, and a row for each bag or harvest with its lot, source and date. Batches record which lots they used.

How long do dried herbs last?

Stored airtight, cool and dark, most keep their quality for a year or two; flowers and leaves fade faster than roots and berries. Use the supplier's date and the oldest lot first.

Do I need lot numbers for herbal products?

If you sell them, yes in practice: it's the only way to trace a problem to one batch. More in how to create lot numbers.

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.