Stripe & PayPal Bookkeeping: Fees, Disputes, and Payout Reconciliation
Map Stripe/PayPal correctly, fees, refunds, disputes/chargebacks, reserves/releases, and reconcile payouts to bank. CPA-reviewed ecommerce bookkeeping in QuickBooks or Xero.
Gateway mistakes inflate revenue, bury fees, and make deposits impossible to reconcile. Our ecommerce bookkeeping flow turns Stripe and PayPal activity into a consistent bridge, gross charges – gateway/platform fees – refunds/chargebacks ± reserves/releases = net payout, and ties every payout to a bank line. We normalize descriptors, separate platform fees from gateway fees, and ensure refunds/chargebacks hit the right contra accounts so margins reflect reality. If you use Stripe alongside Shopify or POS, we prevent double revenue by defining a single system of record and mapping the gateway to cash and fees only. Each month we reconcile bank/credit/loan accounts to statements, clear Undeposited Funds, align inventory & COGS timing, and deliver a CPA-reviewed reporting pack (P&L by channel, Balance Sheet, cash highlights) with a period-lock recommendation. The outcome: payouts that reconcile without detective work and channel margins you can trust.
The Gateway Mapping That Just Works
-
Gross charges mapped to Channel Revenue or memo-only (if platform is SoR) - Gateway fees mapped to Stripe Fees / PayPal Fees (separate from platform fees)
- Refunds mapped to Refunds/Returns (contra revenue)
- Chargebacks/disputes mapped to Chargebacks Expense with reason codes
- Reserves and releases on balance-sheet accounts (Stripe Reserve, PayPal Hold)
- Net payout reconciled to the bank (one payout = one bank line)
Stop Duplicate Revenue (Platform + Gateway)
- Pick a System of Record (SoR) per channel (e.g., Shopify payouts or POS Z-report)
- When platform is SoR: gateway posts fees/chargebacks/cash only, not revenue
- When gateway is SoR (headless/checkout-first sites): revenue from gateway; platform feeds excluded from revenue
Refunds, Chargebacks & Evidence
- Refunds reverse revenue and reduce Sales Tax Payable (direct-cart jurisdictions)
- Chargebacks hit expense; win/loss outcomes logged; recovered amounts credited back with reference ID
- Keep evidence packages (order, comms, tracking) linked in transaction memos for audits
Reserves, Holds & Rolling Payouts
- Stripe rolling reserves and PayPal holds tracked on separate accounts
- Release entries reference payout IDs and bank lines; no P&L distortion
- Monthly reserve roll-forward: Beginning + Adds – Releases = Ending
Multi-Currency & FX
- Reconcile payouts in settlement currency; book FX gain/loss on conversion
- Month-end FX remeasurement with CPA-reviewed entries and variance notes
Month-End Checklist
- Import gateway statements and settlements
- Apply mapping: revenue (SoR decision), fees, refunds, disputes, reserves
- Reconcile payouts to bank; Undeposited Funds = 0
- Validate fee totals against statements; investigate variance > 1%
- Post inventory/COGS timing and sales-tax roll-forward (if direct cart)
- CPA review → variance note → period-lock guidance
Reports You’ll Trust
- Gateway fee dashboard (Stripe Fees, PayPal Fees) with effective rate
- Dispute summary (count, win rate, loss cost) with reason-code rollup
- Reserve roll-forward and release schedule
- Channel P&L with a gross→net bridge that matches bank
Frequently Asked Questions
We choose a single system of record. If Shopify payouts are SoR, Stripe posts fees/chargebacks/cash only. That removes duplicate revenue.
Fees, refunds, and rolling reserves change net payouts. We post each component separately and reconcile the final payout to the bank line.
Chargebacks hit Chargebacks Expense with the reason code. If funds are recovered, we credit back on receipt with the dispute ID for traceability.
Yes, payouts are reconciled in settlement currency; we book FX remeasurement at month-end and tie conversions to bank statements.
Explore
- See full Ecommerce Bookkeeping services.
- Map Shopify payouts and fees correctly.
- Fix Amazon settlements and reserves so deposits match.
- Stabilize inventory & COGS timing across channels.
- Align sales tax, facilitator vs direct cart responsibilities.
- Run Shopify + Amazon + POS under one close calendar.
- Need historical repairs first? QuickBooks Cleanup.
- Prefer a packaged plan? Hire a Bookkeeper, Pricing & Packages.