Learn how to create a report in QuickBooks Online of checks that haven't cleared yet.
If you have old, uncleared checks 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 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, QuickBooks Online Plus, and Advanced.
How to create a report for all uncleared checks.
- Go to Transactions, then 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 Customize.
- In the Report period dropdown menu, select All Dates.
- Select Filter.
- Select the Transaction Type checkbox. In the dropdown menu, select Bill Payment (Check), Liability Payment (Check), and Paycheck.
- Select the Cleared checkbox. In the dropdown menu, select Uncleared.
- Select Run report. Note: Select Save customization to use this report in the future.
Method 2: Run a bank report sorted by cleared status
- Go to Transactions, then 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 View Register ▼ and select Run report.
- In the Report period dropdown menu, select All Dates.
- In the Sort ▼ dropdown, select Clr and then Descending order. Checks that haven't cleared show up at the top of the report.