Wine Inventory: Spreadsheet, App and Routine
By mise · Updated September 29, 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.
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. 7-day free trial, then US$33 a month (£26 in the UK).
Start free
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 much does mise cost?
A 7-day free trial, then US$33 a month per location (£26 in the UK).