cancel
Showing results for 
Search instead for 
Did you mean: 
Chrisrod182120
Level 1

There are uncleared checks in Reconciliation but i checked the bank and they are cleared. How should i remove the uncleared?

 
9 Comments 9
jitu1049
Level 3

There are uncleared checks in Reconciliation but i checked the bank and they are cleared. How should i remove the uncleared?

You thinks those are duplicate entries in QB, Than after verifying, you can delete that check. Deleting previous year checks will alter this years start balances. IF those were not duplicate checks , than how were you able to reconcile QB. Did you end up clicking "reconcile anyway" and QB entered the adjustment in to journal.

 

 

Chrisrod182120
Level 1

There are uncleared checks in Reconciliation but i checked the bank and they are cleared. How should i remove the uncleared?

The checks aren't duplicated but there was a period where I needed to create the journal entry to reconciliation discrepancy.  

Chrisrod182120
Level 1

There are uncleared checks in Reconciliation but i checked the bank and they are cleared. How should i remove the uncleared?

correct I must have selected the option in error because we needed to close the period quickly.  I just want to clean it up before the end of this FYE. 03/31/2020

Rea_M
Moderator

There are uncleared checks in Reconciliation but i checked the bank and they are cleared. How should i remove the uncleared?

Thank you for sharing what you did to reconcile your account, Chrisrod182120.

 

There are uncleared checks because you've created a journal entry to force reconcile your account. Please know that it's not advisable to create an adjustment to reconcile an account since it'll cause discrepancies in your future reconciliations.

 

To fix this, you can undo the last reconciliation and exclude the check. Then, delete the adjustment and reconcile the account again. You'll have to include the check transaction in the next reconciliation.

 

To undo a previous reconciliation, here's how:

  1. Back up your QuickBooks company file.
  2. Select Undo Last Reconciliation in the Begin Reconciliation window.
  3. Click  Continue then OK.
  4. Close window.

Once done, reopen the Begin Reconciliation window to reconcile your account again

 

In addition, you can also choose to create an adjustment for current reconciliation. Please know that this is only applicable once you've verified that all your transactions are already accurate in QuickBooks. It'll be entered in the special expense account called Reconciliation Discrepancies.

 

You can go to the Chart of Accounts to check if  the adjustment you've created is accurate.

 

  1. Go to the Lists menu.
  2. Select Chart of Accounts.
  3. Open the Reconciliation Discrepancies account.
  4. From the Dates field, set dates for your last few reconciliations.
  5. If you see any adjustments that are making the account balance inaccurate, make sure your corrections aren't conflicting with the adjustment.

To learn more what to do if your accounts in QuickBooks Desktop don't match your bank statements, you can refer to this article for the detailed steps: Fix issues when you're reconciling in QuickBooks Desktop. It also provides information about the causes of reconciliation issues.

 

Please let me know if you have other concerns. I'm just around to help.

Chrisrod182120
Level 1

There are uncleared checks in Reconciliation but i checked the bank and they are cleared. How should i remove the uncleared?

I found the invoices relating to the priors months rec discrepancy.  Do I just reverse the journal entry and create a small reconciliation for Feb 2020 because at this point I have already reconciled.   Also there are other checks in there that are very old,  what can I do about those?

Anna S
QuickBooks Team

There are uncleared checks in Reconciliation but i checked the bank and they are cleared. How should i remove the uncleared?

Good afternoon, @Chrisrod182120.

 

You are correct. You'll need to reverse the journal entry now that you've found the accurate Invoices. You've also got the right idea about creating a small reconcile for February 2020 so that all of your transactions are reconciled correctly. As for your older check, I suggest asking your accountant about what you can do with those. They're more knowledgeable when it comes to your books and can tell you how they'll affect the rest of your accounting.

 

Feel free to hit the Reply button if you have any other questions. Enjoy your weekend!

jitu1049
Level 3

There are uncleared checks in Reconciliation but i checked the bank and they are cleared. How should i remove the uncleared?

If you are sure that , checks were issued and mailed, but never cashed. Than, its an income now. So make a deposit as other income, date it current (equal to total of the checks) and reconcile again using the last statement bank end balance, Here select the checks to be cleared and click the deposit.  Do not use anything other than OTHER INCOME. Using other than "Other Income" will alter the balances for previous year.

Chrisrod182120
Level 1

There are uncleared checks in Reconciliation but i checked the bank and they are cleared. How should i remove the uncleared?

See the checks were cut, issued and mailed.  And its showing up as cashed. Do I still create the deposit to other income?

Kendra H
QuickBooks Team

There are uncleared checks in Reconciliation but i checked the bank and they are cleared. How should i remove the uncleared?

Good morning, @Chrisrod182120.

 

Thank you for following up on this thread.

 

Each business has a unique setup, so I suggest reaching out to your accountant.

 

Also, if you have any other questions, you can reach out to our QuickBooks Customer Support Team as well.

 

Here's how to get in touch:

  1. Click on the Help option on the top menu.
  2. Hit Contact Us.
  3. Enter your concern in the search field.
  4. Select Let's talk.
  5. Choose Get a callback to connect with us.

If you have any more QuickBooks questions, please don't hesitate to comment below. Happy Monday!

Need to get in touch?

Contact us