Hi, My invoices give details about the cost per Service Family. However, I want to monitor my costs on a monthly basis, filtered by : Subscription Service Is there a way to either : adjust the invoice details, as the groupment by Service Family is not relevant to me OR to create a custom view that I use every month to see costs sorted by Subscription and Service ? Kind regards,

Hi Pierre-Romain Destruy , Thanks for reaching out to Microsoft Q&A. To monitor your Azure costs on a monthly basis, filtered by Subscription and Service, as the easiest approach, you can use the cost analysis feature in the Azure portal: Monitor costs by Subscription and Service Azure portal--> Cost Management + Billing --> Cost Analysis. In the top left, select the scope you want to analyze, such as your billing account, management group, or subscription. Add Filters: Click on Add filter and select Subscription to filter by subscription. Click on Add filter again and select Service to filter by service. Group by Subscription and Service: In the Group by dropdown, select Subscription and Service. This will group your costs by subscription and service, allowing you to see the monthly breakdown. Customize the View: You can further customize the view by selecting different Visualization options, such as Chart or Table. Adjust the Time range to view costs for the desired period, such as the last 12 months. Save the View: Once you have the view set up the way you want, you can save it by clicking on the Save as button in the top right. Give the view a meaningful name, such as "Monthly Costs by Subscription & Service", and it will be available for you to use in the future. Optinally, you can also set up cost alerts to monitor when spending reaches a certain threshold. Go to cost alerts under cost Management and set up a new alert with your desired criteria This custom view will allow you to monitor your Azure costs on a monthly basis, filtered by Subscription and Service, without needing to rely solely on the invoice details. You can use this view to track cost trends, identify high-cost services, and make informed decisions about your Azure resource usage. You can also set up budgets and alerts based on this custom view to proactively manage your Azure spending. Please 'Upvote'(Thumbs-up) and 'Accept' as an answer if the reply was helpful. This will benefit other community members who face the same issue.

How to change invoice detail - Subscription VS Service family

Accepted answer

Vinodh247 22,871 Reputation points

2024-07-11T00:57:40.2033333+00:00
Hi Pierre-Romain Destruy,

Thanks for reaching out to Microsoft Q&A.

To monitor your Azure costs on a monthly basis, filtered by Subscription and Service, as the easiest approach, you can use the cost analysis feature in the Azure portal:

Monitor costs by Subscription and Service

Azure portal--> Cost Management + Billing --> Cost Analysis.

In the top left, select the scope you want to analyze, such as your billing account, management group, or subscription.

Add Filters:

Click on Add filter and select Subscription to filter by subscription.

Click on Add filter again and select Service to filter by service.

Group by Subscription and Service:

In the Group by dropdown, select Subscription and Service.

This will group your costs by subscription and service, allowing you to see the monthly breakdown.

Customize the View:

You can further customize the view by selecting different Visualization options, such as Chart or Table.

Adjust the Time range to view costs for the desired period, such as the last 12 months.

Save the View:

Once you have the view set up the way you want, you can save it by clicking on the Save as button in the top right.

Give the view a meaningful name, such as "Monthly Costs by Subscription & Service", and it will be available for you to use in the future.

Optinally, you can also set up cost alerts to monitor when spending reaches a certain threshold. Go to cost alerts under cost Management and set up a new alert with your desired criteria

This custom view will allow you to monitor your Azure costs on a monthly basis, filtered by Subscription and Service, without needing to rely solely on the invoice details. You can use this view to track cost trends, identify high-cost services, and make informed decisions about your Azure resource usage. You can also set up budgets and alerts based on this custom view to proactively manage your Azure spending.

Please 'Upvote'(Thumbs-up) and 'Accept' as an answer if the reply was helpful. This will benefit other community members who face the same issue.
Please sign in to rate this answer.
Mahesh Goud Juvvadi 1,070 Reputation points Microsoft Vendor

2024-07-12T08:37:23.8666667+00:00

Hi Pierre-Romain Destruy,

Just checking in to see if you have got a chance to see the answer posted by @ Vinodh247 in resolving the issue.

If you feel that your quires have been resolved, please accept the answer by clicking the "Upvote" and "Accept Answer" on the post.

Thank you.

Pierre-Romain Destruy 20 Reputation points

2024-07-12T13:09:08.22+00:00

Hi,

Thanks for your detailed answer.
Howver, I want to confirm 2 points because I cannot apply several groups (like in a pivot table for example), which is the main issue preventing me from quickly access the data I need :

when selecting a filter, I also have to select filtered items. So you confirm that for my purpose, after selecting filter, I need to select all the filtered items (at once, by clicking the top item filtering box of course) ?

when selecting a Group by dropdown, I can select only one group.

Is there anything I am missing here ?

Vinodh247 22,871 Reputation points

2024-07-14T01:39:59.48+00:00

when selecting a filter, I also have to select filtered items. So you confirm that for my purpose, after selecting filter, I need to select all the filtered items (at once, by clicking the top item filtering box of course) ? Yes. You can unselect the groups that you dont want to see if reqd

when selecting a Group by dropdown, I can select only one group. are you trying to see multiple groups? can you share a image for both of your questions, i think I can have a better understanding.

Pierre-Romain Destruy 20 Reputation points

