Start with PayPal's built-in export
Before converting anything, check whether PayPal can give you a CSV directly. Log in and go to your Activity page, then look for the Download or Statements option. PayPal lets you export transaction activity as a CSV (comma-separated values) file for a chosen date range.
On the download screen you can usually pick a file type and a report format. Choose CSV and select the transaction type — a full activity report typically includes gross amount, PayPal fee, net amount, currency, and a transaction ID. This is the cleanest source because the fields are already separated for you.
There are two common documents people confuse. The monthly PDF statement is a formatted summary meant for reading. The activity report or transaction history is the data export. If you only need numbers for your books, the activity report in CSV format saves you a conversion step entirely.
When you only have a PDF statement
Sometimes you inherit a PDF — a client emails last quarter's statement, or you download a monthly statement rather than the activity report. PDFs aren't structured data, so copying and pasting usually scrambles columns and merges fee lines into descriptions.
A conversion tool reads the PDF layout and rebuilds the rows into proper columns: date, description, gross amount, fee, and net. Upload the PDF, review the parsed output, and export to CSV or Excel. This avoids the manual retyping that introduces errors during reconciliation.
If your statement spans several months or currencies, convert each period separately or keep a currency column intact. Mixing currencies in one amount column without a marker will throw off any totals you calculate later.
Clean the CSV before you import it
A raw PayPal export often carries columns you don't need and a few that matter a lot. Keep date, name or description, gross, fee, net, currency, and the transaction ID. The transaction ID is your anchor for matching payments to invoices or refunds.
Watch the fee handling. PayPal reports the fee as a separate negative line or column, and the net is gross minus fee. In your books you generally record the gross sale as income and the fee as an expense, so keep both figures rather than only the net deposit.
Check date formats and decimal separators, especially if you operate outside the US. A date read as day-month-year in one system and month-day-year in another will silently misfile transactions. Standardize to one format before importing.
Import into accounting software
QuickBooks Online, Xero, and Wave all accept CSV bank imports. The general workflow is the same: open the banking or transactions area, choose the import or upload option, select your CSV, then map your columns to the software's fields — date, description, amount, and sometimes separate debit and credit columns.
QuickBooks and Xero often expect debits and credits split, or a single signed amount column. If your PayPal export uses positive for money in and negative for money out, most tools handle that once you tell them which column is the amount. Save your column mapping so future imports go faster.
Wave and other tools follow similar steps. Whichever you use, import one period first, confirm the running balance matches your statement, then bring in the rest. Reconciling in small batches makes it far easier to spot a duplicate or a misread fee.