Copilot for Financial Advisers: Outlook, Teams and Excel With Records

Copilot keeps an adviser's records compliant when it drafts and you decide: summarise an email thread, draft a reply, recap a meeting, build a first-pass spreadsheet. Save the reviewed result as the file note in your system. It costs $21 a user a month on annual billing, or $18 under Microsoft's promotion until 31 December 2026.

That price is for the Copilot Business add-on, which needs an eligible Microsoft 365 business plan; both figures assume an annual commitment. The compliance part is less about the product than about where the final, approved version lives. A neat summary inside Teams is not a record until you have checked it, corrected it and filed it where your firm keeps client files.

Follow me on Instagram@sagnikteaches

What it costs and what you get for it

Pricing as read from Microsoft's own pages in November 2026, in dollars. Check the page again before you buy, because promotions and names change.

Connect on LinkedInSagnik Bhattacharya

Copilot Business is sold alongside the Microsoft 365 Business plans, which cover up to 300 users. The $18 rate needs an annual commitment, applies to the first year only, is not available on trial subscriptions and cannot be combined with other offers; paying month to month costs $25.20. Microsoft's pricing page also flags usage-based billing for select advanced AI features on top of the licence fee, so ask which of those your firm would switch on before you budget. The naming has shifted as well: Microsoft's documentation now says the Microsoft 365 Copilot app is called Microsoft Copilot, while the add-on is still listed as Microsoft 365 Copilot Business. They are the same family.

Subscribe on YouTube@sagnikteaches

A sum for a five-adviser firm

Illustrative. A firm with five advisers and two administrators wants Copilot for the advisers first. Five add-on licences at $21 cost $105 a month, or $1,260 a year; at the $18 promotional rate that is $90 a month, $1,080 for the first year. If each adviser saves 90 minutes a week on email and meeting write-ups, that is about 6.5 hours a month each, or roughly 32 hours across the team. At a charge-out value of $80 an hour the maths comfortably covers the licence, provided the saving is real. The right way to learn that is a four-week trial with two advisers who time their tasks, not a firm-wide purchase on a promise.

The record test: three questions for every Copilot task

Before using Copilot on any task, ask three questions. They keep the compliance reasoning short and repeatable.

1. Does the output become part of a client record, advice, or a regulated communication? If yes, a person must review and take responsibility for it.
2. Where does the approved version live? It must end up in the firm's system of record (CRM, practice management or document store), not only inside a chat window or a recap page.
3. Can we show what was used and who approved it? You need the source material, the draft where relevant, the edits and the approver, or at least the approved note and the reviewer's name.

Tasks that pass all three with a light touch are the good first uses. Tasks that fail the first question, such as anything that sounds like a recommendation produced by the tool, need a human to write the advice and AI only to tidy the wording.

Outlook: triage, summaries and drafts

Outlook is the easiest win. Microsoft says every eligible subscriber has Copilot in Outlook, and free Copilot Chat works with the email or thread you have open, so you can test the idea before paying for more. Questions across the whole mailbox, such as which threads need an answer today, rely on the paid licence, which reads your mail through Microsoft Graph. Use it for the jobs that eat time but carry little regulatory risk.

• Summarise a long thread before a client call, so you remember the sequence of questions. Check the summary against the thread for any figure.
• Draft a routine reply, such as acknowledging a document, chasing a signed form or confirming a meeting time.
• Tighten a draft for tone and clarity.
• Prioritise the inbox by asking for threads that need an answer today (paid licence).

What stays human: anything that states or implies a recommendation, a product comparison, a suitability judgement or a performance figure. If the email is itself a regulated communication, treat the Copilot draft as a starting point and apply the firm's usual sign-off.

A prompt with a realistic output

Summarise this email thread in five bullet points for my call with the
client at 2pm. List: what they asked, what I already replied, any figures
mentioned (copy them exactly), anything I promised, and open questions.
Do not add information that is not in the thread.

