Job cost report template with the formulas live.
One line per cost code: budget, approved and pending changes, committed cost, cost to date, the PM’s cost to complete, EAC and variance. Flags catch the lines that are understated, and a summary sheet gives projected margin and fade.
What’s in the workbook
The download is one Excel file (73 KB) with 3 sheets: Instructions, Job cost report, Summary. The formulas are live, the inputs are marked, and it opens in Excel for Windows and Mac, Excel for the web, Google Sheets and LibreOffice. This is the Job cost report sheet with the sample data:
Formula in L5: =IF($A5="","",I5+K5)| A | B | C | D | F | H | I | J | K | L | M | P | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Job cost report | |||||||||||
| 2 | Project | Riverside Medical Center (sample) | Job # | 10/31/2026 | Prepared by | Project manager | ||||||
| 3 | Blue cells on yellow are inputs; black cells are formulas. One line per cost code. EAC = cost to date + estimated cost to complete. Variance = revised budget − EAC, so a negative (red) number is a projected overrun. Sample data is illustrative. | |||||||||||
| 4 | Cost code | Description | Cost type | Original budget | Revised budget | Committed cost | Cost to date | Open commitments | Est. cost to complete | Est. cost at completion (EAC) | Variance: under / (over) | Flag |
| 5 | 01-3100 | Project management and supervision | Labor | $1,850,000 | $1,850,000 | $0 | $1,310,000 | $0 | $610,000 | $1,920,000 | ($70,000) | Over budget |
| 6 | 01-5000 | Temporary facilities and controls | Other | $420,000 | $420,000 | $185,000 | $236,000 | $0 | $170,000 | $406,000 | $14,000 | |
| 7 | 01-5400 | Equipment rental (lifts) | Equipment | $260,000 | $260,000 | $48,000 | $188,000 | $0 | $92,000 | $280,000 | ($20,000) | Over budget |
| 8 | 01-7400 | Cleaning and waste | Other | $95,000 | $95,000 | $22,000 | $61,000 | $0 | $41,000 | $102,000 | ($7,000) | Over budget |
| 9 | 03-3000 | Cast-in-place concrete | Subcontract | $2,240,000 | $2,254,500 | $2,254,500 | $2,190,000 | $64,500 | $64,500 | $2,254,500 | $0 | |
| 10 | 05-1200 | Structural steel | Subcontract | $1,960,000 | $1,960,000 | $1,935,000 | $1,935,000 | $0 | $0 | $1,935,000 | $25,000 | |
| 11 | 06-1000 | Rough carpentry materials | Material | $145,000 | $145,000 | $98,000 | $87,000 | $11,000 | $52,000 | $139,000 | $6,000 | |
| 12 | 07-5400 | Roofing | Subcontract | $610,000 | $610,000 | $598,000 | $402,000 | $196,000 | $196,000 | $598,000 | $12,000 | |
| 13 | 08-4100 | Storefront and glazing | Subcontract | $430,000 | $430,000 | $412,000 | $96,000 | $316,000 | $342,000 | $438,000 | ($8,000) | Over unless pending changes are approved |
| 14 | 09-2900 | Gypsum board | Subcontract | $2,960,000 | $2,960,000 | $3,120,000 | $1,404,000 | $1,716,000 | $1,716,000 | $3,120,000 | ($160,000) | Over budget |
| 15 | 09-3000 | Tiling | Subcontract | $540,000 | $540,000 | $525,000 | $0 | $525,000 | $525,000 | $525,000 | $15,000 | |
| 16 | 09-9100 | Painting | Subcontract | $380,000 | $380,000 | $372,000 | $51,000 | $321,000 | $321,000 | $372,000 | $8,000 | |
| 17 | 22-1000 | Plumbing | Subcontract | $1,720,000 | $1,741,000 | $1,741,000 | $1,012,000 | $729,000 | $729,000 | $1,741,000 | $0 | |
| 18 | 23-3300 | Air duct accessories | Subcontract | $412,000 | $471,000 | $455,000 | $318,000 | $137,000 | $120,000 | $438,000 | $33,000 | Cost to complete is below open commitments |
| 19 | 26-0500 | Electrical | Subcontract | $3,820,000 | $3,820,000 | $3,880,000 | $2,210,000 | $1,670,000 | $1,670,000 | $3,880,000 | ($60,000) | Over budget |
| 20 | 31-2300 | Excavation and fill | Subcontract | $690,000 | $709,000 | $709,000 | $709,000 | $0 | $0 | $709,000 | $0 | |
Sheets
- Instructions
- What each column means, the color key and how to roll the report forward each month.
- Job cost report
- 30 cost-code lines with drop-down cost types, flags and frozen headers; totals at the bottom.
- Summary
- Totals by cost type, revised contract, projected gross profit, margin, fade since bid and cost-to-cost % complete.
Built in
- Live formulas: change an input and every total, flag and chart updates
- Frozen header rows and columns, so labels stay put as you scroll
- Drop-down lists and value checks on the input cells
- Conditional formatting for flags and overruns
- An Instructions sheet with every column defined
- Prints landscape, one page wide, with the header row repeated
Worked example: Riverside at the October close
Illustrative numbers from the sample file. Sixteen cost codes carry $18,645,500 of revised budget, $16,354,500 committed and $12,209,000 spent to date. The PMs’ estimates to complete add $6,648,500, so the estimate at completion is $18,857,500 and the total variance is ($212,000): a projected overrun.
The flags show where it comes from. Gypsum board was bought out over budget, ($160,000) on that line alone, and the signed subcontract locks it in. Air duct accessories looks $33,000 under budget, but its cost to complete of $120,000 is less than the $137,000 still owed on the subcontract, so the line is understated rather than saving money. Storefront is ($8,000) today and turns positive only if the pending $18,500 budget change is approved.
On the Summary sheet, the revised contract of $20,274,850 less the EAC leaves projected gross profit of $1,417,350, a 7.0% margin against 8.0% at bid. That is -1.04 points of fade to explain at the monthly review, before it shows up on the WIP schedule.
The formulas in the file
Revised budgetJob cost report · F5
=IF($A5="","",D5+E5)Original budget plus approved budget changes. Pending changes stay out.
Open commitmentsJob cost report · J5
=IF($A5="","",MAX(0,H5-I5))What is still owed on signed subcontracts and POs, never below zero.
Est. cost at completionJob cost report · L5
=IF($A5="","",I5+K5)Cost to date plus the PM’s estimated cost to complete.
VarianceJob cost report · M5
=IF($A5="","",F5-L5)Revised budget minus EAC. Negative is a projected overrun and turns red.
FlagJob cost report · P5
=IF($A5="","",IF(K5<J5,"Cost to complete is below open commitments",IF(M5<0,IF(M5+G5>=0,"Over unless pending changes are approved","Over budget"),"")))Cost to complete below open commitments, over budget, or over unless pending changes are approved.
Projected gross profitSummary · B18
=B16-B17Revised contract minus the EAC from the report.
Job cost report template: printable version
os.construction · free template- Project
- Job #
- Period ending
- Prepared by
Job cost report (sample lines)
| Cost code | Description | Original budget | Revised budget | Committed cost | Cost to date | Open commitments | Est. cost to complete | Est. cost at completion (EAC) | Variance: under / (over) |
|---|---|---|---|---|---|---|---|---|---|
| 01-3100 | Project management and supervision | $1,850,000 | $1,850,000 | $0 | $1,310,000 | $0 | $610,000 | $1,920,000 | ($70,000) |
| 01-5000 | Temporary facilities and controls | $420,000 | $420,000 | $185,000 | $236,000 | $0 | $170,000 | $406,000 | $14,000 |
| 01-5400 | Equipment rental (lifts) | $260,000 | $260,000 | $48,000 | $188,000 | $0 | $92,000 | $280,000 | ($20,000) |
| 01-7400 | Cleaning and waste | $95,000 | $95,000 | $22,000 | $61,000 | $0 | $41,000 | $102,000 | ($7,000) |
Sample rows are illustrative and marked for deletion. Your contract, drawings and specifications govern. Template from os.construction/resources/templates/job-cost-report
Using the job cost report template
- Cut off cost at the period end first: post the invoices and payroll that belong to the month, so cost to date is complete before anyone estimates what is left.
- Enter one line per cost code with its budget, approved budget changes, pending changes, committed cost and cost to date. Pending changes stay out of the revised budget until they are approved.
- Have the PM enter a cost to complete for every line from what is actually left: open commitments, remaining quantities at today’s unit cost, months of general conditions. Never back into it from the budget.
- Read the flags. A cost to complete below open commitments means the line is understated. A red variance is a projected overrun; “over unless pending changes are approved” tells you which change orders to chase.
- On the Summary sheet, compare the projected margin with the margin at bid. The fade is what the monthly cost review should explain.
- Save a copy every month. The trend in EAC is what shows a job fading, more than any single month.
- Budget by cost codeOriginal + approved changes
- Committed and cost to dateSubcontracts, POs, invoices, payroll
- Cost to completePM estimate per line
- EAC and varianceCost to date + cost to complete
- Projected marginRevised contract − EACFade: re-estimate: back to “Cost to complete”
- WIP scheduleCost-to-cost % complete
Text version
- Budget by cost code: Original + approved changes
- Committed and cost to date: Subcontracts, POs, invoices, payroll
- Cost to complete: PM estimate per line
- EAC and variance: Cost to date + cost to complete
- Projected margin: Revised contract − EAC
- WIP schedule: Cost-to-cost % complete
Fade: re-estimate: from “Projected margin” back to “Cost to complete”.
Do this in os.construction instead of a spreadsheet
In os.construction the Budget tool is the job cost report: per cost code and cost type it shows original budget, budget modifications, approved and pending budget changes, revised budget, committed costs, direct costs, pending cost changes, projected costs and projected over/under, with pending changes kept apart from approved numbers. The Forecast tab adds forecast to complete, which the PM can override on any line, and estimated cost at completion. Monthly budget snapshots and the Variance tab give the trend. Commitments, change orders and invoices feed the same lines, so nobody retypes them into a spreadsheet.
Try it on the sample project
Every trial workspace includes a sample project to run this workflow on. 14-day free trial. Pricing for paid plans isn't set yet.
Questions about the job cost report template
What is a job cost report in construction?
A report for one project that compares, by cost code, what was budgeted, what is committed, what has been spent and what the job is now expected to cost (the estimate at completion). Its variance column shows which codes are heading over or under budget, and its totals drive projected margin and the WIP schedule.
How do you calculate estimate at completion (EAC)?
EAC = cost to date + estimated cost to complete. The cost to complete should come from what is actually left on the line (open commitments, remaining quantities, remaining months of general conditions), not from the budget minus cost to date, which assumes the rest of the work goes exactly to plan.
What is the difference between committed cost and cost to date?
Committed cost is what you have signed up to spend through subcontracts and purchase orders, including approved changes to them. Cost to date is what has actually been incurred and recorded. The gap between them, open commitments, is a floor for the cost to complete on that line.
Why does the template keep pending changes out of the revised budget?
Because they are not approved. Counting a pending change order as budget makes the variance look better than the contract supports. The template shows pending changes beside the budget and flags lines that are over budget unless those changes are approved.
Does it work in Google Sheets?
Yes. Upload the .xlsx to Google Drive and open it with Google Sheets; the formulas, drop-downs and conditional formatting carry over. It also opens in Excel for Windows and Mac, Excel for the web and LibreOffice.
Keep going
- Pillar guideConstruction cost reporting explained
- Free toolEstimate at completion calculator
- os.constructionProject financials and job costing
- GlossaryCommitment
- GlossaryCost code
- GlossaryCost report
- GlossaryCost-to-complete
- GlossaryCost-to-cost method
- GlossaryEstimate at completion
- GlossaryJob costing
- GlossaryMargin fade
- Free resourceEstimate at completion calculator
- Free resourceWIP schedule workbench
- Free resourceCost-to-complete worksheet (CSV)
- Free resourceHow to set up construction cost codes
- Free resourceHow to run a cost-to-complete review
- Free resourceHow to calculate general conditions costs
- TemplatePunch list template
- TemplateMeeting minutes template
- TemplateInspection checklist starter pack
- TemplateT&M ticket template
- TemplateRFI writing checklist
- TemplateDaily log checklist
- TemplateChange event log
- TemplateBack charge notice and log
- TemplateThree-week look-ahead template
- TemplateSafety observation log
- TemplateAction item tracker
- TemplateCloseout and TCO checklist
- TemplateNotice to proceed template
- TemplateConstruction schedule (Gantt) template
- TemplateChange order log template
- TemplateBid tabulation and leveling template
- TemplateCash flow projection template
- TemplateBuyout log template
- TemplateASI log template
Keep exploring
Related across os.construction
- Free toolEstimate at completion calculatorForecast final cost, cost-to-complete and margin fade.
- PlatformJob costing (use case)How os.construction handles job costing on one record.
- BlogHow to run a cost-to-complete review: forecast what's left, line by line, before the job fadesA cost-to-complete review is where a job's margin is actually forecast. Cut off cost, refresh commitments, forecast each cost code from what is physically left, compare the estimate at completion with budget, and roll it up into projected margin. Here is each step, a weekly labor check, and a worked four-code example.
- DocsJob cost reports and cost-to-completeHow the job cost report is built by cost code from budget, commitments, actual cost and the forecast, how cost-to-complete is set in the Budget tool, and which flags are planned.
- ExplainerConstruction cost reporting explainedCost report columns, accruals, EAC and earned revenue on one job, into the WIP.
- BlogConstruction job costing: how to set up cost codesA cost code list decides what your job cost report can tell you. Too coarse and overruns hide; too fine and the field codes everything to the first line on the list. Here's how to structure codes and cost types, when to follow CSI MasterFormat and when to build your own, a worked tenant improvement budget, and the rules that keep coding clean.