The problem with spreadsheet BOQs
Every construction project in India starts with a bill of quantities. The client or consultant issues one with the tender, the estimator prices it, and — if you win — it becomes the contract. After that, the same BOQ is supposed to drive purchase, cost control and every RA bill.
In most contracting firms it does not, because the BOQ lives in Excel:
- Each tender arrives in a different format, and re-typing items introduces errors.
- Rates are a single number with no record of how they were built, so nobody can defend them in negotiation.
- Revisions overwrite each other. Which version did the client accept?
- After award, site and accounts keep their own copies, and the item numbers drift.
BOQ software should fix the structure once, so the rest of the project can rely on it.
How BOQs work in Indian contracting
A typical BOQ is divided into sections (earthwork, concrete, masonry, finishes, MEP and so on). Each item has a description, a unit, a quantity and — once priced — a rate and amount. Government and PSU BOQs often follow a schedule of rates such as a state PWD SoR or the CPWD DSR, with item descriptions and units taken from it. Private clients usually issue their own format.
Pricing an item properly means rate analysis: building the rate from material quantities and their prices, labour, equipment, wastage, and finally overheads and profit. A good rate analysis lets you see why a rate is what it is and change it when a material price moves.
After award, the contract BOQ is fixed. Changes to scope go through a change order, and billing is measured against the contract BOQ item by item.
What to look for in BOQ software
- Excel import with column mapping, ideally saved per format.
- Sections and item structure that survive the whole project.
- Rate analysis with material, labour and equipment build-up, wastage, overheads and profit.
- Approval and revision snapshots, so you can show exactly what was quoted.
- A clean path to the contract — quotation, award and terms — without re-keying.
- Downstream use: the budget, purchase and RA bills all referring to the same items.
Questions to ask during evaluation
- If the client sends a revised BOQ after the pre-bid meeting, how do you compare it with the version you priced?
- When a cement or steel price changes, how many rates do you have to edit by hand?
- After award, can the QS bill against the same item numbers the estimator priced, without exporting and re-importing?
- Can a site engineer see quantities without seeing rates and margins?
A tool that cannot answer these is a BOQ editor, not BOQ software for a contracting business.
How Zaptiz Construction handles BOQs
Zaptiz Construction treats the BOQ as the core record of a project.
Import and structure
BOQs are organised into sections and can be imported from Excel with saved column mappings. Once checked, a BOQ is approved, and revisions are kept as snapshots so earlier versions stay available.
Rate analysis
Each item’s rate can be built from material, labour and equipment, with wastage, overheads and profit. A library-first approach means rates you have already analysed are reused rather than rebuilt for every tender.
From BOQ to contract
You quote directly from the BOQ. When the work is won, the award records retention, advances, the defect liability period and LD terms against the contract.
The BOQ keeps working after award
- The project budget is derived from the contract BOQ at cost, with variance by cost head and phase.
- Material requests and POs feed a cost ledger that posts committed and actual cost automatically.
- RA bills measure cumulative quantities against the contract BOQ, with a guard against billing beyond it.
- Change orders are priced, submitted to the client and update the contract once approved.
To understand why this link between BOQ and cost matters, read Controlling construction project cost with budgets and a live cost ledger.
AI that drafts the tedious part
Three agents help with BOQ work, and all of them produce drafts for an estimator to review:
- BOQ Generator turns scope text or a messy Excel or PDF into an unpriced draft BOQ.
- Rate Suggestion fills blank rate-analysis coefficients, checking your library first.
- Resource Catalog Match suggests catalogue links for BOQ lines that are not yet linked.
Nothing is approved or priced on your behalf. More on this approach at Zaptiz AI.
What is not there yet
Drawing takeoff is currently a PDF viewer with calibrated scale and a snapping ruler; area, count and quantity takeoff is coming soon. Zaptiz Construction does not run vendor RFQs or compare vendor quotations, so material rates in your analysis come from your own library and records.
Get started
The fastest test is a real tender: import its BOQ from Excel, analyse a few key rates and produce the quotation. If you set up your first project afterwards, follow Setting up your first project in Zaptiz Construction. Book a demo to see it with your own BOQ, or contact us for a quote.