Illustrative output: "Asked: whether the transfer value can be taken in two stages. Replied: sent the provider's form on 3 Nov. Figures: transfer value $182,400 as quoted by the provider's letter. Promised: to confirm the charges by Friday. Open: the client's retirement date, mentioned as 'about three years' without a month." What you fix: open the original thread and check $182,400 against the letter, because a summariser can drop a digit. And do not let "promised" become an automatic to-do list until you have confirmed that the promise exists.

The Outlook triage tutorial goes into the daily routine in more depth, and the one on what compliance allows with general chat tools explains why a work-account Copilot is a different proposition from a personal chatbot.

Teams: meeting recaps that become file notes

This is where the record question bites. A client meeting in Teams can produce a transcript and an AI recap, and the recap looks like a finished file note. It is not one yet. Microsoft's admin documentation says intelligent recap needs a Teams Premium licence or a Microsoft Copilot licence, and that administrators must switch transcription on for it to work. If recording is not allowed, the recap still appears but without the recording, speaker timeline, topics and chapters.

A safe workflow in five steps:

1. Tell the client at the start that the meeting is transcribed for the firm's records, and note their agreement where the firm's rules require it.
2. Run the meeting with transcription on, so the recap has material.
3. Generate the recap and open it the same day, while your memory is fresh.
4. Edit it into the file note format the firm uses: client objectives, information given, advice discussed, decisions, actions. Correct anything the AI got wrong, such as a mis-heard figure or an action attributed to the wrong person.
5. Save the approved note to the CRM or document store, and file the transcript under the firm's retention policy if you keep it. Record the date and who reviewed it.

One setting deserves a deliberate decision. With a Copilot licence, Microsoft offers recap for scheduled meetings without saving the transcript. That suits an internal stand-up, but for a client review it removes the source you would check the note against, and the adviser's memory becomes the only evidence. A sensible rule for a small firm: client meetings keep the transcript, at least until the approved note is filed, and the firm's retention policy decides what happens to it afterwards.

Pay particular attention to words like "recommend", "should" and "agreed". The AI may paraphrase a discussion as a recommendation you did not give, or miss a client's stated reluctance. Check the note against what you remember and, where it matters, the transcript. The detail on settings, recaps and privacy is in the Teams recap and privacy tutorial, and the comparison with adviser-specific tools is in AI note takers for financial advisers.

Before and after for one meeting

Illustrative. The raw recap line: "Adviser recommended increasing pension contributions to the maximum." What was actually said: the adviser explained the annual contribution limit and asked whether the client wanted figures for a higher contribution, and the client said they would think about it. The corrected note: "Discussed the annual contribution limit and how contributions affect tax relief. Client asked for illustrations of a higher contribution; no recommendation made at this meeting. Action: adviser to send two illustrations by 15 Nov." Same meeting, very different record. A firm that files the first version has created evidence of advice that never happened.

Excel: working with client data and the =COPILOT() change

Excel suits calculation checks and tidy-up tasks, with a caveat on a feature that has gone. The =COPILOT() worksheet function was retired on 14 September 2026, and cells that still use it show #NAME? when recalculated. Results it already produced stay in the workbook as stored values until the cell recalculates, so open any old cash-flow or review sheet that used it and replace those cells with plain values or ordinary formulas before a client review relies on them. Copilot in Excel remains, opened from the Copilot icon or pane, where you ask questions about a table and it helps with formulas, charts and analysis. Without the paid licence, access depends on the label Microsoft shows under your name: users marked "Microsoft 365 Copilot (Basic)" get standard access to Copilot in Excel, users marked "Copilot Chat (Basic)" do not, and the full experience with priority access needs the paid licence.

Good uses for advisers:

• Cash-flow sheet checks. Ask what a formula does, or whether a growth assumption is applied consistently across years.
• Tidying exported data. Standardise date formats and names from a CRM export.
• A first-pass comparison table of fees across providers from data you supply.
• Summaries of a client's spending categories from a statement export.

