CSTI · Global News繁體中文
2026-11-13

Copilot in Excel Can Now Draft Journal Entries, with Phased Rollout Starting 13 November

Copilot in Excel Can Now Draft Journal Entries, with Phased Rollout Starting 13 November

Microsoft's message centre notice MC1536053, published 3 November, describes new accounting capabilities in Excel and Cowork. Copilot can reconcile accounts by comparing balances and transactions and preparing reconciling items. It can draft journal entries, including accruals, reclassifications, allocations, reversals and recurring entries. It can also run variance analysis and help with reporting.

Microsoft states that "nothing is posted automatically" to an ERP or system of record without user approval. Worldwide general availability began on 13 November and is due to finish by late November. It needs a Microsoft Copilot licence, and third-party accounting connectors may need separate licensing or admin enablement.

An audit trail recording what Copilot changed and why is available in Excel, but it is opt-in, and for Cowork it is still only planned. This matters because a drafted journal is still a journal, and the person who prompted Copilot is its preparer.

For SMEs, this is the most practical AI finance feature of the week. Before switching it on, decide three things. Who approves a Copilot-drafted entry, and is that person different from the one who prepared it? Is the opt-in audit trail turned on, so you can tell later which entries started with AI? And what data leaves your tenancy when a connector is used?

What does this mean for your business?

AI has reached everyday finance work: drafting entries, reconciling accounts, running variance analysis. The tool itself is not the hard part — the process is: who prepares, who approves, and how do you trace a problem afterwards. Before switching on features like this, it is worth setting the rules for approval and audit trails first. CSTI can help your business bring AI applications into existing workflows, so AI does the heavy lifting while responsibility and records stay clear.

Learn about Software Development & AI Applications →

Source · Serv365 (Microsoft 365 Message Center MC1536053)