A distilling log has one row for each run of the still. It records what was charged, in gallons and strength, and where that came from; the cuts, as gallons of heads, hearts and tails; the proof of the hearts; and where the hearts went. Everything is compared in proof gallons: gallons times proof, divided by 100. A charge of 120 gallons at 28% alcohol is 67.2 proof gallons. Hearts of 44 gallons at 138 proof are 60.72. The second over the first is the recovery, here 90%, and it's the number that tells you whether a run went the way the last one did. Below are the columns, five runs with one that came up short, and a file.
The short version
- One row a run, stripping runs included.
- Proof gallons = gallons × proof ÷ 100. Proof is twice the percent alcohol.
- Record the charge, the three cuts and the hearts' proof.
- Recovery = the hearts' proof gallons ÷ the charge's.
- Write what was charged by lot, and which barrel or tank the hearts went to.
- TaroStack records each run as a batch, with the lots in and the lot out. More below.
What to record
| Column | Why |
|---|---|
| Date, run, kind of run, spirit | A stripping run and a spirit run are read differently |
| Charge: gallons and ABV | The alcohol you started with |
| What was charged, by lot | Mash, low wines, recycled tails, neutral spirit, botanicals |
| Heads, hearts, tails (gallons) | Where the cuts were made |
| Hearts proof | Read with a hydrometer and corrected for temperature |
| Hearts proof gallons, recovery | What you kept, and its share of what went in |
| Hearts went to | The barrel or tank, by its number |
Five runs
A made-up craft distillery. On a stripping run, the "hearts" columns hold the low wines.
| Run | Kind | Spirit | Charge | Charge PG | Heads | Hearts | Proof | Hearts PG | Tails | Recovery | Check |
|---|---|---|---|---|---|---|---|---|---|---|---|
| W-411 | Stripping | Bourbon | 300 gal at 8.5% | 51.00 | 88 gal | 56 | 49.28 | 96.6% | OK | ||
| S-311 | Spirit | Bourbon | 120 gal at 28% | 67.20 | 2.5 gal | 44 gal | 138 | 60.72 | 9 gal | 90.4% | OK |
| S-312 | Spirit | Rye | 115 gal at 27% | 62.10 | 2.5 gal | 40 gal | 140 | 56.00 | 8 gal | 90.2% | OK |
| S-313 | Spirit | Gin | 60 gal at 45% | 54.00 | 1 gal | 30 gal | 162 | 48.60 | 4 gal | 90.0% | OK |
| S-314 | Spirit | Bourbon | 118 gal at 28% | 66.08 | 2.5 gal | 38 gal | 137 | 52.06 | 14 gal | 78.8% | LOOK |
The run that came up short
Three spirit runs recovered 90%. S-314 recovered 78.8%, and the sheet flags it. The row explains it: tails were 14 gallons where the others were 8 or 9. The cut to tails was made early, and the alcohol that would have been hearts is in the tails tank. It isn't lost, because those tails go into the next spirit run, as the note says. But barrel B-113 got 52 proof gallons and not 59, and the log is why nobody has to wonder about a leak.
When recovery is low and the tails aren't high, look elsewhere: a wrong reading on the charge, a hydrometer read warm and not corrected, or vapor going somewhere it shouldn't.
Follow the lots
Whiskey passes through several containers before it's a bottle, and each step needs a name.
| Step | Its own number | What it records |
|---|---|---|
| Mash | M-0611 | Grain lots, yeast lot |
| Stripping run | W-411 | The mash it stripped |
| Spirit run | S-311 | The low wines and tails it was charged with |
| Barrel | B-112 | The run that filled it, the date, the entry proof |
| Bottling | A bottling lot | The barrels dumped |
With those links, a problem with a lot of rye can be followed forward to barrels and bottles, and a bottle can be followed back. Barrel stock is in distillery inventory spreadsheet. The difference between a batch number and a lot number is in batch number vs lot number.
What this log isn't
It's a production log. A distillery with a federal permit also keeps the records and files the reports its permit requires, and this sheet doesn't replace them. It can agree with them, and it should: the proof gallons here are the same proof gallons.
Get the sheet
Download the distilling log sheet. One row a run; proof gallons and recovery work themselves out, and the check says LOOK under the recovery you set on the Limits sheet. It's an ordinary Excel file with no macros, and it works in Google Sheets, LibreOffice and Numbers. For the fermenting side, the brew log sheet has gravity readings by batch.
Where this stops working
The log ends when the hearts leave the still. Barrel B-112 then sits for four years. In that time it's moved, sampled, topped up and finally dumped with five others into a bottling. The still log can't follow it, and by then the corn lot that started it is a line on a page nobody has opened since.
How TaroStack does it
TaroStack keeps each step as a batch and links them by lot.
Mash, stripping, spirit run, bottling: each is a batch. Recipes can contain other recipes, so the low wines from one batch are an ingredient of the next. Record a batch and the lots it used are noted automatically.
Your own fields. Charge strength, the cuts, hearts proof and proof gallons go on the batch-record form, with initials.
Every barrel is a lot. It has a code, a date and a place, and a transfer moves it between sites.
The trace runs both ways. From a grain lot forward to barrels and bottles, and from a bottle back, in one report.
Cost follows the lots. Each batch is costed from what went into it, so a barrel carries its real cost.
| The job | Still log | In TaroStack |
|---|---|---|
| What was charged | Written on the row | The batch's ingredients, by lot |
| Cuts and proof | Columns | Fields on the batch record |
| Where the hearts went | A barrel number | A lot, with its place |
| Grain to bottle | Five notebooks | One report |
TaroStack doesn't write TTB reports or gauge spirits. Recipes, batches and lots are on every plan, from $9.99 a month (5 recipes) or $39 a month (50 recipes); more than one site starts at $89 a month. 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.
