This page has useful information about all of the reports that you can generate. Some fields, columns or settings may not be visible depending on your permissions and how the reports are made.
This table contains the fields that are used when you setup or create your reports.
Field |
Description |
Displays the unique code that identifies your company. |
|
Enter the batch number in the field. If you do not know the batch number, you may want to refer to the Transfer Batch report from the Reports menu and select 0 (zero) in the Batch ID field to display details of all batches. Alternatively, you may want to refer to the page where all paid batches are located. To do this, select the Financial Status page from the left-hand menu. Locate the Transfer Summary. Select the Transfer Currency or Amount hyperlink in the Total to be Transferred field. The Account Batch page is displayed. This page displays details of all transfer batches. |
|
Enter the batch number in the field, or enter 0 (zero) to display all batches. |
|
Clear Form (button) |
Clears all your settings on the current report parameters page so you can start afresh. |
Event Type |
Select a payment status from the drop-down list. The 'all statuses' option is the default. The report will output payments that reached the payment status you select within the date range specified in the Date From and Date Until fields. The payment statuses in reports are slightly different to the statuses in the Business Manager. To see how they relate to each other, click here. |
Select the format of the report from the drop-down list:
|
|
Enter a date or date and time in the From Date to specify the start date of your chosen date range. If you do not specify a time then the default time applies, which is 00:00 at the start of the day. The date must be entered in the format: yyyy-mm-dd and the time in the format: hh:mm. |
|
Generate (button) |
Select this button to generate the report. |
Go back (button) |
Select this button to return to the report parameters page. |
Enter the full invoice or a partial invoice number and a wildcard. If a wildcard character is required then a (%) percentage character must be used as the wildcard. It can only be placed after 1 or more characters have been entered. Note that the search is case-sensitive. |
|
Select an invoice period from the drop-down list. |
|
Select the Last Event check box, if required. Use the Last Update option to report on those payments that are currently at a particular status. For example, to report on those payments that are at the AUTHORISED payment status but have not yet reached the CAPTURED payment status or payments that have reached CAPTURED but have not yet reached the SETTLED status. |
|
Select the Create button next to Saved Report Format to create a new column configuration based on a standard configuration (the Statement). If you have created your own reports they are displayed in the Edit or Delete your own Configurations section. The Edit and Delete buttons enable you to amend or remove your own reports. To learn more about creating a new Get Statement report, click here. |
|
Displays a list of the available report parameter sets. Each parameter set has a reference name or number in the Reference column. Use the Load button to load an existing parameter set which you can then amend or the Delete button to delete a parameter set. To learn more about creating report parameter sets, click here. |
|
Displays a list of the available report schedules. Each schedule has a reference name or number in the Reference column. The schedule description column informs you exactly when the report automatically generates. Use the Load button to load an existing schedule which you can then amend or the Delete button to delete a schedule. For details about scheduling, click here. |
|
An account identification code. Your company may have several accounts and for each account you will receive a merchant code from the Payment Service. |
|
Select the merchant code you require from the drop-down list if you have more than one merchant code. If there is only one merchant code for your administration, displays that merchant code. |
|
Two or more of the following output parameters will displayed, depending on the report. Select one of the following options.
|
|
Select a Saved Report Format from the drop-down list. The default is 'statement'. If you have created your own reports by using the Manage Report Column Configurations section of this report then the names of your reports are displayed in the drop-down list, which you can select. |
|
Enter a date or date and time in the Until Date to specify the end date of your chosen date range. If you do not specify a time then the default time applies, which is 00:00 at the start of the day. The date must be entered in the format: yyyy-mm-dd and the time in the format: hh:mm or hh:mm:ss. |
This table contains a list of all the report fields in alphabetical order.
Field/Column Heading |
Description |
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:
For further details, refer to the Cardholder Authentication 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 currency codes in the HTML Redirect guide. |
|
A three letter currency code that identifies a currency. Refer to currency codes in the HTML Redirect guide. |
|
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. Note: In the Transfer batch view of the Finance section, this is known as the reserve adjustment. |
|
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 a V.me wallet. |
|
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 Payment Status section of the Payments & Orders guide. The payment statuses in reports are slightly different to the statuses in the Business Manager. To see how they relate to each other, click here. |
|
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. |
|
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.) |
|
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 currency of the amount displayed in the Merchant Guarantee Amount field. |
|
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. |
|
A unique ID given by the payment server to identify a |
|
Transaction charges made by the WorldPay Payment Service for this period. |
|
The number of transaction or a list of transactions. |
|
The number of transactions. |
|
A unique id given by the payment server to identify a payment. |
|
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. |
|
Risk score associated with V.me wallet payments. Available on the Payment with Risk Detail report. |