Setting up credit card import

Your bank provides you with a comma separated file (.csv) that you can import into Ajera. This is where you define the fields that appear in the .csv file and select which fields to import. The fields need to be reordered to display in the order they appear in the .csv file from the bank.

Note: It is recommended that you create separate import settings for each financial institution.

To edit or view an existing import setting

  1. From the > Setup menu, click Company > Credit Card Import.
  2. Click on the row.

The information for that setting will appear on the right.

  1. Make changes or use the Action column to copy or delete.
  2. Click to save.

Set up credit card import

  1. From the > Setup menu, click Company > Credit Card Import.
  2. Click New.
  3. Enter a description
  4. Enter any notes
  5. Under Import File Detail, enter:
Field delimiter

Select a field delimiter being used in the .csv file.

Note: For a .csv file the delimiter will be a comma (,), other fields might separate fields differently.

Text qualifier

Select a text qualifier (None, ", ').

By default, " is selected.
Decimal symbol Enter a symbol to use as a decimal.
Date delimiter

Enter a date delimiter.

By default, / is selected.

Date order

Select the order the date appears in the file.

File contains a header Check if the file contains a header.
Reverse amount sign Check if charges come through from bank as negative.
Date leading zeros Check if the date leads with zeros.
Four digit year Check to use a four digit year.
  1. Under Fields to Import, select available columns:
Date* The date of the charge.
Amount* The amount charged to the card.
Transaction ID

The ID of the transaction from the bank.

Note: You cannot have duplicate transaction IDs.
Cardholder name

The name of the cardholder.
Ignore

Allows ignore a column from the file.

For example, your bank may provide more information than you want to import.

Note: This column can be added more than once.

Merchant Description The merchant description in the file from the bank.

Notes

 Additional information from the bank that does not fit into other columns.
User Defined Field 1

Other information you want to include that the bank has provided.

This information will be available to view on widgets, in expense reports, and the bank register.

Note: These are optional columns in Credit Card Import List. To add the columns in expense reports and the bank register, click Import > and select the columns.
User Defined Field 2

Other information you want to include that the bank has provided.

This information will be available to view on widgets, in expense reports, and the bank register.

Note: These are optional columns in Credit Card Import List. To add the columns in expense reports and the bank register, click Import > and select the columns.
User Defined Field 3

Other information you want to include that the bank has provided.

This information will be available to view on widgets, in expense reports, and the bank register.

Note: These are optional columns in Credit Card Import List. To add the columns in expense reports and the bank register, click Import > and select the columns.
User Defined Field 4

Other information you want to include that the bank has provided.

This information will be available to view on widgets, in expense reports, and the bank register.

Note: These are optional columns in Credit Card Import List. To add the columns in expense reports and the bank register, click Import > and select the columns..
User Defined Field 5

Other information you want to include that the bank has provided.

This information will be available to view on widgets, in expense reports, and the bank register.

Note: These are optional columns in Credit Card Import List. To add the columns in expense reports and the bank register, click Import > and select the columns.

* Indicates the column is required and cannot be removed.

  1. To finish adding, click to save.