Knowledge Base

Consumption Report (5.0)

Overview

The Consumption Report gives a detailed summary of the resources an organization has consumed during a billing period. You can export it by email, schedule it to be sent every month, and follow consumption trends in charts.

The Consumption Report currently covers Azure consumption only. Consumption from other services will be added to the report later.

The Consumption Report page

👥

Organization level: Reports > Consumption Report

  • Full access: Super Admin, Global Admin, Global Support Admin, Global View Only Admin

  • Full access (assigned organizations): Key Account Manager, Limited Key Account Manager

  • Full access (own organization): Organization Global Admin, Organization Service Admin

  • Read only (own organization): Organization View Only Admin

You can also open the report from the Usage Report card on the Overview tab of Services > Microsoft Azure.

The page has three tabs.

Tab

What it shows

Export

Export options for an Excel file sent by email, and the list of exported files. Columns: exported file, billing period, status, sent to emails, and an Actions menu.

Schedule

Scheduled reports. Columns: report name, frequency, next run, last run, status, recipients, and an Actions menu.

Charts

Consumption trends by subscription and by meter category.

[SCREENSHOT] The Consumption Report page with the Export tab selected.

Exporting the report

  1. Navigate to Reports > Consumption Report. The Export tab opens.

  2. Under Services, Azure Consumption is selected.

  3. Select the Billing period. Azure consumption is reported per calendar month:

    • Current ongoing period - the current month up to today.

    • Previous ongoing period - the previous month, before Microsoft has closed it.

    • Previous closed period - an earlier month that Microsoft has closed.

  4. Under Send to emails, add the recipients. Your own email is filled in by default.

  5. Click Send usage report.

Recipients receive the generated Excel file by email. The file also appears in the list on the tab, with its billing period and status.

Report fields

The report contains the following fields, for both broker and organization users:

Area

Fields

Organization

OrganizationId, OrganizationName, MicrosoftCustomerId, CloudmoreCustomerNumber, CustomerCountry

Product

ProductName, ProductId, Sku, SkuName, PublisherName, BillingProvider

Subscription

SubscriptionId, SubscriptionDescription, EntitlementId, EntitlementDescription

Charge

ChargeStartDate, ChargeEndDate, ChargeType, Quantity, UnitPrice, Total, InvoiceCurrency

Meter

MeterCategory, MeterSubCategory, MeterId, MeterName, MeterRegion, MeterType

Usage and resource

UsageStartDate, UsageEndDate, Tags, ResourceName, ResourceGroup

Scheduling the report

  1. Open the Schedule tab and click Create schedule.

  2. Enter a Report name. Under Services, Azure Consumption is selected.

  3. The Frequency is Monthly. Choose the Day of month and the Send at time. The scheduled report always covers the current ongoing billing period.

  4. Add the recipients under Send to emails and click Save schedule.

Use the Actions menu on a schedule row to change or remove it.

[SCREENSHOT] The New scheduled report dialog for the consumption report.

Consumption charts

The Charts tab shows consumption in the platform, so you do not need to download the detailed report. It has two charts:

  • Consumption trends by subscriptions - how the cost of each subscription changes over time.

  • Consumption trends by meter category - which resource types, such as Virtual Machines, Storage or Bandwidth, drive the highest costs and how those costs evolve.

Use Filter by subscriptions and click Apply filters to narrow the charts to specific subscriptions.

[SCREENSHOT] The Charts tab with consumption trends by subscription and by meter category.