Run an uncleared cheque report in QuickBooks Online

You can run a report to find old or outstanding (uncleared) cheques.  This helps you manage your transaction register and prepare for account reconciliation. 

There’s 2 methods to run this report in QuickBooks. 

Some of your reports will look different depending on whether they're in the classic view or new enhanced experience. Learn more about the new enhanced experience.

Method 1: Run a bank report sorted by cleared status

1. Follow this link to complete the steps in product
2. Find the transaction account you want to run the report for. In the Action column, select Run report from the Account history ▼ dropdown.
3. Select Switch to classic view.
4. In the Report period ▼ dropdown, select All Dates.
5. In the Sort ▼ dropdown, select Clr from the Sort by ▼ dropdown, then select Descending order. Uncleared cheques appear in the report.

Method 2: Run a bank report using the cleared status filter

Note: This method is only available in QuickBooks Online Essentials, QuickBooks Online Plus, and QuickBooks Online Advanced.

1. Follow this link to complete the steps in product
2. Find the transaction account you want to run the report for. In the Action column, select Run report from the Account history ▼ dropdown.
3. Select Switch to classic view, then select Customise.
4. In the Report period ▼ dropdown, select All Dates.
5. Select Filter.
6. Tick the Transaction Type box. In the ▼ dropdown, tick Cheque Expense, Bill Payment (Cheque), Liability Payment (Cheque), and Payroll payment.
7. Tick the Cleared box. In the ▼ dropdown, tick Uncleared.
8. Select Run report, then select Save customisation for future use of this report.