Exporting Returned Payments Data

You can export data on Returned Payments from the Reconciliation Dashboard. The data is listed by transaction or group of transactions and exported to a comma separated value (csv) format file. Transaction-level data is available for export for the previous 24 months only. If the option to export is available, a CSV export icon () appears as active (not grayed-out) next to the values in the Returned Payments column of the following data panels:

To export Chargeback, Direct Debit (eCheck) Return and PINless Debit Adjustment data from the Reconciliation Dashboard:

From the iQ Bar, click the Financial icon and select Reconciliation Dashboard from the list of available reports, or from the Financial Navigation bar.
Select the desired view, either by Settlement Date or Activity Date.
Specify the desired Date, Reporting Group, and Currency and click View to refresh the page.
Click the CSV export icon () next to a value in the Returned Payments column. If the CSV export icon is grayed-out, adjust your date range for a start date no earlier than 24 months prior to today.

Depending upon your browser, 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.

Returned Payments Report Export Field Descriptions
Field	Description
Case ID	The unique ID number automatically assigned to each chargeback or retrieval request, the return ID for a Direct Debit return, or the Adjustment ID for a PINless Debit Adjustment.
Worldpay Payment ID	The automatically-assigned unique identifier for this transaction.
Merchant Order Number	The merchant-designated identifier for this transaction.
Account Suffix	The account number suffix that the customer used for this transaction. Regardless of account permissions, only the last four digits are visible for credit cards, and the last three digits for a Direct Debit.
BIN	The bank identification number, which is the first six digits of the credit card number used for the transaction. This uniquely identifies the institution that issued the credit card to the card holder.
Payment Type	The method of payment (Visa, Mastercard, etc.) for this transaction, or PINless Debit Adjustment.
Reason Code	The code indicating why this chargeback, Direct Debit return, or PINless Debit adjustment was initiated.
Reason Description	The description corresponding to the Reason Code.
Date Issued	The day the issuing bank processed the chargeback, Direct Debit return, or PINless Debit Adjustment.
Date Received	The day that Worldpay received the chargeback, Direct Debit return, or PINless Debit Adjustment from the network or bank.
Reply by Date	The day by which merchants must respond to the case. Note: This field is empty for Direct Debit returns and PINless Debit Adjustments.
Chargeback Currency	The currency used for the chargeback.
Chargeback Amt	The disputed dollar amount of the chargeback, Direct Debit return, or PINless Debit Adjustment.
Auth Date	The date of the original Authorization. Note: This field is empty for Direct Debit returns and PINless Debit Adjustments.
Auth Currency	The currency used for the Authorization amount.
Auth Amt	The total dollar amount of the original authorization. Note: This field is empty for Direct Debit returns and PINless Debit Adjustments.
Transaction Date	The date of the original transaction.
Transaction Purchase Currency	The currency used for the transaction purchase.
Transaction Purchase Amount	The amount of the original purchase.
Transaction Settlement Currency	The currency used for the transaction settlement.
Transaction Settlement Amount	The total amount of the purchase in the settlement currency.
Activity Date	The date that Worldpay processed the transaction.
Settlement Date	The date that Worldpay sent the settled funds to your organization’s account.
Activity	The activity performed on the chargeback, or the return type (if not a chargeback). Possible values are: Add Note Assign To Vantiv Assign To Merchant Assign To Merchant Automated Assign to User Attach Document Auto Represent File Pre-arbitration Merchant Accepts Liability Merchant Accepts Liability - PayPal Merchant Represent Merchant Requests Arbitration Merchant Respond Merchant Respond - Sent Credit Move To Vantiv Error Queue Network Accepted Network Decision Receive Network Transaction Request Declined Send Representment Send Retrieval Request Response Successful PayPal Case ACH Direct Debit Return PINless Debit Adjustment
Cycle	The current cycle of the chargeback. Possible values are: ARBITRATION_CHARGEBACK CHARGEBACK_REVERSAL FIRST_CHARGEBACK ISSUER_ARB_CHARGEBACK PRE_ARB_CHARGEBACK REPRESENTMENT RETRIEVAL_REQUEST Note: This field is empty for Direct Debit returns and PINless Debit Adjustments.
Campaign	The merchant-specified identifier used to track transactions associated with specific marketing campaigns.
Merchant Name	The name of the parent organization (or division) that submitted the transaction.
Affiliate	The merchant-specified identifier used to track transactions associated with your affiliate organizations.
Merchant Grouping ID	The merchant-specified identifier for grouping transactions by an additional transaction level ID outside of Affiliate or Campaign.
Reporting Group	The Reporting Group to which the transaction belongs.
Txn Type	The type of transaction (for example, Deposit or Refund).
Batch ID	The unique number automatically assigned by Worldpay for the batch associated with the transaction.
Session ID	The unique number automatically assigned by Worldpay for the session associated with the transaction.
ARN	The Acquirer Reference Number (ARN) that uniquely identifies this transaction with the networks.
Customer ID	The unique identifier of the purchaser associated with the 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.
Billing Descriptor	The text shown on the customer bill. This is either the default (hard-coded billing descriptor), or the value designated in the transaction (soft billing descriptor).
Assigned To	The name of the user to which the chargeback is assigned.
Assigned To User Type	The type of user. Possible values are: VANTIV MERCHANT PRESENTER MULTI_ORG
Issuing Bank Country Code	The three-character country code indicating the location of the issuing bank.
Issuing Bank	The name of the bank issuing the card.
Merchant ID	The value of the merchantId element/attribute submitted in the cnpAPI transaction.
Presenter	The short name of the presenter.