5 Claude Prompts for Portfolio Review & Client Reporting
Ready-to-use Claude prompts for drafting quarterly review letters, performance summaries, and market commentary that save hours every review season.

Why Use AI for Client Reporting?
Quarterly review letters are the single most time-consuming recurring deliverable in financial advisory. An advisor with 80 clients writing 30-minute review letters spends 40 hours per quarter — an entire work week — on review letters alone. And most advisors feel guilty about how long it takes to get them out the door after quarter-end.
The challenge is that each letter needs to feel personal while following a consistent structure. Clients notice when their letter reads like a form letter, but writing 80 unique letters is unsustainable. Claude solves this by generating genuinely personalized letters from each client's specific data in under a minute.
These prompts are built around real portfolio review workflows. They reference performance attribution, benchmark comparisons, allocation changes, and market commentary — the specific elements every review letter needs. You still need to verify every figure against your custodian data and add your personal insights, but the structural and narrative heavy lifting is handled.
The Prompts
Prompt 1: Standard Quarterly Review Letter
Use this for your standard quarterly review letter to clients with managed portfolios.
You are a financial advisor writing a personalized quarterly portfolio review letter. Write in a warm, professional tone that builds trust and transparency. The letter should feel like it was written specifically for this client, not generated from a template.
<client-data>
- Client: Retired couple, ages 71 and 68
- Review period: Q4 2025 (October - December)
- Relationship tenure: 8 years
- Portfolio value end of quarter: $1.85M (up from $1.78M)
- Portfolio return: +3.8% for the quarter
- YTD return: +11.2%
- Benchmark (50/50 stock/bond): +2.9% for the quarter, +8.7% YTD
- Distributions taken: $18,500/quarter ($74K/year, 4.0% withdrawal rate)
- Asset allocation: 50% equities, 35% fixed income, 10% alternatives, 5% cash
- Notable holdings performance: Dividend equity fund +4.5%, municipal bond fund +1.2%, real estate fund +5.8%
- Changes made: Rebalanced equities after strong run, increased municipal bond allocation for tax efficiency
- RMD status: Both taking RMDs, amounts on track for the year
</client-data>
<instructions>
Structure:
1. Warm opening referencing the quarter and their relationship
2. Performance summary in plain language (3-4 sentences)
3. What drove results (attribution in accessible language)
4. Changes we made and why (1 paragraph)
5. Market context (2-3 sentences, not a Wall Street essay)
6. Looking ahead (forward-looking but no predictions)
7. Invitation to meet and personal sign-off
Length: 450-550 words
Do not use percentage signs more than 6 times — use phrases like "just under four percent" where natural.
</instructions>Example Output:
Dear [Clients],
>
As we close out 2025, I want to take a moment to review how your portfolio performed over the final quarter — and reflect on what has been a strong year overall.
>
Your portfolio grew to $1.85 million by year-end, adding approximately $70,000 during the fourth quarter alone. After accounting for your quarterly distributions of $18,500, your investment return was just under four percent for the quarter — outperforming the blended benchmark by nearly a full percentage point. For the full year, your portfolio delivered returns of over eleven percent while supporting $74,000 in distributions to fund your retirement lifestyle. This is exactly the kind of outcome our strategy is designed to produce.
>
The strongest contributors were your real estate allocation, which gained nearly six percent as commercial property values stabilized, and your dividend equity fund, which continued its steady performance at four and a half percent. Your municipal bond allocation provided stability and tax-efficient income, contributing a modest but important positive return.
>
During the quarter, I rebalanced your equity holdings after the strong market run to lock in gains and restore your target allocation. I also increased your municipal bond weighting slightly to improve tax efficiency — an important consideration now that you are both taking required minimum distributions. These are the kinds of adjustments that may seem small in any given quarter but compound into meaningful tax savings over time...
Prompt 2: Market Volatility Communication
For proactive client communication during market selloffs or volatile periods.
Write a client communication to send during a period of market volatility. This should be calming, informative, and demonstrate that you are actively monitoring the situation.
<market-context>
- Trigger: S&P 500 has declined 8% over the past two weeks
- Primary driver: Unexpected inflation data sparked fears of renewed rate hikes
- Bond market: 10-year Treasury yield jumped from 4.1% to 4.6%
- International markets: Also declined, though less severely (MSCI EAFE -5%)
- VIX (volatility index): Elevated at 28, up from 15 two weeks ago
- My client base: Primarily moderate-risk retirees and pre-retirees
- Our positioning: Portfolios are diversified, slightly underweight equities relative to benchmarks, overweight short-duration bonds
</market-context>
<instructions>
Structure:
1. Subject line: Calm, direct (not clickbait, not dismissive)
2. Acknowledge what happened — do not pretend the decline did not occur
3. Explain why in 3-4 sentences a non-investor understands
4. Historical context — how common are these events?
5. How your portfolios are positioned — why the current allocation makes sense
6. What you are doing (or not doing) and why
7. Invitation to talk — open door without being pushy
Length: 300-400 words
Tone: Steady, transparent, confident but not cavalier
</instructions>
<avoid>
- "Don't worry" or any dismissive language
- Predicting when the market will recover
- Technical jargon (basis points, duration, yield curve inversion)
- Anything that sounds like you wrote it before looking at their specific situation
</avoid>Example Output:
Subject: Market Update — What Happened and What We're Doing
>
You have likely noticed that markets have been choppy over the past two weeks, and I want to share some context directly rather than leaving you to sort through the noise.
>
What happened: The stock market has declined about 8% from its recent peak after new inflation data came in higher than expected. Investors are concerned that the Federal Reserve may need to keep interest rates higher for longer than anticipated, which put pressure on both stocks and bonds.
>
How common is this? More common than it feels. The stock market experiences a decline of 5-10% roughly once per year on average. Since 1950, the S&P 500 has seen 36 corrections of 10% or more — and recovered from every single one. That does not mean this one feels comfortable, but it is well within the range of normal market behavior.
>
How your portfolio is positioned: This is exactly the kind of environment our diversification strategy is designed for. Your portfolio is slightly underweight stocks relative to the market, which has cushioned the impact. Your bond allocation is concentrated in shorter-duration bonds, which are less sensitive to rising interest rates — so your fixed income has held up better than the broader bond market...
Prompt 3: Year-End Annual Performance Summary
For the comprehensive year-end review sent to all clients.
Write a year-end portfolio performance summary for a de-identified client. This is the most important piece of client reporting each year — it should be thorough, clear, and forward-looking.
<annual-data>
- Client: Business owner, age 55, single
- Portfolio value Jan 1: $920K
- Portfolio value Dec 31: $1.08M
- Total contributions: $55K (max 401k + backdoor Roth + taxable)
- Investment return: $105K (+11.4%)
- Benchmark (70/30): +10.1%
- Allocation: 65% equities, 20% fixed income, 10% alternatives, 5% cash
- Best performing: US small-cap value (+18%), international developed (+14%)
- Worst performing: Emerging markets (-2%), long-term bonds (-3%)
- Tax-loss harvesting: Realized $12K in losses to offset capital gains
- Roth conversion: Completed $35K conversion in December
- Milestones: Crossed $1M total portfolio value for the first time
</annual-data>
<instructions>
Structure:
1. Opening: Celebrate the milestone year (crossing $1M is significant)
2. Performance overview with attribution
3. Key strategic moves (tax-loss harvesting, Roth conversion)
4. What worked and what didn't (be honest about underperformers)
5. Year-ahead outlook and priorities
6. Updated progress toward retirement goal
Include a simple performance comparison table (portfolio vs. benchmark).
Length: 500-650 words
Tone: Celebratory but grounded — big milestone, but the work continues
</instructions>Example Output:
2025 Annual Portfolio Review
>
I am pleased to share your year-end portfolio review, and this year it comes with a milestone worth celebrating: your portfolio crossed the $1 million mark for the first time. Between your disciplined savings of $55,000 and investment returns of $105,000, your total portfolio grew from $920K to $1.08M — an increase of over 17%.
>
Performance Overview
>
| | Your Portfolio | Benchmark (70/30) |
|---|---|---|
| 2025 Return | +11.4% | +10.1% |
| Dollar Growth | +$105,000 | — |
| Contributions | $55,000 | — |
>
Your portfolio outperformed the benchmark by 1.3 percentage points, driven primarily by strong results in US small-cap value stocks (+18%) and international developed markets (+14%). These asset classes benefited from broadening economic growth beyond the large technology companies that dominated returns in prior years...
Prompt 4: Performance Attribution Report
For clients who want more detail on what drove returns.
Write a performance attribution summary that explains portfolio returns by asset class and investment selection. This is for a sophisticated client who wants to understand the "why" behind their numbers.
<attribution-data>
- Review period: Full year 2025
- Total portfolio return: +9.8%
- Equity sleeve (60% of portfolio): +13.2%
- US Large Cap (30%): +15.1% (benchmark S&P 500: +14.5%) — slight overperformance from value tilt
- US Small/Mid Cap (10%): +16.8% (benchmark Russell 2500: +14.2%) — strong active manager selection
- International Developed (12%): +10.5% (benchmark MSCI EAFE: +9.8%) — currency hedging helped
- Emerging Markets (8%): +2.1% (benchmark MSCI EM: +3.5%) — underperformed, China exposure drag
- Fixed Income sleeve (30% of portfolio): +4.2%
- Investment Grade Bonds (15%): +3.8% (benchmark Agg: +3.2%) — short duration positioning helped
- Municipal Bonds (10%): +4.5% — tax-equivalent yield of 6.8% at client's bracket
- High Yield (5%): +5.8% (benchmark HY Index: +6.2%) — slight underperformance, higher quality tilt
- Alternatives sleeve (10% of portfolio): +7.5%
- Real estate (5%): +8.2% — recovery in commercial property valuations
- Managed futures (5%): +6.8% — trend-following added diversification value
</attribution-data>
<instructions>
Structure:
1. Executive summary (3 sentences — what drove returns in plain language)
2. Asset class review (each sleeve with context)
3. What worked and why (top 3 contributors)
4. What underperformed and why (bottom 2, with forward-looking view)
5. Portfolio positioning commentary (how allocation decisions impacted results)
Tone: Analytical but accessible. This client is sophisticated but still wants you to explain the "so what" — not just the numbers.
Length: 400-500 words
</instructions>Prompt 5: New Client Welcome and Onboarding Summary
For documenting the initial portfolio positioning for a new client.
Write a welcome and initial portfolio positioning letter for a new client whose assets have just been transferred and invested according to the agreed-upon plan.
<new-client-data>
- Client: Married couple, ages 42 and 40, both professionals
- Assets transferred: $380K from previous advisor (mix of mutual funds and individual stocks)
- New contributions: $25K cash from savings account
- Total invested: $405K
- Investment Policy Statement summary: Growth-oriented, 15+ year horizon, high risk tolerance
- Target allocation: 80% equities (40% US, 20% international, 10% small cap, 10% emerging), 15% fixed income, 5% alternatives
- Changes from previous portfolio: Replaced high-fee mutual funds (avg 0.85% ER) with low-cost index and institutional funds (avg 0.12% ER). Sold concentrated stock position in former employer (was 22% of portfolio). Diversified across asset classes.
- Tax impact: Realized $8K in capital gains from restructuring (unavoidable due to concentration risk), offset by $3K in harvested losses from other positions
- Fee reduction: Annual cost savings of approximately $2,900 from lower expense ratios
</new-client-data>
<instructions>
Structure:
1. Welcome and confirmation that assets are invested
2. Summary of what was done and why (portfolio restructuring rationale)
3. Fee savings highlighted (this validates their decision to switch advisors)
4. Tax impact of the transition (transparent about gains realized)
5. What to expect going forward (reporting cadence, communication)
6. Next steps
Tone: Confident, welcoming, and transparent. This is their first experience with you — set the tone for the relationship.
Length: 400-500 words
</instructions>