Rule Vault: Default Matching Rules
  • 04 Dec 2024
  • 3 Minutes to read
  • Dark
    Light
  • PDF

Rule Vault: Default Matching Rules

  • Dark
    Light
  • PDF

Article summary

This is a part of the Rule Vault feature. Learn more about the Rule Vault.

Default Matching Rules are system-generated rules that help to match your bank statement to transactions that have already been entered in R365. When retrieving Bank Activity, the system will run through all default matching rules before running user-created rules. Default matching rules cannot be edited or deleted but can be marked as inactive as needed.


Default Matching Rule Fields

While the only aspect of a Default Matching Rule that can be updated is its status, Users can view each rule's matching criteria by clicking into the rule from the Rule Vault page. This criteria is defined below.

Button/Field

Description

1

Name

The name of the rule.

2

Description

Optional field to include a description.

3

Bank Accounts

The bank accounts that are assigned to this rule.

Default matching rules will have all bank accounts selected.

4

Matching Bank Activity to

This includes two options from which this Rule will match to:

  • Imported Account - Matching against transactions in the bank account

  • Undeposited Funds - Matching against Undeposited Funds transactions

5

Trx Type

  1. The type of transaction that will be created by this Rule. Options include:

    • Cash In (Deposit)

    • Cash Out (Expense/Withdrawal)

6

Bank Activity Type

The Bank Activity field(s) that correlate(s) with this Rule

7

Function

The function(s) that tie(s) the Bank Activity fields to the selected R365 Value

8

Rule Value

The value(s) that this Rule match(es) to in Bank Activity


Default Matching Rules Notes

  • Rule Vault Bank Account Location Matching Value

    When there is no Location available in the Imported Bank data, the Rule Vault will use the Bank Account's Location as the location matching value. This way, more bank transactions will be automatically matched by the system during Bank Activity Matching.

  • Multiple vCard Payments by Transaction Date Match Rule

    This Matching Rule matches bulk bank withdrawals to multiple vCard Payments. The system searches for multiple R365 vCard Payments that have the same or later Payment Date and matches the vCard Records to the Bank Transaction as a possible Match.

    Users can select to 'Match Set,' which will create a new bank transaction for each of the R365 Payment Transactions in the set, with the name, comment, and date from the original Bank Transaction and the amount matching the corresponding R365 Transaction.

  • Multiple vCard Payments by Batch Code Match Rule

    This Matching Rule matches bulk bank withdrawals to multiple vCard Payments. The system searches for multiple R365 vCard Payments that have the same batch code and matches the vCard Records to the Bank Transaction as a possible Match.

    Users can select to 'Match Set,' which will create a new bank transaction for each of the R365 Payment Transactions in the set, with the name, comment, and date from the original Bank Transaction and the amount matching the corresponding R365 Transaction.

  • Multiple ACH Payments Based on Payment Run/Check Run ID Match Rule

    This Matching Rule matches bulk bank withdrawals to multiple ACH Payments. The system searches for multiple ACH Payments with the 'ACH' Payment Method or R365 Payments whose R365 Payment Method is 'ACH' that have the same Payment Run/Check Run ID.

    Users can select to 'Match Set,' which will create a new bank transaction for each of the R365 Payment Transactions in the set, with the name, comment, and date from the original Bank Transaction and the amount matching the corresponding R365 Transaction

  • Multiple ACH Payments Based on Date Match Rule

    This Matching Rule matches bulk bank withdrawals to multiple ACH Payments. The system searches for multiple ACH Payments with the 'ACH' Payment Method or R365 Payments whose R365 Payment Method is 'ACH' that have the same Payment Date.

    When applied, Users can select to 'Match Set,' which will create a new bank transaction for each of the R365 Payment Transactions in the set, with the name, comment, and date from the original Bank Transaction and the amount matching the corresponding R365 Transaction


Default Matching Rules in Bank Activity

Users can view transactions impacted by the default matching rules in the matched/excluded tab on the bank activity page. The rule applied column displays name and number of the rule that was applied to the transaction. Users also have the the option to filter the tab to focus on transactions created by a specific rule.


Was this article helpful?