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

My bank balance and quickbooks balance do not balance please can someone tell me how to balance it

 
3 Comments 3
RCV
QuickBooks Team
QuickBooks Team

My bank balance and quickbooks balance do not balance please can someone tell me how to balance it

I'd like to provide a few details about matching your bank balance to QuickBooks Online (QBO), hassauto.

 

The bank balance doesn't match with QuickBooks if there are transactions that are manually created, duplicates, edited, or deleted. If this happens, we can check the lists of transactions on your bank statement with what's in QuickBooks. This helps us to see if there are any changes made from the previous reconciliation or any transaction that shows in QuickBooks but not in the bank. Here's how:

  1. Go to the Gear icon and select Reconcile.
  2. Choose the affected bank account and you'll see the red message saying Your account isn't ready to reconcile yet.
  3. Click the We can help you fix it, then select the View link in the History column.

From there, you'll see the transaction, when it was deleted or changed, and who did it.  For deleted transactions, you'll need to manually re-enter it and do a mini-reconciliation to fix it. Here's how: 

  1. Go to Accounting on the left panel. 
  2. Within the Chart of Accounts tab, click the bank account.
  3. Click Account history under the Action column.
  4. Choose transaction, click the field until you see R. 
  5. Then, Save.

On the other hand, if it's your first time to reconcile your account, we'll need to review the opening balance if it's correct. Then, make sure that the bank register in QBO is the same as your actual bank account statement. Lastly, you may need these articles for additional reference in fixing reconciliation in the Online product:

 

I'd like to know how you get on after trying the steps, as I want to ensure this is resolved for you. Feel free to reply to this post and I'll get back to you. You have a good one. 

Queanbeyan Hospital Auxiliary
Level 1

My bank balance and quickbooks balance do not balance please can someone tell me how to balance it

The transactions that are causing the opening balance on the bank reconciliation to not correspond with my bank account do not appear in the register of transactions for that bank acct in QuickBooks Online.  However, under History of Account the reconciled amount at 31 December 2020 is correct and the same as my opening amount for my January 2021 bank statement.  However, when I commence reconciling the account for January in QB online, I get the message that the opening balance has a discrepancy.  Just can't figure this out!!

Adrian_A
Moderator

My bank balance and quickbooks balance do not balance please can someone tell me how to balance it

Thanks for the details, Queanbeyan Hospital Auxiliary.

 

Aside from the reasons shared by my colleague above about the causes of the discrepancy, it can also be that the transactions status were modified.

 

When the status of a previously-reconciled items were changed from Reconciled (R) to Cleared (C) or blank it can cause the opening balance error. It can also be that the unreconciled transactions were changed to Reconciled.

 

If the bank account is connected to QuickBooks, let's try to match and categorise the transactions. This is to make sire that the beginning balance is correct.

 

Then, reconcile again.

 

If the same thing persists, I'd recommend reaching out to our Phone Support team. An agent can do a screen-share with you and review what causes the discrepancy.

 

You can contact them by clicking the ? Help icon and then continue with the on-screen instructions to get in touch with our support.

 

I've added this reference for more information about reconciliation: Fix issues for accounts you've reconciled in the past in QuickBooks Online.

 

Feel free to mention my name as to how these information works on your end. Keep safe!