Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
I recently connected my PayPal account to QB online. I wanted to start doing my books on QB for the year 2020. However, in the banking section, it imported PayPal transactions all the way back to the beginning of 2019. How do I deal with these, so that I can get my PayPal balance reconciled in QB online? There's thousands of 2019 transactions for review.
I'll help you with balancing the accounts, Iharkins. We'll have to add or match the transactions.
Just follow these steps:
I'll share the reference on how you can add or match the transactions for more information.
Once done, you can reconcile your PayPal account.
If you have more questions, please get back to this thread so we can help you further.
Is there a way to simply exclude 2019 transactions and still maintain an accurate PayPal balance in quickbooks? Or is there a way to only import transactions starting in 2020? I don't need 2019 data as I did my books somewhere else, I really just want to work with transactions starting in 2020.
Let me continue to help you with your PayPal transactions, iharkins.
Yes, you can definitely exclude your 2019 transactions. This will make your PayPal register neater since you'll only have fewer transactions to manage. Just be sure to enter an opening balance at the start of 2020, so you can reconcile your account. This is your balance after the last transaction in 2019.
That will do it. If you need more help, please don't hesitate to send a short reply.
Thanks, I think this puts me on the right track. But I am having a little trouble still. Here is the situation:
After excluding certain transactions, my bank balance is 5,861.98. My QuickBooks balance is 8,844.09. I can't make a deposit to bridge the gap and make these numbers match. What kind of entry would work in this situation?
Thank you for providing information about your concern, @iharkins.
When some transactions are created manually Bank balance and QuickBooks balance will not be the same. The QuickBooks balance will depend on the added or matched transactions. While Bank balance will be changed or updated if the account is connected to online banking.
To check what causes the difference in balance, go to your bank register. From the transactions on your bank register, you can notice transactions with green boxes. That means it matched with the bank. While those manually created transactions are not present from your Bank statement.
For the detailed steps please refer to this article: Fix Differences Between QuickBooks and Bank Balance.
Here is a helpful article that you can read through in fixing issues when reconciling accounts in QuickBooks Online: https://quickbooks.intuit.com/learn-support/en-us/undo-reconciliation/fix-issues-when-you-re-reconci....
I'm just a few clicks away if you have any additional questions. Stay safe and take care always!
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