Resource · Worksheet

The Microsoft 365 license rationalization worksheet.

Most enterprises renew Microsoft 365 on the footprint that happens to be assigned, not the footprint they actually use, and the gap between the two is paid for at full price. This worksheet is the buyer side rationalization pass we run before a renewal, structured as checks your team can complete against tenant data. Rationalize first. Then negotiate.

Contact Us See the optimization service →
Why rationalize The worksheet Reading the result Get the file

Why rationalize before you renew

Microsoft 365 is the single largest line on most enterprise Microsoft agreements, and it is also the one that drifts furthest from reality between renewals. Seats get provisioned for joiners and never reclaimed from leavers. Premium suites get assigned by default rather than by need. Add ons stack on top of bundles that already include the same capability. By the time a renewal arrives, the assigned footprint and the consumed footprint have quietly separated, and the account team is pricing the former.

Rationalization is the discipline of closing that gap on your own terms before anyone prices it for you. This worksheet is the buyer side rationalization pass we run at the start of a Microsoft 365 engagement, structured as a sequence of checks your team can complete with the data already in your tenant. It feeds directly into the license optimization work and sets the baseline for the renewal negotiation that follows.

The worksheet

Work each item against tenant data, not against the purchasing record. The two rarely match, and the difference is the point of the exercise. The printable version expands every line with the report to pull and the threshold to flag.

Section 1 · Seat reconciliation
Reconcile assigned licenses against active users
Compare purchased quantity to assigned quantity to active sign in over the trailing ninety days.
Identify and reclaim leaver seats
Seats still assigned to disabled or departed accounts. See the leaver process.
Flag never activated assignments
Licenses assigned to accounts that have never signed in to the service they pay for.
Measure dormant seats
Active accounts with no meaningful service usage across the measurement window.
Section 2 · Tier fit
Test E5 utilization against the premium paid
Confirm the population on E5 actually uses the security, voice, and analytics the premium buys. See E3 versus E5.
Model an E5 to E3 step down where fit is weak
Quantify the saving and the capability traded. See the E5 downgrade analysis.
Match frontline staff to F3 rather than E3
Deskless and shift workers rarely need the full knowledge worker suite. See F3 versus E3.
Right size Business Premium against enterprise suites
Confirm the entity is sized for the suite it sits on. See E5 versus Business Premium.
Section 3 · Add on overlap
Map every standalone add on against the base suite
Confirm you are not paying separately for a capability the suite already includes. See add on rationalization.
Check Defender stacking
Standalone Defender purchases layered over a bundle that already carries them. See bundle versus standalone.
Review Copilot assignment against active use
Confirm Copilot seats sit with users generating measurable activity. See Copilot ROI analysis.
Section 4 · Governance to hold the gain
Set a reclaim cadence
A recurring review so reclaimed seats do not silently refill before the next renewal.
Pool and reassign rather than buy
Reassign freed seats inside reassignment rules before purchasing new. See license pooling.
Translate the result into a renewal target
Carry the rationalized count, not the historical count, into the renewal proposal.
The rationalization rule

You renew the footprint you can defend with usage data, not the footprint that happens to be assigned the week the quote lands.

Reading the result

Each flagged item is either a seat to reclaim, a tier to step down, or an add on to retire. Totalled against your per seat cost, the worksheet produces a hard number: the spend you can remove before the conversation with Microsoft even begins. In most enterprises that number is large enough to change the entire shape of the renewal, because it resets the baseline the uplift is calculated against.

The discipline matters most in the months before a renewal, when there is still time to act on what it surfaces. Run cold, six weeks before signature, it becomes a list of regrets. Run twelve months out, it becomes leverage.

Get the file

Enter a corporate email and the worksheet arrives as a printable PDF with every check expanded into the report to pull and the threshold to flag. No sales sequence is attached.

Gated resource · Opens on submit

Open the Microsoft 365 license rationalization worksheet.

Tell us who you are and the full worksheet opens immediately in your browser. No wait and no email attachment. We ask for a corporate identity because the buyer side method inside is shared with practitioners, not crawlers.

Opens immediately in your browser. Use a corporate email; personal and freemail addresses are not accepted. We do not share your address and there is no sales sequence attached.

A worksheet finds the waste. An engagement removes it.

The worksheet shows you the seats and tiers to cut. We run the full optimization, hold the gain through governance, and carry the rationalized count into the renewal. Two analyst calls, no pitch.