A bill of quantities comparison is the controlled process of aligning contractor tender returns, reconciling their totals, exposing differences in scope and qualifications, and evaluating each offer on a genuinely comparable basis. It is not merely a spreadsheet containing several prices. The useful output is an evidence-backed commercial view: what each contractor has offered, where the offers differ, what remains uncertain and how those differences affect the recommendation.
That distinction matters because a neat column of totals can create confidence without comparability. One contractor may include an item elsewhere, another may exclude it, and a third may leave the cell blank. A fourth may price a substitute specification in a qualification that never appears in the BOQ. If all four states are treated as zero, the analysis is mathematically tidy and commercially wrong.
01 · The problem
Why contractor BOQs stop being comparable
Tender documents describe a common requirement, but returns rarely preserve a common structure. Contractors insert rows, combine items, amend descriptions, change units, move prices between sections or respond in their own workbook. PDF submissions introduce another layer of extraction risk. Addenda can be incorporated unevenly, while qualifications alter the offered scope outside the pricing document.
The result is a set of bids that look aligned at headline level but diverge underneath. Three forms of difference need to be separated. First is structural difference: the same work appears in different sections or levels of detail. Second is scope difference: the offer includes, excludes or changes part of the requirement. Third is price difference: contractors have genuinely priced the same obligation differently. Tender analysis becomes useful only when it stops those three signals from being confused.
A sound process therefore moves in two directions at once. It creates enough consistency to compare the bids, and it retains enough source context to explain every material conclusion. Normalisation without evidence can erase nuance. Evidence without structure leaves the team unable to see the commercial shape. Good BOQ comparison holds both.
02 · The method
A seven-stage method for comparing contractor BOQs
The sequence below is deliberately controlled. Each stage creates the basis for the next, and each should leave a visible record. On smaller tenders, several stages may happen in one working session. On complex packages, they may involve different reviewers and formal approval gates.
- 01
Preserve every original return
Start with an immutable source set: the issued BOQ, tender instructions, addenda, contractor returns, qualifications and post-tender clarifications. Record the filename, issue date, revision and sender. Never overwrite a returned workbook with a cleaned version. The working comparison can evolve; the evidence it is based on should not.
- 02
Create a common comparison structure
Choose the employer’s or consultant’s issued BOQ as the primary structure where it is reliable. Map each contractor’s sections and items to that structure, rather than forcing a match based only on row position or description similarity. Keep contractor-added items visible. If the source BOQ itself is inconsistent, establish a controlled comparison structure and document the reason for every material remapping.
- 03
Reconcile the commercial totals
Confirm how the tender sum is formed before analysing variance. Check section totals, carried amounts, discounts, provisional sums, taxes, alternates and any arithmetic corrections. A comparison that does not reconcile to the contractor’s submitted total may still look precise, but its conclusions are unreliable. Show the submitted figure and the reconciled analysis figure separately whenever they differ.
- 04
Distinguish every non-price state
Blank, zero, included, excluded and not priced are different commercial statements. Treating them as the same is one of the fastest ways to create a false ranking. Assign an explicit status, retain the source wording and raise a clarification when the contractor’s intent is uncertain. Do not silently convert an ambiguity into a price.
- 05
Isolate scope and qualification differences
Read qualifications alongside the priced BOQ. Note substitutions, programme assumptions, design responsibility, attendance, temporary works, warranties, testing, logistics and authority fees. Separate genuine price variance from differences in what has been offered. This is where the lowest submitted total can become a materially different proposition from the lowest comparable offer.
- 06
Control clarifications and revisions
Give every clarification a reference, owner, status and response date. Link the answer to the affected section or item, and keep superseded values available in the audit trail. When a revised return arrives, compare it with the previous issue before replacing anything in the current view. That makes late scope movement and unexplained commercial changes visible.
- 07
Write a source-backed recommendation
Present the submitted totals, comparison adjustments, residual risks and resulting comparable position. Explain the material reasons for any adjustment and point back to the relevant BOQ line, qualification or clarification. The final recommendation should state what remains unresolved and who accepted each assumption. Software can assemble the evidence; the accountable professional must own the judgment.
03 · Commercial meaning
Do not collapse the five non-price states
A cell without a conventional rate or amount still carries meaning. Record that meaning explicitly and apply a consistent review rule. The exact labels can vary by practice, but the distinctions should not.
| State | What it usually means | Comparison response |
|---|---|---|
| Missing | No response can be identified for the item. | Check mapping and source, then clarify; do not assume inclusion. |
| Zero | The contractor has entered a deliberate nil value. | Retain zero, but test whether the obligation is acknowledged. |
| Included elsewhere | The cost is stated as carried in another rate or section. | Link the stated location and avoid adding it twice. |
| Excluded | The contractor says the work is outside its offer. | Assess the scope gap and any comparison allowance required. |
| Not priced | The item is acknowledged but no price has been offered. | Seek a price or record a controlled risk; never invent one. |
These states should remain visible in summaries and decision briefs, not disappear once an adjustment is made. The adjustment is an analytical response; it does not replace the contractor’s submitted position. Showing both prevents a comparison allowance from being mistaken for a tendered commitment.
04 · Professional control
What software should automate—and what it should leave to people
BOQ comparison software is valuable where the work is repetitive, high-volume or easy to verify. It can extract document structure, align likely item matches, calculate totals, detect revision changes, surface blank or unusual states and maintain links between findings and source pages or cells. It can also make the same commercial view available to reviewers without circulating another uncontrolled workbook.
It should not silently decide that two ambiguous items are equivalent, convert an exclusion into an allowance, accept a qualification, or recommend an award without accountable review. Those actions depend on project context, contract strategy, design intent, risk appetite and professional obligations. An automated confidence score can guide attention; it cannot carry responsibility.
The right boundary is simple: automate the assembly of evidence, not the ownership of judgment.
For UAE and GCC tender teams, this boundary is especially useful when packages move between consultants, clients and contractors in mixed PDF and Excel formats. Multiple addenda, bilingual descriptions, provisional quantities and rapid post-tender revisions can increase both workload and ambiguity. The answer is not to hide uncertainty behind a uniform table. It is to make uncertainty reviewable, assign it to the right person and preserve the decision history.
When assessing a platform, look beyond whether it can produce a side-by-side sheet. Ask whether originals remain accessible, whether totals reconcile, whether statuses are distinct, whether mappings can be reviewed, whether revisions are versioned and whether the final figure can be traced to a source. Also test export and access controls: the tender record must remain usable outside a single analyst’s session and protected from the wrong audience. You can read how BOQView approaches those controls on our security page.
05 · Review gate
Tender comparison checklist
Before issuing a tender report or award recommendation, confirm that the working comparison can answer each of these questions:
- Are the issued documents, addenda and every contractor return preserved and revision-labelled?
- Does each analysed total reconcile to the corresponding submitted tender sum?
- Are contractor-added, moved, combined and substituted items still visible?
- Are blank, zero, included, excluded and not-priced states treated distinctly?
- Have qualifications been connected to the BOQ items and sections they affect?
- Can every comparison adjustment be traced to a source and an accountable reviewer?
- Are clarification responses, superseded values and unresolved matters recorded?
- Does the recommendation separate submitted price, comparison adjustment and residual risk?
- Has an authorised professional reviewed the final commercial position?
If any answer is no, the comparison may still support investigation, but it is not ready to support a defensible decision. Resolve the gap or state it clearly in the recommendation. Honest uncertainty is more useful than false completeness.