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.
