Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.
Tiv
Level 3

Print a report showing all open transactions in the checkbook in Quickbooks Premier Plus edition 2021

I have Quickbooks Premier Plus Edition 2021. I'd like to print a report showing all uncleared transactions (checks, deposits, general ledger entries, everything) in the checkbook, but I can't find a report that will give me that information even if I customize it. I found some shared reports that will not open because they're not set up for Premier Plus. I went to Reports - Banking - Missing Checks, but it wouldn't show the deposits or GL entries, only the checks even after I customized it to show every type of open transaction.

 

Essentially, I just need a list that shows me all uncleared items in the checkbook. Where can I go to find this report?

3 Comments 3
ReyJohn_D
Moderator

Print a report showing all open transactions in the checkbook in Quickbooks Premier Plus edition 2021

I have an idea on how to get the report you need, @Tiv.

 

You can run the Check Detail report to view all the uncleared transactions in your checkbook. Then, customize it further to show info like the check, deposits, journal entries, etc. 

 

Here's how to do it:

 

  1. Go to the Reports menu at the top.
  2. Select the Check Detail report from the Banking section.
  3. Click the Customize button, and then choose the Filters tab.
  4. Select Transaction Type as the filter, and then Multiple Transaction Types from the drop-down.
  5. Choose check, deposits, journal, and other info you want to include, and then click OK.
  6. Search for the Cleared filter, and then select No beside it.
  7. Click OK again when you're ready.

Then, you're good to go to print the said report. To do that:

 

  1. Go to the Print drop-down, and then choose Report.
  2. Select the print setting you want.
  3. Click Print, and then follow the on-screen prompts to continue.

The good thing is, you can save the said report customization. This way, you can access it easily for later use. For more details, please head to this link: Memorize reports in QuickBooks Desktop.

 

I'm still up and running for more reports concern you may have. I'm always here to lend a helping hand.

Tiv
Level 3

Print a report showing all open transactions in the checkbook in Quickbooks Premier Plus edition 2021

Thanks, but that didn't quite work. It shows me four entries starting back in 2017. I marked "no" on the cleared option, chose checks and deposits as the types of transactions to see, chose "any" for the amount, but the entire list of uncleared items wouldn't show up.

 

I did find this through Google:

 

  • Select Reports - Company & Financial - Balance Sheet Standard, and then double-click on the dollar amount for the desired account. This brings up a Transactions by Account report.

  • Click on the Customize Report button.

  • On the Filters tab, in the Choose Filter box, scroll down, and select Cleared - No.

 

This actually gave me a list of uncleared checks and deposits, but the fact you have to go through the Balance Sheet Standard is a bit odd. I would never have thought to look there.

 

Jessica_young
Moderator

Print a report showing all open transactions in the checkbook in Quickbooks Premier Plus edition 2021

Thanks so much for this update, @Tiv.

I'm so happy to hear you found a solution that works for you and taking the time to reach back out to the Community to share this solution.

 

Please let me know if I can help with anything else. Have a lovely holiday! 

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us