Which jobs actually make you money?
This is the kind of dashboard we build from a trade business's invoices and job records. It shows profit by job type and customer, month by month, and who's slow to pay. Use the filters to explore.
Sample data. Example Plumbing Co. is made up: a small Sydney plumber with twelve months of invented jobs and invoices. Your dashboard would use your own records.
- Gross profit
- —
- Revenue (ex GST)
- —
- Gross margin
- —
- Jobs completed
- —
- Profit per labour hour
- —
Profit per hour on the tools
By job type, after parts, labour and travel. Hover or tap a row for detail.
Show as a table
| Job type | Jobs | Revenue | Gross profit | Margin | Per hour |
|---|
Monthly revenue, split into costs and profit
- Gross profit
- Costs (parts, labour, travel)
Show as a table
| Month | Jobs | Revenue | Costs | Gross profit | Margin |
|---|
By customer type
"Days to pay" is the average time from job to payment, weighted by invoice size. "Still owed" is unpaid at 30 September.
| Customer type | Jobs | Revenue | Margin | Days to pay | Still owed |
|---|
What the numbers say
How it's worked out: revenue is the invoice total excluding GST. Costs are parts, labour at $68 an hour (wages plus super and on-costs, time and a half after hours) and $25 a visit for travel. Gross profit doesn't take out overheads like insurance, the van lease or accounting fees. All figures are for the made-up business above.