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! Go to Solution.
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.
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.
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
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.
Enjoy continuous data backups, and bespoke reporting with QuickBooks Advanced
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
These cookies are strictly necessary to provide you with the services and features available through our site. Because these cookies are strictly necessary to deliver the site, you cannot refuse them without impacting how the site functions.
These cookies are used to make advertising messages more relevant to you and your interests. They also perform functions like preventing the same ad from continuously reappearing, ensuring that ads are properly displayed, and in some cases selecting advertisements that are based on your interests.