cancel
Showing results for 
Search instead for 
Did you mean: 
MelTilk
Level 3

Uncleared check report not working

When I run an uncleared check report (Bank Account Quick Report with Filters: Transaction Type= Check, Cleared = No), I do not actually get a report with uncleared checks - none of them show up.  I am dumfounded, but it is probably something simple that I am missing...

There are about a dozen outstanding checks - I see them in the register and the status column is blank (no checkmark, no *, no lightening bolt) - that is they have not been downloaded through bank feeds nor have they been reconciled (obviously).  The funny thing is that one check -  just one - shows up on the report. I can't figure out how it is different from all of the others.   So my question is: why are the uncleared checks are not coming up on the Uncleared Check Report (i.e., what am I missing)?

Solved
Best answer January 16, 2021

Best Answers
MelTilk
Level 3

Uncleared check report not working

Hi Alcaes M,

My filters match yours, and that is not the solution. Neither is verifying/rebuilding.  I actually figured it out with more thought. It was actually because the filters need to be as follows:

Type = Multiple Types and select, Check and Bill Payment

This is simply because QB does not recognize checks issued as "Bill Payments" as the type ="Check" even though we are cutting a check to pay that bill.  Now the report works.  I hope this solution will help others since rebuilding data is not always the answer.

 

View solution in original post

2 Comments 2
AlcaeusF
Moderator

Uncleared check report not working

Hi @MelTilk,

 

Welcome to the Community. I'm here to help you fix the unusual behavior when running the report.

 

You should be able to view the data you need using the filters you've mentioned above. Let's review the Modify Report window and ensure there are three filters only (see screenshot below).

 

 

If the result is still the same, I recommend you proceed with running the Verify and Rebuild Data utility. This feature usually resolves commonly known data issues and resolve them.

 

To verify data:

 

  1. Click the File tab at the top menu bar.
  2. Hover your cursor to Utilities.
  3. Select Verify Data.

To rebuild data:

 

  1. Click the File tab at the top menu bar.
  2. Hover your cursor to Utilities.
  3. Select Rebuild Data.

You can also check the articles for more details about how to use the QuickBooks Tool Hub tool to resolve program issues: Fix common problems and errors with the QuickBooks Desktop Tool Hub.

 

Drop me a comment below if you have any other questions regarding the report. I'll be happy to help you some more.

MelTilk
Level 3

Uncleared check report not working

Hi Alcaes M,

My filters match yours, and that is not the solution. Neither is verifying/rebuilding.  I actually figured it out with more thought. It was actually because the filters need to be as follows:

Type = Multiple Types and select, Check and Bill Payment

This is simply because QB does not recognize checks issued as "Bill Payments" as the type ="Check" even though we are cutting a check to pay that bill.  Now the report works.  I hope this solution will help others since rebuilding data is not always the answer.

 

Need to get in touch?

Contact us