# Job cost report template

Excel workbook with live formulas: https://os.construction/templates/job-cost-report-template.xlsx

**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) |
|   |   |   |   |   |   |   |   |   |   |
|   |   |   |   |   |   |   |   |   |   |
|   |   |   |   |   |   |   |   |   |   |
|   |   |   |   |   |   |   |   |   |   |
|   |   |   |   |   |   |   |   |   |   |

## How to use it

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.

Template by os.construction: https://os.construction/resources/templates/job-cost-report. Sample rows are illustrative; your contract and specifications govern.
