cancel
Showing results for 
Search instead for 
Did you mean: 
iharkins
Level 3

How do I get my PayPal balance to match QB Online balance?

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.

5 Comments 5
Kristine Mae
Moderator

How do I get my PayPal balance to match QB Online balance?

I'll help you with balancing the accounts, Iharkins. We'll have to add or match the transactions.

 

Just follow these steps:

  1. Click Banking.
  2. Go to the Banking tab, then select the PayPal account.
  3. Click either Match or Add.

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. 

iharkins
Level 3

How do I get my PayPal balance to match QB Online balance?

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.

JessT
Moderator

How do I get my PayPal balance to match QB Online balance?

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.

  1. Select + New.
  2. Choose Bank Deposit.
  3. Select your PayPal account at the top.
  4. Backdate the deposit to reflect the opening balance. Example: 01/01/2020.
  5. Leave the Received From blank.
  6. In the Account field, select Opening Balance Equity.
  7. (Optional) Enter a memo, such as "Opening Balance".
  8. Enter the appropriate amount.
  9. Select Save.

That will do it. If you need more help, please don't hesitate to send a short reply.

iharkins
Level 3

How do I get my PayPal balance to match QB Online balance?

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?

DivinaMercy_N
Moderator

How do I get my PayPal balance to match QB Online balance?

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!

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us