Explain the gap between certified bills and bank receipts

Identify the contract, client entity, billing period, certificate, associated invoice or receivable record, currency and bank receipt. Check whether the certificate figure is gross, net or already adjusted for specific items. Compare like bases before subtracting one total from another.

Certification and accounting recognition are related but not necessarily identical events. Finance determines the actual treatment under the contract and accounting policy. Preserve the certificate as evidence and link it to the relevant ledger records rather than assuming that every certificate is already a posted invoice.

Keep dates separate: application, certification, invoice, contractual due date, bank value date and allocation date. They answer different questions. A receipt after the reporting cut-off should not silently reduce the historical outstanding position for an earlier date.

In this fictional example, two certificates show ₹10 lakh and ₹12 lakh on the same comparable basis. The associated recorded receivables total ₹22 lakh. The bank has received ₹18 lakh, with no other adjustments in the example. The simple unsettled difference is ₹4 lakh.

If the client's verified remittance allocates ₹10 lakh to the first bill and ₹8 lakh to the second, the first is settled and ₹4 lakh remains against the second. Record that allocation and its evidence. It is not a new cash receipt; it explains the existing ₹18 lakh.

If no reliable allocation is available, keep the cash as received but unapplied or allocated only under an authorised, documented policy. Do not claim that the second bill is specifically short by ₹4 lakh merely because a first-in-first-out rule produced that result. The overall balance is known; the bill-level explanation may still be unresolved.

Possible explanations include timing, a disputed item, retention, advance recovery, an agreed adjustment, tax-related withholding or an allocation error. These are investigation categories, not conclusions. Each requires the relevant certificate, remittance, contract, correspondence or finance evidence.

Show claimed by client, verified and disputed amounts separately where needed. A deduction shown in a remittance does not automatically mean the contractor accepts it. The commercial owner may need to investigate while finance records the appropriate position under policy.

Do not use a universal tax rate or retention percentage to fill a gap. Applicable treatment depends on the actual transaction and terms. An unexplained ₹4 lakh should remain an explicit reconciliation exception until the evidence supports a more specific classification.

ERPNext's Payment Reconciliation documentation describes linking existing submitted payments to outstanding invoices, with company, party and account checks. It distinguishes allocation from creating another bank movement. That is the operational boundary to preserve when designing the reconciliation process.

Check the payment's available unallocated amount before applying it. One receipt may cover several invoices, and one invoice may be settled by several receipts. The allocation table should reconcile to both sides and prevent the same cash from being used twice.

Some systems can propose first-in-first-out allocations. Treat such proposals according to the organisation's authorised policy and available remittance evidence. Review the bill references before acceptance, especially where the client has expressly identified a different allocation.

A client may revise a certificate, issue a later adjustment or reverse an earlier allocation. Keep the original record and link the revision. Do not overwrite the earlier figure so that last month's reconciliation can no longer be explained.

If a bank receipt is reversed, finance must record and reconcile the actual bank event through the approved process. An allocation correction alone should not invent or remove cash. Separate changes to the cash record from changes to which invoices that cash settles.

For a credit or agreed adjustment, verify the document, authority and affected balance. Check that it has not already been reflected in the net certificate or another ledger entry. Counting the same adjustment twice can make a short payment appear fully explained while understating the amount still due.

Finance owns bank and ledger reconciliation. Billing or commercial teams obtain certificate and remittance explanations and pursue disputed deductions. The project team supplies supporting performance or measurement evidence where required. Assign a named person to each unresolved item rather than one broad accounts follow-up label.

A useful review shows the remaining amount, reason or unknown status, latest correspondence, next action and expected decision date. Keep cash received but unapplied visible alongside unpaid receivables. Otherwise collection teams may chase money that has already arrived while overlooking the allocation work.

Track age from the relevant event, not merely from the date the exception was entered. A newly created row can represent a long-standing issue. Preserve original dates so management sees the actual delay in resolution.

Use the ₹22 lakh and ₹18 lakh example, then add a partial remittance explanation, a revised certificate and a reversed allocation. At each stage, reconcile certificate basis, recorded receivable, cash, allocations and remaining balance. Have another finance reviewer reproduce the result from the saved evidence.

A controlled register may be adequate when volumes are low and ledger links are reliable. Native reconciliation is preferable when the ERP already holds the relevant transactions. Automation can propose references or extract remittance lines, but it should not convert an unexplained difference into an approved write-off.

The useful result is an outstanding position the collection and project teams can act on. It tells them which money is missing, which money is merely unapplied and which adjustment still needs a decision.

1. Put certificates, ledger records, remittances and bank receipts on a consistent basis.
2. Reconcile the total before assigning bill-level explanations.
3. Obtain evidence for deductions and approve allocations of existing cash.
4. Review unresolved and unapplied balances with named finance and commercial owners.