Reconciliation Dashboard

The Reconciliation Dashboard provides a single source tool for accessing all the necessary data when performing financial reconciliation, eliminating the need to access multiple reports. The pertinent information from the Activity Report, Settlement Report, and Transaction Summary Report, along with other relevant data, is assembled on the same screen for easy access.

If you are a Payment Facilitator, see the PayFac Reconciliation Dashboard.

You can view the Reconciliation Dashboard by Activity (post) date or by Settlement (funds transfer) date. Summary data is presented in the top frame (the same as seen in the Activity and Settlement Reports), and other detailed data is presented in various frames below.

If you are a Payment Facilitator enabled for sub-merchant funding, the Net Settlement field in the summary panel displays the ‘Net Amount Delivered to Operating Account.’

Reconciliation Dashboard Features

The Reconciliation Dashboard includes a number of features consistent with other reports and some features unique to this report:

• How do I use this data? - you can view information on how to use the data in the Reconciliation Dashboard by clicking above each data panel. Along with a brief description of the report, fields most used when performing your reconciliation activities are highlighted.

• Expand or Hide Data Panels - you can expand or hide data panels using the expand ( ) and hide ( ) icons. All panels are expanded by default.

• Split and Join Columns - in certain data panels, a Split icon () appears above some columns. Click the icon to split the amounts in the columns as follows:

  • Net Settled Sales – splits the amounts into four columns: Settled Deposits, Settled Refunds, Deposit Reversals, and Refund Reversals.

  • Returned Payments – splits the amounts into two columns: Chargebacks/Returns and Rejected Payments.

  • Total Fees – splits the amounts into two columns: Worldpay Fees and Passthrough Fees.

    To re-join the expanded columns, click the Join icon ().

• CSV and Excel Report Exporting - some columns/fields may contain a CSV export icon () or a Microsoft Excel export icon (). Click the icon to export data on Net Settled Sales by Transaction, Fees, Returned Payments, and Reserve Activity.

• Detail Report Links - items shown as hyperlinks in the certain panels provide links to reports with more detailed information. Click an amount hyperlink to view the following:

  • Returned Payments Report - provides a detailed listing of all chargebacks, Direct Debit (eCheck) ACH returns, rejected payments, and PINless Debit adjustments associated with the selected transactions.

  • Fee Report - provides a detailed breakdown of Worldpay and Passthrough (Interchange) fees associated with the selected transactions.

  • Reserve Report - shows a chronological list of the activities associated with the selected transactions that influence your organization’s reserve account.

If your organization is using a Monthly Billing model, see Monthly Billing and Fees in Financial Reports for information on how to interpret fee and settlement data in the Reconciliation Dashboard.

Reconciliation Dashboard - Activity Date View

To access the Reconciliation Dashboard:

1. From the iQ Bar, click the Financial icon and select Reconciliation from the list of available reports, or from the Financial Navigation bar. The Reconciliation Dashboard displays as shown in the above figures.

2. Select the desired view, either by Settlement Date or Activity Date.

3. Specify the desired Date Range, Reporting Group, and Currency, then click View to refresh the page. See Notes on Reporting Group Limits for information on the report groups shown in the Reporting Group drop-down selector.

Each Reconciliation Dashboard view (Activity Date or Settlement Date) comprises a summary panel and the following sections:

• Activity Date View - Transaction Summary by Purchase Currency.

• Activity Date View - Approved Transactions by Purchase Currency.

• Activity Date View - Exchange Summary by Purchase Currency.

• Activity Date View - Activity Summary by Activity Date.

• Activity Date View - Activity Summary by Payment Method.

• Activity Date View - Activity Summary by Presenter.

• Settlement Date View - Settlement by Funds Transfer.

• Settlement Date View - Settlement Summary by Settlement Date.

• Settlement Date View - Settlement Summary by Payment Method.

• Settlement Date View - Settlement Summary by Presenter .

• Settlement Date View - Settlement Summary by Purchase Currency

The sections to follow describe each of these panels.