General and bank account reconciliation rules
- 5 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
- From the Bank Account Reconciliation page, select Rules, and then General Reconciliation Rules.
- To create a new reconciliation rule, in the action bar, select New.
- Fill in the fields according to the descriptions in the table below.
| Column | Description | Example |
|---|---|---|
| Search Text | Specify the text to be searched for in the vendor payment. | Fee |
| Search Principle | Specify 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.
Add dimensions to bank account reconciliation rules
To enhance the functionality and reporting capabilities of reconciliation rules for bank accounts, you can include dimensions.
Dimensions are values that categorize entries so you can track and analyze them. For example, by setting up dimensions on bank account reconciliation rules, you can ensure accurate tracking and analysis of data. If no specific dimension is added, the system will automatically assign the dimension from the corresponding G/L account.
This feature ensures that dimensions are added to the journal lines generated by the rule, and they will be automatically included in the entry when it is posted.
Note
For more details about adding dimensions, please refer to the article Setting up bank account reconciliation rules on Continia Docs.
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.