QuickBooks HelpQuickBooksHelpIntuit

Run an uncleared cheque report in QuickBooks Online

by Intuit•37• Updated 1 month ago

Identify outstanding or old cheques by running an uncleared cheque report in your account. This helps you manage your cheque register and prepare for account reconciliation.



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 cheque register sorted by their cleared status.

  1. Go to All apps A bunch of numbers and letters on a tile wall., select Accounting, then select Chart of accounts (Take me there).
  2. From the Action column, select the Account historyâ–Ľ dropdown and select Run report.
  3. Select All Dates from the Report period â–Ľ dropdown.
  4. Find the Cleared column and select the Sort default view iconA street sign with a number of signs on it. until it displays in descending order Simple arrow icon pointing downward..


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.

  1. Go to All apps A bunch of numbers and letters on a tile wall., select Accounting, then select Chart of accounts (Take me there).
  2. Locate the bank chequing account you want to run the report for.
  3. Go to the Action column, select the Account history â–Ľ dropdown, and select Run report.
  4. Select All Dates from the Report period â–Ľ dropdown.
  5. Select Customize.
  6. 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 Paycheque from the Value â–Ľ dropdown.
  7. Select + Add another filter.
  8. Select Cleared from the Filter by â–Ľ dropdown, select equals from the Condition â–Ľ dropdown, then select Uncleared from the Value â–Ľ dropdown.
  9. 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.



Related links