PayPal Statement to Excel: Gross, Fees and Net

TL;DR For PayPal in Excel, start with PayPal's activity download (CSV) where you can, because it splits each transaction into gross, fee and net. Use monthly statement PDFs when you need the official monthly summary or when the download isn't available. In the spreadsheet, keep gross and fee separate, treat transfers to your bank as transfers rather than income or spending, convert foreign currency lines carefully, and check that the opening balance plus net activity equals the closing balance. Then match each PayPal transfer to the deposit on your bank statement.

PayPal sits awkwardly between a bank account and a payment processor. Freelancers get paid through it, online sellers take orders through it, and plenty of people use it to buy things, sometimes funded by a card, sometimes by a bank account, sometimes by a PayPal balance. That mix is exactly why PayPal activity is harder to get into a spreadsheet than an ordinary bank statement. One sale can create several lines, fees are deducted before the money lands, and the money then moves again when you transfer it out.

This guide explains how to get PayPal activity into Excel in a form you can actually use: for bookkeeping, for tax preparation, or just to know what you earned and spent. We describe PayPal's screens in general terms, because menus and report names change over time.

Two sources: activity download and statements

The activity download is a report you can generate for a date range, usually as CSV. It's generally the richest source: each line typically includes date, time, name, type, status, currency, gross, fee, net, and a transaction ID, with more columns available depending on the options you choose. For bookkeeping, this is usually what you want.

Monthly statements are PDF summaries of each month's activity and balances. They're useful as an official record, and they're what some lenders or reviewers ask for. They're also the fallback when you only have PDFs, for example records saved years ago or sent to you by someone else.

If you have both, use the download for the detail and the statement for the official opening and closing balances. If you only have PDFs, convert them with a tool that keeps the gross, fee and net amounts in separate columns, then work with them the same way.

Why one PayPal payment becomes several rows

PayPal records more events than a bank does. Depending on the transaction, you may see:

• The payment itself: a sale, a payment received, or a purchase.
• A fee: often shown in a fee column on the same row, sometimes as its own row.
• A currency conversion: two rows, one in each currency, when money is converted.
• A funding row: when a purchase is funded from a linked bank account or card rather than your balance, there may be a row for the money coming in from that source.
• Holds and releases: money placed on hold and later released.
• Transfers: money moved to or from your bank account.
• Refunds and reversals: sometimes with a partial fee refund.

If you add up every row without thinking, you'll double-count. The trick is to understand which rows affect your PayPal balance and which are informational, and to keep your categories honest.

The layout to aim for

Whatever source you start from, aim for one table with these columns:

The fee in the example is illustrative, not a statement of PayPal's rates, which vary by transaction type and country.

Keep all three amount columns. Net is what hits your PayPal balance. Gross is what you earned or spent. Fee is a cost in its own right.

Clean the download

A PayPal CSV opens in Excel easily, but expect some tidying.

1. Convert dates. Depending on your region settings, dates may be day-first or month-first, and may sit alongside a separate time column. Make sure the Date column is real dates. Our guide to fixing bank statement dates in Excel covers locale problems.
2. Convert amounts. Amounts may come through as text, with thousands separators or in a format that depends on your region. Use NUMBERVALUE to convert them reliably.
3. Filter by status. Pending, denied or cancelled transactions don't affect your completed balance in the same way. Decide which statuses you include, usually completed ones only.
4. Remove informational rows. Rows that record holds or authorizations without changing the balance can distort totals. Check the Balance Impact column if your report includes it, and only total rows that actually move the balance.
5. Turn the range into a table named PP so formulas read cleanly.

Our guide to cleaning bank statement data in Excel has more general cleanup techniques.

Prove the balance

As with any statement, check the math before you rely on it. For one currency:

=ROUND(OpeningBalance + SUMIFS(PP[Net], PP[Currency], "USD") - ClosingBalance, 2)

