PayPal Reconciliation Checklist
Free checklist to reconcile PayPal transactions, fees and withdrawals with bank statements.
Try with sample files | View sample report
Download the working files
Problem statement
PayPal bank deposits are usually net withdrawals, not the gross customer-payment total. A safe checklist separates payments, refunds, fees, withdrawals, and reversals before the bank match.
Checklist outcome example
| Line item | Amount |
|---|
| PayPal withdrawal | $3,134.00 |
| Known deductions inside PayPal | -$126.00 |
| Unexplained remainder | $0.00 |
| Bank deposit | $3,134.00 |
Why the numbers do not match
- Customer payments and the final withdrawal are different stages of the PayPal cash cycle.
- Refunds and reversals may reduce a later withdrawal than the original payment.
- Fees and currency conversion can lower the net cash that reaches the bank.
- Weak descriptions and manual withdrawal timing can keep the final bank match in review.
What files to export
- PayPal Activity export with payments, refunds, fees, withdrawals, reversals, and transaction IDs.
- Bank statement CSV/XLSX with withdrawal deposits and dates.
- Optional orders or invoices export when you need customer-facing references behind the withdrawal.
Manual workflow
- Step 1: Export PayPal Activity.
- Step 2: Export bank statement.
- Step 3: Separate payments, refunds, fees, withdrawals, and reversals.
- Step 4: Match PayPal withdrawals to bank deposits.
- Step 5: Review unresolved rows.
- Step 6: Export final report.
Common mistakes
- Matching customer payments directly to the bank instead of starting from the withdrawal batch.
- Treating every shortfall as a fee when the export only proves a broader amount difference.
- Mixing reversals and refunds into one unexplained bucket.
- Closing the reconciliation before mixed-currency rows or delayed withdrawals are explained.
How Reconcile Locally helps
- Keeps the PayPal activity, withdrawal rows, and bank deposits in one local review workflow.
- Separates matched withdrawals from amount differences and unknown bank payments.
- Preserves conservative wording when the files only prove a possible fee, refund, FX, or adjustment.
- Exports a review-ready report instead of leaving the logic hidden in spreadsheet notes.
What still needs manual review
- Exact FX treatment, tax treatment, and the final classification of every adjustment may still require manual review.
- Weak-reference rows should stay open until the evidence is strong enough.
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 a PayPal bank deposit equal the gross sales amount?
Usually no. The bank deposit is normally the net withdrawal after fees, refunds, reversals, timing differences, and other activity inside the PayPal balance.
When should I use amount-difference wording?
Use amount-difference wording whenever the files do not prove the exact cause. You can mention a possible fee, refund, tax, FX, or adjustment, but keep it in review until the export confirms it.