MYOB Exo Business

Hide NavigationShow Navigation

  • Contents
  • Index
  • Search
 
Show results that include all search words

 

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.