Use the opening and closing balances from the monthly statement or the report summary. The result should be zero.

If you hold several currencies, check each one separately. PayPal keeps separate balances per currency, so a USD line and a EUR line can't be added together.

If the check fails:

• The difference equals a hold or a pending payment: you've included a row that didn't yet affect the balance, or excluded one that did.
• The difference equals a fee: a fee row was double-counted or missed.
• The difference matches a conversion: one side of a currency conversion is missing.

The free balance checker is a quick way to confirm the totals.

Currency conversions

When money changes currency inside PayPal, you'll typically see two linked rows: one reducing the balance in the original currency, one increasing the balance in the new currency. For reporting in your home currency:

1. Keep both rows, so each currency balance is complete.
2. In a Home Amount column, use the converted amount for the row in your home currency.
3. For rows that stayed in a foreign currency, convert at a rate your accountant agrees with, and note the rate and its source.

Don't treat the conversion rows as income or spending. They're movements between your own balances. The difference between the rate you got and a reference rate is a cost, and some bookkeepers record it separately. Ask your accountant how they want it handled.

Transfers to your bank account

When you transfer money from PayPal to your bank, it leaves PayPal as a negative row and arrives on your bank statement as a deposit, usually a few days later. That deposit is not income. The income was the original sales. If you count both, you count it twice.

Match each transfer to the bank deposit:

=XLOOKUP(G2, Bank[Amount], Bank[Date], "Not found", 0)

where G2 is the transfer amount with its sign flipped. Add a few days of tolerance when you compare dates. Anything marked "Not found" needs a look: a transfer still in progress at month-end, a reversal, or a deposit that was combined with something else. Our guide to reconciling Stripe payouts to a bank statement uses the same matching approach, and it applies to PayPal too.

Categorizing PayPal activity

A simple category scheme that works for most freelancers and small sellers:

Personal purchases made through the same account should be marked clearly so they're excluded from business figures. Our guide to categorizing business expenses from bank statements has a fuller category list, and Excel formulas to categorize transactions shows how to automate it with a rules table.

Getting PayPal into accounting software

Most accounting packages treat PayPal as its own bank-type account. The idea is that PayPal has a balance like any account, and transfers to your bank are transfers between two of your accounts.

• Gross plus fee. Record sales at gross, with the fee as a separate expense line, so the net matches PayPal's balance movement. Many CSV importers only accept one amount per line, so you may need to split each sale into two rows, gross and fee, before importing. A short formula-driven sheet that stacks the gross rows and the fee rows does this.
• QuickBooks Online. Set up PayPal as a bank account and import CSV. See our guide to importing into QuickBooks Online.
• Xero. Same idea, with Xero's CSV layout. See the Xero CSV import format.

Some accounting packages also offer direct PayPal connections. Even then, a CSV from the activity download is useful for backfilling older months or fixing gaps.

A worked example

A freelance illustrator gets paid by clients through PayPal, buys a couple of software subscriptions with it, and transfers money to her bank account every couple of weeks. She wants June's figures for her bookkeeping.

1. Download. She generates an activity report for June as CSV and saves the June monthly statement PDF for the official balances.
2. Clean. She converts dates and amounts, keeps completed rows only, and checks the balance impact column to drop informational rows.
3. Balance check. Opening balance plus the sum of net equals the closing balance. Zero.
4. Categorize. Four client payments go to income at gross, their fees to processing fees, two subscriptions to software, and two transfers to Transfer.
5. Bank match. Both transfers appear as deposits on her bank statement a few days later. She marks the bank deposits as transfers from PayPal.
6. One EUR payment. A European client paid in euros, which she converted. She keeps both conversion rows, records the USD amount she actually received, and notes the conversion.
7. Summary. Income at gross, total fees, expenses, and net change in balance all tie together.

Her income figure is the gross of the four payments, not the total of the bank deposits, and her fees are recorded as an expense rather than disappearing.

Working from PDF statements only

