How to Convert a PayPal Statement to Excel: The Complete Guide

You have a PayPal account. You need to convert the statement to Excel.

This page is the PayPal statement conversion guide. It covers the two download formats, the fee handling, the currency conversion, the business vs personal distinction, and the conversion step-by-step. The details are below.

PayPal offers two download formats: PDF (the official monthly statement) and CSV (the transaction history). The PDF is the document PayPal sends by email at the end of each month.

The CSV is downloadable from the PayPal account under “Activity” → “Statements” → “Custom date range.” The CSV is usually easier to work with because it preserves the gross, fee, and net amounts as separate columns.

PayPal statements have three columns most bank statements do not: Gross, Fee, Net. The conversion must preserve all three. Recording only the Net amount loses the fee data. Recording only the Gross amount overstates the revenue. The CSV handles all three. The PDF requires extra work to extract the fee structure.

PayPal is one of 5 non-bank sources covered in our other statements conversion guide, which maps the download flow for each. The conversion step is similar to a bank statement, with extra handling for fees and currency.

What PayPal Actually Gives You

PayPal offers 2 download formats for personal and business accounts. The choice depends on what you need: PDF for the official record, CSV for the raw data.

What most guides miss about Excel conversion is that the quality depends on the mechanism, not on the tool. Two tools that look different on the surface often run the same 4-step process underneath: read, find, parse, verify. The difference is in how well each step handles edge cases (merged cells, missing balances, non-standard date formats, scanned vs digital input). Choosing between tools based on UI alone misses the actual quality lever.

The PDF statement is the official monthly document. It shows every transaction in the period, with the date, description, gross amount, fee, and net amount. The PDF is what PayPal emails at the end of each month. The format is consistent across personal and business accounts. The PDF is 2 to 10 pages depending on the volume of transactions.

The CSV download is the raw transaction data. It has the same columns as the PDF, plus a few more: Transaction ID, Reference ID, Balance, Type. The CSV is downloadable from the PayPal account under “Activity” → “Statements” → “Custom date range.” The CSV is the better format for accounting because it preserves all the columns without manual extraction.

Personal vs Business PayPal

PayPal personal accounts and business accounts have different statement formats. Personal accounts show only the net amount (the gross minus the fee is already deducted). Business accounts show the gross, fee, and net as separate columns.

For most self-employed people who use PayPal for business, the account is a business account. The statement shows the fee structure. The conversion handles the fee structure by preserving the gross, fee, and net as separate columns in the output file.

For personal users who use PayPal only for personal transactions (sending money to friends, receiving money for personal sales), the statement is simpler. There is no fee for “Friends and Family” transactions. The statement shows the net amount only.

International Transactions and Currency Conversion

PayPal handles international transactions with automatic currency conversion. The customer pays in their currency. PayPal converts to your currency at the time of the transaction. The exchange rate is on the statement.

The statement shows the original currency amount, the exchange rate, and the converted amount. The exchange rate gain or loss is the difference between the rate at the time of the transaction and the rate at the time of the payout. The gain or loss is a separate line item on the statement.

For the conversion, the original currency and the converted currency should both be preserved. The exchange rate is usually implicit (you can derive it from the two amounts), but the original currency helps with the bookkeeping.

How to Download a PayPal Statement Step by Step

The PDF download is in the “Statements” section. The CSV download is in the “Activity” section. Here is the click-by-click flow for each.

1. Log into PayPal with your email and password.
2. Click “Activity” or “Statements” in the navigation.
3. For PDF: Click “Statements” → “Monthly statements” → select the month → click “Download” → choose PDF.
4. For CSV: Click “Activity” → “Statements” → “Custom date range” → set the start and end dates → choose “Comma Delimited – All Activity” → click “Download.”
5. Save the file to your computer.

The PDF download is the official document. The CSV download is the raw data. For most accounting purposes, the CSV is better. The CSV has all the columns the PDF has, plus the Transaction ID and Reference ID, which are useful for matching against invoices.

How to Convert PayPal PDF to Excel

The PDF conversion is harder than the CSV. The PDF has the transaction list in a tabular format, but the columns are nested: each row has a description, then sub-rows for the gross, fee, and net. The converter needs to recognize this nested structure.

