Setting Up Bank Feeds Rules
By default, Bank Feeds matches transactions based on their date and amount. You can set up your own rules for matching transactions or creating new transactions based on transactions from bank feeds.
Set up rules for bank feeds by clicking the Setup Rules button in the Bank feeds module, or configure them in Exo Business Configurator under Admin > Banks > Bank Feed Rules.
The Setup Bank Feed Rules window lists all rules. Rules are listed in the order in which they are applied to the bank feed transactions. To re-order the list of rules, click on the rule you to move and drag it into a new position.
Note: Matching rules (including the default date and amount matching rule) are always applied before transaction creation rules. The priority order applies to rules of the same type.
To create a rule, click New, or select an existing rule and click Copy.
Details
The Details section contains basic details of the rule itself, as well as general details of transactions that are created by the rule (if any).
Field |
Description |
Rule Type |
Select:
|
Apply to Bank Account |
Select the bank account that this rule applies to, or select All to apply the rule to all bank accounts. |
Name |
Enter a name for the rule. |
Account |
Select the Debtor or Creditor account to assign to transactions created by this rule. This field is not enabled for Match or Create General Transaction type rules . |
GL Account |
This field is read-only and displays the GL account that is assigned to transactions created by this rule. |
Payment Type |
Select the Payment Type to assign to transactions created by this rule. This field is not enabled for Match type rules. |
Analysis Codes |
Click in this field to select Analysis Codes to apply to transactions created by this rule. |
GST Rate |
Select the GST Rate to assign to transactions created by this rule. This field is not enabled for Match type rules. |
Active |
Select this option to make the rule active. |
Manual |
This option is enabled for Create type rules only. Select this option to enable, the rule when creating a transaction by clicking the New button or right-clicking on un-matched transactions that satisfy the Rule Conditions. If you don't select this option, the rule is applied whenever the list of transactions is refreshed, and matching transactions are created. |
Rule Conditions
In this section, you can set up the conditions that determine which transactions from the bank feed are affected by the rule. Press the down arrow key to add a new condition to the rule.
Each condition has these attributes:
Field |
Description |
Match Field |
Select the field from the bank feed transaction to examine for a match. Note: You can populate three custom fields using a function or stored procedure to perform extra processing on bank feed data before the rules act on it. For example, you can parse the transaction details to find an invoice number or account. |
Match Operator |
Specify how to match the transaction:
|
Match Value |
Enter the value to match against the Match Field. For operators that support multiple values – ContainsAny, RegExCompareAny, and WildCompareAny – the values must be separated by commas. |
Link Operator |
Specify how this condition applies to the other conditions in this rule:
|
Invert |
Select this option to invert the Match Operator. For example, when this option is selected, a rule with the Equals operator matches all transactions that do not equal the Match Value. A rule with the Contains operator matches all transactions that do not contain the Match Value. |
Action Conditions
This section determines how the transactions that meet the Rule Conditions are acted on. You can specify multiple actions. Press the down arrow key to add a new action.
For rules with Rule Type of Match, this section specifies the Exo Business transactions that transactions meeting the Rule Conditions should be matched with:
Field |
Description |
Match Field |
Select the field of the Exo Business transaction that will be examined for a match. Note: The three Custom fields are available here as well. |
Operator |
Specify how the transaction will be matched. Choose from:
|
Source Value |
Select the field of the bank feed transaction to match the Match Field against. |
Link Operator |
Specify how this condition applies to the other conditions in this rule:
|
Invert |
Select this option to invert the Match Operator. For example, when this option is selected, a rule with the Equals operator matches all transactions that do not equal the Match Value. A rule with the Contains operator matches all transactions that do not contain the Match Value. |
For rules that apply to a new Exo Business transaction for the bank feed transaction, this section determines how to populate details of the Exo Business transaction:
Field |
Description |
Destination |
Select the field of the Exo Business transaction that should be populated. |
Action |
Specify how to populate the field:
To concatenate multiple lines, set the first line to Put and all subsequent lines to Concat. If more than one line is set to Put, only the last line is used. |
Source Value |
Select the field from the bank feed transaction to use to populate the field in the Exo Business transaction. |