The client wanted to automate their daily banking reconciliation process where they match transactions in the company’s book (in ERP) along with bankers’ statements. Their finance department was required to use three applications on their desktop, with structured information and predetermined rules and decisions.

The client’s traditional reconciliation process involved the manual extraction, comparison, and updating of volumes of files processed in their core banking system. Multiple process scenarios, time norms, and different file types complicated the process further, leading to errors, inconsistencies, and data integrity issues.

The UiPath robot automated the processing of statements across the banking platform with a zero-error rate. The bot compared periodic bank statements against the transaction files downloaded from the ERP. It then creates and sends a report of the reconciled and unreconciled transactions.