Exporting Transaction-Level Recovered Orders

You can export a report in CSV format that provides transaction-level data on recovered orders (31 days maximum) that were approved. If you require more than 31 days of data, you must export separate reports in 31-day increments. Transaction-level data is available for any 31-day period in the previous 24 months.

To export the Transaction-Level Recovered Orders report:

  1. From the iQ Bar, click the Approvals icon and select Recovery Snapshot from the list of available reports, or from the Approvals Navigation bar.

  2. Specify the desired Date Range (31 days maximum) and Reporting Group, then click View to refresh the page.

    See Notes on Reporting Group Limits for information on the report groups shown in the Reporting Group drop-down selector.

  3. Click the CSV Export icon () next to the count in the Recovery Orders - Approved during Period field. If the CSV export icon is grayed-out, adjust your date range for a start date no earlier than 24 months prior to today.

    The File Download dialog box appears.

  4. Choose an option as follows:

    • Open - opens the report in your default spreadsheet application (e.g., Microsoft Excel).

    • Save - saves the CSV file to your computer.

    • Cancel

The data listed in the table below are included in the report.

See Notes on Microsoft Excel for information on the presentation of certain data fields in exported files.

Transaction-Level Recovered Orders Report Field Descriptions

Field

Description

Payment ID

The automatically-assigned unique identifier for this transaction.

Merchant Transaction ID

The identifier specified by the merchant for this transaction. This value corresponds to the id attribute (id="value") of the transaction and is used with Online transactions for Duplicate Transaction Detection.

Recycle ID

The identifier specified by the merchant to track recycling for this transaction as part of the transaction signature.

Auth Approval Date

The date the recovered order was approved.

Merchant Order Number

The merchant-designated identifier for this transaction.

Expected Settlement Amount (USD)

The net settlement amount in US Dollars that is expected to be transferred to your organization’s bank account for this transaction.