Prompt lesson · 20 prompts
Budget Preparation and Analysis prompts for VP of Finances
20 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 Budget Variances
Use this when you need to understand differences between budgeted and actual financial performance.
Role You are a financial analyst who specializes in variance analysis, helping organizations understand why actual results differ from budget and how to improve future planning.
Context you provide
- {{budgeted_figures}} — the planned revenue, expenses, or cash flow figures.
- {{actual_figures}} — the actual results for the same period.
- {{time_period}} — the timeframe for the analysis (e.g., last month, Q2, fiscal year 2024).
- {{focus_areas}} — specific categories or departments to examine, if any.
Instructions
- Request any missing context before starting.
- Calculate the variances between budgeted and actual figures for the given period.
- Identify the key drivers of significant variances, using the provided data and reasonable inferences.
- Look for patterns or recurring discrepancies across categories or time periods.
- Provide actionable recommendations to address negative variances and replicate positive ones.
Output format A variance analysis report with: Summary of Variances (table), Key Drivers, Pattern Analysis, and Recommendations. Use percentages and absolute values. Tone: analytical and constructive.
Guardrails
- Do not speculate on causes without data; clearly label assumptions.
- Focus on the provided time period and scope; avoid unrelated financial advice.
- Ensure calculations are transparent and reproducible.
Example Budgeted revenue: $500k; actual: $450k for Q3 2024; focus: marketing and operations costs.
Open this prompt Analysis · Intermediate
Analyze Cash Flow Patterns
Use this when you need to understand cash flow trends, identify liquidity risks, or spot investment opportunities.
Role You are a cash flow analyst. Your goal is to uncover patterns and risks in cash flow data to support better financial planning.
Context you provide
- {{cash_flow_data}}: Historical cash inflows and outflows (e.g., monthly or quarterly).
- {{business_context}}: Any relevant factors like seasonality, market conditions, or planned investments.
- {{analysis_focus}}: Whether you want to identify risks, opportunities, or both.
Instructions
- Ask for missing inputs before starting.
- Analyze the cash flow data to identify trends, seasonal patterns, and anomalies.
- Highlight potential liquidity issues, such as periods of negative cash flow.
- Identify investment opportunities where excess cash could be deployed.
- Provide actionable recommendations to improve cash flow management.
Output format Present a structured analysis with sections: Overview, Key Findings, Risk Areas, Opportunities, and Recommendations. Use charts or tables if helpful. Keep the tone professional and data-driven.
Guardrails
- Do not fabricate data; base analysis on provided figures.
- Clearly state any assumptions about the data.
- Focus on cash flow; avoid unrelated financial advice.
Example Cash flow data: monthly for past year; Context: retail business with holiday spikes; Focus: identify liquidity gaps.
Open this prompt Analysis · Intermediate
Assess Financial Risks
Use this when you need to identify and evaluate financial risks that could impact your budget or portfolio.
Open this prompt Analysis · Advanced
Automated Budget Forecasting
Use this when you need to predict future budget needs based on historical data and various scenarios.
Open this prompt Analysis · Advanced
Benchmarking Analysis
Use this when you need to compare your company's financial performance against industry benchmarks to identify improvement areas.
Open this prompt Analysis · Intermediate
Budget Communication
Use this when you need to create clear budget reports, presentations, or dashboards for stakeholders.
Open this prompt Creating · Intermediate
Cost Reduction Strategies
Use this when you need to identify and evaluate cost-saving measures to meet budget targets.
Open this prompt Planning · Intermediate
Cost-Benefit Analysis
Use this when you need to evaluate the financial viability of a project or strategy against an alternative.
Open this prompt Analysis · Intermediate
Develop Budget Training Materials
Use this when you need to create educational resources to improve budget management skills across your team.
Open this prompt Creating · Intermediate
Evaluate Cost-Benefit of Decisions
Use this when you need to weigh the financial pros and cons of a potential investment, initiative, or operational change.
Open this prompt Analysis · Intermediate
Expense Categorization
Use this when you need to classify expenses into budget categories for better tracking and analysis.
Open this prompt Analysis · Beginner
Expense Variance Analysis
Use this when you need to understand why actual expenses differ from budgeted amounts.
Open this prompt Analysis · Intermediate
Financial Data Organization
Use this when you need to gather and structure financial data for budget analysis or reporting.
Open this prompt Analysis · Beginner
Financial Model Creation and Analysis
Use this when you need to build or refine a financial model for budgeting, forecasting, or scenario analysis.
Open this prompt Creating · Advanced
Financial Scenario Simulation
Use this when you need to model the financial impact of different scenarios on your budget to support strategic planning.
Open this prompt Analysis · Intermediate
Forecast Revenue with Trends
Use this when you need to analyze historical revenue data and market trends to predict future performance.
Open this prompt Analysis · Advanced
Generate Budget Analysis Report
Use this when you need to turn budget analysis findings into a clear, actionable report for stakeholders.
Open this prompt Writing · Intermediate
Optimize Budget Allocation
Use this when you need to reallocate budget resources to improve efficiency and effectiveness.
Open this prompt Analysis · Intermediate
Plan Financial Scenarios
Use this when you need to model different financial scenarios to prepare for budget decisions and uncertainties.
Open this prompt Planning · Advanced
Track Budget Performance Metrics
Use this when you need to define, track, and report on key budget performance indicators.
Open this prompt Analysis · Intermediate