Previous

General and bank account reconciliation rules

  • 4 min.

The general reconciliation rules and the bank account reconciliation rules are basically the same. However, general reconciliation rules apply by default to all bank accounts, and bank account reconciliation rules only apply to a specific bank account.

These reconciliation rules are applied during the import of a bank account statement to search for bank account lines for settlement in the bank account reconciliation journal. The search rules will be applied the description in the bank account reconciliation lines. If the search rule is complied with, a counter entry will be generated on a balance account (bank or ledger). Search rules will most often be applied in connection with recurring entries such as interests or fees.

Set up general and bank account reconciliation rules

  1. From the Bank Account Reconciliation page, select Rules, and then General Reconciliation Rules.
  2. To create a new reconciliation rule, in the action bar, select New.
  3. Fill in the fields according to the descriptions in the table below.
    Payment Management General reconciliation rules
ColumnDescriptionExample
Search TextSpecify the text to be searched for in the vendor payment.Fee
Search PrincipleSpecify how the search is carried out when searching for the specified search text.Exact indicates that the search text must be the exact same as the description on the bank account reconciliation line, for the rule to be met.
From left indicates that the search text must match the first part of the description on the bank account reconciliation line, for the rule to be met.
From right indicates that search text must match the last part of the description on the bank account reconciliation line, for the rule to be met.
Within indicates that the search text must just appear anywhere in the description on the bank account reconciliation line, for the rule to be met.
Balance Account No. (Positive)Specify the balance account (bank account or ledger account) to which the entry will be generated in case of a positive amount. If the account type is a ledger account, an account of the balance type must be used, which allows direct bookkeeping.9110
Balance Account No. (Negative)Specify the balance account (bank account or ledger account) to which the entry will be generated in case of a negative amount. If the account type is a ledger account, an account of the balance type must be used, which allows direct bookkeeping.6810

You can add as many rules as you want.

When you have finished setting up reconciliation rules, you can close the page. The rules will be implemented when you run a reconciliation in the bank account reconciliation journal.