Is Microsoft 365 Copilot Worth Keeping at Renewal? A Licence Audit

Coding Liquids tutorial cover featuring Sagnik Bhattacharya for Is Microsoft 365 Copilot Worth Keeping at Renewal? A Licence Audit.
Coding Liquids tutorial cover featuring Sagnik Bhattacharya for Is Microsoft 365 Copilot Worth Keeping at Renewal? A Licence Audit.

Keep a Microsoft 365 Copilot licence only for people who use it weekly and save more than the break-even time: about 42 minutes a month at the $21 Business list price if their time is worth $30 an hour. Cut anyone inactive for 90 days, and move occasional users to free Copilot Chat. Decide before the renewal date, not after.

The audit takes about two hours: export the usage report, test each seat against a value rule, then choose keep, cut or move for every person. This tutorial is the checklist, with the report fields to read, the sums, and a filled-in example for a twelve-seat business. It assumes you are a Business customer; the logic is the same for Enterprise seats at a higher break-even.

Follow me on Instagram@sagnikteaches

Prices and names to have in front of you

On 5 November 2026, Microsoft's pricing page showed the Microsoft 365 Copilot Business add-on at $21 per user per month on an annual subscription, struck through to a promotional $18. The footnote says the offer runs from 1 July to 31 December 2026, needs an annual commitment and applies to the first year only; the subscription auto-renews, and there is a 7-day cancellation window for a prorated refund. A monthly subscription, also auto-renewing, is $25.20. Business is for organisations of up to 300 users. The Enterprise add-on is $30 per user per month paid yearly, or $31.50 paid monthly, both on an annual commitment. Every listing also carries usage-based billing for select advanced AI features (the page names Copilot Cowork, Code, Autopilot and the Work IQ APIs), charged on top of the licence. Copilot Chat is included with eligible Microsoft 365 business plans at no extra cost.

Connect on LinkedInSagnik Bhattacharya

Two points about names will save confusion. Microsoft now calls the app "Microsoft Copilot", while product pages still say "Microsoft 365 Copilot" in places, and the licence table on Microsoft Learn uses labels such as "Copilot Chat (Basic)" and "Microsoft 365 Copilot (Premium)". Second, the promotional price is a first-year price, as Microsoft's footnote says, so seats bought on it renew at the list price unless a new offer applies, and the first such renewals fall from July 2027. Read what the renewal quote says before you assume $18 again: for many owners it will be the first time they see the full $21.

Subscribe on YouTube@sagnikteaches

Step 1: Find the date and the rules before anything else

  • Renewal date. Find the exact date for the Copilot subscription in the Microsoft 365 admin centre billing pages. Put it in the diary with a reminder 45 days before. Many cost mistakes are made on the last day.
  • Billing term. Is it yearly or monthly? A monthly subscription gives flexibility at a higher price per seat ($25.20 against $21). On a yearly term, Microsoft Learn says licences can be removed only in a short window after you buy or renew (seven days on accounts billed under a Microsoft Customer Agreement), or after recently adding licences; outside that window, the subscription page shows the date a reduction takes effect, normally the renewal.
  • Auto-renewal. Recurring billing is on by default when you pay by card or billing profile, and Learn notes that licences can only be removed while it is on. Turning it off does not cancel anything (the subscription stays active until it expires) and it wipes any changes you had scheduled, so set the new seat count for renewal rather than switching renewal off.
  • Assigned seats. You cannot remove a licence while it is assigned to someone. Unassign it first, then reduce the count.
  • Who bought it. If a reseller or a Microsoft representative manages your licences, Learn says to go to them for changes; ask for the change deadline in writing.

Record these answers at the top of the audit sheet. If you cannot find them, the first job of the audit is to find them. While you are in the admin centre, also open Cost Management and note any usage-based Copilot charges: they sit outside the per-seat price and need their own keep-or-cap decision.

The Complete Excel Course with AI Integration thumbnail

The Complete Excel Course with AI Integration

From formulas and pivot tables to Power Query, DAX, VBA and AI with Copilot, ChatGPT and Claude — hands-on from the first lesson.

By Sagnik Bhattacharya and Virginia Thorn, Primetime Emmy Award winner

Buy now

Step 2: Pull the usage report

