PayPal bank feed for Xero: import PayPal statements as a live feed
Xero offers a PayPal direct feed, but it runs one currency per feed, imports only completed, cleared or reversed transactions, and turns balance conversions into transfers it cannot match. StatementClear posts the same PayPal exports into Xero as live feed lines, deduped and balance-checked.
The PayPal balance that never quite matches Xero is a monthly tradition. The native PayPal feed helps, but it is one currency per feed, it skips zero-value and pending transactions, and conversions between your currency balances arrive as transfers Xero cannot match - so the gaps get filled by hand. Upload the same PayPal exports and StatementClear posts them into Xero as a live bank feed, deduped and balance-checked, ready to reconcile.
Where the native PayPal feed falls short
Xero offers a PayPal direct feed, but it is single-currency per feed, only imports non-zero transactions with a completed, cleared or reversed status, and turns conversions between currency balances into transfers it cannot match. The gaps still get filled by manual import.
PayPal's activity export puts Gross, Fee and Net on the same row, while the balance only ever moves by the net - map the gross without the fee and your running balance drifts on every single sale. Currency conversions appear as two or three linked rows, money out of one currency and into another, which is why they refuse to match anything in Xero. The export itself has quirks worth knowing: history goes back seven years but only twelve months per request, CSVs cap at 50,000 rows before splitting into a ZIP, and the status column mixes completed, pending and reversed activity. The Balance column is your friend - it is what StatementClear checks your mapped amounts against before posting.
The manual way, every month
- Log in and export a statement (and hope the format didn't change)
- Reformat columns, dates and signs until Xero's importer accepts it
- Upload the CSV into the right account and pray nothing doubled up
- Eyeball the balance, fix what broke, repeat next month
And after all that, it still isn't a feed - it's a one-off import you'll redo next month.
The StatementClear way: a real feed
Upload the statement and it posts into Xero as a live bank feed through Xero's Bank Feeds API - deduped, balance-checked and ready to reconcile. Not another file to import. Converters hand you a CSV; this arrives in Xero the way a bank feed does.
- Step 1
Connect Xero
Link your org and pick the account that has no feed.
- Step 2
Upload your PayPal statement
PDF, CSV or Excel - whatever you can export. Map the columns once and we remember the mapping.
- Step 3
We check it first
Duplicates are skipped, the running balance is verified, and sign errors are caught before anything posts.
- Step 4
It lands as a feed
Clean lines arrive in Xero through the Bank Feeds API, ready to reconcile.
Questions about PayPal and Xero
Related accounts
Stop importing PayPal statements. Start feeding them.
Tell us how your PayPal setup is structured and we'll get you connected.
Browse every bank and platform or read the Xero bank feed guides.