A bank receipt can clear while the customer’s invoice still shows as unpaid. A short worksheet helps a finance team track what came in, what was matched, and what still needs a reply before the close.
Use the same cut-off for both reports
Export bank receipts and the customer ledger through the same date. Record the bank reference, date and amount. Compare them with the customer name, invoice number and remittance advice. For a payment covering several invoices, list each allocation separately so a reviewer can trace the total.
Keep the unresolved amount visible
Use this layout when an incoming payment only partly matches open invoices. The amounts and references below are fictional.
| Bank reference | Received | Matched | Unresolved | Evidence and next action |
|---|---|---|---|---|
| B-014 | AED 8,400 | AED 6,000 | AED 2,400 | Remittance identifies INV-1048 and INV-1053 for AED 3,500 and AED 2,500. Ask the customer for the reference for the remaining amount. |
| B-015 | AED 1,150 | AED 0 | AED 1,150 | Payer name differs from the customer record. Ask the credit-control team to identify the payer before allocating. |
| Total | AED 9,550 | AED 6,000 | AED 3,550 | Assign an owner and due date to each unresolved item. |
Close the loop next month
- Attach the bank line, customer remittance and invoice references to each item you clear.
- Group open items by cause, such as missing references, possible advances or third-party payments. Confirm the cause before changing an invoice balance.
- Carry unresolved lines into the next close with the original receipt date and a named follow-up owner. Ask a reviewer to check aging items and approve any corrections under the team’s normal process.
More information about EMARK’s accounting and outsourcing services.