Skip to content

Wine Inventory Spreadsheet: Bins, Vintages, by the Glass

A wine inventory spreadsheet for a restaurant, wine bar or shop: a row for each wine and vintage, bin numbers, pars, glasses from a bottle, and a free 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 21, 2026 · 6 min read

Wine is easy to count and easy to get wrong, because two bottles that look the same aren't. A wine inventory spreadsheet has a row for each wine and vintage: the 2023 and the 2024 of one Chardonnay cost differently and may sell at different prices, so they're two rows. Each row has a bin or shelf, the bottles on hand, what a bottle cost, and a par, the number you want on hand before the weekend. A restaurant or wine bar adds one more job. Wine poured by the glass leaves in fifths of a bottle, so open bottles are counted in tenths and compared with what the till says was sold. Below is a sheet for a made-up wine bar, the by-the-glass sums, and the file. A winery's own stock, in tanks and barrels, is a different sheet: see winery inventory spreadsheet.

The short version

  • One row for each wine and vintage. A new vintage is a new row.
  • Give every row a bin or shelf, and list the rows in walking order.
  • Reorder at the par: what you want on hand going into your busiest days.
  • A 750 ml bottle is five 5 oz glasses.
  • Count open bottles in tenths.
  • Compare bottles used with bottles sold. The gap is over-pours, comps and breakage.
  • TaroStack keeps stock by place and counts it on a phone. More below.

An example sheet

Counted on a Monday before opening.

Item Unit On hand Reorder at Unit cost Value Status
Pinot Noir, Willamette Valley 2022 bottle 18 12 $21.00 $378.00 OK
Cabernet Sauvignon, Napa 2020 bottle 9 12 $46.00 $414.00 REORDER
Chianti Classico 2021 bottle 14 12 $17.50 $245.00 OK
Sauvignon Blanc, Marlborough 2024 bottle 22 18 $12.00 $264.00 OK
Chardonnay, Sonoma 2023 bottle 16 12 $19.00 $304.00 OK
Riesling, Mosel 2023 bottle 7 6 $16.00 $112.00 OK

Ten rows in all, $2,461.00 at cost, with four to reorder: the Cabernet, the Prosecco, the Champagne and the rosé. Reds are $1,037.00 of it, whites $680.00, sparkling $494.00.

Vintages. When the distributor's delivery brings the 2024 where the 2023 used to be, add a row. Don't overwrite the old one. The list price may need to change, the cost almost certainly did, and a guest who ordered the 2023 should be told. The file's deliveries sheet has a note column for exactly this.

Bins. A bin number on the row and on the shelf turns a count from a search into a walk. It also lets someone who doesn't know the wines pull the right bottle.

Par. The reorder level is this bar's par for each wine, set from what a busy week sells. Nine bottles of the Cabernet against a par of twelve is a reorder, even though nine sounds like plenty. The difference between a par and a reorder point is in par level vs reorder point.

By the glass

Sauvignon Blanc House red, 3 L box
Size 750 ml, 25.4 oz 3 L, 101.4 oz
Glasses at 5 oz 5 20
Cost $12.00 $24.00
Cost a glass $2.40 $1.20
Price a glass $12.00 $9.00
Pour cost 20.0% 13.3%

The prices are this bar's own. The sum is what carries over: a bottle's cost divided by the glasses it pours. A 6 oz pour gets four glasses from the same bottle, and the cost a glass goes from $2.40 to $3.00. Setting list prices is in how to price a wine list.

Open bottles are counted in tenths: a bottle with two glasses gone is 0.6. It feels fussy and it matters, because the by-the-glass wines are the ones that move.

Used against sold

Once a month, for each wine by the glass:

Sauvignon Blanc Bottles
Opening count 14.0
Received 24.0
Closing count 22.0
Used: opening + received − closing 16.0
Sold, from the till: 62 glasses and 3 bottles 15.4
Difference 0.6

Sixty-two glasses is 12.4 bottles at five to the bottle, plus three sold whole. The 0.6 of a bottle that was used and not sold is three glasses, $7.20 at cost: a heavy pour here, a taste for a regular there. A small gap is the cost of hospitality. A gap that grows is worth watching a shift for. The same check for spirits is in bar inventory spreadsheet, and for a shop in liquor store inventory.

Get the spreadsheet

Download the wine inventory spreadsheet. Four sheets: inventory with value and REORDER, deliveries by invoice with a note for vintage changes, a count sheet that works out each difference and what it's worth, and a read-me. It's an ordinary Excel file with no macros, and it works in Google Sheets, LibreOffice and Numbers.

Where this stops working

A list of ten wines fits a sheet. A list of eighty, across a cellar, a cooler and the bar, with vintages rolling over through the year, is three counts and a lot of retyping. The sheet is right on Monday. On Saturday night the server finds out the Cabernet is gone by walking to bin 14.

How TaroStack does it

TaroStack keeps each place's stock, between counts.

Stock is held by location: the cellar, the cooler and the bar each have their own quantity.

Receiving adds each delivery, with or without a purchase order, at the price on that invoice.

Counting works on a phone with no signal, in a cellar. A count shows what each difference is worth.

A reorder list in days of cover, with each distributor's lead time and minimum.

Every adjustment carries a reason: corked, broken, comped.

The job Spreadsheet In TaroStack
What's in the cellar and what's at the bar One number, or two tabs Stock by location
What a bottle costs now The last price typed From the last delivery
What the count found Typed in afterward Counted on the phone, valued
What to order from each distributor Rows under par A reorder list by supplier

TaroStack doesn't run the till or count glasses poured. It connects to Square. Stock, counts, receiving and reordering are on every plan, from $9.99 a month (50 items) or $39 a month (3,000 items). 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 you keep track of wine inventory?

Give each wine and vintage its own row, with a bin, the bottles on hand, the cost and a par. Count on the same day each week, open bottles in tenths, and compare what was used with what was sold.

How many glasses of wine are in a bottle?

Five, at a 5 oz pour: a 750 ml bottle holds 25.4 oz. At 6 oz it's four. A 3 liter box holds 101.4 oz, or twenty 5 oz glasses.

Should each vintage be a separate inventory item?

Yes. The cost changes from one vintage to the next, and the list price and the guest's expectation may too. Add a row when a new vintage arrives, and keep the old row until its bottles are gone.

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.