BOQ template for Excel (Philippines)

A bill of quantities (BOQ) lists every work item of a build by trade, with its item number, description, quantity, unit, unit cost and amount. Instead of filling a blank template, Countstruct builds the BOQ from your estimates and downloads it as an Excel workbook with four sheets (summary, bill of quantities, unit price analysis and materials) or as a PDF.

Want the whole picture? See every Countstruct feature on one page.

Work it out for your own job

Estimate each job with the calculators, add them to a project, and download the bill of quantities as a PDF, or as Excel on Business.

Make a bill of quantities in Countstruct
Countstruct project on a desktop: bill of quantities grouped into structural, architectural, electrical and plumbing works, with Download PDF and Excel buttons
The bill of quantities on a desktop, grouped by trade.
Countstruct project on a phone: project budget with Download PDF and Excel buttons, and the work items grouped by trade
The same project on a phone.

The BOQ format

Each line of a bill of quantities is one work item. The Excel workbook Countstruct downloads uses these columns:

Column What goes in it
Item No. The trade letter and line number: A.1, A.2, B.1…
Description The work item, with the estimate's name
Qty and Unit The measured quantity: m², m³, pcs, blocks…
Material unit cost and amount Materials for one unit, and for the whole quantity
Labour unit cost and amount Labour, with minor tools and equipment
Unit cost and Amount Materials plus labour: the direct cost of the line

Amounts are direct costs. Contingency, overhead, profit and VAT are added in the summary, not spread over the lines.

Sections by trade

Work items are grouped into lettered sections, each ending with a subtotal: A structural works, B architectural works, C electrical works, D plumbing works and E other works. General requirements and hauling follow in section F. A section appears only when the project has work in it. These letters are the app's own, not DPWH pay item numbers, which vary from contract to contract.

The four sheets in the Excel file

It is an ordinary .xlsx file: open it in Excel, add your own columns or print it. On Business, your company name goes on every document.

BOQ as PDF

Download PDF makes an A4 document with the project, client, location and date, the summary of cost estimate, the bill of quantities, and the materials to buy. Every page carries the note that it is a planning estimate, and a page number.

First page of a bill of quantities PDF made by Countstruct: project details, summary of cost estimate by trade, and signature lines
The first page of a bill of quantities PDF.

A BOQ for bidders

Bill of quantities for bidders gives contractors or subcontractors the same work items and quantities with the unit price and amount columns left empty, for the whole job or one trade. It adds short bidding instructions and lines for the bidder's name, validity and signature. None of your own costs appear in it. In the Excel version the amounts, subtotals and total bid price are formulas, so they add up as the bidder types. When quotes come back, Compare quotes sets each one against your estimate.

Quotes from bidders on a desktop: each quote compared with the estimate, the lowest marked and one awarded
Quotes from bidders compared with the estimate.
Countstruct project on a phone with the Download PDF and Excel buttons above the bill of quantities
Download PDF and Excel from a project on a phone.

Which plan you need

What you get Free Business
Bill of quantities PDF Yes Yes
Materials list (To buy) and copy as text Yes Yes
Bill of quantities for bidders, as PDF Yes Yes
Excel workbook (.xlsx) of the project — Yes
Bill of quantities for bidders, as Excel with formulas — Yes
Save to Google Sheets — Yes
Estimate revisions — Yes

You can try Business free before you pay. See plans.

What Countstruct adds

From estimate to BOQ

  • Quantities from 51 calculators, each showing how it worked out its numbers, so every line can be checked.
  • Material and labour unit costs from a regional price book you can edit, with your suppliers and quote dates.
  • Owner, contractor and DPWH presets for contingency, overhead, profit and VAT.
  • Numbered revisions you can compare and restore, printed on every export (Business).
Make a bill of quantities in Countstruct

Questions

Is there a free BOQ template for Excel?

Countstruct's free plan makes the bill of quantities as a PDF, from your own estimates. The Excel workbook, with its summary, unit price analysis and materials sheets, comes with Business.

Can I edit the BOQ in Excel?

Yes. It is a normal .xlsx workbook. Change, add or reprice lines in Excel, or change them in Countstruct and download again.

Does it follow the DPWH format?

The cost build-up has a DPWH preset for markups, but the section letters A to F are Countstruct's own. They are not DPWH pay item numbers, which vary from contract to contract.

What is the difference between a BOQ and a bill of materials?

A BOQ lists work items with materials and labour. A bill of materials lists only the materials to buy. Countstruct makes both from the same project.