Reconciliation
A payment arrived with no reference. What now?
It happens every week in businesses that take money from more than a handful of payers. Here is how to identify it, what to do while you cannot, and how to make it happen less.
A credit lands. The narrative is the payer’s bank’s idea of a name, the reference is blank, or it is a car registration, or it is the invoice number from a job that closed in April. Nothing in your ledger matches it, and the money is real and sitting there.
Short answer
Work the identifiers in order of how hard each is to get wrong: the payer’s account first, then the exact amount, then the two together, and the reference last. Hold anything you cannot identify somewhere visibly unresolved rather than allocating it to the nearest plausible invoice.
Work through the identifiers in order of strength
The mistake is to start with the reference, because the reference is the field most likely to be wrong. Work in the order of how hard each identifier is to get wrong by accident.
- The payer’s account. Sort code and account number are set by the payer’s bank, not typed by a person. If you have received money from that account before, you almost certainly know who this is, whatever name appears on the credit.
- The exact amount. An exact match against an open invoice is a strong signal, but only a signal. Two customers owing the same round figure is common enough that amount alone should never settle it.
- Amount and payer together. Two independent agreements is the threshold worth using. One agreement is a coincidence.
- The reference, last. Useful when it is right, decisive when it uniquely separates two otherwise identical candidates, and misleading the rest of the time.
- Timing and pattern. A payment that arrives on the same working day each month, for the same amount, from the same account, is not a mystery even with no reference at all.
What to do with it while it is unidentified
Put it somewhere that is visibly unresolved. A suspense or holding position, reviewed on a named day, by a named person. The failure mode is not the unidentified receipt; it is the unidentified receipt that gets allocated to the nearest plausible invoice to clear the queue, and surfaces nine months later when the customer produces a remittance.
Two rules worth writing down:
- Never allocate on one signal. If the only thing you have is the amount, you do not have enough.
- Never split the difference between two candidates. If two invoices match equally well, the correct answer is to ask. Choosing the older one, or the larger one, is a policy that will be wrong roughly half the time and will look deliberate when it is.
Reduce how often it happens
- Put one unique reference on the invoice, the payment link, the statement and the reminder, and make it the same string in all four.
- Keep it short. References get retyped from a screen into a banking app on a phone; eighteen characters with hyphens will not survive that.
- Where the payer is a large institution, such as a local authority, an insurer or an NHS body, accept that you will not control the reference and identify on the account instead.
- Record the payer’s account against the customer the first time you successfully identify them, so the second time is automatic.
Why this is a banking problem, not an accounting one
Accounting software reconciles after the fact, against a feed, once the money has already been sitting unidentified for days. The information that would identify the payment, meaning the account it came from and the expectation it settles, exists at the moment the credit arrives. Tervra is built on the argument that the understanding belongs where the money is.
Tervra’s receipt matching applies exactly the rule above: two independent exact agreements carry a match, one does not, no tolerance is applied to an amount, and where two candidates are equally supported it returns unknown and names both rather than choosing. How money in works.
Sources
- Bacs Direct Credit scheme information, Pay.UK
- Practitioner guidance on reference handling and suspense treatment in UK SME reconciliation
Your next step
Get to know Tervra.
Explore the product, follow a fictional journey or tell us what matters in your business account.