Prompt lesson · 23 prompts
Financial Data Interpretation prompts for Accountants
23 ready-to-use prompts from our AI for Accountants course. Copy one, fill in the {{placeholders}}, and paste it into ChatGPT, Claude, Gemini or any other AI.
Analyze Budget-To-Actual Variances
Use this when you need to explain the gap between actual and budgeted financial results and recommend corrective action.
Role — You are a financial analyst who explains the gap between actual and budgeted results and turns it into specific, actionable recommendations.
Context you provide
- {{actual_vs_budget_data}} — actual and budgeted figures for the period, by line item or department
- {{period}} — the period being reviewed
- {{scope}} — what's in scope (e.g., a department, a cost category, company-wide)
- {{known_factors}} — optional: known events that might explain variances (hiring, price changes, one-off costs)
Instructions
- Ask for missing inputs before starting, especially {{actual_vs_budget_data}}.
- Calculate the variance (amount and %) for each line item in {{scope}} for {{period}}.
- Rank the top variances by size and flag whether each is favorable or unfavorable.
- Explain likely drivers behind the largest variances, using {{known_factors}} where relevant and marking speculation clearly.
- Recommend corrective actions or process adjustments for the most significant unfavorable variances.
Output format — A variance table (line item, budget, actual, variance $, variance %, favorable/unfavorable) followed by "Top Drivers" and "Recommended Actions," each 3-5 bullets.
Guardrails
- Use only the figures supplied; do not estimate missing budget or actual numbers.
- Clearly separate confirmed causes from plausible explanations.
- Flag variances large enough to warrant a conversation with department leadership.
Example — {{actual_vs_budget_data}} = Q2 actual vs. budgeted spend by department; {{period}} = Q2 2026; {{scope}} = sales department; {{known_factors}} = two unplanned hires and a trade show sponsorship.
Open this prompt Analysis · Intermediate
Analyze Financial Statement Health
Use this when you need a ratio-backed assessment of a company's financial health from its statements.
Role — You are a financial analyst who interprets financial statements into a clear, ratio-backed assessment of a company's health and performance.
Context you provide
- {{company_name}} — the company being analyzed
- {{financial_statements}} — the statements or figures available, such as income statement, balance sheet, and cash flow, for the relevant periods
- {{time_period}} — the period or periods to analyze or compare
- {{comparison_target}} — optional: an industry peer, benchmark, or prior period to compare against
Instructions
- Ask for any missing statements, time period, or comparison target before starting.
- Calculate and interpret key ratios: liquidity, solvency, profitability, and efficiency, using only the figures provided.
- Identify notable trends across {{time_period}}, such as revenue growth, margin changes, or leverage shifts.
- If {{comparison_target}} is given, compare {{company_name}}'s ratios against it and explain significant gaps.
- Summarize overall financial health and flag any red flags or areas needing further investigation.
Output format — A ratio table (ratio, value, what it indicates), a trends section, and a short written assessment of financial health. Plain language suitable for a finance-literate but non-specialist reader.
Guardrails
- Calculate ratios only from the figures supplied; do not estimate or invent missing numbers.
- Clearly state when a conclusion depends on data not provided.
- Avoid presenting this as investment advice; frame it as an analytical summary.
Example — {{company_name}} = Company XYZ; {{financial_statements}} = three years of income statements and balance sheets; {{time_period}} = FY2023-FY2025; {{comparison_target}} = industry average for its sector.
Open this prompt Analysis · Advanced
Break Down Company Cost Structure
Use this when you need to analyze a company's cost structure to find the biggest cost drivers and opportunities for savings.
Open this prompt Analysis · Intermediate
Budget Adherence Analysis
Use this when you need to analyze budget data to identify variances, understand patterns, and improve future budgeting decisions.
Open this prompt Analysis · Intermediate
Budget Variance Insights
Use this when you need to analyze differences between actual financial results and budgeted amounts to identify overspending and cost-saving opportunities.
Open this prompt Analysis · Intermediate
Business Unit Performance Review
Use this when you need to evaluate the financial performance of business units, departments, or projects to identify top performers and areas for improvement.
Open this prompt Analysis · Intermediate
Capital Investment Evaluation
Use this when you need to evaluate the profitability and feasibility of long-term investment projects using financial analysis.
Open this prompt Analysis · Advanced
Cash Flow Analysis
Use this when you need to interpret a cash flow statement to assess liquidity, identify trends, and spot investment opportunities.
Open this prompt Analysis · Intermediate
Comparative Financial Analysis
Use this when you need to compare financial performance across companies, periods, or against industry benchmarks to inform strategic decisions.
Open this prompt Analysis · Intermediate
Compliance Analysis
Use this when you need to review financial data for adherence to accounting standards, regulations, and internal policies, and identify corrective actions.
Open this prompt Analysis · Advanced
Financial Benchmarking Analysis
Use this when you need to compare a company's financial performance against industry peers or benchmarks to identify strengths, weaknesses, and improvement areas.
Open this prompt Analysis · Advanced
Financial Forecasting
Use this when you need to predict future financial performance based on historical data and assumptions to support planning and resource allocation.
Open this prompt Planning · Intermediate
Financial Ratio Analysis From Statements
Use this when you need to calculate and interpret liquidity, profitability, or efficiency ratios from a company's financial statements.
Open this prompt Analysis · Intermediate
Financial Risk Assessment
Use this when you need to evaluate financial risks from market volatility, creditworthiness, or external factors and develop mitigation strategies.
Open this prompt Analysis · Intermediate
Financial Scenario Modeling
Use this when you need to simulate the financial impact of different scenarios, such as interest rate changes, cost driver fluctuations, or pricing strategies, on a company's performance.
Open this prompt Analysis · Advanced
Financial Sensitivity Analysis
Use this when you need to assess how changes in key variables like sales volume, pricing, or costs affect financial outcomes.
Open this prompt Analysis · Intermediate
Financial Trend Analysis
Use this when you need to analyze financial data over time to identify patterns, trends, and anomalies that affect business performance.
Open this prompt Analysis · Beginner
Interpret Company Cash Flow
Use this when you need to interpret a cash flow statement and flag liquidity trends or concerns.
Open this prompt Analysis · Intermediate
Investment Opportunity Assessment
Use this when you need to evaluate investment opportunities by analyzing financial statements, comparing performance, or screening for high-potential companies.
Open this prompt Analysis · Intermediate
Market-Based Financial Forecasting
Use this when you need to forecast financial performance by combining historical data with market trends and industry factors.
Open this prompt Research · Advanced
Profitability and ROI Analysis
Use this when you need to analyze profit margins, return on investment, and other profitability metrics to assess and improve a company's financial performance.
Open this prompt Analysis · Intermediate
Revenue Source and Trend Analysis
Use this when you need to analyze revenue data to identify key sources, trends, and the effectiveness of sales and marketing strategies.
Open this prompt Analysis · Intermediate
Spot Trends In Financial Statements
Use this when you need to identify recurring patterns in a company's revenue, expenses or cash flow across multiple periods.
Open this prompt Analysis · Intermediate