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 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 and QuickBooks Online Plus.
How to create a report for all uncleared cheques.
- Go to Bookkeeping 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 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 Bookkeeping 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.