Exporting Declined Transaction Data

You can export single-day transaction-level data to a CSV file (e.g., Microsoft Excel) for each category of Declined Transaction in the report by clicking the CSV Export icon () in the desired field. If the option to export is available, the CSV Export icon is available and active (not grayed-out). Transaction-level data is available for export for the previous 24 months only.

To export transaction-level data from the Declined Transaction report:

From the iQ Bar, click the Operations icon and select Declined Transaction Summary from the list of available reports, or from the Operations Navigation bar. The Declined Transactions report appears.
Select the desired Date Range and click View to refresh the page.
Click the CSV export icon () next to the declined transaction count in the desired field. Click the export icon in the Total Transactions field for all declined transactions.
If the CSV export icon is grayed-out, adjust your date range for a single day no earlier than 24 months prior to today. Depending upon your browser, the File Download dialog box may appear.
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 files.

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

Declined Transactions Export Field Descriptions
Field	Description
Worldpay Payment ID	The unique identifier automatically assigned by Worldpay for this transaction.
Batch ID	The unique identifier automatically assigned by Worldpay for the batch associated with this transaction.
Session ID	The unique identifier automatically assigned by Worldpay for the session associated with this transaction.
Txn Type	The type of transaction you were attempting to perform (e.g., deposit, refund, etc.).
Merchant ID	The unique identifier automatically assigned by Worldpay.
Response Reason Code	The three-digit transaction response code returned by Worldpay for this declined transaction.
Response Reason Message	The transaction response message returned by Worldpay for this declined transaction.
Organization ID	The unique identifier for your organization.
Category ID	The Worldpay-generated identifier for the Reporting Group.
Reject Type	The reason the transaction was rejected (Real-time Decline, Tied Decline, or Duplicate).
Dupe_Txn_ID	The transaction ID of the original transaction, if this a duplicate.
Amount	The total dollar amount of the transaction.
Purchase Currency	The currency used for the purchase, designated by the three-letter abbreviation of the currency (e.g., USD, EUR, CAD).
Post Day	The date the funds from the original transaction appeared as accepted, or recognized.
Reported Time stamp	The date and time of the declined or rejected transaction was processed by Worldpay.
Payment Type	The method of payment (VI=Visa, MC=Mastercard, etc.) for this transaction.
Reporting Group	The Reporting Group category to which this transaction belongs.
Merchant Order	The unique identifier specified by your organization. Typically, this is the order number.
Merchant_TXN_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.