Skip to content

Tincture Log Template: Every Batch From Jar to Bottle

A tincture log template for an herbalist: herb and alcohol lots, ratio, strength, start and press dates, yield and bottles for every batch, with a file.

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 · 6 min read

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.

Questions people also ask

What should I record when making a tincture?

The herb and its lot, its weight, the alcohol's lot and proof, the volumes of alcohol and water, the start date, the pressing date, the volume pressed and the bottles filled.

How do I label tincture jars while they steep?

With the batch number, on the glass and on the lid. The log holds everything else.

How long should a tincture steep?

Follow your own source for the herb. The example batches sat 28 days. Whatever you choose, record the two dates so it's the same next time.

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.