Thred
All posts

Why a reconciled bank in Exact Online can still be wrong

A bank account that reconciles to the cent proves your cash is complete. It does not prove your receivables are right. What to check in Exact Online, and how to keep it honest.

David van Duijn5 min read

Working on this yourself? Talk to Mark, our co-founder. We’re here to solve it with you.

Book a demo
On this page

Bank reconciliation in Exact Online means processing every imported bank line until the bank account in your administration agrees with the bank statement. A reconciled account proves your cash is complete. It does not prove each payment was booked against the right invoice or account, and that second question is where most errors hide.

If you run finance on Exact Online, or your firm looks after dozens of clients on it, you have probably seen a bank account with a difference of €0.00 and an ageing report that is plainly wrong. Both can be true at once. This post is about why, and about the checks that tell you which of your reconciled accounts you can actually rely on.

What does a bank reconciliation actually prove?

It proves one thing: every line on the statement has been booked somewhere, and the balance in Exact Online equals the balance at the bank.

That is valuable. It means no payment is missing and nothing has been booked twice on the bank side. But "somewhere" is doing a lot of work in that sentence. A line booked to a suspense account counts. A payment applied to the wrong customer's invoice counts. A payout booked as revenue without its fees counts. The bank still reconciles.

So the useful question for a controller or a founder is not only "is the bank reconciled?" It is "is every line in the right place?"

How does a bank line move through Exact Online?

It helps to picture three passes over the same lines, followed by a queue.

  1. Import. Lines arrive daily through the bank connection, or from a statement file you upload.
  2. Match. Each line is compared with the open items of your customers and suppliers. When the amount fits and there is a recognisable reference, Exact Online proposes or makes the match.
  3. Rules. Recurring lines without an invoice, such as bank fees, rent or a subscription, are booked to a fixed account by booking rules you have saved.
  4. The queue. Everything else waits for a person.

The first three passes are reliable because they only act when the bank line holds enough information to decide. The queue is where the information lives somewhere else, in an email, a payment provider's report or someone's memory. It is also where the shortcuts happen, because the queue is what stands between you and a reconciled account at month-end.

How can a balanced bank account hide wrong books?

Each of the usual shortcuts clears a line from the queue and leaves the bank balanced. Take an illustrative week.

  • Parked on a suspense account. Noorderlicht Retail pays €6,342.75 with the description "payment october". It covers five invoices, but nobody has time to work out which, so it goes to suspense "for now". The bank reconciles. All five invoices still show as overdue.
  • Matched because the amount fitted. A €1,200.00 transfer from a holding company is matched to the first open invoice of €1,200.00. It was meant for a different one, which stays open.
  • Half an invoice, no reason. Bakkerij Hoekstra pays €750.00 of a €1,500.00 invoice. It is allocated, and the remaining €750.00 sits open without anyone knowing whether it is an instalment or a dispute.

In that one week, the bank reconciles to the cent while receivables are overstated by €6,342.75. The next reminder run will email Noorderlicht about five invoices it has paid.

Which checks show whether the books behind the bank are right?

These take minutes and tell you far more than the reconciliation status.

  1. Is the suspense account empty? If not, how old is the oldest line on it, and does anyone know what it is?
  2. Are there payment differences you cannot explain? Look at the account where small differences are booked and check that each line has a reason.
  3. Does every payout clearing account return to zero? If you book payment provider settlements through a clearing account, gross sales in and fees out should leave nothing behind.
  4. Do overdue customers have recent payments? A customer with three overdue invoices and a payment last week is a sign something was applied wrongly.
  5. How many "we already paid" replies did you get? Each one is a payment that reconciled the bank but not the receivable.

If all five are clean, your reconciled bank is also a reliable bank. If not, the reconciliation was finished but the work was not.

How do you keep the queue from turning into shortcuts?

Shortcuts happen when the queue is too big to handle properly. A few habits keep it small.

  • Process daily rather than monthly. A line is easiest to explain on the day it arrives, while the email that explains it is still near the top of someone's inbox.
  • Save a rule the second time you see a pattern. Every rule removes that line from every future month.
  • Give payment provider payouts their own clearing account. Book gross sales and fees there and treat the payout as a transfer.
  • Set a weekly moment to clear suspense. Treat anything older than a week as a real problem.
  • Write down why. When you allocate a part payment or accept a difference, record the reason. The next person, or the auditor, will need it.
  • Improve what customers send you. Put the invoice number prominently on your invoices, use a structured payment reference (betalingskenmerk) where your invoicing supports it, and offer payment links so the reference travels with the money.

What should an accounting firm check across clients?

For a firm, the risk is that each client's bank reconciles while their receivables quietly drift, and nobody notices until year-end or until the client asks why a customer is angry.

A weekly portfolio view helps more than reviewing clients one by one. For every administration, look at the suspense balance and its oldest line, the number of unprocessed bank lines, and the overdue receivables of customers who have paid recently. The clients that show up on more than one of those lists are the ones to look at this week.

That turns the five checks above from a year-end clean-up into routine review, which is a better use of a qualified accountant's time than working the queue itself.

Where does an agent fit on top of Exact Online?

The queue is the work we built Thred for. Not the lines Exact Online already matches, but the ones where the answer sits in an email, an attachment or a provider report.

With Thred Layer, agents work on top of Exact Online. They read bank lines together with the evidence around them, propose or make the match within the limits you set, raise the lines that need a decision with the context attached, and push finished entries back. Exact Online stays the system of record, so your accountant keeps working where they always have, and nothing is migrated. Firms can run the same checks across every client from one workspace. Agents read by default and write only with permission, and every entry stays traceable to its source and approver, as described on our security page.

The goal is the same whatever tools you use. A reconciled bank should mean the books are right, not just balanced.

If you run finance on Exact Online and want that queue handled daily, book a demo on your own bank data.

Frequently asked questions

Does a reconciled bank account mean my books are correct?

No. It means every bank line is booked somewhere and the balances agree. Payments parked on a suspense account or applied to the wrong invoice still leave the bank reconciled, while receivables and payables are wrong.

Which bank lines still need a person in Exact Online?

Automatic matching needs an amount that fits an open item and a recognisable reference. Payments covering several invoices, part payments, payouts net of fees and transfers from an unknown payer usually lack one of those, so they wait for a person.

How should payment provider payouts be booked?

A common approach is a separate clearing account per provider. Gross sales and the provider's fees are booked there from the settlement report, and the payout to your bank is treated as a transfer, so the clearing account returns to zero.

What is a betalingskenmerk?

A betalingskenmerk is a structured numeric payment reference used in the Netherlands. When the payer copies it into their transfer, the receiving administration can match the payment to the right invoice much more reliably.

How often should I reconcile the bank in Exact Online?

Daily or at least weekly works best. Lines are easiest to explain soon after they arrive, and a short queue removes the pressure to park payments on a suspense account at month-end.

Sources

  1. Automatisch boeken afschrift (Exact Online product documentation)
  2. Troubleshooting statement imports (Exact Online Knowledge Base)
  3. Example of matching Mollie payments in Exact Online and the matching entry (Exact Online Knowledge Base)
  4. Betalingskenmerk (Betaalvereniging Nederland)

Read next

Where Thred comes in

Thred Layer

Finance agents running on top of your existing ledger. You set the rules, approve the work and handle the exceptions. No migration.

Keep reading

Finance, handled.

Book a demo, or request a callback and we will call you.

Book a demo