Build a WHMCS Dashboard with AI in 10 Minutes

WHMCS gives you a default admin dashboard with income summaries, order counts, and ticket stats. It is useful. It is also generic. It shows the same data to every hosting provider regardless of what matters to their business.

What if you could build a custom dashboard by just describing what you want?

With Claude and MCP Server, you can. This tutorial walks you through connecting AI to your WHMCS and using it to pull, analyze, and format the data that matters to you. No code. No SQL. No spreadsheets.

What You Need

• WHMCS 8.0 or newer (including 9.0)
• MCP Server module installed in your WHMCS
• An AI assistant with MCP support (Claude Desktop recommended)
• 10 minutes

If you don't have MCP Server installed yet, follow the setup guide. Installation takes about 5 minutes.

Step 1: Connect Claude to Your WHMCS

Once MCP Server is installed, add it to your Claude Desktop configuration:

{
  "mcpServers": {
    "whmcs": {
      "command": "npx",
      "args": [
        "mcp-remote",
        "https://your-whmcs.com/modules/addons/mx_mcp/mcp.php",
        "--header",
        "Authorization:Bearer YOUR_BEARER_TOKEN"
      ]
    }
  }
}

Replace your-whmcs.com with your WHMCS URL and YOUR_BEARER_TOKEN with the Bearer token from MCP Server settings.

Restart Claude Desktop. You should see WHMCS tools available in the conversation.

For detailed connection instructions including Cursor and other AI clients, see MX Modules Integrations.

Step 2: Pull Your Business Snapshot

Start with a broad question. Type this into Claude:

"Give me a business snapshot of my WHMCS: total active clients, total active services, overdue invoices count and total amount, and recent ticket count."

Claude queries your WHMCS through MCP Server and returns something like:

Example response:

• Active clients: 347
• Active services: 892
• Overdue invoices: 23 ($4,287.50 total)
• Tickets opened this week: 41

This is already more useful than clicking through four different WHMCS screens. But we can go further.

Step 3: Analyze Client Distribution

Now let's understand your client base:

"Break down my active services by product group. Show me how many services are in each group and the monthly revenue contribution of each."

Claude returns a product breakdown:

Example response:

Instantly you see that VPS and Dedicated Servers generate more revenue per service than Shared Hosting. This takes 30 seconds with AI. In WHMCS, you would need to export data and build a pivot table.

Step 4: Find Your Overdue Invoice Problem

Overdue invoices are money sitting on the table. Let's dig in:

"List my top 10 overdue invoices by amount. For each one, show the client name, invoice amount, due date, and how many days overdue."

Claude pulls the data and formats it:

Example response:

Now you know exactly where to focus your collection efforts. The highest-value overdue invoices get priority.

"For the top 3 overdue clients, what services do they have and how long have they been customers?"

This context helps you decide whether to suspend services, send a polite reminder, or offer a payment plan. A 3-year client with one overdue invoice gets a different approach than a 2-month client who has never paid.

Step 5: Identify Revenue Concentration Risk

Here's a question most hosting providers never ask:

"What percentage of my total monthly revenue comes from my top 10 clients?"

Example response: "Your top 10 clients generate $8,400/month, which is 34% of your total monthly revenue of $24,985."

If 34% of your revenue comes from 10 clients out of 347, you have concentration risk. Losing any one of those clients would hit hard. This is the kind of insight that takes hours to calculate manually but seconds with AI.

Step 6: Check Ticket Load Distribution

Support costs eat into margins. Let's see where the load is:

"Which 10 clients opened the most support tickets in the last 30 days? Show ticket count and their monthly service value."

Example response:

A client generating 18 tickets on a $29.99 plan is likely costing you money. Each ticket averages 15-20 minutes of support time. At $25/hour, 18 tickets cost roughly $112 in support labor. On a $30/month plan, that client is deeply unprofitable.

Cross-reference this with Why WHMCS Does Not Show Your Real Profit to understand the full picture.

Step 7: Build Your Morning Briefing

Now combine everything into a single prompt you can run every morning:

"Give me my morning WHMCS briefing:

1. Total active clients and services
2. Revenue collected in the last 7 days
3. New orders in the last 7 days
4. Overdue invoices count and total
5. Open tickets count
6. Any services pending setup or activation"

Save this prompt somewhere you can find it. Run it every morning and you have a personalized dashboard in 30 seconds.

For more prompts like this, see 5 AI Prompts WHMCS Admins Should Save.

Step 8: Create Action Items

The real power is not just seeing data. It's getting recommendations:

"Based on my current WHMCS data, what are the three most urgent actions I should take this week? Consider overdue invoices, pending orders, and open tickets."

Claude analyzes your data and provides prioritized recommendations:

Example response:

1. "Contact ABC Hosting Co about their $1,200 overdue invoice. They've been a client for 3 years, so a personal call may be more effective than automated reminders."
2. "You have 4 pending service setups more than 24 hours old. Clients are waiting. Prioritize the $299/month dedicated server order."
3. "12 tickets are older than 48 hours without a response. Client satisfaction drops sharply after this window."

This is a business dashboard that thinks, not just displays.

Tips for Better Results

Be Specific

Vague prompts get vague results.

Bad: "How is my business doing?"

Good: "Compare my total revenue this month versus the same month last year. Break it down by product group."

Save Your Best Prompts

Once you find prompts that give useful results, save them. Build a collection of go-to queries for different situations:

• Morning briefing (daily)
• Revenue analysis (weekly)
• Client profitability review (monthly)
• Overdue invoice follow-up (as needed)

Combine with MX Metrics

AI through MCP Server is great for ad-hoc queries and custom analysis. For persistent dashboards with historical trends, churn tracking, and automated profitability calculations, MX Metrics provides the always-on analytics layer.

The two complement each other:

• MCP Server + AI: Ask anything, anytime. Custom analysis on demand.
• MX Metrics: Persistent dashboards with MRR trends, churn rates, and profit tracking that update automatically.

What You Can't Do (Yet)

AI dashboards through MCP Server have limitations:

• No historical trending. Each query is a snapshot. You get current data, not "how has this metric changed over the past 6 months."
• No automated scheduling. You start each interaction. It doesn't generate reports at 8 AM automatically.
• No visual charts. Results come as text and tables. For graphs and charts, you need a traditional dashboard tool.
• Human-in-the-loop required. This is interactive, not automated. For unattended reporting, use MX Metrics or custom scripts.

These limitations matter. For real-time, interactive analysis, AI is faster than any traditional dashboard. For persistent monitoring with trend lines and alerts, you need a dedicated analytics tool.

Frequently Asked Questions

Do I need coding skills for this?

No. Every query in this tutorial is plain English. You type a question, Claude queries your WHMCS, and you get a formatted response. If you can write an email, you can build an AI dashboard.

Is my data safe when using AI with WHMCS?

With MCP Server, your data stays on your WHMCS server. Claude queries it in real-time but doesn't store your client information. For maximum privacy, you can use local AI models like Ollama. See What Is MCP Protocol? A Guide for WHMCS Admins for how the protocol works.

Can I use ChatGPT instead of Claude?

ChatGPT doesn't have native MCP support. You can use it through third-party connectors like Zapier, but the experience is less direct. Claude Desktop has native MCP support, which makes it the smoothest option. See How to Use ChatGPT with WHMCS for all available methods.

How accurate are the AI responses?

The data is pulled directly from your WHMCS database in real-time, so the numbers are accurate. The analysis and recommendations are AI-generated based on that data. Always verify critical business decisions against your own records.

Can multiple team members use this?

Yes. Each team member needs their own AI assistant configuration (Claude Desktop or similar) and an MCP Server API token. You can create multiple tokens with different permission levels in the MCP Server settings.

Related

• 5 AI Prompts WHMCS Admins Should Save - Ready-to-use prompts for daily WHMCS management
• Connect AI to WHMCS with MCP (Setup Guide) - Detailed MCP Server installation
• MCP Server vs WHMCS API: Which Do You Need? - When to use each approach
• How to Use ChatGPT with WHMCS - All methods compared
• 10 WHMCS Tasks AI Handles for You - More practical AI automation examples