Skip to content
StatementClear
Start a free trial

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.

Start a free trial

14 days, no card. Connect Xero and post a real statement before you decide anything.

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.

  1. Step 1

    Connect Xero

    Link your org and pick the account that is missing transactions.

  2. Step 2

    Upload your PayPal statement

    PDF, CSV or Excel - whatever you can export. Map the columns once and we remember the mapping.

  3. Step 3

    We check it first

    Duplicates are skipped, the running balance is verified, and sign errors are caught before anything posts.

  4. 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

For everything the native feed leaves behind: currency balances beyond your primary one, history from before the feed was connected, and the transactions it skips outright, such as zero-value and pending items. You export the activity from PayPal as usual, upload it, and StatementClear posts it into Xero as feed lines rather than another manual import. It also covers PayPal accounts that cannot get the native feed at all.

You map the columns once and StatementClear saves the mapping for that feed. Before posting, it recomputes the running balance from your mapped amounts and compares it against PayPal's Balance column - the classic gross-versus-net mistake shows up immediately as a balance mismatch, before a single line reaches Xero.

Statements are encrypted in transit and at rest, and we never sell your data. StatementClear uses your export for one thing: posting feed lines into your Xero organisation through the Bank Feeds API. That is the whole data flow.

Fine, and expected - PayPal's twelve-months-per-request limit makes overlaps almost inevitable on a backfill. StatementClear deduplicates on upload, so lines it has already posted are dropped, and the running-balance check confirms the account still tracks after every upload.

Where this comes from

Everything above about what Xero's native feed covers, what its manual import accepts and how feed lines reach a bank account comes from Xero's own documentation. The relevant pages are below, so you can check the claim rather than take it.

  • About bank feedsXero's own account of which feeds exist, how they connect and what they do not cover.
  • Import a CSV bank statementThe manual import: the formats it accepts, and how it handles lines it has seen before.
  • Bank Feeds API overviewThe interface StatementClear posts through, and the reason a fed line is not an imported one.

Related accounts

Stop importing PayPal statements. Start feeding them.

Connect Xero, drop in a PayPal statement, and watch the lines arrive as feed lines.

Start a free trial

14 days, no card. Connect Xero and post a real statement before you decide anything.

Browse every bank and platform or read the Xero bank feed guides.