Bar Inventory Spreadsheet Template (Free, No Email)

If you’re googling “bar inventory spreadsheet template” at 1am after close, you’re in good company. Our team has stood behind a Virginia Beach bar with a clipboard, a pen running out of ink, and a Google Sheet rebuilt four times because the formulas kept breaking. The spreadsheet worked. Until it didn’t.

This post gives you the template. Not a gated PDF. Not an email capture. Just the columns and formulas you can paste into Google Sheets or Excel in about 10 minutes and start using tomorrow night. Then, because we care more about your pour cost than our download numbers, we’ll tell you exactly when the spreadsheet stops being enough.

What should a bar inventory spreadsheet include?

A working bar inventory sheet needs enough columns to answer three questions: what do you have, what is it worth, and what did you lose. Anything less and you’re just making a grocery list.

Here are the 11 columns every bar inventory spreadsheet should have:

1. Product Name. Full brand and bottling. “Tito’s 1.75L” not “vodka.”
2. Category. Vodka, gin, whiskey, rum, tequila, liqueur, wine, beer. Makes sorting and reporting easier.
3. Unit Size. 750ml, 1L, 1.75L, 12oz, half keg. Required for variance math.
4. Par Level. The number of bottles you want on the shelf after an order.
5. On Hand. Your counted number, including partial bottles as decimals. Three full and one half bottle is 3.5.
6. Unit Cost. What you pay the distributor, not the menu price.
7. Extended Value. On Hand multiplied by Unit Cost. This is your inventory dollars.
8. Vendor. Who you buy it from. Southern Glazer, RNDC, Breakthru, local distributor.
9. Last Ordered. Date of the last purchase order. Tells you how fast things move.
10. Expected Depletion. What POS sales say should have been poured since the last count, expressed in bottles.
11. Variance %. The difference between Expected Depletion and what actually left the bottles.

Bonus columns if you want to get sharper: minimum reorder quantity, shelf location, depletion per week, and last count date.

Free bar inventory spreadsheet template

Open a new Google Sheet or Excel file. Name it “Bar Inventory [your bar name].” Use Row 1 for headers and start your data in Row 2.

Here is the exact column layout, left to right:

Column	Header	Type
A	Product Name	Text
B	Category	Text
C	Unit Size	Text
D	Par Level	Number
E	On Hand	Number
F	Unit Cost	Currency
G	Extended Value	Formula
H	Vendor	Text
I	Last Ordered	Date
J	Expected Depletion	Number
K	Variance %	Formula

Now the formulas. Paste these into row 2, then drag down to apply to the rest.

Extended Value (Column G): =E2*F2

That multiplies your on-hand count by your unit cost. If Tito’s 1.75L costs you $22 and you have 3.5 bottles, G2 shows $77.

Variance % (Column K): =(J2-E2)/J2

Expected Depletion is what POS sales tell you should have been poured. On Hand is what you actually counted. If those two don’t match, variance is the gap. Format column K as a percentage.

Total Inventory Value (put this in a summary cell at the top or bottom): =SUM(G2:G500)

That gives you the dollar value of every bottle on your shelves. Most bars are shocked the first time they see it.

Par Alert (optional, Column L): =IF(E2<D2,"REORDER","OK")

Flags anything below par so you know what to put on your next order.

These formulas work the same in Google Sheets and Microsoft Excel. No translation needed. Format columns F and G as currency, column K as percentage, and column I as a date. Freeze Row 1 so your headers stay visible when you scroll.

That’s it. You now have a functional bar inventory spreadsheet template. No download button. No email form. Just build it.

How do you do bar inventory by hand?

A good count takes discipline, not talent. Do it the same way every week and you’ll cut your count time in half by the fourth week.

Step 1: Count after close, before open. Never mid-shift. You need the bar still, the POS closed out, and nobody pouring behind you.

Step 2: Start with the back bar, work left to right. Pick a corner and go shelf by shelf. Don’t jump around. If you skip and come back, you will double-count a bottle of Fernet and it will haunt your variance report.

Step 3: Count full bottles first. Sealed and unopened bottles go in as a whole number. Three Jamesons sealed equals 3.0.

Step 4: Tenth the open bottles. Tenthing is how bartenders eyeball partial bottles. Hold the bottle up and estimate what fraction of the liquid remains in tenths. Half full is 0.5. A bottle with about 20% left is 0.2. Do this for every open bottle and add it to your full count. Two sealed plus one bottle at 0.6 equals 2.6.

Step 5: Move to the speed rail. Speed rail bottles get opened fast, so tenthing matters most here. Don’t skip well products because they seem cheap. Well vodka at high volume loses more money than a forgotten bottle of Pappy.

Step 6: Count the walk-in and dry storage last. Full cases, half cases, loose bottles. Cases stay sealed, so math is fast.

