Skip to main content
January 11, 2022
Question

Bank Reconciliation Discrepancy

  • January 11, 2022
  • 1 reply
  • 0 views

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?

1 reply

PrachiJoshi
January 11, 2022

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

Angelyn_T
January 12, 2022

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!

January 13, 2022

Thank you it has been resolved.