Bank Statement Verification Option for BAI Statement Balances in Data Integration

Account Reconciliation customers can now verify that the correct BAI 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. If a difference is detected or any error is encountered in one or more of the accounts, an error log is produced and the transactions will remain in the Workbench; however, they are not exported to transaction matching.

Business Benefit: 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), and incorrect currency codes.

Key Resources