AI Prompts for Financial Advisors: Portfolio, Retirement, Estate Planning

Published: July 2026 | 8 min read

Financial advisors handle complex client situations that require synthesizing market data, tax rules, life events, and risk tolerance into actionable recommendations. AI prompts can accelerate the document-heavy parts — client meeting prep, portfolio review narratives, financial plan drafts, and regulatory documentation — freeing you to focus on strategy and relationships.

The key is structured prompts that produce advisor-ready output: client-facing language that's compliant, specific, and actionable. Below are production-ready AI prompts for financial advisors. These are adapted from Skillent's Finance AI Prompt Library.

Want 190,000+ professional AI prompts?

Get Skillent Pro — $9/month

Client Meeting Preparation

1. Client Meeting Prep Brief

Role: You are a financial advisor preparing for a quarterly client review.
Client: [age], [occupation], [retirement target age], [risk tolerance], [key concerns]
Portfolio: [current allocation summary — equity %, fixed income %, cash %, alternatives %]
Recent life events: [list any changes — job change, inheritance, home purchase, divorce, health event]
Task: Create a meeting prep brief.
Include:
1. Portfolio performance summary (vs benchmarks, narrative format)
2. Asset allocation drift assessment (current vs target)
3. Rebalancing recommendations with tax-efficient execution plan
4. Progress toward retirement goal (funded status, savings rate needed)
5. Tax planning opportunities (harvesting, Roth conversion, charitable)
6. Insurance coverage gaps to raise
7. Talking points for client concerns
8. Action items with deadlines
Format: 1-page brief, bullet-heavy, scannable during the meeting.
Tone: Professional but conversational — this is for your internal use.

2. Client Email: Quarterly Review Summary

Role: Financial advisor writing to a client.
Task: Draft a quarterly review email summarizing portfolio performance and next steps.
Client: [name]
Period: Q[1-4] [year]
Include:
- Portfolio return for the quarter (vs benchmark)
- YTD performance
- Key drivers (positive and negative)
- Allocation changes made or recommended
- Looking ahead: market outlook and strategy adjustments
- Meeting scheduling link
Tone: Warm, professional, jargon-free — client is [sophisticated/layperson]
Length: 300 words maximum.
Do NOT: Include specific dollar amounts in email (refer to portal).

3. New Client Discovery Questionnaire

Role: Financial advisor onboarding a new client.
Task: Generate a comprehensive discovery questionnaire.
Categories:
1. Personal & Family (age, spouse, dependents, health considerations)
2. Financial Goals (short/medium/long-term, prioritized)
3. Current Financial Situation (assets, liabilities, income, expenses)
4. Risk Profile (tolerance, capacity, willingness to accept volatility)
5. Investment Experience (asset classes owned, past losses, behavioral reactions)
6. Tax Situation (bracket, state, loss carryforwards, NOLs)
7. Estate Planning (wills, trusts, beneficiaries, powers of attorney)
8. Insurance (life, disability, LTC, liability, property)
9. Employer Benefits (401k match, ESPP, RSUs, deferred comp, HSA)
10. Values & Preferences (ESG, faith-based, restrictions, legacy goals)
Format: Numbered questionnaire with space for advisor notes.
Include: Red flags to watch for in client responses.

Portfolio Analysis & Recommendations

4. Portfolio Review Narrative

