Microsoft 365 License Management with BlueTally

What Is Microsoft 365 License Management?

Microsoft 365 license management is the ongoing practice of tracking which subscriptions you own, which users those seats are assigned to, whether those users are actually active, and what the whole thing costs. It covers assignment, reassignment, reclamation when someone leaves, and right-sizing plans at renewal.

Most IT teams do a version of this once a year, in a spreadsheet, a few weeks before their CSP or EA renewal. In between, seats accumulate. BlueTally keeps the picture current so you’re not rebuilding it from scratch every twelve months.

Can Microsoft 365 Manage Its Own Licenses?

Partly. The Microsoft 365 admin center will tell you how many seats you’ve bought and how many are assigned. What it won’t do is tell you which of those assigned seats are worth keeping.

Here’s what the M365 admin center can do:

• Show purchased vs. assigned seat counts per subscription
• Assign and unassign licenses to individual users
• Handle group-based licensing through Entra ID
• Produce usage reports per service (Exchange, Teams, SharePoint, OneDrive)
• Show a last sign-in column on the active users list

Here’s what the M365 admin center cannot do:

• Show you what each assigned license actually costs you, at your negotiated rate
• Connect a license to the employee’s offboarding status
• Tell you which licensed accounts don’t correspond to anyone in your asset register
• Give you a single view across licenses and the hardware assigned to the same person
• Track renewal dates and total subscription spend alongside the rest of your IT inventory
• Produce a report you can hand to finance without editing it first

The gap isn’t data — it’s the join. Microsoft knows who has a license and when they last signed in. Your ITAM system knows who’s an active employee, who’s leaving, and what else they’ve got out. Neither one is useful for cost decisions on its own.

‍

Microsoft 365 License Management Limitations

If you’re managing M365 licenses out of the admin center alone, you’ll hit these quickly:

1. Seat counts without cost

The admin center shows units, not dollars. Nobody negotiates at list price, so the numbers you’d need to build a business case for cutting seats aren’t in there.

2. No link to employment status

A license stays assigned until someone remembers to remove it. When an employee is offboarded, their seat keeps billing unless the removal happens to be on somebody’s checklist.

3. Sign-in data is buried

Last sign-in exists as a column you can add to a user list, or as a report you can export. Either way it’s a manual pull, and it goes stale the moment you finish it.

4. Nothing spans hardware and software

You end up running two separate inventories: one for devices, one for subscriptions. The same offboarding employee appears in both, tracked twice, reconciled never.

5. Orphaned and service accounts hide in the count

Shared mailboxes, contractor accounts, and old service accounts all look like ordinary licensed users. Without a comparison against your employee list, they don’t stand out.

6. PowerShell is the real answer, and it doesn’t scale

Every serious guide to finding unused M365 licenses ends with a Graph API script. That works once. It doesn’t give you a live view, an audit trail, or anything you can put in front of finance.

BlueTally closes these gaps by treating M365 licenses the same way it treats a laptop: assigned to a person, with a cost, a status, and a lifecycle.

‍

How BlueTally Enables Microsoft 365 License Management

Sync every subscription and seat automatically

BlueTally connects to your Microsoft 365 tenant over a read-only API connection and imports your subscriptions and per-user license assignments. No CSV exports, no scripts.

See every license in one of five clear states

Every assigned seat lands in a state you can act on:

• Active — assigned to a current employee who’s using it
• Offboarding — assigned to someone already flagged as leaving
• Not in use — assigned, but with no recent sign-in activity
• Not in BlueTally — licensed account with no matching employee record
• Unassigned — purchased but sitting in the pool

Attach your real prices

BlueTally doesn’t guess at list prices, because almost nobody pays them. You enter your own per-license rates once, in your own currency, and every state above gets a dollar figure attached. “23 seats not in use” becomes a number you can take to a renewal conversation.

Catch licenses during offboarding

Because BlueTally already knows who’s leaving, their M365 seats show up on the same offboarding view as their laptop and monitor. Licenses stop being the thing everyone forgets.

Report on spend, utilisation and renewals

The Spend & utilization report shows what every license costs and how much of it is actually used. The Renewal report shows every renewal date and what’s at stake on each one. Both run on the same scheduled-report system as the rest of BlueTally.

Right-size plans, not just seat counts

The Optimization report goes past reclaim and looks at fit: users on a premium plan whose actual usage would be covered by a lower tier, add-ons nobody touches, and duplicate entitlements. Every recoverable seat is ranked by annual saving, so you work the list from the top down instead of guessing where to start.

‍

What Data Does BlueTally Sync from Microsoft 365?

BlueTally syncs from Microsoft 365 through a secure, read-only connection, refreshed every 10 minutes. Here’s what comes across:

Subscriptions:

• Subscription and SKU name
• Total purchased seats
• Assigned seats
• Renewal date

User assignment:

• User principal name / email
• Display name
• Assigned licenses per user
• Account enabled or disabled status

Activity:

• Last sign-in date
• Days since last activity

Matching:

• Employee match in BlueTally (by email)
• Employee status, including offboarding

BlueTally uses this to build the license states above, match seats to the employees you already track, and calculate cost using the prices you’ve entered.

The sync is one-way only — BlueTally reads from Microsoft 365 and never writes back, so nothing in your tenant is modified.

‍

How to Find Unused Microsoft 365 Licenses with BlueTally

1. Connect your Microsoft 365 tenant

Follow the Microsoft 365 license management setup guide and run a test connection. Takes a few minutes.

2. Let the first sync run

Your subscriptions, seats, and user assignments import automatically.

3. Set your prices

Enter what you actually pay per license, in your currency. This is what turns seat counts into recoverable spend.

4. Review by state

Start with Not in use and Not in BlueTally. Those two are usually where the money is.

5. Reclaim in Microsoft, track in BlueTally

Remove the seats in your tenant, and BlueTally reflects the change on the next sync. Your Spend & utilization report keeps the before-and-after for the renewal conversation.

‍

Microsoft 365 License Optimization

Reclaiming idle seats is the obvious win. The larger one is usually plan fit: people sitting on a premium SKU who only ever use what a lower tier already covers, add-ons bought in a bundle and never touched, and entitlements duplicated by another tool you’re already paying for.

The Optimization report handles that side. It reviews actual usage against the plan each user is on and produces a per-user recommendation - downgrade, remove the add-on, or leave alone - with the annual saving attached to each one. The list is ranked by value, so the first ten rows are worth more than the last hundred.

Together with the reclaim states, that gives you two levers before a renewal: fewer seats, and cheaper seats.