What is BOQ vs actual cost?
BOQ vs actual cost compares each item's planned quantity and rate in the Bill of Quantities with the quantity actually executed and the rate actually paid. The difference splits into a quantity variance (the site used more or less) and a rate variance (you paid more or less). Tracked during the job, it shows an overrun while there is still budget left to save.
Most "BOQ vs actual" reports show one total and stop there. That total can't tell you whether the problem is on site or in purchasing, and the fix is different for each.
BOQ vs budget vs committed vs actual
Four numbers get mixed up in cost meetings. Keep them separate:
| Number | What it is | Where it comes from |
|---|---|---|
| BOQ value | Contract quantity × contract rate | The BOQ in the work order |
| Budget (cost) | What you planned to spend to execute it | Your estimate or rate analysis |
| Committed cost | Money you've promised but not yet spent | Purchase orders and subcontract work orders |
| Actual cost | Money spent on work done so far | GRNs and material issues, attendance, machine hours, site expenses |
BOQ vs actual compares the first and last. Committed cost is your early warning: a PO raised today at a higher rate is next month's overrun.
BOQ vs actual cost formulas
On this page, a positive variance means an overrun (actual is above BOQ). Earned-value reports use the opposite sign, so check which one your team uses before comparing reports.
Quantity variance = (Actual qty − BOQ qty) × BOQ rate
Rate variance = (Actual rate − BOQ rate) × Actual qty
Quantity variance + Rate variance = Total variance
Variance % = Total variance ÷ BOQ cost × 100
Worked example: a quantity saving hidden by a price rise
Two items from a residential block. Numbers are illustrative.
| Item | BOQ | Actual | Quantity variance | Rate variance | Total |
|---|---|---|---|---|---|
| M25 concrete | 100 m³ × ₹6,000 = ₹6,00,000 | 108 m³ × ₹6,300 = ₹6,80,400 | +₹48,000 | +₹32,400 | +₹80,400 |
| Fe500 steel | 20 t × ₹65,000 = ₹13,00,000 | 19.5 t × ₹68,000 = ₹13,26,000 | −₹32,500 | +₹58,500 | +₹26,000 |
| Total | ₹19,00,000 | ₹20,06,400 | +₹15,500 | +₹90,900 | +₹1,06,400 (5.6%) |
What the split tells you: the site actually saved half a tonne of steel, but a ₹3,000/t price rise wiped it out. Of the ₹1,06,400 overrun, ₹90,900 (85%) is rate, not usage. That's a purchasing conversation, not a site one. A single "+5.6%" total hides all of this.
Comparing BOQ and actual cost before the job is finished
The most common mistake: comparing actual cost to date against the whole BOQ. At 40% complete, of course you've spent less than the full BOQ. That says nothing. Compare actual cost against the BOQ value of the work actually done (the earned value).
Work done (measured) = 40% → earned value ₹2.00 Cr
Actual cost to date = ₹2.20 Cr
Overrun so far = ₹2.20 − ₹2.00 = ₹20 lakh
Cost performance index (CPI) = 2.00 ÷ 2.20 = 0.91
Estimate at completion (EAC) = 5.00 ÷ 0.91 ≈ ₹5.50 Cr
Cost to complete = 5.50 − 2.20 ≈ ₹3.30 Cr
If nothing changes, a ₹20 lakh overrun at 40% becomes about ₹50 lakh at handover. That's why the comparison needs to happen monthly, not at final bill.
Where the actual numbers come from
BOQ vs actual is only as good as the actuals. On most Indian sites they come from this chain:
BOQ and work order
Items, units, contract quantities and rates. See work order vs BOQ.
Indent and purchase order (committed)
The rate you've agreed to pay before material arrives.
GRN and site issue (actual material)
What arrived, at what rate, and what was issued to which work.
Attendance, machine hours, site expenses (actual labour and plant)
Who worked, which equipment ran, and what petty cash was spent.
Measurement book and RA bill (actual quantity)
What was executed and billed. See the measurement book and RA bill software.
If any link in the chain lives in a WhatsApp group or a notebook, the actuals arrive late or not at all. That is usually why BOQ vs actual is done at month-end in Excel, when it's too late to act.
BOQ vs actual in Excel vs software
| Excel | BOQ vs actual cost software | |
|---|---|---|
| Actual quantities | Re-typed from the MB | Drawn from site measurements |
| Actual material cost | Re-typed from GRNs and challans | Built up from GRNs and site issues |
| Labour and equipment cost | Separate registers | From attendance and machine hours |
| When you see the variance | Month-end, if someone has time | As site entries sync |
| Sites with no network | Paper until evening | Captured offline, synced later |
Excel is fine for one small job with a disciplined engineer. Past two or three sites, the re-typing is where it breaks. More in Excel alternatives for construction.
How True Site Sync tracks BOQ vs actual cost
BOQ in, from Excel
Import your BOQ, with several work orders per project, each with its own rates, GST and retention.
Quantity side, per line
Measurements draw down each BOQ line: contract, executed, billed and balance quantity, live. Extra and deviation items are flagged.
Cost side, automatically
Material issued, labour marked and equipment hours become project cost with no re-entry.
Budget vs actual and P&L
Cost abstracts, budget vs actual and per-project profit, with PDF and Excel exports for owners and banks.
Why it matters
Cost overruns are the norm on large Indian projects, not the exception. MoSPI's July 2026 project monitoring data, reported by Business Standard, put the cumulative overrun across 1,775 central infrastructure projects worth ₹150 crore or more at about ₹3.41 lakh crore, with original cost ₹33,70,138 crore against revised cost ₹37,10,642 crore. The monitored set changes every month, so treat this as a snapshot, not a trend. The lesson for a contractor of any size is the same: you can only fix an overrun you can see.
Frequently asked questions
What is BOQ vs actual cost?
It's the comparison between the planned quantity and rate in your Bill of Quantities and the quantity actually executed and the rate actually paid. The gap is your cost variance, split into a quantity variance and a rate variance.
How do you calculate cost variance in construction?
Total variance = actual cost − BOQ cost. Split it into quantity variance = (actual qty − BOQ qty) × BOQ rate, and rate variance = (actual rate − BOQ rate) × actual qty. The two add up to the total variance.
What is the difference between quantity variance and rate variance?
Quantity variance shows whether the site used more or less than the BOQ, which usually points to wastage, rework or measurement. Rate variance shows whether you paid more or less per unit, which usually points to purchasing or market prices.
How do I compare BOQ and actual cost when the project is only partly done?
Compare actual cost to date with the BOQ value of the work actually done (earned value), not with the whole BOQ. CPI = earned value ÷ actual cost, and estimate at completion = BOQ value ÷ CPI.
What is the difference between committed cost and actual cost?
Committed cost is money you've promised through purchase orders and subcontract work orders but not yet spent. Actual cost is what has been spent on work done. Committed cost shows next month's overrun before it happens.
Can I track BOQ vs actual cost in Excel?
Yes, for a small single job, if someone re-types measurements, GRNs and attendance every week. Across several sites the re-typing falls behind, which is why most firms move to software that builds actuals from site entries.
How are the BOQ, measurement book and RA bill linked?
The measurement book records executed quantity against BOQ items. Measured quantities flow into the abstract and the RA bill at the BOQ rate. The same measured quantities are the actual-quantity side of BOQ vs actual.
See your BOQ against reality, every week
Book a demo with one of your current BOQs, and we'll show you where the variance sits.
Book a demoPrefer to try it yourself? Start a free 6-day trial.