Generate a Missing Cheques report in QuickBooks Online

QuickBooks Online does not have a specific Missing Cheques report that identifies all cheques sorted by number or one that lets you scan for missing or duplicate cheque numbers.

However, you can easily customise the Account QuickReport for your bank account to help you find information about missing cheques.

To create a missing cheques report:

1. Go to Settings and select Chart of accounts (Take me there).
2. Locate the appropriate account in the list.
3. Select the Account history dropdown list in the Action column.
4. Select Run report. The Account QuickReport appears.
5. Select Customise.
6. From the Report period dropdown list, select All Dates.
7. Select the Rows/Columns item to open the section.
8. Select None from the Group by dropdown list.
9. Select the Filter item to open the section.
10. Select All from the Distribution Account dropdown list, and select the required bank account from the Account dropdown list.
11. From the Transaction Type dropdown list, select Cheque Expense, Bill Payment (Cheque), Liability Payment (Cheque), and Prior Liability Payments.
12. Select Run report.

The Account QuickReport is re-run to display the cheque-related items you specified. You can use this report to identify and track missing cheques.

You can optionally select Save customisation to save the custom report for future use. Once you save the report, you can re-open it from the Custom Reports tab of the Reports page.