Microsoft 365 Licence Optimisation Calculator: 20-Point Expert Checklist

The Microsoft 365 admin centre shows provisioned licence counts per SKU. Your EA Order Form shows contracted quantities. Discrepancies between the two result in over-billing or compliance gaps. Expert note: Run a monthly reconciliation between admin centre provisioned counts and EA contracted quantities. Provisioned counts above contracted quantities trigger compliance exposure. Provisioned counts below contracted quantities mean you are paying for licences you have not assigned — this is the more common pattern and represents immediate recoverable cost.

The Microsoft 365 admin centre's Usage Reports section provides activity data by user across Exchange, Teams, SharePoint, OneDrive, and Word. Users with zero activity across all workloads for 30+ days are licence optimisation candidates. Expert note: Export the Microsoft 365 User Activity report. Filter for users with zero activity in the past 30 days. Cross-reference against HR to identify leavers. Remove confirmed leavers and investigate active employees with zero M365 activity — some may be using non-Microsoft tooling that should be reviewed.

Microsoft 365 E5 ($57/user/month) includes E3 capabilities plus advanced security, compliance, and analytics features. Users who only use email, Teams, and standard Office applications have no business justification for E5. Expert note: Build a feature usage map per user cohort using M365 usage reports. The key question per user is: which features are they actually using? E5-specific features include Microsoft Defender, Purview compliance, Power BI Pro, and advanced eDiscovery. Users not using any of these are E3 candidates. E3-to-E1 downgrade is appropriate for users who only use email and don't require desktop Office applications.

Frontline Worker licences are designed for shift workers, retail staff, warehouse personnel, and field workers who need basic communication and task management capabilities but not full desktop productivity suite. Expert note: Identify your frontline worker population — typically users without a dedicated workstation, on shift schedules, and primarily using mobile access. The cost difference between F1 ($2.25) and E1 ($10) or E3 ($36) is significant. A 500-seat conversion from E1 to F1 saves $46,500 annually. Validate that F1 capabilities — Teams, Shifts, task management — meet the operational requirements before converting.

Organisations that purchased standalone Microsoft licences before consolidating on M365 often retain redundant standalone products that are included in their current M365 tier. Expert note: Inventory all standalone Microsoft 365 component licences and cross-reference against the capabilities included in your current M365 suite SKU. Exchange Online Plan 1 is included in M365 E1 and above. SharePoint Online Plan 1 is included in M365 E1. Remove standalone licences for capabilities already included in the suite.

Microsoft 365 Copilot at $30/user/month ($360/year) is the most expensive per-user add-on in the M365 portfolio. Enterprise deployments consistently report active usage rates of 40–60 percent in year one — meaning 40–60 percent of purchased Copilot licences are not being actively used. Expert note: Pull the Microsoft 365 Copilot usage report from the admin centre. Calculate cost per active Copilot user — if 40 percent of your 500 Copilot seats are active, your cost per active user is $750/year, not $360. Use this data to determine the appropriate renewal quantity. Negotiate the right to true-down Copilot licences at the 12-month point based on actual usage.

Power Platform licences are frequently purchased during digital transformation initiatives and then retained beyond the active project phase. Users provisioned on per-user Power Apps licences ($20/user/month) who have not created or accessed a Power App in 90 days are rationalisation candidates. Expert note: Export Power Platform usage data from the Power Platform admin centre. Filter for users with zero app creation or usage in 90 days. Remove these licences at renewal. Note that Power Apps per-user also includes Power Automate Premium — if the user only needs automation, the standalone Power Automate Premium licence ($15/user/month) may be more cost-effective.

Organisations that upgraded from E3 to E5 sometimes retain standalone Defender or Purview licences purchased during the E3 era that are now included in E5. This creates duplicate spend. Expert note: Cross-reference all standalone Microsoft security and compliance licences against the inclusions in your current M365 tier. Microsoft 365 E5 includes Defender for Endpoint P2, Microsoft Sentinel data connectors, Purview Information Protection P2, and Compliance Manager. Remove standalone licences for capabilities already included.

Teams Phone System licences and Microsoft Calling Plans are often purchased at initial Teams telephony deployment and not subsequently reviewed as users change roles or leave. Expert note: Pull Teams calling usage data from the Teams admin centre. Identify Phone System licensed users who have made or received zero PSTN calls in 90 days. Remove Phone System licences from users who have not used Teams telephony and have no business requirement for it. At $8/user/month, a 50-seat reduction saves $4,800 annually.

Microsoft Viva ($12/user/month for full suite) includes Insights, Learning, Engage, and Goals. Organisations that purchased Viva as part of an employee experience initiative but did not complete the deployment may be paying for capabilities no users are accessing. Expert note: Check Viva usage in the M365 admin centre by module. Modules with zero active users represent pure shelfware. If only one or two Viva modules are genuinely used, consider whether individual module licences (where available) or a reduced deployment are more cost-effective than the full suite.

