Connect with and learn from others in the QuickBooks Community.
Join nowCan anyone help me?
Here's the scenario..
Our paypal is connected as bank in qbo. Heres come the day of reconciling,i'm having a hard time reonciling it coz i've seen duplicate transaction in our checking account and in paypal.Sample we paid a bill via paypal,it also reflected on our checking account.what happened?
You are getting duplicate transactions because your PayPal and bank accounts are connected in QuickBooks Online, Lavender.
If the transaction from PayPal is already matched to the record in your register, you can exclude the duplicate from your bank. Similarly, you can remove the downloads from PayPal if you matched the one from your bank account. Here's how:
If the duplicate transactions were already added in your register, you can delete them so you can reconcile the account easily. Just open the bank register, click on each transaction and select Delete.
Let me also share a these articles that can serve as additional guides when reconciling your bank:
I'll jump right back if you have follow-up questions. Other members of the forum and the QuickBooks Team is always here to help.
Hi Lavender,
Hope you’re doing great. I wanted to see how everything is going about reconciling your bank transactions. Was it resolved? Do you need any additional help or clarification? If you do, just let me know. I’d be happy to help you at anytime.
Looking forward to your reply. Have a pleasant day ahead!
Would it be okay to mark these as transfers too?
This does not help with the reconciliation. PayPal is connected to the bank account so the money spent on the bill payment that was made through PayPal was taken out of the bank account. So the "money spent" transaction will come in with both the PayPal bank feed and the checking account feed. If I add the transaction to the register from the PayPal bank tab and exclude the transaction from the checking account feed, the amount will be on the bank statement but when reconciling the checking account, it won't be found in the register...because I have excluded it. If I add the bill payment transaction from the checking account tab and exclude it from the PayPal tab, then in reconciling the PayPal account, the PayPal statement will list the transaction but it won't be found in the register because I have excluded it.
The bill payment was made from PayPal Bank but the funding source was the checking account. In other words, the funds to pay the bill were drawn from the bank account. So the proper way to handle this is to go to the checking account tab, find the transaction, and mark it as Transfer to PayPal (and NOT excluding it!!!). Then go to the PayPal tab and categorize the transaction as an expense. This way, the transaction will not be duplicated, there won't be any duplicate expense transaction, it will only be on the P&L once, and at the same time, you will be able to reconcile both the checking account and the PayPal account. The amount will be on both statements, and you will find it in the checking account register as a Transfer, and in the PayPal account as an expense.
I don't see how this will work. Once you use the transfer option (even from the bank account back to PayPal), in the PayPal account the transaction will offset with itself and there is no way to assign an income or expense. Did you mean pay with credit card? It appears that a PayPal account cannot be tracked in QBO if the transactions download into another account, as well.
I'm here to provide additional insights with the PayPal app integration in QuickBooks, @Kay_T.
Have you tried performing the steps provided by my colleague, JenoP? If not, I suggest trying it out. The recommended step helps resolve those imported Paypal transactions that are incorrectly categorized.
If you're unable to do this, I recommend you get in touch with our Care Support Team so they can take a closer look and further investigate this for you.
Here's how to get their contact information:
You can check out this page which gives you a table on how PayPal transactions are handled within QuickBooks Online: Use the Connect to PayPal app.
That will do it. This should answer your concern today. Please let me know if you have further questions. I'll be here to keep helping. Have a great day.