RA1–RA3 cleared. RA4 pending processing. All figures cumulative (up to date).
Amount payable on RA4
Bill form
Package-wise — the 10 bills inside the BOQ
Every field carried in the workbook is available here. The Columns button opens the
full list grouped by subject — contract, executed, supply/laying, held back, variance, balance and bill
history — and your choice is remembered. The grey line above each description is the schedule heading,
which is what gives short entries such as “1.5 m depth” their meaning. Long text is shown a few lines at a time — click any description to open it in full.
Rates come from the CE break-up sheet of RA Bill-4. The 13 items tagged qty check
have a quantity executed that differs between the RA bill and the CE break-up — switch on the CE site qty
column to see both figures side by side. On supply / laying items the two sources count differently — the CE sheet
records only what is laid, the bill includes material supplied but not yet laid — so those are not tagged.
Item no is the S.No of the CE break-up, which numbers headings and priced lines in one sequence — so
1, 2 and 3 are the headings above the first priced line (4), and the gaps you see are heading rows, not missing items.
Their text is the grey heading shown above each description.
Item no and Description stay in view while you scroll sideways; use Freeze description in the top bar
to release them. Drag the right edge of any column heading to widen or narrow it —
Reset widths in the Columns menu puts them back.
Release stage lists the stages an item is actually billed at, with the quantity in each. Supply alone earns
70%; laying earns a further 20%, so quantity that has been supplied and laid has reached 90% — it is
shown there, not as a separate 20% line. What stays at 70% is the quantity supplied but not yet laid. The old
single figure was released value divided by quantity × rate, which produced averages such as 81.2% that are not
stages anyone bills at; it is still available as Effective % in the Columns menu.
Balance BOQ = contract quantity still to execute — what remains to finish the project.
Balance by package
Balance items (largest first)
Supply done — laying pending (balance at 70% only)
Only Rmt / m items. Laid quantity (70+20 = 90%) is complete and moves to Retention;
this table shows only the balance still sitting at 70%.
Non-linear items billed at 70% / 20%
Units other than Rmt / m — listed separately, excluded from the laying calculation.
Retention — 90% and 95% work only
90% released → 10% retained. 95% released → 5% retained. Quantity laid under 70+20 also
reaches 90%, so its 10% is included here. Items at 70% alone carry no retention yet.
Enter quantities against each release stage. RA4 is still pending so it can be corrected;
RA5 starts as a copy of RA4 (bills are cumulative) and is edited on top of it. Value is recalculated as
quantity × rate × release %. Edits are saved separately and never overwrite the figures read from the workbooks —
an untouched row keeps the exact workbook value. Rows tagged 2 rates carry two
different rates in the source bill, so editing them recalculates on a single rate: check those against the M-Book.
Bill summary
Item entry
Weekly site measurements recorded against BOQ item numbers. Enter the quantity done
in that week (work since the last bill). The cumulative total is what can be claimed in the next RA bill,
and it is checked against the contract quantity so any excess is flagged before it reaches the bill.
Record a measurement
Measured vs billed — claimable in next bill
Measurement entries
Non-tendered items only — GST, sub-total and grand-total rows excluded.
NT items
Differences found inside the source workbooks during reconciliation.