Skip to content

Mead Making Log Sheet for a Small Meadery

A free mead making log sheet: honey by lot and pound, yeast, original and final gravity, nutrient additions, ABV worked out, racking and bottling dates.

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 mead making log sheet has one row a batch. It records the honey (which lot, how many pounds), any fruit, the yeast, the original gravity, the days nutrients were added, the racking date, the final gravity, and the bottling date and count. From the two gravities it works out the alcohol. Mead takes months, and honey changes from drum to drum, so the log is the only way to make the same mead twice. Here's a sheet for a small meadery, with three batches in it.

The short version

  • One row a batch, begun on mixing day and finished at bottling.
  • Honey gets its lot and its weight on the row. It's most of the cost and all of the character.
  • Record original and final gravity; the sheet estimates ABV as the difference times 131.25.
  • Write the nutrient schedule you followed, not the one you meant to.
  • TaroStack takes the honey off its lot when you record the batch and keeps the lots with it. More below.

An example: three batches

A made-up two-person meadery, 60 gallons a batch:

Batch Mead Honey and fruit OG FG ABV Bottles
M-031 Traditional, semi-sweet Wildflower H-0520, 180 lb 1.108 1.012 12.6% 288
M-032 Blackberry melomel Wildflower H-0520, 150 lb; blackberries BB-0702, 90 lb 1.095 1.004 11.9% 276
M-033 Session mead, dry Orange blossom H-0811, 100 lb 1.058 0.998 7.9% Not yet

Each row also has the start date, the yeast, the days nutrients went in, the racking and bottling dates, and notes.

What the numbers say

Honey per gallon sets the gravity. M-031 used 180 lb in 60 gallons, 3 lb a gallon, and started at 1.108. M-033 used 100 lb, about 1.7 lb a gallon, and started at 1.058. A new drum of honey with more water in it will come in lower at the same weight. So measure the gravity and adjust; the weight on the row tells you how much it took.

Alcohol. M-031: 1.108 less 1.012 is 0.096, times 131.25 is 12.6%. This is the working estimate from gravities. What goes on the label follows the rules of whoever licenses you.

Bottles. Sixty gallons would fill about 303 bottles of 750 ml (5.05 to the gallon). M-031 filled 288 and M-032 filled 276. The melomel lost a case more, to fruit and the extra racking. Fifteen and 27 bottles short are 5% and 9%: real money at mead prices, and invisible unless the count is written down.

Honey cost. Two batches drew 330 lb from lot H-0520. If that honey cost $5.50 a pound, that's $1,815 of one drum in 564 bottles. The lot on the row is how you'd know which bottles to look at if the beekeeper ever called about that harvest.

The parts people skip

Nutrient additions. A staggered schedule (days 1, 2, 4 and 7 here) is easy to plan and easy to miss on day 4. Write the days you really added.

Temperature swings, a stuck ferment, a bag of fruit pulled late. The notes column is for anything you'd want to know when you taste the result.

Get the sheet

Download the mead making log sheet. The log, with ABV worked out, and a read-me. It's an ordinary Excel file with no macros, and it works in Google Sheets, LibreOffice and Numbers. Counting the honey itself is in honey inventory template, and a brewer's version of this log in brew log sheet.

Where this stops working

The log knows M-032 took 150 lb of H-0520. The drum doesn't. Unless someone also updates a stock sheet, the first sign that wildflower is running out is the bottom of the drum on a mixing day. And six months on, matching a bottle on a shop shelf to its row depends on a batch code somebody remembered to print.

How TaroStack does it

TaroStack ties the log to the stock.

A mead is a recipe. Pounds of honey, gallons of water, yeast, nutrient. Record the batch and the honey comes off the lot you used, and the batch record notes it, automatically.

Your readings on the batch. Add your own fields for original and final gravity, pH and the nutrient days, with initials, and print the form for the tank room.

Bottling makes a lot. Mead from the tank plus bottles, corks and labels becomes cases with their own lot and date. A label printed from it carries the lot.

The cost is the honey's. Each batch's cost follows the lots it used, so the melomel's margin reflects 150 lb of honey and 90 lb of berries, not an average.

The job Log sheet In TaroStack
Honey left in the drum A separate count Comes off with the batch
Which honey is in this bottle Read back through the log On the batch record
What a bottle cost Work it out Follows the lots used
Bottles lost at bottling If someone counts Batch yield against the recipe

TaroStack doesn't write 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

How do you calculate the alcohol in mead?

Subtract the final gravity from the original gravity and multiply by 131.25. From 1.108 to 1.012 gives 12.6%.

How much honey goes into a gallon of mead?

It depends on the strength and sweetness you want. In these examples, 1.7 lb a gallon made a dry 7.9% session mead and 3 lb a gallon a semi-sweet 12.6%.

What does it take to open a meadery?

The licences, equipment and first-year numbers are in meadery business plan.

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.