Report Generator For WHMCS will let you preview numerous ready-made reports, and also generate custom ones using any type of WHMCS data. You will be free to export, print, and compare reports, display them in a table, graph, or chart form, as well as apply various filters, or even your own PHP code to receive expected results. Furthermore, the module will allow you to schedule creating and sending selected reports, both predefined and custom ones, either via email, or to an FTP/SFTP server.

Whether you are fluent in SQL, or have never heard of it, Report Generator For WHMCS will adjust to your skills by offering two different types of inbuilt creators, each equipped with a tidily arranged, user-friendly interface. The module provides the choice of over 30 reports prepared for immediate use, that you can further filter to obtain the exact figures you seek. If you own our CRM For WHMCS, you will be granted access to 4 exclusive insights into your customer relationships as well.

No matter if you are a web hosting provider, a domains reseller, or use WHMCS in any other way - Report Generator For WHMCS will help you x-ray your company to draw sure-fire conclusions, and shoot up your income. Order the module today, and never again gamble on the future of your business!

Looking for even more powerful tool for WHMCS reporting and complete business analysis?
Try MetricsCube


  • Admin Area
    • Generate Your Own Reports
    • Access 37 Predefined Reports
    • Modify Report Results With Dynamic Filtering Options
    • Compare Side-By-Side Report Results With Different Filters
    • Generate PDF, CSV And XML Files From Reports
    • Display Print Preview And Print Reports
    • Create Reports On Demand Or Schedule Their Generation As Background Task:
      • Choose Report Filtering Options
      • Define Date Range Of Scheduled Reports
      • Upload Report To FTP/SFTP Server
      • Send Report To Selected Staff Members
      • Send Report To Any Email Address
    • Export And Import Reports Structure To File
    • Access Module Logs
  • Reports Creation
    • Add Varied Widget Sections To Created Reports:
      • Table Chart
      • Column Chart
      • Line Chart
      • Pie Chart
    • Choose Reports Creation Advancement Level:
      • Beginner:
        • Generate Reports In Several Simple Steps
        • Join Tables With Known Relations Only
        • WHMCS Tables Available Only
      • Expert:
        • Write SQL Query
        • Modify Output With PHP
        • All Database Tables Available
    • Create Dynamic Filter Types:
      • Data Range Filter - Available On Report View
      • Dropdown Filter - Specify Available Options During Report Creation
      • Number Range Filter
      • Text Filter
    • Display Live Preview Of:
      • Data Returned By Report Creator
      • SQL Query Built By Report Creator
      • Section Generated By Report Creator
  • Additional Beginner Creator Components
    • Add Tables With Known Relations And Automatically Configure Join-in Table
    • Choose Column Types For Data Presentation And Provide Friendly Aliases:
      • Field - Display Field As Is
      • CONCAT - Join Multiple Fields Into One
      • COUNT - Count All Values With The Same Value Of Group By Field
      • SUBSTR - Display Part Of Chosen Field Only
      • SUM - Summarize All Values With The Same Value Of Group By Field
      • MAX - Display Maximum Value Found Within Fields With The Same Value Of Group By Field
      • MIN - Display Minimum Value Found Within Fields With The Same Value Of Group By Field
      • AVG - Display Average Of Fields With The Same Value Of Group By Field
    • Customize Columns View:
      • Hide Specified Columns
      • Replace Their Data With Available Merge Fields And HTML Code
    • Refine Specified Data Using:
      • Expression Conditions With:
        • Comparison Operators
        • Relation Between Two Fields
      • Dynamic Filter Condition
    • Order By/Group By/Limit Data Displayed On Report
    • Skip Chosen Number Of First Records Displayed On Report
  • Predefined Reports
    • "Clients Information" Section:
      • Business Health Status:
        • Domain Renewals
        • Opened Tickets
        • New Invoices
        • Invoice Reminders
        • Hosting Renewals
        • Suspended Services
      • Client Account Statement
      • Client Credits
      • Client Payment History
      • Complete Cases:
        • Closed & Answered Tickets
        • Ticket Status In Time
        • Completed To-Do Tasks
        • To-Do Tasks Stats Per Status
        • Orders Summary
      • Created Panels
      • Customers Per Country
      • Flexible Transactions
      • Most Valuable Clients
      • Orders
      • Paid Orders
      • Sum Total Income Per Custom Field Value
      • Tasks And Tickets In Progress:
        • Task Status
        • Ticket Status
        • Completed Tasks
      • Unpaid Invoices
      • Upcoming Expiration Services
      • Created User Accounts:
        • Number Of Created User Accounts
        • List Of Created User Accounts
    • "Services" Section:
      • Income Per Country
      • Income Per Invoice
      • Invoice Summary
      • Orders Number
      • Orders Over Weekdays
      • Product Income In Location
      • Registered Services
      • Renewals Report
      • Sales Summary Per Product
      • Server Revenues
      • Transferred Domains Report
    • "Staff Members" Section:
      • Comments On Course Of Ticket Solving
      • Ratings Of Ticket Solving Course
      • Ticket Replies By Admin
      • Ticket Response Rating
      • Tickets In Hours
      • Tickets Responding Time
    • "CRM Related" Section - CRM For WHMCS Required:
      • Leads
      • Traders Renewals
      • WWW Created Panels
      • WWW Renewals
    • Cannot see the report you need? We can implement it for free!
  • General Info
Read More


v4.2.0 Released: Aug 4th, 2021
New Feature
  • WHMCS V8.2 support
  • "Client Account Statement" predefined report - case #347
  • "Client Credits" predefined report - case #347
  • "Sum Total Income Per Custom Field Value" predefined report - case #319
  • "Upcoming Expiration Services" predefined report - case #374
  • "Invoice Summary" predefined report - case #307
  • "Income Per Invoice" predefined report
  • Generate XML file type reports
  • Define custom time period for scheduled reports to generate them every or in specified months, days, days in the week, and time - case #341
  • Decide whether to send task report to email if the generated results do not contain any data - case #389
  • Use "Custom Table" to add SQL sub-queries into query filters - case #390
  • SQL queries can now be joined together using the "OR" operator instead of only the "AND" one - case #340
  • Customize column presentation to hide or replace its content via merge fields and use HTML code e.g. to display its data as URLs to clients' profiles, invoices, products, etc.
  • Generated PDF reports will now contain information about used filters - case #378
  • You can now add a single "space" character to the "PHP Code" field when using the expert mode to display SQL query results - case #352
  • Added "Next 7 Days" and "Next 30 Days" options to data selection for scheduled reports tasks - case #374
  • Support for WHMCS V7.10 and previous
  • Support for PHP 7.1 version
Bug Fix
  • Fixed problems with creating scheduled task reports when using the Mozilla Firefox browser
  • Eliminated error that could occur when trying to load the "Client Payment History" report
  • Added assorted missing translations to the language file
  • Many other code corrections and improvements
v4.1.4 Released: Aug 26th, 2020
New Feature
  • WHMCS V8.0 and PHP 7.4 support
  • Added "Opened Date" and "Assigned To" columns for the "Tickets Responding Time" report - case #366
Bug Fix
  • Fixed issue that might have stopped importing advanced reports created in Report Generator For WHMCS v3.x version after the module migration to v4.x - case #355
v4.1.3 Released: Jun 17th, 2020
New Feature
  • Ability to change the font type for generated reports in the module's "app/Config/settings.json" file - case #342
Bug Fix
  • Fixed case, where cron was set to execute actions daily, but the email messages might have been sent every two days - case #332
  • Resolved issue that might have caused task emails not being sent to the chosen administrator - case #334
  • "Sales Summary Per Product" report will no longer display empty data if no product addons are created - case #335
  • Updated date range filter query that caused issues with picking tickets between specified dates - case #339
  • Added missing UTF-8 BOM character when adding the CSV file do ZIP archive - case #343
v4.1.2 Released: Apr 9th, 2020
New Feature
  • WHMCS V7.10 support
  • Support for WHMCS V7.7 and previous
v4.1.1 Released: Nov 29th, 2019
New Feature
  • WHMCS V7.9 support
  • Support for WHMCS V7.6 and previous
Bug Fix
  • Fixed issue with encoding some characters e.g. Arabic ones that could have caused blank page problems - case #305
  • Corrected problem with the report migration that contained certain conditions such as "where ... and ...", "where ... or ..." - case #306
v4.1.0 Released: Sep 4th, 2019
New Feature
  • "Tickets Responding Time" report - view the time taken to respond to an open ticket and subsequent replies from a client - case #291
  • "Server Revenues" report - control servers' monthly maintenance costs, their services' revenues and balance - case #290
  • Added option to refer to table aliases from SQL queries when creating filters in "Expert" reports - case #292
  • New notification informing the administrator whether "exec" PHP function required for "PhantomJS" library is enabled in the server's PHP configuration
Bug Fix
  • Minor corrections to the selected built-in reports
v4.0.1 Released: Aug 7th, 2019
  • Added option to hide the MetricsCube banner
  • Slight language adjustments
Bug Fix
  • Resolved issue with checking permissions for PhantomjJS library
  • Solved case with database creation after module upgrade from the previous version
v4.0.0 Released: Jul 31st, 2019
  • Completely rewritten code
  • Revamped reports creator tool
  • Rebuilt addon module user interface
  • Reports can now be sent to any email address instead of to selected staff members only
  • Reports can now be sent via email and uploaded to an FTP/SFTP server at the same time
  • Assorted language adjustments
New Feature
  • WHMCS V7.8 and PHP 7.3 support
  • Reports comparison - view any report in a side-by-side view to compare results based on the selected filtering options
  • Generate tasks on demand - large reports with long preparation time can now be created and sent in the background from the report view using cron jobs
  • Support for WHMCS V7.5 and previous
  • "MRR & Churn Metrics" and "MRR & Churn Per Product" reports
  • Reports creator tool now consists of two widgets: "Beginner" and "Expert" instead of three
Bug Fix
  • Various corrections to predefined reports
v3.1.3 Released: Apr 16th, 2018
New Feature
  • WHMCS V7.5 support
  • PHP 7.1 and 7.2 support
Bug Fix
  • Fixed problem with sending reports only to the first selected administrator instead of the entire group
  • Removed obsolete 'full_query' function to prevent the 'MRRChurnPerProductReport' problem
  • Resolved incorrect asset loading over HTTP instead of HTTPS
  • Fixed currency conversion for monthly sales reports
v3.1.2 Released: Jun 1st, 2017
  • Admins list is now in alphabetical order and does not contain disabled accounts
Bug Fix
  • Resolved problem with import of custom reports from 3.0 version
  • Corrected 'Affiliate ID' column in predefined 'Orders Report'
  • Data parsed using custom PHP code in 'Advanced Creator' are now saved properly
  • Solved issue with invalid custom filters operation in reports of advanced type
v3.1.1 Released: Mar 10th, 2017
Bug Fix
  • Resolved problem of incorrect CSV reports' export caused by line breaks
  • Corrected file saving after custom report creation
v3.1.0 Released: Jan 25th, 2017
New Feature
  • WHMCS V7 support
  • PHP 7 support
  • Generate reports in CSV format
  • Expanded range of time periods used upon scheduled report creation
  • Include filters in reports of PDF/CSV format and while viewing printable version
Bug Fix
  • Minor tweaks
v3.0.0 Released: Sep 14th, 2016
  • Fully rewritten and redesigned module
  • WYSIWYG creator has been replaced with drag & drop creators - Beginner, Intermediate and Advanced
New Feature
  • Schedule reports to be sent via FTP/SFTP
  • Define type of filters - date range, time period, dropdown, numeric range and text
  • Search through available tables and fields
  • Beginner and Intermediate creators - automatically join tables with common relation
  • Beginner and Intermediate creators - define static conditions
  • Beginner and Intermediate creators - define conditions between two columns
  • Beginner and Intermediate creators - use SQL functions easily by choosing desired ones from the list
  • Beginner and Intermediate creators - skip specified number of first records
  • New Report: Unpaid Invoices
  • New Report: Client Payment History
  • New Report: Sales Summary Per Product
  • New Report: Comments On Course Of Ticket Solving
  • New Report: Ratings Of Ticket Solving Course
  • New Report: Ticket Response Rating
  • New Report: Flexible Transactions Report
  • Restrict ability to modify output with PHP language to Intermediate and Advanced creators - previously always available
  • Remove settings to store unfinished section progress in creator – settings are stored by default and can be reset
  • Remove settings to generate reports via Cron Job - optimization issues allowing to generate it via browser have been resolved
  • Remove settings to generate reports using UTF-8 encoding - use it by default
  • Remove definitions settings - store definitions in multi-language files
  • Divide predefined reports into categories
  • Migration from previous version of Report Generator For WHMCS - for the duration of BETA
  • Export reports to CSV or XML - for the duration of BETA
  • Clone report section - for the duration of BETA
  • Support for WHMCS V5
v2.1.2 Released: Feb 8th, 2016
Bug Fix
  • Generate PDF reports by cron job
v2.1.1 Released: Oct 16th, 2015
  • Support of graphs encoded with UTF-8 in PDF reports
  • Supported fonts for generating PDF reports in WHMCS V6
v2.1.0 Released: Aug 20th, 2015
New Feature
  • WHMCS V6 support
  • New Predefined Report: [CRM] Leads Report
  • New Predefined Report: [CRM] Traders Renewals Report
  • New Predefined Report: [CRM] WWW Created Panels Report
  • New Predefined Report: [CRM] WWW Renewals Report
  • New Predefined Report: Orders Report
  • New Predefined Report: Paid Orders Report
  • New Predefined Report: Created Panels Report
  • New Predefined Report: Renewals Report
  • New Predefined Report: Transferred Domains Report
Bug Fix
  • Export to PDF
  • Minor tweaks
v2.0.5 Released: Jan 14th, 2015
  • New Predefined Report: Income Per Country
  • New Predefined Report: Income Per Country Per Product
  • New Predefined Report: MRR & Churn Metrics
  • New Predefined Report: MRR & Churn Per Product
v2.0.1 Released: Aug 29th, 2014
  • Improved security and license validation
v2.0.0 Released: May 30th, 2014
  • Module rewritten from scratch
  • Rebuilt and improved user interface
New Feature
  • Drag & Drop WYSIWYG report builder (dynamically generated tables, charts and graphs)
  • New charts: column & area charts
  • Export report data to CSV & XML
  • Export report data to CSV from view page
  • Predefined SQL expressions at the report builder
  • Multiple joins at the report builder
  • Cloning section at the report builder
  • Data tables in a report views are now sortable
  • Print view of a report
  • Generate a PDF report using a cron job
  • Generate a PDF using special Unicode font
  • Translation of a database columns and tables from the inside of module settings
  • Migration Tool that allows you to migrate reports from a version 1.0 of the module
  • Multiple cron jobs replaced with only one cron job
  • Time filtering is now optional
  • Fixed: Major bug fixes
v1.0.0 Released: Dec 19th, 2013
  • Stable Release
Read More


  • 2 years ago
    we so happy to use report generator, its help us to improve our services and support ticket responses
  • 2 years ago
    WHMCS didn't have the level of reports that we required to manage our customer data. We did the trial of the ModulesGarden Report Generator for WHMCS and purchased the product well before the trial expired. It has everything we need, plus we have built a number of custom reports. This product is highly recommended!
  • 2 years ago
    With these module you have no need to know SQL, because support drag&drop functions. Great module, I couldn't ask for more.
Read More

See Also

Resellers Center For WHMCS Icon
Resellers Center

Resellers Center For WHMCS

Chosen by 551 customers

Allow resellers to offer your products under own brand, manage acquired customers and earn profits for each sale plus let end clients handle key aspects in your WHMCS.

Multibrand For WHMCS Icon

Multibrand For WHMCS

Chosen by 663 customers

Run multiple brands on multiple websites under your careful management and close supervision while using just a single WHMCS license.

MetricsCube Connector For WHMCS Icon
MetricsCube Connector

MetricsCube Connector For WHMCS

Chosen by 881 customers

Synchronize WHMCS with MetricsCube to access over 70 sophisticated business reports, use intelligent filters, and compare data from various sources and time frames.

NIC IT Registrar For WHMCS Icon
NIC IT Registrar

NIC IT Registrar For WHMCS

Chosen by 71 customers

Implement the automation of .it domains reselling and management in WHMCS plus offer your clients the freedom to personalize each order and handle renewals of TLDs.