How Accountants Are Actually Using Microsoft Copilot (10 Practical Use Cases)

There is a gap between what Microsoft says Copilot can do and what accountants are actually doing with it in practice. The marketing talks about transforming productivity, but the reality in most practices is that people tried it once, got a mediocre response and went back to doing things the way they always have. That is not a Copilot problem, it is a prompting and training problem, and when accounting teams learn to use Copilot with the right approach the results are genuinely useful and consistently good enough to save real time on the work that fills their week.

These are ten use cases we see working when we deliver Copilot training to accounting firms, including a recent rollout across the whole of Goodman Jones LLP. They are not theoretical possibilities but things people are doing after their first session and continuing to use in the weeks that follow.

1. Summarising Client Email Threads Before Meetings

This is the one that gets the biggest reaction in every session we deliver. Before a client meeting, an accountant can ask Copilot to summarise everything relevant from recent emails, pulling out the key decisions, outstanding questions and action items. The prompt that works best is one where you give Copilot context about why you need the summary, something like "Summarise my recent email correspondence with [client name] ahead of our meeting this afternoon, focusing on outstanding questions, agreed actions and anything I need to follow up on." That preparation used to take 20 minutes of scrolling through Outlook and now it takes one prompt, which for fee earners managing 20+ active clients adds up to hours saved every week.

2. Drafting Management Accounts Commentary

Every reporting cycle, someone in the team sits down to write management accounts commentary and it follows a predictable structure: revenue performance, cost movements, margin analysis, key variances and outlook. Yet it gets written from scratch every time. Copilot can draft this from prior period examples and the underlying data, giving your team a strong first draft to review and refine rather than staring at a blank page. The tone stays professional, the structure stays consistent and the time saving compounds across every reporting cycle. The key is uploading a previous example so Copilot understands the format your practice uses, because generic prompts produce generic output while specific prompts with reference material produce something your team actually recognises.

3. Analysing WIP Data in Excel

For accounting teams who live in Excel, Copilot adds a natural language layer on top of the spreadsheets they already use. Instead of building pivot tables and writing SUMIFS formulas manually, your team can describe what they want in plain English. Prompts like "Create a PivotTable to analyse charges by task code and surname" or "Calculate the total for each task code" or "Create a pie chart showing the percentage of total charges for each person" are ones we use in our training sessions and they produce genuinely useful output within seconds. For practices dealing with WIP reports, time analysis and billing reconciliations, this is where the daily time saving is most noticeable because people who were spending 30 minutes building a report are getting a solid first version in under a minute.

4. Agent Mode in Excel

If your team has access to Agent Mode in Excel, it is worth exploring because it goes well beyond single prompts. Agent Mode plans, executes and validates multi-step tasks directly in the grid, building models, reshaping tables and creating charts through transparent, editable steps that you can review as they happen. For accountants working with financial data, Agent Mode can handle more complex requests like "Analyse this trial balance, identify the top 10 variances compared to prior year, and create a summary table with a chart" and it works through the task step by step, showing you what it is doing at each stage so you can intervene if anything looks off. Agent Mode also includes a model switcher that lets you toggle between different AI models depending on the complexity of the task, and our Copilot training covers when and why to use different models so your team knows how to get the best output for different types of work.

5. Drafting Engagement Letters and Client Documents

Engagement letters, proposals, letters of representation, internal memos and client-facing reports all follow templates but still require manual customisation for each client. Copilot in Word drafts documents using your existing templates and organisational content, producing consistent output that your team edits rather than writes from scratch every time. We have seen this work particularly well for practices that have invested in getting their templates right, because the better your templates and prior examples the better Copilot's output. We helped Goodman Jones automate their engagement letter and letter of representation workflows using Power Automate and Dynamics 365, and Copilot training builds naturally on top of that kind of foundation by giving staff the skills to generate and refine documents even faster.

6. Meeting Notes and Action Items from Teams Calls

If your practice uses Microsoft Teams for client calls or internal meetings, Copilot can generate structured meeting summaries with action items and next steps from the recording and transcript. This works with any Teams meeting where recording or transcription is enabled, and nobody needs to do anything special to make it happen because Copilot processes the transcript and meeting content automatically. After a client meeting it pulls together who attended, what was discussed, what was decided and what needs to happen next, which means your team spends less time writing up attendance notes and more time on the work that actually matters.

