All report fields and columns

The 3D-Secure result can be configured to appear in the Get Statement report. One of the following responses is possible:

• Cardholder Authenticated - The cardholder entered their password correctly and their identity was successfully authenticated by the relevant card issuer

• Authentication offered but not used - The relevant card issuer or cardholder is not enrolled

• Authentication Unavailable - Authentication was initiated, but a system or connectivity issue between Worldpay, the Card Scheme and/or the Card Issuer, prevented authentication from being completed

• Ecommerce/Unknown – This result appears when authentication is not initiated for one of the following reasons:

  • The merchant is not enabled

  • The card type is not supported by authentication

For further details, refer to the Liability Shift section of the WPG Integration Guide.

The acquiring bank's identification code.

The account identification that identifies the acquirer that the capture batch is sent to by the Payment Service.

A unique code that identifies your company.

The value of a transaction or the total value of a group of transactions.

The amount transferred to your bank account.

The amount transferred to your bank account.

The amount transferred to your deposit by the Payment Service.

The date that a report or an activity begins.

A code provided by the acquirer to authorise a payment. It means the card has not been reported as lost or stolen and there was sufficient funds at time of authorisation.

Date the payment was authorised.

The result of the Address Verification Service (AVS) check as returned by the acquirer. For further details, refer to the Fraud Screening guide.

Section that provides details about the transfer batch.

The specific batch number that identifies a transfer batch. A transfer report for a particular transfer batch is also identified by a Batch ID.

The specific batch number that identifies a capture batch.

The Batch Transfer identification code.

Date the payment was captured.