Step 7: Reconcile with POS. Pull your sales report for the period since the last count. For each product, multiply items sold by the pour size. That gives you expected depletion in ounces, which you convert to bottles. Subtract that from last count plus purchases. The number should match your new count. It won’t. The gap is your variance. If you are fuzzy on any of this math, read our walkthrough on how to calculate pour cost before you try to reconcile.

Step 8: Investigate anything over 5% variance. A 5% liquor variance is the common rule of thumb used by bar operators and inventory consultants. Actual variance in independent bars often runs much higher before anyone starts tracking it. Above 5% and you’re looking at overpours, spillage, comps that never got rung, or theft.

Budget about 2 hours for a 50-SKU bar if you’re solid. First time, plan for double that.

Why do spreadsheets break at 50+ SKUs?

The spreadsheet gets you to 50 SKUs. Maybe 70 if you’re obsessive. After that, the cracks show.

Formula errors spread silently. Someone copies a row wrong. A cell reference breaks. You don’t notice until the monthly P&L and the spreadsheet are $1,800 apart and nobody can tell which one lied.

Two people counting at once is a nightmare. Google Sheets handles concurrent editing, barely. Excel doesn’t without SharePoint. One person on a laptop in the office, another on a phone behind the bar, and you end up with overwrites, missing rows, and a fight at 2am.

Phones don’t love spreadsheets. Try tenthing a bottle of Hennessy while pinching and zooming on a column you can’t read. You will make mistakes. You will take twice as long.

No variance alerts. Your spreadsheet doesn’t text you when a product is suddenly off 12%. You find out a month later, after three weeks of pours walked out the back door.

No pour tracking. Spreadsheets are a snapshot, not a movie. They tell you what’s on the shelf right now. They don’t tell you what happened between counts. No POS integration, no recipe costing, no real-time depletion.

Version control is fiction. “Bar Inventory FINAL v4 (real)(use this one).xlsx” is not a system. It’s a warning sign.

When should you switch from a spreadsheet to inventory software?

A spreadsheet is the right tool for a small bar with tight control. It stops being the right tool when any of these are true:

• You’re carrying more than 100 SKUs across liquor, beer, and wine.
• Your beverage spend is over $10,000 per week.
• You run more than one location and are trying to compare variance across bars.
• Inventory takes longer than 2 hours per week to complete.
• You can’t answer “what’s my pour cost on Hendrick’s?” in under 30 seconds.
• You’ve had a variance surprise in the last 90 days that cost you real money.

Hit two of those and your spreadsheet is costing you more than inventory software would. That’s the math that pushed our team to build PourIQ in the first place. We were spending six hours a week on a Google Sheet that still missed a 9% variance on tequila. A $75 a month tool would have paid for itself in one shift.

If you want to see what your current pour cost actually looks like, run the numbers through our free pour cost calculator before you shop software. It takes two minutes and it will tell you whether you have a counting problem or a pricing problem.

What are the alternatives to a bar inventory spreadsheet?

When you’re ready to move off the sheet, here is the honest comparison. We build PourIQ so we’re biased, but the pricing is public and you can verify it yourself.

Tool	Monthly Price	Hardware Required	Mobile Count	Variance Alerts	Recipe Costing
Spreadsheet	Free	No	Painful	No	Manual
Backbar	$99+	No	Yes	Basic	Yes
Bevager	$99.99/user	No	Yes	Yes	Yes
MarketMan	$199+	No	Yes	Yes	Yes
Partender	$249+	No (camera)	Yes	Limited	No
Bar-i	$80+ (self) / $320 (concierge)	No	Yes	Yes	Yes
PourIQ	$75 flat	No	Yes	Yes	Yes

Pricing sourced from each vendor’s public pricing page and Capterra as of April 2026: Backbar Essential $99/mo monthly (getbackbar.com), MarketMan Starter $199/mo (marketman.com), Partender Pro $249/mo promotional, $399/mo regular (appdemo.partender.com), Bar-i self-service from $80/mo and concierge tier $320/mo (bar-i.com), Bevager $99.99 per user per month (capterra.com). Compare PourIQ vs Backbar and PourIQ vs MarketMan for feature-level breakdowns.

The spreadsheet wins on price. Software wins on everything else. At $75 a month PourIQ is priced to close that gap for independent bars that can’t justify $200+ per month but have outgrown the clipboard.

See our full pricing page for what’s included.

The honest next step

If the template above gets you where you need to go, use it and bookmark this post for when it stops working. No hard feelings. A clean spreadsheet beats a messy software rollout every time.

If you’re already past the breaking point, you carry 100+ SKUs, inventory eats half your Sunday, or you’ve caught a variance that gave you chest pains, book a 15-minute demo of PourIQ. We’ll walk you through how your current count sheet becomes a live dashboard in under a week. No hardware. No contract. $75 a month.

Request a demo

The PourIQ Team