If you run a small business and pay for Microsoft 365, there is a good chance you are paying for licenses no one uses. Staff turn over, roles change, and subscriptions quietly pile up. A microsoft 365 license audit small business owners can run themselves is not complicated, but most skip it because they do not know where to look.
After reading this, you will know which reports to pull inside the Microsoft 365 admin center, what patterns signal wasted spend, and what concrete steps to take to cut or reassign what you find. No outside tools required.
Where to Find Usage Reports in the Admin Center
Log in to the Microsoft 365 admin center at admin.microsoft.com. You need either the Global Administrator or Reports Reader role to view usage data. Once you are in, go to Reports, then Usage. You will see a dashboard with activity summaries across the core Microsoft 365 services. The cards on that page show Exchange, SharePoint, Teams, and OneDrive activity at a glance.
To dig deeper, click any service card to open its detail report. Each report lets you filter by a time window: seven days, thirty days, ninety days, or one hundred eighty days. The ninety-day view is the most useful starting point for a license audit. It is long enough to catch occasional users but short enough to reflect current behavior.
A few practical notes before you start pulling data:
- Do not run these reports from a shared admin account. Tie the work to a named person so there is a clear audit trail.
- If you want a colleague to pull reports without giving them full admin rights, the Reports Reader role is the right fit.
- Export each report as a CSV file so you can sort and filter outside the browser.
These reports are your foundation. Every decision you make during the audit should start here, not from memory or what someone on staff thinks they use.
What the Reports Actually Show You
The usage reports surface several layers of activity across your tenant. At the top level, you can see which users have been active in the last seven, thirty, ninety, or one hundred eighty days. That alone tells you who is using the licenses you are paying for and who is not.
Dig one level deeper and you find mailbox data. To check how much storage a specific user has consumed, open the Mailbox usage report and sort by name (Microsoft). That view helps you spot accounts that are ballooning toward their storage limit and accounts that show no activity at all.
App activity reports go further. They show which Microsoft 365 apps a user has actually launched, not just which ones are assigned. A person with a full premium license who only opens Outlook is a candidate for a lower-tier plan.
One thing to keep in mind: the privacy masking setting you configure in the admin center affects more than just the browser view. It also applies to usage data pulled through Microsoft Graph, Power BI, and the Teams Admin Center (Microsoft). Set that preference deliberately before you start pulling reports, so the data is consistent across every tool you use.
Spotting Inactive and Unlicensed Accounts
In the usage reports, two account types drain your budget quietly: inactive licensed accounts and unlicensed accounts that still appear in your directory. An inactive account holds a paid license but shows no activity across email, Teams, SharePoint, or OneDrive over the reporting period you selected. An unlicensed account exists in Microsoft Entra ID but carries no license, so it costs nothing directly. The problem is that unlicensed accounts often belong to former employees whose profiles were never fully removed.
Staff turnover is the most common reason these accounts accumulate. When someone leaves, IT may disable the account or remove the license without deleting the profile. The account lingers in the directory, sometimes with shared mailbox access or calendar permissions still attached.
To find inactive licensed accounts, sort the user activity report by last activity date. Accounts with no activity in thirty or more days deserve a closer look. Cross-reference that list against your HR records to confirm whether the person still works there.
For former employees specifically, deleting the user account entirely stops mail sent to that address from being delivered at all (Microsoft). Do that only after you have saved any data you need to keep. See also the employee offboarding IT checklist for a fuller process to follow when someone leaves.
Finding Users on Plans That Exceed Their Needs
Not every user needs the same license tier. A common waste pattern is assigning a premium plan to someone who only reads email and edits the occasional document. Premium plans include features like advanced compliance tools, extended cloud storage, and enhanced security capabilities. If a user never touches those features, you are paying for tools that sit idle.
Pull up your usage reports and look at each licensed account. Focus on what each person actually opens. Someone using only Outlook and basic Word or Excel probably does not need a top-tier plan. The price difference between a basic and a premium plan per user adds up fast when you multiply it across a team. List every user, their current plan, and their active apps from the usage report. Flag anyone whose app usage fits a lower tier. Then price the difference before making any changes, so you know the monthly savings before you commit.
A user on a lower plan still gets access to the features that plan includes (Microsoft). Check the license assignment screen in the admin center as well. Some plans are no longer sold as new subscriptions. If you spot one of those on a user, make a note to review it at renewal time.
One source of phantom spend that the standard usage reports do not surface automatically: Teams-only guest accounts and room or equipment mailboxes. These show up in your tenant as licensed objects but rarely appear in the per-user activity views. Pull the full licensed-users list from the billing section and compare it against the usage report. Any account that holds a paid license but never appears in activity data is worth investigating before your next billing cycle.
How to Remove a License Without Losing Mailbox Data
Before you remove a license, decide what happens to that user's mailbox. If you delete the account outright, the mailbox goes with it. That is not what you want during a cleanup.
The safe path is to convert the mailbox to a shared mailbox first, then remove the license. A shared mailbox does not require a paid license to retain mail and remain accessible to other users (Microsoft). Your team can still open it, search it, and reply from it. Keep in mind that an unlicensed shared mailbox has a storage limit. If a departing employee had a large mailbox, you may need to keep a license on it temporarily or archive older messages before converting it, to avoid hitting that ceiling.
To remove a license, go to Users, then Active Users, select the account, and open the Licenses and Apps tab. Uncheck the license you are removing and save. The Microsoft 365 admin center handles the rest (Microsoft).
A few things to confirm before you proceed. Check whether the account owns any shared drives, calendars, or distribution lists. Reassign ownership of those before touching the license. Also verify the account is not a service account running an integration or automated task. Removing that license can break a workflow silently. Work through your flagged accounts one at a time. Rushing this step is where data loss happens.
Scheduling a Recurring License Review
Set a calendar reminder to repeat this audit every quarter. Ninety days is short enough to catch waste before it compounds, long enough that the task stays manageable.
Each quarter, pull three reports from the Microsoft 365 admin center: the active users detail report, the email activity report, and the OneDrive usage report. Together they tell you who is active, what services they are actually using, and whether any accounts have gone quiet since your last review.
Between full audits, do a lighter monthly check. Scan for new accounts added since last month and confirm each one has a role and a named owner. Flag any that look like test accounts or departures that slipped through offboarding. Also do a quick pass on your Teams guest list and your room and equipment mailboxes each month. Those objects accumulate outside the normal user lifecycle and can hold paid licenses that nobody notices.
Keep a simple log. A shared spreadsheet works fine. Record the license count at the start of each review, what you changed, and why. If a question ever comes up about a removed account or a downgraded license, that log is your answer.
Build the habit before you need it. A quiet quarter is the best time to tighten your process, not after you have discovered a year of wasted spend.
Pull up the Microsoft 365 admin center usage reports right now and note every user who has not logged in this month. That single report, run consistently each quarter, catches the inactive accounts and mismatched plans that quietly drain your budget before the problem grows large enough to hurt. For a related guide, see Microsoft 365 Security Defaults for Small Business. If you want help managing your Microsoft 365 environment, our managed IT services and cloud and infrastructure services cover exactly this kind of ongoing oversight.
If you want help with this, book a free 30-minute call with Joshua and talk it through.




