Managing the Import of Bank Account Statements

There are two ways to import bank account statements for reconciliation: manual selection of a file or using a direct communication service to import statements directly from the bank. To ensure that files are imported correctly, you must define the file format and import criteria.

On the Banking Import Setup page, you can decide which entries should be automatically matched, set limits for payment proposal variances, and specify the minimum details needed for accurate matching. For more information on the settings of the Bank Import Setup page, refer to the Configuring import settings article.

To define the file format for manual import

If you manually import bank account statements, you must define the file format to use for the import.

To define the import file format:

  1. Use the Search for page or report icon and search for Banks then select the related link. This will open the list of banks.
  2. Open the relevant bank card for which you want to define import format for manually imported bank statements.
  3. On the bank card, in the Bank Account Statement File Format field, specify the file format to use when importing bank account statement files. You can only select the file format when you use manual communication.

To manage bank statement selection

If several bank account statements are available for import, you can define which bank account statement should be prioritized when using direct communication.

To manage the selection of bank account statements:

  1. Use the Search for page or report icon and search for Continia Banking Setup, then select the related link.

  2. On the Continia Banking Setup page, on the FastTab General, in the

    Import Statement By field, specify how you want to import bank account statements for reconciliation. Use the drop-down arrow to choose between the following selections:

    • Statement Date: The account statement with the earliest statement date will be imported.
    • Entry No.: The account statement with the lowest entry number will be imported.
    • Manual Selection: You will be asked to manually select which account statement to import.

To manage the bank statement import method

You can specify how to import bank account statements on the bank account card. Indicating whether to import for reconciliation and when to start the reconciliation determines how the statement is imported and handled in the Job Queue.

To select the bank account statement import method:

  1. Use the Search for page or report icon and search for Bank Account, then select the related link. Select a bank to open the Bank card.
  2. On the Continia Banking FastTab, in the Bank Account Statement Import Method field select one of the following options:
    • Download only
    • Import for reconciliation
    • Import and start reconciliation automatically