How do I calculate bar stock variance from sales and stock counts?
By Better Bartender · Published
Compare physical stock usage with recipe-based usage for the same period, then account for recorded waste and other authorised movements. In the example below, 12 litres used against 10 litres expected leaves a 2-litre difference to reconcile.
Start with actual stock usage
Actual usage = opening stock + receipts + transfers in − transfers out − closing stock. Include supplier returns consistently as outbound movements. Count in the same units at both boundaries and separate products whose measures or pack sizes differ.
For an invented spirit example, opening stock is 14 litres, deliveries are 7 litres, closing stock is 9 litres and there are no transfers or returns. Actual usage is 14 + 7 − 9 = 12 litres. This is physical depletion, not necessarily paid sales.
Calculate recipe-based usage
Suppose the POS records 200 serves using exactly 50 ml of that spirit each. The theoretical usage is 200 × 50 ml = 10,000 ml, or 10 litres. The difference from actual usage is 2 litres. For this guide, a positive difference means actual usage exceeds the recipe-based expectation; other stock systems may use the opposite sign.
Check whether cocktail quantities, doubles, modifiers and complimentary items have been mapped correctly. A refund does not always mean the liquid returned to stock. A voided order may have been made and discarded. Recipe arithmetic cannot resolve those events without operating records.
Separate explained and unexplained differences
If the waste log records 0.7 litres and documented tastings account for 0.3 litres, the explained non-sale usage is 1 litre. Subject to correct recording and no double counting, the remaining unexplained difference is 12 − 10 − 1 = 1 litre.
To state a percentage, name the denominator. The original 2-litre difference is 20% of the 10-litre theoretical usage, or 16.7% of the 12-litre actual usage. Those are different ratios, not contradictory results. Neither figure is an industry target.
What should I investigate first?
- Count timing and the accuracy of partial-bottle measurements.
- Receipts, returns and transfers entered in the correct period.
- Recipe quantities, batch yields and POS modifiers.
- Recorded spillages, breakages, tastings and complimentary drinks.
- Whether one movement has been included in two places.
A difference is a prompt to investigate, not evidence of theft or individual wrongdoing. Keep a signed explanation for corrections so the next count does not silently inherit the same error.
Can a sales dashboard measure wastage by itself?
No. POS sales supply part of the expected-usage calculation. Physical counts and movement records are needed to understand actual usage. Diageo Bar Academy’s inventory management guidance also discusses stocktakes and operational causes of variance; the figures and sign convention above are Better Bartender’s own illustrative example.
Connect this review with recipe costing and your weekly sales review. Better Bartender’s current venue pilot tests report collection; it does not establish a live stock-count integration.