Fix reconcile end date

Hi there, CoryC.

Thanks for dropping by the Community space. I’d be glad to provide you with information on how reconciliation works in QuickBooks Online. Then, to ensure you'll be able to change the statement ending date by performing alternative steps.

Correcting the statement ending date that has been entered when reconciling an account is currently unavailable. Meanwhile, I recommend first undoing or removing the transactions from the completed reconciliation. I suggest consulting with your accountant before performing any of the steps. This is to ensure your records are in order. 

If you’re currently using QuickBooks Online Accountant, use the Undo a reconciliation feature to unreconciled entries without manually editing individual transactions from within the register. To visually guide you through the steps, click on this link: Undo a reconciliation.

However, if you’re using a different version, you'll have to manually unreconciled each transaction to undo the reconciliation. Let me provide you with the step-by-step process.

Here's how:

1. Go to the Accounting tab on the left panel.
2. Under Your Company, select Chart of Accounts.
3. Choose the account you’re working on, and click on View Register.
4. Select the transactions you want to unreconciled.
5. Keep on clicking the R status until it shows blank or cleared (C).
6. Click on Save.
7. Choose Yes in the confirmation window.

To see further details, you can open this article: Undo or remove transactions from reconciliations in QuickBooks Online.

After performing all these steps, you can now reconcile the transactions. Then, enter the correct ending date and make sure the information is similar to your bank’s statement.

Lastly, you may refer to this article to view different guidelines on how you fix any reconciliation issues: Learn the reconcile workflow in QuickBooks.

Don't hold back to drop a comment below if you have any other questions or concerns about your reconciled transactions. I’ll be here. Always take care!

This did not work.  Now I have 2 reconciliations for the same statement.  One ending 3/22/22 (a future date ...) and one for 2/23, the correct date.

Thank you for the prompt reply, @CoryC. Allow me to chime in and assist you with your query about fixing reconciliation issues in QuickBooks Online.

QBO automatically generates a new reconciliation report even if you reconcile the account for the same month. Reconciled transactions are those with the status R listed within the bank or credit card register.

Meanwhile, you can Undo the reconciled transaction. But, you still need to reach out to your accountant before making any changes.

Here’s how:

1. Go to the Gear icon at the top and pick Reconcile under the Tools column.
2. On the Reconcile an account page, click the History by account link to open the History by account screen.
3. From there, press the Account and Report period drop-down arrows to locate the reconciliation to correct.
4. Click Undo on the Action column and Yes.
5. Choose Undo to confirm the action.
   
   

From there, you can now delete the transaction to avoid duplicates.

Here's an article you can refer to for more details on how to unreconcile an individual transaction from a completed reconciliation.

In addition, I’ll also include these links that’ll guide you further on fixing issues when reconciling an account in QBO:

• Fix issues for accounts you've reconciled in the past in QuickBooks Online.
• Fix issues at the end of a reconciliation in QuickBooks Online.
• Edit an incorrect opening balance.
  
  

Please feel free to get in touch with me here if you have any additional questions about managing your transactions. The Community always has your back. Have a great day! 

There is no undo action.

Hi there, CoryC.

I appreciate you for coming back to the thread to add further clarification about your concern. I'll be sharing additional information about the undo option on the reconciliation page. This way, I'll ensure you'll be able to fix the statement ending date.

As I mentioned above, you can use the Undo a reconciliation feature to unreconciled entries without manually editing individual transactions from within the register if you’re currently using QuickBooks Online Accountant. With this, it could be you're utilizing the ordinary version and that's the reason why you're unable to see the Undo on the Action column. 

For now, you'll have to manually unreconciled each entry to remove this in the reconciliation. Please follow the steps provided above to guide you with the detailed process. You can also open this article for extra information: Undo or remove transactions from reconciliations in QuickBooks Online.

Lastly, you may refer to this article to view details on how QuickBooks lets you create an adjusting entry that forces your accounts to balance so you can finish your reconciliation: Enter an adjusting entry for reconciliation in QuickBooks Online.

If you need further assistance in managing reconciliation transactions, let me know by posting a comment below. I’m always ready to help. Have a great rest of your day!

Thank you for your information. I have the same issue, I enter an incorrect end date for a period so I need to undo it. I am unable to use "undo" drop down options because I do not have the online accountant version. I did manually changed all reconciled transactions from that period to "C" and saved. However, when I go back to reconcile it, the end date if of course still the same (incorrect) and it says my account it's not ready to be reconciled because there is a discrepancy, and the discrepancy corresponds to the transactions I unreconciled manually. How can I fix the end date? Amounts were all correct, there was no discrepancy originally, just the date. 

Thanks for coming back, Aroy83. We've got some additional information about the wrong ending date for your reconciled transactions.

Changing the ending date for the completed reconciled transactions is unavailable in QuickBooks Online (QBO). To correct this, here's what you'll need to do:

