---
title: Construction cost tracking: budget, committed and actual | Efidis
description: A construction cost tracking template with budget, committed and actual cost per line item, plus the math to see what the job will cost before it ends.
url: https://efidis.co/en/blog/control-de-costos-de-obra
lang: en
---

# Construction cost tracking: budget, committed and actual

*Costs and decisions · Efidis team · Updated November 4, 2026*

**In short:** To track construction costs, compare each line item's budget with what you've spent and also with what you've committed: purchase orders and signed subcontracts that haven't been invoiced yet. Budget minus actual minus committed is what's really left. Add each line item's physical progress and an estimate of what's still to be contracted, and you can project the cost at completion and see the overrun months before closeout.

To track construction costs, compare each line item in the budget with what you've spent and also with what you've committed. Actual cost is what's been invoiced or paid; committed cost is purchase orders and signed subcontracts that haven't been invoiced yet. What's really left is the budget minus both. With physical progress and an estimate of what's still to be contracted, you can project each line item's cost at completion while there's still time to fix it. Below is the template, column by column, and the worked math for a line item that looks healthy on the spreadsheet and is already over budget.

We use line item for each row of the budget. If your company calls it a cost code or a budget line, it's the same thing.

## Why does a job go over budget without anyone noticing?

Because most cost tracking spreadsheets compare the budget with invoices, and invoices arrive late. The steel order gets signed today and the invoice comes in weeks later, once the material is already on site. In between, the spreadsheet shows money as available that has already been spoken for. There are three other common leaks:

- Client changes get built without an approved price. By the end, nobody knows which part of the overrun is your own mistake and which part is work the client asked for and never paid for.
- Crew hours get entered by hand at month-end, so labor runs a month behind on the spreadsheet.
- Spending gets measured without looking at progress. Having spent half a line item with 30% of the work done is a problem, and a spreadsheet that only adds up invoices shows it as "halfway there."

On top of that, budgets tend to come in low from day one. Across 258 transportation projects (roads, bridges, tunnels and rail), actual costs exceeded estimates in almost 9 out of 10, with an average overrun of 27.6% (Flyvbjerg, Holm and Buhl, 2002). Those are large public works, not a small firm's warehouse, and the authors' explanation, that budgets are cut on purpose to get projects approved, has its critics (Love and Ahiaga-Dagbui, 2018). But the study makes clear which way a budget usually misses.

## The template: budget, committed and actual by line item

One row per line item, with these columns. It works in any spreadsheet. What matters is where each number comes from and who enters it.

| Column | What goes in it | How it's calculated |
|---|---|---|
| 1. Line item | Foundation, structure, roofing… | One row per line item |
| 2. Original budget | The amount the job was signed for | Doesn't change |
| 3. Approved changes | What the client added (or removed), with its price approved in writing | Sum of the line item's changes |
| 4. Current budget | What the line item is measured against | 2 + 3 |
| 5. Committed | Purchase orders, subcontracts and rentals signed but not yet invoiced | Sum of what's still to be invoiced |
| 6. Actual | Invoices received, payroll and crew hours charged to the line item | Sum of what's been invoiced or paid |
| 7. Truly available | What's really left to finish | 4 − 5 − 6 |
| 8. Physical progress | Percentage of the work completed, measured on site | Measured by the site manager |
| 9. Still to contract | Remaining work with no order or contract, at the latest quote or the budget price | Estimate |
| 10. Projected cost at completion | What the line item will cost when it's done | 6 + 5 + 9 |
| 11. Variance | How much over or under, in dollars and as a percentage | 10 − 4 |

> When an order's invoice arrives, its amount moves out of committed and into actual. If you only add it to actual, the same purchase gets counted twice.

### The template filled in: a warehouse

This example is made up, with round numbers. An engineering firm is building a warehouse with four line items. This is the spreadsheet halfway through the job, in US dollars:

| Line item | Current | Actual | Committed | Truly available | Progress | Still to contract | Projected | Variance |
|---|---|---|---|---|---|---|---|---|
| Foundation | 80,000 | 78,000 | 0 | 2,000 | 100% | 0 | 78,000 | −2,000 (−2.5%) |
| Structure | 120,000 | 60,000 | 45,000 | 15,000 | 50% | 30,000 | 135,000 | +15,000 (+12.5%) |
| Roofing | 50,000 | 0 | 48,000 | 2,000 | 0% | 0 | 48,000 | −2,000 (−4%) |
| Electrical | 40,000 | 8,000 | 12,000 | 20,000 | 20% | 20,000 | 40,000 | 0 |
| Total | 290,000 | 146,000 | 105,000 | 39,000 | 51% | 50,000 | 301,000 | +11,000 (+3.8%) |

The roofing was subcontracted in full, labor and materials, for US$48,000, so there's nothing left to contract. Electrical has a current budget of US$40,000 because the client approved a US$10,000 change on top of the original US$30,000.

If you only look at actual cost, the job is fine: US$146,000 out of US$290,000, half the money for half the work. Add committed cost and what's still to contract, and the job finishes at US$301,000, US$11,000 over. Almost all of it comes from the structure.

## How do you project a line item's cost at completion?

1. **Start with actual cost.** Everything invoiced or paid on the line item to date, including last week's crew hours.
2. **Add committed cost.** Signed orders and subcontracts not yet invoiced, at the amount still to be billed.
3. **Estimate what's still to contract.** Work that's neither done nor contracted. Price it with the latest quote if you have one and, if not, at its budget value. If prices on that line item have already gone up, use the new price.
4. **Compare with the current budget.** Actual + committed + still to contract is the projected cost. Subtract the current budget and you have the variance, in dollars and as a percentage.
5. **Decide with the number in hand.** Get quotes for the remaining work from another supplier, swap a material with the client's approval, bill a change that was never billed, or draw on the contingency. None of those options exist anymore at closeout.

