Settlement Date View - Settlement Summary by Purchase Currency

iQ displays the Settlement Summary by Purchase Currency data panel (Settlement Date View - Settlement Summary by Purchase Currency) when viewing the Reconciliation Dashboard by Settlement Date. This tab contains information from the Settlement Report and shows the Net Settlement for each Purchase Currency broken out by Settlement Day, detailing the impact of Returned Payments, Total Fees, Reserve Activity, and Third Party Payments.

The table below describes each of the fields in the Settlement Summary tabs.

Settlement Date View - Settlement Summary by Purchase Currency

Settlement Summary Field Descriptions

Field

Description

Settlement Date

The date that Worldpay sent the settled funds (less fees and/or reserve/chargebacks) to your organization’s bank.

The transit time depends on the method of fund transfer (for example, via wire transfer or Automated Clearing House - ACH). Your merchant contract specifies the transit type.

Method of Payment

The method of payment for this transaction or group of transactions (Visa, Mastercard, American Express, Discover, PayPal, Bill Me Later, Direct Debit, etc.). This field appears when viewing the data By Payment Method.

Presenter

The presenter who submitted the transaction.This field appears when viewing the data By Presenter.

Note: If your organization self-presents, this field displays your organization name.

Purchase Currency

The currency used for the purchase, designated by a flag icon and a three-letter abbreviation of the country. This field appears when viewing the data By Purchase Currency.

Purchase Amount

The original purchase amount of the transaction. This field appears when viewing the data By Purchase Currency.

Activity Date

The date or range of dates that Worldpay processed the transaction(s), based on your organization’s cutoff time (specified in your merchant agreement). Each settlement date may have multiple associated activity dates.

Net Settled Sales

The total settled funds (Settled Deposits minus Settled Refunds, Deposit Reversals, and Push to Card, plus Refund Reversals) before the deduction of any fees, reserves, or chargebacks.

In the granular data tabs, use the Split icon () located above the column to show a breakdown of each of these totals. Click the Join icon () to re-combine the columns as Net Settled Sales.

Count

The total number of settled transactions for this Settlement or Activity Date.

In the By Settlement Date panel, this field may contain a CSV export icon (). Click the icon to export data on all Net Settled Sales by transaction to a CSV file (e.g., Microsoft Excel). See Exporting Net Settled Sales by Transaction Data for more information.

Returned Payments

The amount of funds associated with chargebacks, Direct Debit (eCheck) returns, rejected payments, and PINless Debit adjustments, including:

  • Debits for receipt of a first chargeback.

  • Debits for an arbitration chargeback.

  • Debits for a Direct Debit return.

  • Debits or credits for payments rejected by the card networks.

  • Debits or credits for PINless Debit adjustments.

  • Credits for the return receipt of a representment.

This column can be split to show a breakdown of Chargebacks/Returns and Rejected Payments using the Split icon () located above the column. Click the Join icon () to re-combine the columns to Returned Payments.

To view a report with more details about the returned payments amounts in this field, click the desired returned payments amount link. For more information, see the Returned Payments Report.

In the By Settlement Date panel, this field may contain a CSV export icon (). Click the icon to export data on all chargeback activities for this settlement or activity date, to a CSV file (e.g., Microsoft Excel). See Exporting Returned Payments Data for more information.

Total Fees

The amount of funds associated with transaction processing charges (Worldpay Fees) plus other fees, e.g., interchange (Passthrough Fees).

This column can be split to show a breakdown of Worldpay Fees and Passthrough Fees using the Split icon () located above the column. Click the Join icon () to re-combine the columns to Total Fees.

To view a report with more details about the fees in this field, click the desired fee amount link. For more information, see the Fee Report.

In the By Settlement Date panel, this field may contain a CSV export icon ().Click the icon to export data on all fees for this settlement or activity date to a CSV file (e.g., Microsoft Excel). See Exporting Fee Data for more information.

Reserve Activity

The changes made to the reserve fund based upon gross sales. If you sell in multiple currencies, this only reflects the Reserve Activity for the selected currency.

To view a report with more details about the Reserve Activity in this field, click the desired Reserve Activity amount link. For more information, see the Reserve Report.

In the By Settlement Date panel, this field may contain an Excel export icon (). Click the icon to export data on all reserve activity for this settlement or activity date to a Microsoft Excel file. See Exporting Reserve Activity Data for more information.

3rd Party Payments

The fees paid to a third party by Worldpay on behalf of your organization.

If you are a Payment Facilitator enabled for sub-merchant funding, this field is replaced by ‘FBO Settlement Account.’

FBO Settlement Account

The balance of the (For Benefit Of) Settlement account. The FBO Settlement account holds settlement funds for Visa, Mastercard, Discover, American Express, Direct Debit, and Funding Instruction transactions.

If you are a Payment Facilitator enabled for sub-merchant funding, this field is seen in place of ‘Third Party Payments.’

Net Settlement

The net amount transferred to your organization’s bank account.