Start free

Wine Inventory: Spreadsheet, App and Routine

By mise · Updated October 7, 2026

Quick answer: wine inventory is counted by full bottle and, for wines by the glass, by tenths of an open bottle; valued at cost and compared with sales to find what is missing. High-value bottles are counted weekly.

One bottle of wine is worth ten grocery items. When wine inventory is wrong, you see it on the P&L.

What to count in a wine program

CategoryWhat it includesHow often
BottlesBy producer, vintage and sizeMonthly (high-end weekly)
By the glassOpen bottles in tenthsWeekly
CellarReserve and aging stockQuarterly

Step by step

  1. Organize by bin number.
  2. Count open bottles in tenths.
  3. Log breakage, tastings and comps.
  4. Value at the latest purchase price.

Mistakes that throw the count off

Wine inventory spreadsheet (columns)

BinWineVintageSizeFull bottlesOpen (tenths)Cost/bottleValuePar
A12House Cabernet2022750 ml180.4$9.50$174.8024
B03Chablis2023750 ml60$21.00$126.006
C07Rioja Reserva2019750 ml40$24.00$96.006
BTGSparkling (by the glass)NV750 ml90.6$11.00$105.6012

One row per wine and vintage when vintages are priced differently. Barcodes often stay the same between vintages, so the vintage column keeps them apart.

Wine cost and by-the-glass yield

Worked example: a 750 ml bottle (about 25.4 oz) costs $11 and pours five 5 oz glasses. At $12 a glass, one bottle brings $60: wine cost 18.3% if every glass is sold. If the count shows 20 bottles used and the POS shows 85 glasses, 15 glasses (3 bottles, $33) were over-poured, comped or not rung in.

Counting a cellar quickly

  1. Number every bin and keep the sheet in bin order.
  2. Count by bin, not by wine: walk the racks once.
  3. Open bottles at the bar in tenths, or weighed.
  4. Record breakage, tastings and staff wine as you go.
  5. Value at the latest cost; compare usage per wine with sales.

Scanning instead: wine inventory app. Cellar routine: cellar management. Pricing by the glass: pour cost calculator.

Breakage, tastings and staff wine

Record every broken bottle, tasting bottle and staff glass as it happens, with a reason. Otherwise they appear as missing stock in the next count and hide real losses.

How mise helps

Scan the barcode with your phone camera or snap a photo of the label; mise's AI finds the product and categorizes it with name, brand, category, photo and price. Scan each bottle and mise recognizes it by the barcode; open bottles are counted in fractions. Every count is saved with a date and a name, par levels warn you before you run out, and you see shrinkage and food cost for the period without building a spreadsheet.

Try mise in your business

Scan the barcode or snap a photo: mise's AI finds the product and categorizes it. Free trial.

Start free
Download on the App StoreGet it on Google Play
Keep reading Bar inventory spreadsheet (free Excel and Google Sheets template) Wine inventory app: count the cellar by scanning the bottles Pour cost calculator (free): cost per pour, pour cost % and drink price Cellar Management: Pub Cellar Routine and Stock All guides

Frequently asked questions

What columns should a wine inventory spreadsheet have?

Bin, producer, wine, vintage, size, cost, count, value.

Is there an inventory template?

Yes: item, unit, par, count and variance. With mise you count by scanning and export to Excel or PDF.

How often should a restaurant count wine?

Weekly for by-the-glass and high-value bottles, monthly for the rest of the list.

How do I value wine bought at different prices?

Use the latest purchase price for the weekly count, or FIFO if your accountant requires it. Be consistent between counts.

Should by-the-glass bottles be counted separately?

Yes. Keep them as their own location (the bar) so open bottles in tenths are not mixed with sealed stock in the cellar.

Can I try mise for free?

Yes. You get a free trial, with no card needed.