Bank Statement Reconciliation
This bot downloads bank statements for mail server and transaction statements from the 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
Tasks
- 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.
Free
- Bot Security Program
-
Level 1
- Applications
-
- Business Process
- Finance & Accounting
- Category
- Banking and Financial Services
- Downloads
- 158
- Vendor
- Automation Type
- Bot
- Last Updated
- June 21, 2021
- First Published
- December 12, 2020
- Platform
- Automation 360
- ReadMe
- ReadMe
- Support
-
- Community Support Only
- Pathfinder Community Developer Forum
- Bot Store FAQs
See the Bot in Action
Setup Process
Install
Download the Bot and follow the instructions to install it in your AAE Control Room.
Configure
Open the Bot to configure your username and other settings the Bot will need (see the Installation Guide or ReadMe for details.)
Run
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