Job profit calculator for HVAC, plumbing, and electrical jobs
Pick one finished job. Type what the customer paid and what the job cost you: labor hours, parts, permits, fees, and any trip back. The calculator shows the gross profit, the margin, profit per labor hour, and the price that would have hit the margin you want. It runs in this browser. Nothing you type is sent to us.
By James Drake, Founder & CEO · Published · Last checked
Trades Operator publishes this tool and sells field service software. The tool works the same with any software. Nothing you type is sent to us. How we make these tools
A job can look fine on the invoice and still lose money once the crew hours, the materials, and the extra trips are counted. Job costing only works when the estimate, the time, the materials, the expenses, the invoice, and the payment all point at the same job.
Costs that never get tied to a job do not show up in the margin. Drive time is labor. A callback is more labor and more parts. The fee the card processor charged is a cost of collecting the payment. If you leave a cost blank here, the result names it under "Left out of this answer."
Paid and invoiced are not the same number. This calculator uses what the customer paid. Money still owed stays on its own line until it is collected.
Download the sheet and use one ordinary week. One row per job. A blank cell means the paperwork is missing, not that the cost was zero. Type 0 when the cost was zero. Delete the EXAMPLE row before you add your jobs. Then sort by profit per labor hour. The job type at the bottom is the one to reprice or to stop discounting.
Direct cost is the sum of the labor rows and the cost fields you fill in. A blank field is left out. Zero is counted. Gross profit is collected minus direct cost. A negative result is a loss. Gross margin is gross profit divided by collected: collected dollars minus the direct cost of the job, divided by collected dollars. If collected is zero, margin is not shown.
Gross profit per labor hour is gross profit divided by total labor hours. If you type overhead per labor hour, profit after the overhead you assigned is gross profit minus that amount times total labor hours. If you type a target gross margin from 0 to 99.9, the price that would have hit it is direct cost divided by 1 minus that margin. 100 or more is rejected.
Money is integer cents, rounded once at the end of each calculation. Hours take up to two decimals. Percents are one decimal. This page uses no outside figures. It works the same with any software or a paper ledger.
direct cost = labor rows + filled cost fields
gross profit = collected - direct cost
gross margin = gross profit / collected
profit per labor hour = gross profit / labor hours
profit after assigned overhead = gross profit - (overhead per hour x labor hours)
price at a target margin = direct cost / (1 - target margin)
Questions
What counts as a direct cost?
Anything that would not have been spent without this job: labor at what that hour costs you, materials and parts, equipment or rentals, subcontractors, permits and fees, card and payment fees, return trips, and other direct costs. Overhead is separate, and only if you type an amount per labor hour.
Should drive time count?
Yes, if that hour would not have been spent without this job. Put drive time on the labor row for the person who drove. The page does not suggest an hourly cost.
Why is invoiced but unpaid money left out?
Collected is what the customer actually paid. Invoiced but not yet collected is shown as still owed. It is not profit until it is paid.
Is this the same as net profit?
No. Gross profit here is collected dollars minus the direct cost of the job. It is not net profit, and it does not include overhead unless you type an overhead amount per labor hour.
Do you keep the numbers I type?
No. The calculator runs in your browser. Nothing you type is sent to us.