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 cheque, 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 and QuickBooks Online Plus.
How to create a report for all uncleared cheques.
- Go to Transactions and select Chart of accounts (Take me there).
- Find the bank account you want to run the report for. In the Action column, select Run report in the dropdown menu.
- Select Customise.
- In the Report period dropdown menu, select All Dates.
- Select Filter.
- Select the Transaction Type checkbox. In the dropdown menu, select Cheque Expense, Bill Payment (Cheque), Liability Payment (Cheque), and Payroll payment.
- Select the Cleared checkbox. In the dropdown menu, select Uncleared.
- Select Run report. Note: Select Save customisation to use this report in the future.
Method 2: Run a bank report sorted by cleared status
- Go to Transactions and select Chart of accounts (Take me there).
- Find the bank account you want to run the report for. In the Action column, select the dropdown menu next to Account history▼ and select Run report.
- In the Report period dropdown menu, select All Dates.
- In the Sort ▼ dropdown, select Clr and then Descending order. Cheques that haven't cleared show up at the top of the report.