Setting up Transaction Templates

Before importing bank transactions from your bank into Expense Management, you need to set up a transaction template. Each template is associated with a bank, and it’s possible to have multiple templates for the same bank. Each template includes several rules and configurations, and they determine how bank transaction files are processed.

To set up a new transaction template, follow these steps:

  1. Choose the Search icon, enter Banks, and then choose the related link.
  2. Choose a bank on the list. If you can't find the bank from which you want to import the transactions on the list, you need to create a new bank.
  3. On the action tab, select Navigate > Bank > Transaction Template. You may have to select More options for the Navigate action to be displayed.
  4. In the General FastTab, fill out the information as required.
  5. In Data Formats, you choose between several predefined data formats via lookup. If the required date or decimal format is not defined in the lookup list, it's possible to enter one directly via free text.
  6. In the Lines to be ignored fields, you can determine if certain lines at the beginning or end of the file should be ignored during import, such as lines containing header information.
  7. Additional settings may be added by selecting Enable/Disable Template Rules.
    • If the credit card number is specified in the file name, and not in the transaction itself, enabling Card number in file name will extract the credit card number from the file name using Card number start position and Card number length.
    • In Line Rules, you have the option of excluding lines from the file, for example lines containing the word "Total", resulting in these specific lines not being imported.
  8. The Field Mapping section contains the actual mapping from COLUMN NO. IN FILE to MAP TO FIELD. If a file contains negative amounts, you will have to manually enable Reverse sign, as credit transactions should be imported into the transaction journal as positive amounts.