For finance teams and the IT admins who support them, the short version is this: the tools draft work for review, Microsoft does not offer them as accounting advice, and for now an admin has to switch on access.
What Microsoft is shipping
Microsoft announced the accounting skills on October 29 as part of a wider finance push. The company said it is adding more than 25 new finance skills and partner-built plugins across Microsoft Copilot, purpose-built for accounting, capital markets, and broader finance work. The accounting skills are one part of that package.
The roadmap and the announcement describe three main workflows:
- Reconciliations: compare balances and transactions, find discrepancies, and prepare reconciling items for review.
- Journal entries: draft accruals, reclassifications, allocations, reversals and recurring entries. Copilot checks that the required inputs are present and that the entry balances.
- Reporting: compare results against plan, identify the main drivers, and draft reporting that explains what changed and why.
Microsoft says the skills also cover audit, tax, FP&A, compliance and training.
Microsoft's October roundup on the Microsoft Community Hub says the Excel version works directly in the workbook, keeping changes visible and reversible so finance professionals can review the results and retain control of final decisions. The same post says the feature rolled out to Frontier in October and rolls out worldwide in November.
Summary: these are drafting and checking tools that work inside Excel and Cowork. They do not replace your general ledger or your reviewers.
The skills in Excel
Microsoft's support documentation names the individual Excel skills. To use one, type @ followed by the skill name in your Copilot prompt. The accounting skills sit in their own Accounting folder in the Manage plugins & skills dialog. Microsoft's support page notes that accounting skills are rolling out to the Microsoft Frontier program.
| Skill | What Microsoft says it does |
|---|---|
audit-support | Plans and documents audits: sample selection, control testing, tracing transactions to source records |
budget-and-forecast | Builds budgets and forecasts from actuals and departmental inputs, including scenario analysis |
close-management | Tracks close checklists, owners, due dates and approvals; flags overdue tasks, open reconciliations and unposted entries |
compliance-support | Tests controls, reviews policy adherence, and prepares compliance workpapers and regulatory reports |
financial-statements | Builds and analyzes statements, packages, disclosures and schedules from source balances; flags significant changes or unsupported balances |
reconciliation | Matches transactions across GL, subledgers, bank statements and vendor records; identifies missing or duplicate records; proposes corrections for review |
tax-preparation | Prepares tax analyses, calculations and workpapers; tracks filing requirements and notice due dates |
variance-analysis | Explains actual vs. budget, forecast or prior-period differences by price, volume, mix, rate or timing; builds waterfall and bridge charts |
The same documentation lists a journal-entry skill under "other built-in skills." It prepares entries and supporting schedules, checks that debits and credits balance, and documents calculations and business purpose for review.
A typical request would be @reconciliation against a bank statement and the cash ledger. The skill can propose matches and flag exceptions. Someone still has to decide whether each exception really is a timing difference or a real problem.
Accounting for Cowork
In Cowork, the same capabilities come as a role-based plugin. Microsoft Learn calls it Accounting for Cowork (Frontier). You can delegate work in plain language using data from connected systems or files you supply, such as trial balances, GL and subledger detail, bank statements, invoices, budgets and supporting schedules.
The documented Cowork skills are:
accounting-root-skillbudget-and-forecastfinancial-presentationsfinancial-statementsjournal-entryreconciliationtax-preparation
To add the plugin:
- Open Cowork and go to the Customize page.
- Select the plugin.
- Review its description and skills list, then select Add.
- In a conversation, let Cowork pick a skill based on your request, or choose one yourself by typing
/or using the + menu.
If the plugin isn't available to add, Microsoft says to contact your administrator. Admins control plugin availability in the Microsoft 365 admin center under Agents > Tools.
Summary: Excel uses @-invoked skills inside a workbook. Cowork bundles them into a plugin for multistep work that can produce close packages and presentations alongside the spreadsheet.
For admins: turning on Frontier
During preview, access goes through Frontier. The relevant Message Center post is MC1536053, which pupuweb reproduced. It says during Public Preview, accounting capabilities in Excel and Cowork are available to users who have a Microsoft Copilot license and are enrolled in Microsoft Copilot Frontier.
The steps from that post:
- In the Microsoft 365 admin center, go to Copilot > Settings > Frontier, turn on Frontier, and choose whether to provide access to all eligible users or specific users or groups, such as your finance team.
- Make sure the target users have Copilot licenses assigned.
- Tell the finance team the capabilities are coming. The post itself recommends this.
According to the same post, Frontier enrollment is not required once General Availability begins. If you want only a small pilot group, scope Frontier to a group. Don't open it to the whole tenant just to reach accounting.
Two common reasons the skills don't appear:
- The user isn't covered by Frontier. They have a license, but Frontier is off or scoped to a different group.
- The rollout hasn't reached them yet. Microsoft's Excel documentation describes the skills as rolling out, so licensed and enrolled users may not all see them at once.
Success looks like this: an Accounting folder in Excel's Manage plugins & skills dialog, and Accounting for Cowork listed on the Cowork Customize page.
One budget point: Data Studios reports that Microsoft adds that some Frontier features use usage-based billing in Copilot Credits. Check your own billing terms before rolling this out widely.
The audit trail
The most useful feature for auditors is an optional audit trail. When you invoke an accounting capability in Excel, you can choose to start one, and it records in your chat history what Copilot changed and why.
The details matter here:
- It is opt-in. It isn't automatic or mandatory.
- It is available now in Excel. The roadmap says it is coming soon to Cowork.
- It is a chat-history record. It does not replace your formal workpaper documentation or your ERP's change log.
Microsoft's announcement also says Copilot in Excel can now use a workbook's edit history. It can summarize recent changes, identify who made a specific edit and when, and undo individual edits without disturbing the rest of the workbook.
About those usage numbers
Microsoft says that in seven days of limited Insiders availability, more than 8,000 unique users invoked accounting skills more than 44,000 times across more than 18,000 Copilot conversations. That shows a lot of people tried it. It doesn't show the output was right.
Ledger Lowdown made the same point, noting that Microsoft did not publish accuracy, correction, or time-savings results. Microsoft also hasn't said how many organizations took part or whether the users were mostly accountants.
The one customer quote in the announcement comes from EY Ireland's strategic reporting lead. He describes using the skills for weekly reporting, but adds that the team is still testing them. Early access counts as a promising sign, not a finished review.
Microsoft's own disclaimer
Microsoft puts the same warning on both the Excel and Cowork documentation. Copilot does not give accounting, tax, audit or financial advice. It is not a substitute for a qualified professional, and its output may be inaccurate or incomplete. Users are told to check calculations, account mappings and tax treatments against source records, applicable standards and policy before posting entries or filing returns. Microsoft's support page states plainly that Copilot in Excel doesn't replace your organization's internal controls, review, or approval processes.
In practice:
- A "balanced" journal entry only means debits equal credits. It doesn't mean the entry is correctly classified, properly supported or approved.
- A suggested reconciling item is a lead to investigate, not a sign-off.
- Copilot only works with content each user already has access to and respects sensitivity labels. That makes permissions hygiene in SharePoint and OneDrive part of your finance controls.
Where this fits
Microsoft is splitting Copilot into role-specific bundles. Legal got a plugin in October, and finance now has accounting, capital markets and corporate finance packs. Keep the release stages separate. Microsoft lists the June finance skills in Excel and the Capital Markets and Finance plugins for Cowork as generally available. The accounting capabilities are still in Frontier, with worldwide rollout targeted for November.
Here is my read, based on general industry experience rather than anything Microsoft has published. These tools are most valuable where the work is repetitive and the rules are clear: bank-to-book matching, recurring accruals, first drafts of variance commentary. They are riskiest where judgment matters: revenue recognition, tax positions and anything going into a filing. Treat Copilot like a capable first-year associate. Its drafts are fast and usually useful, and every one still needs a reviewer before it goes anywhere.
If you're piloting this, start with a reconciliation you already know well. Compare Copilot's exceptions with your own, turn on the audit trail, and track how often a reviewer has to correct the output. That error rate will tell you more than the launch usage figures.