# WHMCS Reporting & Analytics

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

Custom WHMCS reporting: agreed metric definitions, custom reports in /modules/reports, admin dashboard widgets or Metabase, Grafana and Looker Studio dashboards. From $149.

- **Price:** Starting at $149
- **Billing:** One-time, fixed scope
- **Category:** Custom Development
- **Quote turnaround:** Fixed-price quote within 24 hours
- **Start a project:** https://whmcspilot.com/start-project
- **Details:** https://whmcspilot.com/services/whmcs-reporting-analytics
- **Last updated:** 2026-11-05

## Overview

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](/services/whmcs-ga4-google-ads-tracking).

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

Reports &gt; 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 &gt; 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](/services/whmcs-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 priceOne custom WHMCS report, such as MRR by product with a monthly trend chartFrom $149A KPI pack: MRR movements, churn, ARPA and a cohort retention table, plus a dashboard widgetPriced by the number of metricsRead-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](/modules/whmcs-freedompilot) 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

- 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

- 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

## Frequently asked questions

### Does WHMCS show MRR?

Not directly. The built-in reports cover income, transactions and forecasts, but MRR has to be calculated from recurring amounts on active services, addons and domains, which is what our reports do.

### Why doesn't Income Forecast match my MRR?

Income Forecast assumes every active service and domain renews on its due date and excludes addons and billable items. MRR as we define it includes addons and is based on current recurring amounts, so the two answer different questions.

### Can I connect Metabase or Power BI to WHMCS?

Yes, through a read-only MySQL user limited to the tables the dashboards need. A replica or nightly copy is better than the live database for this.

### Are custom reports affected by WHMCS updates?

Report files in /modules/reports/ are your own and are not overwritten. A major upgrade can change table structures, so recheck the figures after moving to a new branch such as 9.x.

### How long does a custom report take?

Expect a draft to check against your own numbers shortly after the definitions sheet is signed off. The written quote names the delivery day.

### How do I pay for a reporting project?

A 50% deposit books the work, and the balance is invoiced once you have checked the reports against your own figures. Card, PayPal and crypto payments are all possible.
