cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Visit this post for a list of recent banking issues in QuickBooks Online.
Rob Simmonette
Level 1

Quickbooks figures dont match bank balance

So yesterday i amended my opening balance in Quickbooks and both quickbooks and banking figures matched. However today after matching pdq payments and adding supplier expenses the figures once again don't match - please help!

Solved
Best answer October 01, 2021

Accepted Solutions
EmmaM
QuickBooks Team

Quickbooks figures dont match bank balance

Hello Rob Simmonette, there's a reconcile tool within Quickbooks, with which you can find out where the discrepancy is, for example, is there missing transactions, duplicates, etc To do this you click on the cog in the top right of QB and then click on reconcile>it will already have a beginning balance if you added an opening balance it will ask you to put ending date and ending balance at the bank itself we usually recommend doing one month reconcile as its easier to breakdown the point the balance became mismatched that way, once you save that it will ask you to tick all the transactions that should be included( you can check this against you bank statement) it should then show in the figures zero difference. We have included a video here that goes through the process. If it does not show zero difference then that is the point you would look at your statement for missing transactions/duplicates and add missing or remove duplicates. Then go on to the next month and do the same till you are at the current month. Any questions feel free to come back here.

View solution in original post

3 REPLIES 3
Ashleigh1
QuickBooks Team

Quickbooks figures dont match bank balance

Hello Rob Simmonette, 

 

Welcome to the Community page, 

 

You will need to do a reconcile on the bank to see why there is a difference also why did you amend the opening balance on the account for? Also to make you aware that the Quickbooks Balance and the bank Balance can be different when new transactions come in if they have not been matched or reconciled too. 

Rob Simmonette
Level 1

Quickbooks figures dont match bank balance

Hi thanks for your reply

 

When we checked our account statement the opening figures didn't match for some reason thats why we changed it. How do i go about doing a reconcile? Sorry for all the questions im new to all this

 

Thank you

EmmaM
QuickBooks Team

Quickbooks figures dont match bank balance

Hello Rob Simmonette, there's a reconcile tool within Quickbooks, with which you can find out where the discrepancy is, for example, is there missing transactions, duplicates, etc To do this you click on the cog in the top right of QB and then click on reconcile>it will already have a beginning balance if you added an opening balance it will ask you to put ending date and ending balance at the bank itself we usually recommend doing one month reconcile as its easier to breakdown the point the balance became mismatched that way, once you save that it will ask you to tick all the transactions that should be included( you can check this against you bank statement) it should then show in the figures zero difference. We have included a video here that goes through the process. If it does not show zero difference then that is the point you would look at your statement for missing transactions/duplicates and add missing or remove duplicates. Then go on to the next month and do the same till you are at the current month. Any questions feel free to come back here.

Need to get in touch?

Contact us