Role: Financial advisor writing a portfolio review narrative for a client.
Task: Translate the following portfolio data into a client-friendly narrative.
Input: [Asset class | Current value | Target % | Current % | Qtr return | YTD return]
Structure:
1. Executive summary (2-3 sentences)
2. Performance review (what worked, what didn't, vs benchmarks)
3. Allocation assessment (current vs target, drift explanation)
4. Rebalancing plan (what to buy/sell, tax considerations)
5. Forward-looking commentary (market themes, positioning rationale)
Tone: Professional, accessible, no jargon without explanation.
Length: 500-700 words.
Include: Disclosure language placeholder at the end.

5. Asset Allocation Recommendation

Role: Financial advisor recommending an asset allocation.
Client: [age], [retirement age], [risk tolerance], [income needs in retirement], [current assets]
Constraints: [taxable vs tax-advantaged accounts], [ESG preferences?], [liquidity needs]
Task: Recommend a strategic asset allocation.
Include:
1. Target allocation (stocks/bonds/cash/alternatives with sub-asset class breakdown)
2. Rationale for each allocation choice (risk/return/correlation/diversification)
3. Expected portfolio return and volatility (range)
4. Maximum drawdown estimate
5. Tax-efficient location strategy (which assets in taxable vs tax-advantaged)
6. Rebalancing frequency recommendation
7. Glide path if approaching retirement
Format: Recommendation memo with allocation table and narrative.
Reference: Modern Portfolio Theory, but explain in client-friendly terms.

6. Tax-Loss Harvesting Opportunity Scan

Role: Financial advisor performing a tax-loss harvesting review.
Client: [tax bracket], [harvesting goal: offset $X in gains]
Current holdings: [List: security, cost basis, current value, unrealized gain/loss]
Task: Identify tax-loss harvesting opportunities.
For each candidate:
1. Security to sell
2. Unrealized loss amount
3. Tax savings estimate (federal + state)
4. Wash sale risk (identify substantially identical securities to avoid for 30 days)
5. Replacement security recommendation (maintain allocation, avoid wash sale)
6. Holding period impact (short vs long-term)
Format: Harvesting opportunity table sorted by tax savings.
Include: Wash sale rules reminder and documentation requirements.
Flag: Any positions where harvesting would trigger short-term loss vs long-term.

Retirement Planning

7. Retirement Readiness Assessment

Role: Financial advisor assessing a client's retirement readiness.
Client: [age], [target retirement age], [current portfolio value], [annual savings], [expected Social Security at 67], [pension if any], [desired retirement spending]
Task: Create a retirement readiness assessment.
Include:
1. Current funded status (% of goal achieved)
2. Projection at retirement age (Monte Carlo placeholder — show deterministic + 2-3 scenarios)
3. Safe withdrawal rate analysis (4% rule, guardrails approach)
4. Social Security claiming strategy (break-even analysis for claiming at 62/67/70)
5. Healthcare cost planning (Medicare premiums, gap years, LTC)
6. Sequence of returns risk assessment
7. Recommended savings rate to close any gap
8. What-if scenarios (retire 2 years earlier/later, part-time work, downsizing)
Format: Assessment report, 2 pages.
Tone: Objective, data-driven, but accessible to client.

8. Social Security Optimization Memo

Role: Financial advisor optimizing Social Security claiming strategy.
Client: [birth year], [earnings record summary], [marital status], [spouse birth year/earnings if applicable]
Task: Analyze optimal claiming strategy.
Compare:
1. Claim at 62 (reduced benefits)
2. Claim at full retirement age (FRA)
3. Claim at 70 (delayed credits)
4. Spousal benefits optimization (if married)
5. Survivor benefit implications
For each option: Monthly benefit, cumulative benefits at ages 80/85/90, break-even age
Recommend: Optimal strategy with rationale
Include: Tax implications (provisional income, 50/85% taxation threshold)
Format: Claiming strategy memo with comparison table and recommendation.

Estate & Insurance Planning

9. Estate Planning Checklist for Client

Role: Financial advisor preparing an estate planning checklist for a client.
Client: [marital status], [dependents], [net worth range], [state of residence]
Task: Generate a comprehensive estate planning checklist.
Categories:
1. Documents (will, trust, POA, healthcare directive, HIPAA authorization)
2. Beneficiary designations (retirement accounts, life insurance, transfer-on-death)
3. Asset titling (joint tenancy, community property, trust ownership)
4. Trust funding status (are assets actually titled to the trust?)
5. Gifting strategy (annual exclusion, lifetime exemption, 529 superfunding)
6. Life insurance coverage analysis (income replacement, debt, education, estate liquidity)
7. Long-term care planning (self-insure vs LTC insurance vs hybrid)
8. Digital asset access plan
9. Letter of intent / ethical will
Format: Checklist with client action items and advisor follow-up notes.
Include: Red flags — things that would trigger an attorney referral.

10. Insurance Gap Analysis

Role: Financial advisor analyzing insurance coverage.
Client: [age], [income], [dependents], [debt], [current policies summary]
Task: Perform insurance gap analysis.
For each insurance type:
1. Life insurance — coverage needed (DIME: debt, income replacement, mortgage, education) vs current
2. Disability — income replacement needed vs current coverage
3. Long-term care — projected cost vs funding source
4. Umbrella liability — net worth protection needed
5. Property/casualty — coverage limits review
6. Health — HDHP/HSA eligibility and optimization
For each gap: Risk if unfilled, recommended coverage amount, estimated cost, priority
Format: Gap analysis table with recommendations.
Tone: Advisory, not alarmist — frame as protection planning.

Regulatory & Compliance Documentation

11. Investment Policy Statement Draft

Role: Financial advisor drafting an Investment Policy Statement (IPS).
Client: [name/entity], [individual or trust or retirement plan]
Task: Draft a comprehensive IPS.
Sections:
1. Purpose and scope
2. Investment objectives (return, risk tolerance, time horizon)
3. Asset class guidelines (permitted, excluded, target ranges)
4. Rebalancing policy (trigger, frequency, method)
5. Performance monitoring (benchmarks, review frequency)
6. Duties and responsibilities (advisor, custodian, client)
7. Restrictions and constraints (ESG, liquidity, tax considerations)
8. Review and amendment procedures
9. Appendix: Strategic asset allocation target
Format: Formal IPS document, 4-6 pages.
Reference: CFA Institute IPS best practices and applicable regulatory framework (ERISA if retirement plan).

12. Form ADV Brochure Narrative Generator

Role: Compliance officer for an RIA preparing Form ADV Part 2A narrative.
Firm: [name], [AUM range], [number of clients], [fee structure], [services offered]
Task: Draft narrative sections for Form ADV Part 2A.
Cover:
1. Types of clients (Item 4)
2. Advisory services offered (Item 4)
3. Fee schedule description (Item 5)
4. Conflicts of interest disclosure (Item 10)
5. Disciplinary history framing (Item 11)
6. Performance-based fees disclosure (Item 12)
7. Custody disclosure (Item 15)
8. Voting securities policy (Item 17)
Format: SEC-compliant narrative language for each item.
Tone: Plain English per SEC requirements — no legalese.
Note: Final document must be reviewed by compliance counsel before filing.

Best Practices for Advisor AI Prompts

1. Never input actual account numbers or SSNs — use placeholders and replace post-generation

2. Always include risk tolerance and time horizon — these fundamentally change the recommendations

3. Add regulatory context — specify if the client is under SEC, state regulator, or ERISA jurisdiction

4. Specify the fiduciary standard — if acting under fiduciary duty, include that in the prompt for compliant language

5. Review all output for prohibited guarantees — AI may suggest guaranteed returns. Advisors cannot guarantee performance. Remove any such language before sending to clients.

For more finance prompts, see our AI prompts for CPAs during tax season and AI prompts for cash flow analysis.

How to Use These Prompts Effectively

Getting the most out of AI prompts for financial work requires a structured approach. Here's how to integrate these prompts into your workflow:

1. Start with Clean Data

Before running any prompt, ensure your source data is organized and accurate. AI output is only as good as the input. Gather your trial balances, general ledger exports, prior-period statements, and any supporting documentation. The more structured your input data, the more useful the AI output will be.

2. Iterate and Refine

Don't expect perfect output on the first run. Start with the prompt as written, review the output, then refine. Add context about your specific industry, company size, accounting software, or reporting requirements. The prompts above are templates — adapt them to your exact situation.

3. Always Verify Against Source Documents

AI can make calculation errors, cite outdated tax rates, or miss nuances in your chart of accounts. Every piece of output that contains a number, a tax rate, a deadline, or a regulatory citation must be verified against primary sources. This is not optional — it's a professional responsibility.

4. Build a Prompt Library for Your Organization

Save the prompts that work best for your team. Document what you changed, what input data you provided, and what output format worked best. Over time, you'll develop a customized prompt library that reflects your organization's specific accounting practices, reporting requirements, and industry context.

5. Use AI for Drafts, Not Final Products

The most effective pattern is to use AI prompts to generate first drafts — whether that's a budget model, a variance commentary, a reconciliation summary, or a tax memo. Then apply your professional judgment to review, correct, and finalize. AI accelerates the draft phase; it doesn't replace the review phase.

Why These Prompts Matter for Finance Teams

Finance and accounting teams are under increasing pressure to do more with less. Month-end close cycles are compressing. Reporting requirements are expanding. Audit expectations are rising. And the demand for real-time financial insight — not just historical reporting — is growing across every organization.

AI prompts like these address that pressure by automating the repetitive, pattern-based work that consumes hours of professional time each week. A variance analysis that used to take three hours can be drafted in twenty minutes. A budget model that used to start from a blank spreadsheet can begin with a structured framework. A reconciliation narrative that used to be written line by line can be generated from structured input.

The goal isn't to replace financial professionals — it's to free them from mechanical work so they can focus on analysis, strategy, and advisory roles. The most successful finance teams using AI are the ones that treat it as a junior analyst: capable of producing solid first drafts quickly, but requiring review and guidance from senior professionals before the work is finalized.

For more finance prompts across specialties, explore the full Skillent Finance Prompt Library.

Common Mistakes to Avoid with Finance AI Prompts

After working with hundreds of finance teams adopting AI tools, we've identified the most common — and most costly — mistakes professionals make when starting to use AI prompts in their workflow.

Mistake 1: Treating AI Output as Final

The single most dangerous mistake is treating AI-generated financial analysis, tax calculations, or reporting narratives as final without review. AI can produce output that looks correct — proper formatting, confident tone, plausible numbers — while containing subtle errors. A misplaced decimal, an outdated tax rate, a misapplied formula, or a misinterpreted accounting standard can turn a useful draft into a professional liability. Always treat AI output as a first draft that requires professional review.

Mistake 2: Inputting Sensitive Client Data

Entering client names, social security numbers, full financial statements, or proprietary business data into an AI tool without understanding the tool's data handling policy is a serious risk. Some AI tools retain input data for training purposes. Some may expose data through API responses. Before using any AI tool with real client data, verify the tool's privacy policy, data retention practices, and whether you can disable training on your inputs. When in doubt, use anonymized or placeholder data.

Mistake 3: Using Generic Prompts for Specialized Tasks

A prompt designed for general financial analysis won't produce good output for a specialized task like transfer pricing documentation or ASC 842 lease accounting. The prompts in this guide are tailored to specific finance functions. Using a generic "analyze this financial data" prompt when you need a specific deliverable — like a variance commentary for a board meeting — will produce generic, unhelpful output. Match the prompt to the task.

Mistake 4: Ignoring Context

AI tools don't know your company, your industry, your accounting policies, or your reporting requirements unless you tell them. A prompt that says "analyze this balance sheet" without context will produce generic analysis. A prompt that says "analyze this balance sheet for a SaaS company using ASC 606 revenue recognition, with a fiscal year ending June 30, reporting to a Board of Directors" will produce targeted, useful analysis. Context is the difference between a parlor trick and a professional tool.

Mistake 5: Not Iterating

The first run of a prompt rarely produces the best possible output. The most effective users run a prompt, review the output, refine the prompt based on what was missing or wrong, and run it again. This iterative process — two or three rounds of refinement — typically produces dramatically better results than the first run. Build time for iteration into your workflow.

Mistake 6: Forgetting the Human Review Layer

AI is a tool, not a team member. Every piece of output that will be seen by a client, an auditor, a regulator, or a board member must be reviewed by a qualified professional who understands the context and takes responsibility for the final product. This isn't just best practice — in many financial roles, it's a regulatory requirement. The human review layer is non-negotiable.

Quick Start Guide: Your First Week with Finance AI Prompts

If you're new to using AI prompts in your finance workflow, here's a practical week-one plan:

Day 1-2: Experiment with Low-Stakes Prompts

Start with prompts that produce output you can immediately verify. Try the variance analysis prompt with last month's actual vs. budget data. Try the reconciliation summary prompt with a small subset of accounts. The goal is to get comfortable with the prompt structure, see the quality of output, and calibrate your expectations.

Day 3-4: Integrate into a Real Workflow

Pick one recurring task — maybe the monthly variance commentary, or the weekly cash flow summary — and use the relevant prompt to produce a first draft. Then complete the task as you normally would, comparing the AI-assisted version to your traditional approach. This will show you where AI helps, where it falls short, and how to integrate it effectively.

Day 5: Customize and Save

Take the prompt you used during the week and customize it for your specific situation. Add your industry, your accounting software, your reporting format, your typical account structure. Save the customized prompt. This becomes the starting point for next week's work — and the beginning of your personal prompt library.

Ready to access the full library of 190,000+ professional AI prompts? Get Skillent Pro for $9/month and unlock prompts for every finance function.

Advanced Pro Tips for Finance AI Prompts

Chain Prompts for Complex Analysis

For complex deliverables, chain multiple prompts together. Start with a data extraction prompt to pull key figures from source documents. Feed that output into an analysis prompt. Then feed the analysis into a formatting prompt that structures the output for your final deliverable. This three-step chain — extract, analyze, format — produces better results than trying to do everything in one prompt. Each step can be refined independently, and intermediate output can be reviewed before proceeding.

Build a Prompt Version History

As you refine prompts over time, keep a version history. Save the original prompt, note what changes you made and why, and track which versions produced the best output. This creates an institutional knowledge base that your entire team can benefit from. When a new team member joins, they can start with your refined prompts rather than the generic originals.

Create Industry-Specific Variants

The prompts in this guide are written for general finance and accounting use. But a CPA serving manufacturing clients needs different prompts than one serving SaaS startups. Create industry-specific variants of each prompt — add industry-specific tax considerations, accounting standards, reporting formats, and common transaction types. Industry-specific prompts produce dramatically better output than generic ones.

Pair AI with Spreadsheet Skills

The most powerful workflow combines AI prompts with advanced spreadsheet skills. Use AI to generate the analysis framework, the commentary, and the narrative. Use Excel or Google Sheets for the actual calculations — where formulas are auditable and verifiable. Copy AI-generated commentary into spreadsheet cells alongside the numbers. This hybrid approach leverages the strengths of both tools: AI for language, spreadsheets for math.

Document Your Review Process

For audit and compliance purposes, document your AI review process. Note which AI tool was used, which prompt was used, what the output was, and what changes you made during review. This documentation demonstrates professional diligence and provides a clear audit trail. Some firms now require this documentation as part of their quality control procedures.

Real-World Applications: Finance AI Prompts in Practice

Month-End Close Acceleration

A mid-market manufacturing company reduced its month-end close from 12 days to 7 days by integrating AI prompts into its close process. The controller used AI to draft variance explanations for each major account, generate the monthly close memo, and prepare the first draft of the consolidated income statement commentary. The AI-generated drafts were reviewed and finalized by the accounting team, but the drafting time was cut by approximately 60%. The key was using structured prompts that included the company's chart of accounts, materiality thresholds, and standard commentary format.

Audit Readiness for a Growing Startup

A Series B startup facing its first external audit used AI prompts to prepare. The finance team generated a complete PBC (prepared by client) list using an audit preparation prompt, then used reconciliation prompts to clean up balance sheet accounts before the auditors arrived. When the auditors requested supporting schedules, the team used AI to draft the schedules from source data. The audit partner noted that the startup was "unusually well-prepared" — a direct result of using AI prompts to structure the preparation process.

Tax Season Volume Management

A solo CPA practitioner serving 200+ individual and small business clients used AI prompts to manage tax season volume. Client intake questionnaires were generated by AI. K-1 matching prompts processed partnership distributions. Tax research memos for unusual situations were drafted by AI and reviewed by the CPA. The practitioner estimated that AI prompts saved 15-20 hours per week during peak season — equivalent to adding a part-time staff member without the overhead.

Cash Flow Crisis Management

A retail company facing a liquidity crisis used AI prompts to build a 13-week cash flow forecast, stress-test it against multiple scenarios, and prepare a presentation for its bank. The AI-generated forecast identified a week where the company would breach its loan covenant — three weeks before it happened. The company was able to negotiate a covenant waiver with the bank in advance, avoiding a default that would have triggered an interest rate spike.

Budget Season Efficiency

A nonprofit organization with 15 departments used AI prompts to streamline its annual budget process. Each department head received a prompt template to input their assumptions, prior-year actuals, and planned initiatives. The finance team used AI to consolidate the departmental inputs, identify gaps, and generate the first draft of the organization-wide budget. The budget was completed in 3 weeks instead of the typical 8, freeing the finance team to focus on scenario analysis and board presentation preparation.

Frequently Asked Questions

Are these AI prompts safe to use with client financial data?

That depends on the AI tool you're using and its data handling policies. Some AI tools retain input data for model training. Others offer enterprise plans where data is not stored or used for training. Before using any AI prompt with real client data, verify the tool's data retention and training policies. Use placeholder or anonymized data when testing new prompts. Many firms adopt a policy of only using AI tools with data that has been anonymized or that falls below materiality thresholds for confidentiality concerns.

Will AI replace accountants and financial analysts?

No — but accountants and analysts who use AI will replace those who don't. AI is a tool that accelerates the mechanical aspects of financial work: drafting, data organization, first-pass analysis, and formatting. The professional judgment, ethical obligations, client relationships, and strategic insight that financial professionals provide cannot be replicated by AI. The most successful finance teams are using AI to handle routine work so their people can focus on high-value analysis and advisory services.

How accurate is AI-generated financial analysis?

AI-generated financial analysis is accurate enough to serve as a strong first draft, but it is not reliable enough to use without professional review. AI can make calculation errors, cite outdated tax rates, misapply accounting standards, or fail to recognize industry-specific nuances. Every number, every citation, every regulatory reference in AI output must be verified by a qualified professional. The value of AI is in accelerating the draft — not in replacing the review.

Can I use these prompts for client deliverables?

Yes, but only after thorough review and customization. These prompts are designed to produce professional-quality first drafts, but the output must be reviewed, corrected, and customized before it's delivered to a client. Add your firm's branding, adjust the format to match client expectations, verify all calculations, and ensure the analysis reflects your professional judgment. AI output is a starting point, not a finished product.

What's the best AI tool for finance prompts?

Different tools have different strengths. ChatGPT (GPT-4) is versatile and produces natural-language output. Claude is strong for long-document analysis and structured reasoning. Perplexity is useful for research with citations. The best approach is to test your most important prompts across multiple tools and see which produces the best output for your specific use case. Many professionals use different tools for different tasks — one for drafting, another for research, another for data analysis.

How do I get started if I'm new to AI prompts?

Start with one task — ideally a recurring task that takes significant time each month. Pick the relevant prompt from this guide, run it with placeholder data, review the output, and refine the prompt based on what you see. Once you're comfortable with the workflow, expand to additional tasks. The goal is to build confidence with one use case before scaling across your entire workflow. Most professionals are productive with AI prompts within a week of starting.

Key Takeaways

These prompts are just the beginning. The full Skillent Finance Prompt Library contains thousands of prompts across every finance and accounting function — from tax planning to audit preparation to financial modeling to regulatory compliance.

Disclaimer: These prompts are tools for financial professionals, not substitutes for personalized financial advice. AI output must be reviewed by a qualified advisor. Investment recommendations must be suitable for the individual client and comply with applicable SEC, FINRA, and state regulations. Past performance does not guarantee future results. Skillent and Valles Global, LLC are not investment advisors and do not provide personalized financial advice.

190,000+ professional AI prompts for financial advisors and every industry.

Get Skillent Pro — $9/month