Office365 Spend Report
Get detailed analysis of your Office365 spend.
Office365 Consumption provides users with detailed Office365 spend analysis. The data is based on the billing data that is fetched daily.
Using Office365 Consumption, you can access multiple analytic reports and browse consumption cost information through interactive charts. The analysis is extended by leveraging information from the other Client Portal modules. You can also analyze spend per Custom Group or Budget.
Accessing Office 365 Consumption
To access Office365 Consumption
From the main menu, navigate to Analyze and select Consumption overview. The Consolidated Consumption page displays.
From the View menu, select SaaS Office365 Consumption Details or Office365 Billing Consumption Details (Preview).
Office365 Consumption
You can visualize and analyze your Office 365 EA and Office 365Simple spend.
Each Azure Active Directory user and subscription is treated like a resource. You can assign it to a custom group, add tags, or split the quantity between different business units.
SaaS Office365 Consumption Details Report
The SaaS Office365 Consumption Details Report report displays the cost or quantity data.
The cost data always reports the initial monthly cost on the first day of the month and additional costs due to subscription updates on the day it happened. The cost data is calculated in a single currency.
The quantity data shows the maximum number of subscriptions by product subscription per month.
Office 365Simple Multiple Agreements Tenant
The cost data for the Office 365Simple Multiple Agreements Tenant uses the average price calculated in a single currency. The average price is calculated on the first day of the month and on every subscription update.
To check the billing data per agreement, use the Office365 Billing Consumption Details (Preview) report or see the Billing tab under Cloud Subscriptions.
NOTE: If your Office365 tenant has subscriptions in multiple currencies, the Client Portal will only display the consumption data in the default currency of the portal. Multicurrency calculations are not supported for Office365 consumption.
Office 365 EA Tenant
The cost data for Office365 EA Tenant uses the average price set manually in the Price List.
If the price for a subscription is not set, an information banner is displayed as shown in the following image:
The price in the Price List Center is set for every subscription per month and the average calculation has to be done manually. All missing prices are visible under Missing Prices. If the historical quantity data is available, the cost data is recalculated starting from the Effective Date.
Office 365 Tenant with Mixed Purchase Agreements
The cost data for an Office 365 Tenant with mixed purchase agreements (that is, Office 365Simple and EA) uses an average price calculation based on the Office 365Simple prices only.
The Client Portal doesn't support setting custom prices for the subscriptions purchased through the Office 365 EA agreement. For Office 365 Tenants with mixed purchase agreements, an information banner is displayed.
Understand the Office 365 Resource Spend
Azure Active Directory users and subscriptions are treated like resources. Azure Active Directory user resource cost, is a sum of costs of all subscriptions assigned to this user.
Subscription resource cost is the cost of all subscriptions that are not assigned to any Azure Active Directory user (Subscription resource has a name set to Subscription name and “Unassigned Pool” suffix).
Last updated
