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 () 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:
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. |