Skip to main content
April 14, 2021
Question

QBO PayPal integration creates both a sales receipt and a deposit, double counting each sale

  • April 14, 2021
  • 2 replies
  • 0 views

For each sale of product recorded through PayPal, QuickBooks Online, coupled with the provided PayPal integration, is creating both a deposit AND a sales receipt.  The deposit properly records the sale and fees.  This is all I really want. 

 

But: The auto-created Sales Receipts appear to double count the sale and show up in a separate revenue category on my P&L as "PayPal Sales" causing those who review my books to ask, "How many PayPals are you selling and why?"  but also falsely doubling revenue through that channel. 

 

QBO support (after trying to send me off to PayPal) acknowledges the problem and to date, suggests that I log in every day and simply delete the Sales Receipts.  This hardly seem like good practice. Other suggest that QBO support has "fixed" this after calling in.  I've had no such luck. 

 

Have any of you addressed this?  Perhaps a setting or process that I missed?  

 

Thanks for any advice!

 

 

2 replies

katherinejoyceO
April 14, 2021

 

Hi there, @Michael7s.

 

I'm here to help ensure your PayPal transactions are not duplicating your sales. 

 

To fix this, we need to match them with your sales receipts. Here's how: 

 

  1. Go to the Banking page. 
  2. From the Bank and Credit Cards drop-down menu, select your bank account.
  3. Under the For Review tab, find and click your PayPal payment transaction, then select Find Match.
  4. Choose the sales receipt.
  5. Click Save.

 

Here's an article for an additional guide on categorizing or finding a match of your downloaded banking transactions.

 

For future reference, read through this article to learn about balancing your checkbook to match your QuickBooks transactions with your PayPal, bank, and credit card statements: Reconcile an account in QuickBooks Online

 

Visit us again here in the Community and post some more if you have additional concerns. I'm here to keep helping. Take care!

Michael7sAuthor
April 15, 2021

Thank you KatherynJoyce,  I'd like to follow those instructions.  So here's what I did. 

 

For each sales receipt that ended up in the P&L under "PayPal Sales," I found the correlating deposit transaction in the "Already Categorized" section of banking for PayPal and "Undid" each deposit transaction. 

 

This eliminated the sales receipts "sales of PayPal" from appearing in the P&L (Yay!).  Now... what do to with each of these transactions in the "For Review" list on the Banking Transactions PayPal screen of QBO?  

 

The options QBO gives for each PayPal sale transaction is either:

 

"Categorize" as a Sales Receipt or Deposit or Transfer

 

or

 

"Find match"

 

The latter, "Find match"  errors out with "No Matches Found"  So that's of little help for now. 

 

If I Categorize the PayPal transaction (sale) as a Sales Receipt, it rightly counts it as income, but also creates a sales receipt that shows up on the P&L and appears to double count it. 

 

If I Categorize the PayPal transaction (sale) as a Deposit, it rightly counts it as income and everything is fine. 

 

Here's where this introduces a new and different cause/problem.  The RULE for entering PayPal Sales transactions instructs QuickBooks Online to add the transaction as a "Deposit" but instead, QuickBooks Online enters it as a Sales Receipt - which causes the double counting and the problem on the P&L. 

 

 

Does this seem like a bug in QBO or am I missing something important? 

 

Thanks for your help. 

April 15, 2021

Thank you for getting back to us and sharing detailed information on your concern, @Michael7s.

 

Allow me to provide additional insights on how QuickBooks Online (QBO) handles your PayPal transactions.

 

When you sync your PayPal transactions in QBO, you'll want to make sure that all the sales from your PayPal account are created in QuickBooks. This is to ensure the system will match your transactions without an error and won't double the income. Also, make sure that the items used in a transaction with products/services within QuickBooks match your PayPal transactions. The match criteria are based on the item name.

 

To learn more about how QuickBooks manage your PayPal transactions, feel free to read these articles:

 

 

Just in case you want to reconcile your PayPal account within QuickBooks, you can check out this article for your future reference: Learn the reconcile workflow in QuickBooks.

 

Please let me know if you need clarification about importing PayPal transactions in QBO, or there's anything else I can do for you. I'll be standing by for your response. Have a great day.

November 4, 2021

First, I am new to Qb Community.  Please tell me how to originate a post instead of only bring able to comment of pose questions via s reply to existing comment!

 

Second, my Pay Pal transactions in QB online leave me frustrated snd befuddled.  I had PP set up as a bank account for years and this way I received all the information that appears with the transactions in PP such as who it was to or from, the banking transaction text, etc.

 

The bookkeeper I had did not like having to delete the duplicate sale information arising from linking it as a bank account so we removed it as a bank account. Now she only books the PayPal transactions from when they show in a bank account update.  This is good fot her but creates issues fot me.  Half the time or more I cannot tell who the actual Payee was that paid via PP nor can I see what thry bought or what invoice they paid.  This means I cannot properly categorize the transaction other than as a “Transfer” but this does not tell me or anyone if it is just an internal transfer from PP  to business checking, and therefore not counted in revenue, if it paid for something and if so what and from whom, OR if the transfer needs to book as a sale/income. It leaves me blind.


What is simplest, most straightforward way to access PP transactions through QB?  Is this as a bank account that separately pulls in the transactions (and if so, is there a way to set this up to avoid duplicate deposits/income)?

 

if the better way is to just let the bank account provide them, how do Iget the rest of the info I need to categorize, attribute payment to correct customer, etc?  And, how fo I avoid the confusion created by the net PP amounts deposited not matching the gross amount bookkeeper is entering the sales paid via PP.  it is creating so much confusion as I cannot exactly match the transaction amounts on the bank statement to the transaction amount that can be found in the P&L Detail report for each month?


Obviously, accounting is not in my genius zone but with the prominence and wide adoption of Quick Books surely there is a best practice that accomplishes all of these goals?

Fiat Lux - ASIA
November 5, 2021

@AIMONLINE 

Consider having an additional app to reconcile PP transactions into your QBO.