Prompt lesson · 22 prompts
Financial Reporting Assistance prompts for VP of Finances
22 ready-to-use prompts from our AI for VP of Finances course. Copy one, fill in the {{placeholders}}, and paste it into ChatGPT, Claude, Gemini or any other AI.
Analyze Financial Data Trends
Use this when you need to identify trends and insights from financial data to inform strategic decisions.
Role You are a financial analyst expert, skilled in interpreting financial data to uncover actionable insights and trends.
Context you provide
- {{time_period}}: The number of years or specific time frame for analysis (e.g., last 3 years, Q1-Q4 2024).
- {{metrics}}: The specific financial metrics to focus on (e.g., revenue, expenses, profit margins).
- {{benchmark}}: Optional industry benchmark for comparison (e.g., industry average, top competitor).
- {{data_source}}: Where the financial data can be found (e.g., quarterly reports, financial statements, spreadsheets).
Instructions
- If any required information is missing, ask for it before proceeding.
- Analyze the provided financial data for the specified time period, focusing on the given metrics.
- Identify trends, patterns, and anomalies, and compare performance against the benchmark if provided.
- Provide insights on customer spending patterns if relevant, and their impact on financial performance.
- If cash flow statements are available, analyze working capital management and flag potential issues.
- Summarize findings in a clear, actionable format.
Output format Provide a structured report with sections: Executive Summary, Key Trends, Benchmark Comparison, Insights, and Recommendations. Use bullet points and tables where helpful. Keep tone professional and concise.
Guardrails
- Do not invent data; base analysis solely on provided information.
- Flag any assumptions made due to missing data.
- Stay within the scope of financial analysis; do not provide legal or investment advice.
Example "Analyze our quarterly reports from the last 3 years, focusing on revenue and expenses, and compare against industry benchmarks."
Open this prompt Analysis · Intermediate
Analyze Financial Variances
Use this when you need to understand why actual financial results differ from budgeted or forecasted figures.
Role You are a financial analyst that explains variances between actual and budgeted figures, identifying root causes and implications.
Context you provide
- {{actual_figures}}: The actual financial results (e.g., revenue, expenses, profit).
- {{budgeted_figures}}: The budgeted or forecasted figures for the same period.
- {{period}}: The time period being analyzed (e.g., Q3, fiscal year).
- {{factors}}: Any known contributing factors (e.g., market conditions, operational changes).
Instructions
- Ask for any missing inputs before starting.
- Calculate the variance for each line item and categorize as favorable or unfavorable.
- Analyze the drivers behind significant variances, using provided factors and logical reasoning.
- Provide actionable insights and recommendations.
Output format
- Variance table with columns: line item, actual, budget, variance, % variance.
- Explanation of key variances with bullet points.
- Recommendations section.
Guardrails
- Do not invent data; use only provided figures.
- Clearly state any assumptions about causes.
- Stay within the scope of the variance analysis.
Example
- {{actual_figures}}: Revenue $1.2M, {{budgeted_figures}}: $1.5M, {{period}}: Q3, {{factors}}: lower demand.
Open this prompt Analysis · Intermediate
Assess Internal Controls
Use this when you need to evaluate the effectiveness of internal controls over financial reporting and identify weaknesses.
Open this prompt Analysis · Advanced
Automate Financial Report Generation
Use this when you want to design a system that automatically generates financial reports based on predefined criteria.
Open this prompt Automation · Advanced
Automate Financial Reporting
Use this when you need to reduce manual effort in financial reporting by identifying automation opportunities and recommending tools.
Open this prompt Analysis · Intermediate
Create Financial Reporting Training
Use this when you need to design training modules, interactive resources, or assessments to improve your team's understanding of financial reporting requirements and best practices.
Open this prompt Creating · Intermediate
Custom Financial Report Templates
Use this when you need to create tailored financial report templates for different audiences or purposes.
Open this prompt Creating · Intermediate
Ensure Accounting Standards Compliance
Use this when you need to check financial data and reports for compliance with accounting standards and regulations.
Open this prompt Analysis · Intermediate
External Audit Preparation and Documentation Review
Use this when you need to organize, review, and cross-check financial documentation to ensure audit readiness.
Open this prompt Planning · Intermediate
Financial Data Analysis for Reports
Use this when you need to analyze financial data to uncover trends, KPIs, and insights for accurate reporting.
Open this prompt Analysis · Intermediate
Financial Data Collection and Organization
Use this when you need to gather and structure financial data from various sources for reporting or analysis.
Open this prompt Research · Beginner
Financial Data Visualization
Use this when you need to create visual representations of financial data to enhance understanding and presentation.
Open this prompt Creating · Intermediate
Financial Forecasting and Scenario Analysis
Use this when you need to prepare financial forecasts, projections, or scenario analyses to support strategic planning.
Open this prompt Planning · Advanced
Financial Reporting Dashboard Design
Use this when you need to design a real-time financial dashboard that tracks key metrics and KPIs for stakeholders.
Open this prompt Creating · Intermediate
Financial Reporting Process Improvement Analysis
Use this when you need to analyze and improve your financial reporting process to increase efficiency and accuracy.
Open this prompt Analysis · Intermediate
Generate Financial Reports
Use this when you need to create financial summaries, income statements, or risk reports for stakeholders.
Open this prompt Creating · Intermediate
Integrate Financial Reporting Software
Use this when you need to evaluate, select, and implement financial reporting software that improves accuracy and timeliness.
Open this prompt Planning · Intermediate
Internal Controls for Financial Reporting
Use this when you need to analyze and strengthen internal controls to ensure the accuracy and reliability of financial reporting.
Open this prompt Analysis · Intermediate
Prepare Audit Support Package
Use this when you need to organize financial data and documents for an upcoming audit.
Open this prompt Analysis · Intermediate
Prepare Financial Statements
Use this when you need to generate or analyze balance sheets, income statements, or cash flow statements for your company.
Open this prompt Analysis · Intermediate
Review Financial Reporting Compliance
Use this when you need to ensure financial reports adhere to all relevant accounting standards and regulations.
Open this prompt Analysis · Intermediate
Streamline Reporting Processes
Use this when you want to identify inefficiencies in your financial reporting workflow and find automation opportunities.
Open this prompt Planning · Advanced