Skip to main content

Bank Rules and Suggestions

Create automation in bank transaction coding to journal entries through rules and AI suggestions

Travis Lander avatar
Written by Travis Lander
Updated this week

Overview

Add automation to your bank account processing through Rules and Suggestions in coding bank transactions into journal entries. Rules will take details from the bank transaction such as description and category to create criteria that when met, can create a journal entry with the corresponding ledger account and dimensions (e.g. vendor, cost center, etc.). Suggestions are derived from AI reviewing the transaction to suggest the creation of a Rule or Suggestions per bank transaction. For both Rules and Suggestions, the proposed coding to journal entries will appear in columns alongside the bank transaction for review by users to be confirmed before journal entry creation.

Bank Rules

Bank Rules provide automation to automatically pick up inputs from bank transaction details to suggest journal creation with specific dimensions (ledger accounts, cost center, vendor, etc.).

Rules are most effective for:

  • Recurring transactions

  • Transactions that occur frequently

  • Transactions with similar names/descriptions

  • Transactions with similar merchant names

  • Transactions with similar categories

Add a Bank Rule

Bank Rules can be added at the top of the table of bank transactions for any bank account, within the Bank Detail page, or deliberately on the Bank Rules tab at top of the Bank Accounts tab.

When creating a Rule, see the below requirements to add a 1) Bank Rule name, 2) Selection of Bank Account, 3) Match Criteria for what details from Bank Transaction trigger a Rule, and 4) Dimension Settings for coding t0 the journal entry:

Rule Form

Convert Table Filters into Rules

When filtering on the bank transactions table, click the "Add Rule" button to prompt the filters in place on the table automatically into a new Rule. For example, if the below filters are in place:

Filters Applied

And user clicks +Create Rule:

Create Rules

The Create Rule form will open with the filters auto-populated:

Rule Form

Submit the Rule with at minimum a Rule Name and a selected Ledger Account to complete the Rule creation process.

Determine Fields Available for Rules

For each Bank Account, control the available Dimensions that can be coded under the Configure Dimension Settings (default set to Ledger Account, Customer, and Vendor). This is where it can be determined what fields should be included with Rules or Suggested from AI for the eventual journal entry:

Details for Rule Creation

  • Type

    • Global

      • Applies to all bank accounts

      • Priority is determined by the order of creation where the last created rule has the highest priority

      • Has a lower priority than account-specific Rules

    • Account-Specific

      • Applies to a specific bank account

      • Priority is adjustable

      • Has a higher priority than global Rules

  • Criteria

    • Fields from Bank Transaction

      • Full Description

      • Merchant Name

      • Category

  • Dimensions available for Journal Entry

    • Ledger Account

    • Vendor

    • Customer

    • Cost Center

    • Product

    • Job

    • Custom1

    • Custom2

    • Custom3

Adjust Rule Priorities

Rules are listed in order of priority and the list allows for reordering using the drag and drop mechanism. When processing transactions per Bank Account, the higher priority Rules will be tried before lower priority Rules:

Rule Priority Drag

Note: Rule Priority adjustment is only possible per Bank Account Rules pages for Account-Specific Rules. Account-Specific Rules are ALL higher priority than Global Rules.

Rule Actions

Per Rule Actions in Table

Edit, Copy, and Delete Rules from the Actions menu next to Rules:

Rule Menu List

Bulk Rule Actions

Update Rule Dimensions and Delete Rules in bulk:

Rule Bulk Actions

Bank Suggestions

Once Rules have been processed, any bank transaction without an associated journal entry will run through an LLM (large language model) to make the best suggestion for the inputs to a journal entry from the bank transaction. Just like Rules, Suggestions are prompted whenever new bank transactions are added to a bank account, whether from an automatic sync or excel upload.

Note: To disable Classification Suggestions for a Bank Account, disable the Ledger Account selection as an option under the Dimension Settings.

The inputs for the journal entry are controlled under the Dimension Settings for each bank account, and the options for classification are:

  • Ledger Account

  • Vendor

  • Customer

  • Cost Center

  • Job

  • Product

  • Custom Dimension 1

  • Custom Dimension 2

  • Custom Dimension 3

You can see the inputs from both Rules and Suggestions in the same place, the specific classification columns at right of the bank transaction information:

Columns

Note: Rules are displayed with a green icon and Suggestions are displayed with a yellow icon.

Creating Journals

To create journal entries based off the classifications from both Rules and Suggestions, a new bulk action to "Process Suggested" is added that can be used to create journals for the selected transactions when selecting checkboxes at left of all bank transactions.

Bulk Action

Bulk Action Content

Users can choose to manually reconcile the transactions and not use the suggested classifications, and create through single journal entry creation, or bulk creation processes and ignoring Suggestions.

Details on Classifications

The suggested Classifications will be added to any bank transaction without a journal entry already associated, and can be edited before eventual journal entry creation. Overall, all Rules take priority for classification before any Suggestion.

Rules that create classifications can be revealed when hovering over the Rule classifications:

Rule

And the Suggestions can be seen when hovering as well:

LLM

The inputs from classifications can be edited by double clicking per dimension within the bank transactions table:

Manual Edit
Did this answer your question?