A tincture log has one row for each batch, and the row stays open for weeks. On the day you start, it records the herb, its lot and supplier, its weight, the alcohol's lot and proof, and the millilitres of alcohol and water. From those it works out the ratio and the strength you really made, which aren't always the ones you meant. On the day you press, it takes the date, the volume that came out, the bottles filled and the lot code on them. The log matters because of the gap between those two days: four weeks is long enough to forget everything that isn't written down. Below are the columns, four batches, and a file that does the sums.
The short version
- One row a batch, started the day the herb goes in the jar.
- The herb's lot and the alcohol's lot, written that day.
- Weights and volumes as measured, not as planned.
- The jar's label carries the batch number, and nothing else has to.
- On pressing day: date, volume out, bottles, bottle lot.
- TaroStack records each batch with its lots and holds it until it's pressed. More below.
What to record
| Column | When | Why |
|---|---|---|
| Date started, batch | Start | The batch number goes on the jar |
| Herb, its lot and supplier | Start | A problem with the herb is traced through this |
| Herb weight (g) | Start | The first half of the ratio |
| Alcohol lot and proof | Start | The strength sum depends on the proof |
| Alcohol and water (mL) | Start | The second half of the ratio |
| Ratio and strength | Worked out | What you actually made |
| Jar | Start | Where it is |
| Date pressed, days | Pressing | How long it sat |
| Pressed out (mL), yield | Pressing | What the herb gave back |
| Bottles, bottle lot | Pressing | What's on the shelf, and its code |
Four batches
A made-up herbal apothecary. The suppliers are invented.
| Batch | Started | Herb, lot | Herb | Alcohol, 190 proof | Water | Ratio | Strength | Pressed | Days | Out | Yield | Bottles |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| T-1006 | Oct 6 | Echinacea root, ER-2291 | 500 g | 1,315 mL | 1,185 mL | 1:5 | 50% | Nov 3 | 28 | 2,125 mL | 85% | 70 |
| T-1013 | Oct 13 | Lemon balm leaf, LB-2302 | 300 g | 632 mL | 868 mL | 1:5 | 40% | Nov 10 | 28 | 1,140 mL | 76% | 38 |
| T-1020 | Oct 20 | Valerian root, VR-2310 | 400 g | 1,263 mL | 737 mL | 1:5 | 60% | Nov 17 | 28 | 1,720 mL | 86% | 57 |
| T-1103 | Nov 3 | Echinacea root, ER-2325 | 500 g | 1,315 mL | 1,185 mL | 1:5 | 50% | steeping |
What the log shows
Yield differs by herb. The roots gave back 85% and 86% of their liquid. The leaf gave back 76%. Plan lemon balm bottles on the root's number and you're short every time. After a few batches of each herb, the log has your own figure.
Two echinacea batches, two herb lots. T-1006 used ER-2291 and T-1103 used ER-2325. On the shelf the bottles look identical. If the supplier writes about ER-2291, the log says it's lot EC-1103, 70 bottles, and nothing else.
The strength is worked out, not assumed. The sheet takes the proof and the two volumes you typed and gives the real figure. Type 1,215 where 1,315 was meant and it shows 48%, on the day, while it can still be fixed.
The sums behind the amounts are in tincture batch calculator.
The jar label
The label on the jar needs the batch number and nothing more, because the log has the rest. Write it on tape on the glass and again on the lid. Alcohol dissolves some inks and some glue, so use a marker that survives a spill, and keep the tape away from the rim.
From the log to the bottle
The bottle's lot code is the last column. EC-1103 says echinacea, pressed November 3. That code leads back to one row, and the row leads to the herb's lot, the alcohol's lot and the dates. A fuller record for products sold as supplements is in herbal products batch record, and the label itself in dietary supplement labeling requirements. Those rules aren't covered here.
Get the template
Download the tincture log template. One row a batch; ratio, strength, days and yield work themselves out. It's an ordinary Excel file with no macros, and it works in Google Sheets, LibreOffice and Numbers. For herbs, alcohol and bottles on the shelf, see apothecary inventory template.
Where this stops working
The log is good at one batch. It's poor at the questions that cross batches. How much echinacea root is left, and from which lot? Which bottles on the shelf are oldest? Who bought EC-1103? Each answer is in a different notebook, and the log's row has to be matched to it by hand.
How TaroStack does it
TaroStack keeps the batch, the herbs and the bottles in one record.
Each tincture is a recipe. Herb by the gram, alcohol and water by the millilitre, with versions kept when the ratio changes. Units convert, so alcohol bought by the gallon comes off stock by the millilitre.
Recording the batch notes the lots. The herb's lot and the alcohol's lot go onto the batch record automatically.
On hold while it steeps. A batch on hold is kept out of what you can sell until you release it.
Your own fields. Jar, date pressed, volume pressed and initials go on the batch-record form.
Bottles carry a lot and a date. The soonest to expire sells first, and orders record which lot each customer got.
| The job | Tincture log | In TaroStack |
|---|---|---|
| Herb and alcohol lots | Written at the start | Noted on the batch automatically |
| Still steeping | An open row | On hold |
| Herb left, by lot | Another notebook | Stock on hand |
| Who bought EC-1103 | The sales book | 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.
