Esc

↑↓ move↵ openIndex · Pagefind

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.

  • Free
  • No signup
  • Excel · Google Sheets · LibreOffice
The Excel file

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:

L5Formula in L5: =IF($A5="","",I5+K5)
Job cost report template: preview of the “Job cost report” sheet in job-cost-report-template.xlsx, with the sample data
ABCDFHIJKLMP
1Job cost report
2ProjectRiverside Medical Center (sample)Job #10/31/2026Prepared byProject manager
3Blue 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.
4Cost codeDescriptionCost typeOriginal budgetRevised budgetCommitted costCost to dateOpen commitmentsEst. cost to completeEst. cost at completion (EAC)Variance: under / (over)Flag
501-3100Project management and supervisionLabor$1,850,000$1,850,000$0$1,310,000$0$610,000$1,920,000($70,000)Over budget
601-5000Temporary facilities and controlsOther$420,000$420,000$185,000$236,000$0$170,000$406,000$14,000
701-5400Equipment rental (lifts)Equipment$260,000$260,000$48,000$188,000$0$92,000$280,000($20,000)Over budget
801-7400Cleaning and wasteOther$95,000$95,000$22,000$61,000$0$41,000$102,000($7,000)Over budget
903-3000Cast-in-place concreteSubcontract$2,240,000$2,254,500$2,254,500$2,190,000$64,500$64,500$2,254,500$0
1005-1200Structural steelSubcontract$1,960,000$1,960,000$1,935,000$1,935,000$0$0$1,935,000$25,000
1106-1000Rough carpentry materialsMaterial$145,000$145,000$98,000$87,000$11,000$52,000$139,000$6,000
1207-5400RoofingSubcontract$610,000$610,000$598,000$402,000$196,000$196,000$598,000$12,000
1308-4100Storefront and glazingSubcontract$430,000$430,000$412,000$96,000$316,000$342,000$438,000($8,000)Over unless pending changes are approved
1409-2900Gypsum boardSubcontract$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
1509-3000TilingSubcontract$540,000$540,000$525,000$0$525,000$525,000$525,000$15,000
1609-9100PaintingSubcontract$380,000$380,000$372,000$51,000$321,000$321,000$372,000$8,000
1722-1000PlumbingSubcontract$1,720,000$1,741,000$1,741,000$1,012,000$729,000$729,000$1,741,000$0
1823-3300Air duct accessoriesSubcontract$412,000$471,000$455,000$318,000$137,000$120,000$438,000$33,000Cost to complete is below open commitments
1926-0500ElectricalSubcontract$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
2031-2300Excavation and fillSubcontract$690,000$709,000$709,000$709,000$0$0$709,000$0
InstructionsJob cost reportSummary
Rendered from the downloadable file: same formulas, same sample numbers, same conditional formatting. Sample data is illustrative.

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
Download the .xlsx
Worked example (illustrative)

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-B17

Revised 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 codeDescriptionOriginal budgetRevised budgetCommitted costCost to dateOpen commitmentsEst. cost to completeEst. cost at completion (EAC)Variance: under / (over)
01-3100Project management and supervision$1,850,000$1,850,000$0$1,310,000$0$610,000$1,920,000($70,000)
01-5000Temporary facilities and controls$420,000$420,000$185,000$236,000$0$170,000$406,000$14,000
01-5400Equipment rental (lifts)$260,000$260,000$48,000$188,000$0$92,000$280,000($20,000)
01-7400Cleaning 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

How to use it

Using the job cost report template

  1. 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.
  2. 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.
  3. 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.
  4. 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.
  5. On the Summary sheet, compare the projected margin with the margin at bid. The fade is what the monthly cost review should explain.
  6. Save a copy every month. The trend in EAC is what shows a job fading, more than any single month.
From cost code to projected marginBudget by cost code, then Committed and cost to date, then Cost to complete, then EAC and variance, then Projected margin, then WIP schedule. Fade: re-estimate: from Projected margin back to Cost to complete.Fade: re-estimateBudget by cost codeOriginal + approved changesCommitted and cost to dateSubcontracts, POs, invoices, payrollCost to completePM estimate per lineEAC and varianceCost to date + cost to completeProjected marginRevised contract − EACWIP scheduleCost-to-cost % complete
  1. Budget by cost codeOriginal + approved changes
  2. Committed and cost to dateSubcontracts, POs, invoices, payroll
  3. Cost to completePM estimate per line
  4. EAC and varianceCost to date + cost to complete
  5. Projected marginRevised contract − EACFade: re-estimate: back to “Cost to complete”
  6. WIP scheduleCost-to-cost % complete
From cost code to projected margin
Text version
  1. Budget by cost code: Original + approved changes
  2. Committed and cost to date: Subcontracts, POs, invoices, payroll
  3. Cost to complete: PM estimate per line
  4. EAC and variance: Cost to date + cost to complete
  5. Projected margin: Revised contract − EAC
  6. WIP schedule: Cost-to-cost % complete

Fade: re-estimate: from “Projected margin” back to “Cost to complete”.

In os.construction

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.

FAQ

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

Open file