'Azure Billing: New Usage CSV format coming'

I’m happy to announce that we are going to ship a new usage details CSV (comma-separated values) format in the next two weeks. This blog post is meant to give a heads up to those of you who use this file in your scripts.

First, here’s why we are making changes to the format:

  • Difficult to understand. We have heard from users that the current CSV format is difficult to understand. For example, we pack several values in the ResourceDescription field like this: ^Storage^Geo Redundant^^Storage (GB/month)^AzureStorage^GB/month. We worked hard to make the new CSV file much easier to read, making field names more intuitive and expanding packed fields.

  • *Not enough detail. *The current CSV file does not have important details – for example, it tells you how much of a resource you consumed but not how much you are being billed for. Similarly, it does not tell you what rate you are paying for each resource. These details are now in the new CSV file. Moreover, the CSV now has a breakdown of daily usage as well.

  • *Does not match your invoice. *The existing CSV is generated using a different API than the one that generates your bill. So, in some cases, it’s possible to see different usage numbers on your CSV and your bill. We now use the same API in both places, so your CSV should match what you see on your bill.

You can download a sample of the new CSV file to check it out. Here are some fields that won’t be immediately useful to users, but are handy if you call Azure Support:

  • Subscription ID: The same ID that shows up in Account when you click on a subscription.

  • Order ID: An internal ID that is used by Azure Support

  • Offer Name: An internal ID that is used by Azure Support

  • Subs Extra Status: An internal ID that is used by Azure Support

  • SKU: An internal ID used by Azure

  • ResourceGuid: An internal ID used by Azure