Exporting a Payment Settlement File

Corpay Complete streamlines payment reconciliation by enabling organizations to create and export customized payment settlement files with the File Outbound feature. This functionality enables users to quickly export payment settlement files either as a one-time action or on a recurring schedule at designated times. In this article, you will learn how to export a one-time payment settlement file.

Refer to the Scheduling a Recurring Payment Settlement File Export article to learn how to export a recurring payment settlement file.

Prerequisites

Before creating an outbound payment settlement file, a payment settlement template must be configured for your company

Note: Your access to pages and information in Corpay Complete depends on your role and company settings. Some content might be hidden or view-only.

To generate a one-time payment settlement file export:

1. Log in to Corpay Complete.
2. Select the Reports module from the left-side navigation pane.

3. Select the File Outbound tab on the Reports page.

4. Ensure the Existing File Outbound tab is selected on the File Outbound page.

5. Click Create New File Outbound button.

6. Complete the following steps on the Create File Outbound dialog:
   1. Select Payment Report from the Report Type drop-down.
   2. Select the payment settlement file from the Export Type drop-down.
   3. Select an export format from the Export Format drop-down: CSV or XLSX.
   4. Use the Date Picker  in the From Settlement Date field to enter a start date for the settlement file.
   5. Use the Date Picker in the To Settlement Date field to enter an end date for the settlement file.

      

   6. Select a subsidiary from the Subsidiary drop-down.

      Note: The default value for this field is All.

   7. Select a location from the Location drop-down.

      Note: The default value for this field is All.

   8. Select a destination for the file outbound from the Export Destination drop-down:
      • download: If download is selected, the payment settlement file will download to your web downloads folder.
      • email: If email is selected, a Deliver Report to these E-mails field will display. The payment settlement file will be emailed to the email address(es) in the Deliver Report to these E-mails field.
      • sftp: Select sftp (secure file-transfer protocol) if valid integration setting for file transfers have been configured.
   9. To include or exclude a description of the payment settlement file in the column header, check or uncheck the Exclude Column Header Descriptions box.
   10. Click Create to create the payment settlement file export.

7. A confirmation dialog will display, and you will be directed back to the Existing File Outbound page.

8. The payment settlement file will begin generating. This process can take anywhere from one to ten minutes depending on the account and the amount of data in the filters.

9. When the Status is Completed, the payment settlement file can be retrieved using one of the following methods:

   Note: The retrieval method for the payment settlement file depends on the value in the Export Destination drop-down.

   • If you chose download, click the download  icon on the Existing File Outbound page. On the Data Extracts [Number: Name] dialog, click Download to download the file to your downloads folder.

     

     

   • If you chose email, the payment settlement file will be delivered to the email address(es) in the Deliver Report to these E-mails field.
   • If you chose sftp, the payment settlement file will be available on your SFTP server.