Reconcile subcontract bills with work orders and free-issue materials

Confirm the subcontractor entity, package, work-order version, item or milestone, rate and location. Match measured work to that scope. An instruction from a site supervisor may explain why work happened, but whether it authorises a payable variation depends on the contract and delegated authority.

Keep approved changes distinguishable from proposed changes. If a rate is awaiting agreement, show the quantity and its status separately rather than inventing a rate to complete the bill. The QS should be able to trace each accepted value to the applicable measurement or milestone evidence.

Previous bills also need review. Use the accepted cumulative position and the contract’s current-period calculation, preserving earlier claims that remain disputed or uncertified. A previous deduction should not disappear merely because the preparer starts a new spreadsheet.

Illustrative example: after reconciling prior bills, a contractor accepts ₹8,00,000 of current-period subcontract work. A proposed free-issue material recovery of ₹40,000 is disputed. Assume, solely for this example, that authorised current retention is ₹40,000 and advance recovery is ₹60,000. Taxes and other statutory amounts are excluded and require separate review.

If the authorised owner determines that the ₹40,000 recovery is applicable in this bill, the subtotal becomes ₹6,60,000 before the excluded tax and statutory treatment. Record both the authority to deduct and the subcontractor's position: a deduction can be authorised under the contract while remaining disputed. Do not label it agreed merely because it appears in an approved bill. The contract and responsible commercial decision determine whether and how the amount affects payment.

These numbers illustrate the presentation, not recommended retention or recovery rates. The point is that all parties can see which amount relates to accepted work and which relates to a separate decision.

A proposed free-issue recovery should link to issue acknowledgements, supported installation, returned quantities, retained stock and scrap records. The free-issue reconciliation method explains that quantity bridge.

Then show the contractual recovery basis, applicable rate, prior recoveries and the subcontractor’s response. An unexplained quantity does not by itself establish the amount recoverable or the party responsible. Client-to-main-contractor terms and main-contractor-to-subcontractor terms may also differ; do not assume a client deduction passes through automatically.

The Department of Expenditure works manual, section 7.6, provides public-works background on closure reconciliations. The actual subcontract governs the commercial decision in this workflow.

If the quantity is agreed but the valuation is disputed, record both facts. This lets stores close a physical investigation while commercial continues the rate discussion. Forcing both questions into one “approved/rejected” field keeps resolved work unnecessarily open.

Maintain a separate running balance for advances: opening outstanding amount, new advances, approved recoveries and closing outstanding amount. In the example, an opening advance of ₹1,00,000 less the ₹60,000 recovery leaves ₹40,000. If a percentage calculation proposes another ₹60,000 next period, the reviewer must resolve the ₹20,000 excess rather than recover more of that advance than remains outstanding. New advances, interest or other charges need their own approved basis and entries.

Link each recovery to a bill. Track retention withheld and released in its own register, including any contractual cap and release conditions. Reaching a cap, releasing retention and recovering an advance are different events; one generic deduction formula cannot explain all three.

For a recovery revised after a bill is accepted, preserve the original decision and the authorised adjustment. Finance should decide how the change enters the accounting record. A negative deduction pasted into the next bill without explanation is difficult to distinguish from an error.

Do not treat all deductions as revenue reductions or all withheld amounts as permanent recoveries. The finance and tax owners should determine presentation and treatment using the actual facts and applicable requirements.

The site engineer confirms work evidence. The QS checks measurement and rate application. Stores confirms material custody and returns. Commercial resolves scope, recovery and contractual questions. Finance checks cumulative monetary balances, posting and payment treatment.

A smaller contractor may combine roles, but it should still record which decision was made and on what evidence. The person entering a deduction should not be able to make it appear independently accepted by changing a status label.

For a returned bill, preserve the reason and the revised submission. Identify whether the revision changes work value, a deduction or supporting evidence. This prevents a corrected bill from becoming a second payable claim.

A controlled spreadsheet can be sufficient for a few packages with stable terms. As packages and revisions grow, a billing tool or ERP integration can help connect work orders, measurements, material accounts and finance records.

Autodesk’s cost-payment application documentation illustrates supplier payment applications and their progression through review states. During evaluation, demonstrate the specific subcontract scenario, including a disputed recovery and a corrected prior bill. A generic supplier-invoice screen may not preserve enough commercial context.

Measure first-pass completeness, time spent resolving missing evidence, repeated recovery errors and the age of disputed items. Report the disputed amount separately from accepted but unpaid value. Those balances need different owners and follow-up.

A subcontract reconciliation is complete when the next reviewer can explain the accepted work, outstanding advances, retained amounts and unresolved disputes without reconstructing them from messages.

1. Confirm the applicable work order, measurements and approved changes.
2. Reconcile the prior cumulative work and deduction balances.
3. Attach quantity evidence and contract basis to proposed material recoveries.
4. Record the authorised treatment of each disputed item separately.
5. Issue a reviewed statement and carry its open balances into the next billing cycle.