2024-07-15T20:23:00.2866667+00:00

Yes, I'm trying to see multiple groups.
See attached images of :

current view with only 1 group (Subscription) and the possibility to filter by service

desired dynamic view (example from Excel) with total costs and the possibility to develop the lines

Pierre-Romain Destruy 20 Reputation points

2024-07-15T20:29:39.95+00:00

Hi Vinodh247
It seems I cannot share pictures.

Yes, I am trying to see multiple groups in a dynamic view, grouped per subscription with their total costs, and the possibility to develop the lines to see the services costs per subscription.
It is basically the same view as the Subscription smart view, but with the services instead of the resources under each subscription.

Is it more clear ?

Vinodh247 22,871 Reputation points

2024-07-17T05:17:16.97+00:00

To clarify a little bit : I would like a dynamic view grouped by subscription and service, just like the Subscription smart view, but with services instead of resources under each subscription. Is it possible ?

I created a custom view with groupby service name(as below), is this are you trying to achieve?

Pierre-Romain Destruy 20 Reputation points

2024-07-17T13:30:52.31+00:00

Hi !
No, I want it grouped both by Subscription and Service.
I just think it is not possible :(

Vinodh247 22,871 Reputation points

2024-07-18T00:29:08.7733333+00:00

afaik, i dont think that is possible.

Vinodh247 22,871 Reputation points

2024-07-20T09:53:31.6733333+00:00

Pierre-Romain Destruy: Please accept this as an answer and upvote if the above answered your query. In case if you have any resolution, please share the same here with the community as it can be helpful to others. Else, please respond with more details

and we will try to see if we can help further.

Mahesh Goud Juvvadi 1,070 Reputation points Microsoft Vendor

2024-07-22T13:44:05.7+00:00

Hi Pierre-Romain Destruy,

Just checking in to see if you have got a chance to see the answer posted by @Vinodh247 in resolving the issue.

If you feel that your quires have been resolved, please accept the answer by clicking the "Upvote" and "Accept Answer" on the post.

Thank you.

Pierre-Romain Destruy 20 Reputation points

2024-07-22T13:56:14.9733333+00:00

Hi,

Thanks for the answer, that I accepted.
Then could you share what would be the procedure to adjust the invoice details (per service instead of service family) ?
I could not open a service request from the portal.

Thanks again.
Kind regards

Vinodh247 22,871 Reputation points

2024-07-22T15:52:10.2066667+00:00

Try the below steps to view invoice details broken down by individual service instead of service family in azure cost analysis:

Sign in to the azure portal and navigate to cost management + billing.

Select cost analysis under the cost management section.

In the views list, select invoice details. This will show the invoice charges broken down by service.

In the date range list, select the time period for the invoice you want to analyze.

Add a filter for invoice number and select the invoicenumber that matches the one on your physical invoice.

Cost analysis will now show cost details for each invoiced service, broken down by individual service rather than service family. The costs shown should match precisely to the usage charges for each individual resource on your physical invoice.

To get an even more detailed breakdown, you can export the raw cost details data in csv format from the download button in the top right. This will provide the full usage details with all the fields like resource, region, consumed quantity, etc. For each individual service charge.

To sum up, the key steps are to select the invoice details view in cost analysis, filter for the specific invoice number, and then you'll see the charges broken down by individual service. Exporting the raw data provides the most detailed view of all the usage fields for each service.

Pierre-Romain Destruy 20 Reputation points

2024-07-24T21:15:12.3766667+00:00

Hi,

Thanks for the procedure.

At step 7, when I download data, I get the exact same fields as displayed in the InvoiceDetails view (either in Excel or csv format) : PublisherType,"ChargeType","ServiceFamily","ServiceName","Meter","PartNumber","CostUSD","Cost","Currency"

So I still can't get the break down I'm looking for, by Service and Subscription (or Subscription and Service).

Anything I'm missing for the export ?

Vinodh247 22,871 Reputation points

2024-07-24T23:54:34.63+00:00

Can you try the below and let me know if not yet?

To group by Service, In the Cost Analysis view, select Cost by service. This will allow you to see the costs associated with each service within the selected subscription. Optionally, you can further group by Service tier to get more granular details

Pierre-Romain Destruy 20 Reputation points

2024-07-25T13:28:31.3433333+00:00

Actually, since I need to review all the service costs every month, subscription by subscription, I was looking for a faster way than your suggested procedure (manually change the filtered subscription is quite laborious), hence the wish for a dynamic view like in a pivot table.

I noticed that it's a bit faster to adjust the filtered subscription with the graphic views.

However it's a shame I can't just customize table view or export in xls/csv by selecting the columns as following :

Subscription Service name Cost

IaaS Dev Storage xxx $

IaaS Dev Virtual Machines xxx $

IaaS Dev Backup xxx $

IaaS Prod Storage xxx $

IaaS Prod Virtual Machines xxx $
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

How to change invoice detail - Subscription VS Service family

0 additional answers

Your answer

Subscription	Service name	Cost
IaaS Dev	Storage	xxx $
IaaS Dev	Virtual Machines	xxx $
IaaS Dev	Backup	xxx $
IaaS Prod	Storage	xxx $
IaaS Prod	Virtual Machines	xxx $