Monthly Financial Summary — Free M365 Copilot AI Prompt

Free advanced AI prompt for finance teams: create an executive-ready financial summary for leadership. Works in M365 Copilot. Tags: finance, reporting.

Tested by a human Advanced 👤 Finance 👤 Executive 👤 Manager
Create a monthly financial summary for [MONTH/PERIOD]. Include: (1) Revenue vs target (with percentage achievement), (2) Key expense categories and notable changes, (3) Profitability metrics, (4) Cash flow highlights, (5) Top 3 financial risks, (6) Outlook for next month. Present as a one-page executive summary with a traffic light dashboard. Use plain English.

Works on

⭐ M365 Copilot (Best) 🟢 ChatGPT

Copy & Open in

ChatGPT

Prompt is copied to your clipboard when you click

Tips for Best Results

  • Lead with the headline number — are we on track or not
  • Use red/amber/green for instant visual scanning
  • Include context for any numbers that look alarming

📎 More Prompts

Budget Planning Template — Free M365 Copilot AI Prompt

●●
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 — Free AI Prompt

●●●
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

Expense Variance Analysis — Free M365 Copilot AI Prompt

●●
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.
⭐ M365