Bar Inventory Template

Count spirits, beer, mixers and bar equipment against par levels, see what to order from which supplier and what your stock is worth.

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

Stock, Suppliers

Fields

21

Views

grid, dashboard

Tables, columns and sample rows

The 2 linked tables in this template, with their real columns, field types and sample rows. Copy the template to edit them in Edesy Tables.

Stock

13 fields · 7 sample rows

  • Stock count (Grid)
  • Order list (Grid)
  • Bar stock (Dashboard)
ItemTextCategorySingle selectUnitSingle selectStorageSingle selectOn handNumberPar levelNumberStock statusFormulaOrder qtyFormulaUnit costCurrencyStock valueFormulaOrder costFormulaSupplierLink to another tableLast countedDate
Jameson Irish Whiskey 750 mlSpiritsBottleBack bar4.58Reorder4₹2,900₹13,050₹11,600Brindco Spirits18 Nov 2026
Bombay Sapphire Gin 750 mlSpiritsBottleBack bar9.06In stock0₹2,600₹23,400₹0Brindco Spirits18 Nov 2026
Kingfisher Ultra draught 30 LBeerKegCool room2.04Reorder2₹7,800₹15,600₹15,600United Breweries18 Nov 2026
Sula Brut TropicaleWineBottleCellar0.06Out of stock6₹1,150₹0₹6,900Sula Vineyards18 Nov 2026
Tonic water 300 mlMixersCaseStore room5.04In stock0₹1,400₹7,000₹0Metro Cash & Carry18 Nov 2026
LimesGarnishKgCool room1.53Reorder2₹160₹240₹320Metro Cash & Carry19 Nov 2026
Highball glassesGlasswarePieceBack bar46.060Reorder14₹120₹5,520₹1,680Metro Cash & Carry12 Nov 2026
Field details
Item · Text
Category · Single select
Spirits, Beer, Wine, Mixers, Garnish, Glassware, Equipment
Unit · Single select
Bottle, Keg, Case, Can, Kg, Piece
Storage · Single select
Back bar, Cool room, Cellar, Store room
On hand · Number
Par level · Number
Stock status · Formula
IF({On hand} <= 0, 'Out of stock', IF({On hand} <= {Par level}, 'Reorder', 'In stock'))
Order qty · Formula
MAX(0, ROUNDUP({Par level} - {On hand}, 0))
Unit cost · Currency
INR
Stock value · Formula
{On hand} * {Unit cost}
Order cost · Formula
{Order qty} * {Unit cost}
Supplier · Link to another table
Links to Suppliers
Last counted · Date

Suppliers

8 fields · 4 sample rows

  • Suppliers (Grid)
SupplierTextContactTextPhonePhoneEmailEmailDelivery daysMultiple selectItemsLink to another tableItem countCountNext order valueRollup
Brindco SpiritsRakesh Malhotra+91 98100 11122[email protected]Tue, FriJameson Irish Whiskey 750 ml, Bombay Sapphire Gin 750 ml2₹11,600
United BreweriesSunil Hegde+91 98450 22233[email protected]Mon, ThuKingfisher Ultra draught 30 L1₹15,600
Sula VineyardsNisha Rao+91 98220 33344WedSula Brut Tropicale1₹6,900
Metro Cash & CarryStore desk+91 80 4000 1234Mon, Wed, SatTonic water 300 ml, Limes, Highball glasses3₹2,000
Field details
Supplier · Text
Contact · Text
Phone · Phone
Email · Email
Delivery days · Multiple select
Mon, Tue, Wed, Thu, Fri, Sat
Items · Link to another table
Links to Stock
Item count · Count
Next order value · Rollup
sum of Order cost via Items

Bar Inventory Template: 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