Beverage Cost Control Workbook

Stop guessing where your bar margin goes.

The Beverage Cost Control Workbook gives you a complete system to track, calculate, and improve your pour cost — built for Australian bars, pubs, restaurants, and hotel F&B operations.

What's inside (6 sheets):

• Dashboard — Live KPI tiles: pour cost %, COGS, GP%, and variance against your target. Instant read on where you stand.
• Recipe Costing — 50 drink slots. Enter ingredients, portion, and unit cost. Selling price, pour cost %, and GP calculate automatically.
• Stock Take — Weekly COGS tracking by category (Spirits, Beer, Wine, Cocktails, Non-Alcoholic). Opening stock, purchases, closing stock — done.
• Waste & Spillage Log — Track spillage, over-pours, breakage, and theft. 60 entries with a summary by waste type.
• Performance Tracker — 12-week trend table so you can see direction, not just a snapshot.
• Benchmarks — Australian industry pour cost benchmarks by category with editable targets.

Built for operators, not accountants. Blue cells are your inputs. Everything else calculates automatically.

No subscriptions. No logins. Download once, use forever.

Requires Microsoft Excel or Google Sheets.