Copilot in Excel: is AI enough to run your SME?
Back to the blog
Artificial Intelligence

Copilot in Excel: is AI enough to run your SME?

Jérémy
Jérémy
Founder & CTO
4 November 20267 min read

Copilot in Excel gets accounting features on 13 November. What AI brings to an SME, what it does not fix in a shared file, and when to move to business software.

Copilot in Excel can save an SME time on analysis: reconciling two lists of transactions, preparing an accounting entry, explaining why a margin has fallen. It does not, however, turn a workbook into management software. If your Excel file is used to analyse figures, AI is a good reinforcement. If it runs the business day to day, with five people entering data in it, AI does not fix what makes it fragile.

The question is a practical one this month. On 29 October, Microsoft announced more than 25 new finance skills for Copilot, including accounting features directly in Excel. According to the Microsoft 365 message centre, their general availability was scheduled to start on 13 November 2026 and finish at the end of November. Many managers are therefore wondering whether their Excel files, boosted by AI, can be enough for a few more years.

What can Copilot do that is new in Excel?

Microsoft is targeting finance teams first. Copilot can compare balances and transactions between the general ledger, a bank statement or a supplier file, spot discrepancies and suggest corrections. It also prepares adjusting entries or recurring entries, checking that debits and credits balance. Finally, it writes a commentary on the variances between actuals and budget.

Two safeguards are worth noting. Nothing is posted automatically to accounting software or an ERP without human approval. And in Excel, users can enable an audit trail that keeps, in the conversation history, what Copilot changed and why. Microsoft is also announcing Copilot connectors to QuickBooks, Xero and Zoho Books, which may require a separate licence.

To benefit from it, you need a Microsoft 365 Copilot licence. During the testing phase, access was through Microsoft's Frontier programme. From general availability onwards, this enrolment is no longer necessary.

For which uses is Copilot in Excel useful to an SME?

Its natural territory is the analysis file. The spreadsheet your administrative manager builds every month from accounting software exports, the cash flow forecast, the comparison of supplier prices. These files have a single owner, are used for thinking things through, and you can check the AI's result before using it.

Let us take a fictitious example. A trading SME in Rumilly exports its customer receipts and bank statements at the end of each month. Reconciling them by hand takes the accountant half a day. With Copilot, she gets a first list of discrepancies, which she then checks line by line. The time saved is real, and the decision remains hers.

Why does AI not fix the limits of a shared Excel file?

Trouble with Excel rarely comes from the formulas. It comes from how it is used: the order tracking file opened by four people, the "final version 2" copy sent by email, the column a colleague deleted without warning. Copilot works on the workbook it is given. If that workbook contains duplicates or inconsistent entries, it will analyse them with the same confidence.

A spreadsheet cannot say who is allowed to change what, either. A sales rep can overwrite a purchase price, an intern can delete an entire tab. Business software checks data entry at the moment it happens: a mandatory field, a consistent date, a customer who already exists. The error is blocked before it gets in, instead of being spotted afterwards.

Microsoft has in fact given Copilot the ability to trace a workbook's history, say who changed what and undo a specific change. That is handy. It also confirms that the shared file remains the weak point.

Accounting listings printed on continuous paper, with a pen and a calculator, on a desk next to a pair of glasses and a red binder

Photo: Cht Gsml on Unsplash

When should you move from Excel to business software?

A few signs are unmistakable. Several people enter data in the same file every day. The workbook runs an activity and not just an analysis: scheduling, quotes, stock or job site tracking. Its data has to be copied into another tool. A cell error has already cost an order or an invoice.

If you recognise yourself in two of these situations, AI will not be enough. We have detailed these thresholds in our article Excel or business software: when to switch. Your file already contains a large part of the specification: the columns, the calculations, the rules the team applies without thinking about them. That is the starting point of our method to turn your Excel file into custom software without losing what works.

It remains to choose between an off-the-shelf tool and an application developed for you. It all depends on your particularities, and our comparison business software or SaaS gives the criteria for deciding.

Can you keep Excel and Copilot alongside business software?

Yes, and it is often the best compromise. The data lives in the application, with rights by profile and checks at data entry. Excel goes back to being the analysis tool: a clean export every month, on which Copilot works without any risk of damaging the source.

You can also connect AI directly to the software, so that an assistant queries your orders or your stock without going through a file. That is the principle of an MCP server for businesses, which we presented recently. Custom software lends itself well to this, because its data is already structured.

If your business relies on one or two Excel files that are becoming hard to manage, tell us how your team uses them. From Rumilly, we will tell you frankly whether Copilot is enough or whether a dedicated tool would save you more.

Frequently asked questions

What is Copilot in Excel?

It is Microsoft's AI assistant built into Excel. It analyses a workbook, creates formulas and charts, and since autumn 2026 has offered accounting features such as account reconciliation or preparing journal entries. It requires a Microsoft 365 Copilot licence.

When are Copilot's accounting features in Excel available?

According to the Microsoft 365 message centre, general availability was scheduled to start on 13 November 2026 and finish at the end of November. Before that date, they were reserved for users enrolled in the Frontier programme.

Can Copilot replace management software?

No. It helps analyse and prepare work in a file, but it does not manage access rights by profile or checks at the moment of data entry. For a business run every day by several people, business software remains safer.

Can you turn an Excel file into an application?

Yes. The file serves as the starting point, because its columns, calculations and rules already describe the need. The existing data is then migrated into a web application with user accounts and checks at data entry.

ExcelCopilotArtificial intelligenceBusiness softwareSME

How much would your project cost?

Project type, features, timeline: a costed estimate in two minutes, with no commitment.

Estimate my budget

Is your Excel file becoming hard to manage?

Tell us how your team uses it: we will tell you frankly whether Copilot is enough or whether a dedicated tool would save you more. Ask for a quote or book 15 minutes with Jérémy.