Copilot Accounting Skills in Excel: What's New, Reconciliations, and Alternatives (2026)
Microsoft is adding accounting skills to Copilot in Excel and Copilot Cowork. The skills help finance teams reconcile accounts, draft journal entries, explain variances, and prepare financial statements. A preview is running now, and general availability starts on November 13, 2026.
This guide covers what Microsoft announced, the eight skills in the Accounting folder, how reconciliation works, and what it costs. It ends with alternatives, including a way to turn closed books into a finished report. Every detail comes from Microsoft and vendor pages read on November 9, 2026.
What Microsoft announced on November 3
Microsoft published the change in Message Center post MC1536053 on November 3, 2026. The title is "Microsoft 365 Copilot: New accounting capabilities in Excel and Cowork."
The post describes the goal in one line. The new capabilities "help finance professionals complete common accounting tasks in the tools they already use." It names accountants, AP and AR specialists, and controllers as the people affected.
The post lists four core jobs:
- Reconcile accounts. Compare balances and transactions, find discrepancies, and prepare reconciling items.
- Draft journal entries. Accruals, reclassifications, allocations, reversals, and recurring entries.
- Analyze performance. Compare results against plan and explain the drivers.
- Prepare financial reporting. Build reports and variance analysis for review.
It also says the skills support "budgeting, forecasting, audit, tax, compliance, and training." Copilot prepares the work, and people keep control of review, approval, and posting.
The eight accounting skills in Excel
Microsoft's support page on built-in skills lists eight accounting skills. They sit in the Accounting folder of the Manage plugins & skills dialog. The page says they help "manage financial close, reconcile accounts, prepare financial reports, support audits and compliance, and analyze taxes, budgets, and variances."
| Skill | What Microsoft says it does |
|---|---|
| audit-support | Plans and documents audits, selects samples, tests controls, and traces transactions |
| budget-and-forecast | Builds budgets and forecasts from actuals and department inputs |
| close-management | Tracks month-end, quarter-end, and year-end close tasks and approvals |
| compliance-support | Tests controls and prepares compliance workpapers and reports |
| financial-statements | Creates statements, reporting packages, and supporting schedules |
| reconciliation | Matches transactions across ledgers, bank statements, and vendor records |
| tax-preparation | Prepares tax analyses, calculations, and workpapers |
| variance-analysis | Explains differences by price, volume, mix, rate, or timing |
Some details stand out. The close-management skill flags "overdue or blocked tasks, open reconciliations, and unposted entries." The variance-analysis skill "creates waterfall and bridge charts." The financial-statements skill calculates dollar and percentage variances and documents adjustments for review.
These accounting skills sit next to general skills. The same page lists clean-data, which finds extra spaces, mixed formats, and duplicates. It also lists skill-builder, which saves a workflow as a custom skill.
How reconciliations work
Reconciliation is the headline use case. Microsoft's support page says the reconciliation skill works "across the general ledger, subledgers, bank statements, vendor records, and other sources."
The skill then matches transactions. It flags issues "such as missing records or duplicate entries." Finally, it prepares proposed corrections and supporting documentation for review.
Here is the typical flow, based on Microsoft's pages:
- Open a workbook with the balances or transactions you want to compare.
- Open Copilot in Excel and type @reconciliation in the prompt.
- Describe the sources, such as the ledger tab and the bank statement tab.
- Review the matched items, the flagged differences, and the proposed fixes.
- Approve the changes you agree with, and post them in your own system.
Nothing goes to your ledger on its own. The Message Center post says "Nothing is posted automatically to an ERP or system of record without approval."
Journal entries, variances, and financial statements
The other skills follow the same pattern. Copilot drafts, and a person decides.
Journal entries. The Message Center post says users can draft entries "with checks for required inputs and balanced entries." Balanced means debits equal credits. It does not mean the entry is right, so the reviewer still checks the substance.
Variance analysis. The skill compares actuals with budgets, forecasts, or prior periods. It then "drafts explanations of significant or unexplained changes for review." The waterfall and bridge charts land in the workbook.
Financial statements. The financial-statements skill builds statements and schedules "from source balances." It also identifies significant changes or unsupported balances.
Budget and forecast. This skill combines income statement, balance sheet, and cash flow forecasts. It compares plans with targets and tests assumptions and scenarios.
A month-end close example
Here is how the skills could fit one close. The company and figures are made up for illustration. The skill names and steps come from Microsoft's pages.
Maple Row Supply closes October in one workbook. The ledger tab shows a cash balance of $84,200. The bank statement tab shows $81,950. The gap is $2,250.
Day 1: reconcile cash. The controller types @reconciliation and points Copilot to both tabs. Copilot matches the transactions and flags two items. One is a $1,500 customer payment recorded twice. The other is a $750 bank fee that never reached the ledger. Together they explain the full $2,250 gap.
Day 2: draft entries. The controller asks for two entries. One reverses the duplicate payment. The other books the bank fee. Copilot checks that each entry balances. The controller reviews both and posts them in the ERP.
Day 3: explain variances. The team runs @variance-analysis against the October budget. Copilot builds a bridge chart and drafts notes on the largest changes. The controller edits the notes before they go anywhere.
Day 4: track the close. @close-management lists the open tasks, owners, and approvals left before sign-off.
The audit trail keeps a record of each change Copilot made. That record helps when an auditor asks how the cash gap was cleared.
Audit trails and controls
Finance teams care about who changed what. Microsoft added an opt-in audit trail for this reason.
The Message Center post says users "can choose to capture an audit trail when they invoke an accounting capability." When it is on, a record of what Copilot changed and why goes into the chat history. Audit trails are available in Excel now and are planned for Cowork.
Data access stays inside existing rules. Per the post, Copilot "works only with content each user can access." It respects permissions and sensitivity labels and stays within the Microsoft 365 service boundary.
The skills can also use connectors, including ones that read from or write to ERP systems. The post says the accounting capabilities do not depend on these connectors. Third-party accounting connectors may need separate licensing or admin setup.
Microsoft also adds a clear warning on its support page. It says "Copilot doesn't provide accounting, tax, audit, or financial advice or professional determinations." Teams should verify calculations, account mappings, and tax treatments against source records.
Rollout dates and who can use it
The rollout has two stages, per MC1536053:
- Public preview. Started in late October 2026 and should finish by mid-November. It needs a Microsoft Copilot license and enrollment in Microsoft Copilot Frontier.
- General availability. Starts November 13, 2026, and should finish by late November. Frontier enrollment is no longer required.
During the preview, admins turn on Frontier in the Microsoft 365 admin center under Copilot, then Settings, then Frontier. They can open it to all eligible users or to a group, such as the finance team.
To use a skill, you select the Add menu in the Copilot prompt and pick Choose plugins and skills. You can also type @ followed by the skill name, such as @variance-analysis.
Teams can also turn a good workflow into their own skill. The skill-builder skill saves the steps, the decision logic, and the expected output. A team could save its own reconciliation checklist this way and reuse it every month.
What it costs
Microsoft does not list a separate fee for the accounting skills. The Message Center post says they require Microsoft Copilot licenses. Microsoft's enterprise pricing page lists the add-on as follows.
| Plan | Price on Microsoft's pricing page | Accounting skills |
|---|---|---|
| Microsoft 365 Copilot (add-on) | $30.00 per user per month, paid yearly, or $31.50 paid monthly with an annual commitment | Included; preview needs Frontier until November 13 |
| Qualifying Microsoft 365 plan | Sold separately | Required alongside the add-on |
The page says "A separate license for a qualifying Microsoft 365 plan is required." Check your tenant's agreement, since prices can vary by contract and market.
Current limitations
The launch has clear edges. These come from Microsoft's own pages:
- The preview runs only for Frontier users until November 13.
- Audit trails work in Excel, but they are still planned for Cowork.
- Copilot does not post anything to your ERP without approval.
- Third-party accounting connectors may need extra licenses.
- Microsoft says output "might be inaccurate or incomplete" and needs review.
There is also a format question. The accounting skills work inside the workbook. A board-ready report or deck built from the same numbers still needs a separate step.
Alternatives to Copilot accounting skills
Other tools cover parts of the same job. Prices come from each vendor's page on November 9, 2026.
| Tool | Where it works | Price, per the vendor |
|---|---|---|
| Copilot accounting skills | Inside Excel and Copilot Cowork | Microsoft 365 Copilot at $30.00 per user per month, paid yearly |
| Claude in Excel | An add-in sidebar in Excel | Paid Claude plans; Pro is $17 per month with annual billing or $20 billed monthly |
| Powerdrill Bloom | Uploaded Excel, CSV, and PDF exports | Free plan; Pro $13.27/mo |
Claude in Excel. Anthropic's product page says "Claude for Excel, PowerPoint, and Word are generally available on all paid Claude plans." The Claude pricing page lists Pro at $17 per month with an annual subscription, billed as $200 up front. It is "$20 if billed monthly." It suits analysts who build models in Excel and want a general assistant in the sidebar.
The Free plan is a different story. Claude's plan comparison marks Claude for Microsoft 365 as not included on Free. You need Pro or a higher plan to use it in Excel.
Anthropic's Excel page focuses on building models and saving good workflows as skills. Teams that want Microsoft's eight named accounting skills need Copilot. Teams that mostly build and test models may prefer a general sidebar.
If your close happens in another system, there is a simpler path. Export the closed trial balance, P&L, and cash data, and build the report from those files.
Where Powerdrill Bloom fits
Reconciliation ends in a clean ledger. Month-end often ends in a document for leaders. Powerdrill Bloom works from the files you export after the close.
The AI Financial Report Generator says it builds "monthly, quarterly or board-ready financial reports — narrative, charts and an executive summary." The AI Budget Analysis Tool compares budget against actuals with driver explanations. The AI Finance Dashboard Builder covers P&L, cash, working capital, and forecast views.
The output can be a branded PDF or a deck. That covers the step after the workbook. The pricing page lists a Free plan at $0.00 and Pro at $13.27/mo.
Try Powerdrill Bloom with last month's closed P&L.
Frequently asked questions
What are the accounting skills in Copilot in Excel?
They are eight Microsoft-built skills in the Accounting folder. They cover audit support, budgets and forecasts, close management, compliance, financial statements, reconciliation, tax preparation, and variance analysis.
When do Copilot accounting skills become generally available?
Microsoft says general availability starts on November 13, 2026, and should finish by late November. Before that, the skills are in public preview for Frontier users.
Do I need a Copilot license to use them?
Yes. The Message Center post says the capabilities require Microsoft Copilot licenses. Microsoft's pricing page lists the Microsoft 365 Copilot add-on at $30.00 per user per month, paid yearly.
Can Copilot post journal entries to my ERP?
Not on its own. Microsoft says nothing is posted automatically to an ERP or system of record without approval. Copilot drafts entries, and people keep review, approval, and posting authority.
Does Copilot keep a record of what it changed?
It can. You can opt in to an audit trail when you use an accounting skill. The record of what Copilot changed, and why, goes into your chat history. This works in Excel now.
Sources: Microsoft 365 Message Center, MC1536053 · Microsoft Support, Use built-in skills with Copilot in Excel · Microsoft Support, Use skills with Copilot in Excel · Microsoft 365 Copilot pricing · Claude in Excel · Claude pricing. Details read from vendor pages on November 9, 2026.