Home Services Case Studies FAQ Contact Free consultation

Case Studies · FinTech

Month-end bank reconciliation for a global payments company, on autopilot

A robot now handles 130+ bank reconciliations every month, whatever format each statement arrives in, and hands finance a ready-made report.

130+
bank reconciliations every month, across banks around the world
4 formats
CSV, XLS, XLSX and PDF statements handled
7 outcomes
each statement filed as complete, incomplete, no movement or needing review
1 report
monthly summary emailed to finance when the run finishes

The challenge

Our client is a fintech company competing on the world stage, moving money across borders for businesses everywhere. To stay competitive, it wanted its finance team focused on control and analysis, not on routine preparation.

Month end told a different story: more than 130 bank reconciliations, for accounts held with banks around the world. Every bank sends its statement differently. Some send CSV, some Excel, some only PDF, and one combines several accounts into a single workbook. Each month the team gathered the files, converted the PDFs, split the workbook, matched every statement and updated the summary by hand.

They wanted to retire that repetitive practice for good, and let the team spend month end on the accounts that actually need attention.

What we built

A robot that runs the whole reconciliation for the previous month:

  • Collects and sorts every statement, and sets aside files from banks that are out of scope.
  • Converts PDFs to Excel and splits the combined multi-account workbook into one file per account.
  • Reconciles each statement against its references, using the rules agreed for each bank.
  • Files every statement by outcome: complete, incomplete with open items, no movement, converted, excluded, skipped, or flagged for manual review.
  • Updates the monthly report and bank summary, then emails finance when the run is done.

Anything the robot can’t settle with confidence goes to a “for manual processing” folder, and is picked up again on the next run once a person has dealt with it.

Built to keep running

Before each run, the robot checks that every folder and reference file it needs is in place. If a step fails it retries automatically. If it still can’t finish, it takes a screenshot, logs the error and emails the support team, so nothing fails silently.

Results

  • No manual preparation: statements are collected, converted, reconciled and filed by the robot.
  • One consistent process for every bank, whatever format its statement arrives in.
  • Clear status for every account each month: what is complete, what has open items, and what needs a person.
  • A full audit trail: daily logs, a monthly report and an email at the end of every run.

Reconciling many banks by hand?

We'll build a free proof of concept on your real data so you can see the result first.

Book a free assessment