In the Microsoft 365 admin centre, go to Reports, then Usage, and under Microsoft Copilot select Copilot, then the Usage tab. That is the route Microsoft Learn gave when I checked on 5 November 2026; menus move, so search for "Copilot usage" if it differs. Then:

  1. Set the time filter to 90 days. The report offers 7, 28, 90 and 180.
  2. Note the three headline numbers: Enabled Users (people holding a licence), Active Users (enabled people who took a user-initiated action in at least one app) and the Active users rate, which is active divided by enabled.
  3. Scroll to the user table and export it as a CSV. It lists each enabled user with prompts submitted, active days, and a last-activity date for each app: Teams, Word, Excel, PowerPoint, Outlook, OneNote, Loop and Copilot Chat.
  4. By default, user names may be hidden in usage reports. If you see anonymised names, an admin must change the privacy setting for usage reports before the export is useful.

Three limits to bear in mind. Data for a day usually appears within 48 hours, so do not run the export on the renewal day itself. The last-activity date for Word, Excel, PowerPoint, OneNote and Outlook can be blank or late if a user's device uploaded its data late. And the table includes everyone who held a licence at any point in the past 180 days, even if they have since lost it, so filter to current holders before you count.

Step 3: Sort every seat into one of four groups

With the CSV open in a spreadsheet, add one column that classifies each person by the rule below. The thresholds are starting points, not Microsoft's; set your own after reading the first export.

GroupSignal in the reportFirst decision
HeavyActive on 8 or more days in the last 28, across two or more appsKeep
LightActive on 2 to 7 days in 28, mostly chatTest a move to free Copilot Chat
DormantNo activity in 90 days, or fewer than 2 active daysCut or reassign
UnknownBlank last-activity date but licence assignedAsk the person, then reclassify

This first pass does not decide anything. It builds a list of people you need to talk to. The report tells you who used Copilot, not whether it helped them.

Step 4: The per-seat value test

For each person left after step 3, apply a break-even sum. A seat pays when the time saved per month, in money, exceeds the monthly price. The formula is simple: price divided by hourly value, times 60, gives break-even minutes per month.

Seat price per monthTime valued at $20 an hourAt $30At $50At $80
$18 (first-year promotion)54 min36 min22 min14 min
$21 (Business, yearly)63 min42 min25 min16 min
$25.20 (Business, monthly)76 min50 min30 min19 min
$30 (Enterprise, yearly)90 min60 min36 min23 min

Read the table like this: a person whose time is worth $50 an hour needs to save 25 minutes a month to cover a $21 seat. That is less than 90 seconds a working day, which is easy to reach on paper and surprisingly hard to prove. So ask each user a pointed question, not "do you like it?":

  1. Which two tasks did you do with Copilot last week?
  2. For each, how long would it have taken without it?
  3. How long did you spend checking or fixing the output?
  4. Did the result go to a client or a colleague unchanged?

The net saving per task is the second answer minus the third. Add up a typical week and multiply by four. If a person cannot name two tasks, treat that as a cut or move signal, whatever the report says.

A filled-in sample for one seat

An account manager at a marketing agency, time valued at $40 an hour, on a $21 seat. Break-even is 31.5 minutes a month. She names three tasks: summarising Teams meetings (saves about 10 minutes a meeting, 6 meetings a month, 60 minutes), drafting first replies in Outlook (saves 3 minutes on about 20 emails, 60 minutes, but she edits each for about 1 minute, 20 minutes net cost) and turning notes into a client recap (saves 15 minutes, 4 a month, 60 minutes). Net saved: 60 + 40 + 60 = 160 minutes, five times break-even. Keep. A colleague who only asks general questions in chat and saves 10 minutes a month is below break-even: that is a move to Copilot Chat.

Step 5: Decide keep, cut or move

DecisionWhenWhat happens
KeepNet saving at least twice the break-even, and they use it in a work app, not just chatSeat stays; name the tasks in the audit sheet
Move to free Copilot ChatMostly chat use, net saving below break-evenSeat is removed; they keep Copilot Chat as part of their business plan if eligible
ReassignA dormant seat while another person is asking for oneMove the licence between people, if your term allows
CutDormant 90 days, no named tasksSeat is removed at the earliest point your term allows

