Open bottles get rounded
A half well vodka is not an empty bottle and not a full one. Templates that only accept whole units invent variance before anyone steals a drop.
Free count sheet for a real well
Free bar inventory template for liquor and beer. Download Excel, CSV, or PDF, count tonight, then start a 14-day trial when the sheet is not enough.
14 days free · No credit card · Plans from $69/month
Jump to the templateDownload CSVDownload XLSXPrintable PDFBeer inventory sheet
Count session · Backbar
Bottles counted
0 / 148
Time on count
18 min
Partials
36
Buffalo Trace 750 mL · scanned, tap fill level
Tito's Handmade 1L
0.7
Hendrick's Gin 750 mL
0.4
Patrón Silver 750 mL
0.9
Aperol 1L
Below par0.15
Interactive count sheet
Start with a typical well. Edit names, sealed bottles, and open fill (0 to 1). Totals stay in your browser. Print the sheet if you still walk the rail on paper tonight.
| Product | Size (ml) | Sealed | Open fill | Unit cost | Remove |
|---|---|---|---|---|---|
Bottle equivalents
10.75
Volume
10,438 ml
Estimated value
$147.65
Formula: bottle equivalents = sealed bottles + open fill. Volume = equivalents times bottle size. Value = equivalents times unit cost. This sheet does not reconcile against POS sales. For that loop, see liquor inventory management and pricing.
The week you already know
A count sheet is only useful if your closer will finish it, and if Monday can compare it to what actually sold.
A half well vodka is not an empty bottle and not a full one. Templates that only accept whole units invent variance before anyone steals a drop.
You can have a perfect clipboard and still not know whether Saturday's well matches Saturday's tickets.
When the template lives in one manager's Drive folder, a sick day becomes a skipped count.
Pick a cutoff after receiving and before the next service. Record any late case that lands during the walk.
Speed rail, back bar, well, then the liquor room. Count sealed bottles, then tap or write the open fill.
Save the totals. Next week, run the same sheet. The difference is only useful if the route and units stayed the same.
Problem vs ExactPour
Use the sheet tonight. Graduate when you need the sales half of the loop.
The Monday problem
You rebuild the same columns every Sunday.
With ExactPour
Scan the well. The count is the record.
The Monday problem
Open fills are a guess written in the margin.
With ExactPour
Fill levels from 0 to 1 stay on the product.
The Monday problem
Toast has tickets. The sheet has bottles. They never meet.
With ExactPour
Projected usage comes from the POS you already ring.
Buyers searching for a bar inventory template or a liquor inventory template usually want one of two things: a count sheet they can run tonight, or a reason to stop rebuilding that sheet every Sunday. This page is both. The interactive template below is a real well sheet for casual bars, pubs, and sports bars. Download the XLSX and open it in Excel or Google Sheets. It is not a cocktail-program cellar list and it is not a beer-only taproom log. It assumes you pour house spirits from a rail and that those open bottles are the inventory that actually moves.
If you need the system-neutral method without a product pitch, use bar inventory counting basics. If you already know the method and want software, start at liquor inventory management, see pour cost control, or compare plans on pricing. Keep this page open when you are still on paper or Google Sheets and want a cleaner starting file.
A count is a snapshot. It is only useful when the snapshot is taken the same way each time. Pick a night your receiving is done and service is paused or carefully recorded. Walk one route. Count sealed units first so you are not double-counting a bottle you later open. Then estimate each opener. Write the fill convention on the sheet so the next closer does not invent a new one.
Most failed templates fail on units. Mixing tenths of a bottle on the rail with case counts in the storeroom without converting them creates fake variance. Stay in milliliters or stay in bottle-equivalents. The calculator on this page uses milliliters times (sealed plus fill) so a 1000 ml well vodka at 0.4 fill is 400 ml, not a shrug.
A sheet can store what you type. It cannot scan a UPC, it cannot pull Toast tickets, and it cannot flag the well product that ran short three weeks in a row. That is why vs spreadsheets exists as a comparison and why bar inventory spreadsheet alternative exists as a migration playbook. Use the template until the labor of retyping and VLOOKUP is the bottleneck. Then trial ExactPour.
The graduation test is simple. If two people can finish the same count and still not agree what Saturday should have poured, you do not need a prettier spreadsheet. You need the sales half of the loop. ExactPour maps well drinks to recipes and compares projected usage to the physical count. New accounts get one 14-day Pro trial. Nothing is charged unless you add a payment method. Details live on pricing.
Award cocktail bars and allocation-heavy wine rooms need different sheets. This template is for the house pour: well vodka, well gin, well rum, well whiskey, well tequila, and the modifiers that ride next to them. Those SKUs hide the most dollars because they move the most ounces and they are rarely full at close.
Sports bars and pubs should add the call brands that actually sell on game day or on a Friday regulars night, then ignore the dusty backup bottles until the well is honest. A 40-SKU sheet that never gets finished is worse than a 12-SKU sheet that gets finished every Sunday. ExactPour later lets you count the full room without turning the first week into a catalog project. See sports bars and pubs if that is your room.
Sample filled row (example only): Well vodka, 1000 ml, 2 sealed bottles, 0.4 open fill, par 4, unit cost $13. Bottle equivalents = 2.4. Volume = 2400 ml. Value = $31.20. Those numbers are a teaching row, not a customer count.
Column glossary. Product: the SKU name. Size ml: container volume. Sealed bottles: unopened units counted as 1.0 each. Open fill: the opener from 0 to 1. Par bottles: the reorder target after the count. Unit cost USD: last invoice cost. Pour size oz and drink price: optional recipe columns if you want a per-drink pour cost sketch.
Beer uses different columns than a liquor well. Count cases, leftover singles, and sealed kegs by size. Do not convert an open keg into leftover pints on this sheet. ExactPour counts packaged beer and sealed kegs as units. Draft yield stays out of scope. Download the beer sheet below, then read beer inventory software.
Files in this repo: beer-inventory-sheet.csv and the Beer tab inside liquor-inventory-template.xlsx.
A spreadsheet stores what you type. Software scans identity, keeps fill levels, and compares the count to POS sales. When retyping is the bottleneck, graduate. The honest side-by-side is vs spreadsheets.
| Job | Spreadsheet template | ExactPour |
|---|---|---|
| Count tonight | Download CSV, XLSX, or print the PDF | Scan the well on iPhone |
| Open fills | Write 0 to 1 on the sheet | Fill stays on the product |
| Par and pour cost columns | You type them | From counts, invoices, and recipes |
| POS sales | Not in the file | Toast, Square, Clover, or GoTab |
| Price | Free files in this repo | $69, $99, $129 monthly USD |
Related: counting basics · spreadsheet alternative · bar inventory software · pour cost control · pricing
Start the trial on your own well, or read pricing if you want the plan map first.
14 days free · No credit card · Plans from $69/month
14-day Pro trial
No credit card required