PayPal QuickBooks Reconciliation - Review Withdrawals Before Posting
A practical workflow for reconciling PayPal withdrawals, fees, refunds, and bank deposits before clearing or posting them in QuickBooks.
Try with sample files | View sample report
Problem statement
QuickBooks sees the final bank deposit, but PayPal activity mixes customer payments, fees, refunds, FX, holds, reversals, and withdrawals. A withdrawal-level review has to happen before the accounting entry is trusted.
Numeric example
| Line item | Amount |
|---|
| Customer payments inside PayPal | $4,280.00 |
| Refunds | -$220.00 |
| PayPal fees | -$128.40 |
| FX or hold adjustment | -$41.60 |
| QuickBooks bank deposit | $3,890.00 |
Why the numbers do not match
- QuickBooks bank feeds usually show only the net withdrawal that reached the bank.
- PayPal Activity mixes customer payments, fees, refunds, reversals, holds, and FX rows in one export.
- One withdrawal can represent many customer payments across several dates.
- Invoice or order references may exist in PayPal activity but not in the final bank description.
- Accounting handoff still needs payout-style support before any entry is cleared or posted.
What files to export
- PayPal Activity export with payments, refunds, fees, reversals, withdrawals, transaction IDs, and currencies.
- QuickBooks bank export with the net deposit rows being reviewed or matched in the bank feed.
- Optional invoice or order export when you need customer-facing references behind the PayPal payments.
Manual workflow
- Isolate the PayPal withdrawal batch that matches the QuickBooks bank deposit period.
- Separate customer payments, refunds, fees, reversals, FX, and hold rows before you compare the net amount.
- Use transaction IDs and references to connect PayPal payments back to invoices or orders where available.
- Match the expected net withdrawal to the QuickBooks bank deposit by amount, date, and reference.
- Keep unsupported gaps as amount differences until the exported files prove the cause.
- Retain the reviewed report as support before any QuickBooks entry is changed or cleared.
Review checks
- Customer payments were matched directly to the bank deposit instead of starting from the PayPal withdrawal.
- Fees, refunds, reversals, or FX rows were left inside one unexplained net amount.
- The QuickBooks bank date was treated as proof of the PayPal activity date.
- The deposit was cleared before the withdrawal batch and supporting references were reviewed together.
How Reconcile Locally helps
- Keeps PayPal activity, bank rows, and optional source rows in one local review workflow.
- Separates matched withdrawals from amount differences, unknown bank payments, and unresolved reference gaps.
- Preserves conservative wording when the files suggest several possible causes for the shortfall.
- Exports a report you can keep with the QuickBooks handoff instead of burying the logic in spreadsheet notes.
What still needs manual review
- Reconcile Locally does not post to QuickBooks or apply customer payments automatically.
- Exact FX treatment, tax treatment, and final ledger mapping still require human review.
- Weak PayPal references or several similar withdrawals can still require one more export before the difference is fully explained.
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 the QuickBooks deposit?
Usually no. Start from the PayPal withdrawal that reached the bank, then reconcile the activity inside that withdrawal batch back to orders or invoices.
What should I export first?
Start with PayPal Activity and the QuickBooks bank export for the same period. Add invoices or orders only when you need customer-facing references behind the withdrawal.
Can Reconcile Locally post or clear the QuickBooks transaction?
No. It prepares a review-ready report from exported files. Posting, clearing, and approving accounting entries remain separate human workflows.