Skip to main content

Microsoft 365 Licenses: Find and Reclaim License Spend

M365 Licenses shows Microsoft 365, Copilot and Dynamics 365 license quantities, usage and estimated license value for review. It reads license and directory metadata through read-only Microsoft Graph access and never changes the tenant. The page is in preview.

What it finds​

Unassigned paid seats: seats bought that nobody holds, paid for every month until the quantity is lowered; on the Licenses tab, lower the purchased quantity before the next lifecycle date. Duplicate licenses: an add-on the suite already includes; on Accounts, Duplicate Licenses, remove it then lower its quantity. Downgrade candidates: no Windows or Mac Office app use in 30 days; check app needs, then move E3 to F3 or Business Standard to Business Basic; accounts with a mailbox or OneDrive over 2 GB are not suggested for F3. Disabled accounts with licenses: usually leavers, sometimes shared mailboxes; confirm mailbox, retention and holds first. No sign-in for 90+ days: confirm with the owner, because a sign-in date is not proof of product use. Never signed in: licensed accounts created 90+ days ago with no sign-in, often shared mailboxes, rooms or service accounts; a shared mailbox needs no license unless it is over 50 GB, has an archive or is on hold. No Office activity in 30 days: signed in recently but no Exchange, OneDrive, SharePoint, Teams or Viva Engage use; confirm with the person or their manager. Guests with paid licenses: people outside the organization holding a paid license; check why each one has a license. Copilot seats: bought, assigned and used, to find idle seats to reassign or reduce. Nothing is changed in the tenant.Unassigned paid seats: seats bought that nobody holds, paid for every month until the quantity is lowered; on the Licenses tab, lower the purchased quantity before the next lifecycle date. Duplicate licenses: an add-on the suite already includes; on Accounts, Duplicate Licenses, remove it then lower its quantity. Downgrade candidates: no Windows or Mac Office app use in 30 days; check app needs, then move E3 to F3 or Business Standard to Business Basic; accounts with a mailbox or OneDrive over 2 GB are not suggested for F3. Disabled accounts with licenses: usually leavers, sometimes shared mailboxes; confirm mailbox, retention and holds first. No sign-in for 90+ days: confirm with the owner, because a sign-in date is not proof of product use. Never signed in: licensed accounts created 90+ days ago with no sign-in, often shared mailboxes, rooms or service accounts; a shared mailbox needs no license unless it is over 50 GB, has an archive or is on hold. No Office activity in 30 days: signed in recently but no Exchange, OneDrive, SharePoint, Teams or Viva Engage use; confirm with the person or their manager. Guests with paid licenses: people outside the organization holding a paid license; check why each one has a license. Copilot seats: bought, assigned and used, to find idle seats to reassign or reduce. Nothing is changed in the tenant.

In the fictional Contoso demo tenant, for example, the page finds $538 USD a month of unassigned seats, three Exchange Online (Plan 1) licenses that the users' suites already include, and five Microsoft 365 E3 users who could move to F3 for $130 USD a month less; a sixth is held back because its mailbox is over the F3 limit.

Review a tenant​

  1. Open Tasks → Monitor → M365 Licenses and choose the tenant if the company has more than one. Microsoft 365 is not scoped to Azure subscriptions, so the subscription filter does not apply.
  2. Read the Overview: the three headline answers, then What needs a decision? and Where is the review value?
  3. Select a product to see its seats, its next lifecycle date and the exact quantity to keep.
  4. Select Review Accounts, or a row in Where is the review value?, to load the accounts behind a finding. Find the accounts to review on the Accounts tab, and export the available account rows from Export → Accounts (CSV).
  5. Share the aggregate findings with Export → License Report (Word), which needs the Data Exports feature. The Word report contains counts and estimates, with no account names, user principal names or person lists.

The page needs the M365 Licenses feature set and the microsoft_365_licenses.view permission. Company administrators control the feature set under Feature Sets; custom roles must grant the permission separately.

Read the Overview​

