Exporting Transaction-Level Repaired Auths

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

To Export the Transaction-Level Repaired Auths Report:

From the iQ Bar, click the Approvals icon and select AU Repair from the list of available reports, or from the Approvals Navigation bar.
Specify the desired Date Range (seven days maximum), Reporting Group, and Currency (if applicable), then click the View button to refresh the page.
Click the Export icon () next to the Repaired Auths count in the Repaired Auths 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.
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 file.

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

Transaction-Level Repaired Auths Field Descriptions
Field	Description
Payment ID	The automatically-assigned unique identifier for this transaction.
Repair Activity Date	The date the repair activity was performed.
Merchant Order Number	The merchant-designated identifier for this financial transaction.
Amount	The amount of the repaired transaction.
Response Reason Message	The transaction response returned by Worldpay. If the transaction was declined, this message will provide a reason.
BIN	The Bank Identification Number (BIN) of the issuing bank for this credit card.
Old Card Suffix	The last four digits of the original credit card used in the transaction.
Old Expiry	The expiration date of the original credit card used in the transaction.