0

Overview

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

Features

  • Admin Area
    • Generate Your Own Reports
    • Access 31 Predefined Reports
    • Modify Report Results With Dynamic Filtering Options
    • Compare Side-By-Side Report Results With Different Filters
    • Generate PDF And CSV 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
    • 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 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
      • Tasks And Tickets In Progress:
        • Task Status
        • Ticket Status
        • Completed Tasks
      • Unpaid Invoices
      • Created User Accounts:
        • Number Of Created User Accounts
        • List Of Created User Accounts
    • "Services" Section:
      • Income Per Country
      • 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

Changelog

v4.1.1 Released: Nov 29th, 2019
New Feature
  • WHMCS V7.9 support
Removed
  • 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
Improvement
  • 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
Improvement
  • 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
Improvement
  • 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
Removed
  • Support for WHMCS V7.5 and previous
  • "MRR & Churn Metrics" and "MRR & Churn Per Product" reports
Changed
  • 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
Improvement
  • 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
Improvement
  • 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
Improvement
  • 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
Changed
  • 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
Removed
  • 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
Improvement
  • 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
Others
  • 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
Others
  • 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
Changed
  • Improved security and license validation
v2.0.0 Released: May 30th, 2014
Changed
  • 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
Changed
  • Multiple cron jobs replaced with only one cron job
  • Time filtering is now optional
Others
  • Fixed: Major bug fixes
v1.0.0 Released: Dec 19th, 2013
Launch
  • Initial Release
Read More

Reviews

  • 3 months ago
    we so happy to use report generator, its help us to improve our services and support ticket responses
  • 8 months 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!
  • 10 months 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

Multibrand For WHMCS Icon
Multibrand
$149.95/yr
Featured

Multibrand For WHMCS

Chosen by 527 customers

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

$149.95/yr
Domains Reseller For WHMCS Icon
Domains Reseller
$199.95/yr
Featured

Domains Reseller For WHMCS

Chosen by 330 customers

Allow resellers to offer your TLDs directly to their clients through any system, while you set up various pricing groups, shape refund policy, manage credits, and control income.

$199.95/yr
MetricsCube Connector For WHMCS Icon
MetricsCube Connector
$0.00
Free
Featured

MetricsCube Connector For WHMCS

Chosen by 363 customers

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

$0.00
Server Allocator For WHMCS Icon
Server Allocator
$49.95/yr

Server Allocator For WHMCS

Chosen by 183 customers

Set switching rules based on configurable options, product addons and custom fields to automatically match the most suitable servers to products ordered by your clients.

$49.95/yr
;
;