cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Get unlimited expert tax help and powerful accounting in one place. Check out QuickBooks Online + Live Expert Tax.
Batman64
Level 1

I finalized a checking account reconcilement with an ending date that was one year later than the actual date. How do I fix that?

 
Solved
Best answer March 06, 2024

Best Answers
JuliaMikkaelaQ
QuickBooks Team

I finalized a checking account reconcilement with an ending date that was one year later than the actual date. How do I fix that?

Hello there, @Batman64.

 

Thanks for dropping by the Community space. I’d be here to provide details on how the reconciliation works and fix your reconciliation in QuickBooks Online.

 

If your transactions aren't reconciled yet and are still in the process of reconciling your account, you can change the ending date by modifying it to the reconciliation page. You can follow the steps below for guidance:

 

  1. Go to Transactions, then select the Reconcile tab.
  2. Choose the bank account from the Account dropdown list.
  3. Click the Resume reconciling button.
  4. Tick the Edit Info button located in the upper right-hand corner.
  5. Change the Ending Date.
  6. Click Save.

 

On the other hand, if you've already completed the reconciliation, the option to change the ending date in the program is unavailable. However, you can manually undo transactions from the completed reconciliation. Before proceeding, I recommend consulting with your accountant to ensure your records are in order. They can also undo the entire reconciliation by using the Undo reconciliation feature to unreconciled entries without manually editing individual transactions from within the register. This feature is only available if they're using the QuickBooks Online Accountant version to manage their accounts. 

 

Here's how to manually unreconciled transactions:

 

  1. Go to Transactions, then select Chart of Accounts.
  2. Find the account for the reconciled transactions, then click View Register.
  3. Look for the transaction that you want to unreconciled, then in the check column, keep on clicking the R status until it shows as blank.
  4. Click on Save, then choose Yes in the confirmation window.

 

For more information, you can refer to this article: Undo or remove transactions from reconciliations in QuickBooks Online.

 

Once you've undone the transactions, you can start the reconciliation process again and enter the correct ending date.

 

Moreover, I’ll attach these links that’ll guide you further on fixing issues when reconciling an account within the program:

 

 

Feel free to leave a comment below if you have any further questions or concerns regarding your reconciled transactions. I will be available to assist you. Take care always!

View solution in original post

3 Comments 3
JuliaMikkaelaQ
QuickBooks Team

I finalized a checking account reconcilement with an ending date that was one year later than the actual date. How do I fix that?

Hello there, @Batman64.

 

Thanks for dropping by the Community space. I’d be here to provide details on how the reconciliation works and fix your reconciliation in QuickBooks Online.

 

If your transactions aren't reconciled yet and are still in the process of reconciling your account, you can change the ending date by modifying it to the reconciliation page. You can follow the steps below for guidance:

 

  1. Go to Transactions, then select the Reconcile tab.
  2. Choose the bank account from the Account dropdown list.
  3. Click the Resume reconciling button.
  4. Tick the Edit Info button located in the upper right-hand corner.
  5. Change the Ending Date.
  6. Click Save.

 

On the other hand, if you've already completed the reconciliation, the option to change the ending date in the program is unavailable. However, you can manually undo transactions from the completed reconciliation. Before proceeding, I recommend consulting with your accountant to ensure your records are in order. They can also undo the entire reconciliation by using the Undo reconciliation feature to unreconciled entries without manually editing individual transactions from within the register. This feature is only available if they're using the QuickBooks Online Accountant version to manage their accounts. 

 

Here's how to manually unreconciled transactions:

 

  1. Go to Transactions, then select Chart of Accounts.
  2. Find the account for the reconciled transactions, then click View Register.
  3. Look for the transaction that you want to unreconciled, then in the check column, keep on clicking the R status until it shows as blank.
  4. Click on Save, then choose Yes in the confirmation window.

 

For more information, you can refer to this article: Undo or remove transactions from reconciliations in QuickBooks Online.

 

Once you've undone the transactions, you can start the reconciliation process again and enter the correct ending date.

 

Moreover, I’ll attach these links that’ll guide you further on fixing issues when reconciling an account within the program:

 

 

Feel free to leave a comment below if you have any further questions or concerns regarding your reconciled transactions. I will be available to assist you. Take care always!

Batman64
Level 1

I finalized a checking account reconcilement with an ending date that was one year later than the actual date. How do I fix that?

Thank you for the response JuliaMikkaela. Despite the ending date being incorrect the opening and closing balances were correct and the account reconciled appropriately without adjustment. Subsequent monthly reconcilements were done. Will the process you described to manually unreconcile the transactions in the reconcilement with the incorrect ending date and then reconcile with the correct ending date affect the subsequent reconcilements that were finalized?

MelroseV
QuickBooks Team

I finalized a checking account reconcilement with an ending date that was one year later than the actual date. How do I fix that?

Let me chime in on this conversation, Batman64.

 

If you undo your reconciliation and then adjust the ending date, it won't impact any of your future completed reconciliations. You can refer to your accountant for undoing your reconciliation to guide you further. In case you don't have an accountant, you can visit this page to get one: Find a QuickBooks ProAdvisor.

 

If you ever want to learn more about reconciliation in the future, I've got some resources that might come in handy. Feel free to check them out whenever you can:

 

Should you have additional questions regarding your reconciliation in QuickBooks Online, please don't hesitate to post them here in the Community space. Stay safe!

Log in today
Get expert help and peer support to tackle all your QuickBooks questions effortlessly.

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