PayPal Fees and Refunds Bank Reconciliation Guide
Review PayPal fees, refunds, withdrawals, and amount differences before matching the final bank deposit.
Try with sample files | View sample report
Problem statement
PayPal bank withdrawals rarely equal gross customer payments. Fees, refunds, disputes, currency conversion, and PayPal balance timing all affect the amount that reaches the bank, and the withdrawal is usually the only number visible in the bank statement.
Numeric example
| Line item | Amount |
|---|
| Customer payments | $3,440.00 |
| Refunds | -$180.00 |
| Explicit PayPal fees | -$101.40 |
| Possible FX or adjustment effect | -$24.60 |
| Bank withdrawal | $3,134.00 |
Why the numbers do not match
- PayPal fees can be explicit activity rows or part of the balance movement behind the withdrawal.
- Refunds can reduce a balance before the bank withdrawal.
- Withdrawals may include many payments from different dates.
- Currency conversion creates gross, fee, and net differences.
- PayPal balance movements can hide the timing between sale and bank deposit.
What files to export
- PayPal activity export with payments, fees, refunds, withdrawals, transaction IDs, and currencies.
- Bank statement export with PayPal withdrawal deposits, dates, and raw bank descriptions.
- Order or invoice file with customer-facing references to connect PayPal transactions to sales.
Manual workflow
- Filter PayPal activity into payments, fees, refunds, withdrawals, and transfers.
- Calculate the net PayPal movement for the withdrawal batch you are reviewing.
- Match withdrawals to bank deposits instead of matching individual customer payments directly to the bank.
- Trace customer payments to orders or invoices by transaction ID and reference.
- Keep currency conversion rows separate from explicit fee rows.
- Flag refunds, disputes, and cross-period effects that still need review.
- Leave the remaining gap as an amount difference or possible adjustment when the export does not fully prove the cause.
Common mistakes
- Matching customer payments directly to bank deposits instead of starting from the withdrawal batch.
- Calling every difference a fee when the export only proves a broader amount difference or adjustment.
- Letting refunds reduce the withdrawal without tracing which period they belong to.
- Mixing currency conversion rows into payment rows and losing the real withdrawal explanation.
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 review-ready report before you move into accounting or follow-up.
What still needs manual review
- Some PayPal exports still need manual review because balance timing and references 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 final 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
Which PayPal report should I export first?
Start with the PayPal activity export that shows payments, refunds, fees, withdrawals, and currencies. Then compare the withdrawal batch to the bank deposit.
What should I do when the export shows fees but the total still does not tie?
Keep the explicit fee rows visible, then leave the remaining gap as an amount difference or possible adjustment until another export proves the exact cause.
Can I reconcile this without connecting PayPal?
Yes. Export the PayPal activity file and the bank statement, then review the withdrawal batch locally in the browser without a direct connection.