BOQ Format for Residential Building in Excel (Free)

A BOQ format (bill of quantities) for a residential building — item-wise description, unit, quantity, rate and amount, totalled with GST. India DSR/market-rate ready Excel + PDF. Free, editable.

Download the template

Excel (with formulas) & print-ready PDF. Free & editable, no sign-up.

⬇ Download Excel (.xlsx) ⬇ Download PDF

What is a bill of quantities (BOQ)?

A BOQ is the itemised list of all work and materials in a project with quantities and rates, used to price the works, invite tenders and control cost. It is the backbone of construction estimating and billing.

BOQ format — sample

Item-wise residential BOQ with rate, amount and GST totals:

Sl	Item Description (CSI/Trade)	Unit	Qty	Rate	Amount
1	Earthwork excavation in foundation	cum	180	₹165	₹29,700
2	PCC 1:4:8 in foundation	cum	22	₹5,200	₹114,400
3	RCC M25 in footings & columns	cum	96	₹6,850	₹657,600
4	Brickwork in CM 1:6 superstructure	cum	140	₹5,400	₹756,000
5	12mm internal cement plaster	sqm	1850	₹295	₹545,750
SUB-TOTAL (Basic)					₹2,103,450
GRAND TOTAL (incl. 18% GST)					₹2,482,071

What to include

BOQ header — project, client, BOQ reference, date, rate basis (DSR/market).
Item description — by trade/CSI — earthwork, concrete, masonry, finishes.
Unit & Qty — measured quantity per item.
Rate & Amount — amount = qty × rate, auto-calculated.
Totals — sub-total, GST and grand total.

How to prepare it (step by step)

List each item by trade with a clear description.
Enter unit and measured quantity (from the measurement book).
Enter the rate (DSR or market).
Amounts, GST and grand total compute automatically.
Use the priced BOQ for tendering or budget control.

Building BOQs by hand?

Spreadsheet BOQs drift from the measurement book and the actuals. ProjectsNext links BOQ → procurement → billing so quantities, rates and costs stay reconciled across the project.

See procurement in ProjectsNext →

Frequently asked questions

What is BOQ format in construction?
An itemised schedule of work/materials with units, quantities, rates and amounts used to price and control a project.

How do I make a BOQ in Excel?
Download the template, list items by trade with quantities and rates; amounts and totals calculate automatically.

What is the difference between BOQ and estimate?
An estimate predicts likely cost; a BOQ is the formal itemised quantity-and-rate schedule, often used as the contract pricing document.

Is the BOQ template free?
Yes — Excel and PDF, free and editable.

More construction procurement formats: all templates · Comparative Statement · Purchase Order · RFQ · BOQ.