Start free

Liquor inventory sheet: free template for bars

By mise · Updated October 7, 2026

Quick answer: a liquor inventory sheet lists every bottle by location with size, full bottles, the open bottle in tenths, total bottles, cost per bottle, value, par and quantity to order. Count weekly at the same time and compare usage with POS sales to find over-pouring.

The sheet below is laid out the way a bar is counted: by location, bottle by bottle, with the open bottle in tenths. If you would rather scan than write, the liquor inventory app does the same count in a third of the time.

Download the template

Download the free liquor inventory sheet (CSV — opens in Excel and Google Sheets)

ColumnHow to fill it
Full bottlesSealed bottles, back bar and storeroom.
Open bottle (tenths)0 to 9. The formula adds it as a fraction.
Cost per bottleFrom the last invoice.
ParBottles you want after each delivery.
OrderPar minus total bottles, never below zero.

Tips that make the sheet reliable

For the full method, see bar inventory. Or skip the sheet: in mise you scan the bottle, the product comes named with its size, and a Bluetooth scale records the open bottle for you.

Example: a filled-in sheet

LocationProductSizeFullOpen (tenths)TotalCost/bottleValueParOrder
Back barHouse vodka1 L40.64.6$15.00$69.0061.4 → 2
Back barBlanco tequila750 ml20.32.3$24.00$55.2041.7 → 2
StoreroomBourbon750 ml606.0$22.00$132.0060
Wine fridgeHouse white750 ml80.58.5$8.50$72.25123.5 → 4

Order quantities are rounded up to whole bottles (or to the case, if you buy by the case).

From two sheets to pour cost

  1. Usage per bottle = last week's total + bottles received − this week's total.
  2. Usage at cost = usage × cost per bottle; add up for all liquor.
  3. Liquor cost % = usage at cost ÷ liquor sales × 100.
  4. Compare per bottle with what the POS says was poured; the gap is over-pouring, comps or unrung drinks.
Worked example: house vodka went from 6.2 to 4.6 bottles with 6 received: 7.6 liters used (1 L bottles), about 257 oz. The POS shows 150 vodka drinks at 1.5 oz = 225 oz. The 32 oz gap is about 21 pours in a week, worth checking with jiggers.

An Excel version with formulas, par and order columns: bar inventory spreadsheet. Per-drink pricing: pour cost calculator.

Keep last week's sheet next to this week's while counting: a total that jumps or drops sharply is easier to double-check on the spot than after the bar closes.

Count your stock by scanning barcodes

Point the camera and the product comes up complete: name, brand, category, size and photo — the mise AI finds it from the barcode or a photo. Free trial, no card.

Start free
Download on the App StoreGet it on Google Play
Keep reading Bar inventory spreadsheet (free Excel and Google Sheets template) Par level: meaning, formula and calculator Bar inventory: how to count liquor, beer and wine Pour cost calculator (free): cost per pour, pour cost % and drink price All guides

Frequently asked questions

What should be on a liquor inventory sheet?

Location, category, product, size, full bottles, open bottle in tenths, total, cost per bottle, value, par and order quantity.

Is there a free liquor inventory spreadsheet?

Yes — the CSV on this page opens in Excel and Google Sheets with the formulas included.

How do I count an open bottle in tenths?

Look at the bottle against a level surface and estimate how many tenths are left (0.3 = three tenths). Weighing the bottle and subtracting the empty weight is more accurate.

Should I list each bottle size separately?

Yes. A 750 ml and a 1 L of the same brand have different costs and pars; one row per size keeps the value right.