Loading latest data…
⚠️ Could not load live data.
Yan Melbourne · Financial Dashboard
Loading…
Where does every dollar go this week?
Each segment as % of total revenue
Revenue vs stacked costs · last 8 weeks
Revenue line vs cost layers
Food
Labour
Fixed
Variable
Revenue
Net profit · last 8 weeks
Profit and loss by week
Profit
Loss
Trend
This week's alerts
Labour % · last 8 weeks
Target: 40% · dashed = trend
Labour breakdown · this week
Weekly labour detail · last 8 weeks
| Week | Revenue | Wages (Xero) | Cash wages | Super | Total labour | Labour % |
|---|
Food cost % · full year
Target: 30% · dashed = trend
Food %
30% target
Trend
Weekly breakdown · last 8 weeks
| Week | Revenue | Food COGS | Food % | vs target |
|---|
Weekly revenue · full year
Darker = above average · dashed = trend
Cost % trends · full year
Food, labour, net margin
Food %
Labour %
Net %
YTD P&L summary
Cumulative totals to date
Rolling 8-week average · · updates as you navigate weeks
Trend vs prior 8 weeks
↑ improving · ↓ worsening · → stable
Roster budget guide · next week
Based on 8-week avg revenue · target 40% labour
Average weekly P&L · last 8 weeks
What a typical week looks like right now
| Week | Revenue | vs avg | Food % | Labour % | Net profit | Labour $ |
|---|---|---|---|---|---|---|
Scenario planner
$19,000
30%
40%
$2,875
Projected vs actual net profit · last 8 weeks
What you would have made at your scenario targets
Actual
Projected
Square sales data for this week · imported via Google Sheet
No Square data imported for this week yet. Go to your Google Sheet → Square Sales tab → paste CSV → click Yan Dashboard → Import Square Data.
Drinks health check
Target: 20%+ of total revenue
Key dish quantities · this week
Your highest-margin larger dishes
Banquet tracker
Covers and average spend per cover
Manual CSV import
For ad-hoc analysis or weeks not yet in Google Sheet
Larger dishes
| Dish | Qty | Revenue | Avg price |
|---|
Top drinks
| Item | Qty | Revenue |
|---|
Pricing alerts
Revenue by category