Skip to main content
December 28, 2021
Question

Deposit

  • December 28, 2021
  • 1 reply
  • 0 views

Hello,

 

I have a deposit from April of this year that was not reconciled, I have confirmed from the creator, that the check was cashed. How can I do a mini reconciliation?   I have Enterprise.

 

Thanks

Kim

1 reply

December 28, 2021

Did the check just clear?  Or is there a duplicate entry?  Just want to clarify since I'm *assuming* :) you've reconciled correctly every month since April.  If it just cleared, wait until you reconcile for Dec. since it it just now clearing.

 

If the check was unreconciled by mistake, you can redo Nov. and it should correct everything.  Just start the normal Reconcile process and put in your Nov. closing date and balance.  Make sure you're hiding all future transactions and the balance shown should be the amount of the check.  So check it off and accept.   

 

Do not check off any of the Nov items that were still outstanding at the time you originally reconciled.  This one check should be the only outlier.  If it is not, then there is something else that is wrong with the account.  Confirm again there is not a duplicate entry for the check, did someone in a later month put in some Adjustment entry so they could reconcile, etc.  Something had to happen for the Acct to Reconcile with a $0 balance all these months.

 

So if it is not just a matter of checking off the one check that was unreconciled by mistake, I'd say you really need to UNreconcile every month back to April and start over.  Hopefully there are not hundreds of transactions for each month, but it seems like the cleanest way to figure out why you showed a good reconciliation every month when you really had an outstanding check.

December 28, 2021

Thank you for the advice however, I am not willing to undo the reconciliations back to April as I have done this before and there are several hundred transactions.

This is an Old Bank account that is no longer being used.  It is a Deposit that was not cleared in the amount of $1409.90.  I have checked with the person who wrote the check and it did clear there bank in May.

I am hoping to do a mini reconciliation to get it gone, if this is possible

 

Thanks  Kim

 

December 28, 2021

Thanks for getting back to us, Pro Grade Enterprises Inc.

 

Yes, you can do a mini-reconciliation to correct the balance. Here are the steps on how to do a mini-reconciliation:

 

  1. Go to the Banking menu at the top. 
  2. Select Reconcile.
  3. Pick the bank account with the transactions you need to reconcile.
  4. Enter the date for an "off-cycle reconciliation in the Statement Date section. This date can be any date between your last reconciliation and the next scheduled one.
  5. In the Ending Balance field, input the balance of your last successful reconciliation then hit Continue.
  6. Check the transactions you wanted to correct and re-reconciling then make sure the difference field shows $0.00.
  7. Once done, hit Reconcile Now.

 

For more insights and detailed steps, check out this article: Reconcile previously deleted and re-entered checking or credit card transactions.

 

For additional reference, I've added below articles for more options on how to fix the reconciliation issue in QuickBooks Desktop:

 

 

Feel free to reach out back if you need more help with reconciliation. I've got your back.