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
| Category | What it includes | How often |
|---|---|---|
| Bottles | By producer, vintage and size | Monthly (high-end weekly) |
| By the glass | Open bottles in tenths | Weekly |
| Cellar | Reserve and aging stock | Quarterly |
Step by step
- Organize by bin number.
- Count open bottles in tenths.
- Log breakage, tastings and comps.
- Value at the latest purchase price.
Mistakes that throw the count off
- Vintages mixed under one item.
- Tasting bottles not logged.
- Staff drinks not recorded.
Wine inventory spreadsheet (columns)
| Bin | Wine | Vintage | Size | Full bottles | Open (tenths) | Cost/bottle | Value | Par |
|---|---|---|---|---|---|---|---|---|
| A12 | House Cabernet | 2022 | 750 ml | 18 | 0.4 | $9.50 | $174.80 | 24 |
| B03 | Chablis | 2023 | 750 ml | 6 | 0 | $21.00 | $126.00 | 6 |
| C07 | Rioja Reserva | 2019 | 750 ml | 4 | 0 | $24.00 | $96.00 | 6 |
| BTG | Sparkling (by the glass) | NV | 750 ml | 9 | 0.6 | $11.00 | $105.60 | 12 |
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
Counting a cellar quickly
- Number every bin and keep the sheet in bin order.
- Count by bin, not by wine: walk the racks once.
- Open bottles at the bar in tenths, or weighed.
- Record breakage, tastings and staff wine as you go.
- 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.
Scan the barcode or snap a photo: mise's AI finds the product and categorizes it. Free trial.
Start freeFrequently 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.
