Skip to content
Custom Development Verified service · 5.0 rating

WHMCS Reporting & Analytics

MRR, churn, cohort and LTV reports built from your WHMCS data, as custom reports, dashboard widgets or BI dashboards.

Fixed-price quote in 24h 14-day correction guarantee 1 year free support

WHMCS reporting and analytics work turns the billing data already in your WHMCS database into the numbers a subscription business is run on: monthly recurring revenue, churn, customer lifetime value and retention by signup month. It is for hosting companies, VPS sellers and IPTV operators who export CSV files every month and still cannot say whether recurring revenue grew. One custom report starts at $149, paid once. The subject here is billing and customer data inside WHMCS; tracking which ad campaigns brought in paying customers is a separate job, covered by GA4 and Google Ads conversion tracking.

What the built-in reports cover, and where they stop

Reports > Reports in the admin area already includes useful reports such as Annual Income Report, Income by Product, Monthly Transactions, New Customers, Customer Retention Time, Aging Invoices and Top 10 Clients by Income, and any of them can be exported to CSV from the Tools menu. The gaps show up when you ask subscription questions:

  • There is no MRR figure, and nothing that splits the monthly change into new, expansion, contraction and churned revenue
  • Income Forecast assumes every active service and domain renews, and leaves out addons and billable items
  • Churn is not reported as a monthly rate, by product or by client group
  • Lifetime value and retention by signup month are not available at all

Metric definitions, agreed in writing first

Two people can calculate MRR from the same WHMCS database and get different answers. Before any query is written, we send a one-page definitions sheet for you to approve. A typical version: recurring amounts on active services, addons and domains, divided down to a monthly figure (quarterly by 3, annual by 12, biennial by 24, triennial by 36), converted to your base currency, with setup fees and one-time items excluded. Churned MRR, logo churn, average revenue per account and LTV get the same treatment. On WHMCS 9.x, credit notes listed under Billing > Credit and Debit Notes are netted off revenue, because published invoices are no longer edited directly.

Where the numbers come from

The queries read the WHMCS tables that hold this data: tblhosting, tblhostingaddons and tbldomains for recurring amounts and status, tblinvoices and tblinvoiceitems for billing, tblaccounts for transactions, and tblclients and tblorders for signup dates and sources. Each report is checked against the Annual Income Report and Monthly Transactions for sample months, and any difference is explained in the handover note.

Three ways to deliver it

Custom WHMCS reports

A PHP report file placed in /modules/reports/ appears in the Reports list next to the stock reports, can draw charts with the Google Charts helper WHMCS provides, exports to CSV, and follows your existing admin role permissions. This is the cheapest option and needs nothing outside WHMCS.

Admin dashboard widgets

An MRR or churn tile on the admin homepage, built with the AdminHomeWidgets hook and WHMCS's widget class, so the headline numbers are the first thing staff see after login.

External BI dashboards

For drill-downs and sharing with partners, we create a read-only MySQL user limited to the needed tables, ideally on a replica or nightly copy, and connect Metabase, Grafana, Looker Studio or Power BI to it. Heavy reporting queries then never compete with live checkout traffic. If the database itself is slow, see database optimization first.

Inputs from your side

  • The questions you want answered each month, in your own words
  • Admin access, plus database access or permission to create a read-only user
  • Your base currency and how you treat refunds, credits and free trials

Deliverables

The approved definitions sheet, the report files or dashboard, the SQL behind each figure, and the reconciliation notes. If a figure disagrees with the approved definitions, tell us within 14 days and we correct the query free.

Pricing

ScopeOne-time price
One custom WHMCS report, such as MRR by product with a monthly trend chartFrom $149
A KPI pack: MRR movements, churn, ARPA and a cohort retention table, plus a dashboard widgetPriced by the number of metrics
Read-only database access and dashboards in Metabase, Grafana, Looker Studio or Power BIPriced by dashboards and data sources

A packaged alternative exists too: the Freedompilot module includes MRR, churn, LTV and cohort reporting alongside its automation tools.

Not included

  • Licenses or hosting for the BI tool
  • Accounting, tax or audit advice
  • Data from systems other than WHMCS, unless quoted separately
  • Custom reports on WHMCS Cloud, which WHMCS does not currently support there

Tell us the three numbers you most want to see every Monday, and the quote will start from those.

What's included

Every WHMCS Reporting & Analytics engagement ships with these.

  • Written definitions sheet for MRR, churn, ARPA and LTV approved before build
  • MRR normalized from every billing cycle and converted to your base currency
  • New, expansion, contraction and churned MRR by month
  • Cohort retention table by signup month
  • Custom report files in /modules/reports/ with charts and CSV export
  • Admin homepage widgets built on the AdminHomeWidgets hook
  • Read-only MySQL user for Metabase, Grafana, Looker Studio or Power BI
  • Credit and debit notes netted off revenue on WHMCS 9.x
  • Reconciliation against Annual Income Report and Monthly Transactions
  • SQL for every figure handed over with the reports

Business outcomes

What hosting operators report after delivery.

  • Monthly recurring revenue and churn become one agreed number instead of a spreadsheet debate
  • You can see which products and signup months keep customers longest
  • Reporting queries stay off the live database when a replica is used
  • Staff see headline numbers on the admin homepage without running exports
  • Every figure can be traced back to the SQL that produced it

Ready to talk about WHMCS Reporting & Analytics?

Quick scoping call, fixed-price quote within 24 hours, no commitment.

Related services

Other WHMCS work hosting operators ask us about.