client-reporting-delivery

What this skill does

# Client Reporting and Delivery

## Purpose

Enable Claude to assist advisory firms with designing, generating, customizing, and delivering client reports across all channels. This skill covers the full reporting lifecycle from data sourcing through delivery confirmation, including quarterly performance reports, tax reporting, client portal integration, compliance review, and quality assurance. It provides guidance on report content structure, personalization by client segment, delivery channel strategy, and the operational workflows that ensure timely, accurate, and compliant report production.

## Layer

10 — Advisory Practice (Front Office)

## Direction

Retrospective

## When to Use

- An advisor or operations team asks about designing or redesigning client report templates
- Questions arise about what sections to include in quarterly or annual client reports
- A firm needs guidance on transitioning from printed to digital report delivery
- Someone asks about client portal integration for reporting
- Questions about performance presentation in client reports (return periods, benchmarks, net vs gross)
- A firm needs to build or improve its report generation workflow and production timeline
- Tax reporting questions: realized gains/losses reports, 1099 supplements, coordination with CPAs
- Compliance review of client reports: required disclaimers, supervisory review, record retention
- Quality assurance processes for report accuracy and error remediation
- Client segmentation for report customization (mass affluent vs HNW vs UHNW)
- E-delivery consent and electronic delivery compliance questions
- Report frequency management: quarterly, annual, ad-hoc, on-demand

## Core Concepts

### Client Reporting Architecture

The reporting pipeline in an advisory firm flows from data sources through a generation engine to client delivery. The primary data sources are the portfolio management system (PMS), custodian data feeds, financial planning tools, and the billing system. Each source contributes distinct data elements: the PMS provides portfolio holdings, performance calculations, and asset allocation; the custodian provides official transaction records, settled positions, and tax lot data; the financial planning tool provides goal progress and projection data; and the billing system provides fee calculations and payment history.

Report types span the full advisory relationship:

- **Quarterly performance reports** — The cornerstone deliverable. Summarizes portfolio performance, allocation, holdings, and transactions for the quarter with trailing period returns.
- **Annual reviews** — Comprehensive year-in-review combining performance, planning progress, and forward outlook. Often presented in person.
- **Financial plan updates** — Progress toward goals, updated projections, and recommended adjustments. May be quarterly or semi-annual.
- **Tax reports** — Realized gains and losses, unrealized gains and losses, cost basis reports, 1099 supplements, wash sale reports, and tax-loss harvesting summaries.
- **Billing summaries** — Detailed fee calculations showing AUM tiers, fee rates, amounts debited, and billing period.
- **Custom and ad-hoc reports** — Client-requested reports outside the standard cycle, such as a holdings detail for a mortgage application or a performance report for a specific date range.

Reporting platforms fall into several categories. PMS-embedded reporting tools (Orion Portfolio Solutions, Black Diamond, Tamarac Reporting) generate reports directly from the portfolio management database, ensuring data consistency. Standalone reporting platforms (Addepar, Backstop Solutions) aggregate data from multiple sources and offer advanced customization, often favored by firms serving UHNW clients and family offices. Client portal integration layers the reporting function into a broader digital client experience.

Custodian statements and advisor-produced reports serve complementary but distinct purposes. Custodian statements are the official record of account activity and positions, produced by the custodian (Schwab, Fidelity, Pershing). Advisor-produced reports add value through consolidated household views, custom benchmarks, goal-based framing, blended performance across custodians, and advisor commentary. Clients receive both, and firms should help clients understand the relationship between the two, particularly when minor data differences arise from timing or methodology.

### Report Content and Structure

A well-designed quarterly performance report follows a logical structure that guides the client from high-level summary to supporting detail:

1. **Cover page** — Firm branding, client or household name, reporting period, key headline metrics (total portfolio value, period return, net change in value). The cover page sets the tone and provides the most critical data points at a glance.

2. **Executive summary and market commentary** — A brief narrative (typically one page) covering market conditions during the period, key events that affected portfolios, and a forward-looking perspective. This section can be firm-level (same for all clients) or personalized by the advisor.

3. **Portfolio summary** — Asset allocation (current vs target, shown as pie chart or bar chart and table), total holdings count, cash position, and net deposits/withdrawals during the period. Household-level view aggregating all accounts.

4. **Performance summary** — Period returns (MTD, QTD, YTD, 1-year, 3-year, 5-year, 10-year, since inception) with benchmark comparison. Displayed as both table and chart. Net-of-fee returns as the primary presentation with gross-of-fee available.

5. **Account detail** — Individual account summaries within the household, each showing account type, custodian, value, allocation, and performance. Important for clients with multiple accounts across different registration types.

6. **Holdings detail** — Complete listing of positions by account or by asset class, showing security name, ticker, shares/units, market value, percentage of portfolio, unrealized gain/loss, and yield.

7. **Transaction summary** — Purchases, sales, income received, contributions, withdrawals, and fee debits during the period. Level of detail varies by client preference.

8. **Fee summary** — Advisory fees charged during the period, showing calculation methodology (AUM, billing rate, proration if applicable). Increasingly important given regulatory emphasis on fee transparency.

9. **Disclosures and disclaimers** — Required legal language including past performance disclaimers, benchmark descriptions, fee impact disclosure, and firm registration information.

Content customization by client segment is essential. Mass affluent clients typically prefer simplified reports emphasizing total value, return, and allocation with minimal holdings detail. High-net-worth (HNW) clients generally want comprehensive reports including full holdings, transaction detail, and benchmark comparisons. Ultra-high-net-worth (UHNW) and family office clients often require institutional-grade reporting with performance attribution, alternative investment detail, multi-entity consolidation, and custom analytics. The challenge is balancing comprehensiveness with readability — a 40-page report that goes unread serves no one.

### Performance Presentation in Reports

Performance is the most scrutinized section of any client report. Presenting returns accurately and clearly requires attention to methodology, time periods, benchmarks, and context.

**Return methodologies:**

- **Time-weighted return (TWR)** measures the compound rate of growth independent of external cash flows. TWR is the standard for evaluating manager or strategy performance because it removes the effect of the client's deposit and withdrawal timing. Most PMS platforms calculate daily-valued TWR using the Modified Dietz method for sub-period returns.
- **Money-weighted return (MWR/IRR)** reflects the client's actual