Payment allocation reconciliation is needed when one customer transfer settles several invoices. Match the bank receipt to the customer’s remittance advice, record the amount allocated to each invoice and investigate the remainder. Recording the entire deposit against the newest invoice can leave old debts apparently overdue and distort the customer’s statement, even though the cash has arrived.

Accounting records, calculator and glasses on a desk
Illustrative photograph by Cht Gsml.

Gather the right evidence

Collect the bank transaction, remittance advice, customer account and open-invoice listing for the relevant date. Check the payer’s identity; a group company or payment intermediary may appear on the statement. Use the customer account and invoice references to substantiate the match rather than relying only on a familiar trading name.

Build a simple allocation schedule

Use columns for invoice number, invoice balance, proposed allocation and remaining balance. The total allocated must agree to the amount available from the receipt, after any separately identified items. Record the bank date and receipt reference once, so the same payment is not matched again by a second team member.

Example: three invoices and an unexplained difference

A customer pays S$3,000. Its remittance lists invoices of S$1,200, S$900 and S$800, leaving S$100 unexplained. Match the supported S$2,900 and ask whether the remainder is an advance, an overpayment or a reference error. Do not invent an additional sale to clear the difference. Keep the S$100 identifiable until the explanation is approved.

Investigate deductions separately

A customer may deduct a bank fee, discount or disputed charge. A deduction does not automatically mean the company has agreed to reduce the invoice. Ask the commercial owner to confirm the basis, then give the accountant the evidence. Where a credit note is appropriate, link it to the original invoice instead of silently changing the invoice value.

Review the customer statement

  1. Check that the receipt appears once in the cash records.
  2. Confirm each supported invoice allocation.
  3. List any unapplied cash or disputed deduction.
  4. Generate a fresh customer statement.
  5. Have a reviewer compare it with the remittance advice.

Keep the schedule with the receipt support. These steps are practical controls; the software’s buttons and account names may differ.

When to ask for help

If allocations span currencies, group companies or an earlier closed period, ask the accountant to review them before posting an adjustment. IRAS requires records that explain business transactions; a bank deposit alone does not explain every allocation. See bookkeeping basics, bookkeeping versus accounting and company records to keep.

Official guidance: IRAS company recordkeeping requirements.

Help with your company records

For accounting and bookkeeping support, contact Raffles Corporate Services at [email protected] or WhatsApp +65 8501 7133. Tell us which records or transactions need attention so we can discuss the relevant next steps.