Install and Login to Integration App

1. Install Microsoft Access Database Engine from the location below (pre-requisite)


2. Open the Integration App. You can download the Integration app from here -                        


3. On the login screen, enter the following as the Login URL –


4. Log in to the integration app using Admin user Id and password. Select any account system radio button (For example GP 2013)

Import Credit Card Transactions

 5. Once logged in, go to File - > Import Credit Card File ->Import Amex Open Excel



 6. Go to Settings and check for Country, State and City checkboxes and then browse for the file downloaded from Make sure you download a file for a specific date range in XLS format. Click done and then click Reload.


 7. Click Select All and then Import AMEX Open XLS.



8. All selected transactions will be imported and then displayed in Green. Any transactions that fail will turn Red. Any     duplicate transactions that already exist in the system will turn Orange. On the screen below one transaction failed as it was not able to find the corresponding Employee/User in the system (the Employee Column in empty) and the second transaction (highlighted in Orange) failed as it was already imported before.



Using  below steps you can download the excel file from American Express website.