Sample
Karoo Kitchen
A fictional Cape Town restaurant group. Three branches. June 2026, as at 13 July 2026. Walk through the sample, or look around.
Action required. VAT payment of R118 400 due Saturday 25 July. Projected bank balance on that date: R293 400. Headroom after payroll: R89 000. No action needed. Flag for awareness.
Revenue trend, 12 months
Business health score
78/100
CriticalWatchHealthyStrong
Revenue trend: +3pts · Margin health: −4pts · Cash cover: +5pts · Branch balance: −2pts
Food cost at 34.0% has triggered a watch flag. One branch (Sea Point) is pulling the score down with a 14.2% rent to revenue ratio. Both are addressable before peak season.
Monday 13 July 2026
June closed 8.7% below May, consistent with winter seasonality, and 3.1% ahead of June 2025. The top line is performing. Two items require attention before end of month.
Food cost pressure: Cost of goods reached 34.0% of revenue against a 12 month running average of 31.5%. Supplier invoices confirm dairy up 11% and beef up 9% since April. A 4 to 6% menu reprice on the eight highest volume dishes would restore margin without a material customer impact.
Sea Point underperformance: Revenue down 14% year on year while Gardens grew 10.2% and Stellenbosch 6.4%. Sea Point's rent to revenue ratio now stands at 14.2%, against a group average of 7.4%. The lease break in November is the natural decision point.
Profit and loss
Income statement, June 2026 vs June 2025
| Line item | Jun 2026 | Jun 2025 | Change | % of revenue |
|---|---|---|---|---|
| Revenue | R741 200 | R718 900 | +3.1% | 100.0% |
| Food & beverage | (R252 000) | (R224 300) | +12.3% | 34.0% |
| Staff costs | (R209 000) | (R201 800) | +3.6% | 28.2% |
| Rent & occupancy | (R76 500) | (R72 900) | +4.9% | 10.3% |
| Utilities | (R38 900) | (R35 200) | +10.5% | 5.2% |
| Marketing | (R21 400) | (R19 600) | +9.2% | 2.9% |
| Other operating | (R57 300) | (R76 000) | −24.6% | 7.7% |
| Net profit | R86 100 | R89 100 | −3.4% | 11.6% |
Cost breakdown, % of revenue
Cash flow
25 July: VAT payment R118 400. Balance drops to R293 400. Payroll on 28 July: R209 000. Both commitments are met on current projections. No action required.
6 week projected closing balance
Upcoming commitments
| Date | Description | Category | Amount | Status |
|---|---|---|---|---|
| 17 Jul | Supplier, Freshy Produce | Cost of goods | R31 200 | Due |
| 20 Jul | Staff wages advance | Payroll | R31 500 | Due |
| 25 Jul | VAT201, SARS | Tax | R118 400 | Priority |
| 28 Jul | Full payroll, all branches | Payroll | R209 000 | Scheduled |
Branch results
Revenue by branch
Gardens
R318k+10.2%
Stellenbosch
R246k+6.4%
Sea Point
R177k−14.0%
Branch profitability
| Branch | Revenue | Food cost | Staff | Rent | Rent/Rev | Net profit | Net margin |
|---|---|---|---|---|---|---|---|
| Gardens | R318 400 | R108k | R71k | R22 000 | 6.9% | R47 100 | 14.8% |
| Stellenbosch | R245 700 | R83k | R55k | R18 500 | 7.5% | R29 300 | 11.9% |
| Sea Point | R177 100 | R61k | R83k | R25 100 | 14.2% | R9 900 | 5.6% |
Sea Point flag: Rent to revenue ratio of 14.2% is 91% above group average. At current trajectory, a 6% further revenue decline makes this branch loss making. Lease break clause in November is the natural review point.
Scenario planner
Input variables
Projected net profit / month
R86 100
Baseline · June actuals · 11.6% margin
Ask
Karoo Kitchen Group
Reports
June management report
Consolidated profit and loss, branch analysis, cash position, and the notes from this sample. Generated 1 July, 06:15.
Weekly cash flow briefing
Week of 13 July. Expected inflows, outflows, and the 6 week projected balance.
VAT readiness summary
Reconciled output VAT, input VAT, and net payable, formatted for a VAT201 filing.
Branch comparison report
Side by side performance of all three branches. Revenue, margin, rent ratio, and year on year change.
WhatsApp delivery
Monday briefing
Delivered 08:00 every Monday · +27 82 ••• 4471 and 2 others
Alert notifications
A message when a threshold in this sample is breached
Month end report summary
Key metrics on the 1st of each month
Monday briefing · 13 Jul
Jun closed +3.1% YoY. ⚠️ Food cost 34.0%. Action needed. VAT R118k due 25 Jul. Covered. Sea Point −14% YoY. Review required.
June management report is in Reports. 08:00
Jun closed +3.1% YoY. ⚠️ Food cost 34.0%. Action needed. VAT R118k due 25 Jul. Covered. Sea Point −14% YoY. Review required.
June management report is in Reports. 08:00
Monitoring rules in this sample
| Rule | Condition | Last triggered | Status |
|---|---|---|---|
| Food cost alert | Cost of goods > 33% of revenue | 4 July 2026 | Active |
| Revenue drop alert | Any branch drops >15% week on week | Never | Active |
| Cash floor alert | Bank balance falls below R150 000 | Never | Active |
| SARS deadline · VAT | 3 days before VAT201 due date | 22 July (upcoming) | Pending |
| SARS deadline · PAYE | 3 days before EMP201 due date | 4 July 2026 | Active |
Sources in this sample
XeroIn this sample
GAAP POSIn this sample
Google SheetsIn this sample
SageNot in this sample
QuickBooksNot in this sample
Also in Demos: Casa Mia forecast