📥 Free download: BOQ format in Excel
- Item No, Description, Unit, Quantity, Rate and Amount columns, with Amount = Quantity × Rate as a formula
- A filled 12-item example: earthwork, PCC, RCC, steel, shuttering, brickwork, plaster, flooring, paint
- Summary sheet with the BOQ total, GST rate and total including GST
- A 'How to use' sheet, and it uploads straight into True Site Sync
No email or sign-up needed. Opens in Excel, Google Sheets and WPS Office. Free to use, copy and share.
What is a BOQ?
BOQ format: the columns
| Item No | Description | Unit | Quantity | Rate (₹) | Amount (₹) |
|---|---|---|---|---|---|
| 1.1 | Earthwork in excavation for foundations | m³ | 180 | 285 | 51,300 |
| 2.1 | PCC 1:4:8 (M7.5) below footings | m³ | 12 | 5,850 | 70,200 |
| 3.1 | RCC M25 in footings, columns, beams, slabs | m³ | 140 | 7,400 | 1,036,000 |
| 3.2 | Reinforcement TMT Fe 550D | kg | 16,500 | 78 | 1,287,000 |
| 4.1 | Brickwork 230 mm in CM 1:6 | m³ | 130 | 6,400 | 832,000 |
| 5.1 | 12 mm internal plaster in CM 1:6 | m² | 2,600 | 265 | 689,000 |
Sample rows from the free template. The rates are illustrative; use your SOR or market rates.
How to prepare a BOQ in 6 steps
1. Study the GFC drawings
Architectural, structural and MEP, plus the specification.
2. List items by trade
Earthwork, PCC, RCC, steel, shuttering, masonry, plaster, flooring, finishes, MEP.
3. Take off quantities
Measure as per IS 1200, with deductions for openings. Use the concrete, brick and BBS calculators.
4. Write full descriptions
Material, grade, mix, thickness and finish: a description should price the item on its own.
5. Apply rates
From the state SOR / DSR for government work, or rate analysis and market quotes for private work.
6. Total and add GST
Amount = quantity × rate; add GST as per the contract (18% for most works contracts).
Common BOQ mistakes
- Vague descriptions ("RCC work") that can't be priced or measured.
- Mixing units for the same item (m² vs m³ for plaster).
- Missing items, which become disputed extra items later.
- Heading rows and blank rows inside the item list, which break imports and totals.
- Not tracking BOQ vs actual quantities during the job. See BOQ vs actual cost.
Frequently asked questions
What is the format of a BOQ?
A table with Item No, Description, Unit, Quantity, Rate and Amount, where Amount = Quantity × Rate, grouped by trade, with a total and GST at the end.
How do I prepare a BOQ for building construction?
Study the drawings and specification, list items by trade, take off quantities as per IS 1200, write full descriptions, apply SOR or market rates, then total and add GST.
Is there a free BOQ format in Excel?
Yes. Download the free True Site Sync BOQ format above. It has formulas, a filled 12-item example and a summary sheet with GST. No sign-up needed.
What is the difference between BOQ and estimate?
An estimate is the owner's or contractor's forecast of cost. A BOQ is the contract document listing quantities that bidders price and against which the work is measured and billed.
Can I import a BOQ from Excel into software?
Yes. True Site Sync imports a BOQ from Excel or CSV and detects the Item No, Description, Unit, Quantity and Rate columns automatically.
Turn your BOQ into RA bills
Upload the BOQ once; measurements and RA bills follow from it.
Start free 6-day trialOr book a demo.