Wealth Management Client Report Generator
Generate professional client-facing performance reports with portfolio returns, allocation breakdowns, and market commentary for quarterly or annual distribution.
Assembling quarterly client reports means hours of pulling data from multiple systems, formatting tables, writing market commentary, and ensuring every number ties out -- all while the deadline looms and clients expect polished, branded deliverables.
Who it's for: wealth managers, financial advisors, private bankers, family office managers
Example
"Generate a Q4 performance report for the Johnson household" → Branded 10-page PDF with household and per-account returns vs. benchmarks, allocation pie charts, holdings detail, market commentary, activity summary, and planning notes
New here? 3-minute setup guide → | Already set up? Copy the template below.
# Client Report
description: Generate professional client-facing performance reports with portfolio returns, allocation breakdowns, and market commentary. Suitable for quarterly or annual distribution. Triggers on "client report", "performance report", "quarterly report for [client]", "generate reports", or "client statement".
## Workflow
### Step 1: Report Parameters
- **Client name** and household
- **Reporting period**: Quarter, YTD, annual, custom range
- **Accounts**: All accounts or specific account
- **Benchmark**: S&P 500, 60/40 blend, custom benchmark matching IPS
- **Firm branding**: Logo, colors, disclaimers
### Step 2: Performance Summary
**Household Summary:**
| | QTD | YTD | 1-Year | 3-Year Ann. | 5-Year Ann. | ITD Ann. |
|---|-----|-----|--------|-------------|-------------|----------|
| Portfolio | | | | | | |
| Benchmark | | | | | | |
| +/- | | | | | | |
**By Account:**
| Account | Type | Value | QTD | YTD | Benchmark |
|---------|------|-------|-----|-----|-----------|
| Joint Taxable | Brokerage | | | | |
| John IRA | Traditional | | | | |
| Jane Roth | Roth IRA | | | | |
| 529 Plan | Education | | | | |
| **Total** | | | | | |
### Step 3: Allocation Overview
Current allocation with visual (pie chart or bar chart):
| Asset Class | % of Portfolio | $ Value | Benchmark % |
|------------|---------------|---------|-------------|
| | | | |
### Step 4: Holdings Detail
| Security | Asset Class | Shares | Price | Value | % of Portfolio | QTD Return |
|----------|-----------|--------|-------|-------|---------------|-----------|
| | | | | | | |
### Step 5: Market Commentary
Brief market summary tailored to the client's level of sophistication:
- What happened in markets this quarter (2-3 sentences)
- How it affected the portfolio
- Outlook and positioning rationale (2-3 sentences)
- No jargon for retail clients; can be more technical for sophisticated investors
### Step 6: Activity Summary
- Trades executed during the period
- Contributions and withdrawals
- Dividends and interest received
- Fees charged
- Rebalancing activity
### Step 7: Planning Notes
- Progress toward financial goals (retirement, education, etc.)
- Any plan changes or recommendations
- Upcoming action items
- Next review date
### Step 8: Output
- PDF report (8-12 pages) with firm branding
- Word document for customization
- Excel data appendix (optional)
**Report Structure:**
1. Cover page (client name, period, firm logo)
2. Executive summary (1 page)
3. Performance summary (1-2 pages)
4. Allocation overview with charts (1 page)
5. Holdings detail (1-2 pages)
6. Market commentary (1 page)
7. Activity summary (1 page)
8. Planning notes (1 page)
9. Disclosures and disclaimers (1 page)
## Important Notes
- Performance must be calculated net of fees unless client/compliance requires gross
- Always include appropriate disclaimers and disclosures (past performance, risk factors)
- Reports should be consistent across clients — use a standard template
- Match the level of detail to the client — some want every holding, others want a one-page summary
- Benchmark selection matters — use the benchmark from the IPS, not whatever looks best
- Review for compliance approval before first distribution of a new template
What This Does
This playbook generates professional, client-facing performance reports covering portfolio returns, asset allocation breakdowns, holdings detail, market commentary, and planning notes. It produces structured output suitable for quarterly or annual distribution to clients, with firm branding and compliance-ready disclaimers.
Important: This workflow assists with report generation but does not provide financial advice. All reports should be reviewed by qualified professionals and compliance before distribution.
Quick Start
Step 1: Create a Project Folder
mkdir -p ~/Documents/ClientReports
Step 2: Download the Template
Click Download above, then move the file into your project folder as CLAUDE.md.
mv ~/Downloads/wm-client-report.md ~/Documents/ClientReports/CLAUDE.md
Step 3: Start Working
cd ~/Documents/ClientReports
claude
Try these prompts:
"Generate a Q4 performance report for the Smith household"
"Create an annual client statement for John and Jane Doe"
"Build a quarterly report comparing portfolio returns to the 60/40 benchmark"
Report Structure
The generated report follows a professional 8-12 page structure:
- Cover page -- Client name, reporting period, firm logo
- Executive summary -- 1-page high-level overview
- Performance summary -- Household and per-account returns vs. benchmarks (QTD, YTD, 1-Year, 3-Year, 5-Year, ITD)
- Allocation overview -- Current allocation with visual charts and benchmark comparison
- Holdings detail -- Individual security positions with returns
- Market commentary -- Tailored to client sophistication level
- Activity summary -- Trades, contributions, withdrawals, dividends, fees
- Planning notes -- Goal progress, recommendations, next review date
- Disclosures and disclaimers
Best Practices
- Performance calculation: Always calculate net of fees unless client or compliance specifically requires gross
- Benchmark selection: Use the benchmark from the Investment Policy Statement (IPS), not whichever benchmark looks most favorable
- Client-appropriate detail: Some clients want every holding listed; others prefer a one-page summary. Match the level of detail to the client
- Consistency: Reports should be consistent across clients -- use a standard template so nothing gets missed
- Compliance: Review for compliance approval before first distribution of any new template format
Example Prompts
"Generate a quarterly performance report for the Anderson household benchmarked to the S&P 500"
"Create a year-end client statement including tax lot detail for the taxable account"
"Build a one-page executive summary report for our annual review meeting"
"Draft market commentary for Q1 suitable for a retail client audience"