We're reorganizing! You might notice your favorite article has a new home. We'll be done soon—but in the meantime, try using the search bar to quickly find what you need.
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:
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
Source
Determines which transaction type the rule criteria will reference. Options include:
Bank Activity: References bank activity transactions.
R365 Transaction: References data from existing transactions created in R365 (e.g., AP Payment, Bank Expenses, Bank Deposits, or Journal Entries).
When R365 transaction is selected, the available options in the Transaction field will adjust based on the selected Transaction Type (Cash In or Cash Out).
13
Transaction Field
Specifies the fields used for matching criteria based on the selected source. The transaction field selected determines the function and rule value options available.
R365 Transaction Field Options:
Cash In: When cash in is selected, the rule conditions reference the fields on the bank deposit header or journal entry line, depending on the field selected.
Location:
The location field references the deposit header and journal entry line.
When selected, the function options are:
Equal to: Requires an exact match between the rule value entered and the location name in order for the rule to be applied.
Contains: Requires the rule value to be present somewhere in the location name in order for the rule to be applied.
Starts with: Requires the location name to start with the rule value in order for the rule to be applied.
When selected, the rule value accepts alphanumeric text.
Date
The date field references the deposit header and journal entry header.
When selected, the function options are:
Equal to
Within
When selected, the following additional options are displayed:
Days: Accepts whole numbers up to 1000
Before or After dropdown
After
After or equal to
Before
Before or Equal to
When selected, the rule value field accepts dates in the MM/DD/YYYY format.
Comment
The comment field only references the journal entry line.
When selected, the function options are:
Equal to: Requires an exact match between the rule value entered and the comment in order for the rule to be applied.
Contains: Requires the rule value to be present somewhere in the comment in order for the rule to be applied.
Starts with: Requires the comment to start with the rule value in order for the rule to be applied.
When selected, the rule value accepts alphanumeric text.
Check Memo
The check memo field only references the deposit header.
When selected, the function options are:
Equal to: Requires an exact match between the rule value entered and the check memo in order for the rule to be applied.
Contains: Requires the rule value to be present somewhere in the check memo in order for the rule to be applied.
Starts with: Requires the check memo to start with the rule value in order for the rule to be applied.
When selected, the rule value accepts alphanumeric text.
Cash out: When cash out is selected, the rule conditions reference the fields on the AP payment header, the bank expense header, or the journal entry line, depending on the selected field.
Location
The location field references the AP payment header, bank expense header, or journal entry line.
When selected, the function options are:
Equal to: Requires an exact match between the rule value entered and the location name in order for the rule to be applied.
Contains: Requires the rule value to be present somewhere in the location name in order for the rule to be applied.
Starts with: Requires the location name to start with the rule value in order for the rule to be applied.
When selected, the rule value accepts alphanumeric text.
Date
The date field references the the AP payment header, bank expense header, or journal entry header.
When selected, the function options are:
Equal to
Within
When selected, the following additional options are displayed:
Days: Accepts whole numbers up to 1000
Before or After dropdown
After
After or Equal to
Before
Before or Equal to
When selected, the rule value field accepts dates in the MM/DD/YYYY format.
Comment
The comment field references the AP payment header or journal entry line.
When selected, the function options are:
Equal to: Requires an exact match between the rule value entered and the comment in order for the rule to be applied.
Contains: Requires the rule value to be present somewhere in the comment in order for the rule to be applied.
Starts with: Requires the comment to start with the rule value in order for the rule to be applied.
When selected, the rule value accepts alphanumeric text.
Check Memo
The check memo field only references the bank expense header.
When selected, the function options are:
Equal to: Requires an exact match between the rule value entered and the check memo in order for the rule to be applied.
Contains: Requires the rule value to be present somewhere in the check memo in order for the rule to be applied.
Starts with: Requires the check memo to start with the rule value in order for the rule to be applied.
When selected, the rule value accepts alphanumeric text.
Payment Method
The payment method field references the AP Payment header only.
When selected, the function options are:
Equal to
Not Equal to
When selected, the rule value offers a menu of the following options:
R365 Payments
ACH
Check
Auto-Direct Debit
Credit Card
Vendor
The vendor field references the AP payment header or bank expense header.
When selected, the function options are:
Equal to: Requires an exact match between the rule value entered and the vendor name in order for the rule to be applied.
Contains: Requires the rule value to be present somewhere in the vendor name in order for the rule to be applied.
Starts with: Requires the vendor name to start with the rule value in order for the rule to be applied.
When selected, the rule value accepts alphanumeric text.
Bank Transaction Field Options:
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
When selected, the rule value field auto-populates as transaction number and cannot be edited.
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.
14
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.
15
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.
16
+ Plus Condition
Adds an additional condition row that can be edited.