Exporting Transaction-Level Fraud Reports

You can export a report in CSV format that provides transaction-level data on Fraud-Detected Authorizations (seven days maximum) as well as a report on Fraud Alerts. If you require more than seven days of data, you must export separate reports in seven-day increments. Transaction-level data is available for any seven-day period within the past 24 months.

Fraud-Detected Authorizations Export Report

To export the Transaction-Level Fraud-Detected Authorizations Report:

From the iQ Bar, click the Fraud icon and chose Snapshot from the list of available reports, or from the Fraud Navigation bar.
Specify the desired Date Range (seven days maximum) and Reporting Group and click View to refresh the page.
Click the CSV Export icon () next to the count in the Filtered Authorizations 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 report.

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

Transaction-Level Fraud-Detected Authorizations Report Field Descriptions
Field	Description
Transaction Date	The original date of the transaction.
Amount	The amount of the transaction.
Card 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.
Merchant Order Number	The merchant-designated identifier for this transaction.
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.
Method of Payment	The method of payment (Visa, MasterCard, etc.) for this transaction.
Response Reason Message	The transaction response reason returned by Worldpay for this declined transaction.
Fraud Velocity	Indicates the filter results for the filtered transaction. For each type of filter, one of the following is shown: Not Checked - the filter was not checked (not configured to run). Checked - Passed - the filter was applied for this transaction and passed, so the transaction was not filtered. Failed - Not Filtered - the filter was applied for this transaction and failed, but the transaction did not fail for this reason alone. Failed - Filtered Txn - the filter was applied for this transaction and failed, and this was part of the reason for the failed authorization.
Prior Chargeback
Prior Fraud Advice
Prepaid Card
International Card
Security Code No-Match
AVS No-Match
FraudSight

Fraud Alert Count Export Report

To export the Fraud Alert Count Report:

From the iQ Bar, click the Fraud icon and chose Fraud Snapshot from the list of available reports, or from the Fraud Navigation bar.
Specify the desired Date Range (seven days maximum) and Reporting Group and click View to refresh the page.
Click the CSV Export icon () next to the count in the Total Fraud Alerts field. 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 report.

Note that the number of Fraud Alert records listed in the exported report may differ from the count shown in the summary panel. This can occur if:

Your organization receives reports on certain Merchant IDs (MIDs) only. The summary panel displays counts for the entire organization.
There is a Fraud Alert against a refund. The summary panel count does not include the record in the count, however the export report contains the record.
There is a Fraud Alert against a deposit that has multiple partial refunds. The export report contains multiple records, but the summary panel count includes it as a single record.

Transaction-Level Fraud Alert Report Field Descriptions
Field	Description
Merchant Name	The name of the parent organization (or Reporting Group) to which the transaction associated with this Fraud Alert applies.
Report Date	The date when this Fraud Alert was posted by Worldpay.
Billing Descriptor	The custom billing descriptor text that will display on the customer’s bill for the transaction associated with this Fraud Alert.
BIN	The Bank Identification Number (BIN) of the issuing bank associated with transaction associated with this Fraud Alert.
Bank Name	The name of the bank associated with this BIN.
Customer ID	The unique identifier or the purchaser associated with the transaction associated with this Fraud Alert.
Transaction Type	The type of transaction associated with this Fraud Alert (for example, Auth, Deposit, etc.)
Deposit Payment ID	The unique identifier automatically assigned to the deposit associated with this Fraud Alert.
Deposit Order Number	The merchant-designated identifier for the deposit associated with this Fraud Alert.
Deposit Date	The date of the deposit associated with this Fraud Alert.
Deposit Amount	The amount of the deposit associated with this Fraud Alert.
Auto-refund	Indicates whether the deposit associated with this Fraud Alert was auto-refunded by Worldpay.
CBK Issuing Bank Day	The date the issuing bank submitted the chargeback associated with this Fraud Alert (one day before Worldpay receives the chargeback).
CBK Current Cycle	The current phase in the chargeback life cycle for the chargeback associated with this Fraud Alert: ARBITRATION_CHARGEBACK CHARGEBACK_REVERSAL FIRST_CHARGEBACK ISSUER_ARBITRATION_CHARGEBACK PRE_ARBITRATION_CHARGEBACK REPRESENTMENT RETRIEVAL_REQUEST
CBK Amount	The amount of the chargeback associated with this Fraud Alert.
Prior Refund Date	The date of the refund associated with this Fraud Alert.
Prior Refund Amount	The amount of the refund associated with this Fraud Alert.
Method of Payment	The method of payment (Visa, Mastercard, etc.) for the transaction associated with this Fraud Alert.