Prepare an RA bill without billing the same quantity twice

Illustrative example: a contractor bills one pipe-laying item at an assumed rate of ₹2,000 per metre. The approved cumulative eligible quantity at the September cutoff is 150 metres. Previous submissions claimed 110 metres; certificates accepted 100 metres. Taxes, retention, recoveries and variations are excluded from this first calculation.

The new quantity is worth ₹80,000 at the illustrative rate. The prior 10 metres represent a separate ₹20,000 difference between claimed and certified positions. If the contract allows that amount to be presented again, identify it as a carried-forward or resubmitted item and retain its history. Do not describe it as another ten metres installed this period.

Under a contract format that deducts previous gross certification from cumulative eligible gross value, the current application could legitimately show ₹3,00,000 − ₹2,00,000 = ₹1,00,000. That comprises ₹80,000 for new work and ₹20,000 carried forward. It is the value of 50 metres presented for consideration, but only 40 metres are newly claimed. The QS must confirm whether the earlier ten metres remain eligible and how the contract requires them to be presented.

The cumulative claimed position is still 150 metres. Adding 50 to the previous 110 would incorrectly produce 160 metres. Likewise, do not substitute cash received for previous gross certification in this example: retention, other deductions or unpaid certificates can make those figures different. Use the prior-position field specified by the governing bill format and reconcile it to the claim register.

Start with the executed contract, bill of quantities, applicable amendments and approved rates. Add checked measurement records, prior submitted bill versions, certificates, approved variations and the deduction registers relevant to the period. The QS should agree which measurement status qualifies an item for preparation and which requires further review.

The Department of Expenditure works manual, section 7.3.1, addresses measurement records in public works. For the project in hand, the governing measurement method and approval route come from its applicable contract documents.

Give every bill line a route back to the work: contract item, measurement reference, location, unit, drawing revision where relevant, checked quantity and approval status. A total copied from a site summary is difficult to defend if the underlying rows include an overlap or a superseded correction.

For a milestone-based EPC contract, do not reuse the metre calculation as the payment model. Establish the milestone’s contractual evidence and valuation. The principle of tracking prior claims still applies, but the eligibility test is different.

Suppose September bill 06 is returned because a measurement attachment is missing. The contractor submits bill 06 revision 1 with that attachment. The system should preserve the first submission and record what the revised submission replaces. It should not add both versions to cumulative claimed quantity.

If the revision changes 40 metres to 38 metres, show the 2-metre correction and its reason. If part of the original bill has already been certified or recorded in finance, the QS and finance team need to reconcile the correction through the applicable process. Deleting a file does not reverse its commercial or accounting effects.

Define claim identity separately from document identity. A bill can have several files and versions while representing one claim. Conversely, two valid claims may cover the same month. Date and filename alone are weak controls against duplication.

After the quantity and rate bridge is checked, show gross work value and each applicable adjustment separately. These may include retention, advance recovery, material recovery, other contractual deductions and tax-related amounts. The authorised finance and tax reviewers should determine the actual treatment; there is no universal percentage suitable for every project.

Keep cumulative and current-period adjustment balances consistent. A retention release is different from newly withheld retention. A material recovery disputed by the subcontractor is different from an accepted deduction. Preserve that status rather than hiding both in one net number.

The client’s certificate may differ from the application in quantity, rate, eligibility or deduction. Record the reason at line level when possible. Without that explanation, the next month’s preparer has to reconstruct the dispute from emails.

Use separate positions for measured work, submitted claims, certified value and receipts allocated by finance. A bill marked “sent” is not certified. A certificate is not cash in the bank. A payment reference should be reconciled to the actual receipt and its allocation.

Autodesk’s payment-application documentation distinguishes application history and later approval/payment states. Whatever software is used, validate the project’s definitions and the handling of corrections; product status names alone do not establish the client’s acceptance.

Age the differences between stages. Work measured but not submitted may need missing evidence. A submitted amount awaiting certification may need a technical response. A certified amount awaiting payment needs a different follow-up. One “billing pending” list mixes three different jobs.

Before release, a checker should be able to select a bill line and reproduce its current quantity, rate and prior position. Review repeated locations, negative adjustments, changed rates, unapproved variations and items carried forward from a previous certificate.

A controlled spreadsheet can provide this if the source tables and versions are protected. Software becomes more valuable when many packages, revisions and reviewers make the history difficult to maintain. Evaluate it using the contract-specific billing tests, including a returned bill.

The next RA bill should begin with an agreed history. That history includes outstanding differences, not just one previous total. Maintaining it reduces the risk that a legitimate unresolved claim becomes a duplicate quantity.

1. Agree the cutoff and the definitions of eligible, claimed, certified and paid.
2. Reconcile prior bill versions and identify which submissions remain active.
3. Calculate current quantities from the cumulative bridge and separate prior unresolved items.
4. Check rates, variations, deductions and tax treatment with their authorised owners.
5. Release the reviewed pack and retain a line-level record of subsequent certification differences.