A brew log sheet is one row for each batch, filled in over three weeks: on brew day, the malt, hops and yeast with their lot numbers, the mash temperature and the original gravity; during fermentation, the pitch temperature and the tank; at the end, the final gravity, the date it was packaged and how many gallons made it out. From the two gravities the sheet works out the alcohol. From gallons in and gallons out it works out the yield. When batch 142 tastes different from batch 141, the log is where you look. Here's one for a small brewery, filled in, with the file.
The short version
- One row a batch, started on brew day and finished at packaging.
- Write the lot of every malt, hop and yeast, and the yeast's generation.
- Record both gravities; the sheet estimates ABV as (original less final) times 131.25.
- Record gallons packaged, so the losses show.
- TaroStack records the lots a batch used when you record the brew, and takes them off stock. More below.
An example: four batches
A made-up three-barrel brewery, 93 gallons a batch:
| Batch | Beer | OG | FG | ABV | Packaged | Gallons out | Yield |
|---|---|---|---|---|---|---|---|
| B-141 | Pale ale | 1.052 | 1.011 | 5.4% | Oct 22 | 86 | 92% |
| B-142 | IPA | 1.065 | 1.012 | 7.0% | Oct 31 | 82 | 88% |
| B-143 | Oatmeal stout | 1.058 | 1.016 | 5.5% | Nov 6 | 87 | 94% |
| B-144 | Pale ale | 1.051 | In the fermenter |
The same rows carry the ingredients. For B-141:
| Malt lots | 2-row 25-0914; crystal 25-0822 |
| Mash | 152°F |
| Hop lots | Cascade H-2231; Centennial H-2207 |
| Yeast | Ale yeast A-07, generation 3 |
| Pitch | 66°F, into FV2 |
What the log tells you
Alcohol. The pale ale: 1.052 less 1.011 is 0.041, times 131.25 is 5.4%. That's the common estimate from gravities, good for a working log. Your label's figure follows your regulator's rules for how it's measured.
Yield. The IPA packaged 82 of 93 gallons, 88%, against 92% and 94% for the others. The note says why: dry hops soaked up 4 gallons more than planned. That's 4 gallons of your most expensive beer, every batch, and now it has a number. Either the recipe's batch size goes up or the price does.
Consistency. B-144 is the same pale ale as B-141, and its original gravity came in at 1.051 against 1.052. Close enough. If it had been 1.046, the first suspects are on the row: a new lot of 2-row (25-1002 instead of 25-0914) and a mash that might have run cool.
Yeast. Generation 6 on B-144. Whatever your cutoff is, the log is the only way to know you've reached it.
Lots are for the day something goes wrong
Hop and malt lots feel like paperwork until a supplier calls. A maltster recalls a lot; you type the number and need to know which batches got it and where those kegs went. With the lot on every row, that's two minutes with the filter. Without it, it's every keg since August.
The stout row has a note: contains oats. Allergen and gluten statements for beer have their own rules, and the log is where the fact starts.
Get the sheet
Download the brew log sheet. Two sheets: the log, with ABV and yield worked out, and a read-me. It's an ordinary Excel file with no macros, and it works in Google Sheets, LibreOffice and Numbers. Malt, hops and kegs on hand are in brewery inventory spreadsheet.
Where this stops working
The log says what went into B-142. It doesn't take 110 lb of 2-row off the inventory sheet, so that's a second entry somewhere else, usually skipped. And the lot numbers are only as good as the brewer's memory of which sack was opened.
How TaroStack does it
TaroStack is the brew log and the stock count in one entry.
Each beer is a recipe. The pale ale's grain bill, hops and yeast are a recipe with a batch size. Record a brew and every ingredient comes off stock, from the lot that's due first, and the batch record notes which lots were used, automatically.
Your readings go on the batch. Add your own fields to the batch record: mash temperature, original and final gravity, pitch temperature, tank. Print the form for the brew deck, with a sign-off.
Packaging is a second batch. Beer from the tank, plus kegs or cans, becomes packaged stock with its own lot, and the gallons that didn't make it show as the difference.
Yield against the recipe. From your own batch history, TaroStack shows whether a recipe yields what it claims. An IPA that keeps coming in at 88% doesn't hide.
A supplier's recall is one report. From the malt lot to the batches, to the kegs, to the accounts that got them.
| The job | Log sheet | In TaroStack |
|---|---|---|
| Malt and hops used | Written on the row | Come off stock with the batch |
| Which lot | From memory | Recorded with the batch |
| Yield, batch after batch | Work it out | Shown against the recipe |
| Where a lot ended up | Filter and read | One report |
TaroStack doesn't write a brewery's TTB reports. It keeps the records behind them. Recipes, batches and lots 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.
