Skip to content

Brew Log Sheet for a Small Brewery (Free Template)

A free brew log sheet for a nano or small brewery: malt, hop and yeast lots, mash and pitch temperatures, gravities, ABV worked out, and gallons packaged.

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

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.

Questions people also ask

What should a brew log include?

The date, batch number, recipe, ingredient lots, mash and pitch temperatures, original and final gravity, the tank, and the date and volume packaged.

How do you calculate ABV from gravity?

Subtract the final gravity from the original and multiply by 131.25. From 1.052 to 1.011 is 5.4%.

What is a good brewhouse yield?

It depends on the beer. Compare each batch with your own earlier batches of the same recipe; the method is in batch yield formula. Software choices are in brewery inventory management software.

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.