Set up the count sheet, count by tenths or by weight in under an hour, and turn the count into usage, variance and orders.
By Rob Bruni, founder of OpsEdge Hospitality, twenty years running restaurants, bars, clubs and resorts. Updated November 2026.
Free printable: Bar Inventory Count Night checklist (PDF)
Bar inventory is the count of every bottle, keg and case behind the bar and in the storeroom, done the same way at the same time every week. It is the only way to get a real pour cost, the only way to find out which bottle is leaking, and the single habit that separates bars that make money from bars that wonder where it went. This guide covers how to set up the count sheet, how to count by tenths or by weight, the weekly routine in under an hour, and how to turn the count into usage, variance and orders.
Invoices tell you what arrived. The POS tells you what was rung in. Neither tells you what was poured. The gap between what the POS says you sold and what the shelf says you used is where over-pours, spills, unrung comps and theft live, and the count is the only instrument that measures it.
A bar doing $40,000 a month in beverage sales with a four point gap between theoretical and actual pour cost is losing about $1,600 a month of product. Most bars that have never counted carefully are in that range. The count takes under an hour a week once it is set up.
The count sheet is a list of every product you stock, in the order you will walk past it. Build it once, properly, and the weekly count becomes mechanical.
Keep unit costs current. A count valued at last year's prices gives you last year's pour cost. Update costs from invoices as they arrive, or at least monthly.
Each open bottle is estimated to the nearest tenth: a bottle at the shoulder is 0.8, half is 0.5, the last inch is 0.1. It is fast, needs no equipment, and two trained people will land within a tenth of each other. For a bar with 150 products that is accurate enough to find a four point variance. It is not accurate enough to find a half point one.
Each open bottle goes on a scale. Subtract the empty bottle weight (tare), divide by the weight per ounce of the liquid (spirits are close to 0.95 ounces of weight per fluid ounce, but the sheet should hold a tare and a density per product), and you have ounces remaining to the pour. It takes a little longer per bottle and needs a $30 kitchen scale and a one-time tare list. It is accurate to the quarter ounce, which means the variance report can point at a single bottle with confidence.
Our recommendation: tenths for the first month to build the habit, then weight for the top 30 products by volume, which is where most of the variance lives, and tenths for the rest.
Weigh kegs, or estimate by lifting if you must. A full half barrel weighs about 160 pounds and an empty about 30, so each pound of liquid is roughly 0.8 pints. Weighing is the only reliable method. Record the keg as a fraction of a full keg.
A 150 product bar counted by tenths with two people takes 35 to 45 minutes. Add 15 minutes for weighing the top 30. Entering and reviewing takes another 15. Under an hour and a half all in, and it drops with practice.
Last week's ending count is this week's beginning count. Purchases are every invoice dated in the week. Usage in dollars, divided by beverage sales for the same week, is your actual pour cost, and you can run it by category. The pour cost guide covers the benchmarks for each.
One product, one week
House vodka, 1 L, $19.50 per bottle. Beginning: 6.4 bottles. Purchased: 12. Ending: 7.1 bottles.
Usage: 6.4 + 12 − 7.1 = 11.3 bottles, or 382 ounces, or $220.35
POS says 236 vodka drinks at 1.5 oz = 354 ounces = 10.5 bottles (theoretical)
Variance: 0.8 bottles, 28 ounces, about 19 drinks, $15.60 of product. About 7.5 percent of this product over-poured, spilled or given away.
Category variance tells you there is a problem. Product variance tells you where. Pull the POS product mix for the week, convert every drink sold to ounces of each product using your recipe specs, and compare it to the ounces the count says you used. Sort by dollar variance, biggest first.
Aim for total variance under 2 percent of beverage cost. Most bars that start counting are between 4 and 8 percent and get under 3 within two months, mostly because counting changes behaviour before it changes anything else.
A par is the quantity of a product you need on hand to get to the next delivery with a small buffer. Set it from usage: average weekly usage, times the number of weeks between deliveries, plus a 20 to 30 percent buffer for a busy week. The order is simply par minus what the count says you have.
Ordering from pars instead of from habit does two things. It stops the storeroom from filling with slow movers that tie up cash and eventually break or spoil, and it makes stock-outs of fast movers rare, because the par is built from how fast they actually move. Review pars quarterly and whenever the menu changes.
Our Bar Inventory Spreadsheet and Bar Manager Bundle hold the count sheet, usage calculations, variance report and par ordering in one workbook. The Prime Cost System page covers the help available when you want the first count and variance report built with you.
The free pour cost calculator prices any drink from bottle cost to menu price and shows profit per pour, then compares a month of purchases against sales to show what variance is costing you. No signup.
Open the pour cost calculator All free toolsFree printable
How to run a bar count in under an hour, plus a usage and variance worksheet and the pour cost bands. Two printable pages.
Here it is. We also sent a confirmation to your inbox.
Download the PDFWeekly for liquor and draft, which is where most variance lives, and a full count including wine and bottled beer at least monthly. Same day, same time, same person every week so that usage between counts is comparable.
Tenths is fast, needs no equipment and is accurate enough to find a variance of a few points. Weighing is accurate to the quarter ounce and lets you point at a specific bottle. Most bars do well with tenths for everything and weight for the top 30 products by volume.
A 150 product bar counted by tenths with two people takes 35 to 45 minutes. Weighing the top 30 products adds about 15 minutes. Entering and reviewing the count takes another 15. Under 90 minutes all in, and it gets faster with practice.
Variance is the difference between what the POS says you sold, converted to ounces using your recipe specs, and what the count says you actually used. It captures over-pouring, spills, unrung comps and theft. Under 2 percent of beverage cost is tight; most bars that start counting are between 4 and 8 percent.
Beginning count plus purchases minus ending count, for each product, in units. Multiply by unit cost for dollars. Divide total usage in dollars by beverage sales for the same period to get actual pour cost.
A par is the quantity you need on hand to reach the next delivery with a buffer. Set it as average weekly usage times weeks between deliveries times about 1.25. The order each week is par minus what the count says is on hand.