How to Export Reconciliation from Worldpay (2026 Guide)

Open your browser and sign in to the Worldpay iQ Reporting and Analytics portal with your merchant credentials. Ensure you have access to the financial reporting section of the portal.

From the iQ Bar, click the Financial icon and select the Reconciliation Dashboard. This report provides a detailed breakdown of each transaction's fees, including Worldpay's commission and passthrough fees (interchange and card network fees).

Select the date range, reporting group, and currency for the reconciliation data you want to export. Click 'View' to generate the report. The reconciliation report links each transaction to its corresponding transfer (payout) batch via the Transfer ID.

Tip: Use the Transfer ID column to group transactions that were paid out together in a single bank deposit. This simplifies matching payouts to your bank statement.

The reconciliation report shows separate columns for Worldpay Fees (Worldpay's processing commission) and Passthrough Fees (interchange and card network charges). Review these columns to understand the total cost per transaction. The sum of both fee types equals the total Fees column.

Click the CSV Export button to download the reconciliation data. The export includes Payment ID, Merchant Order ID, Transaction Date, Settlement Date, Activity Type, Gross Amount, Net Settled Amount, Fees, Worldpay Fees, Passthrough Fees, and Transfer ID.

Open the CSV file in a spreadsheet and confirm that the fee breakdown columns are populated. For journal entry creation, you will typically need the Gross Amount (debit to accounts receivable), Fees (credit to expense), and Net Settled Amount (debit to bank). The Activity Type column distinguishes deposits, refunds, chargebacks, and adjustments.

Warning: Refunds and chargebacks appear with negative Net Settled Amounts. Make sure your accounting workflow handles these as reversals rather than additional charges.