The Microsoft 365 Copilot Prompt Pack for Finance is a collection of ready-to-use example prompts designed specifically for finance professionals. It helps teams use Microsoft 365 Copilot to support common finance workflows across:

• Financial closing and reporting – organizing and summarizing close data, standardizing inputs, and preparing leadership-ready summaries and slide outlines.
• Forecasting and performance analysis – summarizing forecast outlooks, visualizing trends, explaining model movements, and incorporating external signals like competitor earnings.
• Risk, compliance, and audit readiness – interpreting regulations, updating policy wording, comparing accounting amendments, and translating complex terms into plain language.
• Contract and supplier decision support – comparing planned vs. actual spend, preparing for supplier negotiations, and flagging contract clauses that may need deeper review.
• Collections and cash flow acceleration – identifying overdue invoices, estimating near-term cash receipts, and pinpointing recurring dispute drivers.

The prompts are designed to:

• Inspire and guide how you structure your own prompts, rather than act as rigid templates.
• Show how to ground Copilot in your files and data (for example, forecast models, reconciliation reports, policy documents, contracts, and dispute logs).
• Help teams operate more adaptably, with better information and clearer outputs, while still protecting organizational data.

Outputs from the prompt pack are intended to support productivity and analysis. They are not a substitute for professional financial, accounting, investment, or legal advice, and they are not tailored to any specific organization.

With the Finance Prompt Pack, Microsoft 365 Copilot uses an intelligence layer (Work IQ) that connects individual and organizational knowledge. In practice, this means Copilot can:

• Understand your role and context (for example, FP&A, controllership, or collections).
• Ground responses in your actual files such as forecast models, reconciliation reports, policy documents, contracts, and aging receivables.
• Deliver insights in the flow of work across Microsoft 365 apps, without relying only on connector-based integrations.

However, there are important considerations:

• Configuration and permissions: Results depend on how your tenant is set up, what data users are allowed to access, and which products are available in your environment.
• Data quality: Copilot’s outputs reflect the quality and consistency of your underlying data (for example, standardized invoice fields, clean forecast models, and up-to-date policy documents).
• Governance and compliance: The examples in the prompt pack are illustrative and may not cover all governance, privacy, compliance, or financial requirements for your organization.

To use the prompt pack responsibly, finance teams should:

• Ensure usage aligns with internal policies, applicable laws, and the Microsoft 365 Copilot Transparency Note.
• Apply meaningful human oversight to all outputs, especially those used in reporting, planning, or external communications.
• Treat Copilot’s responses as supporting analysis, not as final financial, accounting, investment, or legal conclusions.
• Refer to internal guidance and expert review before making decisions based on Copilot-generated content.

The Finance Prompt Pack is organized around real-world scenarios that finance teams handle every month and quarter. Examples include:

1. Financial closing and reporting

• Standardizing close data – identifying formatting inconsistencies in consolidated invoice and payment data and proposing Excel transformations to normalize it.
• Revenue insights – finding the top product categories by revenue over the past three years and summarizing trends in a table and chart.
• Leadership materials – turning variance analysis into a 4–6 slide PowerPoint outline with key variances, drivers, implications, and a short talk track per slide.

2. Forecasting, variance analysis, and performance insights

• Forecast outlooks – summarizing the expected outlook for top product categories, highlighting assumptions, changes vs. prior forecasts, and emerging risks or opportunities in a one-page briefing.
• Trend visualization – creating simple charts of forecasted revenue by product category over the next two years, with a short narrative on what the trend suggests.
• Explaining model movements – breaking down month-over-month changes in ARR, consumption, seat growth, and credits usage, then converting that into an executive-level narrative.

3. Risk, compliance, and audit readiness

• Policy updates – summarizing leadership feedback, updating specific policy sections, and clearly calling out what changed and why.
• Regulation tracking – summarizing new accounting regulations from credible sources and outlining what finance teams should be aware of.
• Plain-language explanations – rewriting financial terms and formulas so non-finance stakeholders can understand them, with simple examples.

4. Contract and supplier decision support

• Spend vs. deliverables – comparing planned/committed spend to actual invoiced and paid spend by vendor, highlighting the largest variances in a table.
• Negotiation prep – summarizing contract terms, renewal dates, payment patterns, and open issues from emails and procurement data before a supplier meeting.
• Risky clauses – flagging contract clauses that may introduce financial, legal, or operational risk (for example, unilateral changes or autorenewals) and explaining why.

5. Collections and cash flow acceleration

• Overdue invoice visibility – scanning aging receivables and customer emails to identify the most overdue invoices, issues, and recommended next steps in a table.
• Escalation planning – drafting narratives that recommend escalation paths for overdue accounts, including rationale and steps if payment is not received.
• Cash flow risk – estimating expected cash receipts over the next 30 days and identifying invoices at risk of delay based on historical patterns and meeting notes.
• Dispute analysis – summarizing the most common dispute root causes by value and frequency, and recommending preventive process or policy changes.

Across these scenarios, the prompt pack helps finance teams reimagine how they use Copilot: not just to answer questions, but to structure analysis, prepare stakeholder-ready outputs, and focus human effort on judgment and decision-making.