An estimate vs actual report compares what you expected each part of a job to cost with what it really cost, in the same categories. Before you trust the variance, check three things: every cost got captured, every cost landed on the right job, and the estimate and the actuals use the same categories. If any of those fail, the report is answering a different question.
Most owners I talk to have run this report at least once and walked away more confused. The job they know was a mess shows up under budget. A job that felt fine shows a loss. The report is not lying, exactly. It is doing math on whatever reached it.
What the report is supposed to tell you
A useful estimate vs actual report answers six questions for every job:
- What did we expect it to cost?
- What did it actually cost?
- What was the gross profit and gross margin?
- Where was the variance?
- Why did it happen?
- What should change next time?
The first four are math. The last two are judgment, and they only work if the math is right.
A worked example
Here is a simplified report for one remodeling job. The numbers are an illustrative example, not a real job.
| Category | Estimate | Actual (as reported) | Variance |
|---|---|---|---|
| Labor | $24,000 | $19,500 | $4,500 under |
| Materials | $31,000 | $29,800 | $1,200 under |
| Subcontractors | $22,000 | $18,000 | $4,000 under |
| Other direct costs | $5,000 | $6,700 | $1,700 over |
| Total direct cost | $82,000 | $74,000 | $8,000 under |
On paper this job came in $8,000 under budget. Now look closer:
- Subcontractors $4,000 under. Was the final sub invoice entered? If you committed $22,000 to subs and only $18,000 has been billed, the job is not under budget. The bill has not arrived yet.
- Labor $4,500 under. Is crew time tracked by job, or is some of it sitting in payroll with no job attached? Labor that never reaches the job makes every job look cheaper than it was.
- Other direct costs $1,700 over. This is often where unassigned card purchases end up, or where they should have ended up. Ask what is in there and what is missing.
In this example, add the $4,000 final sub invoice that had not been entered and $4,000 of card purchases that never got a job, and the “underrun” disappears, before any missing labor is counted. The job was not under budget. The actual was incomplete.
The three checks before you trust a variance
1. Did every cost get captured?
Every receipt, card purchase, vendor bill, sub invoice and hour of labor needs to be recorded somewhere. If your team buys materials on the way to a job and the receipt lives in a truck, the cost is real but invisible.
2. Did it land on the right job?
A cost can be captured and still be wrong for job costing. It might be in the books with no job, on the wrong job, in the wrong category, or mixed into the original scope when it was change-order work. Your books can be correct for the company and still wrong for the job.
3. Can it be compared?
If the estimate says “Framing” and the accounting says “Lumber” and “Subcontractor expense,” you are comparing different buckets. Estimate and actuals need to use the same categories, which is what a cost code structure is for.
What to fix first
Start with the check that fails most often in your business. For many contractors it is capture: one routine for recording the job and what was bought at the time of purchase fixes more variance than any new report. For others it is labor, because time is tracked for payroll but not by job.
Do not start with a dashboard. A better-looking report on incomplete data is still incomplete.
When to involve your bookkeeper or CPA
Your bookkeeper and CPA make sure the books are right for the company: taxes, reconciliations, financial statements. Job costing is an operating question that sits on top of that. When you change categories, coding rules or how costs are recorded, involve your bookkeeper so the books and the jobs stay in agreement, and confirm anything that touches tax or revenue recognition with your CPA. I am not a CPA, and this is operational guidance, not accounting advice.
Next step
If you are not sure which of the three checks your business fails, the free Job Cost Readiness Scorecard walks through them in 12 questions. The readout shows on screen, no email needed. For the bigger picture, see job costing for contractors and why your profit and loss does not show which jobs make money.