Client segmentation in wealth management for service planning

Client segmentation in wealth management groups relationships by service needs and economics so an advisory firm can plan coverage. Start with assets, earned fees and recorded service hours for the same relationships and period. The result should explain where work sits and which service commitments need review.

An asset tier alone cannot do that. A large relationship may have straightforward requirements, while a smaller one needs substantial coordination. Keep the service classification visible beside the economic measures rather than turning either into a judgment about the client.

Define the relationship and the planning question

Use a relationship ID that joins the accounts belonging to the same service agreement. Decide whether a family group, trust or business relationship is the unit before adding any assets. Otherwise, an account split can look like an increase in the number of clients.

Write the question above the worksheet: which relationships require specialist involvement, and how much recorded work does each group consume? A reviewed service-needs field answers the first part. Activity records answer the second. Neither field determines investment selection or suitability.

Keep the measures separate. Assets are a balance at the reporting date. Fees and service hours are flows across the reporting period. Do not add monthly asset snapshots together. If the next question concerns profitability, use the separate fee margin by client method rather than calling fees per hour a margin.

Assemble the exports before assigning segments

Prepare three source views: closing assets by account, earned advisory fees by billing line, and completed service activity with recorded hours. Add the relationship ID to each view and aggregate each one independently before combining them. Joining individual billing lines directly to individual activity rows can multiply both amounts.

For this example, a fictional US advisory firm reviews the quarter ended September 30, 2026. All amounts are USD, and assets are the closing balance on that date. Each relationship has one approved service-needs label. Hours include all recorded work within the agreed service scope.

In the relationship worksheet, columns A through E contain the source measures below. Put fees per recorded hour in F and the segment in G.

Compute F2 and G2, then fill down:

=IF(E2=0,"",D2/E2)
=IF(B2="Complex planning","Specialist",IF(B2="Routine service","Core","Review"))

The labels are this firm's service categories, not universal tiers. An unrecognized or blank service need goes to Review. A relationship owner must resolve it before the segment is used for staffing.

Calculate the segment view

Put Specialist and Core in J2:J3. These Google Sheets formulas return relationship count, assets, fees and hours for the segment named in J2:

=COUNTIF($G$2:$G$5,J2)
=SUMIFS($C$2:$C$5,$G$2:$G$5,J2)
=SUMIFS($D$2:$D$5,$G$2:$G$5,J2)
=SUMIFS($E$2:$E$5,$G$2:$G$5,J2)

COUNTIF counts matching cells; it counts relationships here because each appears once. SUMIFS sums a range using specified criteria, so the same segment label selects the assets, fees and hours. Covirage is not affiliated with Google.

Divide each segment's fees by its hours. Divide segment fees by total fees for fee share, and segment hours by total hours for hour share. Display rates to two decimal places and shares to one; retain full precision in calculations.

Prove the totals, then use the result

The segment totals must reproduce the relationship worksheet: $26,000,000 of assets, $68,000 of fees and 130 recorded hours. Those totals must also tie to the respective asset, billing and activity exports after documented exclusions. Reconcile each measure separately because matching assets does not prove that hours are complete.

The Specialist group earns $50,000 against 80 recorded hours, or $625.00 per hour. Core earns $18,000 against 50 hours, or $360.00. That difference directs a review; it does not establish that Core receives too much service.

Look within the group before changing coverage. Cedar and Dune share the same label, but Dune records more hours against fewer fees. The relationship owner should check whether onboarding, missing activity records elsewhere or a lasting service requirement explains the difference. Operations then compares expected work with available capacity, and the service lead approves any change to commitments.

Use a wealth management dashboard to present the agreed measures over time. Keep estimates of assets outside the firm in a separate held-away assets review, rather than adding them to managed assets.

Where it goes wrong

• Accounts counted as relationships. Multiple accounts inflate client counts unless the relationship mapping is applied first.
• Cash collected called earned fees. Billing timing can distort a period comparison. State the fee basis and keep it consistent.
• Missing hours treated as no work. A blank activity record is a completeness question, not proof of low service demand.
• Temporary work becomes a permanent label. Review onboarding and exceptional events before changing the service category.
• Fees per hour called profit. The ratio omits the costs required to calculate contribution or margin.

Plan coverage from your own relationship files

Bring a sample of your own asset, fee and service-activity exports to Covirage; it maps the columns, and its tools compute and check relationship and segment totals. The external AI model explains the results with every figure traced to its rows. Create a free Covirage account, which takes about a minute, then set up your business and bring your file.

See Covirage for wealth managers for the supporting client-coverage context.