Advisor Dashboards

Advisor Dashboards

Core Concepts

1. Practice-Level KPIs

Key performance indicators for advisory practices fall into several categories, each measuring a different dimension of firm health. A well-designed KPI framework provides both a snapshot of current performance and the trend data needed to identify emerging risks or opportunities.

AUM (Assets Under Management). The foundational metric for any AUM-based advisory practice. Total firm AUM is the product of client count, average relationship size, and market performance. AUM should be tracked at multiple levels: firm total, by advisor or team, by client segment (high-net-worth, mass affluent, institutional), by account type (taxable, IRA, trust, plan), and by custodian. AUM changes decompose into two components — market appreciation/depreciation and net new assets — and tracking each separately reveals whether growth is organic (advisor-driven) or market-driven.

Revenue. Total advisory revenue, broken down by fee type (AUM-based fees, financial planning fees, hourly fees, performance fees, other), by advisor or team, by client segment, and by billing period. The effective fee rate (total revenue divided by average AUM) is a critical derived metric that reveals fee compression trends over time. Revenue should be tracked on both an accrual basis (for GAAP reporting) and a cash basis (for cash flow management).

Client Count. The number of active client households, tracked by segment, advisor, and tenure. Distinguish between households (the billing and relationship unit) and accounts (the custodial unit). A firm with 500 households might have 2,000 accounts. Client count trends — net new households per quarter, attrition rate, and average household tenure — reveal the health of the firm's client acquisition and retention efforts.

Revenue Per Client. Average annual revenue per household, segmented by client tier. This metric exposes whether the firm is growing revenue through larger relationships or by adding many small ones. Declining revenue per client may indicate fee compression, client downsizing, or an acquisition strategy that targets smaller relationships than the firm's economics require.

Average Account Size. Total AUM divided by the number of accounts (or households). Tracked over time, this metric reveals whether the firm is attracting larger or smaller relationships. When combined with revenue per client, it exposes effective fee rate trends at the client level.

Organic Growth Rate. Net new assets (new client assets plus existing client contributions minus withdrawals minus terminated client assets) divided by beginning-of-period AUM, expressed as an annualized percentage. Organic growth strips out market appreciation to isolate the advisor-driven component of AUM change. Industry benchmarks for healthy RIAs typically target 5-10% annual organic growth. Negative organic growth — even during strong markets — signals that the firm is losing ground despite favorable conditions.

Retention Rate. The percentage of beginning-of-period AUM or client count that remains at the end of the period, excluding market effects. A 95% client retention rate means 5% of clients (by count or AUM) left during the period. Retention is often more valuable than acquisition: replacing a departed $2M client requires acquiring two new $1M clients, each carrying acquisition cost and onboarding effort.

Referral Rate. New clients acquired through existing client referrals as a percentage of total new clients. Referral-sourced clients tend to have higher AUM, lower acquisition cost, and higher retention. Tracking referral rate by advisor identifies which advisors have the strongest referral networks and which may benefit from referral training or process improvement.

Profitability Metrics. For firms that track practice-level financials, operating margin (revenue minus direct and allocated expenses, divided by revenue) is the ultimate measure of practice efficiency. Industry benchmarks for well-run RIAs typically show operating margins of 25-35%. Revenue per employee (total revenue divided by total headcount) provides a simpler proxy for overall productivity. Compensation-to-revenue ratio (total compensation including advisor payouts divided by total revenue) should typically fall between 55-70% for sustainable practices.

2. AUM and Revenue Dashboards

AUM and revenue dashboards provide the financial pulse of the advisory practice. They answer the questions firm leadership asks most frequently: how much do we manage, how much are we earning, where is the growth coming from, and what does the trajectory look like?

AUM by Advisor/Team/Segment. A hierarchical view that drills from firm total AUM down to team, advisor, and individual household. Heatmaps or bar charts comparing advisors by AUM highlight concentration risk (if one advisor manages a disproportionate share) and identify capacity constraints (advisors approaching their effective management limit). Segment views (by client tier, account type, or investment model) reveal the composition of the firm's book and inform strategic decisions about target markets.

Revenue by Fee Type. A breakdown showing what percentage of total revenue comes from AUM-based fees versus planning fees, hourly fees, or other sources. Firms diversifying beyond pure AUM-based revenue should track the mix over time. A rising share of planning fee revenue indicates successful adoption of comprehensive planning services. Billing exception rates by fee type highlight operational trouble spots.