• Leave the date as it is and select the correct end date the next time you reconcile (an incorrect date doesn't affect any balances and will not prevent you from future reconciliation). 
• You can undo the reconciliation and then reconcile the correct ending date (which you already performed).

Before we can resume reconciling your account, you'll have to find the discrepancies in the reconciliation. In the red box, Your account isn't ready to reconcile yet, click the blue hyperlink We can help you fix it to see the transactions causing the discrepancies. 

We can also run a Reconciliation Report to view previous reconciliations to see if everything has balanced out, as well as see what transactions were recorded. Here's how:

1. Go to Reports.
2. Type Reconciliation Report in the Find report by name search bar.
3. Choose Reconciliation Reports.
4. Select the Account for the reconciliation report you want to view.
5. From the Report period drop-down arrow, pick the reconcile period.
6. Press View Report.

To learn more about this, check out this article: How do I view, print, or export a reconciliation report?. Once done, you can start the reconciliation process again and enter the correct ending date.

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

• Edit an incorrect opening balance
• Fix issues at the end of a reconciliation in QuickBooks Online
• Fix issues for accounts you've reconciled in the past in QuickBooks Online

Feel free to comment below, Aroy83 if you have any further questions or concerns regarding your reconciled transactions. We are always available to assist you. Take care always.

@RCV   Just wanted to confirm that there is no way to change the reconciled end date for prior reconciliations in Quickbooks Online and that your guidance to @aroy83 was only for Quickbooks Desktop users.  Is that correct?  If that is the case, then for Quickbooks Online users, if they put the reconciled end date as 1 year into the future by accident, is the only thing they can do is wait until that future period passes before they will be able to see the reconciled end date as correct again?

Welcome to the Community space. We appreciate you joining the thread and providing us with in-depth details about your concern, Richardnip.

Yes, that is correct. In QuickBooks Online (QBO), we cannot directly change the reconciled end date for prior reconciliations once they have been completed. Also, the steps that I've provided on this thread are for the QBO version. If a mistake has occurred, such as setting the reconciliation end date one year into the future, we can manually undo the reconciliation and redo it with the correct date. This process will allow you to set the right reconciled end date rather than waiting for the future period to pass.

Here are general steps to undo and redo a reconciliation:

1. Go to the Gear icon on the top menu. Then choose Chart of accounts (Take me there).
2. Find the account that has the reconciled transaction. Then click View register.
3. Find the transaction. If the transaction is reconciled, you’ll see an “R” in the checkmark ✔ column.
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. Press Save.
7. Close the account register.

You can check out this article for more details about unreconciling an individual transaction: Undo or remove transactions from reconciliations in QuickBooks Online. Be cautious when undoing reconciliations, as this will affect the entries and could potentially alter your financial reporting if not done accurately. We recommend consulting with your accountant for specific guidance tailored to your accounting needs.

If you’re currently using QuickBooks Online Accountant, use the Undo a reconciliation feature to unreconciled entries without manually editing individual transactions from within the register. To visually guide you through the steps, click on this link: Undo a reconciliation.

I've added here an article that will help you in case you encounter reconciliation issues: Fix issues when you're reconciling accounts.

Moreover, you can refer to this article on how to handle reconciliation starting from checking its opening balance, to fixing, and editing completed reconciled transactions: Learn the reconcile workflow in QuickBooks. 

The QuickBooks Community team is committed to supporting your business success. If you have further questions about reconciling your accounts or any QuickBooks-related concerns, revisit this thread. We're always here to assist you in achieving your financial goals, Richardnip.

Welcome to the Community space. We appreciate you joining the thread and providing us with in-depth details about your concern, Richardnip.

Yes, that is correct. In QuickBooks Online (QBO), we cannot directly change the reconciled end date for prior reconciliations once they have been completed. Also, the steps that I've provided on this thread are for the QBO version. If a mistake has occurred, such as setting the reconciliation end date one year into the future, we can manually undo the reconciliation and redo it with the correct date. This process will allow you to set the right reconciled end date rather than waiting for the future period to pass.

Here are general steps to undo and redo a reconciliation:

1. Go to the Gear icon on the top menu. Then choose Chart of accounts (Take me there).
2. Find the account that has the reconciled transaction. Then click View register.
3. Find the transaction. If the transaction is reconciled, you’ll see an “R” in the checkmark ✔ column.
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. Press Save.
7. Close the account register.

You can check out this article for more details about unreconciling an individual transaction: Undo or remove transactions from reconciliations in QuickBooks Online. Be cautious when undoing reconciliations, as this will affect the entries and could potentially alter your financial reporting if not done accurately. We recommend consulting with your accountant for specific guidance tailored to your accounting needs.

If you’re currently using QuickBooks Online Accountant, use the Undo a reconciliation feature to unreconciled entries without manually editing individual transactions from within the register. To visually guide you through the steps, click on this link: Undo a reconciliation.

I've added here an article that will help you in case you encounter reconciliation issues: Fix issues when you're reconciling accounts.

Moreover, you can refer to this article on how to handle reconciliation starting from checking its opening balance, to fixing, and editing completed reconciled transactions: Learn the reconcile workflow in QuickBooks. 

The QuickBooks Community team is committed to supporting your business success. If you have further questions about reconciling your accounts or any QuickBooks-related concerns, revisit this thread. We're always here to assist you in achieving your financial goals, Richardnip.