Skip to content

Wine Making Log Sheet: A Cellar Record for Every Lot

A free wine making log sheet for a small winery: one row each time a lot is touched, with Brix, pH, TA, free SO2, additions with their lots, and gallons.

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 wine making log sheet is a diary for each lot of wine, with a row every time someone touches it. The row says what was done (pressed, inoculated, racked, topped, sulfited, bottled), the readings taken that day (Brix, temperature, pH, TA, free SO2), anything added with its own lot number and amount, and how many gallons the lot holds afterwards. A year later, when the 2026 Vignoles is in the glass and someone asks why it's sharper than the 2025, the log is the answer. Here's the sheet, with one lot's first two months filled in.

The short version

  • One row each time a lot is touched, not one row a lot.
  • Readings go in their own columns so they can be read down the page.
  • Every addition gets its lot number and its amount.
  • Gallons after: every drop in volume has a row that explains it.
  • TaroStack keeps the lot's gallons and what went into it, and takes additions off stock. More below.

An example: a Vignoles from press to first racking

Gasconade Hills Winery is a made-up Missouri winery I use in these examples. Its 2026 Vignoles is lot VG26-T1, in tank 1:

Date What was done Brix pH TA Free SO2 Added Gallons after
Sep 3 Pressed, settled overnight 22.4 3.28 8.1 Sulfite KMS-3381, 30 ppm 520
Sep 4 Racked off solids, inoculated 22.2 3.30 Yeast Y-2207, 1 lb 505
Sep 10 Fermenting 9.5 3.26 Nutrient N-118, 0.5 lb 505
Sep 19 Dry -1.2 3.24 7.6 Sulfite KMS-3381, 50 ppm 505
Oct 8 Racked off lees 3.25 7.5 28 480
Nov 5 Sulfite check 3.25 22 Sulfite KMS-3381, 10 ppm 480

The sheet also has columns for the temperature, who did the work and notes.

Reading it back

Volume. The lot started at 520 gallons of juice and holds 480. The log accounts for all 40: 15 gallons of solids left behind on September 4, and 25 gallons of lees on October 8. That's a 7.7% loss from juice to clean wine, a number worth having when you plan how many tons to bring in next year. And a count of 480 with no rows explaining the difference from 520 would be a question with no answer.

Sulfite. Three additions, 90 ppm in all, each with the same bag's lot. Free SO2 read 28 ppm on October 8 and 22 on November 5, so the wine used 6 ppm in four weeks, and the 10 ppm added that day brings it back. Without the two readings on the page, you'd be adding by habit.

Fermentation. From 22.2 Brix on September 4 to dry on the 19th: fifteen days, steady, no stuck ferment. If next year's takes twenty-five, you'll know it's slow because this row exists.

Additions need lots

Yeast, nutrient, sulfite, fining agents, oak. Each comes with a lot number on the package. Writing it down takes ten seconds and matters twice: when a supplier recalls something, and when a wine goes wrong and you want to know what this lot got that the others didn't. Sulfites have label rules of their own: see sulfites labeling.

Get the sheet

Download the wine making log sheet. The cellar log and a read-me. It's an ordinary Excel file with no macros, and it works in Google Sheets, LibreOffice and Numbers. Where the gallons and cases sit today is in winery inventory spreadsheet.

Where this stops working

By the second vintage there are a dozen lots, some blended into each other, and the log is hundreds of rows. Finding "everything that went into the wine in this bottle" means following a blend back through two or three lots by hand. And the sulfite you logged isn't taken off the bag in the lab, so the day you run out is a surprise.

How TaroStack does it

TaroStack keeps each lot's history with the lot, and follows it through blends.

Each step is a batch that notes its lots. Pressing turns tons of fruit into gallons of juice. An addition takes sulfite from the bag's lot. A blend takes gallons from two lots and makes a third. Bottling turns gallons into cases. Each is recorded once, the stock moves, and the record notes which lots went in, automatically.

Readings on the record. Your own fields hold Brix, pH, TA and free SO2, with initials.

Losses have reasons. Lees and topping are adjustments with a reason, so the year's losses add up to a number.

Back from the bottle. A lot's trace runs both ways: from a bottling lot to the tank, the fruit and every addition, and forward to the customers who got the cases.

The job Log sheet In TaroStack
What's in this bottle Follow blends by hand The lot's trace
Sulfite on hand Check the bag Comes off when it's added
Gallons in tank 1 The last row, if it's current The lot's balance
A year's losses Add up notes A report by reason

TaroStack doesn't write a winery's TTB reports; it keeps the working 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 records should a winemaker keep?

For each lot: where the fruit came from, every operation with its date, the readings, every addition with its lot and amount, and the volume after each step. A licensed winery has federal records to keep besides.

How often should I test free SO2?

Often enough that the reading never surprises you. Monthly during aging is a common habit, and always before bottling.

How much wine is lost between press and bottle?

In this example, 7.7% by the first racking. Your own log will give you your own figure; the costs it feeds are in winery 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.