Bar inventory: a count sheet to copy, how to work out pour cost, and par levels
Bar inventory step by step: a count sheet with partial bottles in tenths, the usage and pour cost math worked through, par levels and a weekly routine.
Start from the inventory template
Know what's in stock and reorder in time.
On this page
Bar inventory means counting every bottle, keg and case on the same day each week, then working out what you used: starting count plus what you received, minus the ending count. Cost that usage and divide it by sales for the same drinks, and you have your pour cost. All you need is a count sheet and a steady routine.
Below: a count sheet to print, counting partial bottles in tenths (no scales needed), a worked week, par levels, a second bar and the apps with their prices. If you’d rather keep all of it in an app, the inventory management template holds your products, counts and purchase orders.
How we researched this: in November 2026 we checked each price below on the vendor’s own pricing page, where one is public, and the bottle sizes against the federal Alcohol and Tobacco Tax and Trade Bureau (TTB). The count method and formulas are standard bar accounting. The bar, its bottles and its numbers are an example.
What does a bar inventory count sheet look like?
A count sheet lists every product you stock, in the order you’d walk the bar, with room to write what you find. Make one sheet per location, and inside it go shelf by shelf, left to right and top to bottom.
A neighborhood bar usually has three locations: the well (the speed rail the bartender reaches for first), the back bar (the shelves behind it, plus the fridge) and storage (cases and backups). Print this page and use one copy per location. Write the size in the item’s name. Start is last week’s End, In is what you received, End is today’s count in bottles and tenths, and Used is Start + In − End:
| ☐ Item | Start | In | End | Used |
|---|---|---|---|---|
| ☐ | ||||
| ☐ | ||||
| ☐ | ||||
| ☐ | ||||
| ☐ | ||||
| ☐ | ||||
| ☐ | ||||
| ☐ | ||||
| ☐ | ||||
| ☐ | ||||
| ☐ | ||||
| ☐ |
Location: ______ Counted by: ______ Date: ______
Keep wine and beer on their own pages. Count wine in bottles. For kegs, count the full ones plus the tapped one as a tenth, judged by lifting it, the way you’d judge a bottle.
How do you count a partial bottle?
Hold the bottle at eye level and write down how much is left in tenths: 0.1 is almost empty, 0.5 is half. If the same item has two open bottles, add their tenths together: 0.4 and 0.7 is 1.1. Do it the same way every week, with the same person if you can.
A tenth is small. In the US, spirits come in a few standard sizes, including 750 mL, 1 liter and 1.75 liters (TTB’s fill and headspace chart). At 29.57 mL to a fluid ounce, a tenth of each is:
| Bottle | One tenth |
|---|---|
| 750 mL (25.4 oz) | 2.5 oz |
| 1 liter (33.8 oz) | 3.4 oz |
| 1.75 liters (59.2 oz) | 5.9 oz |
A 1.5-ounce pour from a 750 mL bottle gives about 17 drinks, so a tenth is under two drinks. Every open bottle will be off by a drink or so, and the errors tend to partly cancel across a few dozen bottles. So a one-point swing in pour cost from one week to the next isn’t a finding. Look for the same item running high several weeks in a row.
Three habits make counts comparable:
- Count with the bar closed, so nothing moves during the count (BevSpot’s how-to says the same).
- Count in the same order every time. Two people work well: one calls the item and the count, one writes.
- Count storage too. A case that isn’t counted looks like a bar that used it.
How do you work out usage and pour cost?
Usage is the starting count plus what you received (from the week’s invoices), minus the ending count. Multiply usage by the cost per bottle to get the cost of what you used, then divide by sales of the same drinks. That’s your pour cost.
Here’s the example week. Counts are bottles and tenths, so 6.4 is six full bottles and one at four tenths:
| Item (cost a bottle) | Cost used | Start + received − end |
|---|---|---|
| House vodka, 1 L ($19.50) | $140.40 | 6.4 + 6 − 5.2 = 7.2 |
| Well gin, 1 L ($17.00) | $62.90 | 3.5 + 3 − 2.8 = 3.7 |
| Bourbon, 750 mL ($24.00) | $98.40 | 4.2 + 3 − 3.1 = 4.1 |
| Tequila blanco, 750 mL ($27.00) | $180.90 | 5.0 + 6 − 4.3 = 6.7 |
| Spiced rum, 1 L ($18.00) | $19.80 | 2.6 + 0 − 1.5 = 1.1 |
| Triple sec, 750 mL ($12.00) | $6.00 | 1.8 + 0 − 1.3 = 0.5 |
| Dry vermouth, 750 mL ($9.50) | $3.80 | 1.5 + 0 − 1.1 = 0.4 |
| Scotch, 750 mL ($36.00) | $25.20 | 2.3 + 0 − 1.6 = 0.7 |
| Total | $537.40 | 24.4 bottles |
The same eight products rang up $2,350 in the POS (point of sale) report for the week. Pour cost is $537.40 ÷ $2,350, which is 22.9%. Of every dollar those drinks sold, about 23 cents was the liquor.
Three notes keep that number honest:
- Same items on both sides. Divide the cost of the liquor by the sales of the drinks made from it. Keep a separate line for beer and wine, and leave out batched cocktails, syrups and juice, which aren’t liquor.
- Start from last week’s end. Copy last week’s End into this week’s Start, and update a bottle’s cost when the distributor’s price changes.
- Know what’s missing. Comps, spills, staff drinks and mis-rung drinks all show up as cost without sales. That’s why you watch pour cost over weeks, and not as one number.
What should your pour cost be, and what moves it?
There isn’t one right number: it depends on your menu and prices. Work out yours for four weeks, call that your baseline, then watch for a week that’s out of line.
When pour cost jumps, check these in order, cheapest first:
| What to check | Why it moves pour cost |
|---|---|
| Receiving | An invoice entered late, or twice, changes usage |
| The count | One partial bottle misread, or storage skipped |
| Prices | A new case price not updated on the sheet |
| Ringing | Drinks poured but not rung, or rung as the wrong item |
| Comps and staff | Free drinks with no entry in the POS |
| Pour size | Free pouring that drifts over a house pour |
Start with the first two, which cost nothing to check. Fix the sheet before you talk to your staff.
How do you set par levels and write the order?
A par level is how much of an item you want on the shelf right after a delivery. Par is weekly usage × (days between orders + days to deliver) ÷ 7, rounded up, plus a spare bottle for a busy weekend. Your order is par minus what you have and what’s already coming.
For the example bar, an order goes in every 7 days and the distributor delivers in 2. Vodka used 7.2 bottles, so par is 7.2 × 9 ÷ 7, rounded up to 10, plus one spare: 11. With 5.2 on hand and nothing on order, you’re 5.8 short, so order 6.
| Item | Order | Par and on hand |
|---|---|---|
| House vodka, 1 L | 6 | 11, have 5.2 |
| Well gin, 1 L | 4 | 6, have 2.8 |
| Bourbon, 750 mL | 4 | 7, have 3.1 |
| Tequila blanco, 750 mL | 6 | 10, have 4.3 |
| Spiced rum, 1 L | 2 | 3, have 1.5 |
| Triple sec, 750 mL | 1 | 2, have 1.3 |
| Dry vermouth, 750 mL | 1 | 2, have 1.1 |
| Scotch, 750 mL | 1 | 2, have 1.6 |
That’s 25 bottles, about $536.50 at the costs above. Round up, since you can’t order four-tenths of a bottle. Use your own order day and delivery time, and update par when usage changes.
What’s a weekly bar inventory routine?
Pick one day and time and keep it, such as Sunday after close or Monday before open.
- Close out the week’s invoices. Enter what was received, with costs.
- Count with the bar closed: well, back bar, then storage, in shelf order.
- Enter the counts, and check anything odd now, while you’re at the shelf. A negative usage means a missed count or a missed delivery.
- Read usage, cost used and pour cost against your baseline.
- Write the order from par and send it to the distributor.
- Put away the delivery, newest bottles behind the old.
How do you run inventory for a second bar?
Count each bar on its own sheet, with its own sales, and work out its own pour cost. Don’t pool them. A pooled number hides the bar that’s running high.
Each bar needs its own Start, Received, End and sales from its own register. When a bottle moves between bars, write it down on both sheets: it’s Received at one bar and taken out of the other. Add those transfers to usage (start + received + transferred in − transferred out − end), or the bar that gave up a bottle looks like it poured it.
An example week for two bars (made-up numbers):
| Bar | Pour cost | Cost used ÷ sales |
|---|---|---|
| Main bar | 22.9% | $537.40 ÷ $2,350 |
| Patio bar | 26.3% | $310.00 ÷ $1,180 |
The patio bar is 3.4 points higher. Recount it first, then compare item by item: if the same bottles run high week after week, check pour size and ringing at that bar. Use one price list for both.
Which bar inventory app or software should you use?
Pick by how the bar counts. If you like a spreadsheet, you have the sheet above. If you want an app for counting, ordering and reports, here’s what each vendor’s own page showed in November 2026, in US dollars, as listed:
| Tool | Price |
|---|---|
| Backbar | Free plan; paid $79 to $149 a month per location |
| BevSpot | $948 or $1,428 a year, billed annually |
| WISK | $249 a month, plus $750 setup |
| MarginEdge | $350 a month per location; scale +$150 |
| BinWise | No price published |
| Partender | We couldn’t read its price |
Who each suits:
- Backbar: a one-bar owner who wants to start free. The free Basic plan is one location with unlimited users, up to 10 recipes and six months of history. Essential is $79 or $99 a month and Professional $129 or $149, depending on whether you pay yearly or monthly. Its bar inventory page describes scanning UPC codes to add items.
- BevSpot: a bar that wants counting and ordering on any device. Starter is $948 a year and adds one-click ordering; Standard is $1,428 and adds recipe costing. Automated variance reports (what you used against what you should have) are on its Pro plan, priced by quote, so ask what you’d pay.
- WISK: a busier bar or a small group that wants counting with a scale. Single venue beverage includes 5 users, 60+ POS integrations and a mobile app with a Bluetooth scale. The page doesn’t say whether $249 is the annual or quarterly rate.
- MarginEdge: a restaurant that wants the kitchen’s invoices and the bar in one place. Paid a year up front it’s 10% off, $3,780.
- BinWise shows a demo button and no price; it describes a scanning app for bar counts. Partender’s pricing page wouldn’t load for our automated check, so look at it yourself.
For one bar, a year is $0 on Backbar’s free plan, $948 on BevSpot Starter, about $2,988 plus setup on WISK and $4,200 on MarginEdge billed monthly. We’d look at Backbar’s free plan first: you learn whether you’ll count weekly before you pay. Look at WISK or MarginEdge for scales, or the restaurant’s invoices in the same system.
Build your bar inventory in GoodTaco
The job: a count that works the way your bar does, on a phone. The manager counts the back bar at the shelf, and the low items are grouped by distributor with a suggested order, so the order is half written before she picks up the phone.
The inventory management template tracks items by quantity across locations, with stock history and purchase orders. Its sample records are a plumbing shop’s, so you rename things: items become bottles, locations become Well, Back bar and Storage, suppliers become distributors. Quantities take decimals, so 6.4 is a real count. You get:
- A record for each product. SKU (your stock code), category, unit (bottle, keg, case), cost, the count in each location, and a history of each Take out, Receive, Move and Count with who made it and when. Count sets what’s there, and a save has an Undo.
- Reorder at and Fill up to. Use Fill up to as your par. The home page lists what’s low, grouped by distributor, with a suggested order that tops each item back up to its Fill up to.
- Purchase orders. Make a draft per distributor and receive the bottles into a location. Move sends bottles between locations. Stock value shows at cost, by location. Our guide to purchase order tracking covers the ordering side.
For pour cost, ask GoodTaco to add it: it takes your sales for the week. Type this first; the scene shows it done:
Turn this into a bar inventory app: bottles, locations Well, Back bar and Storage, and counts in tenths.
Then ask for the rest, one request at a time. The second:
Add a Usage page. For a date range, show each product’s starting count, what I received, the ending count and the cost used, with a total.
A third:
On the Usage page, let me type my liquor sales for the dates, and show the pour cost as a percentage of those sales.
For a second bar, ask for a Bar field on each location and a pour cost for each. You can also ask for a count sheet laid out for printing, one page per location.
GoodTaco builds apps like this in minutes. You change them by chatting, and every version is saved with one-click rollback. Already have a count sheet that works? Upload it with spreadsheet to app: GoodTaco puts your products into the app’s own built-in database, turns columns of repeated choices such as Location into dropdowns, and rebuilds the formulas it can reproduce exactly. Or start from the template and ask for your bar’s columns.
Staff sign in through your GoodTaco workspace, or you invite them to a private app. Set a part-timer’s role to Viewer in the Users tab and they can look a product up but not change it. A restaurant can keep its food stock in the same app; see restaurant software. GoodTaco is free to start. Paid plans start at $9 a month, and Pro at $49 a month includes 10 users; bigger teams talk to us about Enterprise.
Know what you poured, and what to order Monday. Start free, no credit card needed.
Frequently asked questions
How do you do bar inventory?
Count every bottle on the same day and in the same order each week, with the bar closed. Write full bottles plus the open bottle as tenths, such as 0.4. Then work out usage: starting count plus what you received, minus the ending count. Cost that usage and divide it by sales to get pour cost.
How do you calculate pour cost?
Pour cost is the cost of the liquor you used divided by the sales of the drinks made from it. If you used $537 of liquor in a week and those drinks sold $2,350, pour cost is 22.9%. Usage is starting count plus received minus ending count, multiplied by cost per bottle.
How do you count a partial bottle?
Hold the bottle at eye level, look at where the liquid sits, and write the fraction of the bottle left in tenths: 0.1 for almost empty, 0.5 for half, 0.9 for nearly full. Use the same person and the same method every week. A tenth of a 750 mL bottle is about 2.5 ounces.
Is there a free bar inventory sheet or template?
Yes. Several vendors and spreadsheet sites publish free bar inventory templates for Excel and Google Sheets. You can also build one with columns for item, bottle size, cost, start, received, end, used and cost used, as in this guide, with a second sheet for par levels and the order.
How often should you do bar inventory?
Weekly works well for a neighborhood bar, because a week is short enough to catch a problem while you can still trace it, and long enough that counting is not a daily chore. Whatever you pick, count on the same day and time so each period is the same length.
What is a par level for a bar?
A par level is how much of an item you want on hand right after an order arrives. A simple way to set it: weekly usage × (days between orders + days to deliver) ÷ 7, rounded up, plus a spare bottle for a busy weekend. You order the difference between par and what you have.
What is the best bar inventory app?
It depends on the bar. Backbar has a free plan for one location and BevSpot starts at $948 a year, billed annually. WISK and MarginEdge cost more and suit bars that want scales and point of sale (POS) links. A spreadsheet or a simple app of your own works if you only need counts, usage and orders.
Start from the inventory template
Get your own copy of a working inventory app with sample records, ready to make yours. Free to start.
Use the template, free