Industry Copilot · 5 min read

Which Copilot model should your finance team actually use?

James Wilkinson

By James Wilkinson 7 June 2026 Updated 3 October 2026

Auto for a quick email, but not for a forecast. When finance teams should choose Claude Opus or a heavier GPT model in Copilot, and keep the P&L under their own Microsoft controls.

TL;DR
  • For a quick finance email or a clean summary, Copilot's default setting, Auto, is the right tool. Leave the picker alone.
  • For a forecast with linked assumptions, structured variance work or anything going to the board or a lender, choose a heavier model on purpose, such as Claude Opus or one of the newer GPT models, then check the output.
  • Doing the analysis inside Copilot keeps the P&L under your firm's Microsoft agreement and tenant controls, instead of pasting figures into a personal ChatGPT account.

Finance teams were quick to find the useful corners of Copilot. Summarise a board pack, draft the commentary, pull last month’s figures into a note, tidy a reporting email. Most of that runs happily on Auto, the setting Copilot uses by default to pick a model for each request, and you would not think to change it.

Then the work gets harder. A rolling forecast with linked assumptions. Variance commentary that has to trace back to the right driver. A reconciliation that will not behave. This is where the model picker, the one most teams never open, starts to matter.

Auto is fine until the numbers get complicated

Auto weighs accuracy, speed and cost on every request, and finance has plenty of routine work where that balance is right. For a quick email, a status update or a clean summary it is the right tool. The harder test is the multi-step reasoning a forecast demands: holding several driver cells in mind at once, following assumptions through to an output, explaining a movement rather than just restating it.

Auto decides how much reasoning each request deserves. On a forecast you would rather make that call yourself than find out afterwards. Leave a forecast with linked assumptions to a quick, routine pass and you often get an answer that looks right and reads well. The trouble is the parts that look right and are not. In finance, that is the expensive kind of wrong. The same risk sits behind a lot of AI-assisted analysis and reporting in Excel: the output is only as trustworthy as the reasoning underneath it.

The failure mode is specific. A quick pass rarely refuses or stalls. It produces a confident, fluent answer, and on a forecast that is the problem, because fluent and correct are not the same thing. A wrong number in a clean sentence is harder to catch than an obvious gap, and finance is the one place that error gets quoted onward as fact.

When to switch, and to which

The rule is the same one in the fuller guide to the Copilot model picker, applied to finance work.

  • Quick email, status update, clean summary: leave it on Auto.
  • A forecast with linked drivers, a structured variance analysis, any reasoning that has to hold together: choose a heavier model, such as Claude Opus or one of the newer GPT models.
  • Anything that goes to the board, a lender or an auditor: choose on purpose, then check it line by line. Claude Opus is the one to reach for when you want the model to flag where it is unsure rather than present a tidy guess, which is the behaviour you want near a number you are about to sign off.

In practice the choice tracks the reporting cycle. The day-to-day chases, the holding emails and the quick figure-pulls sit on Auto and stay there. The set pieces, month-end commentary, the reforecast, the pack that goes to the board, are the ones worth switching for. If your team only remembers one rule, make it that: anything someone outside finance will read closely, or make a decision on, deserves a switch and a second look.

Choosing a heavier model in Chat or Excel does not add to the bill for most finance work. The everyday models are part of the Copilot licence, and Microsoft says heavier ones such as Opus will come with usage limits, with a warning before anyone reaches one. Work handed to Cowork, or to the frontier models, is paid in Copilot Credits. We set out the split in Copilot model choice: what the licence covers and what costs Copilot Credits.

Keep the numbers under your own controls

There is an old habit worth naming. Someone has a gnarly P&L question, the deadline is close, so they paste the figures into a personal ChatGPT account and get an answer in seconds. It works. It is also the firm’s financial data sitting in a consumer tool nobody approved.

The point of doing the same work inside Copilot is that it stays under your firm’s Microsoft agreement and the controls you already run. GPT models in Copilot are covered by Microsoft’s Product Terms and Data Protection Addendum. Claude models are too, but Anthropic processes them outside the EU Data Boundary, which is why UK tenants have them switched off until someone decides. Our living list of the models behind Copilot sets out both settings. For accountancy practices handling client books the logic is sharper still, and it is the same discipline we set out for Copilot workflows in accountancy firms. A better answer is not worth much if you had to break a data rule to get it.

It is also a habit worth removing before it spreads. One person pasting a P&L into a consumer tool under deadline becomes the team’s unofficial method by the next quarter. Giving people a capable model inside Copilot is how you take that temptation away, rather than just warning against it.

A short worked example

Take a simple one. You ask Copilot to explain why Q3 gross margin fell against budget.

On a quick pass, you tend to get a competent summary. Margin is down, here are the lines that moved, here is a sentence on each. Useful, quick, fine for an internal note.

Switch to a heavier model and give it the linked assumptions, and the answer changes shape. It traces the movement to the drivers: volume held, but input cost per unit rose and the price increase only landed part way through the quarter, so the margin effect is partial. It tells you which assumption to test next. That is the difference between a model that describes the variance and one that reasons about it.

Neither removes the review. You still check the figures yourself. But the second answer starts the conversation in a much better place.

