Bar inventory spreadsheet (free Excel and Google Sheets template)
By mise · Updated October 7, 2026
Download the Excel file (.xlsx) CSV
Free, no sign-up. Google Sheets: File → Import → Upload the .xlsx and the formulas keep working.
Quick answer: a bar inventory spreadsheet lists every bottle once, by location, with full bottles, the open bottle in tenths, cost per bottle and par. Total bottles = full + open; value = total × cost; order = par − total. Count at the same time every week and compare the two counts with purchases to get usage and pour cost. mise does the same count by scanning each bottle: 7 days free.
Most bars start with a spreadsheet, and a good one gets you a long way: one row per product, in the order you walk the bar, with the math done for you. Here is one ready to use, and how to run the weekly count with it.
What is in the spreadsheet
| Location | Product | Size | Full | Open (tenths) | Total | Cost/bottle | Value | Par | Order |
|---|---|---|---|---|---|---|---|---|---|
| Back bar | House vodka | 750 ml | 6 | 0.4 | 6.4 | $14.00 | $89.60 | 8 | 1.6 |
| Back bar | Bourbon | 750 ml | 3 | 0.7 | 3.7 | $22.00 | $81.40 | 4 | 0.3 |
| Wine fridge | House red | 750 ml | 9 | 0.0 | 9.0 | $8.50 | $76.50 | 12 | 3.0 |
The example rows above show how the formulas behave; the downloaded file comes with the counts empty. Total bottles, value and order are formulas, and the last row adds up the value of the whole bar. A second tab explains how to use it.
How to count the bar with it
- Same day, same time, every week — before opening or after close, before deliveries come in.
- Walk the bar in shelf order so the spreadsheet rows match what you see: back bar, speed rail, wine fridge, walk-in, storeroom.
- Full bottles first, then the open one in tenths. 0.4 means four tenths left. Weighing open bottles is more accurate than eyeballing.
- Use the cost from the latest invoice, not the price list.
- Save a copy per week. Usage = last week's count + purchases − this week's count. Divide usage at cost by liquor sales and you have your actual pour cost.
Want the per-drink side? Use the pour cost calculator. For beer kegs, cans and bottles there is a separate beer inventory sheet.
When the spreadsheet stops being enough
A spreadsheet is free, but every product is typed by hand, the open bottles are guesses and nobody else can count at the same time. In mise you scan each bottle with your phone: the product comes back named and sized, you tap the tenths (or weigh it with a Bluetooth scale), and value, usage and variance come out when you close the count. It exports to Excel too, so the spreadsheet can stay as your report. See bar inventory app.
Scan the barcode or snap a photo: mise's AI finds the product and categorizes it, and the count values itself. 7 days free, no card.
Start free
Frequently asked questions
Is there a free bar inventory spreadsheet?
Yes. The Excel file on this page is free, needs no sign-up and has the formulas for total bottles, value, par and order already in. It also opens in Google Sheets.
How do I count open liquor bottles?
In tenths of a bottle: if four tenths are left, write 0.4. Weighing the bottle on a scale and subtracting the empty weight is more accurate.
How often should a bar do inventory?
Weekly for liquor, beer and wine, at the same time each week, so usage and pour cost compare like with like.
How do I use it in Google Sheets?
Open Google Sheets, choose File, Import, Upload, and pick the .xlsx file. The formulas keep working.
How much does mise cost?
7 days free with everything included and no card.