Skip to main content
F
friends3
February 20, 2021
Question

I put the wrong statement ending date on a reconciliation. how can I change it?

  • February 20, 2021
  • 2 replies
  • 0 views
Original commenter did not share additional details

2 replies

katherinejoyceO
katherinejoyceO
February 20, 2021

Hi there, @friends3. 

 

Thanks for visiting the Community today. I'm here to help fix your reconciliation. 

 

If your transactions aren't reconciled yet, you can click the Edit info button in the upper right-hand corner of the reconciliation page. Then, change the Ending Date of your statement and click Save.

 

However, if it's already reconciled, you'll need to undo the reconciliation. Here's how: 

 

  1. Go to the Accounting menu, then select Chart of Accounts under Your Company. 
  2. Select the account you're working on, and click on View Register.
  3. Select the transactions you want to unreconcile.
  4. Keep on clicking the R status until it shows blank or cleared (C).
  5. Click Save.

 

You can also ask assistance from an accountant with a QBO Accountant subscription to undo an entire reconciliation. 

 

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

 

Let me know if you need more help with reconciliation. I'll always be here to help. 

R
rick85
April 4, 2023

I used your process of going to the bank register and "unreconciling" transactions - that I assumed would allow me to re-reconcile after I changed the statement date to the correct date.  It still won't allow me to add a new date.  Now what?

R
RCV
April 4, 2023

Let me provide some information about changing an incorrect date on a reconciliation,

 

We appreciate you carrying out my colleague's recommended solutions. We can still change the ending date if you haven't finished the reconciliation by returning to the reconciliation page. Then, modify the Ending Balance and End Date periods. Here's how it's done:

 

  1. Go to Accounting on the left menu.
  2. Click the Reconcile tab.
  3. Choose the bank account from the Account drop-down list.
  4. Tap the Resume reconciling button.
  5. Tick the Edit Info button located in the upper right-hand corner.
  6. Change the Ending Balance and Ending Date.
  7. Press Save.

 

However, if the reconciliation has already been completed, the option to change the date in QuickBooks Online is unavailable (QBO). We can reverse the reconciled transactions. Let me demonstrate: 

 

  1. Click Accounting at the left panel and choose Chart of Accounts.
  2. Locate the account for the transaction and click View register.
  3. Look for the transaction that you want to undo reconciliation.
  4. In the check column, repeatedly click the top line of the transaction until the box is blank. This removes the transaction from the reconciliation.
  5. Press the Save button.

 

To learn more about this one, see the Undo and remove transactions from reconciliations in the QuickBooks Online article. Once done, start the reconciliation again and enter the correct ending date. You can check the Reconcile an account in the QuickBooks Online article for the steps and details. Just in case QBO doesn't match your bank statement at the end of reconciliation, follow the steps in the Fix issues when you're reconciling accounts in the QuickBooks Online article to troubleshoot the issue. 

 

Feel free to visit our Reconciliation page for more insights about reconciling your bank account with QuickBooks.

 

I'd like to know how you get on after trying the steps, as I want to ensure this is resolved for you. Please reply to this post and I'll get back to you. You have a good one. 

katherinejoyceO
katherinejoyceO
February 21, 2021


Hi friends3,

 

Hope you’re doing great. I wanted to see how everything is going about changing the statement ending date on your reconciliation you had yesterday.

 

Was it resolved? Do you need any additional help or clarification? If you do, just let me know. I’d be happy to help you at any time.

 

Looking forward to your reply. Have a pleasant day ahead!

S
slinko
April 11, 2023

this "fix" completely wrecked my books.  Now the statement beginning balance is completely incorrect and doesn't match any of my statements.  I only unreconciled the entries from the statement I was trying to fix.  I can start a new reconcilliation but then it's a new reconcilliation and not fixing the old one. 

N
NaTashaB813
June 11, 2023

I had this issue today and this is how I fixed it:

 

Accounting -> Reconcile 

Upper Right Click History By Account 

Locate the incorrect Closing Date and click View Report

Click Undo

When prompted click yes to undo the last reconciliation.

Re-Reconcile the account with the proper ending date

 

Hope This Helps!

 

Terms & ConditionsAccessibility statement