Worldpay Reconciliation Report Validator

You can, but free scripts and AI often miss edge cases that break real-world data: missing SKUs, currency formatting quirks, tax calculation errors, or date format mismatches. We have battle-tested validators specifically designed for accounting software imports that catch these issues before they corrupt your books. Plus, you get instant browser-based conversion without installing Python or managing dependencies.

Required columns are Payment ID, Transaction Date, Activity Type, and Gross Amount.

Valid types are Deposit, Refund, Chargeback, Chargeback Reversal, Fee, Adjustment, Hold, Release.

You can preview Worldpay Reconciliation validation results for free — no signup needed. Full validation reports use credits based on row count.

Use the Worldpay iQ Settlement Report for deposits, fees, and net sales. Session exports are transaction-level and can miss settlement data.

Activity is by transaction date; Settlement is by funds transfer date. Use Settlement to match bank deposits and payouts.

Bank deposits are net of fees, chargebacks, reserves, and adjustments. Validate by settlement date and include all rows in the period.

Reconcile to the net payout on the settlement date. Record fees/chargebacks separately so the deposit equals the bank amount.

Some exports don’t include Payment ID on every row or hide it by default. Export a view that includes Payment ID or use another reference field.

Yes—include refunds and chargebacks in the CSV. Missing these entries is a common reason settlement totals don’t tie out.

Validate each currency separately and don’t sum across currencies. Payouts usually settle per currency, so mixed totals won’t match.