Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
Talk to Sales: 877-683-3280
Hours
Mon - Fri, 5am - 6pm PST
Sat - Sun, 7am - 4pm PST
Product support & help
Need help signing in?
M
MelTilk
January 16, 2021
Solved

Uncleared check report not working

  • January 16, 2021
  • 1 reply
  • 5 views

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)?

Best answer by MelTilk

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.

 

1 reply

AlcaeusF
AlcaeusF
Level 14
January 16, 2021

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.

M
MelTilkAuthorAnswer
January 16, 2021

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 QuickBooks guidance?
Log in to access expert advice and community support instantly.
Terms & ConditionsAccessibility statement