What This Integration Does
This integration posts every PayPal sale into QuickBooks Online as a sales receipt, with the PayPal processing fee recorded as an expense, the customer matched, and the class or location tag applied so reporting reflects the real source of the revenue. Refunds, chargebacks, and currency conversions are handled with their own posting logic so the QuickBooks PayPal clearing account always agrees with what PayPal is about to pay out.
The result is a QuickBooks ledger where PayPal activity is not a black box of net deposits but a transparent list of receipts, fees, and adjustments.
The Workflow
The integration listens for transaction completions through the PayPal IPN and Webhooks APIs, then queries the PayPal Transactions API for the full detail of each completed payment. For each sale, it creates a sales receipt in QuickBooks Online against the matched customer, sets the deposit account to the PayPal clearing account, and adds a line item for the PayPal fee posted against the merchant fees expense account. Class tracking, if enabled, picks up the right segment based on the PayPal item name or invoice metadata.
A typical example: an online course business sells courses to customers in the UK, Australia, and the US. A US customer buys a £79 course paying in USD. PayPal converts it and pays out GBP. The integration records the sale at the GBP equivalent, posts the fee in GBP, attaches the class for “Online Courses,” matches the existing customer record (or creates one), and timestamps everything so the daily sales report by class is accurate.
Refunds flow as refund receipts against the original sales receipt, reducing the PayPal clearing account by the refunded gross. Chargebacks post a journal entry to a “Disputed” liability account until the dispute resolves, at which point the integration either reverses the entry or writes off the amount.
Before and After
Before, the bookkeeper logs into PayPal, downloads the activity download, and either tries to reconcile it manually or relies on QuickBooks’ native PayPal connector — which posts net deposits only, leaving fees, currency differences, and refunds to be sorted out later. Sales by class or product is impossible to report on without leaving QuickBooks.
After, every PayPal transaction has its own QuickBooks entry. The sales-by-class report works. The PayPal clearing account matches the next payout. The bookkeeper spends an hour a week reviewing the integration log rather than three hours a week posting transactions.
Who Needs This
US, UK, and international businesses using QuickBooks Online with meaningful PayPal volume — particularly e-commerce stores, online course creators, and donation-based non-profits. The integration is worth building when class or location tracking matters and the native QuickBooks PayPal feed has stripped that detail out.
How We Build This
We build this as a custom integration against the PayPal Webhooks API and the QuickBooks Online API, with a queueing layer between them so transient failures from either side never lose transactions. OAuth tokens for both platforms refresh automatically, and the class/customer mapping rules are configurable per business. See QuickBooks API Integration for the QuickBooks capabilities behind the integration.
Get PayPal and QuickBooks Connected
If your QuickBooks PayPal account never matches your PayPal payouts and your class reporting is missing PayPal entirely, we can rebuild the connection with a custom integration that preserves the detail.