Skip to content

Winery Inventory Spreadsheet: Bulk, Cases, Dry Goods

A winery inventory spreadsheet for a small producer: bulk wine by tank and barrel in gallons, bottled cases by lot, corks, capsules and labels, with reorders.

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 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.

Questions people also ask

How do wineries keep track of inventory?

In three parts: bulk wine by vessel and lot in gallons, bottled wine by cases, and dry goods. Each movement between them is written down with any loss.

How many bottles are in a gallon of wine?

About five 750 ml bottles, so a 60-gallon barrel fills roughly 300 bottles, or 25 cases.

What does a small winery cost to run?

The numbers for this example winery, tasting room included, are in winery business plan, and a retail shop's in wine shop 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.