/client-reporting-delivery

name: client-reporting-delivery
description: "Design, generate, and deliver client performance reports across all channels, covering quarterly reports, tax reporting, portal integration, and compliance review. Use when the user asks about building or redesigning report templates, choosing what to include in quarterly or annual client reports, transitioning from print to digital delivery, integrating a client portal, presenting net-of-fee performance with benchmarks, managing report production timelines, or handling e-delivery consent. Also trigger when users mention 'client reporting', 'quarterly performance report', 'report customization', 'tax lot report', '1099 supplement', 'report disclaimers', 'UHNW reporting', or 'report QA process'."

Client Reporting and Delivery

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 (e.g., Addepar) aggregate data from multiple sources and offer advanced customization, often favored by firms serving UHNW clients and family offices. (Backstop Solutions, sometimes miscategorized here, is an institutional research-management/CRM platform rather than a client reporting tool.) 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 s