Copilot Can Now Reconcile Accounts in Excel. Here's the Catch for Small Business.
This is the first episode of AI This Week, Checked. The idea is simple: take one AI headline that matters to a small business, go to the primary source, and tell you what is real, what is not yet, and what to do about it.
Episode one is Microsoft Copilot doing accounting work inside Excel. I recorded the Short a few weeks ago. Since then the rollout has moved, so I re-checked every claim against Microsoft's own pages on November 17, 2026. Where things changed, I say so below.
What Microsoft announced
On Thursday, October 29, 2026, Microsoft announced more than 25 new finance skills and partner-built plugins across Microsoft Copilot. The part that matters most for a small business is a set of new accounting capabilities in Copilot in Excel and in Cowork (the part of Copilot that takes on longer, multistep tasks).
Microsoft describes three headline capabilities:
Reconcile accounts. Copilot compares balances and transactions, identifies discrepancies, and prepares reconciling items for review.
Prepare journal entries. It drafts accruals, reclassifications, allocations, reversals, and recurring entries, with checks for required inputs and balanced entries.
Turn results into reporting. It analyzes performance against plan, identifies key drivers, and prepares reporting that explains what changed and why.

Microsoft also shared an early number. In seven days of limited Insiders availability, more than 8,000 unique users invoked the accounting skills more than 44,000 times, across more than 18,000 Copilot conversations. That tells you people are trying it. It does not tell you how accurate it is, and Microsoft does not claim that it does.
What changed since the Short
In the Short I said the accounting skills were in Frontier, Microsoft's early access program, and that an administrator had to turn Frontier on. That was true when I wrote it. Here is where it stands today.
General availability has started. Microsoft's message to Microsoft 365 administrators (MC1536053) says general availability began rolling out worldwide on November 13, 2026, and is expected to finish by late November 2026.
Frontier is no longer required. The same message says that starting with general availability, Frontier enrollment is not required.
A Copilot license still is. Users need a Microsoft Copilot license to get the accounting capabilities.
Your tenant may not have it yet. Rollouts land in waves, and Microsoft's own Excel support page still says the accounting skills are rolling out to Frontier. So if you do not see them this week, that is expected.
How to check: open Copilot in Excel, select the Settings menu (the three dots in the upper right), choose Manage plugins & skills, and look for the Accounting folder.
The skills, by name
Microsoft's Excel support page lists eight skills in the Accounting folder. You can call any of them by typing @ and the name in your prompt, for example @reconciliation.
Skill | What Microsoft says it does, in plain terms |
reconciliation | Compares the ledger, bank statements, vendor records and other sources, flags missing or duplicate items, and proposes corrections for review |
variance-analysis | Compares actuals to budget, forecast or last period and drafts explanations of the differences |
close-management | Tracks month-end, quarter-end and year-end close tasks, owners, due dates and approvals |
financial-statements | Builds and analyzes statements and supporting schedules from source balances |
budget-and-forecast | Builds budgets and forecasts from actuals and department inputs |
audit-support | Helps plan and document audits, select samples and track findings |
tax-preparation | Prepares tax analyses, calculations and workpapers |
compliance-support | Helps test controls and prepare compliance workpapers |
The same page lists a built-in journal-entry skill that prepares entries and checks that debits and credits balance.

The guardrails Microsoft built in
This is the part I would read twice if you are the one responsible for the books.
Audit trail, now in Excel. In the Short I said it was coming. Microsoft now says the audit trail is available in Excel and planned for Cowork. When you call an accounting skill you can choose to start one, and Copilot records in your chat history what it changed and why.
Nothing posts on its own. Microsoft says nothing is posted automatically to an ERP or system of record without user approval.
It only sees what you can see. Copilot works only with content each user can already access and honors existing permissions and sensitivity labels.
Your data does not train the model. Microsoft says it does not use prompts, responses, or documents to train the underlying foundation models.
It is not your accountant. Microsoft's support page says Copilot does not provide accounting, tax, audit, or financial advice, is not a substitute for a qualified professional, and that you should review and verify all output before you post entries, file returns or share financial information.

That last point is the whole story in one line. Copilot drafts. A person signs off.
The catch, updated
The catch is still the plugins, because most small business books do not live in Excel. They live in QuickBooks, Xero or Zoho Books.
Microsoft named Intuit QuickBooks, Xero and Zoho Books as accounting partners, plus Mercury for business banking. Here is what I can confirm today:
Xero and Mercury appear on Microsoft's published list of available Copilot Cowork plugins (last updated November 13, 2026). Xero announced its Microsoft 365 Copilot integration back in July, and Mercury lists Microsoft 365 Copilot as an official integration.
QuickBooks is not on that list as I write this, and I could not confirm the QuickBooks plugin is live yet. If you run QuickBooks, do not promise your team anything until you see it in your own tenant.
Expect extra steps. Microsoft says third-party services may require separate licensing, subscriptions, authentication, or administrator enablement from the provider. Plan on two approvals: your Microsoft administrator allowing the plugin, and a sign-in on the accounting system's side.
One more note if you turned Frontier on early to get a head start. Microsoft says Frontier features are previews that may change and do not comply with ISO 27001, ISO 27002 or ISO 27018. If you have promised those standards to your own clients, check with whoever owns that promise before you leave preview features on for the finance team.
Three steps before anyone points it at your books
Step one. Check before you promise. Find out who has a Copilot license, and whether the rollout has reached your tenant yet (look for the Accounting folder in Manage plugins & skills).
Step two. Decide who approves plugins. A QuickBooks or Xero plugin connects your books to Copilot. Pick one person who approves it, and write down what data it can reach, before anyone turns it on.
Step three. Test it on last month. Run one month's reconciliation side by side with your bookkeeper. Turn on the audit trail and compare the results line by line. Copilot drafts. A person signs off.
If you are an MSP
Your clients are going to ask about this, probably right after a vendor demo. A few things I would do now:
Add a line to your client reviews: Copilot licenses, rollout status, and who approves finance plugins.
Treat an accounting plugin like any other app that touches money. It gets an owner, a written data scope, and a review date.
Offer the side-by-side test as a project, not a promise. The bookkeeper stays in charge of the final number.
Watch and share
If you want a second set of eyes on your Copilot rollout or your plugin approvals, we are happy to talk shop at hello@chibitek.com.
We make IT effortless so you can create, disrupt, and grow!
Sources
Microsoft Support, "Use built-in skills and skills created by Microsoft with Copilot in Excel"
Microsoft Support, "Use skills with Copilot in Excel to complete repeatable tasks"
Microsoft Learn, "Available plugins for Copilot Cowork" (updated Nov 13, 2026)
Microsoft Learn, "Get started with the Microsoft Frontier Program"
CPA Practice Advisor, "Microsoft Touts New Accounting Capabilities for Copilot" (Oct 30, 2026)
Xero media release, "Xero Launches Integration with Microsoft 365" (Jul 1, 2026)








Comments