Rule Vault: Default Matching Rules
  • 13 Jun 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. Click here to 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 first 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.

  1. Name - The name of the Rule

  2. Description - The description for the Rule, if any

  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 - The type of transaction that will be created by this Rule. Options include:

    • Cash In (Deposit)

    • Cash Out (Expense/Withdrawal)

  6. Bank Activity Field - 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. 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


Was this article helpful?