Showing results for 
Search instead for 
Did you mean: 
Level 2

Bank account reconciliation a complete mess way too many deleted and changed transactions

So its time for me to admit how lazy and stupid I treated this whole reconciliation process for the last year.

I started QuickBooks last year and was constantly trying to teach myself and get everything figured out. Its been a learning process still is. I figured at the time since it was already half through the year and was still keeping tabs on my own expenses and sales myself. I would be able to use last year to start getting everything down and I would just use my own records for taxes. Which I did. 

At the moment we have just been selling on ebay and with their records and then a spreadsheet for my expenses I had most of what I needed. Used QBO for mileage.

I had some dificulties following along for awhile and I gave up with the reconciliation because I kept sending it way off and in my process of figuring everything out I had been matching and unmatching transactions deleting things that should have just been moved somewhere it was just a mess. Ive got most of it down now and am confident I could keep the QB balance and my bank in sync. 

But it feels impossible to go back and fix everything and I dont really feel like its important bc I have my other records. I want everything to be correct from the beginning of this year. To just like start clean from 1/1/22. As far as my bank goes.

But of course I can see no way to do that and nobody has even mentioned wanting to do that in the community as far as I can see.

I know everyone will say.. Ask your accountant... IM NOT DOING THAT. 

All I want to know is can I start the Bank balance from the beginning of the year. With the opening amount being what it physically was on that date? Like maybe Redirecting it all to a new account in the chart of accounts or something? Or am I going to be told the only thing I can do is go to the beginning and use my bank statements and do the reconciliation? BC Im really not sure I will be able to sort the thing out. 

And like I said there is no accountant to ask 

5 Comments 5
QuickBooks Team

Bank account reconciliation a complete mess way too many deleted and changed transactions

Glad to have you here on the Community page, MiddleClassValues.


I'm here to help correct the opening balance so you can reconcile in QuickBooks Online. 


You'll have to check the beginning balance in QuickBooks every time you start reconciling an account. It's the amount in your account at the beginning of the time period you're viewing at..

For the same start day, the beginning balance amount should match what's on your bank statement. That being said,  you can fix the opening balance by entering the balance of your real-life bank account.


You need to set the opening balance at the beginning of a bank statement. Then follow these steps to review it:


  1. Select the Accounting menu, then select Chart of Accounts.
  2. Find the account on the list.
  3. Select View register.
  4. Search for the opening balance entry. It should have "Opening Balance Equity" in the Account column.
  5. Take note of the date and balance.
  6. Next, you need to compare the opening balance with your real-life account.
  7. Sign in to your bank's website, or find your bank statement.
  8. Check the account's balance for the same day as the opening balance in QuickBooks.
  9. Compare the two balances.


You can check out this article if the opening balance in QuickBooks doesn't match your bank records: Fix issues the first time you reconcile an account in QuickBooks Online.


When you're ready to reconcile in the future, here is an article link: Reconcile bank accounts in QuickBooks Online.


That should do it! Please know that I'm just a post away if you have any other concerns about Opening Balance. Have a good one. 

Level 2

Bank account reconciliation a complete mess way too many deleted and changed transactions

No thats not going to help Ive deleted and messed up tons of transactions for 8 months I need to start over

QuickBooks Team

Bank account reconciliation a complete mess way too many deleted and changed transactions

There are a few ways you can take to start the bank balance from the beginning of the year, @MiddleClassValues.


I'd be happy to provide details on how you can do it.


You can create a new bank account in your QuickBooks Online (QBO) company and import or download the transactions from there. 


To do so, you can first disconnect the old one and connect the new bank account in QBO.


On the other hand, if you want to start with a newly QBO company, you can cancel your current subscription and signup for a new account. You may want to check this article for more information: Delete your data and start over in QuickBooks Online.


Once everything is fine, you can visit our Reconciliation hub to guide you in reconciling your accounts. This also includes instructions on how you can fix reconciliation issues. 


Also, reviewing your previous reconciliation to prevent errors in the future is necessary. To do this, you can pull up a reconciliation report in QBO. 


I'm just around the corner to help if you have any other concerns about managing your account. Just leave a reply below and I'll circle back to assist you.

Level 1

Bank account reconciliation a complete mess way too many deleted and changed transactions

I made a mess of our reconciliation and have spent hours trying to figure it out. Is there a way to wipe out everything and start over for the year?

QuickBooks Team

Bank account reconciliation a complete mess way too many deleted and changed transactions

Hi there, borstjz.


Thank you for visiting the QuickBooks Community. I'll ensure you'll be able to wipe out all the reconciled entries and start a new beginning in QuickBooks Online.


Yes, there is a way to wipe out everything in your reconciliation and start over for the year if you have an accountant who uses QuickBooks Online accountant or if you are the one who is using the said version. To do this, I suggest going to the Reconcile section and you can view a particular option from there to begin the procedure. Please know that you may want to download any attachments tied to the reconciliation because undoing a reconciliation deletes all existing attachments.


Here's how to undo:



  1. In QuickBooks Online Accountant, signed in as an accountant user and select the client from the drop-down list on the Tool belt to open the client's company file.
  2. Go to the Accounting menu. Then, choose the Reconcile tab.
  3. Select History by account.
  4. Select the account you want to reconcile and date range from the dropdowns.
  5. Find the reconciliation on the list.
  6. Select View report to open the Reconciliation Report.
  7. Check any discrepancies and changes your client wants to make.
  8. When you’re ready, select the dropdown arrow in the Action column, and select Undo.
  9. Click Yes and Undo to confirm.


However, if you're using the regular version of QBO, the only option to delete or wipe out a reconciliation is to undo each transaction manually. You may refer to this article to see the steps on how to perform the process: Undo or remove transactions from reconciliations in QuickBooks Online.


Lastly, you may refer to this article to view various guidelines that might help you in fixing any reconciliation issues: Learn the reconcile workflow in QuickBooks.


If there's anything else I can help you with, aside from reconciliation, please let me know by leaving a comment below, borstjz. I'm always here to help. Have a great day!

Need to get in touch?

Contact us
Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up