40 AI Prompts for Finance & Accounting: Reports, Forecasts, and Analysis
Spreadsheets don't explain themselves, and board decks don't write themselves. These prompts handle the narrative — financial reports, variance analysis, investor updates, and the dozens of other documents where the numbers need words around them.
Note: AI output should always be verified against actual financial data. These prompts generate templates, frameworks, and narrative drafts — not financial calculations or audit opinions. Review all output for accuracy before distribution.
Financial Reporting Prompts
1. Monthly Financial Summary
You are an experienced FP&A analyst preparing a monthly financial summary for [MONTH/YEAR].
Actual results:
- Revenue: $[AMOUNT] (budget: $[AMOUNT])
- COGS: $[AMOUNT] (budget: $[AMOUNT])
- Gross margin: [X]% (budget: [X]%)
- Operating expenses: $[AMOUNT] (budget: $[AMOUNT])
- EBITDA: $[AMOUNT] (budget: $[AMOUNT])
- Cash position: $[AMOUNT]
Write a 1-page executive financial summary including:
- Headline performance (one sentence: beat/missed and by how much)
- Revenue analysis (drivers of variance — volume, pricing, mix)
- Cost analysis (where we over/under-spent and why)
- Key metrics vs. prior month and prior year
- Cash flow highlights
- Outlook for next month (risks and opportunities)
- 3 recommended actions
Tone: Data-driven and direct. No filler. CFO and CEO are the audience.2. Board Financial Presentation
Structure a board of directors financial presentation for [QUARTER/YEAR].
Company: [COMPANY NAME], [STAGE — e.g., Series B SaaS company]
Key metrics this quarter:
- ARR: $[AMOUNT] (growth: [X]% QoQ)
- Net revenue retention: [X]%
- CAC payback: [X] months
- Burn rate: $[AMOUNT]/month
- Runway: [X] months
Create a slide-by-slide outline:
1. Executive summary (3 key takeaways)
2. P&L overview with variance commentary
3. Revenue deep-dive (by segment, cohort, or product line)
4. Unit economics dashboard
5. Cash flow and runway analysis
6. Forecast vs. actual (with reforecast if applicable)
7. Capital allocation and investment priorities
8. Key risks and mitigations
9. Board discussion topics
For each slide, include the key data points and 2-3 bullets of narrative. Board members have 45 minutes — every slide must earn its spot.3. Variance Analysis Report
Write a variance analysis report for [DEPARTMENT/BUSINESS UNIT] for [PERIOD].
Budget vs. actual data:
[PASTE LINE ITEMS WITH BUDGET AND ACTUAL AMOUNTS]
For each material variance (>5% or >$[THRESHOLD]):
- Quantify the variance ($ and %)
- Categorize: timing, volume, rate/price, one-time, or structural
- Root cause explanation
- Whether it's expected to continue
- Recommended action (if any)
Format:
- Summary table with color coding (favorable green, unfavorable red)
- Narrative section organized by category
- Forward-looking impact on full-year forecast
Keep the narrative tight — one paragraph per material variance.4. Cash Flow Forecast
Create a 13-week cash flow forecast template for [COMPANY TYPE — e.g., a B2B SaaS company with $5M ARR].
Categories to include:
RECEIPTS:
- Subscription revenue collections (by payment terms: prepaid annual, monthly, net-30)
- Professional services revenue
- Other income
DISBURSEMENTS:
- Payroll and benefits
- Cloud infrastructure / hosting
- Software and tools
- Marketing spend
- Rent and facilities
- Insurance
- Tax payments
- Debt service
- Capital expenditures
- Other operating expenses
Include:
- Weekly column format
- Opening and closing cash balances
- Minimum cash threshold alerts
- Notes column for assumptions
- Scenario toggles (base case, upside, downside)
Provide instructions for maintaining the forecast weekly.5. Investor Update
Write a monthly investor update email for [COMPANY NAME], a [STAGE] [INDUSTRY] company.
Key metrics:
- MRR: $[AMOUNT] ([X]% MoM growth)
- Cash: $[AMOUNT] ([X] months runway)
- Customers: [NUMBER] (net adds: [NUMBER])
- Key hire: [NAME, ROLE]
- Product milestone: [ACHIEVEMENT]
Format (following the standard investor update framework):
1. TL;DR (3 bullets max)
2. Highlights (what went well)
3. Lowlights (what didn't — investors respect honesty)
4. KPIs dashboard (table format)
5. Key asks (introductions, advice, hiring referrals)
6. What's next (next month priorities)
Tone: Transparent, concise, and forward-looking. This builds trust, not just reports numbers. Under 500 words total.Budgeting & Forecasting Prompts
6. Annual Budget Template
Create an annual operating budget framework for a [COMPANY SIZE — e.g., 50-person SaaS company] with $[REVENUE] in annual revenue.
Department budgets to include:
- Engineering (headcount, infrastructure, tools)
- Sales (compensation, travel, tools, events)
- Marketing (campaigns, content, tools, events)
- Customer Success (headcount, tools, training)
- G&A (legal, accounting, insurance, office, IT)
- People/HR (recruiting, benefits, L&D)
For each department:
- Line item categories
- Monthly phasing guidance (even spread vs. seasonal)
- Headcount plan with loaded cost calculation
- Discretionary vs. committed spend
- YoY benchmark percentages (as % of revenue)
Include a budget assumptions page documenting key inputs: hiring timeline, revenue growth rate, inflation factor, and contractor-to-FTE ratio.7. Revenue Forecast Model
Design a bottom-up revenue forecast model for a [BUSINESS TYPE — e.g., B2B SaaS with land-and-expand motion].
Model components:
1. New business pipeline
- Leads → MQLs → SQLs → Opportunities → Closed Won (with conversion rates)
- Average deal size by segment
- Sales cycle length by segment
- Seasonal patterns
2. Expansion revenue
- Net revenue retention by cohort
- Upsell/cross-sell rates
- Expansion timing patterns
3. Churn
- Gross churn by segment and cohort
- Logo vs. revenue churn
- Contraction drivers
Provide:
- Monthly forecast by revenue type (new, expansion, renewal, churn)
- Key assumptions clearly documented
- Sensitivity analysis on 3 most impactful variables
- Reconciliation to top-down targets
Include formulas and logic descriptions for building this in a spreadsheet.8-10. Planning Prompts
8. Headcount Justification — Write a headcount request for [NUMBER] [ROLE(S)] including business case, expected impact on revenue/efficiency, ramp timeline, and fully loaded cost analysis.
9. Scenario Planning — Build three financial scenarios (conservative, base, aggressive) for [YEAR], each with distinct revenue, cost, and hiring assumptions. Include a decision framework for which scenario triggers which actions.
10. Cost Reduction Analysis — Analyze [DEPARTMENT/COMPANY] operating expenses and identify [TARGET — e.g., $500K] in annual savings, ranked by ease of implementation, impact, and risk.
Analysis & Decision Support
11. Unit Economics Analysis
Calculate and analyze unit economics for [PRODUCT/SERVICE].
Data:
- Average revenue per account: $[AMOUNT]/[PERIOD]
- Gross margin: [X]%
- Customer acquisition cost breakdown:
- Sales: $[AMOUNT]
- Marketing: $[AMOUNT]
- Onboarding: $[AMOUNT]
- Average customer lifetime: [MONTHS/YEARS]
- Monthly churn rate: [X]%
Calculate and interpret:
- LTV (lifetime value)
- CAC (customer acquisition cost)
- LTV:CAC ratio
- CAC payback period (months)
- Contribution margin
- Fully loaded unit economics (including CS and support)
Benchmark against industry standards. Flag any metrics outside healthy ranges and recommend improvements.12. Make vs. Buy Analysis
Prepare a make vs. buy analysis for [DECISION — e.g., building an internal billing system vs. purchasing a SaaS solution].
Build option:
- Development cost estimate: [AMOUNT]
- Timeline: [MONTHS]
- Ongoing maintenance: [ANNUAL COST]
- Team resources required: [HEADCOUNT]
Buy option:
- Vendor: [VENDOR NAME]
- Annual cost: [AMOUNT]
- Implementation cost: [AMOUNT]
- Implementation timeline: [MONTHS]
Analyze:
- 3-year total cost of ownership for each option
- Risk factors (technical risk, vendor risk, opportunity cost)
- Strategic considerations (core competency, competitive advantage)
- Qualitative factors (flexibility, scalability, integration)
- Recommendation with supporting rationale
Present as a decision memo for [AUDIENCE — e.g., CFO and CTO].13-20. Quick Analysis Prompts
13. Pricing Analysis — Analyze the financial impact of changing pricing from [CURRENT] to [PROPOSED], modeling effects on volume, revenue, margin, and customer composition.
14. Vendor Consolidation — Review [NUMBER] software vendors totaling $[ANNUAL SPEND] and identify consolidation opportunities, including overlap analysis and savings estimate.
15. Working Capital Analysis — Analyze working capital health using: DSO [DAYS], DPO [DAYS], inventory days [DAYS]. Recommend improvements targeting [GOAL — e.g., reducing cash conversion cycle by 10 days].
16. Break-Even Analysis — Calculate break-even for [NEW INITIATIVE] with fixed costs of $[AMOUNT], variable cost per unit of $[AMOUNT], and price per unit of $[AMOUNT]. Include time-to-break-even under different volume scenarios.
17. SaaS Metrics Dashboard — Define and calculate the core SaaS metrics dashboard: ARR, MRR, net revenue retention, gross margin, burn multiple, Rule of 40, magic number. Include healthy benchmarks for [STAGE] companies.
18. Tax Planning Summary — Outline key tax planning considerations for a [ENTITY TYPE] in [STATE] with $[REVENUE] revenue, including estimated quarterly payments, R&D credit eligibility, and year-end strategies.
19. M&A Financial Summary — Create a financial summary of acquisition target [COMPANY] including revenue trends, profitability, key ratios, synergy estimates, and preliminary valuation range.
20. Capital Allocation Framework — Design a capital allocation framework for distributing $[AMOUNT] across [CATEGORIES — e.g., R&D, sales, infrastructure, M&A], including scoring criteria and recommended split.
Audit & Compliance Prompts
21. Audit Preparation Checklist
Create a comprehensive audit preparation checklist for a [AUDIT TYPE — e.g., annual external financial audit] of a [COMPANY TYPE].
Organize by:
1. Pre-audit preparation (6-8 weeks before)
- Financial close procedures
- Account reconciliations
- Supporting documentation gathering
2. During audit
- Auditor request list management
- PBC (prepared by client) items
- Staff availability and coordination
3. Post-audit
- Management letter response
- Adjusting entries
- Internal control improvements
For each item:
- Description
- Owner (controller, AP, AR, payroll, etc.)
- Deadline
- Status tracking (not started, in progress, complete, submitted)
Include common auditor requests by balance sheet and P&L category.22-30. Compliance & Operations Prompts
22. SOX Compliance Narrative — Write control descriptions for [NUMBER] key financial controls including objective, risk addressed, control activity, frequency, and evidence of performance.
23. Revenue Recognition Memo — Draft an ASC 606 revenue recognition memo for [CONTRACT TYPE — e.g., multi-element SaaS arrangement with professional services], including performance obligation identification and allocation.
24. Lease Accounting Summary — Summarize ASC 842 lease accounting treatment for [LEASE TYPE — e.g., office space lease of $X/month for Y years], including right-of-use asset and liability calculations.
25. Internal Controls Assessment — Design an internal controls assessment questionnaire for [PROCESS — e.g., procure-to-pay], covering segregation of duties, authorization limits, and reconciliation procedures.
26. Chart of Accounts Review — Evaluate the current chart of accounts for [COMPANY TYPE] and recommend additions, consolidations, or restructuring to improve reporting and analysis capabilities.
27. Month-End Close Checklist — Create a detailed month-end close checklist with tasks, owners, deadlines (by close day), dependencies, and sign-off requirements. Target: 5-day close.
28. Financial Policy Draft — Draft a [POLICY TYPE — e.g., travel and expense] policy including approval thresholds, documentation requirements, exceptions process, and compliance consequences.
29. 1099 Preparation Guide — Create a year-end 1099 preparation guide including vendor classification criteria, threshold requirements, common mistakes, and filing deadlines.
30. Bank Reconciliation Procedures — Document bank reconciliation procedures for [NUMBER] accounts including frequency, outstanding item investigation thresholds, and escalation criteria.
Presentation & Communication
31-40. Finance Communication Templates
31. CFO Weekly Report — Write a weekly CFO report template covering cash position, AR/AP aging, revenue pace vs. forecast, key vendor payments, and upcoming financial decisions.
32. Department Budget Review — Structure a quarterly budget review meeting with [DEPARTMENT HEAD] including YTD performance, forecast-to-go, reallocation requests, and headcount plan updates.
33. Financial Literacy Training — Design a 30-minute financial literacy training for non-finance managers covering how to read a P&L, understanding their budget, and what variance analysis means for their team.
34. Fundraising Deck Financials — Create the financial slides for a [ROUND — e.g., Series B] fundraising deck including historical financials, unit economics, forecast, and use of funds.
35. Pricing Committee Brief — Draft a pricing committee brief recommending [PRICING CHANGE] with supporting analysis: competitive benchmarks, margin impact, customer impact modeling, and implementation timeline.
36. Board Financial FAQ — Anticipate and prepare answers to the 10 most likely financial questions the board will ask this quarter based on [CURRENT BUSINESS CONTEXT].
37. Annual Financial Calendar — Create an annual financial calendar for [COMPANY] including close dates, filing deadlines, audit schedule, budget cycle, board meetings, and tax dates.
38. Expense Report Policy Email — Write an all-hands email rolling out updated expense policies, explaining what changed, why, and how to comply. Firm but not punitive.
39. Financial Dashboard Design — Specify a real-time financial dashboard for [AUDIENCE — e.g., CEO and leadership team] including metrics, data sources, refresh frequency, and alert thresholds.
40. Year-End Financial Review — Write a year-end financial review presentation including annual results vs. plan, key wins and misses, lessons learned, and strategic financial priorities for next year.
Tips for Finance Professionals Using AI
- Never paste real financial data without authorization. Use anonymized or sample data until you've confirmed your AI usage policy allows real figures.
- AI handles narrative, not numbers. Use AI to write the analysis around your numbers, not to calculate the numbers themselves. Always verify calculations independently.
- Specify accounting standards. GAAP, IFRS, and local standards differ. Tell the AI which framework applies: "Under US GAAP ASC 606..."
- Include your reporting period and entity. Finance documents are time-sensitive. Always specify the period, entity, and currency.
- Build templates for recurring reports. If you write the same variance commentary every month, templatize the prompt. SurePrompts lets you create reusable prompts that your entire finance team can use consistently.
Keep Reading
- AI Prompts for Business — Strategy, operations, and growth prompts
- AI Prompts for Lawyers — Contracts, research, and compliance prompts
- AI Prompt Security — Protecting sensitive data when using AI
- AI Prompts for Project Managers — Planning, budgeting, and stakeholder communication
- Prompt Engineering Basics — The complete beginner's guide to prompting
- Using the Prompt Optimizer — Analyze and improve any prompt's effectiveness
- Common Prompt Mistakes — Avoid errors that produce unreliable AI output