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.