PanelWhat it shows
What is licensed today?Priced monthly list-price value of the paid seats, split by seat state (hover the bar for each value)
How much is in use?The share of paid seats that are assigned
What can be reclaimed?Unassigned seats plus duplicate licenses, in green, a month and a year, and the value still to review
Which products have the most to reclaim?One bar per product, largest first; products without a list price show their seat counts
When can you act?Reclaimable value grouped by each product's next lifecycle date
What needs a decision?Each finding with its count and value, and the link to act on it, including accounts that never signed in, guests with paid licenses and, with usage reports, accounts with no Office activity in 30 days. A green tick means nothing to review
Where is the review value?Accounts to review and their monthly value by domain, department or country. Select a row to open those accounts on the Accounts tab. Each account counts once; see Understand the estimates
Are licensed people using Microsoft 365?With usage reports: how many licensed people are active, which workloads they use, who signed in without using Office, who uses only web and mobile apps, Copilot seats used and mailboxes over 2 GB. Without them, what Reports.Read.All would add, with Update Access
How has license value changed?Monthly value bars across the bottom of the page, ending with the value after reclaiming; see Track license value over time

The Licenses, Accounts, Usage & Copilot and Capabilities tabs hold the detail behind each panel.

Accounts and Usage & Copilot load person details when opened. Raw Microsoft report tables are not shown.

Usage & Copilot​

Usage & Copilot brings each account's Office activity, platforms, last activity by app, mailbox and OneDrive storage, and Copilot activity together in one table. Every column except Platforms and Last Activity by App sorts; accounts with no value sort last.

Each cell reflects whether the person holds a license for that app, taken from Microsoft's usage report:

ShowsMeaning
No LicenseThe account has no license for the app, so there is nothing to pay for
No Use In 28 Days (Copilot)A Copilot seat with no use. Copilot is bought per seat, so this is a seat to reassign or reduce
No Use In 30 Days (Office apps)Licensed, but unused. Office apps come inside a suite, so this is a conversation with the person, not a saving on its own
No ActivityNo recorded use, including licenses assigned within the last 30 days
Copilot ChatCopilot use without a Copilot license, through the free Copilot Chat
No Mailbox License / No Mailbox FoundNo mail plan, or a mail plan with no mailbox in Microsoft's report
UnknownThe usage report is unavailable, concealed or does not cover the account

Mailbox Used shows a bar of used storage against the mailbox quota. Choose an App to add its last-activity column, then a Last Activity range: active within the report window, up to 90 days, over 90 days, no activity, or not licensed. Copilot Licensed, Not Used and Mail Licensed, No Mailbox filter straight to those accounts; a green tick means there are none.

Find the accounts to review​

The Accounts tab lists each licensed person with their job title, department, licenses, sign-in and value. People from outside the organization show a Guest badge. Choose a review to filter the list:

ReviewAccounts shown
Needs ReviewEvery account in any review below, counted once
Disabled With Chargeable LicensesBlocked sign-in, still holding a paid license
No Sign-In for 90+ DaysLast successful sign-in more than 90 days ago
Never Signed InCreated more than 90 days ago and never signed in. Newer accounts show New account instead
No Office Activity 30dSigned in recently, but no Office activity in 30 days. Needs usage reports
Guests With Paid LicensesGuests holding a paid license
Duplicate Licenses and Downgrade CandidatesSee Duplicate licenses and downgrade candidates
Possible Room, Device Or Test AccountsLicensed accounts whose name suggests a room, laptop, shared or test account, with the word that matched. Accounts licensed only for rooms or shared devices, such as Microsoft Teams Rooms, are left out. Name-based, and never added to reclaimable value
KeptAccounts a manager has kept; see Keep an account
UnknownLicenses, enabled status or sign-in could not be read

Reviews with no accounts are hidden. Narrow any review by License, Domain, Department or Country; each filter is searchable and alphabetical, and Clear Filters resets them. Country comes from the account's Microsoft 365 usage location. Accounts (CSV) includes the domain, department, country and job title.

Keep an account​

