📊 The Copilot FP&A Prompt Pack — 55 Prompts for Budgeting, Forecasting & Board Reporting

The Copilot FP&A Prompt Pack is a single, instant-download Word document 55 Microsoft 365 Copilot prompts covering the full rhythm of FP&A: budgeting, forecasting, variance analysis, scenario modelling, board reporting, business partnering, data checks, and ad hoc investment decisions.

No agent setup. No accompanying tracker to maintain. Every prompt is written to be copied straight from the document and pasted directly into Copilot Chat, Copilot in Word, or Copilot in Excel built to work against whatever forecast model or spreadsheet you already use.

This isn't a beginner's introduction to budgeting. It's written for people already fluent in FP&A covering driver-based planning, price/volume/mix variance decomposition, covenant headroom, transfer pricing, and quality-of-earnings review, alongside prompts for schedule of rates repricing, material cost pass-through, and CPI-linked rent and service charge modelling.

One document. Open it, find the prompt you need, copy it into Copilot.

What's Included

●     55 Microsoft 365 Copilot prompts in a single Word document (.docx)

●     Organised into 8 categories: Annual Budgeting & Planning, Rolling Forecasts & Reforecasting, Variance Analysis & Driver Commentary, Scenario & Sensitivity Modelling, Board & Executive Reporting, Business Partnering & Stakeholder Communication, Data & Model Checks, and Ad Hoc Analysis & Investment Decisions

●     Worked examples grounded in real sectors property maintenance, materials/merchant trading, and housing — alongside fully generic placeholders that work for any business

●     Dedicated prompts for schedule of rates repricing, material price pass-through, and CPI-linked rent and service charge modelling not found in generic finance prompt packs

●     No jargon-for-its-own-sake technical substance, plain-spoken titles and instructions

●     Instant digital download

Who This Is For

●     FP&A analysts and finance business partners

●     Finance managers responsible for budgeting, forecasting and variance-to-forecast reporting

●     Anyone using Microsoft 365 Copilot who wants technical, ready-to-run prompts rather than a system to set up

●     Property, housing, and merchant/trading businesses will find several prompts built specifically around schedule of rates, CPI-linked rent, and material cost volatility but every prompt works for any business

You don't need Copilot for Finance, a specific ERP, or any special add-on just Microsoft 365 Copilot and a forecast to work on.

Why This Pack

Most Copilot prompt packs are either painfully generic (“summarise this budget”) or dressed up in consulting jargon that doesn't match how FP&A people actually talk. This pack is neither technical enough to be useful to an experienced analyst, plain enough to read like something a colleague would actually say, and built as one document you can open and use immediately, with nothing extra to set up.

FAQ

Is this a bundle with an Excel tracker, like your other Copilot packs?

No this is a standalone Word document. There's no accompanying Excel workbook or agent setup. Just open the document, find the prompt you need, and paste it into Copilot.

Do I need Copilot for Finance, or any special licence?

No just Microsoft 365 Copilot and the usual Microsoft 365 apps (Outlook, Excel, Word). Every prompt is written to work in standard Copilot Chat or Copilot in Excel/Word.

I don't work in housing or property — will these prompts still work for me?

Yes. Every prompt uses generic placeholders [business unit], [entity], [X%] that work for any business. A handful of prompts include a worked example from housing, property maintenance or materials trading to make them concrete, but the prompt itself is fully generic underneath.

Is this suitable for someone new to FP&A?

It's written for people already comfortable with FP&A concepts budgeting, variance analysis, forecasting. It assumes you know what you're trying to achieve; the prompts handle turning that into something Copilot can execute wel

l.

I already own The Copilot Financial Controller — is this different enough?

Yes. The Financial Controller pack is built around the close cycle actual vs. budget, reconciliations, audit. This pack is forward-looking budgeting, forecasting, variance-to-forecast, and scenario modelling and ships as a single prompt document rather than a full toolkit with an Excel tracker.