BOQ Full Form and What It Actually Means
BOQ stands for Bill of Quantities — a document that lists every item of work in a construction project along with its quantity, unit, rate, and total cost. It’s the pricing backbone of any tender, contract, or client estimate: instead of one lump-sum number, a BOQ breaks the project into measurable, verifiable line items.
A BOQ is different from a quotation. A quotation is a single price for the whole job; a BOQ shows exactly how that price was built — item by item, quantity by quantity — which is why it’s mandatory for government tenders (CPWD, PWD, municipal) and expected by most private clients and banks before releasing payment.
What Columns Does a BOQ Template Need?
Whether it’s for a small residential job or a government tender, a complete BOQ format in Excel follows the same core structure:
| Column | What Goes In It |
|---|---|
| S. No. | Serial number of the item |
| Item Description | Full work description — matches DSR/tender wording for government work |
| Unit | Cum, Sqm, Rmt, Ton, No. — per the nature of the item |
| Quantity | Measured quantity, traceable to a takeoff sheet |
| Rate | Per-unit rate — DSR rate or current market rate |
| Amount | Quantity × Rate, auto-calculated |
| Remarks | Optional — notes on specification, brand, or make |
Missing any of these — especially a traceable quantity column — is the most common reason a BOQ gets rejected or questioned during a tender review.
How to Make a BOQ in Excel, Step by Step
- Set up the header block — project name, client, location, date, and BOQ reference number at the top of the sheet.
- List items in logical work order — excavation and earthwork first, then foundation, RCC, masonry, plaster, flooring, finishing, electrical, and plumbing, in the order construction actually happens.
- Add the seven core columns from the table above as your header row, freeze it, and format quantity/rate/amount as number cells.
- Link Amount = Quantity × Rate as a formula in every row, not a typed-in number — this is what makes the sheet auditable and error-resistant.
- Group items by work section with subtotal rows (Earthwork, Concrete, Masonry, etc.) so reviewers can sanity-check each category.
- Add a grand total row at the bottom, summing every subtotal, plus GST and contingency if required.
💡 The part most homemade BOQ templates get wrong
A BOQ built with typed-in amounts (not formulas) breaks the moment a rate changes — every dependent total has to be manually re-checked. Our Civil Work Estimate & BOQ Template has every amount, subtotal, and grand total formula-linked, so updating one rate updates the entire BOQ and abstract of cost instantly.
Sample BOQ Format for House Construction (Excel)
Here’s a simplified sample structure — the kind of layout expected for a residential building BOQ format in Excel:
| S.No | Description | Unit | Qty | Rate (₹) | Amount (₹) |
|---|---|---|---|---|---|
| 1 | Earthwork excavation in foundation | Cum | 45 | 180 | 8,100 |
| 2 | PCC 1:4:8 in foundation | Cum | 6 | 5,200 | 31,200 |
| 3 | RCC M20 in footing/column | Cum | 12 | 7,800 | 93,600 |
| 4 | Brick masonry in superstructure | Cum | 28 | 6,500 | 1,82,000 |
| 5 | Internal + external plaster | Sqm | 320 | 280 | 89,600 |
This is only a sample slice — a full residential BOQ typically runs 40-80 line items once flooring, doors/windows, electrical, plumbing, and finishing are added.
BOQ in Tender: What’s Different
A tender BOQ has stricter requirements than a private client estimate: item descriptions must match the tendering authority’s DSR/schedule wording exactly, rates are often split into material and labour separately, and the format usually follows a fixed government template (CPWD/PWD/state PWD) rather than a custom layout. Deviating from the prescribed wording or unit is a common reason tenders get technically disqualified before price is even compared.
Build It Yourself, or Start From a Ready Template
A basic BOQ in Excel is quick to set up for a single small project. Where it gets time-consuming is building it to be reusable — linked formulas, a rate database you can update, DSR-compliant wording, and an abstract of cost that rolls everything up automatically.
Our Professional Civil Work Estimate & BOQ Template gives you exactly that structure pre-built: BOQ, Rate Analysis, Bar Bending Schedule, Quantity Takeoff, and Abstract of Cost, all formula-linked and CPWD/DSR compliant — so you fill in quantities and rates once, and every total updates itself.
Special Launch Offer
Get the Complete BOQ Template for ₹249 ₹999
BOQ, Rate Analysis, BBS, Quantity Takeoff & Abstract of Cost — all formula-linked in one Excel file
Frequently Asked Questions
What is the full form of BOQ?
BOQ stands for Bill of Quantities — a document listing every construction item with its quantity, unit, rate, and total amount, used for tenders, contracts, and client estimates.
What columns should a BOQ template in Excel have?
At minimum: S.No, Item Description, Unit, Quantity, Rate, and Amount. Tender BOQs often add a Remarks column for specification notes.
Is there a free BOQ format for residential buildings in Excel?
Yes — the sample structure in this post covers the core columns and item order. For a full, formula-linked version with 40-80+ pre-listed items, our template is ready to use out of the box.
What’s the difference between a BOQ and a quotation?
A quotation is a single lump-sum price. A BOQ breaks that price into individual measured items with quantity × rate, making it auditable and required for most tenders and bank loan approvals.
Can Excel handle a full tender BOQ?
Yes — Excel is the standard tool for BOQ preparation in India, including for CPWD/PWD tenders, as long as the item wording and units match the tendering authority’s schedule.
Related: CPWD BOQ Format & Rate Analysis · Civil Work Estimate Format in Excel · BOQ Format in Excel for Construction