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 or QuickBooks handoff 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.
When should I use the PayPal QuickBooks workflow next?
Use it after the withdrawal batch is explained well enough to support an accounting handoff. First prove the PayPal withdrawal, then decide how the QuickBooks bank entry should be reviewed or cleared.
What if the PayPal payments came from Shopify orders?
Keep the withdrawal-first PayPal review, then use the Shopify order export as supporting context. The Shopify PayPal workflow is the right next step when the gateway explains the cash movement better than Shopify payouts alone.
When should I use the PayPal withdrawal example instead of this guide?
Use the example when you want one worked withdrawal batch from activity rows to the bank deposit. Use this guide when you need the broader withdrawal workflow, export separation rules, and downstream handoff path.
When should I use the PayPal fees and refunds page instead of this guide?
Use the fees-and-refunds page when the withdrawal-first workflow is already clear and the remaining work is to explain explicit fee rows, refunds, FX effects, or an open amount difference. Use this guide when you still need the broader withdrawal workflow first.