Find your next step.

Search services, insights, projects and people.

Insights / Techvenation Tools Guides

How to compare Microsoft 365 licences with an employee roster

Compare an employee roster with assigned licences and flag records for review.

Export both lists on the same date and use the same UPN format. Review absent, inactive and duplicated assignments separately, since a service account may be absent from an HR roster for a valid reason. Confirm the dependent workloads before reclaiming any licence.

Prepare your inputs

Export a roster and a licence assignment list with a common UPN or email address.

Worked example

A licence assigned to an inactive user is a review item. A shared mailbox or service account can have a valid exception.

Review before you use the result

Confirm workloads, retention and account ownership before removing any licence.

Open the tool and continue

How we prepare our guides

Put the next step
into practice.

Talk to an expert
Call us