Microsoft Copilot Gets Accounting Skills This Week — What CPA Firms Need to Do
Microsoft Copilot Gets Accounting Skills This Week — What CPA Firms Need to Do
Microsoft 365 Copilot's accounting skills for Excel and Cowork go to general availability on November 13. If your firm has a Copilot license, you have access three days from now — no new software, no additional purchase, no Frontier preview enrollment required.
Here is what changes, what to activate, and what to check before you turn it on.
What the November 13 Release Actually Does
Three capabilities are going live:
Journal entry drafting. Copilot in Excel can draft accruals, reclassifications, allocations, reversals, and recurring journal entries. It checks that debits and credits balance before proposing anything. The entry is drafted for human review — a preparer approves or modifies before it posts. This is the work that typically takes a junior staff accountant 30–60 minutes per batch.
Bank reconciliations. Copilot reconciles entries to source records inside Excel. The structure is the same: Copilot proposes the reconciliation; a reviewer confirms before anything is finalized.
Audit trail. When enabled, Copilot generates a system-level record of each step it took: what data it accessed, what it calculated, what it proposed, what was approved or changed. The audit trail is optional by default. Turn it on.
These capabilities were in Frontier preview since mid-2026, requiring explicit enrollment. As of November 13, they are available to any user on a standard Microsoft 365 Copilot license.
Why the Audit Trail Matters More Than the Automation
The automation is useful. The audit trail is what makes it defensible.
IRS OPR Alert 2026-19 is explicit: AI may assist professional judgment, but it may not replace it. The practitioner remains professionally responsible for the accuracy of every work product. For Circular 230 purposes, "I used Copilot to draft this journal entry and reviewed it" is an acceptable workflow — but only if you can document the review.
The Copilot audit trail does that documentation for you. For each step Copilot took, it records what happened and what the human approved. If OPR ever asks how you supervised the AI-assisted work, you have a system-generated record.
For firms that have been holding off on AI because "we can't document our oversight," the November 13 release closes that specific gap. The oversight record is now automatic — but only if you enable the audit trail setting. It is not on by default.
Three Things to Do Before You Enable It
Check your license. The November 13 capabilities require a Microsoft 365 Business Standard or Premium subscription with the Microsoft 365 Copilot add-on ($21/user/month). If you are unsure whether your Copilot license qualifies, go to the Microsoft 365 Admin Center → Billing → Licenses. If you do not have the Copilot add-on, you will need to add it before November 13 to get access on day one.
Audit your Excel file permissions. Copilot inherits your firm's existing Microsoft 365 permissions. If staff have broader SharePoint or OneDrive access than they should — which is common at small firms that set up M365 years ago and never reviewed permissions — Copilot could surface one client's data while working on another's client's file. Run the M365 Admin Center permissions audit before enabling accounting capabilities. This takes under an hour and applies to all Copilot use, not just the accounting skills.
Enable the audit trail, not just the accounting capabilities. Microsoft will walk you through enabling the accounting features. It will not prompt you to turn on the audit trail — that is a separate setting you need to find and enable proactively. Under Copilot settings in Excel or Cowork, look for "audit log" or "accounting audit trail." Turn it on before the first journal entry draft runs. Retroactive enabling does not capture prior sessions.
What This Means for the Data Gap
The pattern here is the same one documented in every professional services AI category this year: the gap between "AI is installed" and "AI is connected to the data your firm uses" is where most of the value is lost.
Copilot accounting skills do not help a firm that keeps client Excel workbooks in a dozen incompatible formats with different account structures for each client. The automation works consistently when the underlying data is structured consistently. For firms with standardized client workbook templates — consistent chart of accounts layout, consistent naming conventions — the November 13 release delivers genuine time savings on day one. For firms without that consistency, the prerequisite work is not Copilot setup. It is template standardization.
This week's action is not "turn on Copilot accounting." It is: audit your most common client Excel workbook structure, identify whether it is consistent enough for Copilot to work reliably, and standardize one template if it is not.
For Firms Currently Evaluating AI Accounting Tools
If you have been evaluating CoCounsel Tax (Thomson Reuters, launched October 22) or CCH Axcess Tax agentic features (Wolters Kluwer, launched October 26), the Microsoft Copilot accounting skills launch changes the comparison set.
CoCounsel and CCH Axcess are purpose-built for accounting workflows and grounded in professional content sources — Checkpoint for CoCounsel, CCH for Wolters Kluwer. They handle more complex tax and accounting tasks and are designed for professional-grade compliance work.
Copilot accounting is different: it is inside the Excel and Cowork environment your firm is probably already using, with no new vendor relationship, no new platform to learn, and no additional subscription cost if you already have M365 Copilot. For journal entry drafting and bank reconciliations in Excel specifically, it is now a credible option.
The evaluation question is not "which AI accounting tool is best?" It is: "which part of my workflow can be addressed by tools my firm already has, and which part needs a purpose-built solution?" For firms already on M365 Copilot, the November 13 release answers the Excel question directly.
The Crossing Report covers AI adoption in professional services weekly. The November 10 issue — The Data Gap — examines the 78%/6% gap between client expectations and firm delivery across accounting, law, and staffing. Read it here.
Frequently Asked Questions
What accounting tasks can Microsoft Copilot do in Excel after November 13, 2026?
Starting November 13, 2026, Microsoft 365 Copilot in Excel and Cowork handles: journal entry drafting (accruals, reclassifications, allocations, reversals, and recurring entries — with automatic debit/credit balance checking), bank reconciliations (reconciling entries to source records), and an optional audit trail that captures each step Copilot takes when it invokes an accounting capability. These capabilities were previously gated to Frontier preview enrollment; on November 13 they go to general availability for any user with a standard Microsoft 365 Copilot license.
Does Microsoft Copilot accounting work without additional software or a new subscription?
If your accounting firm already has a Microsoft 365 Business Standard or Premium subscription with the M365 Copilot add-on ($21/user/month), no additional purchase is required. The accounting skills are included in the existing Copilot license as of November 13. During the preview phase, users needed enrollment in Microsoft Copilot Frontier — that requirement is removed at general availability.
How does the Copilot audit trail help with Circular 230 compliance for tax practitioners?
IRS OPR Alert 2026-19 requires Circular 230 practitioners to have documented AI oversight procedures — practitioners remain professionally responsible for all AI-assisted work product. When Copilot's audit trail is enabled, it generates a system-level record of each step Copilot took: what data it accessed, what calculations it performed, what entries it proposed, and what the reviewer approved or modified. This documentation addresses the 'how did you verify this?' question that OPR guidance now puts squarely on practitioners. For firms that have been hesitant to use AI because they couldn't document their oversight, the audit trail feature closes that gap.
What should a CPA firm do before enabling Copilot accounting skills in Excel?
Three checks before you turn this on: (1) Confirm your Copilot license covers it — Microsoft 365 Business Standard or Premium with the $21/user Copilot add-on. If you're unsure, check the Microsoft 365 Admin Center under 'Licenses.' (2) Audit your Excel file permissions — Copilot inherits your firm's existing M365 permissions. If staff have broader SharePoint access than they should, Copilot could surface one client's data while working on another's. (3) Enable the audit trail setting, not just the accounting capabilities. The audit trail is optional by default — turn it on proactively. It documents AI-assisted steps for professional oversight purposes and positions your firm correctly under OPR Alert 2026-19.
Is Microsoft Copilot accounting appropriate for a 10-person CPA firm, or is it enterprise-only?
The November 13 general availability release specifically drops the Frontier enrollment requirement, making it available to any firm with an M365 Copilot license — not just enterprise preview participants. A 10-person CPA firm on Business Standard with the Copilot add-on gets access to the same journal entry drafting, reconciliation, and audit trail features. The practical constraint is that the value scales with how structured your client data is in Excel. Firms with clean, consistent workbook templates will get more consistent results than firms where each client's Excel setup is different.
Get the weekly briefing
AI adoption intelligence for accounting, law, and consulting firms. Free to start.
Free weekly digest. No spam. Unsubscribe anytime.
Related Reading
- Microsoft Copilot Cowork: What Professional Services Firms Need to Know Before March 31
- You Already Pay for Microsoft 365 — Here's What Copilot Can Now Do in Word, Excel, and PowerPoint
- Microsoft 365 Copilot Pricing for Small Firms: What the June 30 Deadline Actually Means
- Microsoft's AI Maturity Report: What the Author-to-Orchestrator Gap Means for Your Firm
- Microsoft Copilot for Legal: What Small Law Firms Need to Know
This is the kind of intelligence premium subscribers get every week.
Deep analysis, cross-sector patterns, and the frameworks that help professional services firms make the crossing.