QuickBooks HelpQuickBooksHelpIntuit

Use the PayPal Connector by QuickBooks app

by Intuit Updated 2 weeks ago

Save time and improve bookkeeping accuracy with the PayPal Connector by QuickBooks. This app syncs data from PayPal directly into QuickBooks Online, reducing the need for manual data entry.

Learn how to connect and manage PayPal transactions in QuickBooks Online. You can edit, categorize, and match transactions, customers, and products to keep your books on track.

Note: At this time, PayPal transactions originating from Shopify can't be imported.

Learn about:

How to connect

An active PayPal account is required to use the PayPal Connector by QuickBooks. If you haven't already, create a PayPal account before continuing.

  1. Sign in to your QuickBooks Online account.
  2. Go to Apps, then the Find apps tab.
  3. In the search bar, search for PayPal Connector by QuickBooks.
  4. Select Get app now.
  5. Follow the on-screen instructions. When prompted, enter your PayPal account email address and password, then select Log in.
  6. To authorize the PayPal to send your transactions to QuickBooks, select Agree and Connect.
  7. After your transactions finish syncing, select Go to App Transactions.
  8. Confirm the PayPal balance account where you'll find your PayPal transactions, then select Next.
    • Note: Generally, this is separate from your bank account and is automatically created for you upon setup.
  9. If you have historical transactions, select the date you would like to start importing from, then select Done.
    Note: You can import up to 18 months’ worth of historical transactions.

You’re ready to go! You'll see the PayPal app and list of transactions on QuickBooks App transactions (Take me there).

If you already use Sync with PayPal or Connect to PayPal, updating to the new PayPal Connector app is quick and easy.

  1. Sign in to your QuickBooks Online account.
  2. Go to Apps, then the Find apps tab.
  3. In the search bar, search for PayPal Connector by QuickBooks.
  4. Select Get app now.
  5. Enter your PayPal account email address and password, then select Log in.
  6. To authorize PayPal to send your transactions to QuickBooks, select Agree and Connect.
  7. Confirm the PayPal balance account where you'll find your PayPal transactions, then select Sync now.
    • Note: Generally, this is separate from your bank account and is automatically created for you upon setup.
    • As a migrating user, QuickBooks automatically knows your last sync date and will only download transactions since that date.
  8. After your transactions finish syncing, select Go to App Transactions.
  9. Confirm the PayPal balance account where you'll find your PayPal transactions, then select Next.
    • Note: Generally, this is separate from your bank account and is automatically created for you upon setup.
    • As a migrating user, QuickBooks automatically knows your last sync date and will only receive transactions since that date.

You’re ready to go! You'll see the PayPal app and list of transactions on QuickBooks App transactions (Take me there).

Data synced from PayPal

With PayPal Connector, you’ll see most transaction details in QuickBooks that you’d expect to see in PayPal.

Image showing PayPal transactions on the App transactions screen of QuickBooks Online.

How to review transactions

  • Categorizing transactions: QuickBooks suggests categories for some transactions you'll find on the App transactions (Take me there) page. Check that it’s correct, then select Confirm or Add. Sometimes we’ll need more info from you before you can add the transaction. In that case, select Review, and add details as needed.
  • Matching transactions: If the transaction already exists in QuickBooks, you may have the option to match it. In some cases QuickBooks will suggest one or matching records. Select the one that’s correct, then Match.

The table below guide you on how PayPal transactions are handled within QuickBooks Online:

Transaction Type/ItemWhat you'll see in QuickBooks
Income / SalesYou'll see the gross amount, net amount, and fees for each income transaction. Quickbooks imports detailed line item level data from PayPal. Each product/service on the sales receipt will be associated with its own income account within QuickBooks Online. You can also match a transaction to existing invoices and sales receipts if they have already been entered into your QuickBooks Online account.
ExpensesWhen you use your PayPal account for a purchase, an expense transaction appears in the list of transactions on the App transactions (Take me there) page to allow you to categorize the transaction.
FeesFees associated with sales transactions import as an expense transaction with the Sales Receipt.
Note: Fees are included in the compound deposit. You won't see the fees separately in the transaction list. Fees are categorized into a PayPal Fees account. Fees aren’t added to the PayPal Fees expense account until a Sales transaction is added to QuickBooks or matched to an existing transaction.
Funding transactionsTransfers: Money movement between your bank account and your PayPal account will appear as a transfer.
Purchases paid through PayPal that are funded with a bank account or credit card will also appear as transfers in your transactions list.
You can create a rule to tell QuickBooks which account the transfer is coming to/from.
Sales taxIf sales tax is turned on, it is mapped when you complete the PayPal setup steps. To edit:
  • Go to App transactions (Take me there) then select Edit Image of the edit icon. on the PayPal card. Select Edit Settings, then choose a new rate.
