LIMITED TIME 90% 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.
kath8
Level 1

How do I get a total of all the cleared checks written in one month?

I’m Using QuickBooks online
3 Comments 3
MJoy_D
Moderator

How do I get a total of all the cleared checks written in one month?

I can help you with checking your total cleared checks for the specific month, @kath8.

 

You can generate a report to get the total cleared checks for a month in QuickBooks Online. Then, export the report to an excel file to calculate the total amount.

 

Go to your Reports menu to find the Check Detail report. Then, customize the date range for the specific month that you're referring to and the filter to Cleared checks. 

 

Here's how:

 

  1. Go to the Reports menu and then click to run the Check Detail report.
  2. Set the date range.
  3. Click the Customize button.
  4. Go to the Filter dropdown, click the Cleared checkbox and select Cleared.
  5. Once you're done customizing the report, click on the Run report button. 
  6. Click on the Export button and choose Export to Excel
  7. On the file, highlight all the amounts and click on AutoSum.

 

Refer to the following article for more information on how to run, customize, export the report in Excel in QuickBooks Online (QBO): Customize reports in QuickBooks Online.

 

After generating the report, you can save it with its current customization settings. See this article for detailed guidance: Memorize reports in QuickBooks Online.

 

That should let you get the get the total of all the cleared checks for a specific month. Just let me know in the Reply section below if you still have questions about your cleared checks. Keep safe and have a wonderful day!

ddemo
Level 1

How do I get a total of all the cleared checks written in one month?

This gives you a report of all checks that have cleared that were WRITTEN in a given month.  I need a report of ALL checks written that have CLEARED in a given month.

Nicole_N
QuickBooks Team

How do I get a total of all the cleared checks written in one month?

Hi, @ddemo. Thanks for joining the conversation. I'd be glad to help you generate the report you need in QuickBooks Online (QBO).

 

Are you trying to run a report that shows all checks created but different cleared months? If so, then let me guide you on how to customize the report to see the specific detail that matters most to you.

 

Here's how:

  1. Go to the Reports menu.
  2. From the search bar type in Check Detail to view the report.
  3. Click the Customize button.
  4. Select All Dates for the Report period.
  5. Go to the Filter dropdown, then click the Cleared checkbox then select Cleared.
  6. From the Transaction type, select Check.
  7. Once done, click Run report.

 


After customizing the report, you will see all checks created that have cleared in a given month. See the screenshot below for visual reference.

 

You can also visit this article to learn how to personalize and add specific info to your sales forms: Customize invoices, estimates, and sales receipts in QuickBooks Online.

 

Feel free to leave a reply if you have additional questions about running reports in QuickBooks Online. I'll be here to help. Take care and have a good one!

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

Need to get in touch?

Contact us