Bank matching and reconciliation: how to automate it

What is the difference between bank matching and reconciliation?

Bank matching is finding the right counterpart for a bank transaction; reconciliation is recording that link so the open item in accounts receivable or accounts payable is closed. Matching is the search, reconciliation the administrative result. Until an invoice is reconciled, the accounting software shows it as open, even if the customer paid long ago. In Dutch bookkeeping this closing step is called afletteren.

The distinction matters because each step carries different risks. A wrong match produces a wrongly reconciled item, with a correct bank balance but an incorrect overview of who still owes what. Not reconciling produces polluted ageing reports, unjustified payment reminders and a receivables or payables balance that does not tie up. Good bank processing does both: matching correctly and reconciling consistently.

How does reconciliation work in practice?

In practice, reconciliation means comparing each bank line with the open items of the administration and choosing the best fitting item. For a simple payment that comes down to amount and invoice number. When something deviates you have to decide: is this a partial payment, a payment difference you may write off, or a payment that belongs to another contact?

If a transaction cannot yet be explained, many firms post it temporarily to a suspense account, often called a vraagpostenrekening in Dutch. That account should be empty at the end of a period. In practice it tends to grow, because investigating unknown items is postponed until the period close or the VAT return comes up. The manual process usually looks like this:

1. 1Retrieve the bank transactions in the accounting software, via a bank feed or import.
2. 2For each bank line, find the open invoice by amount, invoice number, IBAN or contact name.
3. 3Link the payment to the invoice and reconcile it; with a partial payment the remainder stays open.
4. 4Write off small payment differences according to the firm's policy.
5. 5Post unexplained transactions to a suspense account and ask the client for an explanation or receipt.

Which situations make bank matching difficult?

Bank matching becomes difficult as soon as a payment does not map one to one to a single invoice. That happens more often than you might think: customers pay several invoices at once, offset a credit note, pay in instalments or leave out the invoice number. Payments through a payment provider, where one payout contains many underlying transactions, also need extra investigation.

With foreign suppliers and customers, foreign currency is added to the mix. The amount on the bank statement then differs from the invoice amount because of exchange rate differences or bank charges, so matching on amount alone does not work. These are exactly the situations that take the most time and cause the most errors when done by hand. Typical difficult cases are:

• Partial payments and payment arrangements in instalments.
• Batch payments covering several invoices at once.
• Payments where a credit note has already been offset.
• Payments in foreign currency with a different amount.
• PayPal payments and recurring direct debits without a clear reference.

How does AI match bank transactions to invoices?

AI matches bank transactions by weighing several characteristics at once instead of only comparing the amount. Autoboeker looks at amount, reference, IBAN, contact and date, and combines them into a match with a confidence score. A payment with a different amount but a clear reference and a known IBAN can therefore still be linked to the right invoice with high confidence.

Above the confidence threshold you set, it reconciles automatically. Below it, a proposal waits for review, and deviating amounts and payments are highlighted instead of being reconciled silently. Autoboeker recognises partial payments, credit notes, payment arrangements, recurring payments, foreign currencies and PayPal payments. You can set custom matching rules and apply a matching policy across administrations, so every team matches in the same way.

What happens to bank transactions without a match?

Bank transactions without a match are made visible in Autoboeker and, if they cannot be explained, automatically become a client question (vraagpost). Instead of an item sitting unnoticed on the suspense account for months, the client receives a targeted question in the client portal or app, linked to exactly that transaction.

The client answers with an explanation or uploads a receipt or invoice. That document is analysed by the AI, booked and matched, so the transaction is reconciled after all. Per administration and per team you can see which transactions are still open. That way you know before the month-end close or the VAT return where the bank still needs attention, rather than discovering it during the close itself.

Which accounting software supports bank matching in Autoboeker?

AI bank matching and automatic reconciliation are available in Autoboeker for Exact Online, Twinfield and SnelStart. For e-Boekhouden, bank matching is currently not available; AI processing, automatic booking and client questions do work there. Bank lines are synchronised automatically from the connected software, and the result of the matching is recorded there as well.

Bank matching connects directly to invoice processing. An invoice processed today can be linked to its payment tomorrow, without a separate bank round at the end of the month. Every match and reconciliation is traceable in the audit log. Bank matching is part of the Kantoor plan at €50 per month, like the other modules; you pay per booking, not per matched transaction.