Cash Forecasting Bank Transaction Mapping Rules: Create and Edit

  • Published on Oct 6, 2026
  • 4 minute(s) read
  • Migration Team
  • RJ
 Prev Next

Import Mapping Rules

  1. From the Cash Forecasting solution, go to Treasury > Banking > Bank Accounts.

2026-08-14_08-49-02.png

  1. The Bank Accounts list screen opens.

  2. Select the Upload Bank Rules icons in the upper right corner.

2026-08-14_08-54-55 copy.png

Download and Fill Out Template

  1. Select Download A Sample File.

    2026-08-14_12-39-20.png

  2. Open the downloaded CSV template.

    2026-08-14_12-43-28.png

  3. Enter your mapping rules to replace the sample data:

    • Transaction Type: Enter Credit or Debit to indicate the transaction type to search for.

    • Line Item Name: Enter the line item name to map the matching transactions to.

    • Line Item Type: Enter Payment or Receipt to indicate how the transaction is mapped to the line item.

    • Bank Account Number: The account number of an existing bank account, to make the rule specific to that account. Leave this column blank to create a global rule that applies to all accounts.

    • Description: (Max. 255 characters) Text to look for in the statement line description. This isn’t case sensitive. Multiple spaces and line breaks are collapsed.

    • Customer Reference: (Max. 255 characters) Text to look for in the statement line's customer reference.

    • Bank Reference: (Max. 255 characters) Text to look for in the statement line's bank reference.

    • Contra Account: Counterparty account number on the statement line.

    • Contra Bank: Counterparty bank code on the statement line.

    • Bank Tran Code: (Max. 20 characters) Bank transaction code on the statement line.

    • Exclude From Forecast: Enter Yes or No to indicate whether to exclude the mapped transaction from the forecast.

    • Exact: Enter Yes or No to indicate whether the key words must be used exactly to count as a match in the search.

  4. Save your CSV file to your computer.

Upload Bank Transaction Mapping Rules

  1. Select Choose File.

  2. Navigate to and select the CSV file you saved.

  3. Select Next: Preview Accounts.

2026-08-14_13-31-42.png

  1. Review your rules. If there are any errors, you see them here.

  2. Select SAVE.

2026-08-14_13-33-14.png

Manually Create Mapping Rules

Mapping rules can be created at the individual bank account level (local rules) or for all bank transactions (global rules).

Only admin-level users can create global mapping rules. Every user can create local mapping rules for the bank accounts they have access to.

Mapping rules run in a designated order. Local rules run before global rules, and unless the order is edited, newer rules run before older rules.

  1. Open the View Bank Account screen (local mapping rules) or the All Bank Transactions screen (global mapping rules).

    1. For global mapping rules:

      1. From the Cash Forecasting solution, go to Treasury > BANKING > All Bank Transactions.

    2. For local mapping rules:

      1. From the Cash Forecasting solution, go to Treasury > BANKING > Bank Accounts.

      2. The Bank Accounts list screen opens with a list of the bank accounts in the system.

      3. Open the View Bank Accounts screen in one of the following ways:

        • Hover over the bank account, select the More icon, and then select View from the drop-down list.

        • Select the bank account name.

  2. To create mapping rules through a smart search:

    1. Enter one or more key words in the search bar.

    2. Select the New icon at the bottom left of the screen.

2026-08-14_11-56-57.png

  1. To create mapping rules using the Mapping rules widget:

    • Select the New icon from the widget on the right side of the screen.

2026-08-14_11-58-42.png

  1. The Add Mapping Rule panel slides onto the screen.

  2. Fill out the fields to create a mapping rule based on your search.

    • Select direction: Select whether to search for credit or debit transactions.

    • Select rule type: Designate the type of transactions to select.

      • Catch all: Selects all transactions based only on the selected direction.

      • Custom: Selects transactions by detecting key words in designated fields. Add additional key words if desired by filling in the field to search and the key words to search for. All additional key word search will be treated as AND statements.

        • If you are creating mapping rules from a smart search, the key words will already be populated here.

    • Make this an exact search: Select whether the key words must be used exactly to count as a match in the search.

    • Mapping options: Choose how matched transactions will be mapped.

      • Map to: Select the line item to map the matching transactions to.

      • Exclude: Do not map the matching transactions.

    • Sharing options: (only available for local rules) Select any other bank accounts to share the rule with. All bank accounts you have access to are available in the drop-down list.

      • If you edit a rule that is shared, it updates across all shared rules.

  3. Select Save.

2026-08-14_12-05-59.png

Manage Mapping Rules

  1. Open the View Bank Account screen (local mapping rules) or the All Bank Transactions screen (global mapping rules).

    1. For global mapping rules:

      1. From the Cash Forecasting solution, go to Treasury > BANKING > All Bank Transactions.

    2. For local mapping rules:

      1. From the Cash Forecasting solution, go to Treasury > BANKING > Bank Accounts.

      2. The Bank Accounts list screen opens with a list of the bank accounts in the system.

      3. Open the View Bank Accounts screen in one of the following ways:

        • Hover over the bank account, select the More icon, and then select View from the drop-down list.

        • Select the bank account name.

  2. Expand the type of mapping rules you want to review. Local rules always run before global rules.

2026-08-14_12-15-13.png

  1. The rules list will open, displaying the rules in the order they will run.

2026-08-14_12-21-05 copy.png

  1. Hover over a rule to manage the rule.

image-20250624-225751.png

Move: Opens a drop-down with options to move the rule to the top, up 1 position, down 1 position, or to the bottom.

image-20250624-225822.png

Edit: Opens the Edit Rule screen. Refer to Create mapping rules.

image-20250624-225858.png

Delete: Deletes the rule.

2026-08-14_12-21-05.png

Rule Ordering

  1. Review the order of your mapping rules.

    • Account-specific rules run before global rules.

    • The more specific a rule is, the earlier it should run.

    • General rules run after specific rules, with catch-all rules running last.

  2. Move rules as needed to optimize the order.

View Rules Applied to Transactions

  1. Open the bank transactions:

    • For all bank transactions, go to Treasury > BANKING > All Bank Transactions.

      1. The All Bank Transactions screen opens with a list of the transactions.

    • For transactions by bank account, go to Treasury > BANKING > Bank Accounts.

      1. The Bank Accounts screen opens with a list of the bank accounts.

      2. Select an account to to open the account’s list of transactions.

2026-08-14_12-27-13.png

  1. Hover over a transaction.

  2. Select See more, which appears under the date.

2026-08-14_12-30-04.png

  1. The transaction expands to show the mapping rules that were applied, if applicable.

2026-08-14_12-31-26.png

Copyright 2026 Ripple Labs Inc.

Related articles