How do I run my Azure Billing report?

Cloudmore enables you to produce your monthly CSP billing data in minutes allowing you to easily and accurately invoice your customers.  

The CSP Direct Azure billing process uses different components of Cloudmore to make Azure billing more accurate, faster and easier to understand for your customers.Picture1.png

 

The report is based on the Microsoft costs, with your margin automatically added for each customer, which you set using the Azure price management guide.  The data generated can be passed to your billing platform using either a CSV file or the systems API.

CSPAZ1.png

With Cloudmore you can send your customers a simple, summary invoice and they can view the invoice details, on-demand, within their self-service area. They see the same detailed breakdown as you but personalized and without your cost price showing.

1. Go to Azure

Log in to Cloudmore.  Navigate to your Cloud Service Broker menu > Billing > Azure billing. 

Azure Menu

2. Retrieve Billing Data

The chart displayed at the top of the page shows a summary of the total billing costs for the last five months. 

Picture1

Load Forecast allows you to load the chart data for “Current period” and “Forecast" 

invoice history - forecast png

To see a list of all available invoices, click on Invoice Data

Azureinvoicechoice

Invoices are shown with invoice date and Microsoft invoice number.

Select one or more then click Run report to retrieve the data. Use this report to reconcile your Microsoft invoice.

azurebilllistofinvoices

3. View detail

Breakdown per category

Based on the date range selected Cloudmore will display a breakdown by category.
Note:- The categories are pre-defined by Microsoft.

AzureBreakdown

  • Period – Confirms the date range selected and shows the total cost and sales price. The total cost, if all tenants are linked, should correlate with your Microsoft invoice and can be used as a check to make sure you are billing all your customers correctly.

CSPAZB.png

  • Organization - The report is automatically grouped per organization, showing total cost and sales price for each customer. This is the summary invoice amount for each customer.
    Click on the customer name to expand. 

CSPAZC.png

  • Subscription - Grouped per subscription and shows total cost and sales price.
    Click on subscription to expand. 

CSPAZd.png

  • Category – This will show a line item for each category, e.g. – Virtual Machines, Networking, Storage or Data Management. Each line item will have a total cost and sales price.
    Click on a category to expand. 

CSPAZe.png

4. Export

If you are not using the Cloudmore systems API to link billing data to your billing systems, then export the report to see more details. 

Click on the Export icon, above the report to the right.

CSPAZg.png

The file will download automatically.

CSPAZh.png

Now download the Excel template with pivot tables to process the data for billing and reconciliation of costs. See the examples below.

CSPAZi.png

CSPAZj.png

CSPAZk.png 

5. API Integration to Business Systems

For details on how to use the API to integrate with your business systems, view this video guide - https://vimeo.com/213977116 or download the API guide from - http://hubs.ly/H07fvn20

 

6. Running Azure & One-time billing Report

Log in to Cloudmore.  Navigate to your Cloud Service Broker menu > Billing > Azure billing

Azure Menu

7. Retrieve Billing Data


To see a list of all available invoices, click on Azure Plan & One-time billing

AzurePlaninvoicechoice

Invoices are shown with invoice date and Microsoft invoice number.

azureplaninvocelist

Select one or more then click Run report to retrieve the data. The Azure Plan & One-time billing report is only available for export to Excel or CSV

azureplanexport

The file will download automatically.

Now download the Excel template with pivot tables to process the data for billing and reconciliation of costs. See examples below

Templates

Picture 3-2

The below video shows how to create a scheduled email billing report in Cloudmore: