Author, Hospitality Industry Authority, and Expert Witness · Last updated: November 2025
Working spreadsheet for bar inventory management. Track liquor, beer, and wine inventory. Calculate cost of goods sold and pour cost. Identify variance and shrinkage. Free download via the form above.
Four tracking layers,
fully wired.
Each beverage category has its own tracking sheet, plus a unified COGS calculation that rolls up across categories.
Liquor Inventory Tracking
Per-bottle inventory by category — rail, premium, super-premium.
Keg-level and bottle-level tracking.
SKU-level cellar management with vintage tracking.
Cost of Goods Sold Calculation
Beginning inventory + purchases − ending inventory = COGS.
Six points of margin
walk out the door.
Bar profit margins depend heavily on inventory control. Common failure points add up faster than most operators realize.
Over-pouring drops beverage gross margin
Theft (employee or customer) erodes
Spillage and breakage adds another
Comping outside policy adds variability
Receiving errors compound over time
Often the difference between a profitable bar and one that breaks even.
Three operational rhythms.
Weekly Inventory Cycle
Take physical inventory weekly. Update spreadsheet with beginning inventory, current week purchases, current ending inventory. Output is current week COGS and pour cost percentage. Compare to target.
Monthly Variance Analysis
End of month, run variance analysis: theoretical pour cost (based on POS sales data) vs. actual pour cost (based on inventory). Difference is variance from theft, over-pour, spillage, or receiving errors. Investigate variance over 2 percent.
Trend Tracking
Track monthly pour cost percentages over time. Healthy bars see relatively stable pour cost. Trending upward indicates control issues developing. Trending downward may indicate under-pouring (a customer service issue).
Pour cost benchmarks.
Compare your spreadsheet output to these industry-standard ranges. Above the range signals control failures; below the range may signal under-pouring or pricing issues.
COGS feeds the
margin calculator.
Inventory control directly affects the COGS percentage input to the
Bar Profit Margin Calculator. Disciplined inventory management lets you maintain industry-low COGS percentages, which flow through to higher EBITDA margins. The Bar Business Plan’s integrated financial model uses the same COGS structure — for the complete plan, see the
Bar Business Plan.
Includes inventory control framework