Some licensed accounts look unused but are needed, such as a seasonal volunteer or a role kept for continuity. Open the account and select Keep — Continuity, adjust the reason, and select Keep Account. This needs microsoft_365_licenses.manage.

A kept account leaves every review, its counts and its values. Its licenses still count in seats and the monthly total. The account shows a Kept badge with the reason, when and who kept it, and Accounts (CSV) adds a Kept Reason column. Select Remove Keep to return it to the reviews.

The Overview, Licenses and monthly history use aggregate data. If account details cannot load or belong to an older scan, the summary stays available; use Retry in the account notice to try again.

From a finding to a saving​

1 Find: the Overview shows reclaimable value by product and when each product can change. 2 Check: on the Accounts tab, confirm owners, mailboxes and app needs. 3 Lower the quantity in the Microsoft 365 admin center under Billing, Your products, Remove licenses, before the next lifecycle date; this is the only step that changes anything, and it happens in Microsoft 365. 4 See the saving: the next scan lowers the value and the month's history bar shows it.1 Find: the Overview shows reclaimable value by product and when each product can change. 2 Check: on the Accounts tab, confirm owners, mailboxes and app needs. 3 Lower the quantity in the Microsoft 365 admin center under Billing, Your products, Remove licenses, before the next lifecycle date; this is the only step that changes anything, and it happens in Microsoft 365. 4 See the saving: the next scan lowers the value and the month's history bar shows it.

Unassigning a license does not lower the bill; only a lower purchased quantity does. Step 3 is described in Lower a purchased quantity.

What M365 Licenses accesses​

Access uses the Spotto app registration that already connects the customer's Azure cloud account. Every permission is a read-only Microsoft Graph application permission with tenant admin consent.

Required: LicenseAssignment.Read.All reads products, purchased and assigned quantities and included services, for unassigned seats, license value, utilization and capabilities. User.Read.All reads name, user principal name, enabled status, guest type, assigned licenses, department, job title, office, country and usage location, for disabled accounts and guests with licenses, duplicate licenses, account reviews and the domain, department and country views. AuditLog.Read.All reads the last successful sign-in time, for no sign-in in 90+ days and never signed in. Recommended: Reports.Read.All reads Office activity per workload and apps used per person over 30 days, mailbox and OneDrive size, and Copilot activity over 28 days, for no Office activity, downgrade candidates with the F3 storage check, and Copilot adoption. Optional: Organization.Read.All reads subscription status, next lifecycle date and the organization name, for When can you act and the report cover. Never read: mail, files, chats or calendars, meeting content, Copilot prompts or responses, passwords or sign-in methods, and no change to licenses, users or settings.Required: LicenseAssignment.Read.All reads products, purchased and assigned quantities and included services, for unassigned seats, license value, utilization and capabilities. User.Read.All reads name, user principal name, enabled status, guest type, assigned licenses, department, job title, office, country and usage location, for disabled accounts and guests with licenses, duplicate licenses, account reviews and the domain, department and country views. AuditLog.Read.All reads the last successful sign-in time, for no sign-in in 90+ days and never signed in. Recommended: Reports.Read.All reads Office activity per workload and apps used per person over 30 days, mailbox and OneDrive size, and Copilot activity over 28 days, for no Office activity, downgrade candidates with the F3 storage check, and Copilot adoption. Optional: Organization.Read.All reads subscription status, next lifecycle date and the organization name, for When can you act and the report cover. Never read: mail, files, chats or calendars, meeting content, Copilot prompts or responses, passwords or sign-in methods, and no change to licenses, users or settings.
Permission details for security reviews
PermissionWithout itNotes
LicenseAssignment.Read.AllNo license inventory or valuesReads subscribedSkus
User.Read.AllProduct totals only; no account reviews or domain, department and country viewsReads selected user fields, including department, job title, office, country and usage location, and assigned licenses
AuditLog.Read.AllNo sign-in for 90+ days and never signed in show UnknownSign-in activity also needs Entra ID P1 or P2 in the tenant
Reports.Read.AllNo Office activity, downgrade candidates and usage show UnknownMicrosoft can conceal user names in reports; see Usage report privacy
Organization.Read.AllNo lifecycle dates; everything else worksReads directory/subscriptions and the organization name
ReportSettings.Read.AllReport concealment shows as unknownOptional and not requested by default

