Rex says
Money math without the spreadsheet headache. Plug in your numbers and I'll show you exactly where the dollars land.
Try a scenario
Click to load — tweak from there.Inputs
Result
Variance %
11.8%
Variance in dollars
$600
Actual usage (calculated)
$5,700
Status
Investigate
Psst — share this and help Rex grow
One click, a permanent link with your numbers baked in.
How to use this
- 1Enter beginning inventory value ($).
- 2Enter purchases (period) ($).
- 3Enter ending inventory value ($).
- 4Enter pos theoretical usage cost ($).
- 5Read your variance % on the right — it updates as you type.
- 6Hit Share to keep the scenario or send it to someone.
About this calculator
Inventory variance compares what your POS says you should have used against what physically left the storeroom. Theoretical usage comes from sales data multiplied by the recipe pour size for each drink sold; actual usage comes from beginning inventory plus purchases minus ending inventory, counted physically. The gap between the two, expressed as a percentage of theoretical cost, is your variance. A healthy bar runs under 5% variance; 5-10% suggests inconsistent pouring or recipe drift; above 10% often means theft, comped drinks not being rung in, or breakage not being logged. This calculator takes beginning inventory value, purchases, ending inventory, and POS-calculated theoretical usage to surface both the dollar and percentage gap, which is the number that should trigger a deeper spot-check of pour discipline, comp logging, and receiving procedures.
Worked example
Using the values the calculator loads with:
Inputs
- Beginning inventory value: 8200 $
- Purchases (period): 4600 $
- Ending inventory value: 7100 $
- POS theoretical usage cost: 5100 $
Results
- Variance %: 11.8%
- Variance in dollars: $600
- Actual usage (calculated): $5,700
- Status: Investigate
What each field means
Inputs
- Beginning inventory value ($)
- The beginning inventory value used in the calculation, measured in $. Starts at 8200 $ so you have a working example on load.
- Purchases (period) ($)
- The purchases (period) used in the calculation, measured in $. Starts at 4600 $ so you have a working example on load.
- Ending inventory value ($)
- The ending inventory value used in the calculation, measured in $. Starts at 7100 $ so you have a working example on load.
- POS theoretical usage cost ($)
- The pos theoretical usage cost used in the calculation, measured in $. Starts at 5100 $ so you have a working example on load.
Results
- Variance %
- Returned as a percentage and shown as the headline result. It recalculates instantly whenever you change an input, so you can compare scenarios without reloading.
- Variance in dollars
- Returned as a money amount in US dollars. It recalculates instantly whenever you change an input, so you can compare scenarios without reloading.
- Actual usage (calculated)
- Returned as a money amount in US dollars. It recalculates instantly whenever you change an input, so you can compare scenarios without reloading.
- Status
- Returned as a plain value. It recalculates instantly whenever you change an input, so you can compare scenarios without reloading.
FAQ
What's a normal variance percentage?
Under 5% is considered healthy and reflects normal breakage, comp drinks, and pour inconsistency. Between 5-10% warrants closer monitoring of pour discipline. Above 10% consistently points to a systemic problem — theft, unrung comps, or a bad theoretical usage baseline.
What causes negative variance (using less than theoretical)?
Under-pouring, watered-down well liquor, or a recipe database that overstates pour sizes relative to what bartenders actually pour. It's less common than positive variance but still a quality and consistency problem worth fixing.
How often should bars do a full inventory count?
Weekly for high-volume bars, at minimum monthly for lower-volume operations. Weekly counts catch problems while the shift schedule that caused them is still fresh enough to investigate specific bartenders or shifts.
Can POS theoretical usage be wrong?
Yes — if recipes in the POS don't match what's actually poured (wrong pour size entered, recipe changed but POS not updated), theoretical usage will be systematically off and create false variance. Audit recipe data in the POS before assuming staff behavior is the problem.
Accuracy and limitations
- Results are estimates before tax, fees, and inflation unless an input explicitly covers them.
- Rates are treated as fixed for the whole period — variable-rate products will drift from this projection.
- This is educational maths, not financial advice. Check anything contractual with the lender or your accountant.
Related tools
Cite this calculator
Writing about this topic? Grab a citation — every link helps keep these tools free.
RevenueLab. (2026). Bar Inventory Variance Calculator. Retrieved from https://www.revenuelab.fyi/toolbox/bar-inventory-variance
<p>Source: <a href="https://www.revenuelab.fyi/toolbox/bar-inventory-variance" target="_blank" rel="noopener">Bar Inventory Variance Calculator — RevenueLab</a> (2026).</p>
Source: [Bar Inventory Variance Calculator — RevenueLab](https://www.revenuelab.fyi/toolbox/bar-inventory-variance) (2026).