### The worked math: the warehouse structure

The structure's current budget is US$120,000. The cost report shows US$60,000 spent and 50% physical progress. Seen that way, it's on track: half the money for half the work.

But there's US$45,000 signed and not yet invoiced: the order for the remaining steel and the erection subcontract. Truly available is 120,000 − 60,000 − 45,000 = US$15,000.

That US$45,000 covers another 25% of the line item, which the budget priced at US$30,000: steel went up after the budget was drawn up. The last 25% (stairs and metal cladding) has no order or quote yet, so it's estimated at its budget value: US$30,000.

Projected cost at completion: 60,000 + 45,000 + 30,000 = US$135,000. That's US$15,000 over the current budget, or 12.5%. Put another way, there's US$15,000 available for work that's worth US$30,000.

> That's the optimistic projection. If the last 25% uses the same steel, the prudent move is to price it at the new rate (US$45,000), and the line item finishes at US$150,000, 25% over. The gap between the two numbers is your room to negotiate.

And you see all of this with half the structure still to build, while you can still get the stairs quoted by another supplier or talk to the client about the price of steel.

## Rules that keep the spreadsheet honest

- [ ] Every purchase order goes into committed the day it's signed, not when the invoice arrives.
- [ ] When the invoice arrives, its amount moves out of committed and into actual.
- [ ] Every client change is priced and approved in writing, [with a signed quote](https://efidis.co/en/blog/formato-de-cotizacion), before the work starts, and goes into its line item's approved changes column.
- [ ] Variance is measured against the current budget, not the original one.
- [ ] Within each line item, materials, labor, equipment and subcontracts are kept separate, so you know what drifted.
- [ ] Every invoice and every crew hour is charged to a single job. Material that moves from one job to another is logged as a transfer.
- [ ] Physical progress is measured by whoever is on site, with the same criteria every week.
- [ ] The spreadsheet is reviewed once a week, on the same day, with the site manager and whoever handles purchasing.

## When don't you need this much tracking?

If the job lasts a few weeks, has a fixed price with two or three suppliers and almost everything is paid on the spot, committed and actual are nearly the same. Comparing budget against actual every week is enough. The same goes if you run two or three small jobs a year: a simple spreadsheet per job will do, and setting up more tracking would cost you more time than it saves.

## When is the spreadsheet no longer enough?

The template works as long as one person can keep it up to date. It starts to break down when:

- You run several jobs at once, each in its own file, with different versions going around by email.
- Purchases are requested from the site over WhatsApp and reach the spreadsheet days later.
- Crew hours are copied by hand from paper timesheets.
- The progress you bill in your pay applications doesn't match what the spreadsheet says.

At that point, most of the work is copying data from one place to another, and every copy arrives late or with mistakes. What helps is having the purchase order, the invoice, the hours and the progress recorded once, where they happen, with the columns calculated on their own. [Moving off Excel](https://efidis.co/en/blog/como-salir-de-excel) lays out the order for making that change, and [engineering and projects](https://efidis.co/en/sectores/ingenieria-y-proyectos) shows what it could look like at a firm like yours.

## Frequently asked questions

### What is committed cost in construction?

It's what you've already agreed to pay that hasn't been invoiced yet: approved purchase orders, signed subcontracts and booked equipment rentals. It comes off the budget the day it's signed, because that money is no longer available, even if it's still in the bank.

### How often should you update cost tracking?

On jobs longer than a month, do the full review every week. Committed cost, on the other hand, gets entered the same day each order is signed: it's the column that goes stale fastest.

### How do you record change orders?

Every change the client asks for is priced before the work starts, approved in writing and added to its line item's approved changes column. That way variance measures your own mistakes, and the extra work is ready to bill.

### What is earned value, and do I need it?

It's the formal method for tracking cost, progress and schedule together: it compares the budgeted value of the work done with what it actually cost and, if the finished work ran over, projects that the remaining work will too. This template is a simple version that uses physical progress and committed cost. On large jobs, or contracts that require it, the full method is worth it.

### What contingency percentage should I set aside?

There's no percentage that works for every job. It depends on how much of the design is settled, how volatile prices are for your main materials and how far off you were on similar jobs. If you keep this spreadsheet, the variance on your last few jobs is the best guide for the next one.

## Sources

1. [Bent Flyvbjerg, Mette K. Skamris Holm and Søren L. Buhl, "Underestimating Costs in Public Works Projects: Error or Lie?," Journal of the American Planning Association, 2002](https://arxiv.org/abs/1303.6604)
2. [Peter E. D. Love and Dominic D. Ahiaga-Dagbui, "Debunking fake news in a post-truth era: The plausible untruths of cost underestimation in transport infrastructure projects," Transportation Research Part A, 2018](https://ideas.repec.org/a/eee/transa/v113y2018icp357-368.html)

## The real cost of every job, week by week

Efidis builds your firm a web and mobile app shaped around how you track your jobs. On the call we go over your cost spreadsheet and tell you what to sort out first.

- [Book my call](https://wa.me/573214646372?text=Hi%2C%20I%20read%20an%20article%20on%20the%20Efidis%20blog%20and%20want%20to%20see%20how%20to%20apply%20it%20in%20my%20company.)
