Why bank transfers are hard to match
A card payment arrives with the order attached. A bank transfer arrives as a line of text on a statement, and the only link back to your invoice is whatever the payer’s finance team chose to type. That is why reconciliation is a separate job that starts after the money has landed.
The payer name on the statement is often not the name on the invoice. The usual differences are these.
- The company’s full legal name, when the invoice used the trading name the member goes by.
- A parent company, head office or shared service centre paying for a local subsidiary.
- An individual, such as a director paying from a personal account.
- An abbreviation or truncated string, because banks cut payer names and references to a fixed length and transliteration between scripts can change a spelling.
- A different entity altogether, such as a sister company, an agent or an accountant who settles the bill.
Build a matching routine and score every line
The reference field is no more reliable than the name. Members forget to quote the invoice number, quote the wrong one, or enter a purchase-order number instead. Amounts can also arrive short because a sending or intermediary bank deducted charges. No single field is proof, so you need a routine that weighs several.
Work through each statement line with the same four checks, in the same order, so that two people on your team reach the same answer. Then score the result: a line that passes three or four checks is a confident match, a line that passes two is probable and needs a second look, and a line that passes one or none goes to the unidentified list.
- Amount: does it equal exactly one open invoice, or the sum of a small set of open invoices for the same payer? An exact amount is strong evidence but not proof, because several members often owe the same tier fee.
- Reference: does it contain an invoice number, member number or company name you recognise? An open invoice number with the right amount is the strongest signal you will get.
- Payer name: does it match a legal name, trading name, known parent company or a contact on the record? Keep a list of known aliases against each member and add to it whenever you resolve a doubtful line, so the next one matches itself.
- Date window: did the payment arrive after the invoice was issued, and within a plausible time? Cross-border transfers can take longer, so widen the window for them. A payment dated before an invoice existed cannot be for it.
| Statement line | Likely invoice | Confidence | Action |
|---|---|---|---|
| Exact amount of one open invoice, invoice number in the reference, payer name matches | That invoice | High | Match and mark paid, using the bank date as the payment date. |
| Exact amount of one open invoice, no reference, payer name unfamiliar | Possibly that invoice, but other members may owe the same fee | Low | Do not mark paid. Ask the member or the payer’s finance team, and hold the line as unidentified. |
| Payer is a parent company, reference quotes a subsidiary’s invoice | The quoted invoice | Medium | Confirm with the member contact that the parent pays for them, then match and record the parent as a known payer. |
| Amount slightly below one invoice, reference and payer match | That invoice, short paid | High on identity, amount short | Record the payment, leave the shortfall open and find the cause before writing anything off. |
| One amount equal to the sum of two or three open invoices for one member | Those invoices together | Medium | Confirm from remittance advice, then allocate across the invoices explicitly. |
| Amount above one invoice, reference and payer match | That invoice, overpaid | High on identity, amount over | Allocate the invoiced amount and hold the excess as an unallocated credit until the member decides. |
| Round-number deposit, unfamiliar payer, no reference | None | None | Park it in the unidentified list and ask the sender. Attach it to no member. |
Handle partial, combined, short and excess payments
Real payments rarely arrive as one clean amount against one invoice. Decide your treatment for each case in advance, write it down and apply it the same way every time.
- Partial payment: apply it to the invoice it names, leave the balance open and visible, and tell the member what remains. Do not mark the invoice paid, and do not let a part payment quietly switch off reminders.
- One payment covering several invoices: find or request the remittance advice, then allocate the amount to specific invoices. Keep the single bank line linked to every invoice it settles so the trail shows why they closed together.
- Bank charges deducted, so the amount is short: sending and intermediary banks can deduct charges, and in some places a payer may withhold tax, leaving less in your account than the invoice total. Record the shortfall as a labelled difference with its reason, not a silent adjustment. Whether to ask the member for the balance, absorb it or book it another way is an accounting decision, so confirm treatment with your accountant.
- Overpayment: allocate the invoiced amount, hold the excess as a credit, and ask the member whether to apply it to a future invoice or return it. Returning money should follow the same approval path as any other payment out.
- Payment in another currency: the amount received will differ from the invoice because of the exchange rate and conversion charges. Agree with your accountant how the difference is recorded, and apply the rule consistently.
Never mark an invoice paid on a guess
Marking an invoice paid on a hunch feels harmless and causes three problems. The member who really paid receives a reminder while the one who has not paid stops being chased. Your receivables drift away from the bank. And the mistake surfaces months later, usually at audit or renewal, when it is much harder to untangle. A paid status should mean a specific bank line is linked to that invoice, for a reason you could explain to your treasurer.
A deposit you cannot identify is not a failure. Park it in a visible unidentified-deposits list (a spreadsheet tab or a holding account in the ledger, whichever your accountant prefers) with the bank date, amount, payer string and reference exactly as the statement shows them. Then follow a few rules.
- Give every parked line an owner and a review date, so it cannot sit unseen.
- Ask the likely sender: the member contact first, then the payer’s finance team (quote the date, amount and payer string), and your bank if it can supply more detail.
- Post nothing against a member until someone confirms. A second person approving large or uncertain matches is a cheap, effective control.
- Review the list at every month end. Unidentified money is also an obligation, because someone may be waiting for a receipt.
- If nobody claims a deposit after repeated attempts, how long to hold it and what to do next are questions for your accountant, not for the person doing the matching.
Close the month with a checklist
A month-end close stops small mismatches from compounding. Run the same checklist every month and keep a signed copy with the statement.
- Bring in every statement line for every bank account and payment channel, and confirm the opening and closing balances agree with your records.
- Match every line you can with the routine above, applying your confidence rules.
- List every unmatched statement line and every invoice you expected to be paid but was not, and clear or explain each.
- Review the unidentified-deposits list: age, owner and next step.
- Check that every short payment and overpayment is recorded as a difference with a reason.
- Prove the totals: payments applied to invoices, plus unallocated credits, plus unidentified deposits should equal the money that arrived in the bank.
- Have a second person sign off before the month closes, then pass the reconciled position and open items to your treasurer or finance committee.
Use accounts-receivable aging to chase what is still open
Once the paid items are settled, whatever remains open is your receivables list. An accounts-receivable aging report groups open invoices by how long they have been outstanding, so you can see at a glance which are merely due and which are genuinely late.
Before you chase any overdue invoice, check the unidentified-deposits list, because the member may have paid and the payment may be sitting there unmatched. That single check prevents the most awkward reminder a finance team can send. Then use bands that suit your billing cycle, for example current, 1 to 30 days overdue, 31 to 60 days and over 60 days, and treat each differently.
- Newly overdue: a short, friendly reminder repeating the invoice number, amount and bank details. Many are simply a missed step on the member’s side.
- Middle bands: a personal call or message from a staff member or board contact, asking whether the invoice reached the right person and whether anything is blocking payment.
- Oldest band: escalate to the treasurer or a board contact, and decide with them whether membership benefits continue while the invoice stays open.
Where Chamberflow fits
Chamberflow reads a Taiwanese bank statement and proposes which member each payment belongs to, for a person to confirm. Dues and event invoices sit on one ledger with sequential invoice numbers, so each payment is checked against a single list of open invoices, and accounts-receivable aging and overdue invoices appear in one place for chasing what is still open. Each chamber keeps its books in its own currency.
A person confirms each proposed match, decisions about shortfalls, overpayments and unidentified deposits stay with your staff, and how they are booked stays with your accountant.