QuickBooks Tip – Create a report of customers with no sales & add it to icon bar

QuickBooks FAQ: Is there a way to customize a standard report within QuickBooks to show clients (or customers) that have not purchased products/services within a certain time frame?  Yes, you can create a custom summary QuickBooks report to show customers with no sales.  Plus you can memorize the report to use in the future and even create an icon for it on the icon bar. 

1.  In QuickBooks, go to Reports > Sales > Sales by Customer Summary

2.  Click on Modify Report and change the dates to the period desired

3.  Change Sort by to Total

4.  Click the Advanced button and select Display Rows — All (to include zeroes)

5.  On the Filters tab, select Account and filter for All Ordinary Income Accounts

QuickBooks customer summary

After you click OK, you will see a report similar to this (I collapsed the report to show only the customers and not the jobs):

QuickBooks sales by customer

You could export the report to Excel for further filtering or modification (if you wanted to delete those customers with sales during the year).

Next, you can add the report to the icon bar.  Click on View > Add “Sales by Customer Summary” to icon bar.  You can change the name under the icon if desired.

QuickBooks add to icon bar
Now, there is an icon for the QuickBooks report on the icon bar.

QuickBooks icon bar
After you get the information you want on the report don’t forget to memorize it too.

 

Disclaimer:  This report may or may not provide you with accurate information depending on how QuickBooks has been set up and whether transactions are being entered correctly using the usual forms and work flow (i.e. if sales are being entered as deposits instead of invoices or sales receipts or items are set up incorrectly, etc. then this report may not provide accurate information.)   As usual with QuickBooks, there is more than one method available — an alternative report would be to create a Custom Summary Report to show Total by Customer, display all rows to include zeroes and filter by account for all Ordinary Income accounts.  Thanks to Laura Dion of Cents-able Bookkeeping, LLC for her comments.

Print Friendly

About Michelle Long

Michelle L. Long, CPA is the owner of Long for Success, LLC specializing in QuickBooks consulting & training, coaching small business owners, speaking and writing. She was named one of '10 Women who Inspire a Profession' by Accounting Today and a Financial Services Champion of the Year by the SBA. She has been mentioned in the New York Times, Inc.com, Business Week, Investor's Business Daily, WebCPA and more. Michelle is the author of Successful QuickBooks Consulting and How to Start a Home Based Bookkeeping Business.

11 thoughts on “QuickBooks Tip – Create a report of customers with no sales & add it to icon bar”

  1. How do you do the same thing but with products (items) to show an inactive or slow moving item?

    Is there a way to show items that have not sold in the past week, month or year?

  2. I’m an extreme novice at this so please forgive me but how would one go about making a report to send out mailers to your clients?

    1. Do you want to print labels? Go to File > Print Forms > Labels
      If you want a report, you can go to Reports > Lists > customer contact list and modify it to include the address.

  3. I like this report to see how long it has been since a customer has bought something from the client. If sending mailers ro coupons, can save on the expense and sent to a new potential client.

  4. Great tip, it will help some of my customers that are trying to determine which clients to continue to send catalogs to for their mail order. They have wanted to know a way to filter out customers that they should consider dropping for lack of purchases.

  5. The reports on quickbooks do not look very professional but exporting a report to excel enables the ability to customize the report quickly if the most recent excel program is used.

  6. @Kathleen — I don’t have a quick answer for you. See if the Customer Balance Detail report will help (I know it isn’t exactly what you want) or creating a custom transaction detail report. You may need a 3rd party program like QQube (www.clearify.com) to create the report.

  7. Hi Michelle -

    Thanks for this post, great information.

    Is there any way to run a report that shows all Invoices and Payments, BUT show HOW the Payments were applied to the Invoices.

    The Transaction listings show all the information, but just list the Payments by the date; no application information. To do this manually is VERY time consuming…..

    Thank you,
    Kathleen

  8. Hub — I modified the post. The method I originally described was pulling line items which were zero. The report mentioned now should help you identify the members you want to see.

  9. Close to what I want.

    Have a club client that wants to know members that have spent (charged) nothing more than their montly dues to see their inactivity in using the facilities.

    What is your suggestion?

Leave a Reply