Skip to main content
D
DebbiHenderson
February 22, 2024
Question

Uncleared Checks Report in Quickbooks Premier Plus Desktop

  • February 22, 2024
  • 2 replies
  • 0 views

I work for a large builder using QB Desktop Premier Plus. I'm asked for a report listing uncleared checks. You would think that QB would have that report but no! I've gone through all the suggestions and filters. I come up with a report with all of the checks even though I filter to NO on the cleared filter. It also lists all of the ACH trans. which I don't want. QBs is always updating to silly little changes. I see this report requested going back years! Please quickbooks this is a very basic report. We should be able to filter the date and have our report!!

2 replies

BigRedConsulting
BigRedConsulting
February 23, 2024

I tried creating a report of uncleared checks and it seems to work fine.

 

Note that for the reports uncleared = not reconciled.

 

What report are you running where you're seeing reconciled checks on the report?

 

N
NPC03
July 28, 2024

Can someone list out the exact report to use in Report Center on Quickbooks Desktop to pull a report of all uncleared checks? I need these 4 fields: Check #, check date, vendor name, check amount

S
SheandL
July 28, 2024

To view your uncleared checks in QuickBooks Desktop (QBDT), you can generate the Transaction Detail by Vendor report, @NPC03. I'm here to assist you in customizing it.

 

This report provides a detailed summary of all transactions linked to each vendor, allowing you to analyze their activities and confirm the transactions related to your suppliers. Here’s how to customize the report to display the information you need:

 

1. Head to the Reports menu, then Custom Reports

2. Choose the Transaction Detail.

3. On the report page, go to the Customize Report button, then edit the From and To date fields.

4. Under the Display tab, go to the Column section, then tick the following: Type, Date, Num, Account, Amount. Please know that the Num will show your check number.

5. On the Filters section, search for the following:

  • Cleared, then select No.
  • Date, choose All from the dropdown.
  • Name, then All vendors
  • TransactionType, then Check

6. Once done, click OK.

 

Once done, you can now view all your uncleared checks in QBDT.

 

For additional guidance on managing and personalizing reports in QBDT, please refer to this article: Understand reports.

 

If you have any further questions regarding reports in QBDT, feel free to return to this post for assistance. I am here to help you as soon as possible.

BigRedConsulting
BigRedConsulting
July 30, 2024

Here are steps:

1. Start on the Reports menu and pick Custom Reports | Transaction Detail

2. When the Modify Report window appears, click on the Filters tab.

3. Remove the Date filter, for all dates.

4. Add the following Filters:

- TransactionType = Multiple Transaction Types, then: Check, Bill Payment, Sales Tax Payment, Paycheck, Payroll Liability Check

- Detail Level = Summary Only

- Cleared = No

- Account = The bank account you want to report on (if you have multiple bank accounts and only want to see one).

 

Click OK to run the report.

Terms & ConditionsAccessibility statement