Before moving anyone to Copilot Chat, be clear about what changes. The Learn overview (updated 4 November 2026) describes two free experiences: Copilot Chat (Basic), with no access to Copilot in Word, Excel, PowerPoint or OneNote, and Microsoft 365 Copilot (Basic), with standard access to those apps. Neither can reach work data through Microsoft Graph; both work on uploaded files and on open content in Outlook and Teams. Which one a person lands on depends on their base licence, and the apps show an in-product label for each experience. So an analyst who relies on Copilot in Excel may keep a standard version or lose it entirely, and loses the paid licence's priority access and automatic grounding in work files either way. Do a one-week trial of the downgrade with one person before you change twenty. For the Excel side, see Copilot for data analysis.

A twelve-seat audit, worked through

An illustrative recruitment agency bought 12 Business seats on the first-year $18 promotion and, a year later, faces a $21 renewal. Annual cost at the promotion was 12 × $18 × 12 = $2,592. At $21 it is 12 × $21 × 12 = $3,024, a $432 rise before any changes.

SeatRoleReport signalTest resultDecision
1 to 3ConsultantsActive 12 to 18 days in 28, Outlook and TeamsNet 150+ minutes a month eachKeep
4Operations leadActive 10 days, Excel and WordNet 120 minutesKeep
5 and 6ResourcersActive 5 days, chat onlyNet 15 minutesMove to Copilot Chat
7Finance assistantActive 3 days, ExcelNet 20 minutes, below break-even at $25 an hourMove, trial first
8 and 9DirectorsNo activity in 90 daysNo named tasksCut
10Office managerBlank last activityUsed only to summarise Teams meetings, net 70 minutesKeep, reclassify
11 and 12New startersLicensed 3 weeks ago, 4 active daysToo earlyKeep one more cycle, review at 60 days

Result: keep 7 (seats 1 to 4, 10, 11 and 12), move 3 (5, 6, 7), cut 2 (8, 9). Cost at $21 for 7 seats is 7 × $21 × 12 = $1,764, against $3,024 for all 12: a saving of $1,260 a year, and $828 less than the promotional price they were paying. Note that this saving exists only if the term allows the change; if the agency is locked in, the audit still pays by setting the right number for the next term and by moving the right people in the meantime.

The check-in message to send before you cut anyone

A short, plain message gets honest answers and stops people feeling audited. Send it to every seat holder two weeks before your decision date. Adapt the wording.

Subject: Quick question about your Copilot licence

Hi [first name],

We renew our Copilot licences on [date] and I am checking each one is earning its cost. Could you reply with:
1. The two things you used Copilot for most in the last month.
2. Roughly how many minutes each saved you, after checking and fixing.
3. Anything you would miss if the licence went and you only had the free Copilot Chat.

A short answer is fine. Nothing changes before [decision date], and I will tell you what I decide.

Thanks,
[your name]

Expect three kinds of reply (illustrative). One: specific tasks with minutes, which makes the decision easy. Two: "I use it for general questions", which usually means a move to free Copilot Chat. Three: no reply, which, with a dormant report, is a cut. Do not chase non-replies more than once. A seat nobody will describe in two lines is not a seat you can defend at renewal.

Two sector examples that change the answer

Architecture practice: the people with the longest documents

An architecture practice has nine staff, and the value sits with the two who write specifications, tender responses and fee proposals in Word. Their tasks are long drafts and summaries of long documents, where Copilot in Word earns its place. The drawing technicians barely touch Word. The audit keeps two seats, moves the rest to Copilot Chat for the odd email summary, and the practice pays $504 a year for two seats at $21, not $2,268 for nine. The lesson is that value follows document-heavy roles, not seniority.

Estate agency: the people who live in Outlook

An estate agency has eight negotiators who spend their days in email. The relevant Copilot features are summarising long threads and drafting replies. The risk: drafted replies that promise a viewing time or a price that was never agreed. The audit therefore adds a check to the value test: ask each negotiator how often they sent a drafted reply unedited. If the honest answer is "never", the net saving is smaller than they think, because editing eats the gain. Copilot in Outlook for email triage shows which features to test.

Marketing agency: meetings that need recaps

For a marketing agency the strongest case is often meeting recaps: Microsoft Learn says Teams intelligent recap needs a Microsoft Copilot licence or Teams Premium, and audio recap needs the Copilot licence. If three or four people run most client calls, they need the seats; the rest of the team can work from the notes the seat holders share, without seats of their own. That points to a smaller licence pool than headcount, a pattern worth testing in any services business. Copilot in Teams meetings covers what recaps record and who can see them.

