Shopify PayPal Reconciliation - Match Orders, Withdrawals and Bank Deposits
Review Shopify orders, PayPal activity, and bank deposits together when customer payments flow through PayPal instead of Shopify Payments.
Try with sample files | View sample report
Problem statement
Shopify can show gross orders and refund status, but PayPal controls the actual customer-payment flow, fees, holds, refunds, and withdrawal batches. If you compare Shopify sales directly to the bank deposit, the PayPal cash movement usually stays unexplained.
Numeric example
| Line item | Amount |
|---|
| Shopify orders paid via PayPal | $2,480.00 |
| PayPal refunds | -$120.00 |
| PayPal fees | -$78.00 |
| PayPal hold or FX movement | -$24.00 |
| Bank deposit from PayPal | $2,258.00 |
Why the numbers do not match
- Shopify records the order and payment method, but PayPal controls the net withdrawal that reaches the bank.
- PayPal fees, refunds, reversals, FX rows, and holds can reduce the withdrawal after the Shopify order is marked paid.
- Several Shopify orders can be grouped into one PayPal withdrawal batch.
- Shopify order date and PayPal withdrawal date often differ because the gateway and the bank settle on separate timelines.
- Cross-platform workflows need both Shopify and PayPal exports before a shortfall can be explained safely.
What files to export
- Shopify orders export with order number, payment method, paid date, gross total, and refund detail.
- PayPal Activity export with payments, refunds, fees, holds, withdrawals, and transaction IDs.
- Bank statement export with deposit date, amount, and description for PayPal withdrawals.
Manual workflow
- Filter Shopify orders to the period and payment methods that were actually settled through PayPal.
- Separate the PayPal Activity export into payments, refunds, fees, holds, FX rows, and withdrawals.
- Use PayPal transaction IDs and references to tie the withdrawal batch back to Shopify orders where the exports allow it.
- Build the withdrawal-level net amount before comparing it to the bank deposit.
- Keep orders, refunds, or withdrawal rows without strong cross-reference evidence in review.
- Use amount-difference wording until the combined Shopify and PayPal exports prove the exact cause.
Common mistakes
- Comparing Shopify gross sales directly to the bank deposit without a PayPal withdrawal breakdown.
- Treating every net shortfall as a fee when the PayPal export only proves a broader adjustment or hold.
- Assuming every Shopify order in the period belongs to one PayPal withdrawal batch.
- Forcing a one-order-to-one-bank-row match when PayPal grouped several payments into one withdrawal.
How Reconcile Locally helps
- Keeps Shopify order context, PayPal withdrawal context, and bank rows in one local review flow.
- Shows which orders have strong PayPal support and which still need manual reference checks.
- Separates matched withdrawals from unknown bank payments and amount differences instead of forcing a one-to-one story.
- Exports a review-ready report before accounting handoff or month-end close.
What still needs manual review
- Cross-platform Shopify-to-PayPal workflows can still need manual reference checks when transaction IDs are missing or inconsistent.
- Reconcile Locally works from exported files; it does not sync live Shopify or PayPal data.
- Tax, FX, hold, and reserve rows may still require another export or human review 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
Why do Shopify sales not match the PayPal bank deposit?
Shopify shows gross order activity, while the bank usually receives the net PayPal withdrawal after fees, refunds, holds, FX, and timing differences.
Which file should I start with first?
Start with the PayPal Activity export and the bank deposit. Then use the Shopify order export to explain which orders sit behind the PayPal payment and withdrawal rows.
Can one PayPal withdrawal cover several Shopify orders?
Yes. That is common. Treat it as a grouped payout-style workflow until the supporting Shopify and PayPal rows explain the full net deposit.