Set up transaction templates for manual import of bank transactions

Before you manually import bank or credit card transaction files into Expense Management, you must create a transaction template. A template tells the system how to read and process the file. Each template is tied to a specific bank, and you can create multiple templates for the same bank if needed.

1. Use Search to open the Banks page.
2. Select the bank associated with the transactions you want to import, If the bank does not exist, create a new bank record by clicking on New.
3. On the action bar, select Related > Bank > Transaction Template to open the template card.
4. Configure the template settings.

Configuring the template settings

Staying within the template card, fill in the information required in the General section.

Below is an explanation of some of the fields to configure.

Data Formats: Choose the correct date and decimal formats from the available list. If the format you need isn’t listed, you can type it manually.

Enable/Disable Template Rules: You can add more rules for example, *Excluding lines containing text. *

Lines to be ignored: If your file contains header or footer lines (for example, a title line or summary totals), specify how many lines should be ignored at the beginning or end of the file.

Field Mapping: In the Field Mapping section, map each column in your file (Column No. in File) to the corresponding field in Expense Management. If your file shows credit amounts as negative values, enable reverse sign so they are imported as positive amounts in the transaction journal.