Deleted Transactions

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:

• Edited a reconciled transaction or moved it to another account
• Unreconciled the transaction
• Someone already reconciled the transaction by accident.
• The account's opening balance is incorrect.

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: 

• Duplicate transactions.
• The transaction was associated with a different bank account.
• Previously reconciled transactions were edited or deleted.
• The opening balance or an account is incorrect.

To clear the discrepancies in your QuickBooks Online, you need to check the transaction and the cause of the discrepancy. Here's how:

1. Select + New.
2. Select the correct form (invoice, sales receipt, expense, etc).
3. Fill out the form and select Save and close.
4. Go to the Accounting menu. Then select Chart of Accounts.
5. Find the account that you put the transaction into and select View register.
6. Find the transaction and select it to expand the view.
7. Select the box in the checkmark column until you see an R. This manually reconciles the transaction.
8. Select Save. If you still see an alert the next time you reconcile, open the discrepancy report. The deleted transaction may still be on the list, but the difference should be $0.00. It won't affect your reconciliation.

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: 

• Learn what to review so you can start reconciling.
• How to fix differences between QuickBooks balance and bank balance.

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.