Credit Bundles
One-time purchase
- No monthly commitment
- Credits valid for one year
- Access to all tools
- Full file downloads
Enter your email to receive a sign-in link
Convert Worldpay payment transactions to Xero bank statements in 60 seconds. No API setup, no subscription.
iQ Bar (Financial icon) → Reconciliation Dashboard → Export CSV
Upload Reconciliation Report CSV and choose Bank Statement format
Review converted data, download Xero-ready file
Accounting → Bank Accounts → Select Account → Import Statement
256-bit SSL encryption. Same standards as major financial institutions.
Files are processed directly in browser. No calls to our servers.
Full EU data protection compliance. Your privacy rights protected.
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 |
Works with standard Worldpay CSV exports. No OAuth, no API keys.
Upload → Preview → Download. No waiting for sync or rate limits.
Refunds and chargebacks automatically converted to negative amounts.
Handle settlements across multiple currencies. Process each separately.
Supports UK, US, AU, NZ, and EU Xero organizations with proper date formats.
Files process locally. Your payment data never leaves your computer.
Each transaction creates gross and fee rows in Xero bank format, optionally splitting Worldpay and Passthrough fees
One row per transaction with gross amount and fee breakdown
Payment ID,
Gross Amount,
Worldpay Fees,
Transfer ID
Multiple spend rows for transaction and fee tracking
Issues you might encounter when importing Reconciliation Report data to Bank Statement - and how we solve them
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.
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 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.
Buy bundles and get up to 27% off. Check our pricing options below.
// PRICING //
One-time purchase
Best for professionals and content creators
Credits are based on rows in your file. Each tool shows its rate (e.g., 2,000 rows = 4 credits). We round up to the nearest step. Minimum 1 credit per conversion.
Files process entirely in your browser. We're GDPR compliant with TLS encryption.
Yes! Full refund within 14 days if no credits used. Partial refund for unused credits anytime. Contact sup@spreadsheetbroccoli.com.
Terms of service applies. VAT included where applicable.
All available data flows from Worldpay to Xero
This platform pair is available in 3 other hubs
Help us improve—what stopped you today?
Enter your email to claim your welcome bonus