Construction budget analysis: actuals and commitments

Construction budget analysis compares the approved cost baseline with actual costs, open commitments and the cost of work still to buy or perform. Its useful output is expected final cost by cost code, with a documented explanation of every amount above budget. A low invoice total is not evidence that a project will finish within its allowance.

Start with files that describe the same project

Choose one cutoff date and one approved budget version. Export the cost-code budget, job-cost ledger, subcontract and purchase-order register, and change-order log. Ask delivery owners for remaining quantities, labor requirements and work not covered by existing commitments.

Keep project ID, cost code, document ID, supplier, posting date, amount and approval status in the working file. The commitment register also needs current authorized value and the portion already recognized in actual costs. Preserve subcontract identifiers when invoices use a different expense description.

Progress evidence matters because cost control combines scope, schedule and spending. The Department of Energy describes earned value management as integrating those dimensions. This review uses delivery evidence to assess remaining cost; the separate earned value guide covers performance indices.

Step 1: reconcile actual costs before forecasting

Use incurred project costs, including supported accruals, rather than bank payments alone. An unpaid invoice can already be an actual cost. Conversely, an advance payment does not necessarily represent installed work. Have finance apply the project's accounting policy consistently.

Map all ledger rows to the approved cost codes. Put unmapped entries on an exception list instead of distributing them across codes to make the totals agree. Confirm the mapped actuals plus exceptions equal the job-cost ledger control total.

For a US contractor's warehouse project, the reconciled actual costs are the amounts shown in the forecast table below. They include costs charged against supplier commitments and separately incurred costs, such as self-performed work. Those components must remain distinguishable when computing open commitments.

Step 2: remove the committed costs already incurred

The current authorized commitment includes approved amendments. It is not the open balance. For this project, the commitment register produces:

With authorized commitments in B and recognized costs in C, enter this in D2 and fill down:

=B2-C2

Reconcile the total: $550,000 already recognized plus $670,000 still open equals $1,220,000 authorized. Investigate negative balances; an overbilled subcontract, missing amendment or mismatched document ID should not disappear through a formula that forces it to zero.

Step 3: add only work outside those commitments

The remaining uncommitted estimate covers work absent from open contracts and orders. Delivery owners should identify its quantity, expected rate and scope. Do not add another full estimate for a subcontract whose remaining scope is already covered by its open balance.

Expected final cost = Actual costs + Open commitments + Remaining uncommitted cost

Over/(under) budget = Expected final cost − Approved budget

This worksheet uses approved budget in B, actuals in C, open commitments in D and remaining uncommitted cost in E. The latter is a delivery estimate, not the unused budget plugged into a balancing cell.

The formulas in F2 and G2 are:

=SUM(C2:E2)
=F2-B2

Sum each amount column. The remaining cost is $670,000 + $220,000 = $890,000; adding actuals of $650,000 proves the $1,540,000 final-cost total. Exposure is $40,000, or 2.7% of the $1,500,000 budget, rounded to one decimal place. The variance analysis guide explains the broader variance conventions.

Step 4: review changes and assign actions

Maintain separate fields for proposed, approved and incorporated changes. Approval of a supplier change and approval of additional owner funding are different events; record both when relevant. On federal contracts, FAR 43.102 limits modification authority to contracting officers and addresses pricing changes before execution. Private projects follow their own contractual authority.

Show each exposure once. An approved supplier amendment already in open commitments must not be added again from the change log. Likewise, a pending cost included in the remaining estimate needs a flag showing that it is incorporated.

Have the project manager explain the mechanical, electrical and plumbing overrun, procurement validate supplier balances, and finance confirm the ledger tie. Assign a dated action to each unresolved item. Use construction bid analysis for comparing replacement bids and construction project profitability analysis when assessing the effect on margin.

Where it goes wrong

• Full commitments plus actuals. This counts invoiced subcontract work twice and exaggerates exposure.
• Budget remaining called cost to complete. Subtracting spend from budget assumes the project will finish on budget instead of estimating the work.
• Unrecorded progress. Missing accruals make actuals look favorable while work has already been performed.
• Changes counted in several files. A change can appear in a purchase order, remaining estimate and risk log. Give it one cost treatment and retain references elsewhere.

Analyze your construction cost files in Covirage

Bring your cost-code budget, job-cost export, commitment register and remaining-cost worksheet to Covirage. Its tools map the columns, compute final-cost comparisons and check the totals; the external AI model explains the results with every figure traced to its rows. Create a free Covirage account and bring a sample of your own data.

See Covirage for construction for the supporting industry view.