Microsoft Copilot for Accounting Firms
It is the second week of March, a senior has forty unread client emails, two trial balances that will not tie out and an engagement letter still to send. Copilot can take real weight off that week — but only after the firm knows exactly which client folders each person can open.
Partners at small and mid-sized practices tend to ask the same thing about Microsoft Copilot for accounting firms: will it give staff hours back during busy season without creating a confidentiality problem? On a specific set of jobs it does — explaining and checking formulas in Excel workpapers, drafting engagement letters from the firm's own templates, triaging client email and recapping Teams calls. It does not replace the judgment behind an audit opinion, a review conclusion, a tax position or the advice a client pays a partner for.
The part most firms underestimate is access. Copilot answers from whatever each signed-in person can already open in SharePoint, OneDrive, Outlook and Teams, so a tenant where every client folder is shared with the whole office becomes a tenant where anyone can ask for a summary of any client. This article is the accounting-specific layer; the general implementation playbook is our Copilot rollout for small business guide, and the wider strategy work sits with our AI consulting service. It is not professional-standards or legal advice — your obligations come from your state board, your professional bodies and your own counsel.
Where Copilot helps in accounting workflows
Excel is where accountants feel the difference first. Copilot in Excel can explain what an inherited nested formula is doing, suggest a formula for a reconciliation column, highlight rows that fall outside a pattern and summarize a tab in plain language. On a workpaper someone else built three years ago, that explanation alone saves a reviewer real time — provided the file is stored in OneDrive or SharePoint, where Copilot can work with it.
Engagement letters and client correspondence are the second win. Pointed at the firm's approved template and last year's letter for the same client, Copilot produces a first draft that a manager edits rather than writes. The same applies to document request lists, extension notices and the follow-up email chasing a missing 1099. The habit worth teaching early is to name the source document, not to ask open questions about the client.
During busy season, Copilot in Outlook and Teams handles triage: summarizing a long client thread before a call, pulling open questions out of a week of email, and turning a recorded Teams meeting into a recap with owners and deadlines. None of it is glamorous, and that is the point — it is administrative weight around the professional work, not the work itself.
- Partners — catch up on a client thread before a call, draft the difficult fee or scope conversation, recap a planning meeting with deadlines.
- Managers and seniors — explain and check workpaper formulas, flag unusual rows in a trial balance export, draft engagement letters and request lists.
- Admin and client service — triage the shared inbox, draft status updates, turn intake notes into a structured task list.
| Accounting workflow | What Copilot does well | Where it stops | Human check required |
|---|---|---|---|
| Excel workpapers and reconciliations | Explains existing formulas, suggests new ones, highlights rows outside a pattern | Cannot judge materiality or whether a variance is explained | Tie every figure back to the source ledger or statement |
| Engagement letters and request lists | First drafts from the firm's approved template and the prior-year letter | Does not know your current scope, fee terms or independence status unless you supply them | Manager or partner review before the letter is sent |
| Client email and busy-season triage | Summarizes long threads, drafts replies, lists open items and missing documents | Only sees mailboxes and folders the user can already open | Read before sending; confirm nothing from another client crept in |
| Meetings and planning calls in Teams | Recaps with decisions, owners and deadlines from the transcript | Needs transcription on; cannot capture calls held outside Teams | Confirm deadlines against the firm's due-date tracker |
| Tax research and accounting standards | Explains a concept in general terms or restates guidance you provide | Can state rules that are outdated, wrong or not applicable in your state | Verify against the authoritative source before relying on it |
| Assurance conclusions and filings | Organizes notes and drafts narrative sections for a reviewer to edit | No professional judgment; not connected to tax or e-file software | The engagement team and signing partner own every conclusion |
Where it stops: judgment, assurance and filings
Copilot is a drafting and summarizing tool, not a reviewer. It cannot decide whether a misstatement is material, whether evidence is sufficient and appropriate, or whether a going-concern question needs to be raised. Those conclusions belong to the engagement team and the partner who signs, and the workpapers have to show a person reached them. An AI summary is not audit evidence and should never be filed as if it were.
Any language model can be confidently wrong. It can misread a column, assume a sign convention, or state a tax rule that has changed or never applied to your client's state. Treat every number it produces as unverified until someone ties it to the source, and every statement about tax law or accounting standards as a prompt to check the authoritative guidance rather than as the guidance itself.
Copilot also does not prepare or submit regulatory filings. It is not connected to tax preparation software, e-file systems or your practice management platform unless someone builds that connection deliberately. Client advisory is the same: Copilot can organize the numbers for a planning conversation, but the recommendation, and the professional responsibility for it, stays with a credentialed person who knows the client.
Permission and data-governance work that must happen first
Copilot cannot give anyone access they did not already have; the risk is discovery. A staff accountant who could technically open the controller's payroll folder, or another client's tax return, would rarely stumble on it by browsing. With Copilot, one broad question can surface a tidy summary of it. In a firm that holds Social Security numbers, bank details and payroll for hundreds of clients, that is the scenario to engineer out before the first license.
Engagement segregation is the core of the cleanup. Client files should live in sites or libraries with private membership, organized by client or engagement, with no organization-wide sharing links. Partner-only material — firm financials, compensation, HR files, client disputes — needs its own restricted location. Where an engagement team must be walled off, such as an attest client that another team advises, Microsoft Purview information barriers can enforce the separation, and Copilot respects it.
Sensitivity labels on files that hold tax return information, payroll data or bank details add protections that travel with the document. Restricted SharePoint search can narrow what Copilot reaches while remediation is underway, and Purview audit should be on so Copilot interactions are logged under the firm's retention policy. If your firm is subject to rules on the use and disclosure of tax return information, have counsel confirm how they apply before rollout.
- Client folders — one site or library per client or engagement, private membership, organization-wide links removed.
- Partner-level controls — firm financials, compensation and HR in a restricted site that staff accounts cannot reach.
- Engagement walls — information barrier policies where attest and advisory teams must stay separate, tested with a test account before launch.
- Labels and audit — sensitivity labels on tax, payroll and banking files; Purview audit on with retention matching your records policy.
A rollout sized for a small practice
Timing matters more in accounting than in most industries. Starting a pilot in late February guarantees nobody has time to learn the tool and every shortcut gets taken. The better window is the quieter stretch after the extension deadlines, so the permission cleanup happens when people can answer questions about who needs which folder, and staff build habits before the next busy season arrives.
All of this work is done remotely. A sensible sequence is a review of licensing, identity and how client files are actually stored, then remediation of sharing and engagement segregation, then a pilot of a few named people — typically a partner, a manager and someone from client service — each with one or two concrete jobs. After real use, review the usage reports and decide who gets a license next.
Further reading: Microsoft Learn — data, privacy and security for Microsoft 365 Copilot.
Not sure if this is the right fit?
Book a free 30-minute call with Edward Pinela, MBA. If it is not the right fit, you will be told that on the call.
Frequently asked questions
Does Copilot use our client data to train Microsoft's AI models?
Microsoft states that prompts, responses and data accessed through Microsoft Graph in Microsoft 365 Copilot are not used to train the foundation models. Read Microsoft's current privacy documentation yourself and keep a copy on file, because terms can change and your counsel or a client's due-diligence questionnaire will want the source rather than a summary.
Can Copilot check our Excel workpapers for errors?
It can help. Copilot in Excel explains formulas, suggests corrections and highlights values that break a pattern, which speeds up a reviewer's first pass. It cannot tell you whether the workpaper supports the conclusion, and it can misread a layout it does not understand. Treat its output as a second set of eyes, not as review sign-off.
Will a staff accountant be able to see another client's files through Copilot?
Only if they can already open those files today. Copilot respects SharePoint, OneDrive and Teams permissions, sensitivity labels and Purview information barriers. The problem is that many firm tenants share client folders far more widely than anyone realizes, so the access review and cleanup has to come before licenses are assigned.
Can Copilot prepare or file tax returns?
No. Copilot is not connected to tax preparation or e-file software, and it does not make tax positions. It can draft the client email requesting missing documents, summarize a client's notes and organize a planning conversation. The return itself, and every judgment in it, stays with the preparer and reviewer.
When should an accounting firm start a Copilot pilot?
After busy season, not during it. A pilot needs people with time to learn the tool and a permission cleanup that requires partners to answer questions about who needs which client folder. Starting in the quieter months means the firm arrives at the next filing season with habits in place rather than experiments.
Should every staff member get a license at once?
No. Licenses are assigned per user and can be moved, so start with a few named people who handle heavy volumes of email, workpapers and drafting. Real use over a couple of months tells you more than any demo, and a small pilot keeps verification habits easy to supervise.
Talk it through with a senior consultant
Book a free 30-minute call with Edward Pinela, MBA. No obligation and no sales pitch — just an honest read on whether this is the right fit.
Prefer to call? +1 (714) 872-9606