Skip to main content
ExactPour logo

Free count sheet for a real well

Bar inventory template you can run tonight

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

ExactPour/ Main BarSample data

Count session · Backbar

Tonight's count

Synced to Main Bar

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 par

    0.15

Interactive count sheet

Bar 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.

CSVXLSXPDF
ProductSize (ml)SealedOpen fillUnit costRemove

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.

01

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.

02

The sheet never meets the till

You can have a perfect clipboard and still not know whether Saturday's well matches Saturday's tickets.

03

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

01

Freeze the room

Pick a cutoff after receiving and before the next service. Record any late case that lands during the walk.

02

Walk the same path

Speed rail, back bar, well, then the liquor room. Count sealed bottles, then tap or write the open fill.

03

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

    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 bar inventory template is for

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.

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 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.

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 sports bars and pubs if that is your room.

Sample filled row and column glossary

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 inventory sheet

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.

Spreadsheet vs software

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.

Spreadsheet template versus ExactPour
JobSpreadsheet templateExactPour
Count tonightDownload CSV, XLSX, or print the PDFScan the well on iPhone
Open fillsWrite 0 to 1 on the sheetFill stays on the product
Par and pour cost columnsYou type themFrom counts, invoices, and recipes
POS salesNot in the fileToast, Square, Clover, or GoTab
PriceFree files in this repo$69, $99, $129 monthly USD

Bar inventory template questions

Is this a free bar inventory template?
Yes. This page is a bar inventory template for a liquor well, with a beer sheet in the same files. Download the CSV or XLSX, or the printable PDF. Open the XLSX in Excel or Google Sheets. The browser sheet uses the same columns and does not save to an ExactPour account.
Is this a free liquor inventory spreadsheet?
Yes. Download the CSV or XLSX, or the printable PDF, from this page. The browser sheet uses the same columns: product, size, sealed count, open fill, par, and unit cost. 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 · pour cost control · 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 $69/month