Automatic bank reconciliation in Exact Online: what matches and what you still do by hand
Manoj Tutika · Published 16 November 2026 · Last checked 16 November 2026
Working on this yourself? Talk to Mark, our co-founder. We’re here to solve it with you.
How does automatic matching work in Exact Online?
Exact Online matches a bank line automatically when it finds a clear match. When you process the statements, it looks for an open item with the same amount and an invoice number or payment reference in the description. If there is exactly one candidate, the bank line is linked to that invoice and the invoice disappears from the open items.
For an administration with disciplined customers and structured payment references, a large share goes through on its own. What remains is the work that takes the time. For a wholesaler with 1,140 bank lines a month, that can easily be 280 lines.
Which bank lines stay unmatched?
| Situation | Why it does not match | How to match it |
|---|---|---|
| Batch payment | One amount for several invoices | Link the payment to all invoices that together make up the amount |
| Partial payment | Amount lower than the invoice | Link it to the invoice and leave the remainder open |
| Payment without a reference | No invoice number in the description | Search by customer and amount, link it by hand |
| Payment with discount or charges | Amount differs by a few euros | Link it and book the difference as payment difference or bank charges |
| Mollie or Stripe payout | Net amount for many sales | Book on a clearing account and split into sales and fees |
| Transfer between own accounts | Two lines in two bank journals | Book both on the internal transfers account and match them against each other |
| Bank charges, interest, taxes | No invoice | Book straight to the ledger account, set up a fixed rule |
How do you match bank lines by hand in Exact Online?
- Open the bank entries still to be processed under Bank en kas > Afschriften in the Dutch interface, found in the Financieel menu (Boekhouding in some environments).
- Choose the customer or supplier for each line. Exact Online then shows that relation's open items.
- Select the invoice or invoices that belong to the payment. For a batch payment, tick several until the total agrees.
- If there is a difference, book it as a payment difference, discount or bank charges, or leave it open as a remainder.
- For lines without an invoice, choose a ledger account directly, such as bank charges or payroll taxes.
- Clear clearing accounts and internal transfers in the matching screen (Afletteren in Dutch), by matching the items that together come to zero.
Do this daily, or at least weekly. A payment from yesterday you still recognise.
How do you stop matching from staying manual work?
- Use a structured payment reference on your sales invoices, so customers copy it.
- Set up fixed rules for recurring lines without an invoice, such as bank charges, rent and payroll taxes.
- Process payment providers with their specification. Import the payout reports from Mollie, Stripe or PayPal, so each payout splits into sales and fees.
- Keep clearing accounts clean. A balance that stays grows, and becomes harder to unpick at every month end.
How do you know your reconciliation is in order?
Three numbers tell you most. The first is the number of bank entries to process at the end of each working day. If that is structurally above zero, the work is falling behind. The second is the balance per clearing account, such as internal transfers, the payment provider clearing account and suspense. A healthy balance is €0.00, or an amount you can explain line by line. The third is the age of open items that have in fact been paid. A customer showing €6,250.00 outstanding in Exact Online while the money arrived three weeks ago gets a reminder that annoys them, and your aged debtors report is wrong.
Also watch how many matches you correct afterwards. Matching to the wrong invoice shows up later as credit notes and customers with a negative balance.
Why can an agent match more than rules can?
Rules in accounting software look at amount and reference. An agent looks at what an experienced bookkeeper sees. That a customer always pays two invoices together. That "inv 2026 0412" is invoice 2026-0412. That a difference of €1.85 is the transfer fee of a foreign bank. That the payment from "J. de Vries Holding" belongs to customer De Vries Installatie B.V., because the last three did too.
So the difference is not speed. It is the lines that currently land on your desk. Where an agent is unsure, it proposes instead of booking, with its reasoning attached, and you only look at the lines that genuinely need a decision.
What do Thred's agents do with bank reconciliation in Exact Online?
The Bookkeeper reconciles your Exact Online administration. It works on a synced copy of your administration, finds the right open item for each bank line, including batch payments, partial payments and odd descriptions, and writes the match back to Exact Online. You can also ask in plain language: "match this week's payments" or "why is there €3,420.00 on the clearing account?". Since 11 November 2026, matching from the chat is available for every Exact Online connection.
Each match appears as a proposal first, unless you have set a rule that this kind of match may go through on its own. On Thred Ledger, Thred's own ledger, 99.5% of 36,963 work units, including reconciliation links, were not changed by any human, measured on 19 September 2026. Your bank is current every day, and your month-end close no longer starts with two days of matching. See Thred Layer for how it connects.
Frequently asked questions
Does Exact Online reconcile bank transactions automatically?
Partly. When you process bank statements, Exact Online looks for an open item with the same amount and an invoice number or payment reference in the description. If there is exactly one candidate, it links the payment. Anything less clear stays in the list of bank entries to process.
Why are my bank transactions not matching in Exact Online?
The most common causes are a missing or mistyped reference, a payment for several invoices at once, a partial payment, a small difference for bank charges or a discount, and a payment from a different legal entity than the customer in Exact Online, such as a holding company.
How do you match a batch payment to several invoices?
Select the customer for the bank line, then tick all the open invoices that together make up the amount. If the total still differs, book the difference as a payment difference or bank charges, or leave the remainder open on the invoice.
How do you reconcile Mollie or Stripe payouts in Exact Online?
Book the payout against a clearing account for the payment provider, then split it using the provider's payout report into the individual sales and the fees. When done correctly, the clearing account returns to €0.00 after each payout.
How often should you reconcile the bank?
Daily, or at least weekly. A payment from yesterday is easy to recognise, one from five weeks ago has to be researched first. Daily reconciliation also keeps your receivables list accurate, so customers who have paid do not receive reminders.
Can AI reconcile bank transactions in Exact Online?
Yes. An agent reads the bank line the way an experienced bookkeeper does, including mistyped references, batch payments and payer names that differ from the customer name, and proposes or books the match. Since 11 November 2026 Thred matches payments from the chat for every Exact Online connection.
Sources
- Exact Online, help centre
- Exact, Exact Online product information (UK)
- Thred, method behind the 99.5% figure (measured 19 September 2026)
Read next
- Month-end close in Exact Online: a step-by-step guide
- Why a reconciled bank in Exact Online can still be wrong
- What rules cover in Exact Online, and what agents can take over
- Duplicates, retries and idempotency: keeping the ledger right when data arrives twice
- Bank reconciliation: how to do it step by step, and how to automate it
Where Thred comes in
Finance agents running on top of your existing ledger. You set the rules, approve the work and handle the exceptions. No migration.
