Profit per job calculator and Excel template, South Africa
Short answer: profit on a job is what you invoiced, less what the job cost you. Enter both below and you get the profit, the margin (profit as a share of what you invoiced) and the markup (profit as a share of the cost), with VAT handled the right way for your business.
What did this job really make?
Healthy margin on this job.
The VAT rule
If you are registered for VAT, leave VAT out of both sides. The VAT you charge belongs to SARS, so it is not your income, and the VAT you pay on materials is claimed back, so it is not your cost. Type costs as you paid them, with VAT, and the calculator takes the VAT out.
If you are not registered, you cannot claim VAT back. The VAT you pay on materials is a real cost of the job, so it stays in. Choose No above and the calculator keeps it.
Download the Excel template
For more than one job, or to keep a record, use the template. It has a sheet for one job in detail (up to 50 cost lines), and an All jobs log that totals your jobs and shows the margin on each, so you can sort the weakest to the top.
| File | What is in it | Download |
|---|---|---|
| Profit per job template (.xlsx) | One job in detail, an All jobs log for 500 jobs, and a How to use sheet. Live formulas, with sample rows to overwrite. | Download Excel |
Margin and markup are not the same
A job invoiced at R12,000 that cost R6,800 made R5,200. That is a 43.3% margin (5,200 ÷ 12,000) and a 76.5% markup (5,200 ÷ 6,800). People mix the two up and end up pricing too low. If you want a 30% margin, adding 30% to your cost is not enough. The markup and margin calculator works it out in both directions.
A job only looks profitable if every cost is in
- Small purchases add up. Silicone, screws, fuel to site and the second trip for the part you forgot are all costs of the job.
- Count your own time. If you spend 20 hours on a job you priced as 10, that shows up here when you enter hours and your rate.
- Subcontractors and hire belong on the job that used them, not in general overheads.
- Overheads are separate. Insurance, your phone and your bakkie are not in this number, so a healthy job margin still has to cover them.
Know it for every job, without a spreadsheet
In Zuvo you tag each expense to the job it belongs to, and the Reports page shows the profit and margin on every job, including the ones that lost money. It is on the Growth and Business plans, and in the 14-day trial.
Try Zuvo free for 14 days, no cardHow we checked it
The calculator and the template use the same rule, and the template's formulas were recalculated with a separate calculation engine, including a job that is not VAT-registered, a job with your own time counted, and a job that loses money. We have not opened the template in every spreadsheet program. It should work in Excel, Google Sheets and LibreOffice.
Questions people ask
How do I calculate profit on a job?
Profit = what you invoiced, before VAT, less everything the job cost you. Add up materials, subcontractors, fuel, hire and, if you want the true picture, your own time. Margin is the profit divided by what you invoiced, and markup is the profit divided by the cost.
Should the profit calculation include VAT?
If you are VAT-registered, no: VAT you charge is not income and VAT you pay on costs is claimed back. If you are not registered, you cannot claim VAT back, so the VAT you pay on materials is part of the cost of the job.
What is a good profit margin on a job?
It depends on the trade and on your overheads, so there is no single right number. What matters is that the margin on your jobs, taken together, covers your overheads (insurance, vehicle, phone, admin) and leaves you something. The calculator flags a margin under 20% as thin, which is a prompt to check, not a rule.
Why is my margin lower than my markup?
They divide the same profit by different things. Markup divides by the cost, which is the smaller number. Margin divides by the price, which is the bigger one. So the margin is always the smaller percentage.
Should I count my own time?
Yes, if you want to know whether the job paid you properly. A job that makes a profit only because your time was free may not be worth doing at that price. Enter your hours and your usual hourly rate.
A calculator and general guidance, not financial or tax advice. A job is only as profitable as the costs you remember to include.