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, one award action creates the contract and project and records the contract value and terms, including the retention and advance percentages that RA bills apply.
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 BOQ generator
Tenders rarely arrive as a clean spreadsheet. The BOQ Generator agent starts from whatever you have:
- A typed scope of work, for example “G+4 residential, 1,200 sqm per floor, RCC frame, AAC blocks”.
- The client’s file: Excel, PDF, or a photo (JPG, PNG or WEBP) of their BOQ, up to 20 MB.
It drafts sections, items, units and quantities, up to 400 lines per run. It also lists the assumptions it made and marks quantities it estimated from the scope as “verify”. You review a preview, confirm the draft BOQ, then price its lines through rate analysis. For a long, well-structured Excel BOQ, the regular importer is faster and keeps every line.
The full walkthrough is in the BOQ Generator docs.
More AI that drafts the tedious part
Other agents help after the BOQ exists, and they too produce drafts for an estimator to review:
- BOQ Generator, above, for the first draft.
- 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.
BOQ vs BOM
The two are easy to mix up, and Zaptiz has software for both, so here’s the difference:
| BOQ (bill of quantities) | BOM (bill of materials) | |
|---|---|---|
| Used in | Construction contracts | Manufacturing, such as electrical panels |
| Lists | Items of work, each with a unit, quantity and rate | Components and materials needed to build one product |
| Example line | RCC M25 in columns, 42 cum at ₹8,900 per cum | 1 × 63 A MCCB, 3 × 32 A contactors |
| Drives | The contract value, budget and RA bills | The quotation, purchase and production |
For panel BOMs, see panel BOM software.
What is not there yet
The Takeoff tab splits a PDF drawing set into named, scaled sheets and lets you measure lengths with a snapping ruler. Measurements are not saved and do not flow into the BOQ yet. 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.