How to Reconcile Payment Processor Payouts from Stripe and PayPal
Recording the gross sale, processing fee, and net cash deposit when settling funds from Stripe, PayPal, or HyperPay.
| Account Name | Type | Debit ($) | Credit ($) |
|---|---|---|---|
| Cash in Bank | Asset (+) | 97.00 | - |
| Merchant Processing Fees | Expense (+) | 3.00 | - |
| Sales Revenue | Revenue (+) | - | 100.00 |
💡 Accountant's Note
Never record just the net amount ($97) as revenue. You must record the full $100 sale to keep your tax reporting accurate.
Practitioner & Systems Framework
💻 ERP Architecture
Payment gateway integrations (Stripe, PayPal, HyperPay) typically sync transactions via API into the ERP using the gross method — each transaction posts the full sale price to revenue and the fee as a separate expense line. During bank reconciliation, the ERP matches the net deposit to the sum of gross sales minus fees for the settlement period. Maintain a separate GL account per gateway (e.g., 'Stripe Clearing', 'PayPal Clearing') to make reconciliation traceable.
⚠️ Audit Flags
Common errors: (1) Recording only the net payout as revenue — understates revenue and distorts gross margin, (2) Misclassifying processing fees as a revenue reduction instead of a selling expense, (3) Timing mismatches where sales are recorded in one period but the gateway settles in the next. Auditors will tie gateway settlement reports to bank statements and revenue ledgers.
📄 Required Documentation
Gateway payout reports (downloadable from Stripe Dashboard / PayPal Reports Center) showing gross sales, refunds, fees, and net payout by settlement date; bank statement showing the corresponding deposit; monthly reconciliation schedule matching payout reports to GL entries.
Automate this entry with the JEH Accounting Suite
Stop doing manual entry. Our VBA-powered ERP automatically generates your ledgers, Trial Balance, and Financial Statements.
No Subscriptions. Own your data.
Expert Analysis by Qusai Ahmad
General Accountant Supervisor & IFRS Specialist
Specialized in SAP GUI automation and Middle Eastern tax compliance. Building digital tools for the next generation of finance leaders.