Reconcile one bank receipt against several customer invoices by confirming the payer, obtaining the remittance detail and allocating the receipt to the invoices' current outstanding balances. The total invoice allocation plus any supported advance or unallocated amount should equal the bank receipt. Keep the bank transaction linked to the full allocation schedule.
Receiving money is different from recording a sale. If the invoices already exist, the receipt generally settles the relevant customer balance on the actual accounting basis. Posting the bank credit as new sales can duplicate revenue and leave the original invoices open.
Confirm whose payment arrived
Consider an illustrative Coimbatore packaging supplier receiving ₹90,000 from a regular customer. Accounts checks the bank reference, amount, date and remitter evidence. Where the payment comes from a related group company or an individual acting for the customer, it obtains confirmation of the intended settlement before allocating it.
RBI's NEFT guidance identifies references and remitter information as useful for tracing incoming funds. Use that evidence together with the customer's remittance advice. A matching amount or familiar abbreviated name is not sufficient when several customers could have paid.
ICAI's bank-reconciliation principles support matching the movement with the recorded receipt. The customer allocation is an additional check on which receivables that receipt reduces.
Start with the current invoice balances
The supplier reviews original invoices, earlier receipts, credit notes and any approved adjustments. It uses the amount still outstanding, not simply the invoice's initial total. A credit note already applied to an invoice should not be deducted a second time when the receipt is allocated.
Keep disputed amounts visible. If the customer has short-paid an invoice, obtain the reason and supporting treatment rather than writing the difference off automatically. A remittance note can describe the customer's view without establishing that every deduction is accepted.
Where no allocation advice is available, use an appropriate documented process and obtain confirmation for material ambiguity. Do not assume the largest receipt should close every invoice from that customer.
Work through a combined receipt
The customer's supported remittance gives this illustrative allocation:
| Item | Outstanding or intended amount | Receipt allocated | Position afterward |
|---|---|---|---|
| Invoice C-41 | ₹30,000 | ₹30,000 | Closed |
| Invoice C-49 | ₹25,000 | ₹25,000 | Closed |
| Invoice C-53 | ₹20,000 | ₹20,000 | Closed |
| Advance for a specified future order | ₹15,000 | ₹15,000 | Advance remains identifiable |
| Total receipt allocation | ₹90,000 | ₹90,000 | Agrees with bank |
Existing invoices reduce by ₹75,000. The remaining ₹15,000 is tracked separately according to the actual advance arrangement and applicable accounting requirements. It is not forced against an unrelated invoice merely to leave no unallocated receipt.
If another ₹10,000 invoice remains outside the remittance, it stays open unless separate evidence supports settlement. The customer's total account position and each invoice's status should both be checked.
Preserve one bank movement
The bank shows one ₹90,000 credit. The accounting workflow may allow one receipt with several invoice links or another documented allocation method. Whatever method is used, the bank ledger should not receive ₹90,000 once and then another ₹75,000 as the invoice allocations are entered.
If the receipt was already posted to the customer account, allocation may change only the invoice links rather than create a new bank entry. Check the existing state before processing the remittance.
When several book receipt entries represent the single bank amount, retain a supported grouped match. The sum should agree with the bank and each component should identify the invoice or other purpose it belongs to.
Explain deductions and fees separately
A receipt smaller than the invoice total may reflect an earlier credit, withholding, a bank fee, a dispute or a genuine partial payment. Obtain the actual basis and required documents. Do not label every difference a discount.
If a provider nets fees from collections, use its settlement detail to connect gross customer payments with the net bank credit. The provider payout may cover several customers and should not be treated as one payer's invoice settlement without the underlying report.
Keep sales taxes, deductions and advance-related obligations on the correct actual basis. Reconciliation establishes where money went; it does not determine a universal tax treatment from the receipt amount alone.
Communicate the allocation result
Retain or provide an allocation statement showing the bank receipt reference, invoices settled, any remaining invoice amount and the ₹15,000 advance. This helps the customer identify differences before another payment is made.
If the customer later changes the intended allocation, review the evidence and record the reallocation through a controlled process. Preserve the original history rather than deleting links without explanation. Check that the change does not cause an invoice to appear paid twice.
For a future order using the advance, apply it once and reduce the amount still to be collected. Do not add the advance again as new cash when the final invoice is raised.
Identify who confirms an advance
Give the future-order advance an order reference and responsible owner. Without that link, another salesperson may collect the full later invoice again or use the advance for a different order. Review the advance when the order changes or is cancelled.
Complete the bank and receivable review
Confirm that the ₹90,000 bank credit is matched once, ₹75,000 is applied to the specified invoices and ₹15,000 remains properly identified. Reconcile the resulting customer balance with the ledger and any customer statement.
A combined receipt is fully explained when its amount, payer and purpose all connect. A clear allocation schedule makes later reminders, advances and disputes easier to manage, while preventing a bank reconciliation that agrees numerically but leaves the customer account wrong.