Lines, sums and totals
The nine kinds of line, how each is valued, and how bill, section and BoQ totals are worked out.
Every line of a bill has a Type. The type decides whether the line has an amount, how the amount is worked out, how it prints, and whether tenderers price it.
The kinds of line
| Type | Valued as | Used for |
|---|---|---|
| Section | No amount | A heading that starts a group of lines. The group gets its own total on the bill's Collection. Printed in capitals. |
| Heading / note | No amount | Text only: a description that several items share, a preamble, a note. |
| Measured item | Quantity x rate | The usual measured work. |
| Preliminaries | Quantity x rate | Items of the preliminaries bill (site office, insurances, hoarding...). |
| Dayworks | Quantity x rate | Provisional dayworks (labour hours, plant days). |
| Provisional Sum | 1 Sum x the sum | A sum fixed by the QS for work not yet designed. |
| Prime Cost Sum | 1 Sum x the sum | A sum fixed by the QS for a nominated supplier or subcontractor. |
| Contingency | 1 Sum x the sum | The contingency sum. |
| % addition | % of another line | A percentage of a Prime Cost Sum, Provisional Sum or Dayworks line of the same bill, e.g. contractor's profit on a PC Sum. |
Lump sums
A Provisional Sum, Prime Cost Sum or Contingency is entered as quantity 1, unit Sum, with the sum in Rate. In the line list of a bill on Details, choosing one of these types fills in quantity 1 and unit Sum for you. These three are fixed by the QS: they print on the unpriced tender copy too, tenderers do not price them, and the tender analysis copies them unchanged into every tender.
% additions
- Put the % line just below the sum it is added to. It is linked to the nearest Prime Cost Sum, Provisional Sum or Dayworks line above it in the same bill.
- Its description is filled in for you when empty: Add for contractor's profit (on a PC Sum or Provisional Sum) or Add for overheads and profit (on Dayworks).
- In the editor you type the percentage in Qty / %; the Rate cell reads of the sum above.
- A % line must be added to another line of the same bill, never to itself. A BoQ with a % line that has no % or no line to add it to cannot be locked.
- When the sum changes, the % amount follows at once.
How the figures are worked out
| Figure | Rule |
|---|---|
| Line amount | Quantity x rate for measured items, preliminaries, dayworks and the three lump sums; sum x % / 100 for a % addition; nothing for sections and headings. Amounts and rates are kept in whole shillings; quantities to 3 decimals. |
| Section total | The amounts of the lines from a section down to the next section. Lines above the first section are totalled under the bill's own title. |
| Bill total | Every amount in the bill, % additions included. Carried to the Grand Summary. |
| BoQ total | The bill totals added up: Total (excl. VAT). Once locked, this is the contract sum. |
| VAT | The BoQ total x the VAT rate of the contract, rounded to whole shillings. VAT exempt contracts show VAT: exempt on print. |
| Priced lines | How many lines are of a priced type (shown on Details). |
Rounding happens once per figure: a line of 12.345 m3 at 350,038 is 4,321,219.11, kept as 4,321,219; the bill adds the kept amounts. Attendance is a measured item, not a lump sum, even when it is priced as one Item: tenderers price it.
The Collection and the Grand Summary
On Details, the Grand Summary tab lists each bill with its total, then Total (excl. VAT), VAT and Total (incl. VAT). Drag the handle of a bill to change the order of the bills. Open lines on a bill shows its lines as a list and its Collection tab: one row per section with its total, and the Total carried to Grand Summary.
Good to know
Quantities, rates and percentages are never negative. To take work out of a Contract BoQ, use a variation order: it shows what was omitted against each item.
Something unclear? Ask us on WhatsApp: we answer the same day.