Skip to content

Bill of Quantities Format for a Boundary Wall

  • Excel (.xlsx)
  • 5 sheets
  • Free
  • Updated

Or download the empty Excel template

What is a boundary wall BOQ?

A boundary wall BOQ is a Bill of Quantities for a compound wall: the item list, units and structure for pricing a brick wall built on an RCC footing with intermediate columns, plaster, painting, gate and fencing. You enter measured quantities and rates; amounts, section sub-totals and an abstract calculate from them.

What is in the boundary wall BOQ workbook?

  • Project Details — project particulars, the schedule of rates adopted, and the percentages used on the Abstract.
  • BOQ — the item list. Enter quantity and rate; amounts and sub-totals calculate.
  • Abstract — section sub-totals pulled from the BOQ, plus contingencies, establishment, overheads and GST, giving the total estimated cost.
  • Filled Sample — a 60 m long, 1.8 m high boundary wall with gate, worked through with illustrative figures.

How does the boundary wall BOQ sheet calculate?

  • Amount = quantity × rate, rounded to the paisa. It stays blank until both are entered, so a missing rate never shows as a silent ₹0.
  • Section sub-totals carry into the Abstract sheet automatically.
  • Contingencies, work-charged establishment and contractor's profit & overheads are each the cost of works × their percentage — all charged on the cost of works, not on each other.
  • GST = total before GST × the GST rate, and the total estimated cost is the total before GST plus GST.

Worked example from the sample sheet (illustrative rate): 68.4 cum of excavation in foundation trenches at ₹310 per cum gives an amount of ₹21,204.

How do you use the boundary wall BOQ template?

  1. Open Project Details and enter the project particulars, the schedule of rates you are using, and the add-on percentages for the Abstract.
  2. Go to the BOQ sheet. Item descriptions and units are already filled in — enter your measured quantity and your rate against each item in the yellow cells.
  3. Delete any item that does not apply, and insert new rows inside the relevant section, above its sub-total row.
  4. Check the Abstract sheet. It is already linked to the BOQ — nothing to type there.
  5. Look at the Filled Sample if you are unsure what belongs in a column.
  6. Print or export to PDF. Header rows repeat on every printed page.

What should you check before relying on the boundary wall BOQ?

  • Item descriptions here follow common Indian practice. For a departmental tender, replace them with the exact wording of the department's schedule — the wording governs what is included in the rate.
  • Quantities must come from your own drawings. This template does not calculate quantities.
  • Check whether excavated earth is to be re-used or removed from site; it changes both the filling and the disposal items.
  • Rates are not supplied with this template. Enter rates from your own schedule of rates or market quotations; any figures on the sample sheet are illustrative only and must not be used for real estimating or billing.

Which BOQ template do I need?

Your jobUse this template
Government, PWD or public-sector tender priced from a schedule of rates BOQ Format in Excel
New house or builder floor, private work — turnkey or labour contract House Construction BOQ Format in Excel (Private Work)
Renovation or repair mixing several trades: dismantling, waterproofing, tiling, painting, fabrication, POP Renovation & Trade Works BOQ Format in Excel
Only waterproofing: terrace, toilets, basement or water tank Waterproofing BOQ Format in Excel
Only flooring and tiling: tiles, stone, skirting and dado Flooring & Tiling BOQ Format in Excel
Only painting: interior, exterior, steel and woodwork Painting BOQ Format in Excel
Only the boundary wall and gate Boundary Wall BOQ Format in Excel (this page)
Office, shop or home interior fit-out Interior Work BOQ Format in Excel
Only plumbing and sanitary work Plumbing & Sanitary BOQ Format in Excel
Only internal electrical work Electrical BOQ Format in Excel
A building's fire-fighting system: pumps, hydrants, sprinklers, extinguishers Fire Fighting BOQ Format in Excel
A road, pavement or internal road Road Work BOQ Format in Excel
Adding several BOQs up into one project total Abstract of Cost Format in Excel

What does each column mean?

ColumnWhat goes in it
S. No.Item number within its section. Sections are lettered; items run A.1, A.2, and so on.
Description of ItemThe full specification, pre-filled to common practice. For a departmental tender, replace it with the exact wording of that department's schedule — the wording governs what the rate is deemed to cover.
Unitcum, sqm, rmt, point, nos, kg — as the item is measured. The rate must be quoted in the same unit.
QuantityYour measured quantity from the drawings. This template does not calculate quantities.
Rate (Rs.)Your rate for the item, from your own schedule of rates or a supplier quotation. Record the basis on the Project Details sheet.
Amount (Rs.)Auto-calculated. Quantity x Rate, carried into the section sub-total and the Abstract.

Everything in this band is priced on a bill of quantities. The BOQ format in Excel is that bill — pre-sectioned by trade, with an abstract that totals it — and every rate you settle here is applied against its measured quantities.

Get the quantities from your drawings

A template gives you the structure. The measuring — scaling every quantity off the drawing set — is still three to seven days of work. Upload your architectural and structural PDFs and InstaBOQ reads the drawings, extracts the quantities, and fills this same structure.

Questions

What items go into a boundary wall BOQ?

Earthwork and foundation, concrete and reinforcement, masonry, finishing, and the gate with miscellaneous items. This template has pre-written items in those five sections; delete what does not apply and add rows inside a section for anything missing.

How is brickwork measured for a boundary wall?

One-brick (230 mm) and thicker walls are measured in cubic metres as length x height x thickness, with RCC columns and bands that interrupt the brickwork deducted. Half-brick (115 mm) walls are usually measured in square metres.

What is commonly missed in a boundary wall estimate?

Plaster and paint on both faces of the wall, coping, the gate and its hardware, and the disposal or re-use of excavated earth. Check each against the drawing before pricing.

Does the template include the wall's structural design?

No. Footing size, column spacing and reinforcement depend on wall height, soil and wind exposure, and should come from a structural engineer's drawing. The template prices the design; it does not produce it.

Does this template include rates?

No. Enter rates from your own schedule of rates or supplier quotations. The figures on the sample sheet are illustrative only.

People who downloaded this also took

Fill a BOQ item by item in your browser and export it to Excel. Free to start.