Automatically Rename Imported Bank Transactions (Mapping Rules)

You can create mapping rules to automatically rename payees and memorize accounts when importing bank statement transactions or receiving them through the bank feed.
Mapping rules are automatically created and activated as you import a statement or receive a bank feed, but you can also manually add, edit, or delete a mapping rule as needed.

Note: Mapping rules apply across the account type. For example, adding, editing, or deleting a mapping rule for one operating account applies the rule to all operating accounts.

View Mapping Rules

You can view mapping rules from three locations:

Bank screen	When you create or edit a bank
Bank Statement Import screen	While importing bank and credit card transactions
Bank Feed	When receiving transactions through a bank feed

Mapping View Screen Field Definitions

Active (first unlabeled column)	A check mark in this field indicates the mapping rule is in effect. You can edit the rule mapping to uncheck the Active box and deactivate the rule.
Rule Type	Mapping means the rule has been used to map previous transactions and will be used again when your firm imports more transactions of this type. Exclusion means the rule blocks a certain statement payee name from automatically becoming a mapping rule.
Statement Payee Name	Payee Name on imported statement
Payee Name	Payee Name to use once your firm imports the transaction User can edit before adding the transaction from the import file or feed
Matching Rule	Equals To means the Statement Payee Name and Payee Name are an exact match. Contains means the Statement Payee Name and Payee Name contain similar information. Starts With means the Statement Payee Name begins with the same information as the Payee Name.

Add a Mapping Rule

To add a mapping rule:

From the left navigation panel, click Banking.
Single-click the bank, click on the three dots at the end of the row and from the drop-down, select Mapping Rules.
The Mapping Rules screen opens, displaying a toolbar atop the mapping rules listing.
From the toolbar, click Add Mapping.
The Add Mapping screen opens.
In the Rule Type section, click the Mapping Rule or Exclusion Rule radio button as desired.
Note: If you click Exclusion, you must only complete steps 7 & 8.
From the Mapping Rule field’s drop down, click Contains, Equals To or Starts With as desired.
In the Statement Payee field, enter the payee name as it appears on the imported statement or bank feed.
In the Payee Name field, enter the payee name as you want it to appear on your reconciliation statements.
From the Account field’s drop-down, select an account if desired.
In the Description field, you can enter a description or leave it blank.
In the upper right corner, click Save.
The system adds the mapping rule to the listing.

Edit a Mapping Rule

To edit a mapping rule:

From the left navigation panel, click Banking.
Single-click the bank, click on the three dots at the end of the row and from the drop-down, select Mapping Rules.
On the Mapping Rules screen, select the mapping rule and click on the three dots at the end of the row and from the drop-down, click Edit.
The Edit Mapping screen opens.
Make your edits.
In the upper right corner, click Save.
The system saves your mapping rule updates.

Delete a Mapping Rule

To delete a mapping rule:

From the left navigation panel, click Banking.
Single-click the bank, click on the three dots at the end of the row and from the drop-down, select Mapping Rules.
On the Mapping Rules screen, select the mapping rule and click on the three dots at the end of the row and from the drop-down, click Delete.
The Delete Mapping message reads: Are you sure you want to delete this mapping item?
Click Delete.
The system deletes the mapping rule.

Deactivate a Mapping Rule

To deactivate a mapping rule:

From the left navigation panel, click Banking.
Single-click the bank, click on the three dots at the end of the row and from the drop-down, select Mapping Rules.
On the Mapping Rules screen, select the mapping rule and click on the three dots at the end of the row and from the drop-down, click Edit.
The Edit Mapping screen opens.
Toward the lower left corner, uncheck the Active checkbox.
In the upper right corner, click Save.
The system deactivates the mapping rule.

UpdatedJanuary 7, 2025

In This Article…

Need Support?