Skip to main content
February 3, 2022
Question

The "last reconciled" date is incorrect in my register. Can I correct the "last reconciled" date in my register?

  • February 3, 2022
  • 1 reply
  • 0 views
My register states that the last reconciled date is 1/31/21 but it is actually 12/31/21. How can I fix it?

1 reply

February 3, 2022

Hello there, gutsy4.

 

Thank you for posting your concern here in the Community. I've got the steps you'll in changing the last reconciled date in QuickBooks Online (QBO).

 

You can change the date by undoing and then redoing your reconciliation. To minimize the impact of your books, I'll suggest undoing the entries one at a time.

 

Here's how:

 

  1. Click on the Accounting menu.
  2. Choose Chart of Accounts.
  3. Find the account holding the transaction, tap the View register.
  4. Hit the transaction you want to unreconciled to expand the view.
  5. Review the check column. If the transaction is reconciled, you'll see an "R".
  6. Tick the checkbox until the box is blank. This removes the transaction from reconciliation.
  7. Choose Save.
  8. Close the account register.

 

I also added a link to give more insights about unreconciling transactions. I recommend consulting with your accountant before performing any of the steps. This is to ensure your records are in order. 

 

I've also added this article adjust small amounts after reconciliation.

 

Please touch base with us if you have any concerns and questions regarding your reconciliation. As always, we're here to ensure that you'll get the help you need.

gutsy4Author
February 3, 2022

This is not my issue. The account was reconciled on “12/31/21” but it says “last reconciled on “1/31/21”. I can’t even find my reconciliation reports after 1/31/21 although I have reconciled every month and have the print out. I know how to remove or adjust one transaction, but thank you for responding. 

February 3, 2022

Thank you for getting back to us, @gutsy4. I’ll share some insights about changing the reconciliation ending date in QuickBooks Online (QBO).

 

With QuickBooks Online, you have the option to change the ending date if you haven’t completed it yet. You can go back to the reconciliation page and change the Ending Balance and Ending Date. You can check out this link and refer to Step 2: Check the ending balance you entered for a detailed step.

 

Since this has already been reconciled, the option to change the date is unavailable in QBO. What we can do is to undo the reconciled transactions. You can refer to the steps that my colleague provided above.

 

Moreover, you can check out this article about year-end guide for QuickBooks Online.

 

Let me know if you need further assistance with bank reconciliation. The Community always has your back. Have a great day!