Automate bank reconciliation: match payments automatically
You automate bank reconciliation with a workflow that fetches transactions from all bank accounts daily and matches them to open invoices by amount, reference and customer data, including partial, combined and discounted payments. Your team only resolves the cases that are not clear-cut and gets a suggestion for each. In the worked example with 500 transactions a month this saves about 14 h.
- Time saved in the worked example
- approx. 14 h per month
- Delivery
- 7 to 12 working days
- Typical systems
- Bank APIs (PSD2), camt.053, Xero
- Fixed price
- from €990
, Rouven Jahnke
Flow: Bank reconciliation
5 steps-
Fetch transactions
Daily from all bank accounts
-
Match
Amount, reference, customer
-
Detect special cases
Partial, combined, discounted payments
-
Resolve the rest
With a suggestion, not a search task
-
Post clearing
Close open items automatically
Green runs automatically. Orange is decided by a person.
Where time gets lost today
- Payments are matched line by line
- References are incomplete or wrong
- Reminders go out because payments weren’t matched
With a few payments, reconciliation is quick. With hundreds a month it becomes drudgery: open the statement, read the reference, find the invoice, compare the amount. It gets hard when customers pay several invoices in one sum, deduct a discount or forget the invoice number.
Unmatched payments keep invoices open in the books. That distorts cash planning and, at worst, triggers reminders to customers who paid long ago.
How the automation works
The workflow fetches transactions from all accounts daily, via the bank interface or as statements in camt.053 format. Each payment is matched against open items: invoice number in the reference, amount, customer name, IBAN from earlier payments.
Harder cases are handled with rules and AI support: a combined payment is checked against matching invoice combinations, a payment three percent short is recognised as an early-payment discount when the deadline fits. Clear matches are posted as clearings or proposed to your bookkeeper.
What remains are the genuinely unclear cases. They go to your team, not as a search task but with the most likely suggestion and the reason for it.
What your team still decides
Your team confirms unclear matches and decides on differences, for example whether to reclaim an unjustified discount. Only clear matches are posted automatically, everything else after your confirmation.
Calculate your savings
Adjust the values to your company. The calculation runs only in your browser; nothing you enter is transmitted.
- Working time saved per month
- – h
- Savings per month
- –
- Savings per year
- –
Excludes running costs for hosting and AI usage. You receive the implementation cost as a fixed price after the intro call.
Formula
Hours saved/month = (Transactions x Accounts x 0.5 min + Transactions x Discrepancy rate x 10 min resolution) x Automation rate / 60
Worked example
The calculator above starts with these assumptions. They are example values, not averages from studies.
- Transactions per month
- 500
- Bank accounts
- 3
- Discrepancy rate
- 5 %
- Share of work automated
- 85 %
- Labour cost per hour (fully loaded)
- 45 €
Result: about 14 h less manual work per month, roughly €640 a month or €7,700 a year.
Before and after
| Aspect | Today, by hand | With the workflow |
|---|---|---|
| Matching | Line by line by hand | Automatic for clear cases |
| Combined payments | Adding up invoices | Combinations are checked |
| Unclear cases | Search task | Suggestion with reasoning |
| Open items | Partly outdated | Up to date every day |
Frequently asked questions
How does the workflow access our bank accounts?
Read-only, either through a bank API (PSD2 or similar) or via camt.053 statements from your online banking. The workflow cannot initiate payments.
What about payments without an invoice number?
Then amount, name, IBAN and the customer’s earlier payments are used. If that isn’t enough for a clear match, your team gets a suggestion to confirm.
Does the workflow post entries itself?
As you prefer: clear matches can be posted directly as clearings in your accounting software. If an external accountant keeps your books, the workflow hands over the matches as a list or export instead.
What does this workflow cost and how quickly is it live?
Implementation is a fixed price from €990; the exact price is set after the free intro call and depends on the number of connected systems and exceptions. Typical delivery time for this workflow: 7 to 12 working days. Running costs for hosting and, where used, AI usage are quantified in the proposal.
Bank reconciliation: free intro call
Describe a process that eats time today. I’ll tell you honestly whether automating it pays off, what it would look like and what it costs.
- We walk through your process together, ideally on screen.
- You learn which step has the biggest leverage and what it takes.
- You receive a fixed-price proposal within 48 hours. No obligation.
Pick a time in the calendar
Loading calendar…
Thanks, your message arrived.
You’ll get a confirmation email. I’ll reply within 24 hours.
Your reference number: