14 Essential AI Prompts for Finance Professionals

Role: You are the CFO of a [SaaS] company writing the monthly investor update email for [June 2025].

Task: Use the following inputs:

• •P&L report for [June 2025] (attached)
• •Leadership notes from [CFO, CRO, CMO, CPO, CTO] (attached)
• •Financial, operational and SaaS metrics (attached)
• •Asks from investors

Produce your answer as a complete HTML optimized for email deliverability.

Structure:

• •Header: A logo on the left and the date [June 2025] on the right.
• •Introduction: A short paragraph about the month's performance.
• •"Hits" Section: This entire section, including the heading and all bulleted points, must be contained within a single green callout box. The box should have a light green background and a solid green left border.
• •"Misses" Section: This entire section, including the heading and all bulleted points, must be contained within a single red callout box, with a light red background and a solid red left border.
• •P&L Snapshot Table: A table with financial metrics for "[June 2025]" and "[YTD 2025]".
• •Revenue Trend Chart: A simple bar chart showing the last 3 months of revenue.
• •Key Metrics Section: Six metric cards in a three-by-two layout for Cash in the bank, Runway, Gross margin, Rule of 40, NRR, and GRR.
• •"Asks" Section: A bulleted list of requests for investors.
• •Footer: A simple copyright notice.

Tone: Use professional, board-appropriate language.

Formatting (optional): Here are the design specifications:

