PayPal Bank Reconciliation - Match Transactions, Fees and Withdrawals
Compare PayPal activity exports with bank deposits and review withdrawals, deductions, and source references locally in your browser.
Try with sample files | View sample report
Problem statement
PayPal mixes customer payments, refunds, processing fees, FX rows, holds, and withdrawals in one activity export. The bank deposit is only the final withdrawal, so the activity has to be separated before the cash movement makes sense.
Numeric example
| Line item | Amount |
|---|
| Customer payments | $3,440.00 |
| Refunds | -$180.00 |
| Processing fees | -$101.40 |
| Currency adjustment | -$24.60 |
| Bank withdrawal | $3,134.00 |
Why the numbers do not match
- Processing fees reduce the available balance before the withdrawal is sent.
- Refunds and disputes may be deducted from a later withdrawal batch.
- Currency conversion can change the amount that reaches the bank.
- Held funds can delay part of the balance before it becomes withdrawable.
- Manual withdrawal timing means bank dates rarely line up with payment dates.
What files to export
- PayPal activity export with payments, refunds, fees, withdrawals, transaction IDs, and currencies.
- Bank statement export with deposit date, amount, and description for PayPal withdrawals.
- Order or invoice export with customer-facing references that help connect PayPal activity to source rows.
Manual workflow
- Separate the PayPal activity into payments, refunds, fees, currency rows, and withdrawals.
- Calculate the net PayPal movement for the withdrawal batch you are reviewing.
- Match the withdrawal batch to the bank deposit instead of matching customer payments directly to the bank.
- Trace customer payments to orders or invoices by transaction ID and reference where available.
- Keep currency conversion and hold rows separate from normal processing fees.
Common mistakes
- Matching customer payments directly to bank deposits instead of starting from the withdrawal batch.
- Treating FX rows and holds as if they were normal processing fees.
- Ignoring refunds that reduced a later withdrawal rather than the original payment.
- Marking an unresolved withdrawal as final before the activity export is fully separated.
How Reconcile Locally helps
- Keeps PayPal activity, withdrawal rows, and bank deposits visible in one file-based review flow.
- Separates matched withdrawals from amount differences and unknown bank payments.
- Shows which customer payments still need a manual reference check.
- Exports a report you can keep with the final reconciliation package.
What still needs manual review
- Some PayPal exports still need manual review because transaction references and balance timing are not fully standardized.
- Mixed-currency workflows may require another export before the full difference is explained.
- Rows with weak withdrawal support should stay in review instead of being forced into a match.
Content review and sources
Written and reviewed by the Reconcile Locally product team. Last reviewed June 7, 2026.
Guidance is checked against current product behavior and first-party documentation where available. Reconciliation results still require human review.
Frequently asked questions
Should I match PayPal customer payments directly to bank deposits?
Usually no. Match PayPal withdrawals to the bank first, then reconcile the activity inside the PayPal balance.
What should I do with PayPal processing fees?
Keep them in their own review category so gross customer payments and net bank withdrawals can both be explained clearly.