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.
- Not every shortfall is provably one fee row, so some cases should stay as amount differences until another export confirms more.
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.
- Use amount-difference wording for any unresolved remainder unless the export explicitly labels the exact fee, refund, reserve, or adjustment.
- Prepare the withdrawal explanation before clearing or posting the bank entry in QuickBooks or another accounting workflow.
- 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, QuickBooks cleanup, 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.
- QuickBooks or downstream accounting entries should stay separate from the payout review until the withdrawal support is clear.
- Rows with weak withdrawal support should stay in review instead of being forced into a final match.
Do not want to connect a bank account?
Compare a browser-local exported-file workflow with a typical connected reconciliation tool.
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.
Should I label every PayPal shortfall as a fee?
No. If the export only proves a smaller withdrawal, keep the unresolved remainder as an amount difference or possible adjustment until another export identifies the exact cause.
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.
When should I use the PayPal QuickBooks reconciliation workflow?
Use it after the withdrawal batch is explained well enough to review the accounting handoff. First prove the PayPal withdrawal, then decide how the bank entry should be cleared or reviewed in QuickBooks.
When should I use the broader PayPal bank guide instead?
Use the broader guide when you still need the full withdrawal-first workflow and bank-side explanation. Stay on this page when the withdrawal is already identified and the remaining work is narrowing fees, refunds, FX effects, or open amount differences.