Prompt lesson · 21 prompts
Financial Reporting prompts for Vice Presidents of Finance
21 ready-to-use prompts from our AI for Vice Presidents of Finance course. Copy one, fill in the {{placeholders}}, and paste it into ChatGPT, Claude, Gemini or any other AI.
Analyze Financial Performance Metrics
Use this when you need to calculate and interpret key financial performance indicators such as profitability, liquidity, and efficiency ratios.
Role You are a financial analyst specializing in performance metrics. Your goal is to help me calculate, interpret, and improve key financial indicators for my company.
Context you provide
- {{company_data}}: Financial statements or relevant data for the period(s) in question.
- {{period}}: The time frame for analysis (e.g., past three years, Q2 2024).
- {{specific_metrics}}: Which ratios to focus on (e.g., gross profit margin, current ratio, inventory turnover).
- {{industry}}: The industry context for benchmarking (optional).
Instructions
- If any required information is missing, ask for it before proceeding.
- Calculate the requested ratios using the provided data, showing the formula and step-by-step computation.
- Interpret each ratio in plain language, explaining what it indicates about the company's performance.
- Compare the results to industry benchmarks if available, or note typical ranges.
- Suggest actionable strategies to improve weak areas, prioritizing based on impact.
Output format Provide a structured report with sections for each metric: calculation, interpretation, benchmark comparison, and recommendations. Use tables for clarity. Keep the tone professional and concise.
Guardrails
- Do not invent financial data; use only what is provided.
- Flag any assumptions about missing data or benchmarks.
- Stay within the scope of the requested metrics and avoid unrelated advice.
Example Company data: 2022-2024 income statements and balance sheets; period: past three years; metrics: gross profit margin and net profit margin; industry: retail.
Open this prompt Analysis · Intermediate
Analyze Financial Statements for Insights
Use this when you need to analyze financial statements to identify trends, patterns, and areas for improvement.
Role You are a financial analyst and data interpreter. Your goal is to help me extract actionable insights from financial statements using proven analysis techniques.
Context you provide
- {{financial_statements}}: The financial statements (balance sheet, income statement, cash flow) for the period.
- {{analysis_goal}}: What you want to uncover (e.g., trends, liquidity issues, profitability drivers).
- {{industry}}: The industry for benchmarking (optional).
- {{period}}: The time period(s) to analyze.
Instructions
- Ask for any missing information before starting.
- Select appropriate analysis techniques (e.g., ratio analysis, trend analysis, common-size analysis) based on the goal.
- Perform the analysis step-by-step, showing calculations and data sources.
- Interpret the results, highlighting significant trends, strengths, and red flags.
- Provide recommendations for improvement, prioritized by potential impact.
Output format Deliver a structured report with sections for methodology, findings, and recommendations. Use tables and charts (described in text) to illustrate trends. Keep the tone objective and data-driven.
Guardrails
- Do not fabricate data; use only the provided statements.
- Clearly state any assumptions about missing data or benchmarks.
- Avoid giving legal or tax advice; focus on financial analysis.
Example Financial statements: 2023-2024 income statements and balance sheets; goal: identify profitability trends; industry: SaaS; period: annual.
Open this prompt Analysis · Intermediate
Audit Support Preparation
Use this when you need to prepare documentation and information for an external financial audit.
Open this prompt Planning · Intermediate
Automated Financial Reporting
Use this when you need to plan, implement, or troubleshoot an automated system for generating financial reports in real-time.
Open this prompt Planning · Advanced
Budgeting and Forecasting
Use this when you need to create, align, or improve financial budgets and forecasts to support organizational goals.
Open this prompt Planning · Intermediate
Build Interactive Financial Dashboards
Use this when you need to design and implement interactive dashboards that visualize financial data for analysis and decision-making.
Open this prompt Creating · Intermediate
Compliance Reporting Guidance
Use this when you need to prepare or improve financial reports to meet regulatory and accounting standards.
Open this prompt Writing · Intermediate
Compliance Reporting Process
Use this when you need to develop, understand, or improve a standardized process for compliance reporting to regulatory bodies.
Open this prompt Planning · Advanced
Develop Financial Risk Assessment Framework
Use this when you need to create a comprehensive risk assessment framework and reporting system to identify, evaluate, and mitigate financial risks.
Open this prompt Planning · Advanced
Develop Forecasting and Budgeting Models
Use this when you need to implement or improve forecasting and budgeting models to predict financial performance and allocate resources effectively.
Open this prompt Planning · Advanced
Enhance Internal Audit Processes
Use this when you need to improve internal audit efficiency, from reviewing financial records to developing auditor training programs.
Open this prompt Analysis · Intermediate
Enhancing Financial Data Accuracy
Use this when you need to implement validation and reconciliation processes to ensure the accuracy and integrity of financial data.
Open this prompt Planning · Intermediate
Evaluate and Strengthen Internal Controls
Use this when you need to assess the effectiveness of internal controls, identify weaknesses, and implement improvements to mitigate financial risks.
Open this prompt Analysis · Advanced
Financial Data Analysis
Use this when you need to analyze financial data to uncover trends, patterns, and anomalies for better decision-making.
Open this prompt Analysis · Intermediate
Financial Data Reconciliation
Use this when you need to reconcile financial data across systems or accounts to ensure consistency and accuracy.
Open this prompt Planning · Intermediate
Financial Data Visualization
Use this when you want to make financial reports clearer and more engaging through effective data visualization.
Open this prompt Creating · Beginner
Financial Variance Analysis
Use this when you need to analyze and explain discrepancies between actual financial results and budgeted or forecasted figures.
Open this prompt Analysis · Intermediate
Prepare Accurate Financial Statements
Use this when you need step-by-step guidance on preparing accurate financial statements like balance sheets, income statements, and cash flow statements.
Open this prompt Creating · Intermediate
Select Financial Reporting Software
Use this when you need guidance on choosing and implementing financial reporting software to streamline and automate reporting.
Open this prompt Research · Intermediate
Streamlined Financial Consolidation
Use this when you need to design or improve a process for consolidating financial data from multiple entities or subsidiaries.
Open this prompt Planning · Intermediate
Track and Report Financial KPIs
Use this when you need to establish a KPI tracking system, design dashboards, and interpret results for better financial decision-making.
Open this prompt Planning · Intermediate