cancel
Showing results for 
Search instead for 
Did you mean: 
loupavonline
Level 2

Putting a transaction into an old reconciliation as a cleared item

We have a cleared check from a reconciliation in 2023 that is wrong, we need to delete/void that check and redo it. My question is, is there a way to adjust one reconciliation, say from June 2023, without it affecting all the following reconciliations? If I void the old check, how do I insert the new "correct" check in it's place so that old reconciliation remains in balance? 

Solved
Best answer 4 weeks ago

Best Answers
Ivan_G
QuickBooks Team

Putting a transaction into an old reconciliation as a cleared item

We have two options that we can choose from when handling your reconciled check with incorrect details, loupa. I'm here to lay them out for you.

 

The first option is to undo the previous reconciliations. Please know that we can't undo multiple reconciliations at once. That said, we'll have to do it manually until we reach the period to which the check belongs.

 

To do so, navigate to the Reconciliation page from the Banking menu and then select Undo Previous Reconciliation. A notification will prompt after the selection advising you to back up your company file. It's essential to store a copy of your data before proceeding for safekeeping.

 

Once you've finished the process, you can delete and recreate the check or locate and modify it accordingly. Following that, reconcile the previously unreconciled months.

 

If you want to edit the check, here's how:

 

  1. From the Banking page, select Write Checks.
  2. Click the Find button and enter the accurate check detail on the Find Checks prompt.
  3. Hit Find and double-click the check.
  4. Modify the check information accurately, and once done, tick Save & Close.
  5. Reconcile the previously unreconciled months till the present data.

 

On the other hand, please refer to the steps below if you want to delete and recreate the check instead:

 

  1. From the Banking page, select Write Checks.
  2. Click the Find button and enter the accurate check detail on the Find Checks prompt.
  3. Hit Find and double-click the check.
  4. Tick the X Delete option and then OK to confirm the deletion. Then, recreate the check.
  5. Reconcile the previously unreconciled months till the present data.

 

Meanwhile, the second option is to do a mini-reconciliation. Its process requires adjustment and is risky as it affects your records from previous and following months. For this, I recommend seeking an accounting professional to guide you thoroughly.

 

I'm also adding this article that provides insights on how to get a complete view of your previous reconciliation in the system: Get reports for previous reconciliations in QuickBooks Desktop.

 

The Community team is here for you 24/7. With that, you can always post another query if you have any about your reconciliation data, reports, or other menus and features in QuickBooks. We'll ensure to provide the best assistance.

View solution in original post

3 Comments 3
Ivan_G
QuickBooks Team

Putting a transaction into an old reconciliation as a cleared item

We have two options that we can choose from when handling your reconciled check with incorrect details, loupa. I'm here to lay them out for you.

 

The first option is to undo the previous reconciliations. Please know that we can't undo multiple reconciliations at once. That said, we'll have to do it manually until we reach the period to which the check belongs.

 

To do so, navigate to the Reconciliation page from the Banking menu and then select Undo Previous Reconciliation. A notification will prompt after the selection advising you to back up your company file. It's essential to store a copy of your data before proceeding for safekeeping.

 

Once you've finished the process, you can delete and recreate the check or locate and modify it accordingly. Following that, reconcile the previously unreconciled months.

 

If you want to edit the check, here's how:

 

  1. From the Banking page, select Write Checks.
  2. Click the Find button and enter the accurate check detail on the Find Checks prompt.
  3. Hit Find and double-click the check.
  4. Modify the check information accurately, and once done, tick Save & Close.
  5. Reconcile the previously unreconciled months till the present data.

 

On the other hand, please refer to the steps below if you want to delete and recreate the check instead:

 

  1. From the Banking page, select Write Checks.
  2. Click the Find button and enter the accurate check detail on the Find Checks prompt.
  3. Hit Find and double-click the check.
  4. Tick the X Delete option and then OK to confirm the deletion. Then, recreate the check.
  5. Reconcile the previously unreconciled months till the present data.

 

Meanwhile, the second option is to do a mini-reconciliation. Its process requires adjustment and is risky as it affects your records from previous and following months. For this, I recommend seeking an accounting professional to guide you thoroughly.

 

I'm also adding this article that provides insights on how to get a complete view of your previous reconciliation in the system: Get reports for previous reconciliations in QuickBooks Desktop.

 

The Community team is here for you 24/7. With that, you can always post another query if you have any about your reconciliation data, reports, or other menus and features in QuickBooks. We'll ensure to provide the best assistance.

loupavonline
Level 2

Putting a transaction into an old reconciliation as a cleared item

Thank you for the quick reply. So my only option (on my own) is to undo 12 months of reconciliations to get to the one that needs to be edited. I was hoping to avoid that. Thanks for your help (and instructions)

JorgetteG
QuickBooks Team

Putting a transaction into an old reconciliation as a cleared item

We appreciate you for coming back, Loupa.

 

I'm delighted to hear that the information provided effectively addressed your concern. Our utmost priority is to offer you the assistance you require consistently.

 

I can see the challenge of undoing the last 12 months of reconciliation to get to the one that needs to be modified. It's best to consult with your accountant for accurate bookkeeping while considering the adjustments required for performing a special reconciliation, as suggested by my colleague.

 

Furthermore, you can run reports for previous reconciliations in QuickBooks Desktop to identify discrepancies and other issues.

 

If you're interested in sprucing up your reports in QuickBooks Desktop, you might find this article helpful: Customize reports in QuickBooks Desktop. It offers detailed information on personalizing reports to suit your needs.

 

Please remember that you can always share your concerns here if you need further support with reconciliation or any other QuickBooks-related concerns. We are here to lend a helping hand.

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

Need to get in touch?

Contact us