Credit Card Imports

The credit card importer provides a fast way to upload a large number of expenses from a company credit card statement to CCC Expenses.

Importing Credit Card Transactions

1. The transactions first must be saved as a CSV file. The CSV file should have the following data in the following columns:

Column	Data	Description
A	Account Name	The name of the account holder.
B	Account Number	The credit card number (this will be masked in CCC).
C	Transaction Date	The date of the transaction.
D	Reference Number	Enter a unique reference number for the transaction. If the reference number is not unique, the transaction will be marked as a duplicate and you will not be able to process it.
E	Merchant	The person or business with which the expense was incurred.
F	Amount	The total value of the transaction.
G	Tax Amount	The tax amount of the transaction.
H	Description	A description of the expense.
I	Posting Date	The date on which the transaction was received to the account.

2. On the Credit Card Transactions screen, click the button. Alternatively, click the > button next to Credit Card Imports on the left-hand menu, then click Credit Card Importer. This opens the Credit card Transaction import window.

3. Select the company of the account holder and the payment method from the drop-down lists, then enter a description for the batch of expenses. Note that the payment method cannot be edited later for expense items generated by credit card imports.
4. Click to open the Expenses Credit Card Transactions window.

5. Click the dark area to open File Explorer, then locate the CSV file and open it or drag and drop it to the import window. The data will then appear in a grid.

6. If the first row in the CSV file contains column headings, tick the “first row is title” tick box to ignore the first row of data.
7. If there are problems detected with the alignment of the data, click the button and the system will attempt to match the labels in the CSV to the expected columns. Click the Reset button to undo Auto Align.
8. The default date format is YYYY/MM/DD. If the dates in the CSV are of a different format, select the correct one from the drop-down list below the field.

9. Click to import the CSV. If successful, you will receive a completion message and the transactions will now be visible on the Credit Card Transactions screen.