CustomersThe suggested customer is shown in the bank transaction list, but if it’s not yet in QuickBooks, QuickBooks will prompt you to create a new customer.
VendorsThe suggested vendor is shown in the bank transaction list, but if it’s not yet in QuickBooks, QuickBooks will prompt you to create a new vendor.
Items (Products / Services)Products/services will sync as line items on the sales receipt if the item name within PayPal and QuickBooks Online match.
Otherwise, the items will appear as “PayPal Sales” on the sales receipt line details and you will be prompted to match the item name in the PayPal transaction to an item that already exists in your Products and Services list or create a new item.

Image of the settings screen of the PayPal Connector by QuickBooks.

  • The PayPal balance account is what QuickBooks uses to track how much money you have in your PayPal account at any given time.
  • The Deposit account is the bank account you transfer money to after you’ve received payments through PayPal.
  • When you connect PayPal to QuickBooks, you can receive historical transactions from PayPal. Choose how far back you want PayPal to go when it sends your historical transactions to QuickBooks. You can receive the last six months of transaction, or enter a custom date.
  • You can choose whether or not you want PayPal to record your transactions automatically.
    • With this option turned on, you won’t confirm the details of any transactions. QuickBooks will record everything automatically.
    • With this option turned off, you’ll have an opportunity to confirm transaction details before they’re added to your books.

A Product/Service item within QuickBooks is tied to an income/expense account. This allows you to attribute different line items to different accounts.

When importing transactions from PayPal, QuickBooks matches the items in a transaction to products/services within QuickBooks. The match criteria is based on item name.

  • If the items in the transaction match: QuickBooks Online uses the matched product/service.
  • If the item in the transaction doesn't match: QuickBooks Online uses the default item called PayPal Sales and updates the description line with the name of the item provided by PayPal.

In certain cases, even when the item name matches, QuickBooks Online may not be able to use the item from the transaction for one of two reasons:

  1. The matching product/service in QuickBooks is not selected as a sellable product/service. If the “I sell this product/service to my customers” checkbox is not selected, the PayPal Connector by QuickBooks will not import the sales transaction. Learn more about adding and editing products and services.
  2. The matching product/service in QuickBooks is not a product, but is a product category instead. Product category is a feature used to group a list of related products/services in QuickBooks Online. Even if the item/product name in QuickBooks Online matches with the PayPal transaction, it can't be used as a product item within a Sale transaction.

In these cases, you’ll see the default PayPal Sales line item and the description with the item name from PayPal. This way, the transaction is still imported with details provided.

When you review incoming PayPal transactions, you can match products and services that appear the same in QuickBooks and PayPal. Doing this prevents duplicate inventory tracking across both apps.

  1. Go to Transactions, then the App transactions (Take me there) tab.
  2. Select the PayPal tile, then the For review tab.
  3. Select a transaction to expand the details.
  4. In the Products and services section, you may notice the Select match button for a particular item. Select this button to view potential matches.
  5. In the drawer that displays, you’ll see the PayPal product details side-by-side with potential item matches we found in QuickBooks. Review these to verify a match.
  6. Once reviewed, choose the QuickBooks item that best matches the PayPal item, then select Next.
  7. Select Done. The items are now matched and you won’t need to do this process again for this item going forward.

You can bulk select incoming PayPal transactions to add or match them in QuickBooks, saving you time.

  1. Go to Transactions, then the App transactions (Take me there) tab.
  2. Select the PayPal tile, then the For review tab.
  3. On the left-side of the table, select the check boxes for any transactions you’d like to add to your books.
  4. A pop-up asks you to Confirm or Exclude the selected transactions. Choose Confirm to move all of the selected transactions to the Reviewed tab.
    Note: The Confirm button may be unselectable if one or more of the transactions needs Review under the Actions column. In this case, review and confirm these transactions individually.
  1. Sign in to your QuickBooks Online account.
  2. Go to Apps, then the Overview tab.
  3. Find the PayPal app card, select more options Vertical ellipses icon., then select Settings.
  4. Select Disconnect.
QuickBooks Online AdvancedQuickBooks Online EssentialsQuickBooks Online PlusQuickBooks Online Simple StartThird-party partners

Sign in now for personalized help

See articles customized for your product and join our large community of QuickBooks users.

More like this