The same connection uses other read-only permissions for governance and cost features; see Azure permissions.

What is stored. The latest collected license, directory and usage evidence for each tenant, replaced by every scan. Summary totals use the full collected population; the account screens and CSV expose up to 5,000 person rows. One record a month for the history chart holds quantities, counts and estimates only, never account or usage-report rows. Data stays in the company's Spotto data region and is visible only to users with the M365 Licenses permission.

Update missing access​

Each source is collected on its own, so a missing permission removes only the insights in the diagram that depend on it. The page shows an access notice naming the permissions to review.

  1. A company administrator who can manage cloud accounts selects Update Access in the notice, or Edit → Update Access on the cloud account.
  2. A tenant administrator reviews and grants consent.
  3. The next tenant scan collects the new data. To collect sooner, run a tenant sync from Cloud Accounts.

For manual setup, see Microsoft Graph application permissions.

Track license value over time​

Each tenant scan records the month's license value; the month's last scan with complete inventory wins. The chart shows up to 13 months and an After reclaiming bar.

  • History starts with the first scan after this release. Microsoft keeps no license history, so earlier months cannot be filled in. Until more months exist, the chart shows the current month and the after-reclaiming bar.
  • A month without a scan is left out, never shown as zero.
  • Each stored month uses its recorded reference prices, with any customer rates effective on that snapshot date. The current projection uses rates effective today. Changing today's rate does not rewrite earlier stored evidence.

Customer-specific pricing​

Use Manage Pricing on M365 Licenses to enter agreed monthly rates or import a CSV. This needs microsoft_365_licenses.manage; permission to update Microsoft consent is separate. Readers can see the resulting estimates. The fictional demo remains read-only.

  1. Select the currency on the M365 Licenses page, then open Manage Pricing. The editor uses that same currency. Automatic selection prefers the tenant organisation's supported market when the latest scan supplies it; this is an estimate market, not evidence of invoice currency.
  2. Enter agreed prices directly in the product table. Products without a Microsoft list price can still have an agreed price. Use Add A Price For Another Product for a reviewed catalogue product the tenant does not hold yet.
  3. Keep Applies To: All Months when the rate has always applied, or choose a start month and optional last month. Scheduled periods use UTC calendar months. Price History shows saved periods, including older day-level dates. Enter 0 only for a confirmed zero rate; a blank input uses the Microsoft list price.
  4. Review the monthly price impact, then select Save Changes. Validation errors appear before saving. The editor closes after a successful save, and the page refreshes its summary, account details and history without another Microsoft scan.
  5. Reset individual products or the visible currency's rates before saving. If another manager saved first, your draft remains available; close and reopen the editor to load the latest configuration before retrying.

A product outside the reviewed catalogue becomes available for pricing when the next scan reports its actual held Microsoft SKU. Use that exact identity; similarly named suites can be different products.

A rate applies to every seat of the selected product in that currency. The first version does not allocate a product's users or unassigned seats between separate paid and grant subscriptions. Do not enter zero for an entire product when only some of its stock is free. Supplied rates do not establish nonprofit eligibility, grant allocation, tax treatment or when your provider allows a quantity reduction.

Include an add-on in a suggested move​

A suggested downgrade can leave out a security or compliance suite the account still needs. On the Suggested Moves tab of Manage Pricing, choose an add-on for each move this tenant has, for example Microsoft Defender Suite with Microsoft 365 F3. The add-on shows its agreed price, else its list price.

After Save Changes, each move is valued as the target plus the add-on and named that way, for example "Microsoft 365 E3 could move to Microsoft 365 F3 + Microsoft Defender Suite". A move that no longer saves money is no longer suggested. Choose None to remove an add-on.

Import a CSV​

