Importing and Reconciling Bank Statements

Bank account statements can be imported by file or - if supported by the bank - they can be imported directly from the bank using direct communication.

Upon import, the bank's file format is converted, after which all information is automatically created in the bank account reconciliation.

When importing the bank account statement Statement Intelligence will perform automatic reconciliation, either by matching the account statement lines with bank account ledger entries, preparing accounts receivable for matching, or creating matching proposals.

To import a bank statement

  1. Use the Search for page or report icon and search for Bank Account Reconciliations, then select the related link. This opens the list of bank account reconciliations.
  2. Open the bank account reconciliation for which you want to import account statement lines or create a new bank account reconciliation by selecting New in the action bar.
  3. On the bank account reconciliation navigate to the action bar and select Bank > Import Bank Statement.
  4. If the bank account is set up to use OPplus Smart Banking, available bank account files will automatically be imported into the journal directly from the bank. If, on the other hand, the bank account is not set up for direct communication, you must manually select the file to be imported into the journal.

During import, the account statement will be prepared for reconciliation. Then matching functionality can be used.