Loading latest data from Google Sheets…
⚠️ Could not load data from Google Sheets. Showing last cached data instead.
Yan Restaurant · 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: 35% · 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 cost %
30% target
Trend
Weekly breakdown · last 8 weeks
| Week | Revenue | Food COGS | Food % | vs target |
|---|
Weekly revenue · full year
Darker bars = above average · dashed = trend
Cost % trends · full year
Food, labour, net margin
Food %
Labour %
Net %
YTD P&L summary
Cumulative totals to date
Scenario planner
$19,000
30%
38%
$2,875
Projected vs actual net profit · last 8 weeks
What you would have made at your scenario targets
Actual
Projected at targets
FY26 vs FY27 comparison - updates as FY27 data is entered each week
Weekly revenue - FY26 vs FY27
Same week number each year
FY26
FY27
Net profit - FY26 vs FY27
Green = profit, red = loss
FY26
FY27
Labour % - FY26 vs FY27
Target 40% - dashed line
Food cost % - FY26 vs FY27
Target 30% - dashed line
| Wk | FY26 revenue | FY27 revenue | YoY change | FY26 labour % | FY27 labour % | FY26 net profit | FY27 net profit |
|---|