Rule Vault Page

Prev Next

The Rule Vault houses bank rules. Bank rules determine how R365 transactions are matched or created from bank activity. There are two type of rules: create transaction rules and matching rules.

Create Transaction rules are user-created rules that have set conditions that need to be met in order for bank activity to create a transaction - either a bank deposit or a bank expense. The type of transaction created is dependent on the bank activity transaction type; cash out transactions produce bank expenses and cash in transactions produce bank deposits.

Matching rules contain conditions that need to be met in order for bank activity to match an R365 transaction. Matching rules can be system-created or user-created. System created matching rules are active by default, but can be inactivated.

From the Rule Vault page, users can perform the following actions:

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.


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


Navigation

  1. In the top ribbon of the Accounting module, hover over Banking and select Get Bank Activity. The Bank Activity page opens.

  2. In the top ribbon of the Bank Activity screen, select Rule Vault. The Rule Vault opens in a new window.


Rule Vault

Buttons and Fields


Button/Field

Description

1

New Rule

Opens the new rule menu with the following options:

2

Search

Filters the rule vault grid to the entered text.

3

Table Views

Opens a list of the following options:

  • Save Current View: Saves the current view as a dropdown option for future use.

  • Edit Table Views: Displays a list of custom views that can be edited or deleted.

  • Previously created views: Views that were previously saved are displayed for selection.

4

Filter

Opens the Filter Columns window where users can create and apply filters to the table. 

5

Columns

Opens the column menu where users can show/hide and rearrange columns.

Columns

Click the column header to sort the table by the selected column.

Button/Field

Description

Selector Column

Selects the rule for editing and opens the bulk edit menu with the following options:

  • Assign Bank Account(s): Opens a window where the bank accounts the rule is applied to can be updated.

  • Assign GL Accounts: Opens a window where the GL account for create transaction rules can be updated.

  • Mark Active: Marks the rule(s) active to allow the rule to be applied to imported bank activity when conditions are met.

    • Create Transaction Rules cannot be marked as 'Active' if they have a remaining distribution amount.

  • Mark Inactive: Marks the rule(s) inactive and prevents the rule from being applied to imported bank activity.

  • Delete: Deletes the selected rules. This action cannot be undone.

  • Copy: Creates a duplicate of the selected rule with the same status as the original. This option is only available when one user-created rule is selected.

Number

The identification number assigned to the rule upon creation.

This number auto-increments and cannot be edited.

Name

User-created rule name.

System created rules have system-generated names and are not editable.

Rule Type

Indicates the type of rule:

  • Match(R365): System generated rule that sets the conditions required for R365 transactions to match to bank activity.  

  • Match: User-created matching rule that sets the conditions required for R365 transactions to match to bank activity.

  • Create: Create Transaction rule that creates a bank deposit or bank expense depending on the transaction type.

Bank Account

The bank account (s) the bank rule applies to.
The rule is only applied to bank activity imported to the selected bank accounts.

Vendor

The vendor assigned to the bank transaction created by the rule.

Location

The location assigned to the bank transaction created by the rule.

Account

The GL Account(s) that will be used for the resulting bank transaction.

Transaction Type

The type of bank activity the rule applies to:

  • Cash In: Funds coming in to the bank account; results in a bank deposit.

  • Cash Out: Funds leaving the bank account; results in a bank expense.

Status

Indicates the active status of the bank rule:

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

Description

The description for the bank rule.

This field is optional.

Created By

The user who created the bank rule.

Default matching rules (system-generated) are listed as created by R365.

Created On

The date the bank rule was made.