How to Connect PayPal to Xero: A UK Reconciliation Guide

If you take payments through PayPal and keep your books in Xero, joining the two should make reconciling deposits a quick, near-invisible job. Done well, your sales, fees, refunds and currency conversions land in Xero cleanly and the PayPal balance ties back to the penny. Done badly — and PayPal is one of the messiest feeds in Xero — you get duplicated transactions, missing fees, a PayPal balance that never matches, and hours of manual tidying every month.

This guide covers the realistic options for connecting PayPal to Xero in the UK, how each handles fees, multi-currency and refunds, how to reconcile the PayPal balance properly, how VAT should be treated, and the specific gotchas that catch people out.

The honest short answer

PayPal is not a bank account, and treating it like one is where most reconciliation pain starts. PayPal is a payment processor and a holding account: money sits in your PayPal balance, fees are deducted per transaction, refunds and chargebacks flow back through it, and you periodically withdraw funds to your real bank.

Xero offers a free native PayPal feed, but for many UK businesses it's the wrong tool — it imports gross PayPal activity as individual lines and is notorious for creating duplicates when you also have a sales channel (Shopify, WooCommerce, an invoice) recording the same sale. For clean books, most growing businesses move to a dedicated app that summarises PayPal activity, or a custom feed for complex setups.

Treat PayPal as an account, not a bank feed

The single most important decision is to set PayPal up in Xero as its own bank account (a "PayPal" account in your chart of accounts), separate from your business current account. Money lands in PayPal first, then transfers to your bank later.

That means there are really two reconciliations:

• Into PayPal — sales, fees and refunds hitting your PayPal balance.
• Out of PayPal — the withdrawal moving funds from PayPal to your bank current account.

If you skip the PayPal account and try to reconcile PayPal sales directly against your bank, the numbers will never line up: what hits your bank is a lump-sum withdrawal — net of fees and timing — not your individual sales.

The four ways to connect PayPal and Xero

There's no single "best" method — it depends on volume, whether PayPal is your only record of a sale or a duplicate of one, and how clean you need reconciliation to be. Here's an honest comparison.

Approach	Best for	Strengths	Weaknesses
Native Xero PayPal feed	Very low volume, PayPal as sole sales record	Free; built in; quick to switch on	Imports gross per-transaction; creates duplicates; weak on fees, multi-currency and refunds
Dedicated apps	E-commerce, higher volume, multi-currency	Summarised payouts; fees, refunds and FX split out cleanly	Monthly fee; settlement-based view, not live
Zapier / Make	Light glue, alerts, edge workflows	Flexible; no code; connects many tools	Per-event by default; poor reconciliation; fragile
Custom integration	Complex, high-volume, bespoke logic	Exactly your rules; full control; scales	Build cost; needs maintenance; only past real complexity

Option 1: The native Xero PayPal feed

Xero can connect to PayPal as a bank feed under Accounting → Bank Accounts → Add Bank Account. It pulls in PayPal transactions automatically, much like a bank feed.

It's free and quick, but be clear-eyed about its limits. The native feed imports PayPal activity transaction by transaction at the gross amount, and handles fees clumsily. Crucially, if the same sale is already recorded elsewhere — a Shopify or WooCommerce order, or a Xero invoice the customer paid by PayPal — the feed brings in a second copy of that money. That's the classic PayPal-feed duplicate: revenue counted twice, a payment you can't match, and a growing pile of unreconciled lines.

The native feed is only really safe when PayPal is your sole record of the sale (for example, simple "PayPal.Me" or invoice-link payments with nothing else recording them) and volume is low.

Option 2: Dedicated apps

For e-commerce and higher-volume businesses, a purpose-built connector is usually the right answer. Rather than importing every transaction, the better tools group PayPal activity by settlement/payout period and post a summarised entry into Xero that breaks out gross sales, PayPal fees, refunds and currency conversions — so the total matches what actually moved, and reconciliation becomes a one-click match.

This also solves the duplicate problem: your sales channel records the sale, and the PayPal side is reconciled as the payment, not as a second sale. The trade-off is a monthly fee that scales with volume, and a settlement-based (not live) view. When evaluating any app, ask specifically how it handles fees, refunds, multi-currency and chargebacks — that's where cheaper tools fall down. If you sell through a store, our guides on syncing Shopify and Xero and syncing WooCommerce with Xero cover the sales side that pairs with this.

Option 3: Zapier or Make

Zapier and Make connect to both PayPal and Xero and suit lightweight jobs — alerting your team to a large payment or a chargeback, say. They're poor at the core accounting job: by default they fire one action per event, which doesn't summarise to a payout and copes badly with fees and refunds. Use them as glue, not as your ledger sync. We weigh the trade-offs in Zapier vs Make vs custom integration.

Option 4: Custom integration

A custom build talks directly to the PayPal and Xero APIs, applying exactly your rules: how to summarise per settlement, which clearing accounts to use, how to map fees and FX, and precisely how to treat refunds and chargebacks. This is an API integration job — more on when it's worth it below.

Fees: keep revenue gross, post fees separately

PayPal deducts its fee from each transaction before the money reaches your balance. The temptation — and what the native feed nudges you towards — is to record only the net. Don't.

