A job costing template is a spreadsheet that records every cost a construction job incurs against cost codes, compares the budget for each code with committed and actual costs, and shows the forecast final cost and variance line by line. It is the simplest tool that can tell you whether a live job is making or losing money before the accounts close. This page gives you a free construction job costing template in Excel and CSV formats, with example rows, and no form to fill in first.
Download the job costing template
Both files hold the same columns and example rows. The Excel version is formatted; the CSV opens in any spreadsheet tool, including Google Sheets.
Replace the example rows with your own cost codes and budgets, then update committed and actual costs on a fixed rhythm, weekly at minimum on an active job. Values are shown without a currency symbol so the template works in any market.
The template structure, with example rows
The template has ten columns. The example rows show a materials line drifting over budget, a fixed-price subcontract holding steady, and a labour line running long. Variance is budget minus forecast final cost, so a negative number is an overrun.
| Cost code | Description | Category (labour/materials/equipment/subcontractor/other) | Budget | Committed | Actual to date | Forecast final cost | Variance | % of budget spent | Notes |
|---|---|---|---|---|---|---|---|---|---|
| 03-100 | Concrete supply | Materials | 85,000 | 62,000 | 41,300 | 86,500 | -1,500 | 49% | Supplier price increase on later pours |
| 04-200 | Bricklaying subcontract | Subcontractor | 120,000 | 120,000 | 74,000 | 120,000 | 0 | 62% | Fixed-price subcontract, fully committed |
| 01-300 | Site management labour | Labour | 96,000 | 0 | 52,800 | 99,200 | -3,200 | 55% | Site running longer than planned |
Every column, explained
The columns work as a set: budget states the plan, committed and actual state the facts, and forecast final cost states your honest expectation. Here is what each one is for.
- Cost code. The standard reference for this type of work, consistent across every job you run. Consistent codes are what make jobs comparable and estimates checkable against actuals.
- Description. A plain-language name for the cost line, matching the language of your estimate so the two documents reconcile.
- Category. Labour, materials, equipment, subcontractor or other. Category totals reveal the shape of an overrun: a labour problem calls for a different response than a materials problem.
- Budget. The approved amount for the line, from the estimate plus approved change orders. Change the budget only through formal change control, never to make a variance disappear.
- Committed. The value of purchase orders and subcontracts signed against this line, whether or not invoiced yet. Committed cost is the column spreadsheet job costing most often omits, and it is the one that sees overruns coming months early.
- Actual to date. Costs actually incurred: invoices received, timesheet hours costed, materials delivered against the line.
- Forecast final cost. Your current best estimate of what the line will cost at completion, informed by committed and actual costs plus the cost to complete the remaining work. This column is a judgement, and it is the most valuable one in the sheet.
- Variance. Budget minus forecast final cost. Negative means an overrun. Reading variance across all lines gives the job's forecast margin position at a glance.
- % of budget spent. Actual to date divided by budget. Read it against physical progress: 80% spent on a line that is 50% built is an early warning even before the forecast moves.
- Notes. The reason behind the numbers: price movements, scope questions, pending change orders. A variance without a note invites the wrong conclusion.
Keeping the template honest week to week
A job costing sheet is only as good as its update rhythm. Enter commitments the day the purchase order or subcontract is signed, not when the first invoice arrives; post actuals weekly; and revisit the forecast final cost on every line whenever committed plus actual moves meaningfully. The discipline of forecasting each line, rather than assuming budget will be met until proven otherwise, is what separates job costing from bookkeeping. Our guide to construction job costing covers the full process, from setting up cost codes to closing out a job.
Common job costing mistakes
The classic mistake is tracking only invoiced costs, which makes every job look healthy until the subcontract invoices land; committed cost exists to close that gap. The second is inconsistent cost codes between jobs, which destroys the feedback loop from actuals back into estimating. Third, forecasts that simply restate the budget: if forecast final cost always equals budget, the column is decoration, not a forecast. Fourth, letting the sheet lag by a month; a job costing sheet updated after the monthly accounts tells you what the accounts already know. Finally, hiding overruns by quietly enlarging budgets, which turns the whole document into fiction.
Where the spreadsheet reaches its limits
On a single job with a disciplined owner, this template will hold up. The limits arrive with volume: costs captured on site that never reach the sheet, commitments entered late, and a portfolio question, which jobs are drifting, that no single spreadsheet can answer. That is the job of job costing software: costs land on their cost code the day they happen, commitments are captured when the order is signed, and the same records roll up to CVR (cost value reconciliation) and portfolio reporting without a copy-paste exercise.
Frequently asked questions
What is a job costing template?
A job costing template is a spreadsheet that tracks a construction job's costs by cost code, comparing budget against committed and actual costs and recording a forecast final cost and variance for each line. It shows whether the job is on course for its planned margin while the work is still in progress.
What is the difference between committed and actual costs?
Committed costs are amounts you are contractually obliged to pay, such as signed purchase orders and subcontracts, whether or not an invoice has arrived. Actual costs are amounts actually incurred to date. Tracking both is what lets a job costing sheet warn you about overruns before the invoices do.
How often should the job costing template be updated?
Enter commitments the day they are signed and post actual costs at least weekly on an active job. Review forecast final cost on every line at the same rhythm as your cost reporting, so the variance column reflects current judgement rather than last month's.
