cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
NextGenBizSolutions
Level 1

Bank Reconciliation Discrepancy

Migration to QBO-
Migrated a client from Sage50 to QBO, using the TB numbers. Everything is nice and dandy, except for my bank reconciliation.
The number from TB/BS has an amount of O/S items within it, which creates discrepancy in my bank reconciliation.
I have solved this issue before, but right now, my brain is about to explode and can't remember how I did it.
Does anyone know how to do this to have my GL-Bank intact, and my starting balance in my bank reconciliation correct?

4 Comments 4
PrachiJoshi
Level 5

Bank Reconciliation Discrepancy

Is there a balance in "opening equity balance" account? Does it match the reconciliation discrepancy?

Angelyn_T
QuickBooks Team

Bank Reconciliation Discrepancy

Hi there, @NextGenBizSolutions. I'm here to help you fix the discrepancy in your client's reconciliation.

 

To get started, let's make sure that the transactions recorded or added in QuickBooks Online (QBO) matches the client's bank statements. If there are unwanted entries, then you can exclude or remove them from QuickBooks. 

 

On the other hand, I also recommend checking the account's opening balance. It needs to match the balance of the real-life bank account for the day you decided to start tracking transactions in QuickBooks. Once settled, proceed with your reconciliation.

 

  1. Sign in to QuickBooks.
  2. Go to the Gear icon, then click Reconcile. If you're reconciling for the very first time, select Get started to continue.
  3. From the Account ▼ dropdown, select the account you want to reconcile. Make sure it's the same one on your statement.
  4. Review the Beginning balance. Make sure the beginning balance in QuickBooks matches the one on your statement. Here's what to do if they don't match.
  5. Enter the Ending balance and Ending date on your statement. Some banks call the ending balance a "new balance" or a "closing balance".
  6. If you see it, review the Last statement ending date. This is the end date of your last reconciliation. Your current bank statement should start the day after.
  7. When you're ready to start, select Start reconciling.

 

In case you encounter issues after the process, use this link as your reference to fix the issue: Fix issues at the end of a reconciliation in QuickBooks Online.

 

If you have any other follow-up questions about reconciliation, let me know by adding a comment below. I'm more than happy to help. Keep safe!

NextGenBizSolutions
Level 1

Bank Reconciliation Discrepancy

Thank you it has been resolved. 

Alex M
QuickBooks Team

Bank Reconciliation Discrepancy

Hi there NextGenBizSolutions,

 

I'm happy to hear that this has been resolved. if you have any other questions, feel free to reach out here.

Need to get in touch?

Contact us