It is the last working day of the month. Time for bank reconciliation. A bank app reads your statements, matches them and posts the entries, so most of it takes care of itself. What is left are the exceptions the app couldn’t match, and those are what eat up your time. Thomas Werkhoven, managing director of Exsion365 and still a controller at heart, handles them in Excel.

Where it gets stuck

The app already does the heavy lifting. The hassle is the one payment booked on a customer but not on the right invoice. Before you can fix it, you first have to find it: which customer, which invoice and where it went wrong. In Business Central that means clicking from screen to screen until you lose track. That's why so many controllers reach for Excel.

How I handle it in Exsion

Like most of our customers, I use a bank app that reconciles automatically. What is left is that exception. I open the customer entry in Excel and see straight away how the payment was split and which invoices are still open. No clicking through Business Central, no export. In my case that saves about 90% of the time it used to take me. Fewer steps, fewer mistakes, and room for the real question: why did it not match?

See it with your own figures

Want to see where that 10% in your books goes wrong? Book a meeting with an expert. Together we set up your bank reconciliation overview, so you see straight away how it works for the one payment that does not match. More than 20,000 users already work with their Business Central data this way.

Talk to an expert >>>