Merging Bank Statement Lines

When importing bank account statements with Statement Intelligence, bank reconciliation lines can automatically be merged into one line based on the defined merge rules. Reconciliation lines, that have not automatically been merged during import, can manually be merged in the bank account reconciliation.

Merging of bank account entries is typically used where several credit card transfers are merged into one total per day because that is the amount posted in the general ledger.

To merge lines by merge rules

If you have defined merge rules needed to run automatic merge of bank account statement lines, the lines that comply with the merge rules will be merged during the import of the bank account statement.

If you have been working with the lines after import, that should then be merged, you can manually run the merge rule from the reconciliation journal.

  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. On the required bank account reconciliation, go to the action bar and select Matching > Merge Lines by Rule.

Statement Intelligence will merge lines that can be merged according to the defined merge rules.

To merge lines manually

If merge rules have not been set up, or if the bank account statement lines cannot be merged using the defined merge rules, bank statement lines can be merged by manual selection.

  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. On the required bank account reconciliation, mark the bank statement lines that should be merged, by pressing Ctrl on your keyboard while choosing those lines that should be merged.
  3. Navigate to the action bar and choose Process > Merge Lines Manually.

The lines chosen for manual merge are now merged into one line.

Information about merged lines

To get an overview of which lines have been merged into one line, navigate to the merged bank statement line and select Additional Information. This action opens a list with an overview of a description and a notification for all the lines included in the merge.

Undo merged lines

It is not possible to unmerge lines that have been merged in the reconciliation journal. If you need the lines not to be merged, you must delete the merged line, and reimport it into the reconciliation journal. If the line was merged by a merge rule, you must disable the merge rule before importing the account statement lines again.

See also

Account statement merge rules.