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 cheque 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. Go to All apps , select Accounting, then select Chart of accounts (Take me there).
2. Find the chequing 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. Go to All apps , select Accounting, then select Chart of accounts (Take me there).
2. Find the chequing 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 Customize.
4. In the Report period ▼ dropdown, select All Dates.
5. Select Filter.
6. Select the Transaction Type checkbox. In the ▼ dropdown, select Cheque Expense, Bill Payment (Cheque), Liability Payment (Cheque), and Paycheque.
7. Select the Cleared checkbox. In the ▼ dropdown, select Uncleared.
8. Select Run report, then select Save customization for future use of this report.