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.