Mapping rules are used to automatically rename payees as well as memorize accounts when importing bank statement transactions. Additional mapping rules are built automatically as you import statements. Mapping Rules can be added, edited, or deleted if needed. 

Mapping Rules can be found in two locations:

 
  • In Accounting, within the Bank tab, click "Action/ Mapping Rules"

 
  • In the requested bank's details, within the transactions tab, "Mapping Rules" appears when a bank statement is imported.


Active - This area is checked if the rule is in effect. Rules can be made inactive when editing.

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. Add those names to this 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 as per the user's request before adding the transaction.

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.




Account (operating bank only) - account the transaction is allocated to

 

  • In the Mapping View screen, click "Add" to create a new rule.
  • You can also click a rule so it's highlighted, and click "Edit" to make adjustments to that rule, or "Delete" to remove that rule. Lastly "Delete All" removes all the rules and gives the user a clean slate to begin creating new rules.

 

  • Click "Save" once additions or changes have been made.

After saving, the rule will take effect. Rules can be adjusted before the next import (1st location above) or during an import (2nd location above).