Bank statement interface

The expected number of transactions is compared to the actual number of transactions when the bank statement interface is run. The receipt of all bank statement lines from the financial institution is verified. The cash management group that is associated with the cash management account is used for the comparison.

If a bank statement file exists in the received folder, then the bank statement is moved to the Bank Statement Interface file. The statement goes through several validations and is imported if no errors exist.

If the Automatic Bank Statement Import check box is selected on the cash management group, then it is imported to the bank statement after the file is placed in the Bank Statement Interface.

If Automatic Bank Statement Import is not selected, then the bank statement is not created. You must manually perform the import action on the bank import file.

The bank statement line is assigned a category by the bank statement interface. The category is based on the statement line classification of the Cash account, processing rules, and custom group definitions. If no processing rule criteria matches the bank statement line, then the default category of Uncategorized is assigned.

This list shows the supported bank statement formats:

BAI
BAI2
MT940
MT942
CSV
See the Sample Document Template for additional information about the layout of the CSV file.
CAMT052
CAMT053
The EDI822 format is used for the bank fee statement.

This list shows the process flows for Cash:

SyncBai2BankStatementData
SyncBai2BankStatementData_PGP
SyncCSVBankStatementData
SyncMT940BankStatementData
SyncMT940BankStatementData_PGP
SyncMT942BankStatementData
SyncMT942BankStatementData_PGP
SyncCAMT05XBankStatementData
EDI822BankFeeStatementData