What Copilot gets right for accounting firms (that the AI crowd won't admit)
The AI commentary crowd treats Microsoft Copilot as the boring choice, yet it keeps winning accounting firm deployments, often for rational reasons. This piece makes the honest steelman case: where Copilot genuinely beats the frontier tools for firms, where it runs out of road, and how to get more from a licence you may already be paying for.
Trent McLaren · 22 July 2026 · 10 min read
In this article
- The five things Copilot genuinely does better
- 1. It clears IT and risk sign-off in one meeting
- 2. Excel help where the work actually lives
- 3. Outlook triage that pays for itself in a week
- 4. Meeting recaps in Teams, without a third wheel
- 5. Zero-new-tool rollout
- Where it runs out of road
- Who should default to Copilot
- Getting more out of a Copilot licence you already pay for
- Frequently asked questions
- What does Microsoft Copilot cost for an accounting firm?
- Is client data safe in Microsoft Copilot?
- Copilot vs ChatGPT for accountants: which is better?
- Does Copilot work with Xero or QuickBooks?
- Do small accounting firms actually need Copilot?
Part of our AI in accounting coverage. See the full AI for accounting firms guide →
Here's an awkward truth for everyone (us included) who spends their days writing about frontier AI: Claude and ChatGPT get the headlines, and Copilot gets the deployments.
Scroll accounting Twitter or LinkedIn and you'd think every firm is running agentic workflows in Claude, spinning up custom GPTs, and automating half the practice. Then you talk to actual firm owners and a different picture emerges, one our own coverage keeps bumping into. When we looked at Copilot adoption in Australian accounting firms, the striking thing wasn't the productivity data. It was how many firms had quietly standardised on Copilot without any of the fanfare that surrounds the frontier tools.
The AI crowd's explanation is usually some version of "IT departments are lazy" or "firms don't know better." That's condescending, and mostly wrong. Firms are choosing Copilot for reasons that are often rational. If you're going to argue against it (which, in plenty of cases, you should), you need to understand what you're arguing against first.
So here's the steelman. No Microsoft brochure copy, no affiliate links, and a straight section on where it falls over.
The five things Copilot genuinely does better
1. It clears IT and risk sign-off in one meeting
This is the big one, and it's the one the AI commentary crowd consistently underrates because most of them have never sat through a professional indemnity insurance renewal.
Microsoft 365 Copilot runs inside your existing tenant. Your prompts, the documents it reads, and its responses stay within the Microsoft 365 service boundary. Microsoft states that this data is not used to train its foundation models. Copilot only surfaces content the individual user already has permission to see, because it rides on your existing Microsoft 365 access controls. And if you use Microsoft Purview, sensitivity labels carry through: content generated from a labelled document inherits the label and its protection settings, and DLP policies can block sensitive content from reaching Copilot at all.
Now picture the alternative conversation: a partner wants the team using a third-party AI tool. Cue a new vendor security review, a data processing agreement, questions from the PI insurer, a debate about which staff paste what into which browser tab, and a policy document nobody reads. For a Copilot rollout at a firm already on Microsoft 365, most of that work is already done. Same tenant, same compliance boundary, same admin centre.
Is "easiest to approve" the same as "best"? No. But when the realistic alternative at many firms is staff pasting client trial balances into free consumer chatbots (which is what actually happens when you don't give people a sanctioned option), the firm that ships a governed, boring tool beats the firm still debating the exciting one.
2. Excel help where the work actually lives
Every accountant's real IDE is Excel, and Copilot is the only major AI assistant that works inside it rather than beside it.
The concrete scenario: a senior has a client's 4,000-row general ledger export formatted as a table. Copilot can suggest the XLOOKUP or SUMIFS she half-remembers, add a conditional formatting rule to flag negative balances, build a pivot summary, and explain what a crusty inherited formula actually does, without the data ever leaving the workbook. No export, no paste, no "wait, did I just send client data to a browser tab?"
The caveats are real and we'll get to them below: Copilot needs clean, structured tables to perform, and its formula suggestions need review. But "AI assistance at the point of work, inside the compliance boundary" is a genuinely different product to "AI assistance in another window," and for the median staff member it's the difference between using it daily and never using it at all.
3. Outlook triage that pays for itself in a week
Ask firm owners where Copilot actually sticks and the answer is rarely glamorous: it's email. Summarise this 30-message thread with the client, their bookkeeper, and the bank. Draft a reply that says no politely. Catch me up on what I missed while I was in back-to-back client meetings.
For a partner receiving well over a hundred emails a day through busy season, thread summarisation alone is worth a meaningful slice of the licence fee. It's not clever. It doesn't demo well at a conference. It just quietly returns twenty minutes a day to the people whose time the firm bills at the highest rate.
4. Meeting recaps in Teams, without a third wheel
If your firm already runs client and internal meetings through Teams, Copilot's intelligent recap gives you summaries, action items, and speaker-indexed notes from any transcribed meeting, with no external notetaker bot joining the call, no separate vendor holding your client conversations, and no awkward "do you mind if my AI joins us?" moment. The recording and transcript live where your other client data already lives.
The scenario writes itself: quarterly advisory call with a client, 45 minutes, three commitments made. The recap catches all three, assigns them, and the follow-up email drafts itself in Outlook from the same material. Firms have paid for standalone tools that do exactly this and nothing else.
5. Zero-new-tool rollout
Rolling out software to accountants is famously miserable. Copilot's quiet advantage is that there's nothing to roll out: no new login, no new interface, no "where do I find it" tickets. It appears inside Word, Excel, Outlook, and Teams, which your staff already live in.
Change management is the tax every firm pays on every tool, and most AI evangelists price it at zero. Firm owners know it's often the largest line item. A 20-person firm can turn Copilot on for a pilot group on Monday and have real usage data by Friday, with no training day and no champion programme. As we covered in how firms are actually using Copilot, the adoption curve looks nothing like a typical practice-tool rollout, because there's nothing new to adopt.
Where it runs out of road
Now the part the Microsoft partner channel won't tell you.
Deep reasoning is not its game. Put a complex Division 7A scenario, a multi-entity restructure, or a 90-page loan agreement in front of Copilot and then put the same task in front of a frontier chat tool, and the difference is obvious within a paragraph. In our Copilot vs Claude comparison, this was the consistent pattern: Copilot is an assistant for the work around the work; the frontier tools are better at the work itself. Long-document analysis, technical research, first-draft advisory letters with actual reasoning in them. That's where the gap lives.
Excel formulas still need checking, line by line. Copilot can and does produce plausible-but-wrong formulas, and it degrades quickly on messy real-world workbooks: merged cells, inconsistent headers, the stuff clients actually send you. Notably, Microsoft's own documentation for its Copilot capabilities in Excel warns against relying on them for tasks requiring accuracy or reproducibility. Take Microsoft at its word. As we've said before: no AI is ever going to jail for you, and that includes the one Microsoft sold you.
It's not agentic. Copilot summarises, drafts, and answers. It does not reliably chain multi-step work: pull these three reports, reconcile them, flag exceptions, draft the queries. The frontier tools are moving fast on exactly this; Copilot's equivalents (agents built in Copilot Studio) exist but are a separate build-it-yourself proposition, not something a firm gets out of the box.
Sloppy permissions become a Copilot problem. Because Copilot surfaces anything a user can technically access, firms with years of loosely-permissioned SharePoint sprawl discover that "can technically access" includes things nobody realised: partner comp spreadsheets, HR files, the M&A folder. The security model is sound; it's your tenant hygiene it faithfully reflects. Budget a permissions review before rollout, not after the first awkward search result.
Who should default to Copilot
Firms of 10-100 staff already on Microsoft 365, with no AI policy and no AI champion: default to Copilot, at least for a licensed pilot group. A governed tool people actually use beats an ungoverned better one they use in secret.
Firms with strict client confidentiality obligations or nervous PI insurers: Copilot's tenant-grounding story is the easiest to defend in writing. Start there, expand later.
Firms doing serious advisory work who want AI leverage on the technical product itself: Copilot alone will disappoint you. Run it for the email-calendar-meetings layer and pair it with a frontier tool (under a business plan with training opt-outs, not free consumer accounts) for research and drafting. The two-tool stack is where most firms land: our three-way Claude vs ChatGPT vs Copilot comparison makes the full case, and our guide to AI for accounting firms covers how to structure it.
Google Workspace firms: this entire article is not for you. Copilot's case collapses without the Microsoft stack underneath it.
Getting more out of a Copilot licence you already pay for
- Licence by inbox gravity, not seniority. The people drowning in Outlook and Teams (partners, managers, client-facing seniors) see value in week one. Juniors who live in the ledger software, not so much.
- Check the free tier first. Microsoft 365 users get Copilot Chat with enterprise data protection at no extra cost: web-grounded chat, without the deep Office and tenant-data integration. For lighter users, that may be enough, and it sharpens the question of who genuinely needs the paid seat.
- Turn on transcription policies before your first "recap this meeting" attempt. Intelligent recap depends on transcription being enabled in your Teams admin policies. Most disappointing first impressions trace back to this.
- Format Excel data as tables. Copilot's Excel performance improves dramatically on structured tables with clean headers. Ten minutes of formatting discipline is the highest-ROI Copilot training you can give staff.
- Run a permissions audit. Use a pilot group's Copilot searches as a canary for oversharing, and fix SharePoint access before firm-wide rollout.
- Review usage at 90 days and cull. The adoption data in your admin centre will show a chunk of licensed users barely touching it. Reallocate those seats. At roughly US$30 a month each, empty seats are the quietest waste in the budget.
Frequently asked questions
What does Microsoft Copilot cost for an accounting firm?
Microsoft 365 Copilot is an add-on priced at around US$30 per user per month (roughly A$45-50 in Australia), on top of a qualifying Microsoft 365 licence such as Business Standard, Business Premium, E3, or E5. Budget the full stack, not just the add-on. Microsoft has also introduced bundled and lower-priced SKUs over time, and pricing varies by region and agreement, so confirm current terms with your reseller. A free Copilot Chat tier with enterprise data protection is included for Microsoft 365 users.
Is client data safe in Microsoft Copilot?
Safer than most alternatives your staff will otherwise use. Prompts and responses stay within your Microsoft 365 tenant's service boundary, are not used to train Microsoft's foundation models, and respect your existing file permissions. Purview sensitivity labels and DLP policies extend to Copilot. The real risk isn't Microsoft's architecture. It's your own permissions hygiene, because Copilot will surface anything a user can technically already access. Audit access before rollout.
Copilot vs ChatGPT for accountants: which is better?
Different jobs. Copilot wins for work inside Microsoft 365: email triage, meeting recaps, Excel assistance, and anything where the compliance boundary matters. ChatGPT and Claude are stronger for deep reasoning: technical research, long-document analysis, and advisory drafting. Many firms land on both: Copilot as the governed default for everyone, a frontier tool on a business plan for the advisory and research heavy-lifters. See our full Copilot vs Claude comparison.
Does Copilot work with Xero or QuickBooks?
Not natively, and be sceptical of anyone implying otherwise. Copilot reads what's in your Microsoft 365 tenant, so it can work with reports you export from Xero or QuickBooks into Excel, but it can't query your ledger directly out of the box. Custom connections are possible via Copilot Studio agents and connectors, but that's a build project, not a toggle. For most firms today, the honest workflow is export-then-analyse.
Do small accounting firms actually need Copilot?
Need? No. A sole practitioner or five-person firm may get more value from a US$20-30/month frontier chat subscription with training opt-outs enabled. Copilot's advantages (governance at scale, zero-rollout deployment, tenant-wide security inheritance) compound with headcount. The crossover point is roughly where you stop knowing exactly what every staff member is pasting into which tool. For many firms, that arrives earlier than they'd like to admit.
AIPractice Technology