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.