Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
I have a huge mess from importing Paypal to Quickbooks. Sigh. There are a few instances that really messed things up. Do any of you know how to deal with when Paypal has 8 different transactions for one chargeback/dispute? They found in my favor by the way but left me with a mess of figuring out the details. Or when I use my credit card through my biz PayPal it imported the two transactions (money in and money out). Then there's the inability to reconcile other than doing a journal entry. Do you have a workaround or can you tell me if there are entries I should not include?
Solved! Go to Solution.
Hello thebusywoman1,
I want to know more about your concern so I can give you a hand on this.
May I know how did you connect your PayPal account to QuickBooks? Is this through Sync with PayPal or the Bank Feeds page. What steps did you take so far?
Any information and screenshots you can add would be much appreciated. Thank you in advance!
Hi there, @Anonymous.
Thank you for getting back and providing extra details. I can help you record and reconcile your Paypal transactions in QuickBooks.
It's important to record your money in and money out. To do so, you will have to record the payment for the 8 different transactions and tag it under the Undeposited Funds account.
Here's how to do it:
Next, you will have to record the charge back as an expense transaction.
After successfully recording the transactions, you can already reconcile:
I also recommend getting in touch with your accountant for guidance on how to handle the recording and reconciling process of your transactions in the best way for your business.
That should keep you going today, thebusywoman1.
You can leave me a comment below if you have additional questions about reconciling. I'd be happy for further assist you. Wishing you all the best!
It's great to know that you're able to balance your accounts for reconciliation, thebusywoman1.
Let me discuss with you how Undeposited Funds account works.
QuickBooks automatically creates an Undeposited Funds account when you receive payments, use a payment item on an invoice, or enter a sales receipt. This is why it's called a default account but if you don't have this yet, here's how you can add it:
To be more familiar with Undeposited Funds account, feel free to check out this article: Understand how the Undeposited Funds account works.
Don't hesitate to reach out to me with additional questions about this or anything concerning QuickBooks. I'm always around to help.
Hello thebusywoman1,
I want to know more about your concern so I can give you a hand on this.
May I know how did you connect your PayPal account to QuickBooks? Is this through Sync with PayPal or the Bank Feeds page. What steps did you take so far?
Any information and screenshots you can add would be much appreciated. Thank you in advance!
Hello,
I do a manual download of an iif file from paypal and then import it into QB. In Paypal you can choose between balance affecting and completed payments if you download a csv file. If you download the iif file, you only have the options of completed payments. Either way, it gave me a higher balance than I have. I just spent time on the phone with paypal and they explained how to handle some of the transactions but they have no clue how to help me reconcile my paypal account within QB.
Thank you!
Hello,
I do a manual download of an iif file from paypal and then import it into QB. In Paypal you can choose between balance affecting and completed payments if you download a csv file. If you download the iif file, you only have the options of completed payments. Either way, it gave me a higher balance than I have. I just spent time on the phone with paypal and they explained how to handle some of the transactions but they have no clue how to help me reconcile my paypal account within QB.
Thank you!
Hi there, @Anonymous.
Thank you for getting back and providing extra details. I can help you record and reconcile your Paypal transactions in QuickBooks.
It's important to record your money in and money out. To do so, you will have to record the payment for the 8 different transactions and tag it under the Undeposited Funds account.
Here's how to do it:
Next, you will have to record the charge back as an expense transaction.
After successfully recording the transactions, you can already reconcile:
I also recommend getting in touch with your accountant for guidance on how to handle the recording and reconciling process of your transactions in the best way for your business.
That should keep you going today, thebusywoman1.
You can leave me a comment below if you have additional questions about reconciling. I'd be happy for further assist you. Wishing you all the best!
Wow! Thank you. After speaking with Paypal I just entered the balance changing transactions and not the holds or declined transactions. I got it to balance. I copied your instructions for my future issues. LOL
By the way, I don't have an Undeposited Funds account. How would I classify that? Does QB have holding accounts where it shows money but the money does not increase or decrease the balance?
It's great to know that you're able to balance your accounts for reconciliation, thebusywoman1.
Let me discuss with you how Undeposited Funds account works.
QuickBooks automatically creates an Undeposited Funds account when you receive payments, use a payment item on an invoice, or enter a sales receipt. This is why it's called a default account but if you don't have this yet, here's how you can add it:
To be more familiar with Undeposited Funds account, feel free to check out this article: Understand how the Undeposited Funds account works.
Don't hesitate to reach out to me with additional questions about this or anything concerning QuickBooks. I'm always around to help.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here