Multiple Bank Statements per Bank Account Reconciliation

When importing bank account statements, your Statement Intelligence settings on the bank account define if multiple bank account statements can be imported to the same bank account reconciliation.

According to your settings, the bank account statements can be aggregated by period. If you've chosen to compile the statements in accordance with a given period, for example, the current week, only those bank account statements that have a statement date within the current week can be compiled into the same bank account reconciliation. You can enable Statement Intelligence to automatically create a new bank account reconciliation if the statement date lies without the allowed period for the given bank account reconciliation.

To allow for multiple bank statements

  1. Use the Search for page or report icon and search for Bank Accounts then select the related link. This will open the company bank accounts.
  2. Open the relevant bank account card for which you want to allow for multiple bank statements.
  3. On the Statement Intelligence FastTab, enable the feature Allow Multiple Bank Statements, to allow for multiple bank statements to be aggregated in one bank account reconciliation.
  4. In the Aggregation Period field, use the dropdown arrow to choose if the aggregation of bank statements in a bank account reconciliation should be limited to a given period. You can choose between the following selections: Blank, Current Week, and Current Month. If the field is left blank, there will not be any restrictions for aggregating bank statements. If you choose a period, bank statements can only be compiled to the bank account reconciliation if the Statement Date of the imported bank statement is within the given period.
  5. In the Create New Reconciliation field, choose if Statement Intelligence must automatically create a new bank account reconciliation if the Statement Date on the imported bank statement is outside the allowed period for aggregating bank statements in the existing bank account reconciliation.