Overview
This document guides Cloudmore brokers through the monthly billing check process. It covers how to export billing data, import it into the Monthly Billing Check Tool, and review the results to identify margin discrepancies, pricing anomalies, and potential issues with vendor billing.
This is especially important for Microsoft services, as there can be unexpected results from the Microsoft billing APIs at times.
Exporting Your Data from Cloudmore
-
Log in to Cloudmore.
-
Navigate to Billing > General Billing Report > Export to Email.
-
Select the period you want to review using the date range filter.
-
For the Services field, select All Services to include all managed services.
-
Leave the default selections for Organization Groups, Organization details, and Convert Currencies.
-
Enter your email address in the Send to emails field.
-
Click Send billing report export.
-
You will receive the billing report in Excel format via email, typically within a few minutes.
-
Download the file and open it in Excel.
Copy the Billing Data to the Monthly Billing Check Tool
-
Download the tool in Excel format: Monthly Billing Check Template.
-
Open the Billing Report downloaded from the email.
-
Copy all the content (Ctrl+A, then Ctrl+C) from the downloaded report.
-
Open the Monthly Billing Check Template and paste (Ctrl+V) the data to the Billing Import from the Cloudmore tab.
-
Move to the Service Invoice Reconciliation tab and refresh the table.
Service Invoice Reconciliation Analysis
Before starting, configure two options on this sheet:
-
If you work in multiple currencies, select the currency you wish to analyze.
-
Enter the Low Margin Check percentage value to highlight services below that margin.
The following checks help ensure that sales prices in Cloudmore are producing service margins at expected levels. If you notice discrepancies or concerns about margins, proceed to the next sheets for a more detailed breakdown.
Customer Margin Report Analysis
Review each customer's margin and the Service Invoice Reconciliation Report to compile a list of concerns. Rely on the details, not just aggregated totals, as these can obscure critical information. Review customers flagged with ALERTS and Checks.
Up to six configuration values may impact pricing accuracy and margin calculations:
-
Currency Code - Filter to look at one currency at a time.
-
Total Cost - Filter to remove zero-cost items.
-
Quantity - Filter to remove zero-quantity items.
-
Low Margin Check - View values marked with the "check" flag.
-
High Margin Check - View values marked with the "check" flag.
-
Zero or negative Margin Alert - View values marked with the "ALERT" flag.
Customer Services Margin Report
This report enables you to drill down into detailed data. Use the list of services and customers flagged in the first two reports to focus your attention on areas that require further review.
The main goal is to identify issues with sales pricing, whether at the service level or customer-specific pricing level. Pay close attention to any ALERT or Check flags.
Use the filters to narrow down the data, specifically filtering on the "Check" and "Alert" columns to hide lines that are already correct.
Customer Product Margin
The final level of detail drills down from the service level to the individual product level. Once you have identified a specific organization and service, use the filters to drill down into the exact billing lines that require investigation.
Billing Export Data
This view is for customers who do not use the billing API to retrieve billing data from Cloudmore. It can also be used to validate data being transmitted to ERP systems via the API.
For best results, perform this routine on your billing date each month.
Billing Troubleshooting
The Excel template is a valuable tool for spotting billing discrepancies. If you contact Cloudmore support for help with a billing issue, you will be asked to share a completed version of this template along with your Microsoft billing file. This allows faster identification of the problem and helps you learn to spot similar issues in the future.