Worldpay Xero Integration

🥦

Integrate Complete

Xero Bank Statement CSV Format
valid rows

Seamless Worldpay payment and Xero integration using CSV. No API setup, no subscription, no complex configuration.

Free preview — then from $5. Save with bundles.
Free preview before you pay
Files never leave your browser
No account needed to start

Download Sample Worldpay Export

Sample CSV to test the converter

Download Sample

Tool Rating

4.6 / 5 (47 votes)

How Integration Works

1

Export from Worldpay

iQ Bar (Financial icon) → Reconciliation Dashboard → Export CSV

2

Upload and Configure

Upload Reconciliation Report CSV and choose Bank Statement format

3

Preview and Download

Review converted data, download Xero-ready file

4

Import to Xero

Accounting → Bank Accounts → Select Account → Import Statement

Your file is ready for Xero Bank Statement CSV — just upload it, no extra steps needed.

How People Use This

My Worldpay settlement reconciliation report never matched Xero's expected bank statement format. The converter handles the DD/MM/YYYY date formatting for my UK Xero org and automatically converts refunds to negative amounts in the Money Out column.

Fiona D.
UK Retail Store Owner · 3 Worldpay terminals, Xero accounting

Every week I download the settlement report from Worldpay Business Manager and convert it to Xero bank statement format. The whole process takes about 60 seconds and I import directly through Banking in Xero. No API setup, no subscription.

Patrick N.
Accounts Payable Clerk · processes weekly Worldpay settlements

We run Worldpay across five venues and settle in both GBP and EUR. The multi-currency support lets me process each currency's settlement separately and import to the matching Xero bank account. The payment ID references make reconciliation straightforward.

Simone E.
Hospitality Finance Director · 5 venues, multi-currency settlements

Half my Xero clients accept card payments through Worldpay FIS and none of them could get the settlement data into Xero cleanly. I convert their worldpay CSV to Xero format in bulk each month, and the region-aware date formatting prevents import errors across UK and EU organizations.

Oliver T.
Xero-Certified Bookkeeper · manages 10 clients using Worldpay

Integration Questions Answered

Which Worldpay report should I use?

Use the Settlement Reconciliation Report or Transaction Report from Business Manager. This contains the transaction details needed for conversion to Xero.

How are refunds handled?

Refunds and chargebacks are automatically converted to negative amounts in the Money Out column for proper bank reconciliation.

Can I import directly into Xero?

Upload the converted CSV through Banking → Upload File in Xero. Select your Worldpay bank account and import the transactions.

Worldpay Xero Integration Made Simple

The Settlement Format Problem

Worldpay (FIS) deposits settled transactions to your bank account, but their Settlement Reconciliation Report doesn't match Xero's bank import format. Without proper formatting, you'd manually enter each transaction or spend hours reformatting CSV columns to import Worldpay data into Xero correctly.

Simple CSV Integration

Our CSV-based integration converts Worldpay exports to Xero-compatible bank statements: - Settlement dates formatted for your Xero region - Refunds/chargebacks converted to negative amounts - Transaction references mapped to Payee field - Reference numbers created for bank matching - Multi-currency settlements handled

Seamless and Secure Integration

Automatic Column Matching

Fields from your source file are mapped to the right columns in the target format. No manual work needed.

Runs in Your Browser

Integration runs entirely in your browser. No third-party access to your data.

GDPR Compliant

No data leaves your machine. Full EU privacy compliance.

More credits - more savings

Buy bundles and get up to 60% off. Perfect for recurring monthly conversions.

Field Mapping

How Worldpay Reconciliation fields map to Xero Bank Statement

Worldpay Reconciliation Source Value Xero Bank Statement Target Value Note
Gross Amount 125.00 → Spend Transaction amount (positive for sales)
Worldpay Fees 1.75 → Spend Worldpay processing fees (negative)
Passthrough Fees 1.75 → Spend Interchange fees (negative, tracked separately if split)
Payment ID PAY-1234567890 → Reference PAY-1234567890 Worldpay's unique transaction ID
Transfer ID XFER-20250117-001 → Reference XFER-20250117-001 Settlement transfer identifier

Why Automate the Data Transfer?

No API Setup Required

