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
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
- 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.
- Read the Overview: the three headline answers, then What needs a decision? and Where is the review value?
- Select a product to see its seats, its next lifecycle date and the exact quantity to keep.
- 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).
- 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
| Panel | What 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:
| Shows | Meaning |
|---|---|
| No License | The 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 Activity | No recorded use, including licenses assigned within the last 30 days |
| Copilot Chat | Copilot use without a Copilot license, through the free Copilot Chat |
| No Mailbox License / No Mailbox Found | No mail plan, or a mail plan with no mailbox in Microsoft's report |
| Unknown | The 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:
| Review | Accounts shown |
|---|---|
| Needs Review | Every account in any review below, counted once |
| Disabled With Chargeable Licenses | Blocked sign-in, still holding a paid license |
| No Sign-In for 90+ Days | Last successful sign-in more than 90 days ago |
| Never Signed In | Created more than 90 days ago and never signed in. Newer accounts show New account instead |
| No Office Activity 30d | Signed in recently, but no Office activity in 30 days. Needs usage reports |
| Guests With Paid Licenses | Guests holding a paid license |
| Duplicate Licenses and Downgrade Candidates | See Duplicate licenses and downgrade candidates |
| Possible Room, Device Or Test Accounts | Licensed 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 |
| Kept | Accounts a manager has kept; see Keep an account |
| Unknown | Licenses, 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
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.
Permission details for security reviews
| Permission | Without it | Notes |
|---|---|---|
LicenseAssignment.Read.All | No license inventory or values | Reads subscribedSkus |
User.Read.All | Product totals only; no account reviews or domain, department and country views | Reads selected user fields, including department, job title, office, country and usage location, and assigned licenses |
AuditLog.Read.All | No sign-in for 90+ days and never signed in show Unknown | Sign-in activity also needs Entra ID P1 or P2 in the tenant |
Reports.Read.All | No Office activity, downgrade candidates and usage show Unknown | Microsoft can conceal user names in reports; see Usage report privacy |
Organization.Read.All | No lifecycle dates; everything else works | Reads directory/subscriptions and the organization name |
ReportSettings.Read.All | Report concealment shows as unknown | Optional 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.
- A company administrator who can manage cloud accounts selects Update Access in the notice, or Edit → Update Access on the cloud account.
- A tenant administrator reviews and grants consent.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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
| Finding | Check first |
|---|---|
| Unassigned seats | When 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 accounts | Mailbox purpose and size, retention, archives and holds. Shared, service and resource accounts can still need licenses |
| No sign-in for 90+ days | With the owner. A sign-in date shows login recency, not Office or Copilot use |
| Never signed in | Whether 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 days | With the person or their manager. Activity outside the reported workloads is not counted |
| Guests with paid licenses | Why the guest has a license. Guests can open content shared with them without one |
| Duplicate licenses | Group-assigned licenses are changed on the group |
| Downgrade candidates | License 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:
- In Billing → Your products, select Change billing account if the product is not listed.
- Open the product and select Remove licenses.
- Enter the total to keep, not the number to remove.
- 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 license | Suggested change |
|---|---|
| Microsoft 365 E3 or Office 365 E3 | Microsoft 365 F3 |
| Microsoft 365 Business Standard | Microsoft 365 Business Basic |
| Microsoft 365 Apps for enterprise or business | Check 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.