Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
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:
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:
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.
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!!
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!
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.