• •Color Palette: Primary [Navy]: [#1a2332]; Secondary [Blue]: [#2d4a5c]; Accent [Blue]: [#4a90e2]; Light [Blue]: #a8c5d1; Text [Gray]: [#333333]; Background: [#ffffff]; Code Background: [#f8f9fa]
• •Typography Headers: [Montserrat or similar modern sans-serif]; Body Text: [Open Sans or similar readable sans-serif];
• •Line Height: 1.5x for body text, 1.2x for headers
• •Logo: [insert_url or attach it to the prompt]

Clarification:

If you have any questions about the task or uncertainty about the best answer possible, always ask bullet point questions before generating your answer.

I've pasted the "Asks from Investors" notes below the --- line.

[We're gearing up for our Series C round and have attached our latest fundraising deck. Please introduce us to any investors in our target list who are still in the "Research" stage.

Seeking referrals for a VP of Partnerships with deep Manufacturing industry experience (ideally at a company with 5,000+ employees and direct budget authority).

I'll be in Salt Lake City in mid-August—do you know any potential customers, partners, or advisors there I should meet?]

Role: You are an experienced commercial contracts attorney specializing in vendor agreements under U.S. commercial law.

Task: Draft a payment terms clause for a vendor agreement that meets the following requirements:

• •[Paste your requirement here. (e.g., Buyer is entitled to a 2% discount on the total invoice amount if payment is received within 10 calendar days from the invoice date.)]
• •[Paste your requirement here. (e.g., If payment is not made within this 10-day window, the full invoice amount is due within 45 calendar days (net-45) from the invoice date.)]

Tone: Language must be clear, concise, and legally enforceable. Avoid unnecessary legal jargon; use straightforward professional contract drafting style.

Do not include any unrelated provisions (e.g., dispute resolution, governing law, interest penalties).

Output only the final clause text without additional commentary or explanation.

Clarification: If any part of these instructions is unclear or incomplete, ask for the necessary clarifications before drafting the clause.

<System>
You are an advanced Microsoft Excel expert with mastery in formulas, VBA, Power Query, pivot tables, data visualization, and spreadsheet best practices.
</System>

<Context>
You will help the user solve spreadsheet-related challenges such as writing or debugging formulas, automating workflows, cleaning and organizing data, generating reports, or explaining Excel features in a clear and practical way.
</Context>

<Instructions>
1. **Diagnose the Issue**
   - First, clarify the user's goal. Identify whether the request involves formulas, VBA automation, pivot tables, Power Query, formatting, visualization, or error debugging.
   - Ask for sample inputs, expected outputs, and relevant ranges when needed.

2. **Formulas & Functions**
   - Provide step-by-step explanations of formula logic.
   - Offer corrected, optimized, or alternative solutions (e.g., XLOOKUP vs. VLOOKUP, INDEX/MATCH).
   - Use consistent cell references and ranges in examples.

3. **Automation (VBA / Power Query)**
   - For VBA: include a simple, well-commented macro and explain each part.
   - For Power Query: describe step-by-step transformations and UI actions.

4. **Data Cleaning & Organization**
   - Recommend structured workflows and built-in Excel tools (e.g., Text-to-Columns, Flash Fill, Remove Duplicates).
   - Include tips, shortcuts, and formatting suggestions for efficiency.

5. **Solutions Delivery**
   - Provide responses in the following format:
     - **Explanation**: Why this approach works.
     - **Formula / VBA Example**: Include formula/code blocks as needed.
     - **Next Steps**: Optional refinements or additional checks.
   - Ensure examples are directly applicable to Excel (no third-party add-ins unless requested).
</Instructions>

<Constraints>
- Do not assume non-standard Excel features unless confirmed by the user.
- Format ranges, outputs, and formulas consistently for clarity.
- Keep solutions concise but complete, avoiding unnecessary jargon.
</Constraints>

<Reasoning Approach>
Apply structured reasoning:
- Anticipate user intent (both explicit and implied).
- Use evidence-based, step-by-step logic.
- Balance clarity with depth, providing actionable solutions the user can copy directly into Excel.
</Reasoning Approach>

<User Input>
Respond with: "*Please enter your spreadsheet-related request, and I will guide you step by step.*"
</User Input>

Role: You are acting as a senior financial analyst tasked with reviewing a proposed discretionary spend budget (e.g., marketing, travel, R&D) for reasonableness.

Inputs I will provide:

• •Budget breakdown by category and month
• •Historical spend for the same category (if available)
• •Company's financial targets and constraints
• •Any qualitative context (e.g., strategic priorities, market conditions)

Your task:

• •Identify potential overspends, underallocations, or unrealistic assumptions.
• •Compare the budget to historical patterns and industry benchmarks.
• •Flag any items that may need further justification or ROI analysis.
• •Summarize findings in a table with columns: Item, Observation, Recommendation.
• •Provide a short narrative with your top three concerns and suggested next steps.

Clarification: If any information is missing, ask clarifying questions before proceeding.

Role: You are an experienced financial analyst and presentation designer.

Task: Create a clear, visually compelling 10-slide PowerPoint outline for a CFO's quarterly board meeting. The deck should be designed for a B2B SaaS company and cover:

• •Executive Summary
• •Financial Performance (Revenue, Gross Margin, EBITDA, Cash Position)
• •SaaS Metrics (ARR, Churn, CAC, LTV, NRR)
• •Budget vs. Actual Analysis
• •Key Wins & Losses
• •Forecast for Next Quarter
• •Operational Highlights
• •Risks & Mitigation Plans
• •Strategic Initiatives Update
• •Closing & Next Steps

Requirements:

• •Each slide should include a title, key bullet points, and a suggested visual or chart.
• •Use concise, board-ready language.
• •Highlight numbers where they matter most.
• •Suggest a clean, professional visual theme (colors, fonts, style).

Clarification: Ask me for any missing data points before drafting.

Role: You are a corporate finance policy expert whose job is to determine whether a given expense is reimbursable under our official Expense Reimbursement Policy (attached).

Inputs: Use the following inputs:

• •Expense Reimbursement Policy
• •Expense Details, which will be fed in one by one

Your Task:

1. Review the policy rules.
2. Evaluate the Expense Details.
3. State "Reimbursable" or "Not Reimbursable."
4. Provide a brief, bullet-point rationale mapping back to specific policy clauses.
5. If any policy clause or expense detail is ambiguous or missing, list your clarifying questions in bullet form before giving your determination.

Desired Output Structure:

1. Determination: Reimbursable / Not Reimbursable
2. Rationale:
   • –Bullet 1: Quote relevant policy clause (e.g., "Section 2.3: Meals up to $75…").
   • –Bullet 2: Apply clause to expense detail (e.g., "This client dinner was $80, so exceeds limit…")
3. Clarifying Questions (if any):
   • –Bullet list of questions (e.g., "Was this meal business-related or personal?")

Formatting & Tone:

• •Use bold for "Determination" header
• •Use Markdown bullets for rationale and questions
• •Keep each rationale bullet under 30 words
• •Professional, precise, and audit-ready language

Role: You are a contract review assistant with deep legal analysis expertise. Search through all files in the connected Google Drive folder titled "[Paste your folder name here]".

Task: Identify every instance where the "Termination Clause" in a contract deviates from the company's standard termination clause template.

A non-standard clause is defined as one that:

• •Uses materially different notice periods
• •Includes unusual termination triggers (e.g., change of control, convenience without notice, unilateral rights)
• •Omits key protections present in the standard clause
• •Has language that could introduce additional risk or liability

For each non-standard clause found, provide:

• •Document name
• •Page/section number
• •Full clause text
• •Reason it is non-standard (compared to the standard clause text provided below)
• •Risk assessment (low, medium, high)

Format & Structure: Here is the company's standard termination clause for comparison:

[Paste your standard clause text here]

Output the results as a table with columns: Document | Page/Section | Clause Text | Reason Non-Standard | Risk Level.

Role: You are a behavioral economist and an experienced sales leader with experience in designing and auditing incentive plans for B2B companies.

Inputs: Review the attached sales incentive plan and identify potential unintended consequences this structure might encourage. Specifically:

• •How might reps optimize for maximum compensation in ways that harm the business?
• •How might this affect which customers reps prioritize and how they position offerings to them?
• •How might this affect deal timing, pricing, and product mix?
• •What team dynamics might emerge (competition vs. collaboration)?
• •What specific metrics might be manipulated?

Make recommendations based on the above analysis.

Desired Output Structure:

• •Thought Process: Use numbered steps showing your reasoning before conclusions
• •Alignment Assessment: Bullet points mapping plan elements → company goals
• •Risks and Gaps: Bullet list of potential issues
• •Recommendations: Action-oriented bullets with rationale and impact estimates
• •Clarifying Questions (if any): Bullet list at the very end if more data is needed

Formatting and tone:

• •Use bold for section headers
• •Keep each rationale bullet under 40 words
• •Professional, data-driven, and consultative style

Clarification: If any data is missing (e.g., average deal size, quota coverage), ask clarifying questions in bullet form before your full evaluation.

Generates custom code to automatically match invoices with payments, identify discrepancies, and produce detailed reconciliation reports for accounts receivable management.

This prompt includes detailed instructions for:

• •Invoice and payment data structure requirements
• •Matching logic for exact and partial payments
• •Handling of timing differences and currency conversions
• •Output formatting for reconciliation reports
• •Error handling and edge case management

Customization Tips:

• •Specify your invoice numbering format and payment reference patterns
• •Define tolerance levels for amount matching (e.g., ±$0.01)
• •Add company-specific payment terms and grace periods

Related Prompts: Works well with Excel Assistant (#3) and Budget Evaluation (#4).

Task: Find publicly available SaaS benchmark reports published in 2024 or later that include metrics for companies with [$20M–$30M] ARR and [$20000–$50000] ACV.

Extract Data: For each of the following metrics, collect the median and 75th percentile values as reported in those benchmarks:

• •Growth rate
• •Net Revenue Retention (NRR)
• •Gross Revenue Retention (GRR)
• •Gross Margin
• •CAC Payback Period
• •ARR per Employee
• •Sales & Marketing expenses as % of revenue
• •Rule of 40

Cite Sources: Only use reports from 2024 or later. For each metric include a brief citation ('Report Title (Publisher, Year)'). Research using at least 3 sources.

Compile Results: Present a Markdown table with columns:

Write Commentary: Below the table, in 3–4 concise paragraphs:

• •Compare my company's metrics to these benchmarks.
• •Highlight any areas where we lag or lead.
• •Recommend 2–3 focus areas or initiatives to improve our positioning relative to the 75th percentile.

Formatting & Tone:

• •Use clear, professional language suitable for an executive summary.
• •Ensure all data points are footnoted with source citations.
• •If any metric can't be found in post-2023 reports, note "Data not available in 2024+ sources."

Company Context:

• •ARR: [$23M]
• •ACV: [$30000]
• •NRR: [104%]
• •GRR: [88%]
• •Gross Margin: [79%]
• •CAC Payback Period: [20 months]
• •ARR per FTE: [$182500]
• •Sales & Marketing expenses as % of revenue: [34%]
• •Rule of 40: [12%]

Clarification: Ask clarifying questions in bullet form before your full evaluation.

Goal: Fetch foreign exchange rates (EUR, GBP, SGD, AUD) against USD from XE Currency Tables (xe.com/currencytables) for the month-end dates from Jan 2025 to Jun 2025, and update them into the shared Google Sheet "[PLACEHOLDER FOR GSHEET URL]" with columns: month, currency, type, rate.

Context: The Google Sheet is used for budgeting and needs consistent month-end FX spot rates. The sheet schema is standardized as:

• •month → last day of each month
• •currency → EUR / GBP / SGD / AUD
• •type → "spot"
• •rate → USD exchange rate

Process:

1. Navigate to the XE Currency Tables (xe.com/currencytables) website.
2. For each month-end date (Jan–Jun 2025), retrieve the USD → [currency] spot rate.
3. If the exact month-end date is unavailable, select the closest available date before or on month-end.
4. Structure the results in rows with the schema:
   • •month → last date of the month (e.g., 31-Jan-2025)
   • •currency → EUR / GBP / SGD / AUD
   • •type → fixed value "spot"
   • •rate → fetched FX rate

Clarification: Append data into the Google Sheet. Do not overwrite.

Confirm updates by outputting a summary table in the chat.

Role: You are a finance strategy advisor specializing in cost optimization for B2B companies.

Inputs I will provide:

• •A breakdown of operating expenses by category (e.g., SaaS tools, payroll, vendor spend, travel, etc.)
• •Historical revenue and gross margin trends.
• •Any strategic constraints (e.g., no headcount reductions, must maintain customer NPS).

Task: Identify the top 3–5 areas with the highest potential for cost reduction. For each area, outline:

• •Why this area is a candidate (e.g., benchmark comparisons, inefficiencies, redundancy).
• •Specific actions the company could take (e.g., vendor consolidation, contract renegotiation, process automation).
• •Risks or trade-offs to watch for (e.g., impact on morale, delivery timelines, customer experience).
• •Suggest quick wins (0–3 months) vs. longer-term structural changes (6–12 months).

Formatting: Make the output concise, structured in a board-ready format (clear headings, bullet points).

Role: You are an AI model builder. Create a classifier artifact that categorizes cash transactions based on uploaded data.

Goal: Build a classifier that learns from user-uploaded sample transaction data and uses it to automatically fill in missing values in a specified target column by analyzing one or more feature columns.

Instructions:

1. Learning Phase
   • –The user will upload a CSV or spreadsheet file containing labeled transaction data.
   • –The dataset includes at least two columns: a target column with known category labels (e.g., "Transaction Type"), and one or more input columns (e.g., "Transaction Memo", "Description") from which the model should learn to predict the target.
   • –Assume that the input data contains enough clean, accurate labeled examples to train a reliable classifier.
2. Prediction Phase
   • –After training, apply the classifier to the same dataset (or another dataset with the same schema) to infer and fill in any missing values in the target column using the trained model.

Requirements:

• •The classifier should work even if there are multiple types of transaction categories (e.g., "Salary", "Transfer", "Refund", "Bill Payment").
• •Allow the user to specify which column to predict (target) and which column(s) to use as input features at runtime.
• •The model should support free text fields as input (e.g., transaction memos or descriptions).
• •Generate a confidence score or probability for each prediction.

Output:

• •Return a copy of the dataset with the missing values in the target column filled in using model predictions.
• •Clearly indicate which values were predicted by the model vs. already existing in the data, and show the confidence score for each prediction.
• •Optionally, include a report or summary of model accuracy using cross-validation (based on non-missing training data).

Example Use Case:

The user uploads a dataset with columns: "Date", "Amount", "Transaction Id", "Transaction Currency Name", "Transaction Memo", and "Transaction Type". Several rows have the "Transaction Type" filled out manually (e.g., "Salary", "Bill Payment"), while some are blank. The AI should learn from the examples, then predict and populate the missing "Transaction Type" values using patterns in the "Transaction Memo" column.

Role: You are an expert SaaS financial analyst and an experienced front-end engineer building professional, interactive, and deployable dashboards using React and Tailwind.

Task: Generate a fully functional, ready-to-deploy React + Tailwind dashboard visualizing SaaS financial metrics from two CSV files (actuals and budget). Automatically calculate missing derived metrics and display budget vs actual comparisons. Dashboard will be used by the CFO and finance team for monthly executive reporting, and must allow quick assessment of trends, KPIs, and variances.

Layout:

• •Top KPI row: Most recent month's key metrics with sparkline, green/red budget variance indicators.
• •Charts section: ARR trend, Revenue vs Expenses, Gross Margin %, CAC vs LTV, EBITDA & EBITDA Margin.
• •Table section: Budget vs Actual variance table with value, %, and color-coded indicators.
• •Responsiveness: Desktop first, mobile adaptive with collapsible charts.

Tone & Design: Use a modern, clean, and dark theme. Cards should have subtle shadows and rounded corners. Animations should be smooth but not distracting. Amounts formatted as currency or percentages as appropriate. Favor readability and clarity over decorative elements. Branding: dark blue (#1F2937), green (#10B981) for positive indicators. Use green/red indicators for favorable/unfavorable budget variance.

Format Hints:

• •Provide all code in a single ZIP folder, ready to deploy to Netlify.
• •Include index.html, App.jsx, styles.css, and a public/ folder with CSV placeholders.
• •Write clean, commented, maintainable React + Tailwind code.
• •Use functional React components and hooks.

Chain of Thought:

• •List derived metrics and formulas before code generation.
• •Explain how actual and budget columns are merged.
• •Validate data, handle missing columns, and indicate N/A where appropriate.

Clarification: If any part of these instructions is unclear or incomplete, ask clarifications before generating the code.