How to Connect PayPal to QuickBooks Online So Sales Count Once
Connecting the two takes a few minutes with Intuit's own app, Connect to PayPal 2.0. Whether your books agree a month later comes down to one screen in that setup, the one that asks which bank account PayPal pays out to. It has a Skip button. If it's skipped, the money you withdraw from PayPal can be booked as new income, on top of the sales it came from.
Install Intuit's app. Search the integrations list for Connect to PayPal 2.0 and choose Get app now.
Integrations › Find integrations › Connect to PayPal 2.0 › Get app nowSign in to PayPal and pick where it lives in QuickBooks. Intuit recommends letting the app create a new PayPal bank account rather than reusing an old one.
Name the transfer account. That's the bank account your PayPal withdrawals land in, so they're recorded as transfers, not sales.
Review before anything posts. Imported PayPal activity waits in a queue until you add or exclude it.
All apps › Accounting › Integration transactionsYour first week with PayPal inside QuickBooks
The install is quick. These are the five things that decide whether the PayPal account in QuickBooks ends up matching PayPal.
- 1
Choose a start date that skips what you already entered
The app can reach back up to 90 days. If last month's PayPal sales were already typed in from statements, a start date inside last month imports them again.
Watch for: your own manual entries. Pull up the newest PayPal sale you keyed in by hand and set the start date after it.
- 2
Work through the review queue
Integration transactions › PayPal Payments › For ReviewFilter to PayPal Payments. Each item can be added, excluded, or opened with View details. What you add shows on the Reviewed tab, where Undo reverses it.
- 3
Map customers and items on the first few sales
Expand a transaction and open Customer and item details. Pick an existing customer and product, or use +Add new, then Save and close. Doing this early means later PayPal sales carry names you'd recognize on a report.
- 4
Set the fee and transfer accounts in the app settings
Integration transactions › App settings › PayPal PaymentsThe General tab holds the PayPal bank account and the account transfers are matched to. The Advanced tab sets the default transaction fee account, plus defaults for discounts, shipping, tax and tips.
Watch for: a fee account that barely moves. Intuit says fees only post once the sale they belong to is added or matched, so an uncleared queue means missing fees.
- 5
Match the withdrawal when it reaches the bank
When PayPal money arrives in checking, your bank feed shows it as a deposit. In Banking, match it to the transfer the PayPal app already recorded. Don't add it as income.
Watch for: purchases you paid through PayPal from a linked bank account or card. Intuit records those as transfers too, so they need matching rather than a second expense.
One PayPal sale, from checkout to checking account
The sale and the fee belong to income and expenses. The withdrawal is the same money changing accounts, which is why it has to be a transfer.
| Customer pays through PayPal (A sale in the PayPal bank account) | $250.00 |
|---|---|
| PayPal's fee (Example amount, posted to your fee account) | − $8.99 |
| Net left in PayPal | $241.01 |
| Withdrawal to checking (A transfer between two of your accounts, not a sale) | − $241.01 |
| PayPal balance after the withdrawal | $0.00 |
If the $241.01 deposit in checking is added from the bank feed as income, QuickBooks shows $491.01 of sales for a $250 order. Matched to the transfer, sales stay at $250 and fees at $8.99. Real withdrawals usually cover many sales and a refund or two, which is where tying PayPal's balance to the QuickBooks one starts to take an afternoon.
Connecting PayPal: follow-up questions
Doesn't PayPal already sync with QuickBooks Online on its own?
With QuickBooks Online, yes, through Intuit's Connect to PayPal 2.0 app. It imports sales with tax, fees and shipping broken out, tracks refunds, and records transfers to your bank. Intuit's older PayPal Bank Feeds option only brought in sales summaries. What no setting does is confirm, at month end, that the PayPal account in QuickBooks shows the balance PayPal does. That tie-out is covered on our PayPal and QuickBooks reconciliation page.
Does this PayPal setup work with Xero instead of QuickBooks?
The same logic applies there. Xero connects PayPal as a bank account through its own feed, and a PayPal withdrawal still has to be reconciled as a transfer to your bank account rather than as income. n-frames builds the sale, fee and transfer posting for Xero the same way it does for QuickBooks.
Why are my PayPal transactions taking so long to show up?
Intuit's help notes that the first import can take a while, and suggests refreshing the page. If nothing appears after that, check that the start date you picked isn't later than the sales you're looking for.
Can I bring in PayPal history from before the 90-day window?
Not through the app. Download your activity from PayPal as a file and import it into the PayPal bank account, or enter it as summary entries. Check the overlap with the app's start date first, so no month is booked twice.
Is the PayPal connection quote really free, with no obligation?
It is. n-frames prices the posting and tie-out work once it has seen how money moves through your PayPal account, and nothing gets built unless you decide to go ahead.