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

Run a report of uncleared cheques

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

If you have old, uncleared cheques 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

  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 Customise.
  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  Cheque, Bill Payment (Cheque), Liability Payment (Cheque), and Payroll payment.
  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 Account history 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. Cheques that haven't cleared show up at the top of the report.

How to create a report for all uncleared cheques

  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 Customise.
  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 Cheque, Cheque , Liability Payment (Cheque), and Payroll payment.
  8. Add a check to the box next to Cleared and choose Uncleared from the drop-down.
  9. Select Run Report.

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

Was this helpful?

You must sign in to vote, reply, or post