Matching Rule Record

Matching Rule records are viewed and created from the Rule Vault. Matching Rules set the conditions required for imported bank activity to match to existing R365 records. R365 has default matching rules that can marked active or inactive but cannot be edited further. Users can also create matching rules to customize matching conditions.

Security

The following permissions are associated with bank rules:

Banking → Bank Activity → Bank Rules → View Bank Rules
Banking → Bank Activity → Bank Rules → Edit Bank Rules
Banking → Bank Activity → Bank Rules → Create Bank Rules
Banking → Bank Activity → Bank Rules → Activate Bank Rules
Banking → Bank Activity → Bank Rules → Delete Bank Rules

Navigation

To navigate to an existing Matching Rule, follow these steps:

Navigate to the bank activity page.
In the top ribbon, click Rule Vault.
To view an existing Matching Rule click the desired row.

To create a new a Matching Rule, follow these steps:

Navigate to the bank activity page.
In the top ribbon, click Rule Vault.
To open a new Matching Rule , click New Rule then Matching Rule.

Custom Matching Rule Record

Matching rules automatically include an uneditable condition that requires the bank activity amount to exactly match the R365 transaction amount.

	Button/Field	Description
1	Copy	Duplicates the current rule and opens the duplicated record. R365 default matching rules cannot be copied. This button is disabled for new rules until the rule is saved.
2	Trashcan	Deletes the current rule. This button is disabled for new rules until the rule is saved.
3	Create	Creates the matching rule and defaults it to active. This button is replaced with a save button for existing rules. This button is disabled for new rules until all required fields have been completed.
4	Mark Inactive	Marks the current rule as inactive. This button is replaced with a mark active button inactive rules. Learn more about rule Statuses. This button is disabled for new rules until the rule is saved.
5	Full Screen/ Minimize Screen	Expands the side sheet to full screen or collapses the sidesheet from full screen.
6	Close	Closes the rule without saving.
7	Name	The name of the matching rule. Up to 50 characters can be entered.
8	Description	An optional text field to describe the rule. Up to 75 characters can be entered.
Bank Account Assignment
9	Bank Accounts	The bank accounts that will be assigned to this rule. A rule will only be applied to activity imported into the bank accounts selected here. If a bank account is not selected, then activity imported into that account will not follow this rule. Bank accounts can be assigned by account number, legal entity, or bank.
Matching Conditions
10	Match Bank Activity to:	Sets the account type the bank activity should look to match to: Imported Account - Imported bank activity associated with an R365 bank account. Undeposited Funds - The holding account for funds that have been received but not yet deposited to the bank. This field is only available when the transaction type (#11) is set to ‘Cash In’.
11	Transaction Type	The type of transaction the rule can be applied to. Options include: Cash In (Deposit) Cash Out (Expense/Withdrawal)
12	Bank Activity Type	The criteria that has to be met in order for imported bank activity to match to existing R365 transactions. The bank activity type selected determines the function (#13) and rule value (#14) options available. Options include: 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.
13	Function	The function or parameter used to tie the bank activity field to the rule value. Options for this field vary depending on the bank activity field selected.
14	Rule Value	The user entered value the rule is referencing to match to in bank activity. This field will vary depending on the bank activity field selected.
15	+ Plus Condition	Adds an additional condition row that can be edited.