Liquor Inventory Spreadsheet

Track every bottle by type, age, ABV and proof, count partial bottles, and see pour cost per 30 ml against your menu price.

Sign in with your Edesy account, then click Use template in the preview to copy the base, with its sample rows, into your workspace.

Category

Inventory

Tables

Bottles

Fields

17

Views

grid, dashboard

Tables, columns and sample rows

The table in this template, with its real columns, field types and sample rows. Copy the template to edit it in Edesy Tables.

Bottles

17 fields · 7 sample rows

  • Inventory (Grid)
  • Pour costs (Grid)
  • Cellar value (Dashboard)
ProductTextTypeSingle selectOriginTextAge (years)NumberABVPercentProof (US)FormulaBottle size (ml)NumberFull bottlesNumberOpen bottle levelPercentBottles on handFormulaParNumberStock statusFormulaCost per bottleCurrencyCost per 30 mlFormulaMenu price (30 ml)CurrencyPour cost %FormulaStock valueFormula
Glenfiddich 12WhiskyScotland1240.0%80750360%3.64Reorder₹4,800₹192₹75025.6%₹17,280
Amrut FusionWhiskyIndia50.0%100750225%2.33Reorder₹4,200₹168₹69024.3%₹9,450
Old Monk XXXRumIndia742.8%86750850%8.56In stock₹700₹28₹18015.6%₹5,950
Grey GooseVodkaFrance40.0%80750030%0.33Reorder₹5,200₹208₹65032.0%₹1,560
Hapusa Himalayan Dry GinGinIndia43.0%86750480%4.83In stock₹3,400₹136₹52026.2%₹16,320
Patrón SilverTequilaMexico40.0%80750110%1.12Reorder₹6,500₹260₹90028.9%₹7,150
Baileys Irish CreamLiqueurIreland17.0%34750250%2.52In stock₹2,900₹116₹42027.6%₹7,250
Field details
Product · Text
Type · Single select
Whisky, Rum, Vodka, Gin, Tequila, Brandy, Liqueur, Wine
Origin · Text
Age (years) · Number
ABV · Percent
Proof (US) · Formula
ROUND({ABV} * 200, 0)
Bottle size (ml) · Number
Full bottles · Number
Open bottle level · Percent
Bottles on hand · Formula
{Full bottles} + {Open bottle level}
Par · Number
Stock status · Formula
IF({Bottles on hand} <= 0, 'Out of stock', IF({Bottles on hand} <= {Par}, 'Reorder', 'In stock'))
Cost per bottle · Currency
INR
Cost per 30 ml · Formula
IF({Bottle size (ml)} > 0, {Cost per bottle} / ({Bottle size (ml)} / 30), BLANK())
Menu price (30 ml) · Currency
INR
Pour cost % · Formula
IF({Menu price (30 ml)} > 0, {Cost per 30 ml} / {Menu price (30 ml)}, BLANK())
Stock value · Formula
{Bottles on hand} * {Cost per bottle}

Liquor Inventory Spreadsheet: questions

Yes. Copy the template, then import a .csv, .tsv or .xlsx file into any of its tables and map the columns. Delete the sample rows first if you do not need them.

Yes. An automation runs when a record is created, updated or matches a filter, when a form is submitted, on a schedule or when a date arrives, and can update or create records, call a webhook or post to a connected Slack channel.

Related templates