Pipeline and Flows Tracking. The flow of assets into and out of the firm, tracked on a rolling basis. Key flow metrics include:

• Gross inflows — New client assets plus existing client contributions. Decompose into new relationship inflows (first deposit from a new household) and existing relationship inflows (additional assets from current clients, including rollovers, consolidations, and savings contributions).
• Gross outflows — Client withdrawals plus terminated client assets. Decompose into distribution outflows (planned withdrawals for income, RMDs, or specific needs) and attrition outflows (clients leaving the firm entirely or moving assets to competitors).
• Net flows — Gross inflows minus gross outflows. Positive net flows indicate the firm is gathering more than it is losing. Net flows should be tracked monthly and displayed as a rolling 12-month trend.
• Pipeline — Prospective clients and anticipated asset transfers that have not yet funded. Pipeline tracking requires CRM integration and should display the prospect's name, estimated AUM, probability of close, expected funding date, and assigned advisor.

AUM Growth Decomposition. A waterfall chart or stacked bar showing the components of AUM change over a period:

• Beginning AUM
• Plus: market appreciation (or minus: market depreciation)
• Plus: net new assets (inflows minus outflows)
• Equals: ending AUM

This decomposition is essential for management because it separates controllable growth (net new assets) from uncontrollable growth (market returns). A firm whose AUM grew 12% in a year where markets returned 10% actually achieved only 2% organic growth — a far less impressive result than the headline number suggests.

3. Client Flow Analytics

Client flow analytics go beyond aggregate flow numbers to analyze the dynamics of client acquisition, retention, and asset consolidation at a granular level.

New Client Acquisition Funnel. Track the conversion pipeline from initial lead through prospect meeting, proposal delivery, agreement signing, and account funding. Key funnel metrics include: lead-to-meeting conversion rate, meeting-to-proposal rate, proposal-to-close rate, close-to-fund rate, average time from lead to funded account, and average funded amount versus initial estimate. Funnel analytics by advisor expose differences in prospecting effectiveness and identify bottlenecks (an advisor with a high meeting-to-proposal rate but low proposal-to-close rate may need help with proposal quality or pricing).

Client Attrition Tracking. Monitor departing clients by reason (voluntary termination, death, relocation, fee sensitivity, service dissatisfaction, competitor solicitation), by advisor, by client segment, and by tenure. Attrition dashboards should display both the count and the AUM impact of departures. Early-tenure attrition (clients leaving within the first two years) suggests onboarding or expectation-setting issues. Long-tenure attrition (clients of 10+ years departing) may signal relationship fatigue or a generational transition where heirs move assets.

Money-in-Motion Indicators. Proactive signals that a client may be consolidating assets (opportunity) or preparing to leave (risk). Key indicators include: large cash deposits from external sources (potential rollover or inheritance), systematic outflows exceeding income needs (possible transfer to a competitor), reduced engagement (fewer meetings, unanswered communications), and changes to beneficiary designations or account titling. The dashboard should flag these indicators for advisor follow-up before the client makes a final decision.

Asset Consolidation Tracking. For existing clients with held-away assets, track consolidation opportunities — the gap between total household assets (visible through aggregation) and managed assets. A client with $3M managed and $2M held away in a former employer 401(k) represents a $2M consolidation opportunity. Consolidation dashboards rank opportunities by dollar value and likelihood, enabling advisors to prioritize outreach.

Competitive Losses. When clients depart, capture the destination (self-directed, competitor RIA, wirehouse, robo-advisor, bank) and the stated reason. Over time, this data reveals competitive threats and informs the firm's value proposition and pricing strategy. A cluster of departures to a lower-cost competitor signals fee pressure; departures to a full-service wirehouse may indicate that clients want services the firm does not offer.

Generational Transfer Tracking. A growing concern for advisory firms is the risk that heirs of deceased clients move inherited assets elsewhere. Track accounts where the primary account holder is over age 75, the estimated intergenerational transfer value, whether the firm has an established relationship with the next generation, and the outcome of recent inheritance events (assets retained vs. assets departed). Firms that proactively engage the next generation retain significantly more inherited assets than those that wait until the triggering event occurs.

4. Exception and Alert Dashboards

