What we do
Tools
Industries
Department
How we workLet's talk →
Home/How to Connect PayPal to QuickBooks Online
PayPal + QuickBooks Online

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.

Connect PayPal in QuickBooks Online

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 now

Sign 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 transactions

Your 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. 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. 2

    Work through the review queue

    Integration transactions PayPal Payments For Review

    Filter 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. 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. 4

    Set the fee and transfer accounts in the app settings

    Integration transactions App settings PayPal Payments

    The 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. 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.

Example · one $250 order paid by PayPal
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.

Let's talk

Tell us the one thing your team does manually that eats up time. We read every message and reply within a day.