Several Duplicates, Now Reconciliation is Off After Deleting
I am trying to reconcile one of my accounts. I have been through all of my accounts (8 total) several times, and have removed several duplicate transactions and transactions that were incorrect. For instance, a transfer from account A to account B - with all of the details entered and logged correctly, was showing in the register for account C.
This has happened several times, over the last few hours, and I have spent about 6 hours now editing ALL of the accounts to match the bank statements because of duplicates and incorrect transactions.
I am very new to doing this myself, as I have hired several bookkeepers that have made numerous very large mistakes, costing me over $20k - and I admit I am very frustrated, and now near tears for the third time in the 13 hours I've been working on this today. I didn't know that a reconciliation was so final, and after reconciling successfully to $0, more transactions showed up and I removed them. Now, I can't reconcile the account anymore because the beginning balance - which was originally entered at the correct amount of $4,334.94 is showing that it should be $173,733.5, which is incorrect.
I have gone through numerous support articles, and I updated the amount, as it says to do online in support, and it said the same thing. I removed the line and added a different line with the correct opening balance, and now it says the opening balance should be $169,398.56, which is also incorrect. The opening balance should be $4,334.94, as it was entered when it was imported.
When I look at the "We can help you fix it" link that goes to the discrepancy, it shows all of my transactions that were deleted - because they were incorrect. The deletions are accurate and correct, and need to stay deleted, as they were in the wrong account or duplicates.
There were SEVERAL errors when entering all of my accounts, and I spent several hours updating everything, and now I'm being punished for deleting these errors? The errors were in QuickBooks - and now everything matches my statements after several hours working on this. I finally have the accounts matching the bank statements, categorized and correct, and now I can't reconcile.
Several of my peers warned me not to use QB because of errors like this, but I know that my CPA has asked for QB files in the past so I wanted to try it, and this is becoming quite a nightmare.
Can someone please help? Support is closed. 😔 I would really, really appreciate it. ❤️ I'm typing this out before going to bed, so I can attack it head on first thing in the morning. Thank you in advance.