Payout Reconciliation
Creates bank feed entries that match your PayPal balance and transfers to bank.
Enter your email to receive a sign-in link
Bridge the gap between PayPal payments and Xero accounting. Convert your Activity Download exports to Xero-ready bank statement CSVs for seamless payout reconciliation.
Free preview — then from $5. Save with bundles.Activity → All Reports → Activity download → Download CSV
Upload Activity Download CSV and choose Bank Statement format
Review converted data, download Xero-ready file
Accounting → Bank Accounts → Select Account → Import Statement
Output is in Xero Bank Statement format — ready to import directly, no manual reformatting needed.
Single-line shows the Net Amount (what actually hits your bank after fees). Two-line separates the Gross payment from the Fee (PayPal's charges), letting you track fees as a separate expense category in Xero.
For professional accounting, yes. Create a 'PayPal Clearing' account to hold transactions. When you withdraw to your real bank, the transfer shows in both accounts, making reconciliation clean.
No, PayPal's Activity Download format requires conversion before Xero can import it. You need to reformat the CSV file or use a conversion tool to make it compatible with Xero's bank statement import format.
Creates bank feed entries that match your PayPal balance and transfers to bank.
Optional two-line mode splits gross payments from PayPal fees for expense tracking.
Properly handles refunds as negative amounts to keep your bank balanced.
Filter by currency or process all currencies for multi-currency Xero accounts.
Handles large exports with automatic batching for Xero's 1,000 row limit.
All processing happens locally. Your financial data never leaves your device.
How Paypal Transactions fields map to Xero Bank Statement
| Paypal Transactions | Source Value | Xero Bank Statement | Target Value | Note | |
|---|---|---|---|---|---|
Date |
01/15/2025 |
→ | Date |
01/15/2025
|
Transaction date |
Net |
97.10 |
→ | Amount |
97.10
|
Net amount (single mode) |
Gross |
100.00 |
→ | Amount |
100.00
|
Gross amount (two-line mode) |
Fee |
-2.90 |
→ | Amount |
-2.90
|
PayPal fees (two-line mode, negative) |
Name |
John Smith |
→ | Payee |
John Smith
|
Counterparty name |
Transaction ID |
9AB12345CD678901E |
→ | Reference |
9AB12345CD678901E
|
PayPal transaction ID |
All conversion runs in your browser. Files are never uploaded to any server.
Nothing is stored after conversion. Close the tab and your data is gone.
Full EU data protection compliance. Your privacy rights are fully protected.
Each PayPal transaction becomes 1 or 2 bank rows depending on mode
One Activity Download row with Gross/Fee/Net
Transaction ID,
Date
Issues you might encounter when importing Activity Download data to Bank Statement - and how we solve them
PayPal fee calculation doesn't match Net
Gross: $100, Fee: -$2.90, Net: $98.00
Computed: Fee Effect = Net - Gross = -$2.00
Use FeeEffect = Net - Gross for accurate fee tracking
This handles fee reversals and adjustments correctly
Pending transactions haven't settled yet
Status: Pending, Net: $100.00
Skipped (not balance-affecting yet)
We filter to only Completed transactions
Re-export after transactions settle
Refunds reference original transaction
Type: Refund, Reference Txn ID: ABC123
Amount: -$100 (negative reversal)
Refunds appear as negative amounts
Bank balance stays accurate with refunds included
PayPal holds multiple currency balances
USD: $500, GBP: £200, EUR: €100
Split by currency or single currency
Filter by currency or import to matching bank account
Use currency filter option for multi-currency Xero
Withdrawals to bank appear as negative
Type: Bank Transfer, Net: -$1000
Amount: -$1000 (outflow from PayPal)
This is correct - money left PayPal to your bank
Match with incoming deposit in your actual bank account
Buy bundles and get up to 60% off. Perfect for recurring monthly conversions.
All available data flows from Paypal to Xero
Date → Date
Net → Amount
Gross → Amount
Name → Name
From Email Address → EmailAddress
Contact Phone Number → PhoneNumber
Name → ContactName
From Email Address → EmailAddress
Invoice Number / Transaction ID → InvoiceNumber
This platform pair is available in 2 other hubs
Help us improve—what stopped you today?
Enter your email to claim your welcome bonus
SpreadsheetBroccoli