Question

Fix reconcile end date

10 replies
130 views

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,

QuickBooks Online

C

ChristieAnn 11

Level 9

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:

Go to the Accounting tab on the left panel.
Under Your Company, select Chart of Accounts.
Choose the account you’re working on, and click on View Register.
Select the transactions you want to unreconciled.
Keep on clicking the R status until it shows blank or cleared (C).
Click on Save.
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!

C

CoryCAuthor

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.

C

Carneil_C

Level 6

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:

Go to the Gear icon at the top and pick Reconcile under the Tools column.
On the Reconcile an account page, click the History by account link to open the History by account screen.
From there, press the Account and Report period drop-down arrows to locate the reconciliation to correct.
Click Undo on the Action column and Yes.
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!

Sign up

Login with SSO

Let's get you signed in

Login with SSO