Created with Sketch.Learn about PPP and Loan Forgiveness, stay informed with the latest changes.
Created with Sketch.Questions about how to close your books for 2020? Visit our Year End Resources page.
Created with Sketch.New to QuickBooks or using a new product? Visit our Get Started resource page to help you get going.
Created with Sketch.Need to make changes to your account? Visit the Account Manager Portal.
cancel
Showing results for 
Search instead for 
Did you mean: 
Level 3

Is there a way to create a report showing all customers that have had NO sales activity within the past 5 years?

I'd like to thin our HUGE customer list by removing old customers with no recent sales history.  Is there a way to run a report showing me which customers I can delete?  

 

After that, it would be GREAT if there was a way to quickly make these customers inactive, but I already know the only way is to go into each one individually and edit the customer details.

 

Thanks for any suggestions!

Solved
Best answer October 09, 2020

Best Answers
Moderator

Is there a way to create a report showing all customers that have had NO sales activity within the past 5 years?

Hello @kaycee1,

 

Welcome to the Community. I can help you run the report to filter customers with no recent sales history.

 

I suggest you use Sales by Customer Summary to acquire the data you need. You can customize the report to show customers with zero and non-zero amounts.

 

I know you only need the data for old customers with no recent sales history. However, the option to only show zero figures is unavailable.

 

As a workaround, I recommend exporting the report to Excel and manually remove the unnecessary data. Here's how:

 

  1. On the left panel, click Reports.
  2. Scroll down and select Sales by Customer Summary.
  3. Choose a date range.
  4. Under Display columns by, select Months.
  5. Below Show non-zero or active only, choose All for the rows and columns.
  6. Filter the necessary options.
  7. Press the Export icon.
  8. Select Export to Excel

You're correct about making customers inactive. As of now, the only way to do it is by going to each one of them in the system.

 

I've also attached an article you can use to get the most out of your financial reports in QuickBooks: Customize reports in QuickBooks Online.

 

Please let me know if you need anything else. The Community and I will be here to help you.

View solution in original post

2 Comments
Moderator

Is there a way to create a report showing all customers that have had NO sales activity within the past 5 years?

Hello @kaycee1,

 

Welcome to the Community. I can help you run the report to filter customers with no recent sales history.

 

I suggest you use Sales by Customer Summary to acquire the data you need. You can customize the report to show customers with zero and non-zero amounts.

 

I know you only need the data for old customers with no recent sales history. However, the option to only show zero figures is unavailable.

 

As a workaround, I recommend exporting the report to Excel and manually remove the unnecessary data. Here's how:

 

  1. On the left panel, click Reports.
  2. Scroll down and select Sales by Customer Summary.
  3. Choose a date range.
  4. Under Display columns by, select Months.
  5. Below Show non-zero or active only, choose All for the rows and columns.
  6. Filter the necessary options.
  7. Press the Export icon.
  8. Select Export to Excel

You're correct about making customers inactive. As of now, the only way to do it is by going to each one of them in the system.

 

I've also attached an article you can use to get the most out of your financial reports in QuickBooks: Customize reports in QuickBooks Online.

 

Please let me know if you need anything else. The Community and I will be here to help you.

View solution in original post

Level 3

Is there a way to create a report showing all customers that have had NO sales activity within the past 5 years?

That worked great!

 

Instead of monthly, I just had it show total only, then after exporting it to Excel I sorted it by total and eliminated everything that wasn't zero.  Then I printed it, which still ended up being 36 pages...now the fun begins!

 

Thank you!

Need to get in touch?

Contact us