Shopping cart identification that was given to this transaction by your (the merchant's) system.

The Worldpay Guarantee transaction fee as applied to this payment, or where applicable, payments. Applies only to UK merchants who have purchased the Worldpay Merchant Guarantee.

The currency in which the Chargeback Merchant Guarantee Amount is applied at date of settlement. Applies only to UK merchants who have purchased the Worldpay Merchant Guarantee.

The total value of payments charged back in this period. The period date range is displayed in the Settled Purchases Between field.

The amount charged back from the merchant's account.

Column heading for section detailing charges made by the Payment Service.

The total of transaction-level service charges levied against the payment.

The total of transaction-level service charges levied against the payment.

The date and time the first payment status was given to the payment by the payment server.

A three letter currency code that identifies a currency. Refer to the Useful Tables section of the WPG Integration Guide.

A three letter currency code that identifies a currency. Refer to the Useful Tables section of the WPG Integration Guide.

Defines the method a transaction connects to Worldpay, such as online or over the phone.

The result of the Card Verification Code (CVC/CVV) check as returned by the acquirer. For further details, refer to the Fraud Screening guide.

The date the transaction was authorised.

The date the capture request is submitted to the acquirer.

The date of a transaction, event, message, or other entity.

Displays exchange rate where applicable or gives details of items.

Description of items in the report.

Adjustment made to the deposit for the relevant merchant code at the transfer date. Note that where the current deposit is less than the required deposit, then funds due to you at transfer are automatically transferred to the deposit until paid.

Value held in deposit by the payment service.

Current shortfall or surplus in the deposit account for this merchant code.

Section of the Get Statement report that displays details for the column headings (fields) based on the standard configuration called "statement" or displays fields in the report you have chosen to display using the Saved Report Format field in the report parameters page.

Column heading of the Get Statement report that shows whether or not a transaction was made using the MasterPass or V.me by Visa digital wallets.

Chargeback reason (if given) by the financial institution.

The currency in which applies to the Dispute Reserves Amount.

Amount held in the Dispute Reserve for this transaction. Only populated where disputed.

Type of Dispute

The date that the Event Type (payment status) was given by the payment server.

The relevant payment status or payment event.

For a full list of payment statuses and their meaning, refer to the Payment Process section of the WPG Integration Guide.

The rate imposed by the financial institution to convert the currency the shopper paid in to your transfer currency. Note that the exchange rate is calculated at settlement.

From a specific date or time and date.

The date that starts a particular period. This period ends at the End Date or Until Date.

A transfer fee that is applicable where there is a transfer of funds to a bank account.

The total gross value of all transactions for the relevant settlement period.

The currency of the amount held in the In Process Authorised Amount field.

The balance on the IN_PROCESS_AUTHORISED account and represents the funds that are reserved (authorised) for you by the financial institutions. This amount is the amount that can (still) be captured.

The balance in the IN_PROCESS_CAPTURED account represents the amount that is captured by the financial institutions on your behalf. This amount is the amount that can (still) be settled.

The currency of the amount held in the In_PROCESS_CAPTURED account.

The balance in the IN_PROCESS_SENT_FOR_AUTH account.  

The currency of the amount held in the IN_PROCESS_SENT_FOR_AUTH account.

Costs of different subscription charges.

Any charges specified in the weekly transfer invoice and the monthly invoice are deducted from this transfer. The invoices are emailed to you at the same time as the Transfer report and contain full details.

Date of this invoice.

An account identification code. Your company may have several accounts and for each account you will receive a merchant code from the Payment Service.

An account identification code. Your company may have several accounts and for each account you will receive a merchant code from the Payment Service.

The total transaction-level service charges levied against the payment. This is applied at date of settlement.

The currency in which the Merchant Commission Amount is applied by the Payment Service. This is applied at date of settlement.

The Worldpay Guarantee fee applied to the payment. Applies only to UK merchants who have purchased the Worldpay Guarantee.

The currency of the amount displayed in the Merchant Guarantee Amount field.

Merchant Guarantee service charges made by the Worldpay Payment Service for this period. (Only applicable to UK-based merchants who have purchased the Worldpay Merchant guarantee.)

The amount after any charges or deductions have been made.

The  total amount of service charges due to the Payment Service and deducted at transfer.

Number of transactions.

A unique id given by the payment server to identify a payment.

The description entered by the shopper to describe their order.

The amount of any extraordinary payments or deductions included in this batch. For example, special billing items.

Displays the parameters you have chosen in the report parameters page.

The amount of the payment as entered by the shopper at time of purchase.

The amount paid by the shopper when converted to the transfer currency.

When multi-currencies are used by shoppers, this field provides details of the payment in the transfer currency. Note that when a payment is at AUTHORISED or CAPTURED then this is an indicative amount as the rate imposed by the financial institution to convert the currency is made at settlement.

The currency of the amount displayed in the Payment Amount in Transfer Currency field.

The currency of the payment made by the shopper at time of purchase.

The type of card/payment method. For example, Visa, MasterCard, Amex.

The payment to be transferred to your bank account.

Date the period began in which settled payments were collected.

Date the period ended in which settled payments were collected.

The total amount of payments refunded in this transfer.

The total amount of refunded payments in this period.

Date the report was created.

'W' or 'C' indicates a Warning or Caution risk alert. An alert means that there may be an element of risk involved in accepting the payment. We recommend that you review payment and shopper details to assess the risk involved in accepting the payment. Refer to the Fraud Screening guide for further details.

The code that identifies the particular services that the Payment Service is contracted to provide.

The total value of settled payments processed for this merchant code in this period. The period date range is displayed in the Settled Purchases Between field.

The total value of settled payments in this batch.

The date range that indicates the period that settled payments were collected for the transfer batch.

The amount settled by the acquirer minus any deductions made by the Payment Service. This is the amount that will be/has been transferred to you.

If the payment is not yet settled, then this field is blank.

The currency in which the Payment Service transfers funds that are owed to you.

Date the payment was settled to the Payment Service.

The shopper's postal address, as entered by the shopper at time of purchase.

The shopper's country code.

The shopper's email address, as entered by the shopper at time of purchase.

The name of the shopper as entered by the shopper at time of purchase

The shopper's telephone number, as entered by the shopper at time of purchase.

The shopper's post code, as entered by the shopper at time of purchase (Zip code in the USA).

Where applicable, includes Monthly Service fee, Risk Management monthly fee and Guarantee fee.

Total of charges made by the Worldpay Payment Service before VAT or GST.

Summary details for some fields in the Details section of the report.

Date of Invoice.

Date of Invoice.

Unique number that identifies a particular invoice. You should use this number in any correspondence.

The end date of a period that starts with a From Date.

Total charges for this invoice.

The total sum of the amounts.

Displays total sums for payments that have reached the SETTLED payment status.

Last month's fraud screening charges, chargeback and refund fees.

Transaction charges made by the Worldpay Payment Service for this period.

The number of transaction or a list of transactions.

The number of transactions.

The amount settled by the acquirer minus any deductions made by the Payment Service. This is the amount that will be/has been transferred to you.

If the payment is not yet settled, then this field is blank.

The currency in which the Payment Service transfers funds that are owed to you. This is the currency of the value displayed in the Transfer Amount field.

If the payment is not yet settled, then this field is blank.

The date of transfer.

Date of transfer of funds to your (the merchant's) bank account.

Heading for summary giving transfer details. If applicable, this section displays settled payments, refunds and chargebacks.

Until a specific date or time and date.

The date that ends a particular period. This period starts at From Date.

Value Added Tax (VAT) or Goods and Sales Tax (GST) that is applicable. Rate may vary depending on your region.

Column heading displaying the value of different items in the invoice.