It is worth being clear about what changed. The figures were the same in both runs. What improved was the reasoning over them, because the heavier model connected the assumptions instead of listing the lines. That is the gain you are buying when you switch, and it is largest on the questions where the answer is a judgement rather than a number.

Where to start

Most of this is judgement. Knowing which jobs deserve a switch and which do not. The dependable answer is not asking everyone to remember; it is wiring the right model into the workflow itself, so the heavier model sits behind the tasks that need it by default.

That is the work we do with finance teams and accountancy practices: agents and workflows built around the reports and reviews you already run. If you want the heavier models working on the right tasks, with the numbers kept under your own controls, book a Copilot Readiness Check and we will start from the reports your team runs each month.

Sources checked

Last checked: 3 October 2026.

Related reading

More on Industry Copilot

Industry Copilot Auto, GPT or Claude for legal document review? A law firm's guide to the Copilot picker Which Copilot model for matter prep and contract review, plus the governance points UK law firms should settle before switching Claude on inside Copilot. Copilot Updates Claude Opus 5.5 and GPT-6 Sol in Microsoft Copilot: what UK firms should check first Microsoft is rolling out Claude Opus 5.5 and GPT-6 Sol across Microsoft Copilot (formerly Microsoft 365 Copilot), from Word, Excel and PowerPoint to Cowork and Copilot Studio. What arrived, how it is billed and the checks for UK firms. Industry Copilot How AI can speed up WIP reviews and billing in accountancy firms The median UK firm waits 105 days to turn recorded time into cash. Where AI and automation shorten the WIP half of lock-up, what a day costs and three ways to do it inside Microsoft 365. Copilot Explainers What AI models does Microsoft Copilot use? The current list, by surface Which models power Microsoft Copilot (formerly Microsoft 365 Copilot) right now in Chat, Word, Excel, PowerPoint, Cowork and Copilot Studio, how each is billed and the admin and UK data points. Kept up to date. Copilot Explainers The Copilot model picker nobody switches: when to leave it on Auto and when to choose GPT or Claude Microsoft Copilot has a model picker most teams never touch. When to leave it on Auto, when to choose a GPT or Claude model, what it costs and why the work stays under your Microsoft agreement. Copilot Licensing Copilot model choice: what the licence covers and what now costs Copilot Credits Microsoft Copilot (formerly Microsoft 365 Copilot) is now split into everyday AI on the licence and advanced AI on Copilot Credits. Which models sit where, the 1 December change for Copilot Business and what a firm will pay for. Copilot Updates Claude Opus 5 in Microsoft 365 Copilot: should UK businesses switch it on? Claude Opus 5 is live in the Microsoft 365 Copilot model selector. When it beats GPT-5.6, why UK tenants have it switched off and what enabling it involves. Copilot in Microsoft 365 Copilot in Excel: AI-assisted analysis, reporting and spreadsheet automation Copilot in Excel can speed up analysis, formulas, variance commentary and reporting, but only when the workbook is clean and the question is specific. Industry Copilot Microsoft Copilot for accountants: AI workflows for client emails, reports and admin Microsoft Copilot for accountants: practical workflows for client emails, meeting summaries, report narratives and admin, with the governance UK firms need. Finance and reporting Hospitality P&L agent Monthly P&Ls arrived from each property in a different layout. The finance team now runs a Copilot Studio agent on demand to map each one onto the group's standard lines in seconds, and a person checks the output before the figures go anywhere. Industry AI agents for professional services firms Agents that start on their own when an email arrives, a meeting ends or a report is exported, do the checking, drafting and filing, then stop for one of your team to approve. Industry AI agents for accountancy firms Six accountancy agents for the admin every practice shares: WIP and billing, client checks, meeting notes, records chasing, onboarding and VAT review. Each one waits for one of your team to approve. Next step Book a Copilot Readiness Check Free, 30 minutes, online: where Copilot can and cannot see your data, the two jobs to automate first and a rough install price.

Common questions

Questions about Copilot model for finance

Which Copilot model is best for forecasting?
For a forecast with linked assumptions, choose a heavier model rather than leaving it to Auto. Claude Opus suits work where you want the model to flag what it is unsure of, and the newer GPT models such as GPT-6 Sol are built for multi-step analysis. Always check the output before you rely on it.
Is Copilot's Auto setting good enough for finance work?
For quick emails, status updates and clean summaries, yes. For multi-driver forecasts, structured variance analysis or board-ready commentary, choose a more capable model in the picker yourself.
Can finance teams use Copilot without sending data to ChatGPT?
Yes. The GPT and Claude models in the Copilot picker are covered by Microsoft's Product Terms and Data Protection Addendum and governed through your tenant settings. Claude models are processed by Anthropic outside the EU Data Boundary, which is why UK tenants have them off until someone decides. Either way there is no need to paste a P&L into a personal ChatGPT or Claude.ai account.
Does choosing a heavier model cost extra?
Not for the everyday models in Chat and Excel, which are part of the Copilot licence. Microsoft says heavier models such as Opus will come with usage limits, and work handed to Cowork or to frontier models is paid in Copilot Credits.