15 AI Prompts for Finance Pros: A Practical Workflow Guide

Why Finance Teams Need Structured Prompts

Corporate Finance Institute (CFI) recently published a list of 15 AI prompts aimed at finance professionals. The list targets recurring tasks: monthly close commentary, variance analysis, board-ready summaries, and client emails. A vague prompt like "analyze this" wastes time and yields generic output. A structured prompt—with role, context, and format—returns work you can use almost immediately.

Finance work is detail-heavy. A single missing assumption can distort an entire forecast. The prompts in CFI's list are designed to force the AI to ask clarifying questions or to include placeholders for your numbers. That built-in structure is what makes them faster than ad-hoc prompting.

Before You Start: Set Your Context

Every good finance prompt needs three elements: the role, the dataset, and the output format. Without these, you'll get boilerplate. CFI's examples embed all three. For instance, instead of "Explain this variance," the effective version is: "You are a FP&A analyst. Here is the budget vs. actual for Q2. Explain the top three variances in a memo format with a table and bullet points."

Decide what you want before you type. A board summary is different from a line-item reconciliation. If you need numbers checked, say so. If you need narrative only, say that too. The AI cannot read your mind—it reads your prompt.

The 15 Prompts: How to Use Them in Practice

CFI's list covers five core areas. Below is a distilled, checkable workflow you can run today. Each step maps to one or more of their prompts, but adapted for immediate use.

• Step 1 — Role assignment. Begin every prompt with: "Act as a senior financial analyst at a mid-cap company." This sets the tone, vocabulary, and depth. Test it with a sample report.
• Step 2 — Data injection. Paste the actual numbers, not a summary. Example: "Here is the P&L for Jan-Mar: Revenue 12.4 lakh, COGS 8.1 lakh. Calculate gross margin and compare to forecast of 35%." The AI will compute and flag discrepancies.
• Step 3 — Variance narrative. Use the prompt: "Write a 200-word variance commentary for the CFO. Highlight the top two favorable and unfavorable items. Use plain language, no jargon." Check the output for accuracy against your own calc.
• Step 4 — Board summary. Ask for: "Summarize the quarter in five bullet points, each under 15 words, for a non-finance board member." This forces brevity and clarity.
• Step 5 — Client email. For an invoice follow-up or a late payment reminder, use: "Draft a polite but firm email to a client who is 15 days late on a 2.3 lakh invoice. Include a payment link placeholder and a deadline."
• Step 6 — Forecast scenario. Prompt: "Given last year's sales of 80 lakh and a growth rate of 12%, project monthly sales for next year. Show a sensitivity table for 10%, 12%, and 15% growth." The AI will generate the table—verify the math.
• Step 7 — Excel formula generation. Ask: "Write an Excel formula to calculate CAGR from cells A1 to A5, explaining each part." This saves you from memory lapses.
• Step 8 — Ratio analysis. Use: "Calculate current ratio, quick ratio, and debt-to-equity from these numbers: current assets 5.6 lakh, inventory 1.2 lakh, current liabilities 3.4 lakh, total debt 7.8 lakh, equity 12.3 lakh. Provide interpretations."
• Step 9 — Risk flagging. "List three potential risks in this budget assuming a 20% revenue drop. Be specific about which line items break."
• Step 10 — Presentation slides. "Create an outline for a 10-slide investor deck from this data. Each slide should have a headline and three bullet points."
• Step 11 — Audit checklist. "Generate a 15-point audit checklist for month-end close based on these accounts: cash, AR, AP, payroll."
• Step 12 — Simplification. "Explain EBITDA to a 12-year-old in two sentences." This clarifies your own understanding.
• Step 13 — Comparative analysis. "Compare our margins to industry averages. Assume industry gross margin is 28%. Here are our numbers."
• Step 14 — Cash flow projection. "Using this opening balance and these receivables, project cash flow for 90 days. Flag any negative months."
• Step 15 — Follow-up questions. End with: "Ask me three clarifying questions before you finalize." This catches missing assumptions.

How to Verify the Output

AI can hallucinate numbers. Never copy a computed figure straight into a report. Cross-check the math with your own spreadsheet or a calculator. For narrative outputs, spot-check the dates, names, and units. CFI's prompts include instructions for the AI to state assumptions—always read those out loud.

Set a rule: the AI drafts, you decide. Use the output as a starting point, not the final word. For regulatory filings or client-facing numbers, a human review is non-negotiable.

When This Works—and When It Doesn't

These prompts shine for routine, structured tasks: variance commentary, ratio calculations, draft emails, and slide outlines. They save real time when you have clean data and clear expectations. They fall short for messy, judgment-heavy work—like negotiating a deal or interpreting ambiguous accounting standards—where context and discretion matter more than speed.

CFI's list is a solid starting toolkit. Treat it as a template, adapt the numbers and roles to your firm, and always keep a human in the loop.