Reconciliation Statement Import

Overview

Users will be able to import the detailed information from bank statements. This includes the bank account information, the deposits received by the bank, the checks cleared, service fees, interest and the bank adjustments. The file structure for the bank statement must confirm to the formats pre-defined. The import will consist of 2 import text files having file names ending with BANKHDR.txt and BANKITM.txt. The two files will be compressed together in .zip format for import into the application.

Navigation

Treasury Management Bank Reconciliation ► Reconciliation Statement Import

Reconciliation Statement Import Screen Fields and Tab

 

Fields

Description

User 

System user name will be displayed.

Batch Number

First Batch number start with 1. Every time an import is succesfully finished, the system will increment this number by 1.

Upload File

When the user clicks the ‘Choose File’ button, a file dialog window will be shown, allowing the user to select any file with an extension = “.zip”.