Templates
Free BOQ pricing template (Excel)
Published:
A free Excel template for pricing a bill of quantities: a unit-rate build-up on every line and a summary with overheads, profit and VAT.
Free template, provided as is. Its formulas are a starting point for your own checks. It contains no market rates and gives no pricing advice.
What is in the template
Three sheets, in English (an Arabic edition is linked from the Arabic version of this page).
| Sheet | What it does |
|---|---|
| Instructions | How to fill it in, what each column means and what to check. |
| BOQ | Item reference, description, unit and quantity, then labour, materials, plant and subcontract per unit. The unit rate and the amount are calculated. |
| Summary | Direct cost from the BOQ sheet, then site overheads, head office overheads, profit, contingency and VAT as percentages you enter. |
How to use it
Start from a copy, never from the only version.
- Paste your quantities into the BOQ sheet, one measurable item per row.
- Enter the cost per unit for labour, materials, plant and subcontract; the unit rate and the amount calculate themselves.
- Set the percentages on the Summary sheet, and state in your tender which of them are already inside the rates.
- Write the source and date of every price in the Notes column.
Check the formulas after editing
Formulas break when rows are inserted, sorted or copied in from another file. After each edit, check that the direct cost on the Summary sheet equals the sum of the BOQ amounts, and that no row has a rate without a quantity or a quantity without a rate.
VAT is set to 15%, the Saudi rate, because many users price for Saudi projects. Change it to the rate your tender requires, or to zero if prices are to be stated without VAT.
From template to AI pricing
When the BOQ is ready, the CAIS pricing trial can draft rate build-ups for it from Excel or CSV. Compare its rates with your own before you use either.