Skip to content

Cider Making Log: Gravity, pH and Additions by Lot

A cider making log for a small cidery: one row for every reading, racking and addition, from pressing to keg, with a lot followed through and an Excel file.

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

A cider making log is a cellar log: one row every time something is done to a lot or a reading is taken. Each row has the date, the lot, the vessel, what was done, the specific gravity, the temperature, the pH, anything added with its own lot and amount, and the gallons left afterwards. Read down one lot's rows and you have its whole life: the apples it was pressed from, how fast it fermented, when it was racked, what it lost, and where it ended up. Alcohol comes from the first and last gravity: (1.055 − 1.000) × 131.25 is about 7.2%. Below are the columns, one lot from press to keg, and a file.

The short version

  • One row for each action or reading, not one row a batch.
  • Every row names the lot and the vessel.
  • Gravity, temperature and pH whenever you take them.
  • Additions with their own lot numbers and amounts.
  • Gallons after every move, so losses are visible.
  • TaroStack records each step as a batch, with the lots that went in and the lot that came out. More below.

What to record

Column Why
Date The fermentation curve is gravity against dates
Lot The cider's own code, from pressing to package
Vessel Lots move; the log says where each one is
What was done Pressed, pitched, racked, blended, sweetened, kegged
Specific gravity How far the sugar has gone
Temperature Fast and hot, or slow and cool
pH Stability, and how well sulfite will work
Added (what, lot, how much) Yeast, nutrient, sulfite, sugar, each with its lot
Gallons after Lees and line losses add up
Who, notes Fruit source, smells, anything unusual

One lot, press to keg

A made-up cidery. Lot C26-04 is the fourth pressing of the 2026 season.

Date Vessel What was done Gravity Temp pH Added Gallons
Oct 12 Tank 2 Pressed and settled 1.055 52°F 3.6 Sulfite KMS-3381 260
Oct 13 Tank 2 Yeast pitched 1.055 58°F 3.6 Yeast Y-2207, 130 g; nutrient N-118, 60 g 260
Oct 20 Tank 2 Fermenting 1.030 60°F 3.5 260
Oct 30 Tank 2 Fermenting, slowing 1.004 59°F 3.5 260
Nov 6 Tank 4 Racked off the lees 1.000 55°F 3.5 Sulfite KMS-3381 248
Nov 16 Kegs Kegged: 15 half-barrels and a sixtel 1.000 50°F 3.5 237.7

The first row's note names the fruit: bins A-14 to A-19, Northern Spy and Golden Russet, from the home orchard.

What the log shows

The alcohol. Starting gravity 1.055, final 1.000: about 7.2% by the usual estimate. That's an estimate for your own use. A label needs a measured figure.

The curve. From 1.055 to 1.030 in a week, then to 1.004 in ten days more, at about 60°F. If next year's lot is at 1.040 after a week, you'll know it's behind while there's still time to warm the tank or feed the yeast.

The losses. 260 gallons pressed, 248 after racking, 237.7 into kegs. That's 22.3 gallons, 8.6%, gone to lees, lines and the filter. It's a real cost, and it's invisible unless the gallons are written after every move.

The additions. Sulfite lot KMS-3381 went in twice. If that lot turned out to be weak or mislabeled, every cider that got it is one filter away.

Blends and the lot code

When two lots are blended, the blend gets a new lot code, and its first row says what went in: "Blended: C26-04, 120 gal; C26-07, 80 gal." Don't keep either parent's code, or the log will say one cider is in two places.

The keg lot here is C26-04-K. Bottles from the same cider would be C26-04-B. The same approach for grapes is in wine making log sheet, and codes in general in how to create lot numbers.

What this log isn't

It's a working cellar log. A cidery with a federal permit keeps the records that permit requires, and this sheet doesn't replace them. Sulfite doses, sweetening and carbonation all have their own limits and methods, which aren't covered here.

Get the log

Download the cider making log. The six rows above and blank ones below, with a read-me. Filter the Lot column to read one cider from start to finish. It's an ordinary Excel file with no macros, and it works in Google Sheets, LibreOffice and Numbers. For tanks, kegs and packaging on hand, the winery inventory spreadsheet fits a cidery with little change, and the sums for an orchard are in apple orchard business plan.

Where this stops working

By December the cellar has nine lots in six tanks, two of them blends. The log has every row, in date order, all lots mixed together. Which kegs went to which taproom isn't in it at all. Tracing one keg back to its apples means filtering, then filtering again for each parent of the blend, then finding the delivery sheet.

How TaroStack does it

TaroStack keeps each step as a batch and links the lots for you.

Pressing, blending and packaging are batches. Record one and what went in comes off the lots you used, noted on the batch record automatically. What comes out is a new lot with its own code.

Blends keep their parents. A blend's batch record lists the lots that went into it, so the chain from keg to apples is kept without anyone filtering.

Your readings are fields. Gravity, temperature, pH and initials go on the batch-record form.

Additions are ingredients. Yeast, nutrient and sulfite are items with lots. Use them in a batch and the lot is recorded.

Where the kegs went. Orders record the lot shipped. One report lists the customers who got C26-04-K and what's still in your cooler.

The job Cellar log In TaroStack
What went into this lot Filter the sheet The batch's ingredients, by lot
A blend's parents A note on a row On the blend's batch record
Gallons lost Subtract row from row In against out, on each batch
Which taproom got this keg A delivery sheet One report

TaroStack doesn't file a cidery's federal reports. Recipes, batches, lots and recalls 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 cider log include?

For every action or reading: the date, lot, vessel, what was done, specific gravity, temperature, pH, anything added with its lot, and the gallons left.

How do you calculate the alcohol in cider?

A common estimate is the starting gravity minus the final gravity, times 131.25. From 1.055 to 1.000, that's about 7.2%.

How often should I take gravity readings?

At pressing, at pitching, every few days while it's active, and at each racking. More often if a tank is behaving oddly.

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.