QuickBooksHelpIntuitRun an uncleared cheque report in QuickBooks Online
by Intuit•2• Updated about 14 hours ago
Identify outstanding or old cheques by running an uncleared cheque report in your account. This helps you manage your transaction register and prepare for account reconciliation.
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. |
What you’ll need
- An active QuickBooks Online subscription
- To filter your report for only uncleared cheques, an active QuickBooks Online Essentials, Plus, or Advanced subscription
Run a bank report sorted by cleared status
Use this method to see all transactions in a transaction register sorted by their cleared status.
- Go to All apps
, select Accounting, then select Chart of accounts (Take me there). - From the Action column, select the Account historyâ–Ľ dropdown and select Run report.
- Select All Dates from the Report period â–Ľ dropdown.
- Find the Cleared column and select the Sort default view icon
until it displays in descending order 
.
Run a bank report using the cleared status filter
Use this method in QuickBooks Online Essentials, QuickBooks Online Plus, and QuickBooks Online Advanced to filter for certain cheque types that haven't cleared.
- Go to All apps , select Accounting, then select Chart of accounts (Take me there).
- Locate the bank current account you want to run the report for.
- Go to the Action column, select the Account history â–Ľ dropdown, and select Run report.
- Select All Dates from the Report period â–Ľ dropdown.
- Select Customise.
- In Filters, select Transaction type from the Filter by â–Ľ dropdown, select equals from the Condition â–Ľ dropdown, then select Bill Payment (Cheque), Liability Payment (Cheque), and Payroll payment from the Value â–Ľ dropdown.
- Select + Add another filter.
- Select Cleared from the Filter by â–Ľ dropdown, select equals from the Condition â–Ľ dropdown, then select Uncleared from the Value â–Ľ dropdown.
- Select Save As, then follow the prompts to use this report again in the future.
Results
Your report now displays a list of all outstanding cheques. You can print or export this list as needed for your records.