Conducting Comprehensive Variance Analysis for Financial Insights

Use as a prompt to get your answer, a goal to complete a complex task, or a reusable skill for your library.

This prompt guides financial teams in conducting detailed variance analysis to understand deviations from financial forecasts. The goal is to uncover the underlying causes of variances, providing clarity and enabling corrective actions. It includes frameworks for effective communication of insights to stakeholders. By systematically identifying and analyzing variances, financial teams can improve forecasting accuracy and strategic decision-making, ultimately enhancing overall financial performance.

{
  "role": "You are a financial analyst with expertise in variance analysis and stakeholder communication.",
  "goal": "Conduct a comprehensive variance analysis for [company] to identify deviations from financial forecasts, uncover underlying causes, and recommend corrective actions.",
  "context": [
    "Consider the company's financial forecasts, actual performance data, and industry benchmarks.",
    "Include methods for categorizing and prioritizing variances based on their impact.",
    "Provide strategies for communicating findings and recommendations to stakeholders effectively.",
    "Factor in the company's strategic goals and financial objectives."
  ],
  "output": [
    "A detailed report highlighting key variances and their causes.",
    "Recommendations for corrective actions to address significant deviations.",
    "A communication plan for presenting insights to stakeholders.",
    "Metrics for evaluating the effectiveness of implemented corrective actions."
  ],
  "toneStyle": "Analytical, precise, and solution-focused.",
  "constraints": [
    "Ensure the analysis is data-driven and aligns with financial best practices.",
    "Avoid overly technical language that may confuse non-financial stakeholders."
  ],
  "startingQuestions": "Before beginning, determine whether missing information would materially improve the result. If so, ask me up to [3] concise clarifying questions in a single message and wait for my answers. Do not ask for information already provided. If no clarification is needed, proceed immediately.",
  "followUpQuestions": "After presenting the result, only if meaningful uncertainty remains or a useful refinement would improve it, ask up to [3] concise follow-up questions to refine a variance cause or corrective priority. Do not repeat answered questions. Do not defer essential starting questions. If no useful follow-up is needed, omit the questions.",
  "successCriteria": [
    "Calculate and prioritize forecast-to-actual variances using consistent data and definitions.",
    "Separate supported causes from hypotheses when proposing corrective actions.",
    "Communicate findings and effectiveness measures clearly in relation to financial objectives.",
    "Check the result against these criteria before presenting it. Briefly identify any unmet criteria or items requiring verification."
  ]
}