Credit Card Transactions > Import

The Credit Card Transaction Import reads an Excel file that you specify and then imports each row of that file as credit card transactions.

NOTE: This option can also be accessed from Utilities > Import Credit Transactions.

Up to 13 columns of information can be imported. The order of these columns does not matter, but the first field in each column must contain the descriptions listed below. Some columns accept alternate labels for the column header. The alternate header names are indicated in the parenthesis. Required columns are indicated with an asterisk(*).

Date*

Amount (Split Amount)*

Vendor (Merchant, Description)*

RegionNumber*

SuperFundNumber*

FundNumber*

LocationNumber*

CostCenterNumber*

DepartmentNumber*

AccountNumber (Expense)*

AccountSub*

DetailDescription

Project

Note (Notes)

CreditCardUser

Ref#

Invoice#

1099

NOTE: The header names are case-sensitive (e.g., “date” or “DATE” will not work, must be “Date”).

Only the account structure levels that you are using need to be specified. For example, if you are only using funds and department in your chart of accounts, then you only need to specify "FundNumber" and "DepartmentNumber" columns in your Excel file. Also, the AccountSub field only needs to be specified if you are using Sub Accounts.

The CreditCardUser column in Excel should be formatted in one of the following ways, omitting Titles, Middle Names, and Suffixes:

•[First Name]  [Last Name]

•[Salutation]   [Last Name]

•[Last Name], [First Name]

•[Last Name], [Salutation]

An example file is displayed below.

 

Steps to Import the Credit Card File

 

1.          From the Accounts Payable menu, select Manage -> Unposted Credit Card Transactions.

2.          Enter any filters to narrow the number of transactions that display on the grid and then click the Search button.

3.          Click the Import Credit Card Transactions link in the upper right-hand corner.

4.          The first step is to select a file. Click the Choose File button and then select your import file using the dialog box that appears.

5.          Confirm the filename is correct and then click the Import button.

6.          The file is imported and displays as a grid. Review the transactions for any incorrect information.

NOTE: Click the here link to reverse the signs for the transaction amounts.

7.          Click the Edit  icon to make changes to individual transaction or click the Delete  icon to delete a transaction. These changes do not affect the original Excel file that was used for importing.

8.          Another option is to click the Clear Credit Card Transaction Import button to clear all the transactions, and then make corrections in the Excel file. After making corrections to the Excel file, select to import the file again.

9.          Invalid transactions can be viewed by clicking the View Invalid radio button. Invalid transactions occur when the information from the Excel file does not match with the fields in your Financials program. Other invalid transactions may include payments, which are normally entered on the Transactions > Update page. After an invalid transaction has been corrected, it appears as a valid transaction to be imported.

10.          After reviewing the valid and invalid transactions and making any corrections, click the Import button to finish the import process.

11.          The imported transactions appear on the Credit Card > Transactions page. At this point, you can process these transactions as you normally would.