Job Cost Tracking Spreadsheet: Budget vs Actual by Job
A job cost tracking spreadsheet compares what you estimated against what you’re actually spending — material, labor, subs, and other — line by line, per job, while the job is still running. It turns “I think we made money” into a number you can see, and it catches an overrun in week one instead of at the final invoice when it’s too late to fix.
Most contractors only find out a job lost money after it’s over — when they finally add up receipts. Job costing flips that: you set the budget from your estimate, log actuals as you go, and watch the variance. The jobs that quietly bleed margin show themselves early, while you can still adjust labor, scope, or a change order.
What to track per job
- Estimated cost for each bucket — pulled straight from your estimate: materials, labor, subs, other.
- Actual cost as it lands — receipts, hours, sub invoices.
- Variance (actual − estimate) per bucket, in dollars and %.
- Contract price + change orders — so revenue is current.
- Profit to date — contract price minus actual cost, and projected at completion.
A real example: the job that “felt” profitable
| Bucket | Estimated | Actual | Variance |
|---|---|---|---|
| Materials | $2,560 | $2,610 | +$50 |
| Labor | $2,100 | $2,760 | +$660 |
| Prep/removal | $440 | $500 | +$60 |
| Cost | $5,100 | $5,870 | +$770 |
The contract was $5,900. On paper it “felt” fine — but the labor ran 1.3 days over, and the real profit shrank from an expected $800 to $30. Without job costing, you’d never know the labor estimate was the leak — and you’d repeat it on the next ten jobs. With it, you fix your production rate or your burdened labor rate before it compounds.
Job Cost Tracker (Budget vs Actual)
Per-job budget-vs-actual with material/labor/sub logs, variance flags, and profit-to-date — so you know which jobs actually made money. Editable in Excel and Google Sheets.
Make it a habit, not a post-mortem
Job costing only works if it’s live. Log actuals weekly — material receipts and crew hours take five minutes. The point isn’t a tidy record after the fact; it’s the early warning while you can still act: pull a crew member, tighten scope, or write a change order for work that grew. Feed the final actuals back into your next estimate and your pricing gets sharper every job.
Trade Templates Co. builds back-office templates for solo trade businesses, QA’d against real job numbers before they ship. Numbers are illustrative.
Frequently asked questions
What’s the difference between an estimate and job costing?
The estimate is your budget before the job; job costing tracks actuals against that budget during and after, so you see variance and real profit.
What should I track for each job?
Estimated vs actual for materials, labor, subs, and other; the contract price plus change orders; and profit to date.
How often should I update it?
Weekly — log receipts and crew hours as they happen so overruns surface early, not at the final invoice.
Can I use it in Google Sheets?
Yes — it’s built for Excel and Google Sheets with the variance and profit math already in place.
Get the Tuesday Template
One field-tested back-office template and a profit tip in your inbox each week. No fluff.