What we do
Tools
Industries
Department
How we workLet's talk →
Home/QuickBooks/PayPal QuickBooks Integration, Gaps Included
QuickBooks + PayPal

PayPal QuickBooks Integration: What the App Records, and What Still Needs a Person

Intuit's own app, Connect to PayPal 2.0, brings PayPal sales, refunds and fees into QuickBooks Online and matches them against the money you move to the bank. It doesn't know which of your invoices a PayPal payment was for, and it doesn't handle more than one currency. How much is left over depends on how your customers pay you through PayPal.

How you take PayPal decides what the app covers

How PayPal money reaches you What usually handles it What's still left for a person
PayPal checkout or buttons on your own site, in one currency Connect to PayPal 2.0 Reviewing what lands in App transactions, then matching the transfers to your bank in Banking.
Clients clicking PayPal or Venmo on a QuickBooks invoice QuickBooks Payments, with PayPal and Venmo turned on The payment is recorded against the invoice for you. The matching gap below is for PayPal money that arrives outside that button.
Clients sending PayPal money directly, outside the invoice's own pay button Connect to PayPal 2.0 for the money, nothing for the invoice Intuit's help describes PayPal sales arriving as a sales receipt or deposit, so the invoice itself can stay open until someone applies the payment to it, net of PayPal's fee.
PayPal payments in more than one currency No Intuit app, by Intuit's own description Intuit says multi-currency isn't supported in the Connect to PayPal app, so converting amounts and booking the difference is manual.
PayPal as one payment option in Shopify or another store Usually the store's own QuickBooks connector Pick one source for each sale. If both the store connector and the PayPal app bring it in, it's booked twice. Our Shopify and QuickBooks guide covers the store side.
A few PayPal payments a month Entry by hand from PayPal's reports Workable at low volume. An older PayPal bank feed connection only brought sales in as a summary, without fees or tax split out, which gets slow once refunds start.

Setting up Connect to PayPal 2.0

A few minutes in QuickBooks Online. The choices on the start date and accounts are the ones that are hard to undo.

  1. 1

    Open the app listing

    Integrations Find integrations Connect to PayPal 2.0 Get app now

    Search for Connect to PayPal 2.0, select Get app now, then Continue.

  2. 2

    Pick the start date

    The app can bring in history up to 90 days before the date you choose. Older PayPal activity has to be entered another way.

    Watch for: months you've already booked by hand or through Bank Feeds. Start the day after your last manual entry, or those sales come in twice.

  3. 3

    Sign in to PayPal and choose the account

    Select Agree, sign in to PayPal in the new tab and select Continue. Then choose a new PayPal bank account in QuickBooks, which Intuit recommends, or an existing one.

  4. 4

    Choose the transfer account

    If you move money from PayPal to a bank account, pick that bank account here so transfers are matched rather than booked as income. You can Skip and change it later in the app's settings.

  5. 5

    Review what arrives

    Check it out App transactions

    Transactions can take a while to appear. Add them from the App transactions tab, then match them in Banking. The default transaction fee account is under the app's Advanced settings.

PayPal's in QuickBooks, so why don't the books agree?

The client paid, but the invoice is still open

How you'll know: Accounts receivable shows an invoice outstanding, and the same amount appears as a PayPal sale or deposit.

Fix: Record the payment against the invoice and link it to the PayPal deposit, with PayPal's fee in your fee account, instead of keeping the separate sale. Doing that weekly for dozens of clients is the job worth automating.

PayPal fees are missing from the P&L

How you'll know: Sales are there, but the fee account barely moves.

Fix: Intuit's help says fees post to the fee account once the sale is added or matched. Clear the App transactions queue and they appear.

Sales appear twice

How you'll know: The same PayPal payment shows up from the app and again from an older PayPal bank feed connection.

Fix: Keep one connection. Intuit has merged its older PayPal options into the Connect to PayPal app, so disconnect the old feed and match rather than add anything already booked.

Foreign-currency payments land at the wrong amount

How you'll know: A payment taken in euros shows a dollar figure that doesn't match the deposit PayPal actually made.

Fix: Book these by hand at PayPal's conversion, with the difference in an exchange gain or loss account, or have it automated outside the app.

Invoices paid through PayPal, finally marked paid

Services business · clients paying by PayPal, bank transfer or card through a different processor

Before

PayPal was one of several ways clients could settle an invoice. PayPal's fee, and the odd partial payment, meant a PayPal deposit never quite matched the invoice it was for.

Every week the bookkeeper worked out which invoices were really paid in full once PayPal's cut was taken off.

After

A sync now reads each PayPal transaction, works out the fee against the gross amount, and applies the net payment to the right QuickBooks invoice. Only the payments that don't match an open invoice go to a person to review.

The weekly reconciliation shrank from the full list to a handful of edge cases.

Questions people ask

Does PayPal integrate with QuickBooks, and in how many ways?

Yes. Intuit's Connect to PayPal app brings PayPal sales into QuickBooks Online with tax and fees, and matches transfers to your bank. Intuit has folded its older PayPal Bank Feeds and Sync with PayPal options into that app. You can also enter PayPal activity by hand from PayPal's reports, which suits very low volume.

How do I connect PayPal to QuickBooks Online?

Go to Integrations, then Find integrations, search for Connect to PayPal 2.0 and select Get app now. Choose a start date up to 90 days back, sign in to PayPal, pick the PayPal bank account and your transfer account, then review what arrives in the App transactions tab.

Can I import PayPal transactions into QuickBooks from before the app was connected?

Up to 90 days of them, through the start date you pick at setup. For older PayPal transactions, export a report from PayPal and import it, or enter it by hand. Check first that those months weren't already booked another way.

Does the QuickBooks PayPal integration handle multiple currencies?

No. Intuit says multi-currency isn't supported in the Connect to PayPal app. Businesses that take PayPal in more than one currency convert and book those payments by hand, or have a custom sync do it.

Who builds the matching between PayPal payments and QuickBooks invoices?

A custom sync from n-frames does that job. It reads each PayPal payment, finds the open invoice it belongs to, applies the net amount with the fee booked separately, and sends anything it can't place to a short review list.

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.