n-QuickBooks + PayPal Integration: What Actually Syncs
PayPal connects to QuickBooks two ways: as a linked bank account through Bank Feeds, which pulls in lump deposits like any other bank, or through the official PayPal Connector by QuickBooks app, which breaks each deposit into the sales, fees, taxes, and discounts behind it. The second option is what most businesses actually want, and it still doesn't handle multi-currency transactions.
How people usually connect them
The PayPal Connector by QuickBooks. An official, free app built by Intuit. It imports PayPal sales and expense transactions into QuickBooks with fees, taxes, and discounts already broken out, rather than one lump deposit figure. This is the right default for most businesses taking PayPal payments.
PayPal as a linked bank account. QuickBooks can also connect to PayPal the same way it connects to an actual bank, pulling transactions through Bank Feeds. It's simpler to set up but treats PayPal like a basic deposit account, with none of the fee or tax detail the dedicated connector provides.
Manual entry. Lower-volume PayPal use sometimes still gets entered by hand from PayPal's own transaction reports, which works fine until the fee math on a handful of refunds starts eating an afternoon.
Where the official connector stops
The PayPal Connector handles the common case well: a PayPal sale with its fee broken out into the right expense account. It doesn't support multi-currency transactions or their reconciliation, and it can't import PayPal transactions that actually originated from another platform, a Shopify checkout routed through PayPal, for instance, so those still need a separate path into QuickBooks.
It's also built around PayPal in isolation. If PayPal is one of several payment channels feeding the same customer or the same invoice, a deposit through PayPal, the balance through a bank transfer, say, matching both halves to the right invoice is still a manual step the connector has no way to handle on its own.
What we've built on top of QuickBooks and PayPal
A services business accepted PayPal as one of several ways clients could pay an invoice, alongside bank transfer and card payments through a different processor. PayPal's own fees and the occasional partial payment meant that matching a PayPal deposit back to the right invoice, net of fees, was never quite automatic, and the bookkeeper spent part of every week reconciling which invoices were actually paid in full once PayPal's cut was accounted for.
We built a sync that reads each PayPal transaction, calculates the fee against the gross amount, and applies the net payment to the correct QuickBooks invoice automatically, flagging only the transactions that don't match an existing invoice for someone to review by hand. The weekly reconciliation shrank to a handful of edge cases instead of the full list.
Taking PayPal payments and still reconciling the fees by hand?
Tell us how PayPal payments are landing in your books right now, as a lump bank deposit or something more detailed, and we'll tell you if the matching can run on its own. And if PayPal isn't the payment method causing the headache, that's fine too, the same reconciliation problem shows up with plenty of other processors.
Let's talk