“How do I print a detailed report describing checks that are still outstanding. I’m using QB Pro 2007.”
As you have probably discovered there is no default report for outstanding checks in QuickBooks. However, you can create your own.
Let’s start with the basics, outstanding checks are simply checks written that have yet to clear the checking account.
Now that we have that out of the way…
Open the Reports menu and select Custom Transaction Detail Report. Click on the Modify Report button and select the following options:
Display Tab Settings
1. Dates – All
2. Report Basis – Cash
3. Columns – Leave the default setting (or you can customize to your preferences).
4. Total by – Leave the default setting.
5. Sort by – Clr
6. Sort in – Descending order (I’ll explain why).
Filters Tab Settings
1. Choose Filter – TransactionType and select Check from the drop-down menu.
2. Choose Filter – Detail Level and select Summary Only.
3. Choose Filter – Cleared and select No.
Header/Footer Tab Settings
1. Report Title – Outstanding Checks Report (or whatever you like). Click OK to save the settings.
Keeping It Relevant
Now that you have saved your report the next step is to memorize it for future use. Go to the Edit menu and select Memorize (Ctrl+M). Use the default name or whatever will remind you what this report of for.
To use this report you must use the reconciliation feature (Banking menu, then Reconcile) to clear checks as they post to the checking account. Simply do this by placing a check mark (clear) next to the transaction in the reconciliation window.
Then when you view this report, the cleared transactions will sort to the bottom of the list. Clearly showing you the outstanding checks first with the balance of all outstanding checks combined.
Want more Community Answers? Subscribe.
{ 2 comments… read them below or add one }
Thank you so much for the easy detailed instructions to create this o/s checks detail report!!!!
My pleasure. I enjoyed writing every moment of it.