How To Properly Enter PayPal transactions into QuickBooks Online

In this tutorial, I’ll show you how to avoid common mistakes people make when entering their PayPal transactions into QuickBooks Online.

In this tutorial, I’ll use my PayPal account and a sample QuickBooks company file I use for teaching.

PayPal Transactions in QuickBooks

We’ll start by looking at credit card transactions from a bank account. You can access this information in two ways in your own account.

From the main screen, click on the bank account you’d like from the Bank Accounts box on the right side of the screen.

Opening a bank account in QuickBooks Online

You can also click on Banking in the left-hand navigation menu and select Banking.

Banking Menu in QuickBooks Online

In this example, I’m using a $50 payment for training from a company called Score. The payment was made with a Bank of America credit card but processed through PayPal. The bank details within the transaction tell you this was processed through PayPal.

Paypal transaction Bank Details

In many people’s QuickBooks accounts, I’ll see these PayPal transactions entered with the vendor/customer stating who the money went to and the transaction category. As you can see here:

Paypal transaction with incorrect vendor/customer and category information

This method doesn’t exactly match what occurred. For more details, let’s look at the PayPal register itself.

PayPal Transactions in PayPal

Within PayPal, click Summary in the top menu to see a list of your recent transactions. I have two $50 example transactions at the top of my list.

Recent Paypal transactions

I want to show you a different view of this transaction, which I’ll do by clicking “Activity (including balance & fees).”

Paypal link to Activity (including balance & fees)

In this view, you can see that this purchase was from Score Association for $50. I didn’t pay a fee, and I have a balance of $22.26. The balance is the important part.

Paypal transaction data