7. Catching Up After Being Heads-Down on a Deadline

Accountants are frequently deep in focused work, whether that is audit prep, tax season or year-end, and when you come up for air after a few hours heads-down the process of catching up on what you missed can take longer than the focused work itself. Copilot in Outlook summarises long email threads, flags what needs attention first and drafts replies in the right tone, while in Teams it catches you up on channel conversations and messages you missed. A prompt like "Summarise what I missed in the last 3 hours across my emails and Teams" gives you a briefing in seconds rather than 20 minutes of scrolling through everything manually.

8. The Researcher Agent for Regulatory Changes

Copilot includes built-in agents that go beyond basic chat, and the Researcher agent is one that accounting teams find particularly useful. It handles multi-step research tasks by searching across web sources and your organisational data to produce structured, cited reports. For accountants this is genuinely valuable for staying on top of regulatory changes because a prompt like "Summarise the key changes in UK tax regulations for SMEs using publicly available HMRC guidance, and present the summary with practical implications" produces a useful briefing document rather than a vague AI response. Researcher is not a replacement for professional judgement, but as a starting point for getting up to speed on something like Making Tax Digital updates or auto-enrolment pension changes it saves significant research time that your team can then spend on advising clients rather than reading through HMRC documentation.

9. The Analyst Agent for Data Work

The Analyst agent is designed for complex data analysis and it works well for accounting teams dealing with large client datasets, financial summaries or survey results. You upload a dataset and Analyst explores it, identifies patterns, generates visualisations and produces written analysis that would otherwise take an hour of manual pivot table work. It handles tasks like "Analyse this aged debtor report and identify clients with the highest overdue balances, any patterns in payment timing and recommendations for follow-up priority" and the output includes charts, tables and written commentary that your team can review and refine before acting on it.

10. Building a Client Onboarding Assistant

This one is for practices ready to go further with how they use Microsoft 365. Within Copilot, your team can build custom AI assistants that answer questions, guide processes and surface relevant information from your organisational data, and none of it requires coding. The most common use case we see in accounting firms is a client onboarding assistant that guides staff through the steps required to set up a new client, answers questions about the process and ensures nothing gets missed. Instead of emailing the admin team or digging through a procedures manual, staff ask the assistant and get an instant, accurate answer based on your actual documentation. Other examples include a policy FAQ assistant for the team, a knowledge base for standard processes or a regulatory guidance assistant. We cover this in detail in our Copilot Agents course, and we have also helped clients like Goodman Jones streamline their client onboarding process using Power Automate, Dynamics 365 forms and automated workflows that removed the manual steps entirely.

The Prompting Framework That Makes the Difference

The common thread across all of these use cases is that generic prompts produce generic results, and the accountants who get the most from Copilot are the ones who learn to structure their prompts with four elements that we teach in every session:

Context: Why do you need this? ("Ahead of preparing year-end accounts...")

Goal: What response do you want? ("...summarise the key changes in UK tax regulations for SMEs...")

Source: What should Copilot reference? ("...using publicly available HMRC guidance...")

Expectation: How should Copilot format the response? ("...and present the summary in bullet points with practical implications.")

This framework turns vague AI interactions into reliable, repeatable workflows and it is the single most valuable skill we teach because it applies to every use case above and to anything else your team asks Copilot to help with in the future.

Getting Started

Most of these use cases do not require advanced technical skills and if your team can write an email they can learn to use Copilot effectively. The barrier is not the technology but knowing what to ask for and how to ask for it, which is exactly what our Copilot training for accounting firms covers. We deliver practical, hands-on sessions built around the work your team does every day rather than generic AI awareness workshops, taking your staff from prompting fundamentals through to working with organisational data and building custom assistants with the whole pathway designed for accountants specifically.

Whether your practice has Copilot licences that are not being fully used or has not started with Copilot at all, our training works for both. Copilot Essentials is designed for all staff regardless of licence level, so you can get your whole team started without needing premium licences first. Book a consultation and we will give you an honest assessment of where to start.