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 #

Note: Only available in QuickBooks Online Essentials, QuickBooks Online Plus, and Advanced.

How to create a report for all uncleared checks.

  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 reportNote: Select Save Customizations to use this report in the future.

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.

Powered by BetterDocs

Leave a Reply

Your email address will not be published. Required fields are marked *

Skip to content