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.
Yogi
Level 4

Reports on Inactive Customers

I file various FCC reports that require knowing the date that a customer was marked as inactive. Is there a way to run a report that would list customers made inactive during a specific period and list the actual date of termination?

Solved
Best answer July 18, 2023

Best Answers
Mich_S
QuickBooks Team

Reports on Inactive Customers

Absolutely, Yogi. There's a way to run a report for inactive customers in QuickBooks Online, including their termination date. I'd be glad to share some tips and walk you through how.

 

Running and customizing the Customer Contact List Report lets you view your desired information. Make sure to filter the report properly to achieve this. Here's how:

 

  1. Open the Reports menu.
  2. Search for the Customer Contact List Report and click to open it.
  3. Choose the reporting 
  4. Select the Customize button.
  5. Go to the Rows/Columns section, click on Change columns, and make sure to check the boxes for Customers and Last Modified.
  6. Under Filter, tick the box for Deleted and select Deleted from the drop-down.
  7. Also, tick the box for Last Modified Date and select All Dates.
  8. Once done, click on Run report. Below are some snapshots for you to refer to:

 

 

That's it! You should now get this kind of setup for the report:

 

 

You'll also want to save it with its current customization settings; see this for the steps: Memorize reports in QuickBooks Online.

 

Finally, here's an extra guide to billing your active customers in the future: Create and send invoices in QuickBooks Online.

 

I'll be around to lend a hand always. Keep in touch if you need more help managing reports, customers, or QuickBooks. Take the best care!

View solution in original post

3 Comments 3
Mich_S
QuickBooks Team

Reports on Inactive Customers

Absolutely, Yogi. There's a way to run a report for inactive customers in QuickBooks Online, including their termination date. I'd be glad to share some tips and walk you through how.

 

Running and customizing the Customer Contact List Report lets you view your desired information. Make sure to filter the report properly to achieve this. Here's how:

 

  1. Open the Reports menu.
  2. Search for the Customer Contact List Report and click to open it.
  3. Choose the reporting 
  4. Select the Customize button.
  5. Go to the Rows/Columns section, click on Change columns, and make sure to check the boxes for Customers and Last Modified.
  6. Under Filter, tick the box for Deleted and select Deleted from the drop-down.
  7. Also, tick the box for Last Modified Date and select All Dates.
  8. Once done, click on Run report. Below are some snapshots for you to refer to:

 

 

That's it! You should now get this kind of setup for the report:

 

 

You'll also want to save it with its current customization settings; see this for the steps: Memorize reports in QuickBooks Online.

 

Finally, here's an extra guide to billing your active customers in the future: Create and send invoices in QuickBooks Online.

 

I'll be around to lend a hand always. Keep in touch if you need more help managing reports, customers, or QuickBooks. Take the best care!

Yogi
Level 4

Reports on Inactive Customers

Thank you so much for the guidance. This was an easy solution.

AbegailS_
QuickBooks Team

Reports on Inactive Customers

Hi there, Yogi.  

 

I'm glad that the steps provided by my colleague were able to resolve your concern 

 

Let me know in the comments below if you have further questions. Have a nice day. 

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

Need to get in touch?

Contact us