How to Download a PayPal Statement (and Turn It into a Spreadsheet)

PayPal acts like a bank account for many freelancers and small businesses, so when it is time to do your books, file taxes, or reconcile income, you need the underlying records. This guide covers how to download a PayPal statement or activity report, the formats PayPal offers, how to choose the right date range, and how to turn the file into a clean spreadsheet. (Menu labels can change and differ between personal and business accounts; treat these as the typical steps.)

What PayPal gives you: PDF vs CSV

PayPal generally offers two kinds of downloads, and they serve different purposes.

• PDF statements / reports are formatted documents meant for reading, filing, or sending to an accountant or lender. They look tidy but are hard to analyze directly.
• CSV (or other spreadsheet) activity downloads export your transactions as raw rows — dates, amounts, fees, names, and references. This is the format you want for bookkeeping, because you can sort, filter, and total it.

If your goal is analysis or import into accounting software, reach for the CSV-style activity download. If you just need a document for your records, the PDF is fine.

Download a statement on the web (desktop)

The web dashboard usually gives you the most options, so start there if you can.

1. Sign in to your account in a browser.
2. Open the Activity section, or look for a Reports, Statements, or Documents area (business accounts often have a dedicated reporting hub).
3. Choose the type of download you want — a formatted statement/report, or an activity export.
4. Pick the date range for the period you need (more on this below).
5. Select the format (PDF for a document, CSV for data).
6. Generate or download the file. Larger date ranges may be prepared in the background and emailed or made available for download a few minutes later.

What about the mobile app?

Downloading a full statement or activity report is most reliably done on the PayPal website from a desktop browser, which is where the statement and reporting tools live. The mobile app's options are more limited: you can view your activity, and you may be able to view, share, or save the details of an individual transaction, but the app is not the place to generate a full statement or a complete CSV activity report.

If you need a full statement or a CSV export across a custom date range, use the website rather than the app.

Choosing the right date range

Getting the period right the first time saves a lot of rework.

• Match your accounting period. Pull a full month, quarter, or tax year so totals line up with your books.
• Mind the boundaries. Use the first and last calendar day of the period so nothing falls through the cracks between two exports.
• Watch export limits. Very long ranges can be slow or capped. If a year fails, pull it month by month and combine the files later.
• Keep currency in mind. If you receive money in more than one currency, your export may list each currency separately — note that before you start totalling.

Why the raw download still needs cleanup

A PayPal activity export is more useful than a PDF, but it is rarely ready to drop straight into accounting software. Common issues:

• Gross, fee, and net typically appear as separate columns, so each payment is one row with its fee detail spread across those columns — you usually need to pick or rename the columns your bookkeeping tool expects rather than merge rows.
• Transfers to your bank show up alongside sales, which can double-count income if you are not careful.
• Refunds, holds, and reversals need to be netted out.
• Column headers may not match what your bookkeeping tool expects on import.

For PDF statements the problem is bigger: there is no structured data at all until you extract the transaction table out of the document.

Turn the statement into a clean spreadsheet

Whether you started from a PDF statement or a messy CSV, the goal is the same — a tidy table of dated transactions with consistent columns you can total and import.

If you downloaded a PDF, you need to pull the transactions out of the document first. The fastest path is to drop the file into the free bank statement converter, which detects the transaction table and exports clean rows to Excel or CSV. For the manual alternatives and their trade-offs, see how to convert a bank statement to Excel.

If you downloaded a CSV, open it in your spreadsheet app and tidy it up:

1. Delete summary or header rows that are not transactions.
2. Standardize the date column to a single format.
3. Decide how to handle fees — keep gross and fee in their own columns, or compute net per row.
4. Separate withdrawals to your bank from actual income so you do not double-count.
5. Save as XLSX if you want formulas and formatting, or CSV if you are importing into accounting software.

A repeatable monthly routine

If you reconcile PayPal every month, settle on one approach and repeat it: download the same report type for the same kind of date range, run it through the same cleanup steps, and keep the original download as your source document. Once the columns are mapped the way your accounting tool likes them, each month becomes a quick, predictable task instead of a fresh puzzle.

The key takeaway: download the CSV activity export when you need data, the PDF when you need a document, match the date range to your accounting period, and clean the file before it touches your books.