10 mins for Bank Statement (~50 Accounts)
~ 3 min each statement
Challenge: Previously, our client had to manually retrieve MT940 statements from SFTP locations, decrypt the encrypted files, and upload them into Oracle Fusion for reconciliation. This manual effort required approximately 10 minutes per bank statement for each of our 50 accounts. The process was time-consuming, prone to errors, and hindered quick turnaround times for reconciliation requests.
Solution: To overcome these challenges, we implemented Automation Anywhere 360 in combination with Dot net to automate the bank statement reconciliation process. Our RPA bot was designed to perform the following steps:
- SFTP Connection: The bot utilized Dot net DLL to securely connect to the SFTP server, ensuring a seamless and controlled data retrieval process.
- Statement Download: Our bot automatically downloaded MT940 statements from various bank accounts, eliminating the need for manual retrieval and ensuring efficient data collection.
- Encryption Decryption: The bot decrypted the encrypted bank statements, enabling seamless processing and preparation for reconciliation.
- Oracle Fusion Upload: Our RPA bot uploaded the decrypted statements into Oracle Fusion, enabling automated reconciliation for all bank statement entries. This integration eliminated the need for manual data entry and reduced the risk of human errors.
- Transaction Log and Screenshots: The bot generated a transaction log and captured screenshots at relevant steps in the process, providing a comprehensive audit trail for future reference and compliance purposes.
- Notification and Business Exceptions: Our bot sent a notification to the relevant stakeholders, including the business team, containing the transaction log and any identified business exceptions. This facilitated prompt action and issue resolution.
- Daily Automation: The bot performed this automated task every day, ensuring the consistent and timely reconciliation of bank statements.