Expense Variance Analysis

Analyse actual vs budget spending and explain the differences

🧪 Tested by a human Intermediate 👤 Finance 👤 Analyst 👤 Manager
Analyse the expense variance between budget and actual for [PERIOD]. For each line item that varies by more than [THRESHOLD — 5% / 10% / ]: (1) State the variance amount and percentage, (2) Classify as favourable or unfavourable, (3) Explain the likely cause, (4) Recommend whether it is a one-time variance or a trend, (5) Suggest corrective action if needed. Summarise total impact.

Works on

⭐ M365 Copilot (Best)

Copy & Open in

Prompt is copied to your clipboard when you click

Tips for Best Results

  • Focus on material variances — do not explain every small difference
  • Distinguish between timing variances and true overspends
  • Include a one-line recommendation for each material variance

📎 More Prompts

Budget Planning Template

●●
Create a budget planning template for [DEPARTMENT] for [FISCAL YEAR]. Include: (1) Revenue categories with line items, (2) Operating expenses by category (personnel, software, travel, training), (3) Capital expenditure section, (4) Monthly and quarterly breakdowns, (5) Variance tracking columns (budget vs actual), (6) Summary dashboard row with key ratios. Add formulas for totals, percentages, and year-over-year comparison.
⭐ M365 🟢 GPT

Cost Reduction Opportunity Analysis

●●●
Analyse our spending data and identify cost reduction opportunities. Review: (1) Subscriptions and recurring costs (look for unused or duplicate tools), (2) Vendor consolidation potential, (3) Process automation savings, (4) Licence right-sizing, (5) Contract renegotiation opportunities. For each opportunity estimate: annual savings, implementation effort, and risk. Rank by ROI.
⭐ M365 🟢 GPT

Internal Audit Preparation Checklist

●●
Create an audit preparation checklist for [AUDIT TYPE — financial / IT / compliance / SOC2]. Include: (1) Documents to prepare and organise, (2) Access and permissions to set up for auditors, (3) Key contacts and their responsibilities, (4) Common findings from previous audits to pre-check, (5) Timeline from 4 weeks before to audit day, (6) Post-audit follow-up actions. Assign owners to each item.
⭐ M365 🟢 GPT 🟠 Claude
💬