Rule Vault Overview

Prev Next

The Rule Vault is part of Bank Activity and houses all active and inactive bank rules, including default matching rules, user-created matching rules, and create transaction rules. Bank rules determine how R365 transactions are matched or created from imported bank activity.

When bank activity matches an existing R365 transaction, it moves to the Matched/Excluded tab. When a ‘create transaction rule’ applies, the associated activity moves to the Rule Applied tab for review.


Security

The following permissions are associated with the Rule Vault:

  • 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 → Delete Bank Rules

  • Banking → Bank Activity → Bank Rules → Activate Bank Rules


These permissions can be added to custom user roles or individual users. The Permission Access report can be used to determine which user roles or users already have these permissions assigned. For more information, see User Setup and Security.


Enable the Rule Vault

The Rule Vault is an upgraded version of the Bank Rules tab, which is removed when this feature is enabled. All existing rules live in the Rule Vault, and even though rules can still be added on the Bank Activity screen, once created, they exist in and can be accessed from the Rule Vault.

The Rule Vault is enabled on the Miscellaneous tab of System Preferences:


Rule Vault Page

The Rule Vault page is accessed from Bank Activity and contains all user-created and system generated rules.

From the Rule Vault page users can:


Rule Types and Statuses

Rule Types

The Rule Vault contains two types of rules:

  • Matching Rules: Pair imported bank activity to existing R365 transactions based on specific conditions. Matching rules can be either system-generated (default) or user-created.

  • Create Transaction Rules:

    • User-created rules that create new R365 bank transactions (deposits or expenses) based on defined conditions.

      • Cash in transactions create bank deposits.

      • Cash out transactions create bank expenses.

    • Transaction rules can apply to one or multiple bank accounts. However, because the detail location for transactions is set per rule, organizations with separate bank accounts per location should considering creating separate rules to ensure transactions are recorded accurately.

Rule Statuses

Each rule has one of two statuses:

  • Active: The rule actively matches or creates transactions based on it's conditions.

  • Inactive: The rule is disabled, and and no transactions will be created or matched, even if its conditions are met.

Learn how to update the status of a rule.


Rule Conditions

Conditions define the criteria that must be met for a rule to apply. When new bank activity is imported, R365 reviews all active rules. If the bank activity matches an active rule’s conditions, the system either creates a transaction (for create transaction rules) or matches the activity to an existing transaction (for matching rules). Criteria can be set by bank activity name, date, comment, or amount. If imported bank activity meets the rule conditions for more than one matching rule, the activity will remain in the unmatched tab with an ‘M’ in the column to the right of the location column to indicate there are multiple potential matches. If imported bank activity meets the rule conditions for more than one create transaction rule, only the first match—based on rule order—is applied.


Created Transactions

Transactions created by Create Transaction rules use the settings applied in the Create Transactions Rule record, including:

  • Transaction Type: Cash in or Cash out (bank deposit or bank expense)

  • Location: Detail location selected in the Resulting Bank Expense/Deposit section of the rule.

  • Vendor: The vendor that will be associated with the resulting bank transaction.

  • Account: The account that will be debited or credited in the bank transaction.


Reviewing Activity with Rules Applied

Create Transaction Rules

Transactions created by a create transaction rule are reviewed on the Rule Applied tab.

On this tab, users can:

  • Review the bank activity where a create transaction rule was applied

  • Add the created transaction(s) to R365

If changes to the rule are needed, the rule can be updated from the Rule Vault, and then rules can be reapplied in bank activity with the Reapply Bank Rules button.

Once the transaction is added, the bank activity moves to the Matched/Excluded tab, and the applied rule is listed in the Rule Applied column.

Matching Rules

Matching rules connect imported activity to existing transactions recorded in R365. When a matching rule is applied, the matched transaction moves from the Unmatched tab to the Matched /Excluded tab. The rule used to match the transaction is displayed in the Rule Applied column.