How do I run my Office 365 billing report?

Cloudmore enables the production of monthly CSP Direct billing data in minutes allowing users to easily and accurately invoice customers.  

The billing report is generated using the Microsoft billing rules and the 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 a billing platform using either a CSV file or the systems API.

0365Billing1

With Cloudmore users can send customers a simple summary and they can view billing details, on-demand, within the self-service area. Customers see a similar, but personalized, detailed breakdown as the reseller, without the cost price.

 

1. Go to Microsoft O365 CSP direct

Log in to Cloudmore.  Navigate to the Broker menu>My services>Microsoft O365 CSP direct.

Picture3.png 

2. Invoice details

Click on Billing report.

CSP Direct Invoice details

3. Select date range

Click on the date field and select the desired range.

Picture5.png

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

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

Note: - Each month will contain one billing report that corresponds with the Microsoft Billing Cycle.  For example, if the billing Cycle Ends on the 15th – Cloudmore will display a billing report dated the 16th covering the MS billing cycle from the 14th of the previous month to the 15th 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 the Microsoft invoice and can be used as a check to make sure you are billing all 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 the 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 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.

0365Billing2

5. Export

Export the report to see more details by clicking on the Screen Shot 2017-07-11 at 16.29.34.png icon, above the report to the right.

Picture7.png

The file will download automatically.

Picture8.png

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

Excel1.png

excel2.png

excel3.png

excel4.png

6. Scheduling the CSP 365 Billing Report

Access the Billing Report by  Broker menu > Billing > Microsoft CSP Billing and click the Schedule button

ScheduledemailreportSection3.1

The user will be presented with the scheduled report parameter option

Scheduledemailreportsection3.2

  • Run now and email me report: This will send a copy immediately of the Excel download to email addresses specified by the user when chosen and Save is clicked

ScheduledemailreportSection3.3

  • Schedule Report: This will send a copy of the Excel download to a predefined list of users at specified days and times from a named template created for the Billing Report

ScheduledemailreportSection3.4

Additional actions will be presented that require completion

  • Schedule report name: Defined name for the report which will be presented in the email notification message
  • Run Every: The CSP report is only available on a monthly report
  • On the: 1 to 31 or Last Day of Month are presented in the drop-down menu
  • Time Zone: Choose one from a list of world time zones for the report to be run on
  • At: Choose a time by clicking the clock icon and choosing from the presented lists of Hourly and 15-minute segments for the report to be run on
  • Send to email addresses: One or multiple emails can be entered to send an Excel version of the Billing Report. Multiple addresses are separated by a semicolon
  • Press Save to store template for the scheduled billing

7. API Integration to Business Systems

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