Matching Rule Record

Prev Next

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:

  1. Navigate to the bank activity page.

  2. In the top ribbon, click Rule Vault.

  3. To view an existing Matching Rule click the desired row.

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

  1. Navigate to the bank activity page.
     

  2. In the top ribbon, click Rule Vault.

  3. 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.