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
Liquor inventory template you can run tonight
A working count sheet for casual bars and pubs. Edit the well, print it, then see when a spreadsheet stops being enough.
14 days free · No credit card · Plans from $59/month
Interactive count sheet
Liquor inventory template
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
Why most bar inventory templates fail after week two
A count sheet is only useful if your closer will finish it, and if Monday can compare it to what actually sold.
The sheet never meets the till
You can have a perfect clipboard and still not know whether Saturday's well matches Saturday's tickets.
Someone owns the file
When the template lives in one manager's Drive folder, a sick day becomes a skipped count.
How to do a bar inventory with this template
Freeze the room
Pick a cutoff after receiving and before the next service. Record any late case that lands during the walk.
Walk the same path
Speed rail, back bar, well, then the liquor room. Count sealed bottles, then tap or write the open fill.
Close and compare
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
Paper template vs a counted week
Use the sheet tonight. Graduate when you need the sales half of the loop.
The Monday problem
With ExactPour
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.
What this liquor inventory template is for
Buyers searching for 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. 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 /docs/bar-inventory-counting-basics. If you already know the method and want software, start at /liquor-inventory-management or compare plans on /pricing. Keep this page open when you are still on paper or Google Sheets and want a cleaner starting file.
How to do a bar inventory with a template
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.
Where a spreadsheet template stops helping
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 /compare/vs-spreadsheets exists as a comparison and why /solutions/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.
Built for a liquor well, not a bottle program
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 /industries/sports-bars and /industries/pubs if that is your room.
Liquor inventory template questions
- Is this a free liquor inventory spreadsheet?
- It is a browser count sheet with the same columns a spreadsheet uses: product, size, sealed count, open fill, and unit cost. You can print it. It does not save to an ExactPour account.
- How do I count an open well bottle?
- Estimate fill from 0 to 1. Half full is 0.5. A heavy rail bottle might be 0.3. Train the team on the same visual so bias stays shared.
- Does a finished template replace POS reconciliation?
- No. The sheet tells you what is on the shelf. Variance needs sales and recipes. That is the job of /liquor-inventory-management.
- Can I start a trial after I use the template?
- Yes. New accounts get one 14-day Pro trial. Nothing is charged unless you add a payment method. Compare tiers on /pricing.
Related: counting basics · spreadsheet alternative · bar inventory software · pricing
Finish tonight's count, then stop retyping it
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 $59/month