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
- From the
> Setup
menu, click Company > Credit Card Import. - Click on the row.
The information for that setting will appear on the right.
- Make changes or use the Action column to copy or delete.
- Click
to save.
Set up credit card import
- From the > Setup
menu, click Company > Credit Card Import.
- Click New.
- Enter a description
- Enter any notes
- 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. |
- 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 > |
| 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 > |
| 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 > |
| 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 > |
| 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.
- To finish adding, click to save.
