cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Intuit
44 helpful votes

Run a report of uncleared checks

Learn how to create a report in QuickBooks Online of checks that haven't cleared yet.

If you have old, uncleared checks cluttering up your books, you can run a report to help you handle them.

If you're not sure how to deal with an uncleared check, talk to your accountant. We can help you find an accountant  if you need one.

There are two ways to run this report in QuickBooks.

Method 1: Run a bank report filtered by cleared status

QuickBooks Online Essentials, QuickBooks Online Plus, and Advanced only. QuickBooks Online Plus.

  1. Go to the Accounting menu and select Chart of Accounts.
  2. Find the bank account you want to run the report for. In the Action column, select Run report in the dropdown menu.
  3. Select Customize.
  4. In the Report period drop-down menu, select All Dates.
  5. Select Filter.
  6. Select the Transaction Type checkbox. In the drop-down menu, select  Bill Payment (Check), Liability Payment (Check), and Paycheck.
  7. Select the Cleared checkbox. In the drop-down menu, select Uncleared.
  8. Select Run report.

Method 2: Run a bank report sorted by cleared status

  1. Go to the Accounting menu and select Chart of Accounts.
  2. Find the bank account you want to run the report for. In the Action column, select the drop-down menu next to View Register ▼ and select Run report.
  3. In the Report period drop-down menu, select All Dates.
  4. In the Sort ▼ drop-down, select Clr and then Descending order. Checks that haven't cleared show up at the top of the report.

How to create a report for all uncleared checks

  1. From the left menu, select Accounting and choose Chart of Accounts.
  2. Find the bank account you need to run the report for.
  3. From the Action column drop-down menu, select Run Report.
  4. Select Customize.
  5. Set the Report period to All Dates.
  6. From the Filter drop-down, add a check to the box next to Transaction Type.
  7. Select the drop-down menu beside Transaction Type and mark the boxes for the following: Bill Payment Check, Check , Liability Payment (Check), and Paycheck.
  8. Add a check to the box next to Cleared and choose Uncleared from the drop-down.
  9. Select Run Report.

Note: Select Save Customizations to use this report in the future.

Was this helpful?

You must sign in to vote, reply, or post

Need to get in touch?

Contact us