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)
| Column | How to fill it |
|---|---|
| Full bottles | Sealed bottles, back bar and storeroom. |
| Open bottle (tenths) | 0 to 9. The formula adds it as a fraction. |
| Cost per bottle | From the last invoice. |
| Par | Bottles you want after each delivery. |
| Order | Par minus total bottles, never below zero. |
Tips that make the sheet reliable
- List bottles in the order they sit on the shelves.
- One row per size: a 750 ml and a 1 L of the same vodka are different items.
- Count before deliveries; record transfers to the kitchen.
- Keep the tenths honest — or weigh.
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
| Location | Product | Size | Full | Open (tenths) | Total | Cost/bottle | Value | Par | Order |
|---|---|---|---|---|---|---|---|---|---|
| Back bar | House vodka | 1 L | 4 | 0.6 | 4.6 | $15.00 | $69.00 | 6 | 1.4 → 2 |
| Back bar | Blanco tequila | 750 ml | 2 | 0.3 | 2.3 | $24.00 | $55.20 | 4 | 1.7 → 2 |
| Storeroom | Bourbon | 750 ml | 6 | 0 | 6.0 | $22.00 | $132.00 | 6 | 0 |
| Wine fridge | House white | 750 ml | 8 | 0.5 | 8.5 | $8.50 | $72.25 | 12 | 3.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
- Usage per bottle = last week's total + bottles received − this week's total.
- Usage at cost = usage × cost per bottle; add up for all liquor.
- Liquor cost % = usage at cost ÷ liquor sales × 100.
- Compare per bottle with what the POS says was poured; the gap is over-pouring, comps or unrung drinks.
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.
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 freeFrequently 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.
