How to import a PayPal, Venmo, or Cash App statement into QuickBooks or Xero

PayPal, Venmo, and Cash App aren't banks in a technical sense, but for the freelancers and small businesses that get paid through them, they might as well be. And they all have the same problem: their built-in CSV export stops working after roughly 90 days. Anything older comes as a PDF statement, and QuickBooks and Xero don't read PDFs.

This guide covers the full workflow. Convert the PDF to a proper accounting-ready file, import it into QuickBooks Online or Xero, and reconcile — usually about ten minutes per month of history.

Why the native exports fail you

Each of these platforms deliberately limits historical exports:

• PayPallets you export the last 3 months as CSV. Older months are available only as PDF statements. If you're doing tax prep in March for last year, the useful months are all PDF-only.
• Venmo caps CSV downloads at 90 days. For business use, you almost always want more than 90 days.
• Cash Appshows recent activity in the app but the only reliable long-term record is the PDF statement, downloaded from the “Statements” screen.

None of this is accidental. Every platform's business incentive is to keep your money in their walled garden, not to make it easy to reconcile against external systems.

The short version of the workflow

1. Download the monthly PDF statements you need from PayPal, Venmo, or Cash App.
2. Drop each one into our converter. Pick the QuickBooks (.qbo) tab for QuickBooks, or the Xero tab for Xero.
3. Import the file into QuickBooks (as a bank feed for the PayPal / Venmo / Cash App account) or Xero (via bank statement import).
4. Reconcile against your records.

Setting up the account in your accounting software

If you haven't already, add PayPal, Venmo, or Cash App as an account in QuickBooks or Xero. Treat it as a bank account (not a credit card) — because from an accounting perspective, that's what these platforms are: an asset account with a running balance you can deposit into and withdraw from.

In QuickBooks Online: Accounting → Chart of Accounts → New → Bank. Name it something clear like “PayPal Business” or “Venmo Business.”

In Xero: Accounting → Bank accounts → Add Bank Account → Add it anyway. Pick “Other” if it's not on the connection list.

The sign convention

Payment platform statements follow the same sign convention as bank statements: positive = money in, negative = money out. Money out includes:

• Payments you send
• Transfers to your linked bank account
• Platform fees (e.g. PayPal's 2.9% + 30¢)
• Refunds you issue

This is the same convention accounting software expects for bank accounts — so no sign flipping is needed. Our converter detects that it's a payment platform statement and applies this convention automatically.

Fees: the thing everyone gets wrong

Here's the most common mistake with payment platform bookkeeping: treating the gross amount as revenue and forgetting the fee.

If you invoice a client $100 through PayPal, PayPal takes about $3.20 in fees and deposits $96.80 in your account. If you record $96.80 as revenue, you're under-reporting. The correct treatment:

• Revenue: $100 (the gross)
• Payment processing fee (expense): $3.20
• Net to your account: $96.80

Statements from these platforms usually show both the gross amount and the fee as separate line items — good extraction preserves both. Our converter extracts each fee as its own transaction so you can categorize it properly in QuickBooks or Xero.

Import step-by-step: QuickBooks

With your PDF converted to .qbo:

1. In QuickBooks Online: Transactions → Bank transactions → Upload transactions.
2. Pick the .qbo file → select your PayPal/Venmo/Cash App account.
3. Continue. Transactions appear in For Review.
4. Match, categorize, and confirm. Use consistent categories for the fees so year-end reporting is clean.

Import step-by-step: Xero

1. In Xero: Accounting → Bank accounts → click the PayPal/Venmo/Cash App account.
2. Manage Account → Import a statement → upload the Xero-format CSV from the converter.
3. Confirm the date format (YYYY-MM-DD if you used our default) and the column mapping.
4. Save. Transactions appear as Awaiting Match.
5. Reconcile against your bills, invoices, and other transactions.

The multi-currency case: Wise and Stripe

Wise and Stripestatements sometimes include transactions across multiple currencies. If that's you, set up separate accounts in QuickBooks/Xero per currency, and split the extracted file by currency before importing. Both accounting tools support multi-currency but each expects a single currency per bank account.

Backfilling a year of history

For freelancers doing catch-up bookkeeping: download 12 monthly PDF statements, convert 12 times, upload 12 .qbo files. About 30 minutes of work for a full year — replacing what would otherwise be hours of typing or copy-pasting.

See our 1099-K tax workflow guide for what to do with the imported data at tax time.