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. This list shows the criteria that must be met:

  • The account number in the file matches the number that is defined in the cash management account.
  • The bank statement file name has not been moved to the bank statement interface.

    The same file name can be imported. If a bank statement for the cash account and date exists, a second bank statement is not generated for the same cash account and date.

  • The currency of the bank statement interface is the same as the cash management account.

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 Management 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.

  • EDI822
  • CAMT052 Intraday

    Support the ISO bank transaction type codes.

  • CAMT053

    Support the ISO bank transaction type codes.

This list shows the process flows for Cash Management:

  • SyncBai2BankStatementData
  • SyncBai2BankStatementData_PGP
  • SyncCSVBankStatementData
  • SyncMT940BankStatementData
  • SyncMT940BankStatementData_PGP
  • SyncMT942BankStatementData
  • SyncMT942BankStatementData_PGP
  • EDI822BankFeeStatementData
  • SyncCAMT05XBankStatementData
  • SyncCAMT053BankStatementData