How can we improve WHMCS?

Share, discuss and vote for what you would like to see added to WHMCS

Top 10 Clients by Income Report - add date filtering

  • kurieuo shared this idea 10 years ago
  • Reporting
  • 4 Comments


The Top 10 Clients by Income Report is very interesting to see where money comes from.

I would like to suggest the addition of date filtering, so we can see our top 10 clients for the year or month, etc. Right now it is their "lifetime value", the amount is what they have paid ever as a client.

I have noticed that older clients that are no longer spending as much money but did in the past are on my report.

4 Comments

Login to post a comment.

i want this script just to show me from 2018
This query did this for you...
[co]
  • SELECT tblclients.id,datecreated,firstname,lastname,companyname,SUM(tblaccounts.amountin) as total FROM tblclients INNER JOIN
    tblaccounts ON
    tblclients.id = tblaccounts.userid
    GROUP BY tblclients.id
    ORDER BY total DESC
    LIMIT 10
  • [/co]
    Both ideas are grateful
    This is a great update for this report. It would be helpful.

    It would also be nice to see the top 20, 30, 40, 50, 100, 200, etc.