That balance of $22.26 is the money I have in my Pay{al account. 

Most people don’t think of PayPal as a bank account, but it is. You should think of it like a checking account with a balance of $22.26.

From the summary page, you can see the balance of $22.26 in the upper left-hand corner.

Paypal summary page showing available balance

But there are two $50 transactions, and the balance remains at $22.26. What’s going on?

To find out, I click on the Transaction Type drop-down menu and switch from “Balance affecting” to “All transactions.”

Now, those two transactions have a plus sign to the left of the date.

When I click on the plus sign, I can see the full transaction.

From this view, we can see what actually happened. A $50 withdrawal from my credit card went to Paypal and then from Paypal to Score. 

It should look the same in QuickBooks, but at the moment, it looks like it went directly from my credit card to Score without PayPal being involved.

If I view the PayPal register in QuickBooks, I can see the balance is $22.26, but I don’t see the transaction from Score.

Paypal register in Quickbooks not showing ALL transactions

When reconciling PayPal in QuickBooks, you should log everything you see under All Transactions in your Paypal account.

This may seem like a lot of extra work, like recording a transaction twice. But the reason you want to do this is to ensure you’re not missing any expenses or revenue.

If you have a bank account of any type, you want to be able to reconcile it and verify that ALL of your transactions are recorded and nothing is missing.

Properly Handling a Paypal Transaction in QuickBooks

I’m returning to the QuickBooks credit card register and deleting that $50 Score transaction.

Deleting a transaction in QuickBooks Online.

A warning pop-up alerts me that this transaction was downloaded from my bank’s records. I double-check that I actually want to delete the transaction, but it also informs me that the transaction will be back on the Online Banking page. I do want to delete it, so I click Yes. 

I’ll now click on Banking in the left-hand menu and then on Banking again to get to the Online Banking page. I can see the transaction is back to be reviewed.

I will now change this transaction to a transfer as it’s being transferred from my Bank of America credit card into PayPal.

Recording a transfer in QuickBooks Online

Manually Entering an Expense

I don’t have my PayPal account connected to this QuickBooks file, so I will manually enter the expense.

To do this, I click the New button in the upper left-hand corner, then select Expense from the Vendor column.

Manually entering an expense in QuickBooks Online

I now create the expense with a SCORE payee and a Paypal payment account, and I add the $50 transaction in the education category. I click the “Save and new” button to save the expense.

Manually entering an expense in QuickBooks Online

If I view the Profit and Loss Report, you can see there’s only one $50 expense, even though the transaction was recorded twice: once from the credit card to Paypal and the other from Paypal to Score.

Profit and Loss report in QuickBooks Online

This is because it was recorded as a transfer, and how you should handle your expenses paid with Paypal.

I hope this tutorial was helpful. If you have questions regarding PayPal transactions and QuickBooks, click the green button below to schedule a free consultation.

We are not affiliated with PayPal and do not provide technical support for PayPal. Please follow this link for PayPal support questions: https://www.paypal.com/us/smarthelp/contact-us

☕ If you found this helpful, you can say “thanks” by buying me a coffee…
https://www.buymeacoffee.com/gentlefrog

If you’d like, you can watch me walk through this process in the video below:

Need some one-on-one QuickBooks assistance?
Share Now

This content is for information purposes only and should not be considered legal, accounting, or tax advice, or a substitute for obtaining such advice specific to your business. Additional information and exceptions may apply. Applicable laws may vary by state or locality. No assurance is given that the information is comprehensive in its coverage or that it is suitable in dealing with a customer’s particular situation. Gentle Frog, LLC does not have any responsibility for updating or revising any information presented herein. Accordingly, the information provided should not be relied upon as a substitute for independent research. Gentle Frog, LLC does not warrant that the material contained herein will continue to be accurate, nor that it is completely free of errors when published. Readers and viewers should verify statements before relying on them.

14 Responses

  1. Thank you for the explanation it’s just what I needed because my P&L DID NOT look right!. It seems like my bookkeeper DID NOT create a PayPal account and put everything in my main bank account 🤦‍♀️So I’m verifying everything myself. I’m assuming this process is also done for Venmo, and would it be done for Stripe as well?

    1. Hi Faviola, Stripe, and Venmo can be handled in a few different ways. We may eventually do blogs and videos for this but for now, I recommend chatting with a different professional bookkeeper about your specific situation.

  2. That was great information. Using QBO, how would I record funds that I received via Paypal, the funds were placed on hold, and then cleared/released the following month? How do I reconcile in QBO?

    1. Hi Sheila,

      We don’t have a video explaining this. When processing income like this in QB’s you’d enter the income however you normally would (sale receipt/invoice/directly to the bank, etc.) then use a transfer to transfer the funds from the Paypal account to the checking account.
      If you’d like we’d be happy to walk you through this process you can schedule a meeting here: https://www.gentlefrog.com/meeting/
      -Jess

  3. Do I include transactions that are listed as pending, canceled, or denied? I’m assuming no. They are in the Excel sheet that I imported into QBO.
    Thanks!

    1. Hi Chaya,
      No, you would not include pending, canceled, or denied transactions. You only include things that change/impact the balance.
      -Jess

Leave a Reply

Your email address will not be published. Required fields are marked *

Read similar articles

Finding the Right Mentor and Coaching for Your Bookkeeping Journey

Learn how mentor and coaching can transform your bookkeeping business and help you achieve your professional goals.

QuickBooks Test Drive: How to Access and Use the Sample Company

Learn how to access QuickBooks Test Drive to practice transactions and explore features without affecting real data.

Comparing Accounting Software: QBO, Xero, FreshBooks, Wave, & Zoho Books

Comparing accounting software options? Learn how Xero, FreshBooks, Wave, Zoho, and QuickBooks stack up in pricing, features, and ease of use.

Have a QuickBooks / Bookkeeping Question?

Let me know what you’d like to see in future videos, blog posts, and courses.

Review Your QuickBooks

Are you a small business owner struggling to make sense of your QuickBooks data?

  • Discover how to spot costly mistakes in your bookkeeping and fix them quickly and easily.

  • Save time and money by streamlining your bookkeeping process and reducing errors.

  • Learn how to identify trends in your financial data so you can make smarter business decisions.

  • Get organized and stay on top of your finances by tracking expenses, managing receipts, and closing your books effectively.

Sign up now for this free mini-course and start mastering the essential bookkeeping skills that every small business owner needs to succeed!

FREE Mini Course

Sign up now and enjoy the peace of mind that comes with knowing your bookkeeping is accurate, up-to-date, and free from costly errors.

We won’t send spam. Unsubscribe at any time.

Review Your QuickBooks

Are you a small business owner struggling to make sense of your QuickBooks data?

  • Discover how to spot costly mistakes in your bookkeeping and fix them quickly and easily.

  • Save time and money by streamlining your bookkeeping process and reducing errors.

  • Learn how to identify trends in your financial data so you can make smarter business decisions.

  • Get organized and stay on top of your finances by tracking expenses, managing receipts, and closing your books effectively.

Sign up now for this free mini-course and start mastering the essential bookkeeping skills that every small business owner needs to succeed!

FREE Mini Course

Sign up now and enjoy the peace of mind that comes with knowing your bookkeeping is accurate, up-to-date, and free from costly errors.

We won’t send spam. Unsubscribe at any time.