A cidery's stock is in three states at once. There's bulk cider: juice in tanks, fermenting or conditioning, counted in gallons by tank and by lot. There's packaging: bottles, caps, labels and empty kegs, counted by the case, box and roll. And there's packaged cider: cases and kegs in the cold room, with a lot and a date. The bulk is where the money is and where the count is hardest, because a tank isn't a number on a shelf: it's a level that falls every time you rack, filter or top up. So cidery inventory comes down to one habit, following the gallons: pressed, fermented, lost at each step, packaged. If those add up for every lot, the rest is ordinary counting. Below is a sheet for a made-up cidery in November, the gallon sum, and the file.
The short version
- Bulk cider in gallons, by tank and lot. Measure, don't estimate.
- Each pressing is a lot, and the lot follows the cider into the bottle.
- Write down every loss: lees, filter, spills, samples.
- Packaging is counted before each bottling run, not after it stops.
- Kegs: count the full ones, the empty ones, and the ones out at accounts.
- TaroStack follows each lot from pressing to case, and costs it. More below.
An example sheet
| Item | Unit | On hand | Reorder at | Unit cost | Value | Status |
|---|---|---|---|---|---|---|
| Cider in tank, fermenting | gal | 620 | $3.60 | $2,232.00 | OK | |
| Cider in tank, conditioning | gal | 580 | $3.75 | $2,175.00 | OK | |
| Bottles, 500 ml, case of 12 | case | 140 | 150 | $9.60 | $1,344.00 | REORDER |
| Labels, flagship dry, roll of 2,500 | roll | 1 | 2 | $110.00 | $110.00 | REORDER |
| Flagship dry, 500 ml, case of 12 | case | 86 | 60 | $21.40 | $1,840.40 | OK |
| Flagship dry, 1/6 bbl keg | keg | 9 | 8 | $24.80 | $223.20 | OK |
Eleven rows in all, $8,952.70 of stock. Nearly half of it, $4,407, is liquid in three tanks. Bottles and labels are flagged, and they're the ones to act on: 580 gallons are conditioning, and bottling them takes more glass than is on the floor.
Following the gallons
One lot, pressed on October 12.
| Step | Gallons | Lost |
|---|---|---|
| Juice pressed into tank 3 | 640 | |
| After fermentation, racked off the lees (Nov 9) | 580 | 60 |
| After filtering | 566 | 14 |
| Bottled: 4,200 bottles of 500 ml | 555 | 11 |
| Yield, juice to bottle | 86.7% |
The last two rows are the plan for this lot, which is still in tank 3. The first two have happened. Sixty gallons left on the lees is 9.4% of the pressing, which is ordinary for this cidery, and it knows that only because it writes the number down every time.
Why bother. Three reasons. Cost: the 580 gallons in the tank carry the cost of all 640 pressed, which is why conditioning cider is $3.75 a gallon on the sheet and fermenting cider is $3.60. Planning: a tank that will yield 555 gallons fills 350 cases, so that's the glass to order. And loss: if a lot loses 20% where the last five lost 13%, something happened, and you want to know what.
Measuring a tank. A sight glass or dip tube with a chart for that tank, a flow meter on transfers, or weight. Any of them, used the same way each time. "About two-thirds full" isn't a count.
Packaging
To bottle 555 gallons in 500 ml bottles:
| Needs | Quantity | On hand | Short |
|---|---|---|---|
| Bottles (cases of 12) | 350 cases | 140 | 210 |
| Crown caps | 4,200 | 10,000 | |
| Labels | 4,200 | 2,500 | 1,700 |
That's what the two REORDER flags mean in practice. Glass often has a lead time of weeks and a pallet minimum, so the count that matters is the one done when the cider goes into conditioning, not on bottling day.
Allow a few percent over on bottles and labels for breakage and set-up, and count what's left after the run. The difference between what you issued and what you filled is your packaging loss, and it belongs in the lot's cost.
Packaged cider, and kegs
Cases and kegs in the cold room carry the lot they came from and the date they were packaged. Ship the oldest first. A seasonal that didn't sell through is the stock to watch: in the example, 31 cases of cranberry bottled in October with a best-by in April.
Kegs are two inventories. The cider in them is product. The shells are equipment that leaves the building and is supposed to come back. Of fourteen kegs filled on November 5, nine are in the cold room and five are out at accounts. Track shells by number, with who has each: the sheet for that is in keg inventory spreadsheet.
Records the regulators want
Making and selling alcohol comes with federal and state records and reports of its own, in their own units and categories. An inventory sheet isn't a substitute for them, though the same gallon figures feed both. Ask your regulators, or someone who files for cideries, what you have to keep. The production record for each lot is in cider making log, and a plan for pulling a lot back in recall plan for a brewery, which reads across to cider.
Get the spreadsheet
Download the cidery inventory spreadsheet. Four sheets: inventory with value and a REORDER flag, lots for tanks and packaging runs with best-by dates, a count sheet to print, and a read-me. It's an ordinary Excel file with no macros, and it works in Google Sheets, LibreOffice and Numbers. A wine version is in winery inventory spreadsheet.
Where this stops working
The sheet holds one number for "cider in tank, conditioning". By December there are six lots in five tanks, two of them blended, one split between a tank and a set of barrels. Each has its own cost a gallon. A bottling run takes cider from one, glass from the pallet, labels from the roll and caps from the box, and produces cases that should carry that lot's cost. Keeping that straight in rows and columns takes longer than the bottling.
How TaroStack does it
TaroStack carries the lot and its cost from the press to the case.
Each step is a batch. Pressing makes juice. Fermenting makes cider from juice. Bottling makes cases from cider, bottles, caps and labels. Each batch notes which lots it consumed, automatically, so a case knows its tank and its pressing.
Recipes with scrap and yield. The loss on the lees and at the filter is part of the recipe, and recipe truth shows whether a lot lost what it usually does.
Cost follows the liquid. Each batch is costed from what went in, so the gallons lost are carried by the gallons left, without a sum.
"What could I make right now" says how many cases the conditioning tank, the glass and the labels allow, and which one stops you.
First expired, first out by default, with an alert before a best-by passes.
One report for a recall: which cases and kegs came from a pressing, and which accounts got them.
| The job | Spreadsheet | In TaroStack |
|---|---|---|
| Which pressing is in this case | A note, if written | On the batch records |
| Cost a gallon after losses | Worked out by hand | From the batches |
| Enough glass for the next run | Count and compare | What could I make right now |
| Who got a lot | Invoices | One report |
TaroStack doesn't file TTB reports or keep your regulators' records. Recipes, batches, lots and costing 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.
