How can we improve WHMCS?

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

  1. Home
  2. Ideas
  3. Reporting
  4. Top 10 Clients by Income Report - add date filtering

Top 10 Clients by Income Report - add date filtering

  • kurieuo shared this idea 11 years ago
  • Reporting
  • 5 Comments


20 Votes
Login to Vote
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.

5 Comments

Login to post a comment.

bonitacaily commented 4 weeks ago
Thank you for providing very useful information! Play game https://smashy-road.io free.
Flasher commented 13th December 18
i want this script just to show me from 2018
M.F.Aziz commented 22nd November 16
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]
    luis Silva commented 28th December 15
    Both ideas are grateful
    ahobach commented 20th September 13
    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.