QuickBooks HelpQuickBooksHelpIntuit

Run a report of uncleared checks

SOLVEDby QuickBooksQuickBooks Online303Updated December 22, 2022

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 a ProAdvisor 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 Bookkeeping and select Chart of accounts (Take me there).
  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 dropdown menu, select All Dates.
  5. Select Filter.
  6. Select the Transaction Type checkbox. In the dropdown menu, select  Bill Payment (Check), Liability Payment (Check), and Paycheck.
  7. Select the Cleared checkbox. In the dropdown menu, select Uncleared.
  8. Select Run report. Note: Select Save customization to use this report in the future.

Method 2: Run a bank report sorted by cleared status

  1. Go to Bookkeeping and select Chart of accounts (Take me there).
  2. Find the bank account you want to run the report for. In the Action column, select the dropdown menu next to View Register ▼ and select Run report.
  3. In the Report period dropdown menu, select All Dates.
  4. In the Sort ▼ dropdown, select Clr and then Descending order. Checks that haven't cleared show up at the top of the report.

Was this helpful?

You must sign in to vote, reply, or post
QuickBooks AppsQuickBooks Online AdvancedQuickBooks Online EssentialsQuickBooks Online PlusQuickBooks Online Simple Start

Sign in for the best experience

Ask questions, get answers, and join our large community of QuickBooks users.

More like this