QuickBooks Small Business

New PayPal Integration Tool Is Available in QuickBooks Online

Written by Carrie Kahn

As a QuickBooks ProAdvisor, we often hear feedback from clients and ProAdvisors that it’s difficult to reconcile books when a client uses PayPal. On April 23, 2018, Intuit launched a new Application that addresses these issues. The new PayPal integration tool is available in QuickBooks Online. PayPal is a tool that can be used to collect from your customers and pay your vendors, and it can use your bank account, credit card accounts, and your PayPal balance. This makes it unique but challenging when this information is pulled in as a feed. It causes a lot of confusion because of the unique flexibility PayPal offers.

Your first step is to go through the steps to add: Connect to PayPal App for QuickBooks Online. It’s pretty self-explanatory to do the connection.

During your setup process you will see this screen:

How to Use the New Paypal Integration Tool Available in QuickBooks Online

We recommend you accept these settings and click next. Each month you will reconcile your new PayPal Bank in QuickBooks with your PayPal statement. The next step is to decide how far back to go. Importing transactions in the initial setup, you can go back up to 18 months.

How to Use the New Paypal Integration Tool Available in QuickBooks Online

Similar to reviewing transactions in your bank account, your next step is to go to your PayPal account to edit the transactions and then add to QuickBooks O. You can enter deposits straight to a specific account, or you can enter them as a Sales Receipt. Here is an example of a deposit, someone paying via PayPal where you can code it directly.

How to Use the New Paypal Integration Tool Available in QuickBooks Online

The next example is a sales receipt. If one doesn’t exist, it automatically enters PayPal Sales. However, correct the receipt to match your codes for QuickBooks support and click save.

How to Use the New Paypal Integration Tool Available in QuickBooks Online

The new feature in this app is the fact that details come over in the bank feed. When PayPal charges a fee, the amount is automatically recorded to “PayPal fees” and shown in the details of the transaction. The total sale is one line item; the PayPal fee is a deduction and the two items net to match the actual deposit. Ultimately this makes reconciling smoother than before as the net deposit will now reconcile to the PayPal statement without manual adjustments.

Below is the actual deposit of the sale above but net the fee.

How to Use the New Paypal Integration Tool Available in QuickBooks Online

This fee is automatically coded to a new expense account called PayPal Fees. If you want to change the name, just edit it in the chart of accounts.

Here is how the above transactions will be reflected in a Profit and Loss Statement:

How to Use the New Paypal Integration Tool Available in QuickBooks Online

If you have already entered an invoice, it will also try to find and match to an existing entry.

How to Use the New Paypal Integration Tool Available in QuickBooks Online

Finally, when PayPal is transferred into or out of your bank account or Credit Card account, treat it accordingly, as a transfer in QuickBooks Online.

This new application provides detailed information into the feed including gross sales, transactions fees from PayPal, and net sales. Previously this information was missing and had to be inputted manually. Before you accept the information, you are given a chance to review and edit the data before you record in QuickBooks, similar to how you handle other banking transactions. However, unlike regular bank connections, the details from PayPal will be available, such as what you sold through PayPal and what you paid for, as well as PayPal transaction fees. All this results in more detail and accuracy for your transactions in QuickBooks.

You’re all set and ready to go!  If you’d like further details on managing your PayPal transactions using new Connect to PayPal app, check out the Connect to PayPal FAQ.


Save pagePDF pageEmail pagePrint page

About the author

Carrie Kahn

Complete Business Group helps small businesses purchase the RIGHT QuickBooks product at the lowest price and offers a team of experts to provide high level customer service so that they use QuickBooks® the way it was intended. With the many offerings from online to desktop we understand the benefits and limitations of each option to help you find the right solution. We have a team of certified ProAdvisors located all over the US ready to support you remotely or locally.

Carrie Kahn, CPA, the founder and CEO of Complete Business Group, has been helping small businesses purchase the RIGHT QuickBooks product at the best price and offers a team of experts to provide high level customer service so that they use QuickBooks®the way it was intended.

Carrie has been supporting and selling QuickBooks since Dos V1. She has been an Advanced Certified ProAdvisor since 2002. She joined the Intuit Reseller Program in 2008. In 2015 she launched the Complete Business Partner Program
mentoring ProAdvisors in selecting the best QuickBooks products for their clients at best pricing for their customers. She is very involved in the QuickBooks community providing extensive resources for ABBO Facebook group , Scaling New Heights, School of Bookkeeping, CPA Academy, Intuit’s Firm of the Future, and CBG Blog. Carrie is a lead QuickBooks Author for the Accountex blog. She was named Insightful Accountant’s Top 100 ProAdvisor every year since 2014 and was Insightful Accountant’s 2017 Social Media Resources ProAdvisor. She currently serves on the Intuit Reseller Program Council. CBG has been in the top 10 Intuit Premier Resellers (IRPs) since 2012 and currently is ranked #1 in the East. She is currently serving on the IRP Council. Carrie’s company, CBG was named Partner Program of the year for 2017.

12 Comments

Leave a Comment