Reconciling Incoming Payments

Why reconciliation matters

Reconciliation is the process of matching each payment that lands in your account to the invoice it pays. It sounds clerical, but it is the foundation of credit control: if you cannot say which invoices are paid and which are still open, every chasing decision rests on guesswork. Worse, you risk the cardinal sin of pursuing a customer who has already paid — a fast way to destroy goodwill and your credibility.

Done promptly, reconciliation keeps your aged receivables accurate and your reminders honest. Done late or sloppily, it produces a ledger nobody trusts, where genuine overdue debts hide among unmatched payments. Treat it as a daily or near-daily routine, not a month-end scramble, so your view of who owes what is always current.

Make payments easy to identify

Most reconciliation pain is created at the invoice stage. If you ask customers to use your invoice number as their payment reference — and make that instruction prominent — the vast majority of payments will match themselves. A payment that arrives tagged 'INV-1043' is reconciled in seconds; one tagged 'payment' is a small investigation.

Help your software help you. Consistent invoice numbering, clear remittance instructions, and a single nominated bank account all reduce ambiguity. Where customers send remittance advice, encourage it — it tells you exactly which invoices a lump sum is meant to cover. Tools such as Merion's invoice templates make the reference instruction obvious so customers actually follow it.

Part-payments and lumped payments

Two everyday cases break naive matching. A part-payment covers only some of an invoice — record it against that invoice and keep the balance showing as open, so the remainder is still visibly due. Never let a part-payment quietly close the whole invoice, or genuine debt vanishes from your ledger.

A lumped payment settles several invoices at once with a single transfer. Here remittance advice is gold: it tells you exactly how to split the payment across invoices. Without it, you may have to contact the customer to allocate correctly. Resist the temptation to guess, because a wrong allocation leaves one invoice falsely overdue and another falsely paid.

Unidentified and over-payments

Sometimes money arrives that you cannot immediately match — no reference, an unfamiliar name, or an amount that fits nothing. Do not ignore it and do not assume it is a windfall. Park it in a suspense or holding category and investigate: check recent invoices, ask the bank for sender details, or contact likely customers. Most unidentified payments are simply yours, badly labelled.

Over-payments need their own rule. If a customer pays more than the invoice, decide whether to refund the excess or credit it against their next invoice, and tell them which. Leaving an over-payment unaddressed creates a liability on your side and confusion on theirs. A short, clear policy keeps both ledgers clean and avoids an awkward reconciliation months later.