Change Closing/End Date of a reconciled C.C. Account

Let me make it up to you by ensuring you can fix the end date of your reconciled account in QuickBooks Online, @Luxury_Pools.

Once your account is reconciled, we can only change the end date by unreconciling it. However, please keep in mind that even small changes can unbalance your accounts. That said, I recommend reaching out to your accountant when doing the process to ensure the accuracy of your accounts.

Once you're ready to undo the reconciliation, here's how:

1. Go to the Accounting menu, then select Chart of Accounts.
2. Select the account you're working on, and click on View Register.
3. Find the transaction you want to unreconciled.
4. Select the transaction to expand the view.
5. In the checkmark column, select the box with the "R" until the box is blank. This removes the transaction from the reconciliation.
6. Select Save.

For a more detailed step-by-step procedure for this process, here's an article you can refer to more details: Undo or remove transactions from reconciliations in QuickBooks Online.

If you encounter any issues while reconciling, you can check out this article to learn about fixing them: Fix issues at the end of reconciliation in QuickBooks Online.

You can post anytime if you have more reconciliation or QBO-related concerns. Please know the Community has your back. Take care always.

Thank You.

I googled and found this. (Below)

But it is the last line where the “Note” is that there is no “Undo” option.

I followed the steps and made sure I opened out Company File From QuickBooks Online Accountant view and nothing changed; there still was no option to undo the reconciliation.

————

When you're in their company file:

1. Go to the Accounting menu.
2. Select 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. Review any discrepancies and changes your client wants to make.
8. When you’re ready, select the dropdown  in the Action column, and then select Undo.
9. Select Yes and then Undo to confirm.

Note: If you don't see Undo, make sure you've opened your client's   company file from QuickBooks Online Accountant.

Thanks for getting back here, @Luxury_Pools. I'll share some information to help you undo the reconciliation in QuickBooks Online (QBO).

I appreciate you sharing the steps you've performed. To ensure you'll see the Undo option you have to use the QuickBooks Online Account (QBOA) version (If you have one. If none, you have to reach out to your accountant). Switching to the Accountant view in your QBO (Simple Start, Essentials, Plus, and Advanced) account won't allow you to undo the entire reconciliation. 

If you have a QBOA account, follow these steps to undo a reconciliation.

1. Sign in to your QBOA accountant account. 
2. Once done, select the Go to QuickBooks dropdown and choose your company file name under All clients.
3. When opened, go to the Accounting menu and select Reconcile. 
4. From there, click the History by account link.
5. Next, choose the bank's name in the Account field.
6. Then, look for the reconciliation you need to undo.
7. Select the dropdown arrow under Action and click Undo.

For reference, check out this article: Undo a client’s reconciliation in QuickBooks Online Accountant.

If you have none, you can refer to the steps outlined by my colleague, Carneil_C above. For more details, please read this link: Undo or remove transactions from reconciliations in QuickBooks Online.

You can also run a reconciliation report to have a clearer view of those transactions you reconciled for that account in a specific period. 

I'm always here ready to provide additional assistance if you have other concerns about modifying your reconciled transactions. Have a good one and stay safe. 

I have hundreds of transactions, are you saying that I need to this individually for everyone of them?? Surely there is a more efficient way! I added the wrong year as the end of reconciliation date by mistake! Is there not an easier way to fix this for a report with hundreds of transactions? 

Hey there, @Kerstin2. 

Thanks for chiming in on this thread. 

If your accountant has a QuickBooks Online Accountant account, then they can undo the entire reconciliation for you. This helps so that you don't have to do this action individually with each transaction. 

Review this guide for additional information: Undo a client's reconciliation. 

I hope this helps answer your question. If you have any other questions, don't hesitate to come back. Have great a day!