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

Error in Reconciliation

I was cleaning up accounts in the company, then found a check entered wrong. I deleted the payment and reentered it with all the correct info. However, the one I deleted was reconciled and now my reconciliations for the account are screwed up. Is there any way I can just open the old reconciliation and correct the single transaction? Can I just check it as reconciled in my COA? Or am I going to have to undo every reconciliation until I get back to the month with the error? I'd like to avoid having to redo months of reconciliations if possible. 

Solved
Best answer July 07, 2020

Best Answers
jamespaul
Moderator

Error in Reconciliation

Hello, Chloecs.

 

I appreciate your time posting here for confirmation on what to do with the corrected check. I have another solution we can do before we touch the "undo every reconciliation" part.

 

Checking the transaction as "reconciled" in the COA won't reflect the changes properly. This can throw off your next reconciliation period. 

 

To fix this, you'll want to do an "off-cycle" reconciliation to reflect the changes. Though, this works if you just changed the memo, payee and other details of the check. Before doing this, I'd recommend creating a backup copy of your company file

 

To do the off-cycle reconciliation process: 

 

  1. Click Banking, then choose Reconcile.
  2. In the Begin Reconciliation screen, select your bank account. 
  3. Choose an off cycle date for the Statement Date.
  4. Enter the Ending Balance of your last reconciliation. 
  5. Hit Continue
  6. Check the deleted transaction and ensure it has a zero difference.
  7. Click Reconcile Now.

 

Offcycle.PNG

 

More details can be found here: Reconcile previously deleted and re-entered checking or credit card transactions.

 

Also, if you edited the amount, then this will likely throw off the balances of the other reconciled statements. In this case, you'll want to undo them until you get to the month with the error. The full guides can be found here:

 

It's very important to reach out to an accountant (well-versed with QuickBooks Desktop) before doing this. They'll ensure your reconciled statements are correct after making the changes. 

 

After correcting the reconciliation, you might be looking for help with other tasks. In this case, I'd recommend browsing our QuickBooks Desktop articles. They have detailed guides and information that can help you out. 

 

Feel free to drop by in the Community portal again whenever you need help. You can also go back to this thread or post a new question if you have follow-up concerns with reconciliation or QuickBooks Desktop.

View solution in original post

4 Comments 4
jamespaul
Moderator

Error in Reconciliation

Hello, Chloecs.

 

I appreciate your time posting here for confirmation on what to do with the corrected check. I have another solution we can do before we touch the "undo every reconciliation" part.

 

Checking the transaction as "reconciled" in the COA won't reflect the changes properly. This can throw off your next reconciliation period. 

 

To fix this, you'll want to do an "off-cycle" reconciliation to reflect the changes. Though, this works if you just changed the memo, payee and other details of the check. Before doing this, I'd recommend creating a backup copy of your company file

 

To do the off-cycle reconciliation process: 

 

  1. Click Banking, then choose Reconcile.
  2. In the Begin Reconciliation screen, select your bank account. 
  3. Choose an off cycle date for the Statement Date.
  4. Enter the Ending Balance of your last reconciliation. 
  5. Hit Continue
  6. Check the deleted transaction and ensure it has a zero difference.
  7. Click Reconcile Now.

 

Offcycle.PNG

 

More details can be found here: Reconcile previously deleted and re-entered checking or credit card transactions.

 

Also, if you edited the amount, then this will likely throw off the balances of the other reconciled statements. In this case, you'll want to undo them until you get to the month with the error. The full guides can be found here:

 

It's very important to reach out to an accountant (well-versed with QuickBooks Desktop) before doing this. They'll ensure your reconciled statements are correct after making the changes. 

 

After correcting the reconciliation, you might be looking for help with other tasks. In this case, I'd recommend browsing our QuickBooks Desktop articles. They have detailed guides and information that can help you out. 

 

Feel free to drop by in the Community portal again whenever you need help. You can also go back to this thread or post a new question if you have follow-up concerns with reconciliation or QuickBooks Desktop.

Chloecs
Level 2

Error in Reconciliation

I just followed your steps and it all worked, except for all of my previous months. The check was dated in January, however the account has been reconciled every month after that. If I date the off cycle reconciliation in between the current statement, all of my months since January are now messed up.  If I date it in between my January and February statement, my beginning balance is showing as the current beginning balance for July. That is why I assumed I needed to undo every reconciliation since it was months ago.

Chloecs
Level 2

Error in Reconciliation

This solution worked, except it didn't fix all of my previous months. The check was in January's reconciliation, so when I do the off cycle reconciliation between my current statements, it only fixes the issue moving forward. Every month since January is still off by that check amount. If I choose the date as between my January and February reconciliations, I am only given the option to start with the beginning balance that is my current balance (July). Is there any way to fix the error that will correct all of my previous months?

Candice C
QuickBooks Team

Error in Reconciliation

Good Afternoon, @Chloecs

 

Since you've already tried to do the steps that my colleague provided and you're still having trouble, then I suggest undoing every reconciliation since January. Let me walk you through the step-by-step process. 

 

  1. Go to the Banking menu. 
  2. Choose Reconcile
  3. Select the Account from the drop-down option.
  4. Enter the Statement Date
  5. Press the Undo Last Reconciliation button.

 

Once you're finished, reconcile each transaction. Here are a few articles that give can some guidance: 

 

 

I'm only a post away if you have any other concerns. Have a splendid day!

Need to get in touch?

Contact us