10 AI Prompts for Financial Planning & Analysis
Financial planning involves a large volume of analytical writing: forecasts, scenario narratives, variance explanations, client summaries, risk assessments. The math is handled by spreadsheets. The judgment comes from experience. But the communication layer — turning numbers into clear, structured narratives — is exactly where AI earns its keep.
This guide covers eight high-leverage workflows with 8 copy-paste prompts for ChatGPT, Claude, and Gemini. Each section includes a realistic time-saved estimate. The prompts are designed for financial planners, CFOs, analysts, and advisors working with real client data. If you work in accounting specifically, see the companion guide on AI automation for accountants covering reconciliation, reporting, and client deliverables.
Disclaimer: AI does not replace licensed financial advice. These prompts assist with documentation, communication, and analytical drafting. All outputs must be reviewed by a qualified financial professional before being shared with clients or used in any financial decision-making context.
1. Cash Flow Forecasting Narratives
Spreadsheet forecasts are precise but opaque to most clients and stakeholders. The narrative layer — explaining the assumptions, flagging risks, and translating monthly figures into plain English — is what advisors spend hours producing. AI handles the first draft in minutes.
Time saved: 2-3 hours per forecast cycle
Prompt 1 — Cash Flow Forecast Narrative
Write a plain-English narrative for the following cash flow forecast. This will accompany a spreadsheet shared with the client — assume they are a business owner, not a finance professional. Tone: clear, professional, direct. No jargon. No filler phrases. Length: 250-350 words Format: narrative paragraphs Cover these points in order: 1. Opening cash position and what it means 2. Expected inflows by source and timing 3. Major outflow categories and key dates 4. Net position at period end and whether it represents improvement or deterioration 5. One key risk to the forecast (based on the data provided) 6. One recommended action for the client Forecast data: Period: [MONTH/QUARTER] Opening balance: [FIGURE] Projected inflows: [LIST BY SOURCE AND AMOUNT] Projected outflows: [LIST BY CATEGORY AND AMOUNT] Closing balance: [FIGURE] Key assumptions: [LIST] Do not invent figures. If data is missing, note the gap rather than filling it.
2. Investment Portfolio Summary
Quarterly investment reviews require translating portfolio performance data into a narrative that is accurate, reassuring where appropriate, and honest about underperformance. Drafting these from scratch is repetitive work that AI handles well.
Time saved: 1-2 hours per client per quarter
Prompt 2 — Investment Portfolio Summary
Write a client-facing investment portfolio summary for a quarterly review meeting. Use only the data provided. Tone: measured, honest, professional. Do not oversell performance or downplay losses. Length: 300-400 words Audience: individual investor, moderate financial literacy Include: 1. Portfolio overview — total value, period return, benchmark comparison if provided 2. Asset allocation summary — how the portfolio is currently positioned 3. Top performers and notable underperformers this quarter 4. Any rebalancing that occurred and the reason 5. Forward-looking context — market conditions relevant to this client's allocation 6. Recommended discussion topics for the meeting Portfolio data: Period: [QUARTER/YEAR] Total value: [FIGURE] Period return: [%] Benchmark return (if applicable): [%] Asset allocation: [BREAKDOWN] Holdings performance: [LIST TOP AND BOTTOM PERFORMERS] Rebalancing actions: [LIST OR "NONE"] Client risk profile: [CONSERVATIVE / MODERATE / AGGRESSIVE] Flag any statements that require your professional review before delivery.
3. Budget Variance Analysis
Monthly budget-to-actual variance reports require both the numbers and the narrative. The narrative is the time sink. AI turns a data paste into a structured variance explanation in under two minutes.
Time saved: 1-2 hours per reporting cycle
Prompt 3 — Budget Variance Analysis
Analyze the following budget vs. actual data and produce a variance analysis report. Output format: 1. Executive summary (2-3 sentences): favorable or unfavorable overall, and why 2. Variance table: line item | budget | actual | variance $ | variance % | F/U 3. Narrative explanation for each line item with variance exceeding 5% or $1,000 4. Top 3 action items for management based on the variances 5. Flag any items that suggest a structural issue vs. a timing difference Definitions: F = favorable (actual better than budget), U = unfavorable Budget vs. actual data: Period: [MONTH/QUARTER] [PASTE DATA — line items with budget and actual figures] Keep explanations factual. If you cannot determine the reason for a variance from the data, say so explicitly rather than speculating.
4. Financial Goal Tracking
Progress-toward-goals reporting is one of the highest-value client touchpoints in financial planning — and one of the most time-consuming to write. AI generates structured updates that keep clients engaged without requiring hours of writing.
Time saved: 30-60 minutes per client update
Prompt 4 — Financial Goal Progress Report
Write a goal progress update for a financial planning client. This will be sent as a brief quarterly check-in. Tone: encouraging but grounded in facts. Honest about gaps. Not sales-y. Length: 200-300 words Format: short narrative followed by a goals table For each goal, include: current status vs. target, whether on track / behind / ahead, and one specific action or observation. Client goals: [LIST EACH GOAL WITH: goal name, target amount, target date, current progress, last update] Changes since last update: [DESCRIBE ANY CONTRIBUTIONS, WITHDRAWALS, LIFE EVENTS] If any goal is significantly off track, include a frank one-sentence note and suggest the client discuss it at the next meeting. Do not soften problems to the point of obscuring them.
5. Retirement Planning Scenarios
Scenario planning — showing clients what retirement looks like at 60 vs. 65, or with a 6% vs. 4% return assumption — is essential planning work that typically requires custom narrative writing for each scenario. AI builds the comparative narrative from your scenario data.
Time saved: 2-3 hours per scenario set
Prompt 5 — Retirement Planning Scenario Comparison
Write a retirement planning scenario comparison narrative for a client review. Present two or three scenarios side by side in plain English. The goal is to help the client understand trade-offs, not to push them toward a specific option. Tone: objective, educational, clear. No financial jargon without immediate plain-English explanation. Length: 400-500 words Format: brief intro, then one paragraph per scenario, then a summary of the key decision point Client profile: Current age: [AGE] Target retirement age(s): [AGE OPTIONS] Current savings: [FIGURE] Annual contribution: [FIGURE] Estimated annual expenses in retirement: [FIGURE] Scenarios (provide data for each): Scenario A: [LABEL — e.g., "Retire at 60"] — [KEY ASSUMPTIONS AND PROJECTED OUTCOME] Scenario B: [LABEL — e.g., "Retire at 65"] — [KEY ASSUMPTIONS AND PROJECTED OUTCOME] Scenario C (optional): [LABEL] — [KEY ASSUMPTIONS AND PROJECTED OUTCOME] Close with: "The trade-off your client is weighing is [X vs. Y]. Key questions to discuss at your meeting: [LIST 2-3]." Do not recommend a specific scenario. Flag this section for the advisor to review.
6. Client Quarterly Reports
Quarterly client reports are the most time-intensive deliverable in financial planning practice. Each one requires a summary of portfolio activity, goal progress, market context, and forward-looking notes. AI drafts the report shell; you supply the professional judgment layer.
Time saved: 3-4 hours per client per quarter
Prompt 6 — Client Quarterly Review Report
Draft a quarterly review report for a financial planning client. This document will be sent ahead of their quarterly meeting and reviewed by the advisor before delivery. Sections to include: 1. Quarter in Review (2-3 sentences): what happened in the client's financial life this quarter 2. Portfolio Performance: summary of returns, allocation, any changes made 3. Goal Progress: brief update on each tracked goal 4. Market Context: 2-3 sentences relevant to this client's risk profile and time horizon 5. Looking Ahead: upcoming decisions, deadlines, or life events to plan for 6. Action Items Before Next Meeting: numbered list for the client Tone: personal, professional, clear. Write as if the advisor is speaking directly to the client. Length: 500-600 words total Client data: Name: [FIRST NAME] Quarter: [Q1/Q2/Q3/Q4 YEAR] Portfolio return: [%] Benchmark: [%] Goals on track: [LIST] Goals off track: [LIST WITH REASON] Life events this quarter: [LIST OR "NONE"] Upcoming deadlines: [LIST] Advisor notes: [OPTIONAL CONTEXT] Mark any section where data was insufficient to complete with [ADVISOR: PLEASE COMPLETE].
7. Market Analysis Briefs
Many advisors send periodic market commentary to their client base. Writing a fresh brief each week or month is time-consuming when the structure is always the same. AI accelerates the drafting; the advisor applies current data and professional interpretation.
Time saved: 1-2 hours per brief
Prompt 7 — Client Market Commentary Brief
Write a client-facing market commentary brief based on the bullet points I provide. This will go out to a general client list with mixed financial literacy levels. Tone: calm, informative, grounded. Do not alarm or over-reassure. Avoid sensationalism. Length: 300-400 words Format: short intro paragraph, then 3 sections with brief subheadings, then a closing Audience: retail investors with long-term horizons. Remind them of this framing where relevant. Market data and key points to cover: [PASTE YOUR BULLET POINTS — index performance, key economic data, notable events, relevant sector movements] Advisor's intended message this period: [DESCRIBE IN 1-2 SENTENCES — e.g., "reassure about volatility", "remind about rebalancing opportunity", "note rate environment"] Do not make specific investment recommendations. Close with: "As always, reach out if you have questions about how this applies to your plan." Flag any claims that require fact-checking before sending.
8. Risk Assessment Documentation
Risk assessment documentation — for compliance files, onboarding records, or internal reviews — requires structured, consistent language. AI produces the documentation framework; the advisor supplies the substantive professional assessment.
Time saved: 1-2 hours per client file
Prompt 8 — Client Risk Assessment Documentation
Draft a client risk assessment summary for an internal planning file. This document supports the advisor's compliance records and informs investment recommendations. It is not a client-facing document. Output format: 1. Risk Tolerance Profile: [CONSERVATIVE / MODERATE / AGGRESSIVE] — with a one-paragraph narrative justification based on the inputs 2. Capacity for Loss: assessment of the client's financial ability to absorb downside 3. Time Horizon: effective investment horizon based on goals and age 4. Key Risk Factors: specific to this client (liquidity needs, concentrated positions, income stability, dependents, etc.) 5. Alignment Check: whether current portfolio allocation is consistent with the above profile 6. Flags for Advisor Review: any inconsistencies or areas requiring further client conversation Client inputs: Age: [AGE] Retirement target: [YEAR OR "FLEXIBLE"] Income stability: [STABLE / VARIABLE / UNCERTAIN] Dependents: [NUMBER AND AGES] Primary financial goals: [LIST] Self-reported risk tolerance: [LOW / MEDIUM / HIGH] Reaction to 20% portfolio drop: [CLIENT'S STATED RESPONSE] Current allocation: [BREAKDOWN] Liquidity needs (next 1-3 years): [FIGURE OR DESCRIPTION] This document is a drafting aid. The advisor is responsible for the final professional assessment and compliance suitability determination.
Total Time Saved: 12-19 Hours Per Week
Here is how the time savings add up across a standard advisory practice:
| Workflow | Time Saved |
|---|---|
| Cash flow forecasting narratives | 2-3 hrs / cycle |
| Investment portfolio summaries | 1-2 hrs / client / qtr |
| Budget variance analysis | 1-2 hrs / cycle |
| Financial goal tracking updates | 30-60 min / client |
| Retirement planning scenarios | 2-3 hrs / scenario set |
| Client quarterly reports | 3-4 hrs / client / qtr |
| Market analysis briefs | 1-2 hrs / brief |
| Risk assessment documentation | 1-2 hrs / client file |
| Total (active client roster) | 12-19 hrs / week |
For an advisor billing at $150-250 per hour, reclaiming 12 hours per week represents $1,800-3,000 in capacity — available to serve more clients, invest in business development, or reduce working hours without cutting revenue.
A Note on AI and Financial Advice
AI does not replace licensed financial advice. These prompts assist with documentation, report drafting, and communication — the analytical writing layer. The professional judgment required for investment recommendations, suitability determinations, tax planning positions, and compliance obligations remains entirely with the licensed advisor.
Every prompt in this guide explicitly flags where the advisor must review output before it is used. The objective is not to automate professional judgment. It is to eliminate the mechanical writing work that prevents advisors from spending more time on the judgment work that actually requires their expertise.
The 155 prompts in the qarko AI Workflow Guide Core include dedicated sections on financial analysis, client communication, data interpretation, and report writing — each prompt tested across Claude, GPT-4o, and Gemini.
Related Posts
Get the Full Financial Planning Prompt System
155 copy-paste prompts plus step-by-step workflow guides for financial reporting, client communication, scenario analysis, and more. Optimized for Claude, GPT-4o, and Gemini.
Just need the prompts?
155 copy-paste prompts for Claude, GPT-4o, and Gemini — financial planning, analysis, client reporting, and more.