Free job cost tracker · Excel workbook

Construction job costing template.

Connect the approved cost budget to commitments, actual expenses, remaining estimates, forecast final cost, variance, gross profit, and margin—while keeping every transaction tied to a cost code and source document.

Published August 9, 202618 minute guide · Excel workbook · No email required

The short version

Set the budget once, log every project cost from a source document, separate actual spending from unspent commitments, and update remaining estimates so the forecast explains where the job is heading—not only where it has been.

Use the file now

Download a real working workbook—not a screenshot.

The template includes sample records, editable inputs, formulas, validation, and visible checks. Download it directly, save a clean master copy, then duplicate it for each project.

Workbook structure

Each sheet has one clear job.

Budget and Forecast

Build the cost baseline by code, record approved internal budget changes, and compare revised budget with actual cost, open commitments, remaining estimate, and forecast final cost.

Commitments and Cost Log

Track vendor obligations separately from invoices and receipts so actual spending and unspent committed amounts are not counted twice.

Job Summary and Checks

Review forecast cost, cost to complete, gross profit, margin, category variance, missing fields, duplicate IDs, and reconciliation status.

Recommended workflow

Set the baseline, update the facts, and review the exceptions.

Set the commercial and cost baselines

Enter the original contract amount, approved client changes, approved internal budget, status date, project information, and the accounting conventions the company intends to use.

Client revenue and internal cost-budget changes remain separate.

Create practical cost codes

Use codes that match how the company buys, assigns, reviews, and corrects work. Keep the list detailed enough for action but stable enough that entries are not constantly reclassified.

Each budget row has a unique code, scope label, category, and approved amount.

Record commitments before they become surprises

Enter approved purchase orders, subcontracts, or vendor obligations and track the unspent balance separately from actual invoices posted to the job.

Forecast cost includes only the open portion of active commitments.

Log costs from source documents

Record the date, vendor, description, cost code, invoice or receipt reference, amount, payment status, and file location. Credits should reduce cost through a controlled entry type rather than a negative input convention.

Every cost can be traced to supporting documentation.

Forecast remaining work and review weekly

Update uncommitted estimate-to-complete amounts, investigate over-budget signals, resolve missing codes, and compare forecast final cost with revised budget and project revenue.

The team can explain the forecast, variance, and next corrective action.

Worked example

One trade can show why actual cost alone is incomplete.

A forecast should reflect what has been spent, what remains committed, and what additional uncommitted work is still expected. The example is illustrative and should be replaced with the company's own code structure and accounting policy.

Cost viewIllustrative amountWhat it means

Revised framing budget$82,000The current approved internal budget after documented cost-plan changes.

Actual framing cost$46,500Invoices, payroll allocation, receipts, or other recorded project cost to date.

Open commitments$28,000The unspent balance of active framing vendor or subcontract commitments.

Uncommitted estimate to complete$11,500Expected remaining framing cost not yet represented by an active commitment.

Forecast final cost$86,000Actual plus open commitments plus uncommitted estimate to complete.

Variance at completion($4,000)Revised budget minus forecast final cost; a negative result requires review.

Control the exceptions

Use visible checks before the weekly review ends.

Unique IDs and cost codesFlag duplicate budget codes, commitment IDs, or cost-entry IDs before they corrupt summaries or make source records ambiguous.
Known code and commitmentEvery populated cost entry should use a valid code, and every linked commitment ID should exist in the commitment register.
Actual-versus-commitment integrityFlag linked actual cost that exceeds the revised commitment and prevent completed or cancelled commitments from carrying an open balance.
Forecast tie-outActual cost plus open commitments plus uncommitted estimate to complete must equal forecast final cost at the code, category, and total-job levels.
Revenue and margin logicApproved client changes affect revised revenue; internal budget changes affect the cost plan. Gross profit and margin should derive from revised revenue and forecast final cost.

Every cost entry has a valid project code, vendor, description, source reference, amount, and status.Actual costs and the remaining balance of commitments are not counted twice.Credits, voids, approved client changes, and internal budget changes use separate controlled fields.Remaining estimates reflect current scope and field knowledge rather than a stale original budget.Workbook totals tie to the source records and any accounting-system differences have been investigated.

Use with judgment

The workbook is only as credible as its source records and update discipline.

A useful job-cost view needs complete, orderly supporting records and a clear connection from each entry to the project. Preserve invoices, receipts, payment evidence, purchase orders, payroll support, and other documentation under the company's accounting and retention practices.

IRS business recordkeeping guidanceGeneral U.S. guidance on maintaining business records and supporting documents that identify items such as payee, amount, payment evidence, date, and description.

This template is general operational information, not accounting, tax, audit, payroll, or legal advice. It is not a general ledger or financial statement. Confirm cost definitions, burden, tax treatment, overhead, retention, and recordkeeping with qualified professionals.

Questions contractors ask

Practical answers before you put the workbook to work.

What does a construction job costing template track?

A useful job-costing workbook connects a project budget to transaction-level actual costs, open commitments, remaining estimates, forecast final cost, variance, and project revenue. It should preserve the underlying receipt, invoice, purchase order, or other source reference for each entry.

What is the difference between budget, actual cost, and commitment?

The budget is the approved internal cost plan. Actual cost is spending already recorded to the job. A commitment is an approved vendor or subcontract obligation whose unspent balance may still affect forecast cost. Treating those amounts separately helps avoid double counting.

Does this workbook replace accounting software?

No. It is an operating template for project-level cost awareness and forecasting. It does not replace the general ledger, payroll, tax records, bank reconciliation, financial statements, or review by a qualified accounting professional.

Does the workbook automatically sync with ProBuilder OS?

No. This is a standalone Excel resource. ProBuilder OS Pro and Business currently provide four-category budgets; committed, actual, and paid cost records; project and company forecast-earnings views; and project-ledger CSV export, but workbook rows do not automatically import or synchronize.

From workbook to operating record

Move from a standalone tracker to connected project financial control.

ProBuilder OS Pro and Business currently connect four-category budgets, committed and actual costs, paid amounts, forecast earnings, and a project-ledger CSV export to the active project. This workbook adds a more granular standalone cost-code and estimate-to-complete planning layer; it does not imply automatic import, QuickBooks connection, or other synchronization.

Explore construction job costing