Venue X Financial Workbook

Run your venue's finances from one spreadsheet.

The Venue X Financial Workbook gives you a complete financial management system — P&L, budget tracking, cash flow forecast, and KPI monitoring — built for Australian bars, restaurants, cafés, hotels, and F&B operations.

What's inside (6 sheets):

• Dashboard — Live KPI tiles: total revenue, COGS, gross profit, GP%, labour cost, labour %, and net profit for the selected month. Monthly performance summary table with 12-month view and YTD totals.
• Weekly Trading — 52-week trading log. Enter revenue by category (food, beverage, other), covers, COGS, labour, and other expenses. All calculations are automatic.
• Monthly Budget — Enter your annual budget once. Actuals pull from Weekly Trading automatically. Budget vs actual variance calculated for every P&L line across all 12 months.
• Cash Flow Forecast — 13-week rolling forecast. Opening balance, weekly inflows and outflows, net cash flow, and running closing balance. Update weekly to stay ahead.
• KPI Tracker — 8 key KPIs tracked monthly across the full year: revenue, covers, average spend per cover, food cost %, beverage cost %, labour %, GP%, and net profit %. Editable targets with YTD averages.
• Benchmarks — Australian P&L benchmarks by venue type (café, casual dining, fine dining, bar, hotel F&B) with editable targets.

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

Requires Microsoft Excel or Google Sheets.