Ask any contractor in India what their BOQ looks like and you will get one of three answers — “we have a Word document somewhere,” “the architect sent us a PDF,” or “yes we made it in Excel but the file is on Vinod’s old laptop.” All three answers are wrong, and all three are why projects bleed money.

A Bill of Quantities is the single most important document on a construction project. It is the contract between the owner and the contractor, the procurement plan, the cost baseline, the billing reference, and the variance benchmark all rolled into one. If you cannot find your BOQ in 30 seconds, you do not have a BOQ — you have a memory of one.

This guide is the version that should be taught in the first week of any construction estimating course — what a real BOQ looks like in Excel, every column you need, the rate analysis discipline that separates a real BOQ from a wishlist, and the free template structure you can build today.

What a BOQ is, in plain language

A Bill of Quantities is a structured list of every item of work and material on a construction project, with measured quantities, unit rates, and total amounts. It exists for three reasons:

1. Pricing the contract. Owner and contractor need a single shared baseline of “this much work, at these rates, for this much money.”
2. Running procurement. When the BOQ says you need 14,200 bags of cement and 86 metric tons of TMT, that is the procurement plan for the next six months.
3. Measuring progress and billing. When the contractor bills the owner at the end of month 3, the bill is a percentage of the BOQ items completed. No BOQ, no clean billing.

The reason most Indian projects struggle is that the BOQ exists in name only. There is a number on a quotation, but no underlying breakdown. When the project hits month 4 and the owner asks “why am I paying ₹8 lakh for masonry that was supposed to be ₹6 lakh,” nobody can show their work, because the work was never broken down to begin with.

The structure of a BOQ in Excel

Every real BOQ has the same skeleton. Steal this structure for your next project:

Column 1: Item code

Hierarchical numbering. Example: 1 (Earthwork), 1.1 (Excavation), 1.1.1 (Excavation in soft soil up to 1.5m depth). The hierarchy lets you collapse and expand sections in Excel and matches how your engineers think about the building.

Column 2: Description of work

This is where most BOQs go wrong — they write “PCC” instead of “Plain cement concrete (PCC) M10 grade, 75mm thick, in foundation, including curing and finishing as per drawing reference S-04.” The first version is a guess. The second is a contract. The detail is not optional. The detail is the BOQ.

Column 3: Unit

cum (cubic meter), sqm (square meter), rmt (running meter), kg, no. (number), MT (metric ton). Every Indian BOQ uses these standard units. Stick to them — do not invent custom units like “trips” or “lots” because they will haunt you at billing time.

Column 4: Quantity

The measured number. This is the column the quantity surveyor lives in. Quantities should be measurable from drawings. If a quantity cannot be tied back to a drawing reference, it is a guess and should be flagged as such until the drawing exists.

Column 5: Unit rate

The rupee figure for one unit, including everything — material, labour, machinery, overhead, profit. The rate is where rate analysis lives. We will come back to this.

Column 6: Amount

Quantity × unit rate. Excel handles this automatically. The discipline is to never overwrite this cell manually. If the amount needs to change, the quantity or the rate has to change first.

Column 7: Remarks

Drawing reference, specification reference, vendor preference, anything else relevant. This column saves your life six months later when someone asks why a particular line was priced the way it was.

Optional columns for serious projects

• Section subtotals every 10 to 15 items, with bold formatting
• Material breakdown columns showing the cement / steel / labour split inside the unit rate (lets you forecast procurement quantities directly from the BOQ)
• Variance columns to be filled at billing time (planned vs. actual quantity and amount)

Rate analysis — what makes a BOQ a real BOQ

A BOQ where the unit rates are pulled out of thin air is not a BOQ. It is a wishlist with a fancy header.

Real BOQs are built on rate analysis — for every unit rate in column 5, there is a separate worksheet that breaks down how that rate was arrived at. For one cubic meter of M20 concrete in column, the rate analysis sheet says:

• Cement: 8 bags × ₹390 = ₹3,120
• Sand: 0.42 cum × ₹1,800 = ₹756
• 20mm aggregate: 0.84 cum × ₹1,400 = ₹1,176
• Water and curing: ₹120
• Mixing labour: ₹450
• Placing labour: ₹680
• Vibration / finishing: ₹220
• Wastage @ 3%: ₹196
• Subtotal: ₹6,718
• Overhead and profit @ 12%: ₹806
• Total per cum: ₹7,524

That number — ₹7,524 — goes into column 5 of the main BOQ sheet. When the owner asks “why am I paying ₹7,524 per cubic meter when the contractor down the road says ₹6,800,” the quantity surveyor opens the rate analysis tab and walks the owner through the math line by line. Either the owner sees the logic and pays, or both sides discover that the contractor was using ₹350 cement and the BOQ was costed at ₹390 — in which case the rate gets corrected and everyone is honest.

