Inventory Variance Calculator (Bar and Kitchen)

Enter your counts, purchases and what your POS says you sold to see, item by item, how much product left the shelf without being rung in. Bar mode works in bottles and pours; the any-unit mode works for kitchen items counted by the pound, quart or each.

Count bottles in tenths: 6.4 is six full bottles and one at about 40%. Pours sold come from your POS sales by item.

Item	Bottle (ml)	Bottle cost ($)	Beginning	Purchased	Ending	Pours sold	Pour (oz)	Remove

Results

Variance cost

—

Variance % of theoretical cost

—

Theoretical cost

—

Positive numbers are product used but not sold; negative numbers mean sales were higher than usage, often a counting or POS mapping mistake. Items are sorted by dollar impact.

Inventory variance is the difference between what you actually used (beginning inventory + purchases − ending inventory) and what you should have used according to sales (theoretical usage). A positive variance means product is missing: over-pouring, spills, waste that was not logged, comps or voids that were not rung in, counting mistakes or theft.

Inventory variance formulas

Actual usage: beginning inventory + purchases − ending inventory.
Theoretical usage, bar: pours sold × pour size ÷ ounces per bottle; ounces per bottle = bottle size in ml ÷ 29.57.
Theoretical usage, kitchen: portions sold × the amount of the item in each portion.
Variance: actual usage − theoretical usage; variance % = variance ÷ theoretical usage × 100.
Variance cost: variance × unit cost (the bottle cost for liquor).
Lost pours: variance in ounces ÷ pour size.

How to calculate inventory variance

Count at the start and end of the period. Same day and time each period. Count bottles in tenths, or weigh them, the same way every time.
Add purchases. Everything received between the two counts, from the invoices.
Pull sales by item. From the POS: pours or portions sold. For cocktails, count each spirit’s pour.
Compare and investigate. Start with the lines that cost the most; recount them before you act.

Liquor Inventory Variance Template · Inventory Count Sheet

Worked examples

Bar: House vodka in 1 L bottles at $14: 6.4 at the start + 12 purchased − 5.1 at the end = 13.3 bottles used. The POS shows 280 pours of 1.5 oz, which is 420 oz, or 12.42 bottles, since a liter holds 33.8 oz. The 0.88-bottle variance is 29.7 oz, about 20 pours, or $12.31 (7.1%). Across vodka, tequila and bourbon the example comes to $28.34 on $486.66 of theoretical cost: 5.8%.

Kitchen: Chicken thighs: 40 + 120 − 35 = 125 lb used against 112 lb of theoretical usage, a 13 lb (11.6%) variance worth $37.57 at $2.89 a pound.

What causes inventory variance

Over-pouring, free pouring and oversized portions.
Spills, breakage and waste that nobody logged.
Comps, voids and staff drinks or meals that were not rung in.
POS and recipe mapping mistakes, such as a double rung as a single or a cocktail button that deducts the wrong spirit.
Receiving errors: the invoice says 12 and 11 arrived.
Counting mistakes and deliveries counted in the wrong period.
Theft.

What to do with the result

Recount the top three lines before you act on them.
Check the POS buttons and recipes for those items, then receiving.
Use jiggers or measured pours for spirits, and portion tools in the kitchen.
Log waste, comps and staff meals, so the variance that is left is the part you cannot explain.
Count your highest-cost items every week and compare each with its own history.

Inventory variance FAQ

What is inventory variance?

The difference between actual usage (beginning inventory + purchases − ending inventory) and theoretical usage from sales. A positive variance is product used but not sold.

How do you calculate liquor variance?

Work out the bottles used from your counts and purchases, then the bottles the POS says were poured: pours sold × pour size ÷ ounces per bottle. The difference, times the bottle cost, is the variance in dollars.

What does a negative variance mean?

Sales were higher than usage. It usually points to a counting mistake, a delivery counted in the wrong period, a drink rung under the wrong button or pours shorter than the recipe.

What is an acceptable liquor variance?

There is no official standard. Compare each item with its own history: a variance that jumps from one period to the next matters more than one that stays steady, and the dollar amount tells you where to look first.

Should I count bottles by weight or in tenths?

Weighing a bottle and subtracting the empty weight is more precise; tenths are faster. Either works if you use the same method every time.

Is this inventory variance calculator free?

Yes. It needs no sign-up, and the numbers you enter stay in your browser.

Related free tool

Pour Cost Calculator

Find cost per pour, pour cost % and the right drink price — with the 20% bar benchmark.

Open calculator