WHMCS includes many built-in reports, but custom reports give you the exact data you need. Learn how to create custom reports, build admin dashboard widgets, and visualize your business metrics effectively.
Why Custom Reports?
- Track metrics specific to your business
- Visualize trends over time
- Focus on actionable insights
- Faster access to key data
- Automate report generation
Built-in vs Custom Reports
WHMCS Built-in Reports
| Report | Purpose | Location |
|---|---|---|
| Income Report | Revenue by month/year | Reports → Income |
| Transactions List | Payment history | Reports → Transactions |
| Product Sales | Sales by product | Reports → Products/Services |
| Support Tickets | Ticket statistics | Reports → Support |
| Client Stats | Client activity | Reports → Clients |
When You Need Custom Reports
- Combine data from multiple sources
- Calculate custom metrics (LTV, churn)
- Filter by specific criteria
- Visualize with charts and graphs
- Export to specific formats
- Schedule automated delivery
Report Architecture
Report File Structure
Custom reports are stored in modules/reports/:
- One file per report
- Filename becomes report name
- Must follow WHMCS report structure
- Uses Smarty for templating
Report Components
- Title: Report display name
- Description: Brief explanation
- Date Range Selector: Filter by dates
- Query Logic: Database queries
- Output Format: Table, chart, or both
Essential Business Reports
Monthly Recurring Revenue (MRR)
Track your MRR to understand predictable revenue:
- Sum of all active recurring products
- Normalize to monthly values
- Track month-over-month growth
- Segment by product type
Churn Analysis
Monitor customer and revenue churn:
- Cancelled services count
- Revenue lost to cancellations
- Churn rate percentage
- Reasons for cancellation
Customer Lifetime Value (LTV)
Calculate average customer value:
- Total revenue per customer
- Average customer lifespan
- Segment by acquisition source
- Compare to acquisition cost
Revenue Reports
Revenue by Product Category
| Category | Monthly Revenue | % of Total |
|---|---|---|
| Web Hosting | $15,000 | 35% |
| VPS | $12,000 | 28% |
| Dedicated Servers | $8,000 | 19% |
| Domains | $5,000 | 12% |
| Add-ons | $2,500 | 6% |
Payment Gateway Performance
Analyze payment success rates:
- Transactions by gateway
- Success vs failure rates
- Average transaction value
- Processing fees comparison
Client Reports
Client Acquisition
- New clients by month
- Acquisition source breakdown
- Conversion rate from trial
- First purchase value
Client Value Segmentation
| Segment | Revenue Range | % of Clients | % of Revenue |
|---|---|---|---|
| Enterprise | $500+/month | 5% | 45% |
| Business | $100-499/month | 15% | 35% |
| SMB | $25-99/month | 40% | 15% |
| Starter | $0-24/month | 40% | 5% |
Support Reports
Ticket Analytics
- Tickets opened vs resolved
- Average response time
- Resolution time by department
- Tickets by category
- Peak hours analysis
Support Load by Product
Identify high-maintenance products:
- Tickets per active service
- Support cost per product
- Common issue patterns
- Knowledge base gaps
Dashboard Widgets
Admin Dashboard Customization
Create widgets for quick insights:
- MRR current and trend
- New orders today/week
- Open tickets count
- Pending invoices value
- Overdue invoices count
Widget Types
| Type | Use Case | Example |
|---|---|---|
| Counter | Single metric | Total MRR |
| Chart | Trends over time | Revenue line chart |
| Table | List of items | Recent orders |
| Pie Chart | Distribution | Revenue by product |
| Progress | Goals tracking | Monthly target |
Data Visualization
Chart Libraries
- Chart.js: Lightweight, easy integration
- ApexCharts: Modern, interactive
- D3.js: Complex visualizations
- Google Charts: Simple, hosted
Effective Chart Types
- Line: Trends over time
- Bar: Comparisons
- Pie/Donut: Composition
- Gauge: Progress to goal
- Area: Cumulative values
Report Automation
Scheduled Reports
- Daily summary email
- Weekly performance report
- Monthly business review
- Quarterly analysis
Automation Options
- WHMCS cron-based generation
- Email delivery to stakeholders
- Export to CSV/PDF
- Push to external dashboards
External Integrations
Business Intelligence Tools
- Google Data Studio: Free, powerful
- Tableau: Enterprise analytics
- Metabase: Open source BI
- Power BI: Microsoft ecosystem
Integration Methods
- Direct database connection
- API data export
- Scheduled CSV exports
- Webhook data push
Best Practices
Report Design
- Focus on actionable metrics
- Include time comparisons
- Use clear labels and legends
- Highlight anomalies
- Keep it simple and scannable
Performance Considerations
- Cache expensive queries
- Use database indexes
- Limit date ranges for large datasets
- Paginate large result sets
- Run heavy reports during off-peak
Implementation Checklist
Custom Reports Checklist
- Identify key metrics needed
- Map data sources in WHMCS
- Design report structure
- Create report files
- Add appropriate visualizations
- Build dashboard widgets
- Test with production data
- Set up scheduled delivery
- Document report logic
- Train team on usage
Conclusion
Custom reports transform WHMCS from a billing system into a business intelligence platform. Focus on metrics that drive decisions, automate routine reporting, and use visualizations to spot trends quickly. The investment in custom reporting pays off through better business insights.
Need Custom Reporting?
I build custom WHMCS reports, dashboard widgets, and BI integrations to give you the insights you need to grow your hosting business.
Get Custom Reports
About Shahid Malla
ExpertFull Stack Developer with 10+ years of experience in WHMCS development, WordPress, and server management. Trusted by 600+ clients worldwide for hosting automation and custom solutions.