BOQs without rate analysis are why owner-contractor disputes happen on every Indian project. There is no shared truth, so every dispute becomes a negotiation between two opinions instead of two views of the same data.

The 6 mistakes that ruin most BOQs

Mistake 1: Lump sum line items

“Site clearance — Lumpsum — ₹2,50,000.” This means nothing. Site clearance is excavation, debris removal, vegetation cutting, leveling — each of which has its own quantity and rate. Lumpsum is laziness disguised as simplicity.

Mistake 2: Missing wastage allowance

BOQs that quote 14,200 bags of cement when the actual procurement plan needs 14,800 (because of 3-4% wastage) leave the contractor short by 600 bags. Always build a wastage line — typically 3% for cement and concrete, 2% for steel, 5% for tiles and finishing materials.

Mistake 3: No drawing references

If a BOQ line item does not point back to a specific drawing, it cannot be measured or verified. Every quantity should have a drawing reference in column 7. No reference, no quantity.

Mistake 4: Overhead and profit inside material costs

Some BOQs hide the overhead and profit inside inflated material rates. This makes the rate analysis impossible and the variance reports useless. Overhead and profit should always be a separate, visible line.

Mistake 5: BOQs that are never updated

The drawings change in month 3. The BOQ should change too. Most don’t. By month 6 the BOQ is fiction and nobody is doing variance analysis against it because everyone knows it is wrong. A BOQ that is not updated is worse than no BOQ at all because it gives a false sense of control.

Mistake 6: BOQs locked on one person’s laptop

The senior quantity surveyor maintains the BOQ on his laptop. He goes on leave. Or quits. Or his laptop crashes. The BOQ is gone. This is the single most common reason Indian projects lose their cost baseline mid-project. BOQ software with cloud storage exists specifically to make this category of disaster impossible.

Free BOQ format — what to build in Excel today

If you do not currently have a BOQ template, build this in the next 90 minutes:

1. Open a new Excel workbook. Rename Sheet 1 to “BOQ Main”
2. Set up the 7 columns above (item code, description, unit, quantity, unit rate, amount, remarks)
3. Add hierarchical section headers in bold for: 1. Earthwork, 2. PCC and RCC, 3. Masonry, 4. Plaster, 5. Flooring, 6. Doors and Windows, 7. Painting and Polishing, 8. Plumbing, 9. Electrical, 10. External Works
4. Add a SUM formula at the bottom of each section
5. Add a master grand total at the very bottom
6. Create Sheet 2 named “Rate Analysis.” For every unit rate in column 5 of the main sheet, add a small breakdown table on this sheet
7. Save the file with a clear name: “BOQ_ProjectName_v1_2026-04-10.xlsx”
8. The version number and date in the filename is non-negotiable — you will revise this file 30 times during the project, and you need to know which version is current

That is the entire template. No software to buy, no consultant to hire. The discipline is in the rate analysis sheet, not the formatting.

When Excel stops working

Excel BOQs work fine until one of three things happens:

One. You have more than one project. Now you have 5 BOQ files, each in its own folder, each version-controlled differently, and no way to compare costs across projects.

Two. You need to do live variance reporting. Every week the project manager wants to see “BOQ planned vs. actual” for the last 7 days. In Excel this is a manual reconciliation that takes someone 3 hours every Friday. In construction BOQ software, the actuals flow in from the daily progress reports and the variance is automatic.

Three. Your BOQ has 800 line items and your team is editing it concurrently. Excel does not handle concurrent editing well. You will lose work. You will save the wrong version. You will spend a Sunday afternoon rebuilding lines from email attachments.

The honest answer for most contractors: stay on Excel for the first project, and the day you start project number two, get a real BOQ tool. The cost is trivial compared to the time and disputes Excel will cost you on five concurrent projects.

The BOQ habit that pays for itself

One discipline, more than any other, separates contractors who end projects on budget from those who do not:

Update the BOQ every week.

Not every month. Not at the end of each phase. Every Friday afternoon, the quantity surveyor sits with the latest drawings, the latest variance numbers, and the latest material orders, and updates the BOQ to match reality. Quantities that changed get changed. Rates that moved get adjusted. New items get added. Removed items get marked. Variance is recalculated.

This sounds like overhead. It is not. It is the single most valuable two hours of work the QS does in any given week. Because the moment the BOQ stops matching reality, every other system on the project starts producing fiction — billing, procurement, variance reports, cash flow forecasts, all of it.

A BOQ that is updated weekly is a project under control. A BOQ that is updated monthly is a project running on hope.

Want to see what a live, weekly-updated BOQ looks like with automatic variance reporting and no spreadsheet maintenance? Trackovo BOQ software handles all of it on a phone. Book a 15-minute WhatsApp demo and see it on a real Indian project.