MC1536053 - Microsoft 365 Copilot: New accounting capabilities in Excel and Cowork
Microsoft 365 Message Center announcement MC1536053.
MS Message Center's Summary
Microsoft is introducing accounting functions within Excel and Cowork for finance professionals to handle reconciliations, journal entries, and reporting using Copilot. General availability is scheduled to start on November 13, 2026, while a public preview is currently available through the Frontier program. Administrators should review licensing requirements and prepare finance teams for these new capabilities.
- Administrator impact
- Administrators should assign necessary Copilot licenses and optionally configure Frontier settings during the preview phase.
- End user impact
- Finance professionals with Copilot licenses gain generative artificial intelligence tools within Excel and Cowork to streamline accounting tasks.
- Importance
- 4/10: This is a feature addition that provides new capabilities for specific user groups without introducing mandatory actions or service disruptions.
Available plugins for Copilot Cowork
Microsoft Summary
Microsoft 365 Copilot introduces new accounting features in Excel and Cowork for finance professionals to reconcile accounts, prepare journal entries, analyze performance, and support budgeting and compliance. Available from late October 2026 (preview) and November 13, 2026 (general availability), it requires Copilot licenses and respects data permissions.
- Message Center ID
- MC1536053
- Category
- stay Informed
- Severity
- normal
- Services
- Microsoft 365 apps, Microsoft Copilot (Microsoft 365)
- Tags
- New feature, User impact, Admin impact
- Published
- 2026-11-03
- Last updated
- 2026-11-03
- Expires
- 2027-01-25
[What and why] New accounting capabilities in Copilot in Excel and Cowork help finance professionals complete common accounting tasks in the tools they already use. Users can reconcile accounts, prepare journal entries, analyze financial performance and variances, and prepare financial reports. Additional capabilities support budgeting, forecasting, audit, tax, compliance, and training. Copilot prepares the work while users retain control of review, approval, and posting. Nothing is posted automatically to an ERP or system of record without approval. [Rollout schedule] Public Preview: We will begin rolling out in late October 2026 and expect to complete by mid-November 2026 General Availability (Worldwide): We will begin rolling out on November 13, 2026, and expect to complete by late November 2026 [Impact on your organization] Who is affected Accountants, AP/AR specialists, controllers, and other finance professionals with a Microsoft Copilot licenses Platforms and services Microsoft Copilot Microsoft Excel Cowork What will happen Users can reconcile accounts by comparing balances and transactions, identifying discrepancies, and preparing reconciling items for review. Users can draft journal entries, including accruals, reclassifications, allocations, reversals, and recurring entries, with checks for required inputs and balanced entries. Users can analyze financial performance against plan, identify key drivers, and prepare financial reporting and variance analysis. Additional capabilities support budgeting, forecasting, audit, tax, compliance, and training. In Excel and Cowork, finance professionals can choose to capture an audit trail when they invoke an accounting capability. When selected, a record of what Copilot changed and why is created in their chat history. Audit trails are currently available in Excel and are planned for Cowork. Copilot works only with content each user can access, respects existing permissions and sensitivity labels, and stays within the Microsoft 365 service boundary. Nothing is posted automatically to an ERP or system of record without user approval. Accounting capabilities can use connectors as separate sources, including sources used to read from or write to ERP systems. The accounting capabilities do not depend on these connectors. Third-party accounting connectors may require separate licensing or admin enablement. [Action required and recommendations] Action required: 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. Beginning with General Availability on November 13, 2026, Frontier enrollment will not be required. To provide access during Public Preview: Assign Microsoft Copilot licenses to finance users who need access. 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. Enroll your admin account in Frontier if you need to see and manage Frontier features such as Cowork in the admin center. Consider notifying your finance teams about the new accounting capabilities. Learn more Available plugins for Copilot Cowork | Microsoft Learn Microsoft Copilot for finance: Purpose-built for the way finance teams work | Microsoft Copilot Blog Use built-in skills and skills created by Microsoft with Copilot in Excel | Microsoft Support Explore AI Early Access in Microsoft 365 | Microsoft Frontier Get Started with Frontier for IT Admins | Microsoft Frontier [Compliance considerations] Question Answer Does the change introduce or significantly modify AI/ML or agent capabilities that interact with or provide access to customer data? Yes. The new accounting capabilities use Microsoft Copilot to perform accounting-related work using content the user can access. Does the change provide end users a new way of interacting with generative AI? Yes. Finance users can use Copilot accounting capabilities in Excel and Cowork for reconciliation, journal entries, analysis, and reporting.