Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Transactions were deleted by accident. I used the Audit Log to figure out what they were and I rekeyed them into the register and flagged them as "R" reconciled and the beginning balance is still off. What do I do? There were at least 40 entries that were deleted somehow. It's taken me two hours to fix it the best I can but my beginning balance is still off. I was trying to follow the advice from someone regarding a off-cycle reconciliation but I can't seem to make it work.
Let's resolve the beginning balance discrepancy, @Oodles62.
There are lots of possible reason why you're having a beginning balance discrepancy and accidentally deleting previously-reconciled transaction is one of it. You're right in recreating those deleted transactions and manually reconciling them.
You can check this article for more information: About beginning balance discrepancies.
Here are some of the causes as well that you'll need to review from your account:
You can refer to the following article for detailed guidance on how to fix it: Fix issues for accounts you've reconciled in the past in QuickBooks Online.
Feel free to reply to this post if you have additional questions in reconciling your accounts. I'll be here to help. Have a wonderful day!
So here's the thing. I have been reconciling for a while in QB's online. And with the help of tech support, on a six hr call, we reentered the deleted transactions and then we "reconciled" them as they were before. This did nothing to change the beginning balance. Then we went to virtually all the reconciled reports under banking and looked at every entry that had been changed since that reconciliation took place. Where necessary we re-entered those transactions. My beginning balance is still not right. I thought if you deleted an already reconciled line item, then you go back to the register and you enter it the very same way it was then you re-reconcile the item. Is this not correct? Because nothing is making my beginning balance right and at this point I have been told to do a journal entry to plug that figure which is so wrong in my book. There must be a way to fix this.
So here's the thing. With the help of technical support on the line, we entered those transactions back into the system and flagged them as "reconciled" and guess what? The beginning balance did not change whatsoever. I watched this person (on a screen share) work with this issue for more than six hrs. And in the end I was told to write a journal entry to put the balance back where it was. That was completely unacceptable to me but I was forced to do it because after that many hours of high level support that was my only answer. The is something wrong with this system if I cannot (a) find the original entries somewhere to determine exactly what account it was once posted to and (b) if I enter them back in and reconcile them, it should change everything, and (c) if that doesn't happen then there ought to be a way of reaching a back up to reload so it can all be undone without so much pain and agony and loss of productivity. Just saying.....
I have this same issue right now. Only I had downloaded credit card deposits for tax purposes then went to undeposited funds and created the same deposit. I deleted the original but replaced it with the correct deposit for the same amount. My report showed this to be the reason my starting balance was off. I reconciled them in the register but the starting balance never changed. Did you ever get the proper steps and make yours correct?
Any help is appreciated.
Sadly enough nobody could solve my problem! They're only suggestion was to journal the difference and we took it to a made up account called "balance discrepancies". Too large of a number in my opinion to be sitting in a journal entry. But honestly I am getting more and more discouraged about Quick Books online in general. I think it has a lot of holes. I wish I could help you out. Right now I'm nervous about ever deleting anything. Because the biggest point I have here is that these entries were NOT reconciled. They were just sitting there like duplicates. It should not have affected anything to have deleted them. If you get an answer to your situation, please share it here for us. I would really appreciate that immensely!
Thank you for getting back to us here on the Community page, Oodles62.
Reconciliation discrepancies are usually caused by the following factors:
To clear the discrepancies in your QuickBooks Online, you need to check the transaction and the cause of the discrepancy. Here's how:
After you review everything on the discrepancy report, the Total Discrepancy Difference on the report should be $0.00. Check the beginning balance again in QuickBooks. It should match the beginning balance on your bank statement. Select Resume reconciling to continue reconciling.
This link provides complete steps about handling balance issues:
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.
Will this work for multiple transactions or only a few?
I'm not sure if this is the same, but I also encountered an issue with the beginning balance of a new account (around 3 months old). I did a lot of changes to the prior months' transactions so I undo all the previous reconciliations. When I was ready to reconcile again, there was a Opening balance figure on the recon screen when it should have been zero(0). So I checked the Opening Balance JE, tried editing it and I even deleted it but the Opening balance figure is still unaffected. Turns out the issue was because after undoing all the previous reconciliations, There were still transactions on the register that were marked as (R) reconciled when there should have been none. I believe these were the transactions that I manually marked (R) before. After I removed the (R) tagging, the opening balanced reverted back to zero.
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.
For more information visit our Security Center or to report suspicious websites you can contact us here