Your sale should read at the gross invoiced amount, with the PayPal fee posted to a "PayPal fees" or "merchant fees" expense account. Netting the fee off revenue understates your turnover and distorts your margins. A good app or custom feed does this split automatically; with the native feed you often end up adjusting it by hand.

Multi-currency: where PayPal gets genuinely hard

If you sell internationally, PayPal holds multiple currency balances and converts between them at its own rate, with a conversion spread baked in. This is where the native feed really struggles.

To handle it properly you need Xero's multi-currency feature (Established plan) and a clear approach to:

• Recording each sale in the currency it was made in.
• Capturing PayPal's conversion when you convert a balance or withdraw — including the spread, which is a real cost.
• Realised FX gains and losses when the rate moves between sale and settlement.

Most native-feed setups quietly mishandle this, leaving small unexplained differences that compound. A multi-currency-aware app, or a custom feed that reads PayPal's actual conversion figures, is usually necessary once you trade in more than one currency. This is a data integration problem as much as an accounting one — getting the right numbers out of PayPal in the first place.

Refunds and chargebacks

Refunds and chargebacks flow back out through your PayPal balance, and they need to reverse the original sale and its VAT, not just be booked as an expense. Watch for:

• Refunds — these reduce income and reverse the output VAT on the original sale.
• Chargebacks/disputes — the disputed amount plus any PayPal dispute fee leaves your balance; the fee is a cost, the disputed amount reverses the sale.
• Partial refunds — common in e-commerce, and a frequent source of mismatches if your feed only handles full reversals.

Always test a refund end to end before you trust any setup.

Reconciling the PayPal balance to your bank

Here's the reconciliation that proves the whole setup works: your Xero PayPal account balance should equal your actual PayPal account balance at any point in time.

The flow is:

1. Sales, fees and refunds post into the Xero PayPal account (gross sale, less fee, less refunds).
2. When you withdraw from PayPal to your bank, record a transfer from the Xero PayPal account to your current account.
3. The withdrawal appears on your real bank feed and reconciles against that transfer.

If your Xero PayPal balance drifts from the real one, something's wrong — usually a missing fee, a duplicated sale, or an unrecorded currency conversion. That drift is your early-warning signal, so check it monthly.

VAT: the UK details that matter

• VAT is on the gross sale, not the net payout. Account for VAT on what the customer actually paid, before PayPal's fee is deducted.
• PayPal's fees are generally VAT-exempt, not standard-rated. PayPal's UK/EU payment-processing fees are typically treated as exempt financial services, so there's usually no input VAT to reclaim on them — unlike Stripe or GoCardless fees, which carry standard-rate UK VAT. Don't assume a fee figure includes VAT; check your PayPal statements and confirm the treatment with your accountant.
• Refunds and chargebacks reverse output VAT. Reverse the VAT on the original sale; don't just book the refund as a cost.
• Cross-border sales have their own VAT and place-of-supply rules that PayPal won't sort out for you — handle those at the sales-channel level.

When is a custom integration worth it?

Off-the-shelf apps cover most cases well. A custom build earns its keep when you outgrow them:

• High volume, where per-transaction app pricing hurts or you need smarter summarisation.
• Multi-currency complexity that standard tools handle clumsily.
• Multiple sales channels all paying via PayPal that must post consistently into one Xero file without duplicates.
• Operational coupling — the same pipeline should also update a CRM, trigger fulfilment, or feed a reporting warehouse.

A custom integration writes clean, settlement-matched entries on your exact rules. The cost is real — design, build and maintenance — so it makes sense once the cost of getting it wrong (overstated revenue, wrong VAT, hours of monthly reconciliation) exceeds the build. As an indicative UK market guide only — not a quote — a focused PayPal-to-Xero integration commonly sits in the low-to-mid five figures depending on flows and currencies; treat that as a range to sanity-check quotes against. There's often a sensible middle path: a dedicated app for the standard flow plus a small custom piece for the edge cases.

A practical rollout checklist

1. Set PayPal up as its own bank account in Xero, separate from your current account.
2. Map your accounts — sales, PayPal fees, refunds, FX gains/losses — before connecting anything.
3. Avoid double-counting — decide whether the sale is recorded by your sales channel or by PayPal, never both.
4. Pick the lightest method that fits — native feed only if PayPal is your sole, low-volume sales record; an app otherwise.
5. Confirm fees post separately and revenue stays gross.
6. Check the PayPal balance reconciles to your real PayPal balance.
7. Test a refund and a currency conversion end to end, including the VAT reversal.
8. Run a parallel month before you trust it.

How APIwise can help

Connecting PayPal to Xero is rarely the hard part — getting it to reconcile cleanly, with fees split out, multi-currency handled, refunds reversing VAT, no duplicates and the PayPal balance matching to the penny, is. As the UK's API and AI integration specialists, we're vendor-neutral: if the native feed or a dedicated app is right for you, that's exactly what we'll say. If your volume, currencies or multiple sales channels genuinely call for a custom build, we'll scope and price it up front, fixed.

The simplest next step is our fixed-price Integration Health Check — we review how your systems connect today, find the gaps and risks, and give you a clear, costed plan. Book your Integration Health Check and make your PayPal-to-Xero reconciliation something you never have to think about again.