Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.
mberenson
Level 1

Old check cleared the bank, still a reconciling item.

I have an old (2016) check that was manually matched on the bank feed but I have to uncheck each time I reconcile the bank statement. The client confirmed with the bank that the check actually cleared (same month it was written). I just looked back at the reconciliation history by account and see that this check was reconciled in the correct month and it shows up on the report, however is the only item on that report that doesn't hyperlink to a transaction.

 

Any ideas how I can get the check in my reconciliation to clear?

3 Comments 3
ShiellaGraceA
QuickBooks Team

Old check cleared the bank, still a reconciling item.

Thanks for reaching out to us today, @mberenson.

 

I have some information about the unlink check in your reconciliation report. It's possible that the check was manually reconciled. I have two ways to handle this and I'm more than happy to share the steps with you. 

 

First, you can change the reconcile status to blank to return the check back to the register. This way, you can reconcile again and link it. However, changing a reconciled transaction may cause an incorrect beginning balance of your account. If you need to completely start over, I suggest reaching out to your accountant to undo the entire reconciliation.

 

To change:

  1. Go to Accounting, then select Chart of Accounts.
  2. Look for the account, then tap the View register link.
  3. Locate the check then change the reconcile status from "R" to "Blank".

Lastly, you can exclude the check so it won't show up in your bank feed. Here's how to do it:

  1. Go to the Banking menu, then select Banking.
  2. Highlight the bank account in question.
  3. Tick the box next to the old check.
  4. Click Exclude.

By doing so, this check won't appear in any account registers or financial reports.

 

Want to learn more about reconciliations? Check out these articles below.

 

Feel welcome to message me if you still have questions or concerns. I'm more than happy to assist you. Take care and have good one.

mberenson
Level 1

Old check cleared the bank, still a reconciling item.

Those solutions didn't work:

 

1. Changing the reconcile status from "C" to "blank" makes it show up on my outstanding check report and puts off my reconciliation beginning balance. The check cleared the bank but was deleted in QBO subsequent to that period's initial reconciliation. I don't know what happened in the meantime, but all reconciliations are clean since I took over this client a year ago.

 

2. The transaction doesn't show up in the banking menu for me to exclude. I tried this first, as the item in my reconciliation module shows it was added through the bank feed.

MaryLurleenM
Moderator

Old check cleared the bank, still a reconciling item.

Thank you for the additional details, mberenson.

 

If the check was deleted after the reconciliation, it can cause a problem. To fix it, you can add the transaction again with the original date. Please note that it can affect the balances on your account. I recommend checking it with your accountant if there's a need to undo the reconciliation. 

 

You'll want to check the articles given by my colleague above as a read-through on how to fix reconciliation errors.

 

Stay in touch with me if you have more questions.

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us