A good converter reads the PayPal PDF and produces an Excel file with the same columns as the CSV: Date, Description, Gross, Fee, Net, Balance, Type, Transaction ID. The conversion takes 5 to 10 seconds per month. The output is clean. You can open it in Excel and start working with the data immediately.

For the broader conversion workflow, our general PDF-to-Excel conversion guide covers the 5-point validation check and the 3 things to do after every conversion. The PayPal-specific challenge is the fee structure. The validation check should include a sample transaction where the gross minus the fee equals the net.

Converting PayPal CSV to Excel

The CSV is already in spreadsheet format. The conversion is just opening the CSV in Excel and saving as XLSX. The CSV has all the columns the PDF has, plus a few more. The date format is YYYY-MM-DD. The amount format is the original currency (no currency conversion in the CSV). The fee is a separate column.

For the conversion, open the CSV in Excel. Verify the first 5 transactions: Date, Description, Gross, Fee, Net. The Net should equal the Gross minus the Fee. If the columns are misaligned, the conversion needs to be redone. Save as XLSX for the final file.

The 2am Test for PayPal Conversions

If you are converting a PayPal statement at 2am because the tax deadline is tomorrow, here is the flow that works.

1. Log into PayPal. Click “Activity” → “Statements” → “Custom date range.”
2. Set the date range to the tax year. Choose “Comma Delimited – All Activity.” Click “Download.”
3. Open the CSV in Excel. The CSV is already in spreadsheet format. Save as XLSX.
4. Verify the first 5 transactions: Date, Description, Gross, Fee, Net. The Net should equal Gross minus Fee.
5. Add a “Source” column. Mark every row as “PayPal.” This helps with the consolidation across all sources.
6. Add a “Category” column. Mark each transaction as Income, Expense, Transfer, or Refund based on the Type column.

If the conversion produces a file where the Net does not equal the Gross minus Fee, the conversion is wrong. Try a different converter. The fee structure is the most important part of the PayPal statement, and a bad converter will lose it.

What to Do With Multiple PayPal Accounts

If you have multiple PayPal accounts (personal and business, or multiple businesses), each account has its own statement, its own download, and its own conversion. The workflow is the same for each: download the CSV, convert to XLSX, add the Source and Category columns.

PayPal does not offer a combined statement feature. Each account is downloaded separately. The 24-month download limit applies per account.

For users managing many PayPal accounts, the combined approach is essential for tracking total revenue and fees for tax reporting. The CSV files have the same column structure across accounts, so combining is just an append. Add an “Account” column to identify which PayPal account each transaction came from. Our batch conversion guide covers the desktop converter setup that handles 100+ statements efficiently.

A common failure mode bookkeepers report is treating this as a single operation rather than a chain of dependent steps. The temptation is to find a tool that ‘just works’ and stop investigating the mechanism. The result is a wrong-fix cycle: the tool gives partial output, the bookkeeper spends 30+ minutes troubleshooting, the fix is for the wrong step, and the same error recurs on the next statement. The fix: identify which step failed and apply the right intervention to that step.

How PayPal Statements Compare to Bank Statements

PayPal statements and bank statements are similar in structure but differ in the columns. A bank statement has Date, Description, Amount. A PayPal statement has Date, Description, Gross, Fee, Net. The PayPal fee structure is the main difference.

For accounting purposes, the PayPal statement is a separate account. It does not replace the bank statement. The bank statement shows what hit the bank account. The PayPal statement shows what happened in PayPal. The two are linked by the PayPal-to-bank transfer, which appears on both statements.

The transfer is a “Transfer” in the accounting category, not “Income” or “Expense.” If you record it as Income, you double-count the revenue. The fix: mark transfers as “Transfer” in the Category column. The bank statement and the PayPal statement both show the transfer, and the totals should match when you exclude transfers.

PayPal is one of 5 non-bank sources covered in our other statements conversion guide, which maps the download flow for each. For a broader view across all US banking entities, our bank-statement-converter guide covers the major banks, credit cards, and credit unions in one map.

The conversion step is the same regardless of whether the statement comes from a bank, PayPal, or a crypto exchange. The differences are in the column structure and the category handling. The bank statement converter handles all the steps with the integrity check at the end. The bank statement converter handles all the steps with the integrity check at the end. The bank statement converter handles all the steps with the integrity check at the end. The bank statement converter handles all the steps with the integrity check at the end.