Setting up search rules

During a bank account statement import, the system attempts to identify transactions and match them to the correct accounts. When the system cannot determine an account automatically, you can define search rules to to help recognize transactions based on specific text criteria. Search rules are especially useful for recurring entries such as interest charges, bank fees, or standard payments.

For more information on when to use a search rule, see Introducing search rules in Continia Banking.

For more detailed information about how to set up search rules for common scenarios such as partial text matching, specific bank accounts, and credit or debit amounts see Setting up search rules for common scenarios.

To add a search rule

To set up search rules:

1. Search () for and select Search rules. Alternatively, on the Bank Account Reconciliation or Payment Journal Reconciliation page, select the bank statement line that needs a search rule, and on the action bar, select Rules > Add Search Rule. If a search rule with the same search text already exists, the system opens the existing rule.
2. On the Search Rules page, navigate to the action bar and select New to create a new reconciliation rule.
3. In the Search Text field, specify the text to search for. The system uses this text on the bank account reconciliation lines to identify a match. To use multiple search texts to identify an account, click Add additional search texts on the action bar.
4. In the Usage Type field, you can decide how to apply the search rule. The options are:
   • Always - the rule is applied regardless of the presence or absence of payment application proposals.
   • With proposal - the rule is applied only when payment application proposals exist.
   • Without proposal - the rule is applied only when no payment application proposals exist.
5. In the Search Field Template field, specify where the system should look for the text. The most common search field templates are available by default, and you can create your own. If the text matches any field in the template, the rule is applied to bank statement lines or payment reconciliation journal lines. For more information, see Search field templates for search rules.
6. In the Search Method field, specify how the search is carried out when searching for the specified search text. The options are:
   • Exact - the search text must match the field on the reconciliation line in full.
   • From Left - the search text must match the start of the field on the reconciliation line.
   • From Right - the search text must match the end of the field on the reconciliation line.
   • Contains - the search text must appear anywhere in the field on the reconciliation line.
7. In the Account Type field, select the account type to assign: G/L account, customer, vendor, or employee.
8. In the Account No. field, specify the balance account to which the entry is applied.
9. On the Rule Filter FastTab, define the conditions under which the rule is applied. The following fields are available:
   • Amount Filter - select Only Negative to apply the rule only to lines with negative amounts, Only Positive for lines with positive amounts, or All to apply the rule regardless of the amount.
   • Statement Type Filter - specify the statement type the rule applies to. For example, to restrict a rule to imports made through the Payment Reconciliation Journal, select the relevant CAMT.054 statement type.
   • Bank Code - specify whether the rule applies to a specific bank. When you select a specific bank, the rule applies only to bank statement lines or payment reconciliation journal lines associated with that bank.
   • Bank Account - specify whether the rule applies to a specific bank account. When no account is specified, the rule applies to all bank accounts.
10. On the Posting FastTab, configure how lines are posted. For example, you can add a template for the posting description and assign the VAT business posting group to use.
11. If you turn on the Ignore Account Type toggle, the rule can match a bank reconciliation line even when the line's account type differs from the rule's account type. This is useful when you want the rule to apply based on search text alone, regardless of the account type originally suggested by a bank transaction code rule. Click Show more if this field is not visible.

The fields Search Text, Search Field Template, Account Type, and Account No. are mandatory. If any of these fields are empty when you save the rule, a notification appears on the Bank Account Reconciliation page and the Payment Reconciliation Journal page.

To disable a search rule

1. Search () for and select Search Rules.
2. Open the rule you want to disable.
3. On the General FastTab, turn on the Disable toggle.

Disabled rules are not applied during matching.

Related information

Introducing search rules in Continia Banking
Search field templates for search rules
Setting up search rules for common scenarios
Search rules FAQ