Microsoft Wants Copilot to Help Accountants Close the Books in Excel
Accounting teams spend a huge chunk of every quarter reconciling ledgers, writing journal entries, and collecting audit proof in spreadsheets. On October 29, 2026, Microsoft announced a big expansion of Microsoft 365 Copilot and its Copilot for Finance. It adds special accounting tools and ERP plugins inside Excel. ERP means the big software companies use to run money, supplies, and operations. So Copilot is moving past just writing formulas, and Microsoft wants it to help prepare month-end close materials and financial reports.
How it works
Microsoft’s announcement says the new accounting tools in Copilot in Excel are rolling out as an early-access preview, while broader finance skills in Excel are generally available to enterprise customers.
Here’s what’s behind it:
- Company knowledge: Copilot can pull from stuff outside the spreadsheet, like close calendars, internal policies, and deal team conversations, through Microsoft Graph and Work IQ.
- ERP and partner plugins: Microsoft started rolling out a Dynamics 365 ERP apps plugin, which brings finance and operations data into Copilot and Excel. More partner plugins are starting to roll out too, to connect outside financial data.
- Reusable skills: You can show Excel a process once, and it saves those steps so you can reuse them next time.
It’s meant for three main jobs. First, it compares ledger balances with transaction logs, finds the differences, and makes reconciliation schedules for a person to check. Second, accountants can draft accruals, allocations, reversals, and recurring journal entries, with checks that debits and credits balance. Third, it compares results to the budget, finds what drove revenue, and builds variance reports.
How it compares
This part is our own opinion. Microsoft’s plan looks different from stand-alone close tools like BlackLine, FloQast, and Workiva, which run their own workflows outside spreadsheets. Microsoft seems to be betting that finance teams would rather stay in Excel than learn a new app.
The downsides
Accounting needs everything to be checkable, because AI mistakes can cause penalties and big money errors. Microsoft added an optional audit trail in Excel that records what Copilot changed and why in the chat history. But senior controllers still have to check every AI-written journal entry before it goes into the ERP. So the work shifts from typing data to double-checking it, right when the close deadline is tight.
Licensing is also kind of messy. Core Excel finance skills come with Microsoft 365 Copilot licenses, the advanced accounting tools are still in early access, and outside partner plugins might need separate subscriptions.
What’s next
With the rollout starting in early preview, accounting leaders have to decide soon how to use it. Connecting ERP tools right into daily spreadsheets is great for speed, but teams still need strong human sign-off.