How Accountancy Firms Actually Use Copilot In-House

There is a gap between what Microsoft says Copilot can do and what accountants are actually doing with it day to day. The marketing talks about transforming productivity. The reality in most practices is that people tried it once, got a flat response and went back to working the way they always have.

That is not a Copilot problem. It is a prompting and training problem. When an accounting team learns 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 the week.

These are the use cases we see most often in the accountancy firms we build agents for. They are the patterns people pick up fastest: the things staff can start doing in their first week and keep doing in the weeks that follow.

1. Summarising client email threads before a meeting

This is the one that gets the biggest reaction from almost every firm. Before a client meeting, an accountant can ask Copilot to pull together everything relevant from recent emails: the key decisions, the open questions and the agreed actions.

The prompt that works best gives Copilot a reason for the summary, something like:

“Summarise my recent email correspondence with [client] 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. Now it takes one prompt, which for fee earners running 20-plus active clients adds up to hours a week.

2. Drafting management accounts commentary

Every reporting cycle, someone sits down to write the commentary and it always follows the same shape: revenue performance, cost movements, margin, key variances and outlook. Yet it gets written from a blank page every time.

Copilot can draft it from a prior period example and the underlying numbers, giving your team a strong first version to review rather than a blinking cursor. The key is uploading a previous example so Copilot matches the format your practice already uses. Generic prompts produce generic output. Specific prompts with reference material produce something your team recognises.

3. Analysing WIP and spreadsheet data in Excel

For teams that live in Excel, Copilot adds a plain English layer on top of the spreadsheets they already use. Instead of building pivot tables and writing SUMIFS by hand, people can describe what they want:

“Create a PivotTable to analyse charges by task code and surname.”

“Create a pie chart showing the percentage of total charges for each person.”

For WIP reports, time analysis and billing reconciliations this is where the daily saving is most obvious, because someone who spent 30 minutes building a report gets a solid first version in under a minute. It works best when the underlying data is well structured, which is why solid Excel habits and Copilot pair so well: better data makes the AI output more reliable.

4. Drafting engagement letters and client documents

Engagement letters, proposals, letters of representation, internal memos and client reports all follow templates but still need customising for each client. Copilot in Word drafts from your existing templates and organisational content, producing consistent output your team edits rather than writes from scratch.

This works best for practices that have invested in getting their templates right, because the better the template, the better the draft. It also builds naturally on top of automation: the workflow that works well is moving engagement letter and letter of representation drafting into Power Automate, with Copilot giving staff the skills to generate and refine on top of that foundation. The engagement letter automation example shows what that looks like in practice.

5. Meeting notes and actions from Teams calls

If your practice runs client or internal calls in Microsoft Teams, Copilot can produce a structured summary with actions and next steps from the recording and transcript. Nobody has to do anything special. As long as recording or transcription is on, Copilot processes the meeting and pulls together who attended, what was discussed, what was decided and what needs to happen next. That means less time writing up notes and more on the work that matters.

6. Catching up after a heads-down stretch

Accountants spend long stretches deep in focused work, whether that is audit prep, tax season or year-end. Coming up for air and catching up on what you missed can take longer than the work itself.

Copilot in Outlook summarises long threads, flags what needs attention first and drafts replies in the right tone, while in Teams it catches you up on the channels and messages you missed. A prompt like:

“Summarise what I missed in the last three hours across my emails and Teams.”

gives you a briefing in seconds rather than 20 minutes of scrolling.

7. Researching regulatory changes

Copilot’s research agents go beyond basic chat. They handle multi-step research across web sources and your own organisational data, then return a structured, cited summary. For accountants that is genuinely useful for staying on top of regulation:

“Summarise the key changes in UK tax regulations for SMEs using publicly available HMRC guidance and set out the practical implications.”

This is a starting point, not a replacement for professional judgement. But for getting up to speed on something like Making Tax Digital or auto-enrolment changes, it saves the research time your team can then spend advising clients rather than reading guidance.

8. Building an internal assistant

This one is for practices ready to go further. Inside Copilot, your team can build custom assistants that answer questions, guide a process and surface information from your own documentation, with no coding involved.

The pattern that lands fastest in accountancy firms is a client onboarding assistant that walks staff through setting up a new client, answers questions about the process and makes sure nothing gets missed. Instead of emailing the admin team or digging through a procedures manual, staff ask the assistant and get an accurate answer from your actual documentation. The same idea works for a policy FAQ, a standard-process knowledge base or a regulatory guidance helper. We cover this in Copilot Studio agents, while our case studies show what agents like this look like in practice.

The prompting habit that makes the difference

The common thread across all of these is that generic prompts produce generic results. The accountants who get the most from Copilot are the ones who learn to structure a prompt with four elements:

• Context. Why do you need this? (“Ahead of preparing year-end accounts…”)
• Task. What do you actually want? (“…summarise the key changes in UK tax regulations for SMEs…”)
• Source. What should Copilot work from? (“…using publicly available HMRC guidance…”)
• Format. How should the answer look? (“…as bullet points with the practical implications for each.”)

That structure turns vague AI chat into a repeatable workflow and it is the single most useful prompting habit to build, because it carries over to every use case above and to whatever your team asks Copilot next.

Governance comes first

Accountancy firms handle sensitive client data, so adoption cannot run ahead of control.

Before wider rollout, review SharePoint and Teams permissions, client folder structures, external sharing, sensitivity labels, approved tools and what should never be entered into an AI tool. Staff need rules they can follow during a busy day, not a policy filed somewhere they will never open.

Getting started

Most of these use cases need no advanced technical skill. If your team can write an email, they can learn to use Copilot well. The barrier is not the technology. It is knowing what to ask for and how to ask, and that comes from practising on real work rather than sitting through a generic AI awareness session.

Where a task repeats every week, a prompt stops being enough and an agent starts to make sense. That is what the FiveForward Framework is for. We Discover where the firm loses time, Design the agents and workflows that will take it back, Enable the people who will build, Automate the repetitive coordination and Embed the agents with governance and review, so the gains hold long after the engagement. Where the wider team needs end user Copilot training, that is arranged through our training partner.

Whether your practice has Copilot licences that are barely touched or has not started at all, start small and real: internal meeting summaries, reviewed client email drafts and report narratives. Prove the value on low-risk work, then move into more sensitive workflows with stronger controls. When you are ready to map it to your firm, book a free consultation.