Rules for the record: Excel is a calculation tool and the sheet is part of your working papers, so keep the version used for advice, with the assumptions on a visible tab, and do not paste AI-generated projections into a client document without a check. Verify any formula Copilot writes on a test case with a known answer. If your planning software is the firm's system for projections, use Copilot only for the surrounding spreadsheets, not to replace the regulated tool.

A formula check with a known answer

Illustrative. You ask the side pane for a formula to project a pot of $120,000 growing at 4% a year for ten years with a $6,000 annual contribution at the end of each year. The suggested formula should return roughly $249,666: the lump sum grows to about $177,629 ($120,000 × 1.04¹⁰) and the contributions add about $72,037. Calculate it yourself with a calculator first; if the formula does not match, find out why before the sheet goes near a client. A mismatch usually means contributions were applied at the start rather than the end of the year, or the rate was entered as 4 rather than 0.04.

Two more tasks worth testing, with the record in mind

Annual review preparation. Before a review, ask Copilot in Outlook or Chat to list the client's emails over the last twelve months that mention a change of circumstances, such as a new job, a house move or a health event. Illustrative output: "Four threads: job change in March (mentions new salary), mortgage remortgage in June, a query about a child's university costs in September, a note about a relative's illness in October." That is a prompt list for the review, not a fact-find update. You check each thread, then record the confirmed changes in the CRM in the client's own words. The AI saves the search, and the update to the record remains yours. If any thread contains special-category information, confirm the firm's rules permit it to be processed this way.

Complaint handling. A client writes an angry email about a delay. Copilot can draft a calm acknowledgement and a timeline from the thread. Do not send anything that characterises fault, offers compensation or admits liability without a partner or compliance sign-off, because a complaint triggers its own procedure and time limits. Use the draft to save writing time, and put the complaint on the register before replying. The record here is the complaint file, not the email.

A mistake that shows how records go wrong

Illustrative. An adviser asked Copilot in Teams chat to "summarise what we agreed with the client last week", and the answer drew on a chat between two colleagues that speculated about the client's risk appetite. The summary read as the client's stated position. The adviser, in a hurry, pasted it into the note. A month later, a review found a risk statement that the client never made. The fixes were simple: ask only about the client meeting with the specific meeting named, check the source citations that Copilot lists, and never paste a summary into a note without reading the sources it cites. The permissions point from earlier applies as well: colleagues' chats are visible to the people in them, and Copilot treats them as material.

What Copilot keeps, and what you must keep

Understanding what Microsoft stores helps you design the firm's retention without duplicating or missing anything. Microsoft says it stores the user's prompt and Copilot's response, including citations, as the user's Copilot activity history. Administrators can search this with Content search or Microsoft Purview and apply retention policies. The data is encrypted, and prompts, responses and data accessed through Microsoft Graph are not used to train the underlying models. Users can delete their own activity history through their account, which is a reason to check that your retention settings, not individual choices, decide what is kept.

Copilot only surfaces content the user already has permission to open. That means it is as safe as your permissions: if client folders on SharePoint are open to the whole firm, Copilot will answer questions from them for any user. Clean up access before rolling out, particularly for files about vulnerable clients, staff matters or complaints.

Decide with your compliance lead whether Copilot prompts and responses need retaining at all. For routine drafts they may not, since the approved output is the record. For anything that shaped advice, the safer position is to keep them for the same period as the file. Your regulator's current recordkeeping rules decide this, not Microsoft's defaults.

A four-week trial that shows whether it earns its place

Start with two advisers and one administrator, using the trial or the promotional licence, and test five tasks. Write the baseline times first.

1. Week one: email summaries and routine replies. Measure minutes per day on email.
2. Week two: Teams recaps edited into file notes. Measure minutes from meeting end to approved note, and count corrections per note.
3. Week three: Excel checks and cleaning of two exports.
4. Week four: review. Ask what Copilot got wrong, which tasks nobody used, and whether the notes passed the compliance lead's sample review.