Asking for a better renewal

If your seats come through a reseller or a Microsoft account manager, the audit is also a negotiating document. Prepare a one-page note: current seats, seats you intend to keep, the usage figures, and the date you need a quote by. Then ask three things:

  1. What is the renewal price per seat, and is any promotional price ending?
  2. Can I reduce the seat count at renewal, and by what date must I confirm?
  3. Is there a monthly option for the seats I am unsure about, and what is the price difference?

The third question has a sum behind it. A seat on monthly billing at $25.20 costs $302.40 a year, against $252 on a yearly term at $21. So the flexibility costs $50.40 a seat. For a seat you are 50 per cent sure about, that is cheap insurance: paying $50.40 to avoid a 50 per cent chance of wasting $252 is a good trade. For a seat you are sure about, take the yearly price.

Where the audit goes wrong

  • Treating the active rate as value. A person who asks Copilot trivial questions every day looks heavy in the report. The value test, not the activity count, decides.
  • Cutting the people who use it in secret. Some of your best users are quiet. Ask before cutting; do not rely on the report alone.
  • Ignoring the data the user touches. If Copilot is surfacing files people should not see, the problem is permissions, and cutting seats will not fix it. See cleaning up SharePoint permissions before Copilot.
  • Forgetting the second option. Another assistant may suit some people better, and ChatGPT or Copilot for a Microsoft 365 business compares them.
  • Missing the date. A perfect audit that finishes after the renewal date saves nothing for a year.

A realistic mistake, as an illustration: an owner cuts a director's seat because the report shows no Word activity for weeks. In fact the director used Copilot in Word on a laptop that was often offline, and Learn notes that usage data from Word, Excel, PowerPoint, OneNote and Outlook can upload late, for example when someone disconnects straight after a Copilot action. A two-line email to each person before the cut would have found it.

What to do between renewals

Make the audit a habit, not an event. Put three diary entries in: at 60 days into the term, a 15-minute look at the report; at 120 days before renewal, a user check-in with the four questions; at 45 days before, the keep, cut or move decision. Keep the sheet from this year: next year's audit then starts from a baseline and takes half an hour.

For a wider method on measuring value, how to measure whether Copilot is paying for itself goes into baselines and sampling, which make next year's audit faster.

If you would like a second pair of eyes on your report and the decision, that is what my AI implementation consultation covers. For the wider set of AI tools, see the AI hub.

Copilot renewal: quick answers

What counts as an active Copilot user in the usage report?

A user is active in an app if they take an intentional action, such as submitting a prompt. Opening the Copilot pane in Word without typing does not count. So a low active rate can mean people tried it once and stopped, not just that they never opened it.

How far back does the Copilot usage report go?

You can filter the report over the last 7, 28, 90 or 180 days, and the user table lists everyone who held a Copilot licence at any point in the past 180 days. Data for a given day usually appears within 48 hours of the end of that day.

What do people lose if I move them to free Copilot Chat?

They lose automatic grounding in work files through Microsoft Graph and the paid licence's priority access. Depending on their base licence they land on Copilot Chat (Basic), with no Copilot in Word, Excel, PowerPoint or OneNote, or Microsoft 365 Copilot (Basic), with standard access to those apps. Test the move on one person before you apply it to everyone.

Can I cut Copilot seats before the term ends?

Usually not mid-term. Microsoft Learn says licences can be removed only in a short window after you buy or renew (seven days on Microsoft Customer Agreement accounts) or after adding licences; otherwise the reduction takes effect at renewal. If a reseller or Microsoft representative manages the licences, ask them. Check the date in the admin centre before you promise anyone a saving.

Further reads

Sources: Microsoft Copilot Business and Enterprise pricing pages on microsoft.com; Microsoft Learn pages on the Microsoft Copilot usage report, the Copilot overview licence table, buying or removing licences, recurring billing and Teams intelligent recap; all read 5 November 2026. Minutes and dollar figures for your own staff are illustrative.

Want your Copilot seats checked before you renew?

On a 1:1 call we can read your usage report together, decide which seats earn their cost, and set up a simple review so the next renewal is a quick decision, not a guess.

Book a 1:1 call with me