Why Copilot is not enough for effective budgeting
Copilot in Excel writes formulas, cleans data and summarises a sheet in seconds. But what makes budgeting heavy rarely sits in a single sheet. It sits between the sheets, between the companies and between the people.
Excel is still where the budget lives. In Hypergene's 2025 survey Confessions of a Nordic CFO, 80 percent of Nordic finance leaders said they use Excel for planning, budgeting and forecasting 1. When Microsoft adds Copilot to Excel, it is easy to think budgeting will sort itself out.
Copilot does a lot well. But it makes Excel faster, not the budget process better. This guide covers the difference, and what you need on top of Copilot for the budget to be ready on time and trackable against actuals.
What Copilot in Excel is good at
- Formulas. Describe what you want to calculate and Copilot suggests the formula, even for tricky lookups and conditions.
- Cleaning and structuring data. Splitting columns, fixing formats and building tables from a messy export.
- Summarising and explaining. Getting a quick picture of what a sheet contains and which items stand out.
- Charts and pivot tables. Building a first visual without hunting through the menus.
For someone alone with a sheet who wants to finish faster, it is a real help. The problem is that budgeting rarely looks like that.
Where Copilot runs out in budgeting
- The budget is a process, not a sheet. Targets from management, input from budget owners, reconciliations and decisions. Copilot helps in the sheet but does not manage who delivers what and when.
- Many versions of the truth. When each budget owner has their own file there are many copies to merge. Copilot cannot tell which one is the latest.
- Actuals arrive as an export. To compare with actuals, the books from Fortnox or Visma have to be exported into the sheet, and they are out of date the next day.
- Several companies and charts of accounts. In a group the companies have to be added up, internal items eliminated and charts of accounts mapped. That is not a formula question.
- Permissions. According to Microsoft, changes Copilot makes in a workbook are visible to everyone with access to the file 2. Letting a budget owner see their part but not the salaries in the rest of the company takes separate files.
- Tracking. Once the budget is approved it has to be tracked against actuals every month, and the forecast recalculated. That is another round of exports and sheets.
What Microsoft itself says
Microsoft itself advises against relying on Copilot for financial decisions. Its frequently asked questions on Copilot in Excel say that Copilot can make mistakes and produce inaccurate results, that everything should be reviewed before you rely on it, and that you should avoid using Copilot for decisions in sensitive areas such as finance, legal or medical topics 2.
The same page notes that Copilot was trained mainly on English sources and may work less well in other languages 2. The features also change quickly. The COPILOT formula function, launched to use AI directly in cells, stopped working on 14 September 2026, although Copilot remains available in the side pane 3. A budget model meant to be used year after year needs something more stable to stand on.
| Copilot in Excel | Budget tool on booked actuals | |
|---|---|---|
| Formulas and structure in a sheet | Good | Not needed, the model calculates |
| Many budget owners | One file per person, merged by hand | Everyone in the same budget, with permissions |
| Actuals from the books | Exported in | Fetched automatically |
| Several companies and group | Build it yourself | Added up and consolidated |
| Tracking and forecast | A new round of sheets every month | Tracked and recalculated as actuals come in |
What effective budgeting needs
- One budget, not many files. All budget owners work in the same budget, and management sees the whole as it takes shape.
- Actuals straight from the books. The budget is built on what you have already booked, and tracking is against the latest actuals without exports.
- Drivers instead of accounts. Let budget owners budget headcount, hourly rate or orders, and let the model work out the accounts.
- Permissions. Each budget owner sees and changes their part, nothing else.
- The group in one place. The companies are budgeted one by one and added up, even when they run different finance systems.
How the process itself can be set up, with timeline, targets and roles, is covered in the guide on budget process with many budget owners.
How it works in Fintower
In Fintower you build the budget on what you have already booked, by company and cost center. Actuals are fetched from the finance system, such as Fortnox, Visma, Hogia or Business Central, and budget owners work on their part while management follows the whole. Permissions control who sees and changes what.
If you already have a budget model in Excel it can be uploaded and brought in, so you do not have to start over. After approval, actuals are tracked against the budget automatically and the rolling forecast is recalculated when new actuals come in. You can ask about budget and actuals in plain language, and every number traces back to account and voucher.