cancel
Showing results for 
Search instead for 
Did you mean: 
CoryC
Level 1

Fix reconcile end date

I accidentally entered the wrong statement ending date when I reconciled an account.  I realized this after I clicked finish.  How do I correct the statement ending date?

 

Thanks,

5 Comments 5
ChristieAnn
QuickBooks Team

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!

CoryC
Level 1

Fix reconcile end date

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.

 

QBO capture.JPG

Carneil_C
QuickBooks Team

Fix reconcile end 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:

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! 

CoryC
Level 1

Fix reconcile end date

There is no undo action.

 

QBOCapture2.JPG

ChristieAnn
QuickBooks Team

Fix reconcile end date

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!

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us