Scheduling a Recurring Payment Settlement File Export

Corpay Complete streamlines payment reconciliation by enabling organizations to create and export customized payment settlement files with the File Outbound feature. This functionality lets users 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 schedule a recurring export of a payment settlement file.

Refer to the Exporting a Payment Settlement File article to learn how to export a one-time 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 schedule a recurring outbound settlement file:

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

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

4. Click the Recurring File Outbound tab on the File Outbound page.

5. Click Schedule Recurring File Outbound.

6. Complete the following steps on the Create Scheduled 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. From the Frequency drop-down, select a frequency: Daily, Weekly, or Monthly.
   4. Select the Deliver On drop-down to choose the day of the week, day of the month, or time of day for the recurring outbound settlement file. If you select a Monthly frequency, select the optional End of month? checkbox to deliver the settlement file at the end of the month.
   5. From the Export Format drop-down, select an export format: XLSX or CSV.
   6. Choose a date range for the settlement export from the Schedule Date Range drop-down.

      

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

      Note: The default value for this field is All.

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

      Note: The default value for this field is All.

   9. 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.
   10. To include or exclude a description of the payment settlement file in the column header, check or uncheck the Exclude Column Header Descriptions box.
   11. Click Create to create and schedule the recurring file outbound.

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

8. The outbound payment settlement file will appear on the Recurring File Outbound grid.

9. When the Status is Completed, retrieve the payment settlement file from the Existing File Outbound tab using one of these 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.

10. To modify the recurring file outbound, select the Edit  icon in the Actions column on the Recurring File Outbound tab.