1. Administering Data Integration for Oracle Enterprise Performance Management Cloud
  2. Integrating Data
  3. Integrating Account Reconciliation Data
  4. Verifying BAI Bank Statement Balances

Verifying BAI Bank Statement Balances

Account Reconciliation customers can verify that the correct bank statement is being loaded using the Bank Statement Verification feature in Data Integration. When enabled, the system compares the current period expected ending balance to the ending balance provided in the BAI file being loaded.

To calculate the current period expected ending balance, the system adds the net total of the current day transactions to the previous period ending balance for the Account ID. If a difference is detected or any error is encountered, the transactions remain in the Workbench; however, they are not exported to transaction matching.

Bank Statement Verification enables you to identify:

  • duplicate transactions and duplicate data loads
  • missing balances or transactions
  • statements loaded in the incorrect order (that is, non-chronological order)
  • incorrect currency codes

Note:

Bank Statement Verification works only when daily periods are configured on the base calendar. Also, when the system retrieves the previous period ending balance for the comparison, it always uses the most recent prior period balance available for the Account ID.