Exception dashboards surface items that require immediate attention — anomalies, breaches, overdue tasks, and operational failures that deviate from expected norms. These dashboards are typically used by operations managers, compliance officers, and practice managers rather than individual advisors.

Compliance Alerts. Items requiring compliance attention: overdue annual reviews, stale client profiles, unsigned disclosures, advertising items awaiting review, trade pre-clearance violations, outside business activity disclosures due, gift and entertainment reporting gaps, and code of ethics certification deadlines. Each alert should display the responsible party, the deadline, days until (or past) the deadline, and the escalation status. Color coding (green/yellow/red) provides an at-a-glance severity assessment.

Operational Exceptions. Reconciliation breaks between the PMS and custodian, failed data feeds, NIGO (not in good order) account opening documents, incomplete account transfers (ACAT failures), unsigned paperwork, and pending account maintenance requests. The dashboard should display exception age (how long the item has been open) and flag items that have exceeded their service-level agreement.

Rebalancing Drift Alerts. Accounts where portfolio drift exceeds the firm's threshold but rebalancing has not been initiated. Display the client name, account, current allocation versus target, magnitude of drift, days since threshold breach, and assigned advisor. Persistent drift alerts may indicate advisor inattention or intentional deviation that requires documentation.

Billing Exceptions. Accounts with unusual billing outcomes: fees significantly higher or lower than the prior period, zero-dollar fees, negative fee calculations, accounts missing from the billing run, fee-schedule mismatches (the rate charged differs from the assigned schedule), and overdue invoice payments. Billing exception dashboards should be reviewed before every billing run approval.

Custodian NIGO Status. A centralized view of account opening and maintenance requests that have been returned as "not in good order" by the custodian. NIGO items delay account funding and create a poor client experience. The dashboard should track NIGO reason (missing signature, incorrect form version, incomplete information), age, assigned CSA, and resolution status.

Pending Tasks and Aging. A consolidated view of all open tasks across the practice — from NBA-recommended actions and CRM tasks to operational work items and compliance deadlines. Group by responsible party, sort by age, and flag items approaching or exceeding their SLA. Aging analysis (average days to resolve by task type) identifies process bottlenecks and staffing constraints.

5. Advisor Productivity Metrics

Productivity dashboards help practice managers and firm leadership understand how effectively advisors are using their time and where capacity exists for growth.

Clients Per Advisor. The number of active client households assigned to each advisor. Industry data suggests that a solo advisor can effectively manage 75-125 households depending on service model complexity and support staff. Advisors approaching their capacity limit need either additional support staff, a service model adjustment, or a planned transition of smaller clients. Advisors well below capacity represent either growth potential or an underperformance concern.

Revenue Per Advisor. Total advisory revenue generated per advisor, calculated both as the advisor's personal book revenue and as revenue per advisor adjusted for team support (dividing team revenue by the number of team members). Revenue per advisor benchmarked against current industry surveys (e.g., the Schwab RIA Benchmarking Study and major adviser compensation and staffing studies — verify the current editions, as study names and sponsors change) reveals whether the firm's advisor economics are competitive.

Meeting Volume. The number of client meetings (in-person, video, phone) conducted per advisor per period, sourced from CRM activity logs or calendar integration. Meeting volume is a leading indicator of relationship health and prospecting activity. Advisors with declining meeting counts may be disengaging from proactive client management.

Proposal-to-Close Ratio. The percentage of formal proposals or financial plans delivered that result in a signed advisory agreement and funded account. This metric, sourced from CRM pipeline data, measures advisor effectiveness at converting prospects into clients. Low ratios may indicate pricing issues, proposal quality problems, or a mismatch between the firm's value proposition and the prospect's needs.

Onboarding Pipeline. New clients in various stages of the onboarding process — from signed agreement through account opening, asset transfer, initial investment, and first review meeting. Bottlenecks in the onboarding pipeline (e.g., transfers taking 30+ days) create client dissatisfaction and delay revenue recognition. Track average onboarding time and identify the stage where delays most commonly occur.

Capacity Planning. A forward-looking view that combines curren

…

Source & license

This open-source skill is cataloged on AgentStack and links to its original source — we do not rehost the code.

• Author: JoelLewis
• Source: JoelLewis/finance_skills
• License: MIT

Install and usage instructions live in the source repository linked above.