A winery counts three different things, and a winery inventory spreadsheet has to hold all three: bulk wine in gallons, by tank and barrel and by lot; cased goods by vintage and bottling run; and dry goods, the glass, corks, capsules and labels a bottling day eats by the thousand. Each has its own unit and its own way of going wrong. Bulk shrinks a little at every racking. Cases walk out through the tasting room. Dry goods run out on the morning the mobile bottler arrives. The sheet below is filled in for a made-up Missouri winery, and you can download it.
The short version
- Bulk wine: one row a tank or barrel group, in gallons, with its lot.
- Cased goods: one row a wine and vintage, in cases, with a reorder amount that means "bottle the next lot".
- Dry goods: counted in eaches or cases, with reorder amounts set before bottling is booked.
- Write down every loss: lees, topping, breakage, tasting pours.
- TaroStack keeps each lot's gallons and cases, and what's left after every movement. More below.
An example sheet
Gasconade Hills Winery is a made-up winery in Hermann, Missouri, with a tasting room. Six of its ten rows:
| Item | Unit | On hand | Reorder at | Unit cost | Value | Status |
|---|---|---|---|---|---|---|
| Chambourcin 2025, tank 3 | gal | 620 | 0 | $9.40 | $5,828.00 | OK |
| Vignoles 2026, tank 1 | gal | 480 | 0 | $8.10 | $3,888.00 | OK |
| Norton 2024, in barrel | gal | 295 | 0 | $11.75 | $3,466.25 | OK |
| Chambourcin 2024, bottled | case | 140 | 40 | $93.72 | $13,120.80 | OK |
| Vignoles 2025, bottled | case | 32 | 40 | $88.20 | $2,822.40 | REORDER |
| Bottles, 750 ml claret | case | 210 | 120 | $9.60 | $2,016.00 | OK |
The rest are corks, capsules, labels and a bag of potassium metabisulfite. The cellar and warehouse come to $32,912.85 at cost. Two rows are red: the Vignoles 2025 cases and the capsules.
Bulk rows carry a reorder amount of zero, because you can't order more 2025 Chambourcin. For cased goods, REORDER means something else: at 32 cases, the 2025 Vignoles is nearly gone, and it's time to bottle the 2026 from tank 1.
The dry goods math
A case is 12 bottles, and a gallon fills about five 750 ml bottles (3,785 ml divided by 750 is 5.05). Tank 1 holds 480 gallons, so bottling it takes about:
| Dry good | Needed for 480 gal | On hand | Short? |
|---|---|---|---|
| Bottles | 2,424 (202 cases) | 210 cases | No, with 8 cases spare |
| Corks | 2,424 | 3,000 | No |
| Capsules | 2,424 | 2,000 | Yes, by 424 |
| Vignoles labels | 2,424 | Not yet printed | Yes |
That's a bottling day stopped by a seven-cent capsule. The sheet's reorder amount for capsules is 2,500, one tank's worth, and the row has been red since they dropped below it.
Lots and losses
The Lots sheet follows each wine from crush to case:
| Date | Item | Lot | Quantity | Note |
|---|---|---|---|---|
| Oct 4, 2025 | Chambourcin 2025, tank 3 | CH25-T3 | 650 gal | Racked twice; 30 gal lost to lees |
| Oct 12, 2024 | Norton 2024, in barrel | NO24-B1-5 | 300 gal | Five barrels, topped monthly |
| Jun 18, 2026 | Chambourcin 2024, bottled | CH24-0618 | 250 cases | Bottling run of June 18 |
The tank started at 650 gallons and holds 620. The 30 that went out with the lees is written down, with its date, because a gallon count that falls without a reason is a question you'll be asked. A bonded winery keeps records for the TTB as well, and this sheet isn't those. It's the working count behind them.
Wine has no best-by on this sheet. The date column is for the things that do fade: natural corks (use them within a year of delivery) and sulfite powder, which loses strength once the bag is open.
Get the spreadsheet
Download the winery inventory spreadsheet. Four sheets: the inventory with value and REORDER, lots, a count sheet that fills itself, and a read-me. It's an ordinary Excel file with no macros, and it works in Google Sheets, LibreOffice and Numbers. A distillery's barrel count is a different animal: see distillery inventory spreadsheet.
Where this stops working
One wine becomes three rows in a year: tank, barrel, case. Every racking, blend and bottling means lowering one row and raising another, by hand, with the loss between them. Meanwhile the tasting room sells from the same cases the restaurant accounts are promised.
How TaroStack does it
TaroStack moves the wine from row to row for you and keeps what was lost on the way.
Bottling is a batch. Set the bottled wine up as a recipe: gallons of bulk, a bottle, a cork, a capsule, a label. Record the run and the tank goes down, the dry goods go down, and the cases appear with their own lot. "What could I make right now" tells you a tank can't be bottled until capsules arrive.
Losses have reasons. An adjustment carries its reason (lost, spoiled, sample, breakage), so the year's lees and tasting pours can be reported, not guessed.
Two places, one count. The cellar and the tasting room can be separate sites, with transfers between them, on the Business plan.
The reorder list covers the dry goods. Corks and capsules show up on it before the bottler does.
| The job | Spreadsheet | In TaroStack |
|---|---|---|
| Tank to cases | Edit three rows | One batch |
| Gallons lost at racking | A note, if someone writes it | An adjustment with a reason |
| Enough capsules for the run? | Work it out | Shown before you start |
| Tasting room stock | Mixed in | Its own site |
TaroStack doesn't write TTB reports. It keeps the counts they're drawn from. Recipes, batches and lots are on every plan, from $9.99 a month (5 recipes) or $39 a month (50 recipes); a second site is on Business at $89 a month. 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.
