joellewis/client-reporting-delivery
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'.
npx skills add https://github.com/JoelLewis/finance_skills --skill client-reporting-delivery
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:
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.
A well-designed quarterly performance report follows a logical structure that guides the client from high-level summary to supporting detail:
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 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: For TWR vs. MWR definitions and calculation, see the wealth-management performance-metrics and performance-reporting skills. In client reports: TWR is the standard for strategy evaluation; MWR answers "how did my money do?" and is increasingly presented alongside TWR. Presenting both can be powerful when accompanied by a brief explanation of the difference — when the two diverge significantly, it signals that cash flow timing had a material impact and opens a productive conversation.
Return periods:
Standard periods displayed in quarterly reports include MTD (month-to-date), QTD (quarter-to-date), YTD (year-to-date), trailing 1-year, trailing 3-year, trailing 5-year, trailing 10-year, and since-inception. Annualization conventions are critical: returns for periods exceeding one year should be annualized (geometric annualization), while returns for periods of one year or less should be presented as cumulative (non-annualized). Mixing conventions without clear labeling is a common source of confusion and potential compliance issues.
Benchmark selection and display:
Every portfolio should have a clearly defined benchmark. The primary benchmark should reflect the portfolio's strategic asset allocation and investment universe. For diversified portfolios, a blended benchmark (e.g., 60% MSCI ACWI / 40% Bloomberg US Aggregate) is more appropriate than a single index. Reports should include the benchmark description, component indices and weights, and a note that the benchmark is not investable and does not reflect fees. Some firms also display peer group comparisons or risk-adjusted metrics (Sharpe ratio, Sortino ratio) for sophisticated clients.
Net-of-fee vs gross-of-fee returns:
Net-of-fee returns are the preferred presentation for client reports because they represent the client's actual experience after paying advisory fees. Gross-of-fee returns may be shown alongside net for transparency or for GIPS-compliant presentations. The fee impact over long periods is substantial and should not be obscured.
GIPS compliance considerations:
Firms that claim compliance with the Global Investment Performance Standards must adhere to specific presentation requirements in composite reports, including required disclosures, composite construction rules, and prescribed return calculation methodologies. Individual client reports are not composites, but firms claiming GIPS compliance should ensure client-level reporting does not contradict or undermine their composite presentations.
Performance disclaimers:
Every report displaying performance data must include disclaimers stating that past performance is not indicative of future results, describing the benchmark and its limitations, disclosing whether returns are net or gross of fees, and noting any material factors affecting comparability across periods (e.g., strategy change, benchmark change).
Report customization operates at multiple levels, from firm-wide template design to individual client preferences.
Level of detail: Some clients want a two-page summary; others want 30 pages of detail. The reporting system should support configurable section inclusion, allowing advisors to toggle sections on or off per client. Common toggleable sections include holdings detail, transaction detail, individual account breakdowns, and performance attribution.
Grouping and organization: Reports can organize portfolio data in several ways depending on client preference and portfolio structure:
Household vs account-level reporting: Most clients prefer a consolidated household view as the primary presentation, with account-level detail as a secondary section. The household view enables total portfolio allocation, consolidated performance, and a single net worth perspective. Account-level detail remains important for tax planning, beneficiary considerations, and account-specific objectives.
Custom benchmarks: Clients with unique portfolio constraints (ESG exclusions, concentrated stock positions, alternative allocations) may require custom benchmarks that reflect their investable universe. The reporting system should support advisor-defined blended benchmarks with custom weights and component indices, updated as the target allocation evolves.
Personalized commentary: The highest-value customization is advisor-written commentary specific to the client's situation. This might address recent portfolio changes, progress toward financial plan goals, upcoming planning actions, or responses to client questions. Some firms provide a firm-level market commentary as a default with an editable field for advisor personalization. Advisors who consistently add personalized commentary report stronger client engagement and retention.
White-labeling: Multi-advisor firms, RIA aggregators, and sub-advisory relationships often require white-labeled reports carrying the presenting firm's branding rather than the platform or TAMP provider's branding. The reporting system should support configurable logos, firm names, disclosures, and contact information.
Language and terminology: Reports should use language appropriate to the client's financial sophistication. A retired schoolteacher needs different terminology than a former CFO. Avoid unnecessary jargon where plain language suffices, but do not oversimplify for sophisticated clients who expect precision.
Report delivery has evolved from exclusively print-and-mail to a multi-channel environment. Firms must manage several delivery methods simultaneously.
Client portal (primary digital channel):
The client portal is the hub of digital delivery. Reports are published to the portal where clients can view them online, download as PDF, and access historical reports in an archive. Portal-based delivery offers several advantages: immediate availability (no mail delay), persistent access (clients can revisit reports anytime), reduced cost (no printing or postage), environmental sustainability, and integration with other portal features (real-time portfolio view, document vault, secure messaging). The portal should provide notification (email or push) when new reports are available.
Email delivery:
Email delivery remains common, typically as an encrypted PDF attachment or a link to the client portal. Email is familiar and requires no portal login, making it accessible for less tech-savvy clients. However, email delivery raises security concerns (sensitive financial data in transit or in inboxes), so best practices include PDF encryption with a client-specific password, secure email platforms, or portal links rather than attachments. Firms should document email delivery preferences and security measures.
Print and mail:
Physical printed reports delivered via postal mail are declining but not extinct. Some clients, particularly older individuals or those in jurisdictions with specific requirements, prefer or require printed reports. Print delivery involves additional cost (printing, paper, postage), longer delivery time (days vs instant), and environmental impact. Firms transitioning to digital-first delivery should maintain a print capability for clients who opt in and for any regulatory requirements that mandate physical delivery.
In-person review:
Many advisors present reports during client meetings rather than simply delivering them. The meeting context allows the advisor to walk through results, provide context, answer questions in real time, and connect performance to financial plan progress. In-person presentation may use the same PDF report, a slide-deck derivative, or an interactive portal screen share. The report serves as both a leave-behind document and a meeting framework.
Multi-channel strategy:
The recommended approach is digital-first with print opt-in. Default delivery is portal publication with email notification. Clients who prefer print explicitly opt in and receive mailed copies in addition to (not instead of) digital access. This ensures every client has portal access to current and historical reports while accommodating print preferences.
E-delivery consent:
SEC rules on electronic delivery (primarily from SEC guidance releases and interpretive letters) require that firms provide notice that documents are available electronically, ensure the client has access to the electronic format, and obtain evidence of delivery (or evidence of notice with access). Firms should document client consent to electronic delivery, provide clear instructions for portal access, and maintain systems that confirm report availability and client access. Under FINRA rules, broker-dealers have additional requirements for implied consent and opt-out rights.
Delivery confirmation and tracking:
Firms should track report delivery status: portal published, email sent, email opened (if tracked), portal accessed, print mailed, print delivered (via tracking number if warranted). Delivery tracking supports compliance (evidence of delivery), operations (identifying delivery failures), and client service (confirming clients received their reports).
The quarterly reporting cycle is a firm's most operationally intensive recurring process, typically spanning T+5 to T+15 after quarter-end (5 to 15 business days after the quarter closes).
Workflow stages:
Handling exceptions:
Timeline management:
The reporting cycle compresses many dependencies into a tight window. Bottleneck identification is essential: late custodian data, slow reconciliation, advisor commentary delays, and compliance review capacity are the most common constraints. Firms should establish clear deadlines for each stage with escalation procedures when deadlines slip.
The client portal has become central to the reporting strategy, serving as both a delivery channel and an interactive extension of the static report.
Report access models:
The most effective portal strategy combines all three: periodic batch reports for the formal record, on-demand capability for ad-hoc needs, and interactive dashboards for day-to-day engagement.
Portal features that complement reports:
Driving portal adoption:
Many firms struggle with portal adoption rates, which typically range from 40% to 70% of clients actively using the portal. Strategies to improve adoption include making the portal the default delivery channel, demonstrating the portal during client meetings, simplifying the registration process (single sign-on, mobile-friendly), providing portal training materials, and emphasizing features beyond report access (document vault, secure messaging, goal tracking). Younger clients and those with larger portfolios tend to have higher adoption rates.
Portal vendors:
Leading platforms include Orion Connect (integrated with Orion PMS, strong reporting and planning integration), Black Diamond Client Experience (known for visual report quality and client experience), Tamarac Reporting (integrated with Envestnet ecosystem), Addepar Client Portal (favored by UHNW and family office firms for advanced analytics), and custom-built portals (used by larger firms wanting full control over the client experience). Selection criteria include integration with the firm's PMS, report customization capability, mobile experience, security features, and total cost of ownership.
Tax reporting is a distinct reporting function with its own timeline, data requirements, and audience (the client's CPA or tax preparer in addition to the client).
Tax-related reports:
Year-end deliverables beyond tax reports:
Timing and coordination:
Tax reporting follows a distinct timeline from performance reporting. Preliminary tax reports are typically available in January, based on the best available data. However, custodians issue corrected 1099s through February and sometimes into March (particularly for accounts holding partnerships, REITs, or international securities). Final tax reports should be issued only after the custodian's 1099 correction period closes. Firms should communicate the timeline clearly to clients and their CPAs to avoid filing with preliminary data that later changes.
Coordination with client CPAs is a value-added service. Proactive firms send tax reports directly to the client's CPA (with client authorization), provide a cover letter explaining the reports and any notable items, and make themselves available to answer CPA questions during tax season. This reduces friction for the client and positions the advisor as a hub of the client's financial team.
Client reports are communications to clients and therefore subject to regulatory scrutiny. Compliance requirements vary based on the firm's registration type (RIA, broker-dealer, dual registrant) and how the reports are used.
Regulatory framework:
Required disclaimers:
Supervisory review:
Firms must establish supervisory procedures for client report review. The scope of supervisory review typically includes verifying performance accuracy (sampling), confirming disclaimers are present and current, reviewing advisor-written commentary for compliance (no guarantees, no promissory language, fair and balanced), and checking that reports are consistent with the client's actual account and investment strategy. Compliance should document the review process, the reviewer, the date, and any issues identified and resolved.
Record retention:
Under the SEC's books-and-records rules (Rule 204-2 for RIAs, Rule 17a-4 for broker-dealers), firms must retain copies of all communications delivered to clients, including client reports. Retention periods are typically five years (RIAs) or six years (broker-dealers) from the date of delivery. The retained copy must be the exact version delivered to the client. Digital archiving of PDFs published to portals satisfies this requirement when properly indexed and backed up.
GIPS requirements:
Firms claiming GIPS compliance must present composite-level performance in GIPS-compliant reports to prospective clients. Individual client reports are not composites, but the firm should ensure that client-level performance data does not contradict composite presentations and that GIPS-required disclosures appear on any report used to market the firm's investment capabilities.
Quality assurance is the safeguard between report generation and client delivery. Errors in client reports damage credibility, create compliance risk, and generate costly re-issuance work.
Automated validation checks:
Visual and manual inspection:
Common errors and root causes:
Error tracking and resolution:
Firms should maintain an error log tracking each identified issue: date discovered, report affected, error type, root cause, resolution, and corrective action to prevent recurrence. Error rate metrics (errors per 1,000 reports generated) should be tracked over time and reported to management. A rising error rate signals a systemic issue (data quality, template instability, staffing) requiring intervention.
Client-reported errors:
When a client identifies an error, the resolution workflow includes acknowledgment (prompt response to the client), investigation (verify the error and identify the cause), correction (generate a corrected report), re-issuance (deliver the corrected report with a brief explanation), and root cause analysis (determine whether the error is isolated or systemic). The tone of client communication should be transparent and professional, treating the error seriously while reassuring the client that their actual account and investments are unaffected if the error is limited to the report.
See references/examples.md for three end-to-end worked examples — redesigning a quarterly reporting package with tiered templates, transitioning from print to digital-first delivery, and remediating performance calculation errors in delivered reports. Load it when the user needs a full scenario walkthrough.
Take joellewis/client-reporting-delivery from the repository into ~/.claude/skills for personal
use, or into .claude/skills inside a project.
The agent identifies a skill by the name field in its header. Two skills with the
same name cannot sit side by side — one of them will be ignored.