Use Import / Export CSV to export the current product names, identities and prices as a template, edit it, and import it again. Required headers are skuId, currency and unitPriceMonthly. Optional headers are effectiveFrom, effectiveTo, source and the display-only productName. Product names are not matched approximately. A blank start applies to all earlier months; a blank end has no configured end. Blank-rate template rows use the Microsoft list price and do not become zero.

skuId,currency,unitPriceMonthly,effectiveFrom,effectiveTo,source
3b555118-da6a-4418-894f-7df1e2096870,NZD,0,,,Example confirmed grant covering all seats

This is an illustrative rate, not a recommendation or confirmation of grant eligibility. Imports replace the editor's visible-currency rates and preserve other currencies. Include every period you want to retain. Duplicate rows, overlapping dates, unknown products, unsupported product/currency pairs or invalid amounts prevent saving. Rates support up to four decimal places. To split an existing period in a CSV, include the old period with an exclusive end date and the new period with its inclusive start date. The import limit is 1,000 entries and 1 MiB.

Understand the resulting values​

The page and Word report distinguish agreed prices and Microsoft list prices, including a mixture when only some rates are overridden. Original Microsoft evidence remains stored separately. An agreed rate is a pricing estimate supplied by your company, not an invoice-backed charge. Accounts with a known zero rate show zero; missing evidence remains unknown. A downgrade that costs the same or more at the effective rates is excluded from savings advice. Pricing an unheld product does not add bundle migration rules or prove that its security and compliance capabilities fit the account.

Older snapshots can recalculate purchased, unassigned, disabled and inactive values for products that already had prices. A previously unpriced product may need a new scan before its agreed-price quantities and amounts are known: older evidence did not separate its trial seats or collect its review quantities. A confirmed zero rate still gives zero cost. Richer review values and group charts may also remain unavailable until a normal scan supplies the necessary facts. Large group sets retain bounded named groups and a quantity-complete Other group; the retained names use the reference-price ranking when the complete set exceeds the limit. Values are never reconstructed from the truncated account list.

If saved pricing is unreadable, collected license evidence remains available at Microsoft list prices with an explicit unavailable-pricing explanation. A manager can use the editor's recovery reset, which removes saved prices across all currencies. Storage or network failures remain errors; they are not reported as a successful reset.

Before you act​

FindingCheck first
Unassigned seatsWhen a quantity reduction takes effect and any refund, with your billing provider. A lifecycle date is when a subscription changes state if not renewed; it does not prove your billing term
Disabled accountsMailbox purpose and size, retention, archives and holds. Shared, service and resource accounts can still need licenses
No sign-in for 90+ daysWith the owner. A sign-in date shows login recency, not Office or Copilot use
Never signed inWhether it is a shared mailbox, room or service account. A shared mailbox needs no license unless it is over 50 GB, has an archive or is on hold
No Office activity in 30 daysWith the person or their manager. Activity outside the reported workloads is not counted
Guests with paid licensesWhy the guest has a license. Guests can open content shared with them without one
Duplicate licensesGroup-assigned licenses are changed on the group
Downgrade candidatesLicense eligibility, security, compliance, mailbox continuity, storage and app needs. Low desktop usage is a prompt for review, not proof that security or compliance requirements are preserved

Free, trial and capacity products are never counted as savings.

Lower a purchased quantity​

The product details give the exact total to keep. Select Open Microsoft 365 Admin Center, then:

  1. In Billing → Your products, select Change billing account if the product is not listed.
  2. Open the product and select Remove licenses.
  3. Enter the total to keep, not the number to remove.
  4. Review the new price, then select Update licenses.

You need the Global or Billing administrator role. For subscriptions bought through a partner, ask the partner. The suggested total removes unassigned seats and duplicates, and keeps disabled-account seats until they have been reviewed.

Duplicate licenses and downgrade candidates​

Duplicate licenses compares each active account's licenses with a curated list of products that include others, such as Exchange Online (Plan 1) inside Microsoft 365 E3, E5 and Business Premium, or Power BI Pro inside E5. A pair is not counted when the covering license is inactive or an administrator has turned the service off inside it.

