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
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 ( |
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 ( |
Returned Payments |
The amount of funds associated with chargebacks, Direct Debit (eCheck) returns, rejected payments, and PINless Debit adjustments, including:
This column can be split to show a breakdown of Chargebacks/Returns and Rejected Payments using the Split icon ( 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 ( |
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 ( 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 ( |
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 ( |
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. |