Why do this.. Cloudmore enables you to produce your monthly CSP Direct billing data in minutes allowing you to easily and accurately invoice your customers.     The CSP Direct Office 365 billing process uses  different components of Cloudmore to make Office 365 billing more accurate, faster and easier to understand for your customers.

Follow the instructions below to learn how to generate your CSP billing report. 

The billing report is generated using  the Microsoft billing rules and your Microsoft CSP billing date. The sales price is automatically added for each customer from the Cloudmore standard services price list.  The data produced can be passed to your billing platform using either a CSV file or the systems API.

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

1. Go to Microsoft O365 CSP direct

Log in to Cloudmore.  Navigate to your cloud service broker menu, then click on my services, and then Microsoft O365 CSP direct.

2. Invoice details

Click on billing report.

3. Select date range

Click on the date field and select the desired range.

Last month will set the date range first day to last day of the previous month.  

Custom range allows you to select multiple months and will display a billing report for each month.     

Note: - Each month will contain one billing report that corresponds with you Microsoft Billing Cycle.  For example, if your billing Cycle Ends on the 15^th – Cloudmore will display a billing report dated the 16^th covering the MS billing cycle from the 14^th of the previous month to the 15^th of the selected month. 

4. View detail

The billing report will be grouped by: -

• Date - One billing report per billing cycle within the selected date range will be displayed. This will show 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 of your customers correctly.
• 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 customer name to expand. 
• Product -  Grouped per product showing the total cost and sales price. Note: - that due to the Microsoft billing calculations and rules it is not possible for you to invoice on a traditional Unit x Sales price basis.
• Detail – This will show a line item for each type of transaction e.g. – Cycle Fee, Refund or Pro-rated Billing. Each line item will have a quantity, unit cost and sales price and total cost and sales price.   The correct sales price is automatically applied from either the Cloumore global, or customer specific price list.

5. 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  by clicking on the  icon, above the report to the right.

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.  

6. 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

END