Microsoft offers several commercial frameworks for enterprise M365 procurement: Enterprise Agreement, Microsoft Customer Agreement for Enterprise, and Cloud Solution Provider. Each has different pricing flexibility, commitment structures, and upgrade rights. Expert note: If your annual Microsoft spend is below $500,000, an MCA-E may offer more flexibility than a traditional EA at lower minimum commitment. If your spend is above $2 million, ensure you are in an Enterprise Enrolment with the appropriate tier discounts. Confirm your agreement structure is appropriate for your current and projected spend level before renewal.

Microsoft 365 Business Premium ($22/user/month) includes the same core productivity applications as E3 ($36/user/month) for organisations below 300 seats. For mixed environments, some user cohorts may qualify for Business tiers at lower cost. Expert note: If any of your business units or subsidiaries have fewer than 300 users and do not require advanced compliance or eDiscovery capabilities, Business Premium may be appropriate. The $14/user/month saving versus E3 on a 100-seat cohort is $16,800 annually. Verify licensing eligibility rules — Business tier licences cannot be mixed with Enterprise licences on the same tenant in all scenarios.

Microsoft EA standard terms include an annual true-up where you pay for any licence count increases above the ordered quantity. Quarterly true-up processes create administrative burden and reduce flexibility. Expert note: Negotiate annual true-up timing aligned with your EA anniversary date. If your licence counts are stable or declining, an annual true-up is appropriate. If you have high growth, ensure your true-up process is efficient. True-down rights — the ability to reduce licence counts at true-up — are negotiable in Microsoft EAs for organisations with declining headcounts.

Azure Hybrid Benefit allows organisations with on-premises Windows Server and SQL Server licences with Software Assurance to run equivalent workloads in Azure at significantly reduced cost. Many organisations fail to claim this benefit. Expert note: Azure Hybrid Benefit can reduce Azure IaaS costs for Windows Server workloads by up to 40 percent. For SQL Server on Azure, the saving can exceed 55 percent compared to pay-as-you-go. Work with your Azure team to identify all eligible workloads and confirm the benefit is applied in the Azure portal. This is a zero-cost optimisation available to any EA customer with eligible on-premises licences.

Microsoft Unified Support is priced as a percentage of total Microsoft spend — typically 7–10 percent for the Enhanced tier. For organisations spending $5 million annually on Microsoft licences, Unified Support at 7 percent costs $350,000 per year. Expert note: Review your Unified Support utilisation: number of cases raised, severity distribution, and average resolution time. If you raise fewer than 50 cases annually, your cost per case may exceed $7,000 — significantly above the per-incident pricing alternative. Consider whether a Microsoft Partner-led support arrangement or a lower Unified Support tier could meet your support requirements at lower cost.

The Microsoft 365 admin centre provides free, built-in usage and adoption reports that most organisations use inconsistently or not at all. Monthly reporting creates the accountability that drives licence optimisation. Expert note: Configure the M365 admin centre usage reports to export monthly. At minimum, report: total provisioned licences by SKU, active users by workload, Copilot usage rate, and cost per active user by department. Distribute to IT and finance monthly. The act of monthly reporting consistently surfaces optimisation opportunities that annual reviews miss.

A structured register provides the single source of truth for Microsoft licence management and makes quarterly reviews efficient. Expert note: Build the register in Excel or SharePoint with columns for: SKU name, contracted quantity, provisioned count, active user count, unit cost, annual cost, and recommended action (retain/reduce/upgrade/rationalise). Update quarterly. This register reduces the time required for each quarterly review to under 2 hours and provides the evidence base for every renewal negotiation.

Microsoft routinely adds capabilities to M365 that replace paid third-party tools. Teams Phone replaced many third-party telephony solutions. Microsoft Purview replaced some third-party DLP tools. Copilot is displacing some standalone AI writing assistants. Expert note: Review the Microsoft 365 product roadmap quarterly and assess whether planned feature additions could displace any current third-party tool expenditure. If a Microsoft capability can replace a $50,000/year third-party tool without degrading functionality, the M365 licence cost is partially offset by the third-party saving.

Microsoft 365 Copilot at $360/user/year needs to demonstrate a measurable productivity improvement to justify the cost. Without structured ROI measurement, Copilot becomes a significant unvalidated add-on spend at renewal. Expert note: Define 3–5 measurable Copilot ROI indicators before deployment: email handling time per user, meeting preparation time, document drafting time, code review time if applicable. Measure baseline before deployment and again at 6 months. If measured productivity savings per user exceed $360/year, the investment is justified. If not, reduce the licence count at renewal to active, high-ROI users only.

Microsoft EA renewals default to current terms at current (or higher) pricing if no counter-proposal is made. Buyers who prepare a structured renewal proposal consistently achieve better outcomes than those who accept Microsoft's initial quote. Expert note: 90 days before renewal, prepare a written renewal proposal covering: target per-unit pricing by SKU (benchmarked against market data), proposed quantity adjustments, uplift cap request (maximum 3–5 percent annually), Copilot true-down right, and Azure commitment adjustments. Submit this as a formal procurement communication. Microsoft's negotiation team responds better to documented proposals than to verbal requests, and the paper trail protects your position throughout the negotiation.