Downgrade candidates uses the 30-day Microsoft 365 Apps usage report, matched to accounts by user principal name:

Current licenseSuggested change
Microsoft 365 E3 or Office 365 E3Microsoft 365 F3
Microsoft 365 Business StandardMicrosoft 365 Business Basic
Microsoft 365 Apps for enterprise or businessCheck whether the license is needed

It needs Reports.Read.All and a tenant that shows user names in usage reports; otherwise it shows Unknown with the reason. A license that is both a duplicate and a downgrade candidate counts once, as a duplicate.

An E3 account whose recorded mailbox or OneDrive usage is at or above the F3 target limit is excluded from downgrade candidates and their savings. When storage evidence is missing, verify the sizes before acting; missing evidence is not zero usage.

Understand the estimates​

  • Reference estimates use Microsoft list prices for an annual commitment, excluding tax. Nonprofit grants, negotiated rates and customer-specific contract terms are not included unless you enter customer pricing. Neither reference values nor entered rates establish confirmed bill savings.
  • Unused value is unassigned seats plus duplicates. Disabled-account value is shown separately in the Accounts tab's Disabled With Paid Licenses review, and downgrade savings are separate again.
  • Combined review value counts each account once. Disabled accounts, accounts with no sign-in for 90+ days and accounts with no Office activity contribute their full priced value. Otherwise, duplicates contribute only the duplicate price and downgrades only the saving. Findings remain visible when they overlap, so adding their separate values can overstate the combined total.
  • The value of seats with no Office activity is a value to review with the owner, not an amount to reclaim. A recent sign-in does not prove Office use, and missing usage reports do not prove inactivity.
  • When some paid products have no list price, money totals cover priced products only and are marked partial. Seat counts always include every paid product.
  • Cloud PCs, bots, storage and credits appear as quantities only.

Choose the estimate currency​

The picker at the right of the tab row, such as Prices in NZD, uses an estimate currency. Automatic selection first uses available tenant market pricing or the scan's selected currency, then a single agreeing currency from the tenant's Azure subscriptions. If no tenant pricing is available, the Portal requests its regional estimate default: AUD, USD or EUR. These choices do not establish the Microsoft 365 invoice currency.

Choose another currency to match the price market you want to review, or Use Default Currency to restore automatic selection. It changes only this tenant page and does not convert your invoices or other Spotto costs.

Supported: AUD, BRL, CAD, CHF, DKK, EUR (Irish prices), GBP (UK prices), INR, JPY, KRW, NOK, NZD, SEK, TWD and USD. Demo companies show fictional USD prices.

License capabilities​

The Capabilities tab shows which capabilities, such as Intune or Entra ID P1, each license includes and how many accounts have them assigned. An assigned capability is not proof that it is configured or used. The tab also flags assignment errors, retired services and add-ons already covered by another license, as reviews rather than savings. Select Review Accounts to load the people behind those notices.

Ask AI chat about licenses​

AI chat on this page answers questions such as where license spend can be reclaimed, from the same snapshot and estimates. It receives products and counts only, never account names or user principal names.

Usage report privacy​

Microsoft 365 can conceal user names in usage reports. Spotto never changes that setting or matches concealed names to accounts, so person activity and downgrade candidates then show Unknown. Workload activity can still appear as explicitly anonymous report-row counts; those counts are not identified licensed people and do not establish account savings. Reports contain no mailbox contents, documents, chats or Copilot prompts.

Refresh and large tenants​

Each tenant scan refreshes quantities, estimates, findings and the month's history record; the page has no refresh button of its own. Large tenants are collected page by page, and throttled reads retry within the same scan while the page keeps showing the last snapshot. When a source stays incomplete, account counts and estimates are confirmed minimums, shown with +, and missing values stay Unknown.

The Accounts and Usage & Copilot screens show up to 5,000 people. When more account details are available, the page says how many are not shown and that totals include them. Accounts (CSV) exports the same available account rows, so it is also limited to 5,000 people. Aggregate counts and estimates still include the full collected population.