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: Match - match a bank feed transaction to a transaction in the Exo Business database. The Rule Conditions finds bank feed transactions, then the Action Conditions finds Exo Business transactions to match them to. Create ... Transaction - create a transaction to match a bank feed transaction. The Rule Conditions find bank feed transactions, then the Action Conditions populate the transactions that are created for them. You can use separate rule types for Debtor, Creditor, Expense, Income, or General Ledger transactions.
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: Equals - matches the transaction if the Match Field matches the Match Value exactly. Contains -matches the transaction if the Match Field contains the Match Value. ContainsAny - matches the transaction if the Match Field contains any of the values specified in the Match Value. StartsWith - matches the transaction if the Match Field starts with the Match Value. EndsWith - matches the transaction if the Match Field ends with the Match Value. RegExCompare - matches the transaction if the Match Field matches a regular expression specified in the Match Value. RegExCompareAny - matches the transaction if the Match Field matches any of the regular expressions specified in the Match Value. WildCompare - matches the transaction if the Match Field matches the Match Value, which can contain wildcard characters. WildCompareAny - matches the transaction if the Match Field matches the any of the values specified in the Match Value, which can contain wildcard characters.
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: And Or
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: Equals - matches the transaction if the Match Field matches the Match Value exactly. Contains -matches the transaction if the Match Field contains the Match Value. ContainsAny - matches the transaction if the Match Field contains any of the values specified in the Match Value. StartsWith - matches the transaction if the Match Field starts with the Match Value. EndsWith - matches the transaction if the Match Field ends with the Match Value. RegExCompare - matches the transaction if the Match Field matches a regular expression specified in the Match Value. RegExCompareAny - matches the transaction if the Match Field matches any of the regular expressions specified in the Match Value. WildCompare - matches the transaction if the Match Field matches the Match Value, which can contain wildcard characters. WildCompareAny - matches the transaction if the Match Field matches the any of the values specified in the Match Value, which can contain wildcard characters.
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: And Or
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: Put - copy the value of Source Value field to the Destination field. Concat - concatenate the value of Source Value field with the values from the other lines in this rule. Then, copy the concatenated value to the Destination 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.