Liquor cost percentage equals the cost of liquor consumed divided by liquor sales for the same period, multiplied by 100. Your purchases alone do not tell you what you consumed. Stock remaining on the shelf belongs in the calculation.
For an illustrative bar with $600,000 in annual liquor sales, a four-percentage-point gap between actual cost and its own target represents $24,000 in additional product cost. That gap deserves investigation, not an automatic accusation of theft.
Scannabar supports liquor inventory control with bottle-level counting and usage reporting. The five steps below explain the calculation behind those numbers.
For the complete inventory process behind this calculation, see our liquor inventory and cost-control guide.
Quick Guide: Calculate Liquor Cost in Five Steps
- 1. Match Reporting Dates and Categories: Align inventory boundaries with sales dates and your beverage categories.
- 2. Value Beginning Inventory: Record full and partial bottles using a consistent cost basis.
- 3. Record Purchases, Returns, and Transfers: Reconcile deliveries and movements within the reporting period you selected.
- 4. Calculate Usage Cost: Deduct ending stock after adjusting opening inventory for recorded movements.
- 5. Divide Usage Cost by Liquor Sales: Convert consumption cost into a percentage of matching sales revenue.
Calculate Your Bar's Liquor Cost Percentage
1. Match Reporting Dates and Categories
Choose a period with inventory counts at its opening and closing boundaries. Pull POS sales for those same dates and locations. A count taken after additional service cannot reliably close an earlier sales period unless you account for intervening activity.
Separate spirits from wine and beer when you need category-level answers. Compare the same ingredient scope on both sides: spirits-only costs should not be divided by all restaurant revenue. Consistent scope makes beverage variance easier to interpret.
2. Value Beginning Inventory
Beginning inventory is the cost value of stock on hand at the start of the period. Include the back bar, service stations, storage, and any other locations inside your reporting scope.
Record bottle size, quantity, and partial contents consistently. Use a documented valuation policy agreed with your accountant rather than switching cost methods between counts. Review your counting method when partial-bottle measurements vary between staff.
3. Record Purchases, Returns, and Transfers
Include liquor received during the period, reconcile invoices to deliveries, and deduct documented supplier returns or credits once. An invoice entered twice inflates consumption even if every bottle was poured correctly.
For outlet reporting, add transfers in and deduct transfers out at cost. Transfers within a whole-property scope cancel out; do not treat them as new purchases. Keep wine stock and other categories separate if your calculation covers liquor only.
4. Calculate Usage Cost
Usage cost equals beginning inventory plus net purchases plus transfers in, minus transfers out and ending inventory. All inputs are dollar values at cost, not selling prices.
Usage cost = Beginning inventory + Net purchases + Transfers in − Transfers out − Ending inventory.
Count ending inventory using the same scope and valuation policy. Usage includes sold product, documented waste, complimentary drinks, and unexplained depletion. It is a measure of consumption, not proof of its cause. Inventory reports help organize the review.
5. Divide Usage Cost by Liquor Sales
Divide usage cost by net liquor sales for the matching period and multiply by 100. Exclude tips and taxes from sales consistently with your accounting policy. If sales are zero, the percentage is undefined.
Liquor cost percentage = Usage cost ÷ Net liquor sales × 100.
Compare your result with your recipe-based target and prior periods. Supplier costs, discounts, sales mix, measurement errors, and over-pouring can all change the result.
Worked Example: A Weekly Liquor Cost Calculation
This hypothetical example assumes no transfers. Opening stock is $8,400, deliveries total $5,200, returns are $180, and ending stock is $9,060. Usage cost is $8,400 + $5,200 − $180 − $9,060 = $4,360.
| Measure | Result |
|---|---|
| Usage cost | $4,360 |
| Net liquor sales | $18,200 |
| Liquor cost percentage | 23.96% |
| Gross profit before other expenses | $13,840 |
If the recipe-based target were 20%, expected cost would be $3,640. The $720 difference needs reconciliation against records, prices, waste, and portions. It is not automatically recoverable profit.
Why Can Purchases Differ From Liquor Consumed?
Purchases increase stock; consumption reduces it. A large delivery near period-end can increase purchases without increasing usage by the same amount. Ending inventory removes the unconsumed stock from the calculation.
Keep beer and dry goods in their appropriate categories so receiving activity does not distort a spirits-only calculation.
How Does Liquor Cost Affect Gross Profit?
Lower product cost increases gross profit at unchanged sales, but net profit also depends on labor, occupancy, and other operating expenses. A strong liquor margin does not establish that the entire business is profitable.
Cheryl Stanley, Senior Lecturer at Cornell's Nolan School of Hotel Administration, covers pricing and controls in her beverage program course. Those decisions should be assessed together, rather than treating one cost ratio as the whole business.
How Scannabar Supports Liquor Cost Control
Scannabar provides liquor inventory software with bottle-level measurement, usage reports, and POS reconciliation. Consistent inventory inputs support both the cost calculation and the investigation that follows it.
Use Scannabar's inventory controls to build a culture of accountability that protects staff from false accusations. Review the reporting workflow with your team before making operational changes.
FAQs About Liquor Cost Calculations
Is liquor cost the same as pour cost?
The terms often describe the same period cost ratio. A per-drink recipe cost is different: it describes expected ingredient cost for one serving. Scannabar's usage reports support the inventory-based view, which includes depletion that recipes and recorded sales alone do not explain.
How often should you calculate liquor cost?
A weekly review is a practical starting point for an active bar, provided counts and sales share the same boundaries. Scannabar's counting workflow supports frequent reviews. Choose a cadence your team can execute consistently and add spot checks for high-value stock when appropriate.
Does a high liquor cost prove theft?
No. High cost can reflect pricing, sales mix, supplier changes, recording errors, waste, or unauthorized usage. Scannabar's product-level reports help narrow the review, but records and operational evidence are still necessary before attributing a discrepancy to an individual.
