Uncleared Checks Report in Quickbooks Premier Plus Desktop

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?

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

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.

Hi @SheandL - thank you for the detailed steps, but I am still not getting the report pulled correctly. I followed your instructions and set the Dates to ALL, but the report only shows some petty cash checks from 2015-2016 on our account. There should be multiple uncleared checks from 2024 included on this report. 
Do you have any idea what setting would be off if my report is only pulling uncleared 2016 checks?

I appreciate you for following the steps provided by my colleague, NPC03. Let me help you customize the best report for pulling up uncleared checks from your QuickBooks Desktop (QBDT) account.

First, you'll need to create custom reports and edit them to display your preferred transaction data.

Here's how:

1. Go to Reports. Then, click Custom Reports.
2. Select Transaction Detail.
3. Under the Display section, change the date range to All.
4. Go to the Filters tab.
5. Click Transaction type. Then, select Multiple Transaction Types.
6. Select Check, Bill payment, Sales tax Payment, Paycheck, and Payroll Liability Check. Then click OK.
7. Enter Detail Level, then select Summary Only.
8. Enter Cleared, then click No
9. Type Accounts, then choose the bank account you want to report on.
10. Click OK to run the report.

Note that once the report is pulled up for uncleared checks, it will not show a checkmark under the Clr column.

I've also added a screenshot for your visual reference.

If the transactions are not showing up on the report you've pulled up, it's possible that the checks have been reconciled. You can also check the reconciled account to ensure the transactions are there.

In addition, you can refer to this article to learn how to export reports to Excel from QBDT: Export reports as Excel workbooks in QuickBooks Desktop.

Leave a comment if you still have concerns about running a report in QBDT. I'm always here to help.

@RhoiceW 

Re:

• Go to Reports. Then, click Vendors & Payables.
• Select Transaction List by Vendor.

Your steps will result in a report report will show all transactions for a period that have payees who are vendors. 

That is not what the OP asked for.

The request is for a report that lists all uncleared checks, and only uncleared checks. It's not difficult to understand, is it?

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.