If all you have are PDFs, the process is similar, but you start with a conversion step. Make sure the converter keeps gross, fee and net as separate columns rather than flattening them to a single amount. SheetStatement converts statement PDFs to Excel or CSV with a balance check, and the same checks above apply once you have rows. The free plan covers 3 pages a month, and Starter ($9), Pro ($19) and Business ($39) monthly plans cover more.

A monthly summary that ties out

Once a month is categorized, a small summary sheet shows that everything ties together. Build it with SUMIFS against the table:

The two closing balances should match. If they don't, a category is catching rows it shouldn't, or a row has no category at all. A quick =COUNTBLANK(PP[Category]) finds uncategorized rows.

Laid out this way, the summary also answers the questions people actually ask: how much did I earn before fees, how much did PayPal keep, and how much did I move to the bank. Copy the sheet for each month, or turn it into a pivot table with Month as a column. Our guide to bank statement pivot tables shows the pivot approach.

Online sellers: refunds, disputes and shipping

Sellers see more transaction types than freelancers. A few habits help.

Refunds. A refund sent to a buyer reduces income. Depending on the transaction and the rules that apply at the time, some or all of the original fee may or may not come back. Record whatever the report shows rather than assuming either way.

Disputes and chargebacks. Money can be held or taken back while a dispute is open, and returned if it's resolved in your favour. Track these with a Dispute category and a note with the transaction ID, so a reversal and its later release cancel out cleanly.

Shipping labels and other platform charges. If you buy shipping labels or other services through PayPal, they appear as purchases. Categorize them as cost of sales or shipping rather than lumping them in with general purchases.

Sales platforms. If your sales come through a marketplace that pays out via PayPal, the marketplace's own reports are the place to find order-level detail. PayPal shows the payouts; the marketplace shows what's inside them.

Tax considerations

Payment platforms may report payment activity to tax authorities, depending on your country and the platform's own rules. If you receive a form from PayPal, the figure on it is usually based on gross payments, which is one more reason to keep gross and fees separate. Our guide to reconciling a 1099-K with bank deposits covers that reconciliation for US taxpayers. This is general information, not tax advice; ask a qualified tax professional about your situation.

Troubleshooting

Totals are far too high. You're probably counting funding rows, holds or both sides of a conversion. Filter to rows that affect the balance.

Balance won't tie out. Check each currency separately and confirm which statuses you included.

Bank deposits don't match transfers. A transfer near month-end may land in the next month on the bank. Allow a few days, and look for reversed transfers.

Duplicate rows after combining reports. Overlapping date ranges. Remove duplicates by Transaction ID, which is unique for each event.

FAQ

Should I use PayPal's CSV download or the PDF statement?

Use the CSV activity download for detail, because it includes gross, fee, net and transaction IDs. Use the monthly statement for official balances, or convert it when it's the only record you have.

Why does one payment show up on several rows?

PayPal records related events separately: the payment, fees, currency conversions, funding from a linked account and holds. Only some rows change your balance. Check the balance impact and status columns.

Are transfers to my bank income?

No. The income was the original payments. A transfer is a movement between your own accounts. Mark both the PayPal row and the bank deposit as a transfer.

How do I handle PayPal fees?

Record sales at gross and the fee as a separate expense, so the net amount matches the change in your PayPal balance.

How do I handle foreign currency?

PayPal keeps separate balances per currency. Balance-check each currency on its own, and record converted amounts in your home currency using the conversion rows or a rate your accountant agrees with.

Can I import PayPal into QuickBooks or Xero?

Yes. Treat PayPal as a bank-type account and import CSV. Split sales into gross and fee lines if your importer only takes one amount per row.

Is it safe to upload statements?

See the security page for how SheetStatement handles uploads, and review any service's policy before uploading financial documents.

How much does SheetStatement cost?

The free plan includes 3 pages a month. Starter is $9 a month, Pro $19 and Business $39.