Matching Rules are created from the Rule Vault.
Matching Rules set the conditions required for imported bank activity to match to existing R365 records.
Security
Users must have the following permission(s) to create Bank Rules.
Banking → Bank Activity → Bank Rules → Create Bank Rules
Create a Matching Rule
To create a Matching rule from the Rule Vault, follow these steps:
Click steps to expand for additional information and images.
1) From the accounting application, under banking, click the Bank Activity page.
2) In the top ribbon, click Rule Vault.
3) Click New Rule.
4) Select Matching Rule.
5) Enter a name for the rule.
6) Select the bank account(s) the rule will apply to.
A window will open where the bank account(s) can be selected by account number, legal entity, or bank.
7) Select the transaction type: cash in or cash out.
Cash In - Applies the matching rule to imported bank activity for cash coming into the account.
Cash Out - Applies the matching rule to imported bank activity for cash going out of the bank account.
When Cash In is selected, the option to match bank activity to undeposited funds is added to the matching rule.
This indicates whether the rule should looks to match to transactions recorded to undeposited funds or the imported account.
8) For Cash In transaction types, set what the rule will match bank activity to.
9) Click the + to add a condition then set the condition(s) for the rule using the bank activity type, function, and rule value.
The default condition parameters require an exact amount match between the imported bank activity and the existing transaction and cannot be edited or deleted.
The option selected for the bank activity type determines the options for the function and rule value.
Select a bank activity type below to view it’s associated function and rule value options:
Bank Transaction ID
When selected, the function is set to equal and the rule value is TransactionNumber.
The function and rule value are not customizable when bank transaction ID is selected.
Date
When selected, the function options are:
Equal to
Selecting ‘equal to’ adds a within option that sets the range of acceptable days around the transaction date. Users can enter the number of days and choose whether it applies before (-), after (+), or both before and after (±).
Not Equal to
Greater than
Less than
Greater than or Equal to
Less than or equal to
‘Greater than’ is used as after and ‘less than’ is used as before.
When selected, the rule value field accepts dates in the MM/DD/YYYY format.
Amount
When selected, the function options are:
Equal to
Not Equal to
Greater than
Less than
Greater than or Equal to
Less than or equal to
When selected, the rule value field accepts numbers only.
Name
When selected, the function options are:
Equal to: Requires an exact match between the rule value entered and the bank activity name in order for the rule to be applied.
Contains: Requires the rule value to be present somewhere in the bank activity name in order for the rule to be applied.
Starts with: Requires the bank activity name to start with the rule value in order for the rule to be applied.
When selected, the rule value field accepts letters, numbers, and special characters.
Comment
When selected, the function options are:
Equal to: Requires an exact match between the rule value entered and the bank activity name in order for the rule to be applied.
Contains: Requires the rule value to be present somewhere in the bank activity name in order for the rule to be applied.
Starts with: Requires the bank activity name to start with the rule value in order for the rule to be applied.
When selected, the rule value field accepts letters, numbers, and special characters.
10) To add additional conditions click the + button . (Optional)
Review step 9 to view condition options.
11) Once all required and desired fields have been entered, click create to add the rule.
By default, new rules are set to active. Learn about marking a rule inactive.