Before importing credit card transactions, a credit card must be added to the Accounts Payable application. If you have not yet added a credit card to the Accounts Payable application, see the Process a Credit Card Transaction tutorial for a complete guide on setting up, processing, and importing credit cards transactions.
This Step-by-Step tutorial guides you through importing your credit card transactions from an Excel file.
•For a visual tutorial, see the Import Credit Card Transactions video.
•All video tutorials can be viewed from the Tutorials & Videos page.
1. The first step is to log into your credit card website and download the statement that you want to import.
2. The second step is to add the column headers and other data to the Excel file as specified in the Credit Card > Transactions > Import Help page.
NOTE: The added columns and other data is highlighted in yellow on the image below.
3. Save the file as an .XLSX file format.
4. From the Accounts Payable menu, select Manage -> Unposted Credit Card Transactions.
5. Click the Search button (if the Filters appear).
6. Click the Import Credit Card Transactions link in the upper right-hand corner.
7. Click the Choose File button.
8. Navigate to your .XSLX file using the dialog box and select it.
9. Verify the correct file is displayed next to the Choose File button and then click the Import button.
10. The file is imported and displays on the grid. Review the transactions for any incorrect information.
NOTE: Click the here link to reverse the signs of the transaction amounts.
11. Click the Edit icon to make changes to an 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.
12. 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.
NOTE: Payments typically show as invalid and can be deleted since they are normally entered as an invoice.
13. After reviewing the valid and invalid transactions and making any corrections, click the Import button to finish the import process.
14. The imported transactions appear on the Credit Card > Transactions page. At this point, you can process these transactions as you normally would.