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 or receiving them through the bank feed. They can be created and made active automatically as you import statements or receive transactions through the bank feed, but they can also be manually added, edited, or deleted if needed. 

Locate Mapping Rules

Mapping Rules can be found in three 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 or Bank Feed

You can also see mapping rules while importing bank or credit card transactions or receiving them through the Bank Feed.

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) – General Ledger account the transaction is allocated to

To Add a Mapping Rule

  1. From the Mapping View screen, click Add.image2
  2. This opens the Add Mapping screen.
  3. First you will choose the Rule Type, Mapping or Exclusion.
  4. If you choose Mapping, you will then choose the Mapping Rule, which is the same as the Matching Rule described above.image3
  5. Add the Statement Payee Name.
  6. Add the Payee Name.
  7. Select the default General Ledger account.
  8. Click Save.
  9. If you chose Exclusion in the Rule Type, you will just have to add Statement Payee, then click Save.

To Edit a Mapping Rule

  1. From the Mapping View screen, select the Mapping Rule you wish to edit by single-clicking on it to highlight in blue.image4
  2. Then click the Edit button.
  3. Follow steps 3-9 from the Add a Mapping Rule instructions.
Updated on June 10, 2019

Was this article helpful?

Related Articles

Contact Our Support Team
Can’t find the answer you’re looking for? Don’t worry we’re here to help!
Submit a Ticket
X
X