cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Level 1

Combined total dollar amount for all checks, cleared and uncleared.

How can I see a grand total for cleared and uncleared checks written on my monthly banking report? I currently see a grand total for each seperatly but not combined total.
3 Comments
Highlighted
QuickBooks Team

Combined total dollar amount for all checks, cleared and uncleared.

I'll share a report that you can use, MAFCLI.

 

You can run the Transaction Detail and customize the report to show the total for all cleared and un-cleared checks.

 

Here's how:

 

  1. Go to Reports > Custom Reports > Transaction Detail.
  2. In the Modify Report: Custom Transaction Detail window, click the Filters tab.
  3. Search Transaction Type in the field and select Check from the drop-down list.
  4. Go back to the search field and type Cleared. Choose Either from the drop-down menu.
  5. Hit OK.

Once done, you will see the combined total of all checks. Here's a sample screenshot of what it looks like:

 

 

You can also read this article for more details: Customize reports in QuickBooks Desktop.

 

If there's anything else you need help with QuickBooks Desktop reports, please let me know in the comments below. I'll be around to help you out again. Thanks.

Highlighted
Level 1

Combined total dollar amount for all checks, cleared and uncleared.

When doing this, it did give me a grand total but not on my report. I failed to mention the report is am using is called a previous reconciliation.

I did find when I check off debit and credit it does show a combined total for all checks written as well as all deposits.

 

My next problem I have now, on the previous reconciliation report, I want to change the name of the column to read "deposits" rather than "debits" as well as "checks" rather than "debits".  Is that possible?

 

Also, can I save that layout as a template that I can use each month rather than recreate those customizations each time?

 

Thanks,

Gary

Highlighted
QuickBooks Team

Combined total dollar amount for all checks, cleared and uncleared.

Hello there, @MAFCLI.

 

Let me provide you additional information with the Reconcilation Summary report. Yes, I would agree that debit and credit shows a combined total for all checks written as well as all deposits in the report. However you can make your report more specific by customizing the report.

 

Also, changing the deposits rather than debits and checks rather than debits is not possible. 

 

Lastly, yes you can save the template by clicking the Memorize report tab. This will allow you to use the same settings of the customized report to be available for future use. 

 

Here are articles that can help you in customizing your report:

Feel free to leave your additional questions on the comment section. I'll be delighted to help you further. Have a great day.

Need to get in touch?

Contact us