1. Home
  2. Accounting
  3. Banking
  4. Managing Transactions
  5. Mapping Rules for Importing Bank Transactions

Mapping Rules for Importing Bank Transactions

Introduction

Mapping rules are used to automatically rename payees as well as memorize accounts when importing bank statement transactions. They can be created and made active automatically as you import statements, but they can also be manually added, edited, or deleted if needed. 

Locate Mapping Rules

Mapping Rules can be found in two locations.

Bank

Each bank [account] has its own set of mapping rules. There may be a mapping rule to automatically rename a payee under one bank account, but maybe not another. You may want to review or manage individual bank account’s rules to ensure they are correct.

To view a bank account’s mapping rules:

1. Click on the Accounting Tab

2. From the Bank Tab, click to select the desired bank

3. Click Action > Click Mapping Rules

Bank Statement Import

You can also see mapping rules while importing bank or credit card transactions.

When Mapping Rules are selected in the import screen, you will see a button that says Save/Apply Mapping Profile. The ‘mapping profile’ refers to the set of Mapping Rules you are about to apply.

To view mapping rules from this screen, follow the instructions to import transactions, and click on  Payee Mapping Rules on the import screen. 

Understanding Mapping Rules Screen

After clicking on Mapping Rules, you’ll be taken to a list of existing Mapping Rules.

Here you can Add, Edit existing rules, or Delete. If you add a rule, after saving, the rule will take effect automatically. Rules can be adjusted before the next import (in the Bank Section) or during an import (in the Import Transactions Screen).

See below for a list of fields in the Mapping Rules ‘Edit Mapping’ Screen.

Active – This box is checked if the rule is in effect. Rules can be made inactive when editing by unchecking this box.

Rule Type – gives 2 types: “Mapping” means the rule has already been used to map previous transactions and will be used again when more transactions of this type are imported. “Exclusion” is used to block a certain statement payee name from automatically becoming a mapping rule. 

Statement Payee Name – name of payee on imported statement

Payee Name – name of the payee that will be used once the transaction is imported. This can be changed by the user before adding the transaction from import.

Matching Rule – gives 3 options: “Equals To” means the statement payee name and payee name are an exact match. “Contains” means both the statement payee name and payee name contains similar information. “Starts With” means the statement payee name begins with the same information as the payee name.

 
Default Account (operating bank only) – account the transaction is allocated to 
Updated on August 13, 2018

Was this article helpful?

Related Articles

Need Support?
Can't find the answer you're looking for? Don't worry we're here to help!
CONTACT SUPPORT
X
X