Pass the trial if time-to-note falls without more errors in the compliance sample, and if the licence cost is below the value of time saved at a realistic charge-out rate. Fail it if the compliance lead finds notes recording advice that was not given. Run the check on a sample of ten notes, comparing each with the transcript.

The admin side matters too. The Microsoft Copilot usage report in the Microsoft 365 admin centre (Reports, then Usage) shows who has used it and in which apps, and administrators can limit it for some staff; the admin steps for turning Copilot off in Teams for some staff are useful if you want to exclude recording for particular client types. If you are weighing Copilot's recaps against a cheaper option, the tutorial on Teams Premium versus Copilot for meeting summaries compares the two on cost.

Three rules to put in the firm's AI policy

Whatever you decide, write it down in plain language so every adviser applies it the same way.

• Copilot drafts; the adviser approves. No AI-generated text goes to a client or onto a file unchecked.
• The approved note, not the AI recap, is the record, and it is saved in the system of record the same day.
• Client data is used only in firm-approved tools under the firm's Microsoft 365 account, never in personal chatbots.

With those three rules and a short trial, a small firm can use Copilot to remove admin time from Outlook, Teams and Excel without creating a gap between what happened and what the file says happened.

Questions advisers ask about Copilot and records

Is a Copilot meeting summary my file note?

Not by itself. A summary is a draft that you check against what was said, correct and then save as the firm's record, in the system where file notes live. Keep the transcript or recording under your normal retention rules if you use one, and record who reviewed the summary.

Does Copilot train on our client data?

Microsoft states that prompts, responses and data accessed through Microsoft Graph are not used to train the foundation models behind Copilot. It also works within existing permissions, so it can only surface what the user can already open. Check the current page and your own contract before relying on this.

Can we keep Copilot prompts and replies for audit?

Yes. Microsoft stores each prompt and response as the user's Copilot activity history and lets administrators search it with Content search or Microsoft Purview and apply retention policies. Whether you need to retain them is a decision for your compliance lead, based on your regulator's rules.

Do we need the paid licence or is Copilot Chat enough?

Copilot Chat is included at no extra cost with eligible business plans and works with web content and the email or file you have open. Reasoning across your mail, meetings and files together, and the full Copilot experience inside Word, Excel and PowerPoint, needs the paid licence. Start with a small trial group to find out which tasks justify the difference.

Further reads

• AI Automation for Financial Advisers: Onboarding Without Re-Keying — Onboarding without re-keying client data.
• Jump vs Zocks: Which AI Notetaker Fits Your Compliance Set-Up? — Compare adviser-specific note-takers with Copilot recaps.
• Claude vs ChatGPT for Financial Advisers: Meeting Prep and Records — Alternatives for meeting prep and record keeping.
• How Advisers Use AI to Prepare for Annual Client Reviews — Use AI to prepare annual reviews.
• AI CRM for Financial Advisers: What Is Built In and What Is Bolted On — Where client records should actually live.
• Ongoing Advice Review Evidence File: A Checklist for UK Adviser Firms — A grouped checklist for proving ongoing reviews happened: meeting record, review pack and delivery log, with a filled-in sample file.
• Can AI Write File Notes From Adviser Meetings? Draft, Check, Sign Off — Draft a structured file note from a meeting transcript, then make adviser sign-off a named step with consent wording, a checklist and a retention rule.
• AI Tools and AI Development: The Complete 2026 Guide — the AI hub, including every tutorial in the AI-for-business series.

Sources: Microsoft Copilot for Business pricing page, Microsoft Learn (What is Microsoft Copilot; Data, privacy and security for Microsoft Copilot; Intelligent recap for Teams calls, meetings and events; Microsoft Copilot usage report), Microsoft Support (COPILOT function retirement; What Copilot licence do I have).