Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Connect with and learn from others in the QuickBooks Community.
Join nowI am working with company who started a new bank account in 2020. Their operations are messy to say the least but I'm only hired to clean up after they do the daily operations. I had the bank account in question reconciled through the YE 2020, but the staff at company had added their own expense entries hitting that bank account, billing customers from the expense entries. So I went through and using the register changed the R from my entries to theirs one by one. I have done this many times with this company so that's nothing new and I know exactly how to do it.
The problem is that all of a sudden my "starting balance" was off according to QBO. I checked the historical reconciliation reports and the changes made section in particular. The changes all offset each other as I intended. I still got the error. In the past I've seen this but when you just hit Reconcile anyway those R entries equal out and you can reconcile with the correct starting balance, but this time the starting balance was still incorrect. So I saved for later, then resumed. This in the past has solved many calculation issues with Reconcile feature. But not this time.
So I saw the entries causing problems started in September and since I had spreadsheets with data to support bank reconciliation I just un-reconciled through September and figured I'd just redo it and solve the QBO problem with starting balance. When I did this is made it worse! Now the problems went back to just about the whole history of the bank account, or March 2020. So I just unreconciled the entire history of the account, figured that would solve it.
Now its saying that my starting balance is off by $100,000 which is inconceivable and I'm not sure how to fix it. I logged out in frustration and turned off my computer, hoping a reboot and time away would change something if the was some issue on QBO end which it appears.
I'm not sure how to proceed at this point. Advice? The support online chat seems to be out of commission, we're having really bad weather across the USA and perhaps that is another problem. I'll attach some screen shots.
Solved! Go to Solution.
I'm grateful for the details that you gave, @Dirkdaddy.
I'd like to shed some light regarding your beginning balance for your bank account in QuickBooks Online.
There will be a beginning balance in the system if there are reconciled transactions. If you've created changes to the reconciled entries, this will affect your opening balance.
To fix this, you'll need to undo the reconciliation. After that, go to your bank register and remove the R status of your transactions to zero out the amount.
Here's how:
For more details about this process, please see this link: Learn how to unreconcile an individual transaction from a completed reconciliation.
On the other hand, I'd also recommend checking this great reference, which talks about fixing issues for accounts you've reconciled in the past in QuickBooks Online. This link provides complete steps about handling balance issues: Learn what to review so you can start reconciling.
Please don't hesitate to reach out to me here should you have any further questions, I want to make sure you're taken care of. Thanks for coming to the Community.
I'm grateful for the details that you gave, @Dirkdaddy.
I'd like to shed some light regarding your beginning balance for your bank account in QuickBooks Online.
There will be a beginning balance in the system if there are reconciled transactions. If you've created changes to the reconciled entries, this will affect your opening balance.
To fix this, you'll need to undo the reconciliation. After that, go to your bank register and remove the R status of your transactions to zero out the amount.
Here's how:
For more details about this process, please see this link: Learn how to unreconcile an individual transaction from a completed reconciliation.
On the other hand, I'd also recommend checking this great reference, which talks about fixing issues for accounts you've reconciled in the past in QuickBooks Online. This link provides complete steps about handling balance issues: Learn what to review so you can start reconciling.
Please don't hesitate to reach out to me here should you have any further questions, I want to make sure you're taken care of. Thanks for coming to the Community.
Thank you for that. I didn't realize when I hit "un-reconcile" that some transactions would remain as marked R but you were correct that was the problem with this account. Well you learn something every day!
Now I wish that prior reconciliations would still be marked as cleared when reworking so it would be easier but that's probably wishful thinking.
Hi My name is Maureen
I did the same as you mention go to the Chart of account and untick the R.
But when I go to the bank to do the reconciliation the opening balance is still off
by the amounts that I untick in the register.
how can I fix this? Thanks,
You can hit "continue" I think it is where you get the warning of the opening balance and proceed. You can if I recall how I fixed it un-reconcile the manual R you did before, continue past warning then select that transaction which in effect will adjust the balance so it will tie out to ending period bank balance. Does that make sense?
QB should really refine this reconcile feature, its really a mess sometimes and I have wasted a lot of time dealing with it.
You can hit "continue" I think it is where you get the warning of the opening balance and proceed. You can if I recall how I fixed it un-reconcile the manual R you did before, continue past warning then select that transaction which in effect will adjust the balance so it will tie out to ending period bank balance. Does that make sense?
QB should really refine this reconcile feature, its really a mess sometimes and I have wasted a lot of time dealing with it.
Thanks so much for your time and effort Dirkdaddy. I close my computer and go back in and I reconcile all my transaction again and my opening balance was fixed back to the bank statement but it took me almost two days to work on it. Quick book online need a better solution for undoing bank reconciliation. example in Yardi which i used for several years you can open the bank account. and then click a button and unreconciled all transaction for that month and then re do in less than an hour. This is crazy there is always stuff that comes up with the bank that you need this feature to undo and redo.
Thanks again
Maureen
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.