Pre-audit Preparation Automation

Some of the key challenges were:

• The process was highly time-consuming that involve downloading various reports from the different banking applications, consolidating the report with necessary data massaging, and updating the same in a pre-formatted macro-enabled MIS excel file.
• Adding a human dependency gives further delay in the completion of the internal audit process.
• The process was having a high chance of human error.

• The bot seamlessly interacts with various applications and extract the required data from them.
• The bot consolidates this downloaded data and does necessary data massaging in excel as per the set business rules.
• The bot copies data into a pre-formatted macro-enabled MIS excel file and runs macros to create the MIS reports and place the same in the specified folder and intimately concerned stakeholder through the mail.

• Drastically shortened processing time.
• Robotisation level: 100% automatic effort.
• Error rate decreased to 0%
• 98% drop in manual effort
• Employees were redeployed to use their skills in higher-value complex activities