Uploading a File
To access File Upload, go to Create & Manage Payments > File Upload, then
1 Under File Location, click Browse to select the file you want to upload, and click Open.
-
2Select the mapping that relates to this file from the Mapping Name drop-down menu.
-
3Choose how you want to pay from the Settlement Method drop-down menu. If applicable, select the appropriate Account Number. For all other settlement methods, click the Pay to American Express button to view receiving bank information.
-
4 If you wish to check that your file contains all the relevant information before processing, click Check File.
-
5Once you are ready, click Process File.
-
6If successful, you will see a green success message confirming that your transactions have been imported. From here, you can go to Approve a Payment or go to Batch Management to quote the transactions. To start the process again, click Upload Another File. For more details, view the Batch Management or Approving a Payment tutorials.
File Mappings
In File Mappings, you can Delete or Modify an Existing Mapping, or Create a New Mapping. Please note, the File Mapping should be set up before attempting any upload. Depending on what you require, please follow the steps below.
Modifying or Deleting an Existing Mapping
You must enter the information for the payee receiving the payment. To do so, either Select from Existing Payee List or Create a New Payee.
All your current mappings will be displayed by Name, Date Format, Delimiter, Creator, and Creation Date.
To delete a current mapping, check the appropriate box and click Delete Mapping in the lower right of the page. Alternatively, if you want to delete all current mappings, check Select All.
To modify a current mapping, click on the appropriate Name. The details of that mapping will then be displayed. The Continue or Back button can be clicked to proceed to the next screen or go back to the previous page.
New Mappings
Follow the steps below to create a new mapping:
1Click Create Mapping in the lower right of the page.
-
2Enter your preferred Mapping Name in the provided field.
-
3Select the File Type and Date Format.
-
4Click Continue to proceed.
-
5You will then be required to Set up a New Mapping. This screen will list the various payment details that can be uploaded into a new mapping.
-
6Select the Delimiter Type for your mapping from the drop-down menu.
-
7Enter the field position in the provided fields. Non-mandatory fields can be left blank.
-
8Once you have finished entering your field positions, click Create Mapping in the lower right of the page. If successful, you will see a message confirming that your new mapping has been successfully created.
Processed File Status
The Processed File Status section lists the files that have been uploaded and processed. If there are errors with your files, you can view the details and correct them where necessary. If there are no errors with your file, payments will appear in Batch Management where they can be quoted. For more details, view the Batch Management tutorial.
Helpful Tips
-
Your processed files will be displayed by File Name, File Mapping Name, File Location, and Creation Date. The File Status column will indicate whether the file processing was successful.
-
You can click on a File Name to view the details of any errors. The rows that contain errors will be displayed. You can Delete or Repair them by clicking the appropriate button. From here, you can also go to Approve a Payment or to Batch Management to quote the transactions. For more details, view the Batch Management or Approving a Payment tutorials.
-
To start the process again, click Upload Another File.
Error Details
If there is an error indicated in the File Status column, a description is shown detailing the errors for each piece of information from your file. You can use this information to amend the original file that was uploaded, or you can directly correct the errors from this page. Once you have finished, click the Submit Changes button in the lower right of the page. You will then see a message showing the status of your uploaded payments.
Checked File Status
The Checked File Status section lists the files that have been uploaded and checked. If there are errors with your files, you can view the details. This will help you correct the original file that was uploaded.
Helpful Tips
-
Your uploaded files will be displayed by File Name, File Mapping Name, File Location, and Creation Date.
-
The File Status column will display whether the file check is complete or still processing.
-
If there are errors with your file, you can click on the File Name to view details of the errors.
Check File Upload
By clicking on the File Name, you can Check a File Upload.
Error Details
Once you’ve clicked on the appropriate File Row ID, a new window will open. An error description column will detail the individual errors for each piece of information from your file. This information can then help you amend the original file.
Related Tutorials
↑ Back to topIf you have information on your business, payment needs and bank details at hand, you can go straight to our online application.
Copyright © 2018 American Express Company. Users of this site agree to be bound by American Express Web Site Rules and Regulations. American Express International, Inc.(UEN S68FC1878J), Incorporated with limited liability in the state of Delaware, USA with a place of business at 10 Marina Boulevard #15-00, Marina Bay Financial Centre Tower 2, Singapore 018983.