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.
