Total Revenue
โ
โ
Agent Costs (TCE)
โ
โ
Overhead Costs
โ
โ
Net Profit / Loss
โ
โ
Gross Margin
โ
โ
Headcount
โ
Active agents
Avg Salary
โ
Per agent / month
Avg GM per Agent
โ
(Turnover โ TCE) รท headcount
Overhead % of Revenue
โ
Lower is better
Break-Even Revenue
โ
โ
Total UIF
โ
Employee contributions
Total SDL
โ
Skills Dev. Levy (1%)
๐ Client Performance
| Client | Agents | Turnover (GBP) | Agent Cost (GBP) | Gross Margin | GM % | Rev / Head | Cost / Head |
|---|
๐ข Overhead by Category
๐ง P&L Waterfall (GBP)
P&L Report
| AGENT TOTALS | Gross Pay | UIF | SDL | TCE (GBP) | Turnover (GBP) | Gross Margin (GBP) | GM % | ||||
|---|---|---|---|---|---|---|---|---|---|---|---|
Recurring Overhead Costs
| Description | Category | Amount |
|---|
Clients
| Name | Status | Actions |
|---|
Agents / Employees
| # | Client | Name | Gross Pay | UIF | SDL | TCE | Actions |
|---|
Contract Values (GBP)
Enter the recurring monthly contract value per client. ZAR equivalent shown live at current rate.
| Client | Contract Value (GBP) | โ ZAR |
|---|
Recurring Overhead Costs
All amounts in ZAR. GBP equivalent is calculated live using the current exchange rate.
| Description | Category | Amount | Active | Actions |
|---|
๐ฐ Working Capital Calculator
Based on monthly turnover. Pre-filled from current total contract values.
How it works
Turnover โค ยฃ20,000โ ยฃ20,000 working capital required
ยฃ20,000 โ ยฃ100,000โ slides linearly from ยฃ20,000 down to ยฃ0
Turnover = ยฃ100,000โ ยฃ0 (break-even, no capital needed)
ยฃ100,000 โ ยฃ200,000โ capital repayment, slides from ยฃ0 to โยฃ20,000