Guide

How to track construction project profitability during execution

Track construction profit during the project by comparing, for the same scope of work, the value billed (RA bills) with the cost incurred to date, and by forecasting cost at completion against the revised contract value every month. This needs the BOQ, cost codes, material reconciliation and RA bills to be linked — not kept in separate files.

By the WebSoftOS team · Updated 2026-10-04

Why projects lose money unnoticed

On most sites, profit is only known when the final bill is settled. By then, the cost overruns, unbilled variations and material wastage that caused the loss happened months ago. The fix is not more reports — it is linking the data so the margin calculation is automatic.

1. Build the budget from the BOQ

Every BOQ item has a rate built from material, labour, equipment, overhead and profit. Break that rate analysis into cost codes (cement, steel, labour, shuttering, MEP subcontract…) and multiply by BOQ quantities. That is your project budget — and the baseline for every comparison later.

2. Book every cost to a project and cost code

  • Purchase orders and receipts → material cost code.
  • Muster rolls and labour bills → labour cost code.
  • Subcontractor RA bills → subcontract cost code.
  • Equipment usage logs and hire bills → equipment.
  • Site staff salaries, camp and utilities → site overheads.

Costs without a project and cost code end up in "general" and destroy the margin picture.

3. Compare billed value with cost for the same work

The most common mistake is comparing cost to date with the *total* budget. Instead, compare cost to date with earned value — the BOQ value of work actually done (or billed in RA bills). If you have billed ₹2 crore of work that was budgeted at ₹1.7 crore cost, but spent ₹1.95 crore, you are losing margin on executed work today.

MetricFormulaTells you
Gross margin on billed work(RA billed − cost to date) ÷ RA billedWhether executed work is profitable
Cost performance index (CPI)Earned value ÷ actual cost< 1 means over budget
Schedule performance index (SPI)Earned value ÷ planned value< 1 means behind schedule
Forecast at completionCost to date + estimate to completeFinal project cost
Projected margin(Revised contract value − forecast at completion) ÷ revised contract valueExpected final profit

4. Reconcile material every month

Theoretical consumption = measured quantity × standard consumption (e.g. bags of cement per cum of M25). Compare with material actually issued to the site. Differences above the allowed wastage are either theft, wrong mixes or unbilled work — all of which need action now, not at project close.

5. Bill variations as they happen

Extra items and changed quantities that are executed but not yet approved as variation orders are pure cost with no revenue. Keep a variation register and push approvals; include approved variations in the revised contract value.

6. Watch cash, not just profit

Retention, mobilisation-advance recovery and delayed client payments mean a profitable project can still drain cash. Track retention held, receivables by RA bill and a cash-flow forecast per project.

Frequently asked questions

How often should project margin be reviewed?

Monthly at minimum, aligned with the RA bill cycle. Large projects review key cost codes weekly.

Is a construction ERP required for this?

Not strictly — but doing it in Excel needs disciplined data entry across purchase, stores, labour and billing teams, which is exactly what tends to break.

Related resources