Profession Calculators
Hospitality & Food IndustryPopular

Bar Inventory and Pour Cost Calculator

Calculate liquor cost percentage, variance from target, and category-level pour cost analysis for spirits, beer, and wine using 2026 industry benchmarks of 18% to 24%.

Share:
Bar Inventory by Category

2026 industry benchmark: 18% to 24% for total beverage programs

Embed This Calculator on Your Website

Add this free calculator to your blog, website, or CMS with a simple copy-paste embed code.

Introduction

A bar that operates at 25% pour cost instead of 20% on $30,000 monthly beverage revenue leaves $1,500 on the table every month -- $18,000 per year -- without a single customer complaint. The money does not disappear dramatically. It leaks through free-pour overages, untracked comps, bartender drinks, and the occasional bottle walking out the back. The National Restaurant Association reports that beverage cost variance is the single most controllable profitability variable in bar and nightclub operations. Controlling pour cost starts with measuring it accurately every week using opening inventory, purchases, closing inventory, and revenue. This bar pour cost calculator runs that math by category -- spirits, beer, wine, and custom -- so you see exactly where the leakage is happening.

What This Calculator Does

This bar inventory and pour cost calculator computes beverage cost of goods sold (COGS) and pour cost percentage by tracking opening inventory, purchases, and closing inventory across multiple categories. It calculates actual pour cost, compares it against your target, and quantifies the revenue impact of variance. The tool supports separate category tracking for spirits, draft beer, bottled beer, wine by the glass, bottled wine, and custom categories.

The Formula

COGS = Opening Inventory + Purchases - Closing Inventory | Pour Cost % = (COGS / Sales Revenue) x 100 | Variance = Actual Pour Cost % - Target Pour Cost %

Pour cost measures what percentage of beverage revenue was consumed by product cost. Opening inventory plus all purchases during the period equals total product available. Subtracting closing inventory gives COGS -- everything that was sold, comped, spilled, or stolen. Dividing COGS by revenue and multiplying by 100 produces the pour cost percentage. Variance is the difference between your actual pour cost and your target; each percentage point of variance represents a dollar loss equal to (variance% / 100) x revenue.

Step-by-Step Example

1

Count opening inventory by category

Beginning of week: spirits $6,400 (at cost), draft beer $1,800, bottled beer $900, wine $3,200. Total opening: $12,300.

2

Record all purchases during the period

Spirits delivery: $3,100. Beer: $1,400. Wine: $1,200. Total purchases: $5,700.

3

Count closing inventory

End of week: spirits $6,100, draft beer $1,500, bottled beer $700, wine $2,900. Total closing: $11,200.

4

Calculate pour cost and variance

COGS: $12,300 + $5,700 - $11,200 = $6,800. Revenue: $32,000. Pour cost: $6,800 / $32,000 = 21.25%. If target is 20%, variance is 1.25%. Dollar impact: 1.25% x $32,000 = $400 in excess cost this week.

Real-World Use Cases

Spirits Theft Detection

A bar manager notices spirits pour cost is running at 24% against a 19% target despite menu prices that should support lower margins. The dollar variance -- $1,600 per week -- exceeds what could be explained by over-pouring alone. A comparison of theoretical pour cost (from POS recipe data) to actual pour cost reveals a $900 weekly gap on premium spirits specifically, pointing to a theft or unreported comp problem on high-cost product.

Draft Beer System Audit

A bar showing 28% draft beer pour cost against a 22% target traces the problem to line waste during daily cleaning and inconsistent head pour technique. Standardizing pours to a 2/3 inch head and installing a line counter reduces waste by 8 oz per keg pull, bringing draft pour cost down to 23% and saving $340 monthly on a $6,000 monthly draft beer revenue base.

New Bar Program Launch

A restaurant expanding its bar program uses the calculator to set pour cost targets for each beverage category before launch, then tracks weekly against those targets during the first 90 days. Catching a wine-by-the-glass pour cost at 38% (against a 32% target) in week 3 leads to tighter 5-oz pours versus the 6-oz pours the bartenders had defaulted to.

Comparison

CategoryTarget Pour Cost %Acceptable RangeCommon Cause of Variance
Spirits / Cocktails18-21%Up to 23%Over-pouring, free-pour without jigger
Draft Beer20-25%Up to 28%Line waste, inconsistent head, spillage
Bottled Beer24-28%Up to 30%Breakage, unreported comps, over-chilling waste
Wine by the Glass26-32%Up to 35%Over-pouring, oxidized bottles, comp tracking
Bottled Wine30-40%Up to 45%Breakage, table comps, pricing miscalculation
Non-Alcoholic Beverages10-15%Up to 20%Over-portioning, missed charges

Common Mistakes to Avoid

  • Not counting inventory at the same time each period. If you count spirits on Monday morning one week and Wednesday afternoon the next, two days of sales are included in the second count and excluded from the first, creating a false variance. Count at the same time -- typically before opening on the first day of the period.

  • Counting inventory at retail value instead of cost. Inventory must be counted at what you paid the distributor, not what you sell it for. Counting at retail inflates the inventory value and artificially reduces calculated COGS.

  • Omitting mid-period emergency orders or transfer purchases. Every bottle that enters the bar during the period must be included in purchases. A missed $400 liquor delivery understates COGS by $400 and understates pour cost by its proportional share.

  • Not separately tracking comps, spills, and staff drinks. These are real costs that affect pour cost. Tracking them separately identifies whether variance is legitimate (comp policy expense) or problematic (unrecorded theft or overpouring). Most well-run bars track comps at a 1% to 2% of revenue target.

Frequently Asked Questions

Accuracy and Disclaimer

Pour cost calculations are based on inventory values and sales revenue entered by the user. Accuracy depends on the precision of physical inventory counts and complete purchase recording. Benchmarks reflect 2026 industry averages from hospitality industry sources and vary by concept, location, and product mix. This calculator is for operational planning purposes. Consult a beverage cost consultant or hospitality accountant for targets specific to your operation.

Conclusion

Weekly pour cost tracking is what separates a managed bar program from an unmanaged one. Once you have your numbers, use our Restaurant Prime Cost Calculator to combine beverage cost with food cost and labor into a single profitability view, or run the Labor Cost Percentage Calculator to confirm whether your bar staffing model is appropriately lean for your revenue volume.