Liquor inventory sheet: free template for bars
By mise · Updated September 29, 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.
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. 7-day free trial, no card.
Start free
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.