Disclosure: Augmented Trades participates in affiliate programs with some tools mentioned here, including Jobber, Housecall Pro, and Intuit QuickBooks. We may earn a commission if you subscribe through our links, at no additional cost to you. We never accept payment for a recommendation. See our full disclosure.
A job costing template is the difference between a contractor who looks busy and one who actually makes money. It’s a simple spreadsheet that tracks every cost on a job — labor, materials, subs, equipment, permits — against the price you charged, so you can see the real profit and margin on each job instead of guessing. This guide covers what to track, how to set one up, the mistakes that quietly eat your margin, and a done-for-you tracker if you’d rather skip the building.
What is job costing?
Job costing is assigning every dollar of cost to the specific job that incurred it, then comparing that total to what the customer paid. Estimating happens before the job (your bid); job costing happens during and after (what it actually cost). The gap between the two is where your profit lives — or leaks. A good job costing template makes that gap visible on every job, not just at tax time.
Why every contractor needs one
Most trade businesses know their total revenue but not which jobs, services, or customers actually make money. Without job costing you can’t answer the questions that decide whether you grow or grind: Are my estimates accurate? Which job types carry the best margin? Where did this job go over — labor, materials, or a sub? Job costing turns those from gut feelings into numbers, so you bid sharper and stop repeating the jobs that lose money.
What to track in a job costing template
A complete job costing template captures, per job:
- Contract price — what the customer is paying.
- Labor — hours × loaded rate (include payroll taxes, not just wage).
- Materials — including the small stuff that adds up.
- Subcontractors — electrical, plumbing, etc.
- Equipment — rentals, fuel, wear.
- Permits & fees.
- Estimated vs. actual for each line — the comparison that makes you a better estimator.
- Profit, margin %, and variance — calculated automatically.
How to set one up (5 steps)
1. List each job with its contract price. 2. Log costs as you go, tagged by category. 3. Record both your estimate and the actual for each line. 4. Let the sheet compute profit, margin, and over/under-budget. 5. Review monthly — look for patterns in what goes over and adjust your next bids. The key is logging during the job; reconstructing costs weeks later is where accuracy dies.
Common job-costing mistakes
Forgetting labor burden — wages aren’t your real labor cost; add taxes, insurance, and benefits. Skipping small materials — the consumables that never make the estimate. Never comparing estimate to actual — without that loop, your bids never improve. Doing it after the job instead of during — by then you’re guessing. Not separating jobs — lumping everything into one P&L hides your winners and losers.
Skip the building — get our done-for-you Job-Costing & Profit Tracker ($29)
Our Job-Costing & Profit Tracker is a plug-and-play Excel + Google Sheets workbook: log costs with dropdowns, see estimated-vs-actual profit and margin per job, and a Dashboard that rolls up total revenue, profit, average margin, and flags jobs that went over budget. Instant download. Get the Tracker →
Connecting job costing to your accounting and FSM
A template is the fastest start, but as you grow you’ll want costs flowing automatically. QuickBooks supports job/project costing in its higher tiers, and field-service tools like Jobber and Housecall Pro track job costs alongside scheduling and invoicing. Many shops run a tracker spreadsheet first to learn what to watch, then graduate to software once the habit sticks. (See our QuickBooks Online setup guide for trade contractors.)
Job costing template: quick answers
What is a job costing template?
A spreadsheet that tracks all costs of a job (labor, materials, subs, equipment, permits) against the price charged, so you can see the real profit and margin per job.
Excel or Google Sheets?
Either — a good template works in both. Our tracker ships in Excel and opens in Google Sheets via Drive.
How is job costing different from estimating?
Estimating is your bid before the job; job costing is what it actually cost during and after. Comparing the two is how you make your estimates more accurate over time.
Do I need paid software for job costing?
No. Start with a template — it’s enough to find your margins and tighten your bids. Move to software (QuickBooks, Jobber, Housecall Pro) when you want costs to sync automatically.
Bottom line
A job costing template is the cheapest, fastest way to stop guessing at profit. Track estimated vs. actual on every job, review monthly, and let the numbers sharpen your next bid. Build your own with the columns above — or grab our done-for-you Job-Costing & Profit Tracker and start today.
New to putting AI and templates to work in your office? Start with the free AI Contractor Quick-Start Checklist, or let the free Tool Finder build you a software shortlist.
Related: ready to move past spreadsheets? See our guide to job-costing software for contractors.
Full disclosure: Augmented Trades is an affiliate of Jobber, Housecall Pro, and Intuit QuickBooks mentioned here. See our full disclosure policy.
Related: Free Contractor Invoice Template — bill professionally and get paid faster.
Related: Contractor Estimate Template — quote to win without losing margin (price from cost + markup).
Michael is the founder of Augmented Trades, an independent site that tests and reviews AI tools for trade contractors. Tools are recommended on fit for your shop — affiliate partnerships never decide coverage.