What can and can't be automated in bank reconciliation

“Automate bank reconciliation” sounds like it should mean the machine does all of it. It doesn’t, and the teams who expect that are the ones who end up distrusting the automation. Reconciliation is partly matching, which automates well, and partly judgment, which doesn’t. The win is getting the split right.

What automates cleanly

Exact matches. A bank line that matches an invoice or bill on amount, date and reference is unambiguous. There is no decision to make, so there is nothing a person adds. This is the bulk of most ledgers.
Recurring, predictable lines. Rent, subscriptions, payroll, standing payments — same payee, same amount, same cadence. A rule matches them every time.
Fees and known adjustments. Bank charges, card fees, rounding — once you have told the system what they are, it codes them without asking.
Many-to-one and one-to-many by rule. A batch payment covering several invoices, or one invoice paid in instalments, can be matched automatically when the rule is clear.

For a typical business, this is 80–90% of the lines. Automating it is where the time comes back.

What shouldn’t be automated

Ambiguous matches. Two invoices for the same amount, a payment that could be either — the system should not guess. It should flag.
Missing documents. A payment with no invoice behind it yet is not a reconciliation problem; it is a chase. A person decides whether to chase or accrue.
Anything that looks wrong. An amount that doesn’t fit, a new payee, a duplicate — these are exactly the moments a human eye earns its keep.
The sign-off. Someone is accountable for the reconciled period. Automation prepares it; a person still owns it.

Target the split, not the total

A good automated reconciliation does not aim to clear 100% of lines untouched. It aims to clear the routine 85% cleanly and present the other 15% as a short, clear list of exceptions — each with the context a person needs to decide in seconds. That is the difference between reconciliation that takes three days and reconciliation that takes an afternoon of review.

This is the same principle whether you work in Xero or QuickBooks — see how we approach finance automation for what that looks like built around your software.