A2019 - Bank Statement Reconciliation

Bot downloads bank statements for mail server and transaction statements from ERP system. Then reconciles bank statements and transaction statements

Top Benefits

  • Removes the manual effort to download the bank statement file from mail & transaction statements from ERP
  • Removes the manual efforts of reconciling sensitive data
  • Bank statement reconciliation process which reduces human intervention


  • Download bank statement file from mail
  • Download transaction statements from ERP
  • Reconcile both files through script file
  • Upload output file to ERP System

Bank statement reconciliation is a summary of banking and business activity that reconciles an entity's bank account with its financial records. The statement outlines the deposits, withdrawals, and other activities affecting a bank account for a specific period of equity.

Get Bot


Bot Security Program
Level 1
Business Process
Automation Type
Last Updated
December 14, 2020
First Published
December 12, 2020
Enterprise Version

See the Bot in Action

Bot creation structure
ERP system
Mail from we download attached bank statement file
Bot creation structure
ERP system
Mail from we download attached bank statement file

Setup Process


Download the Bot and follow the instructions to install it in your AAE Control Room.


Open the Bot to configure your username and other settings the Bot will need (see the Installation Guide or ReadMe for details.)


That's it - now the Bot is ready to get going!

Requirements and Inputs

  • Required to pass values in variable those follow as below:
  • sEmailServerHost - Provide email server host name to check received mail from server
  • nEmailServerPort - Provide email server port number to check received mail from server.
  • AttachmentFolderPath – Provide input folder path to store bank statement attached file and transaction statement file
  • SenderEmailID - Provide sender email ID for receiving bank statements file from mail server.
  • ErrorFolderPath - To store error details
  • Create credential vault to store email ID and password, select email credentials in email: connect action at line no. 5