Works with standard Worldpay CSV exports. No OAuth, no API keys.

60-Second Conversion

Upload → Preview → Download. No waiting for sync or rate limits.

Automatic Refund Handling

Refunds and chargebacks automatically converted to negative amounts.

Multi-Currency Support

Handle settlements across multiple currencies. Process each separately.

Region-Aware Date Formatting

Supports UK, US, AU, NZ, and EU Xero organizations with proper date formats.

Browser-Based Privacy

Files process locally. Your payment data never leaves your computer.

Data Transformation

Each transaction creates gross and fee rows in Xero bank format, optionally splitting Worldpay and Passthrough fees

Input Worldpay Transaction

One row per transaction with gross amount and fee breakdown

Key columns: Payment ID, Gross Amount, Worldpay Fees, Transfer ID
1:N — One input row creates multiple output rows
Output Xero Bank Rows 2-3 (depends on split_fees setting) rows per input

Multiple spend rows for transaction and fee tracking

Transaction Amount Sale, refund, or chargeback at gross amount
Worldpay Fee Worldpay processing fee tracked separately
Passthrough Fee Interchange fee tracked separately (if split_fees enabled)
All amounts sum to net deposit (matches bank statement)

Common Bank Statement Import Errors

Issues you might encounter when importing Reconciliation Report data to Bank Statement - and how we solve them

Transfer Totals Don't Match Bank

Xero bank import totals don't align with actual bank deposits

Verify you're using the complete Worldpay Reconciliation Report. Check for missing transactions or split transfers.

Too Many Fee Rows in Xero

Xero bank import has 3 rows per transaction making reconciliation difficult

Disable 'split_fees' option to combine Worldpay and Passthrough fees into one line.

Xero Rejects Import Due to Date Format

Xero can't parse dates because wrong regional format is used

Set the correct region (UK/AU/NZ/EU use DD/MM/YYYY, US uses MM/DD/YYYY). Check your Xero organisation settings.

Frequently Asked Questions

Your data never leaves your device. All files are processed entirely in your browser using client-side JavaScript - no data is stored on our servers or sent anywhere. There's no account to hack, no database storing your files, and no API connections to your bank or accounting software. You upload, convert, download, and we forget it immediately.
No payment or signup required. You can upload your file, see a free preview of the conversion results, and verify everything looks correct before paying anything. If it doesn't work for your files, you haven't wasted any money. We only charge when you're satisfied and ready to download the final converted file.
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.
Use the Settlement Reconciliation Report or Transaction Report from Business Manager. This contains the transaction details needed for conversion to Xero.
Select the format matching your Xero organization. UK/AU/NZ use DD/MM/YYYY, US uses MM/DD/YYYY. Using the wrong format will cause import errors.
Refunds and chargebacks are automatically converted to negative amounts in the Money Out column for proper bank reconciliation.
Yes. Worldpay was acquired by FIS but the settlement reports maintain the same structure. This tool works with both legacy Worldpay and FIS Worldpay reports.
Export your Settlement Reconciliation Report from Worldpay Business Manager, upload it to our converter, then import the bank statement CSV into Xero via Banking. No API setup needed.
Process each currency's settlement separately and import to the appropriate bank account for each currency in Xero.
This tool is specifically for Xero. For QuickBooks, use our Worldpay to QuickBooks converter which creates the correct QBO format.
Upload the converted CSV through Banking → Upload File in Xero. Select your Worldpay bank account and import the transactions.
IPAY Xero is the reference Worldpay uses for deposits into your settlement account. Match this reference when reconciling in Xero.
Worldpay deducts processing fees before depositing to your bank. The CSV shows gross amounts, but your bank shows net after fees.
Worldpay fees are typically shown on separate invoices. Enter these as bills or expenses in Xero to track total processing costs.

Worldpay → Xero Data Ecosystem

All available data flows from Worldpay to Xero

Worldpay Reconciliation Report Detailed reconciliation with fee breakdown for journal entries
→
Xero Bank Statement Bank transactions for reconciliation
Transfer Date → Date Gross Amount → Spend Worldpay Fees → Spend
Payout reconciliation, fee tracking

Also available as

This platform pair is available in 1 other hub