Overview
The Microsoft Reconciliation Report compares each Microsoft partner invoice with the cost and sales billed in Cloudmore. Use it to check that every Microsoft charge has been billed to a customer, and to find the organizations and subscriptions that need attention.
If all tenants are linked and every organization has the right service, the Cloudmore total cost should match your Microsoft invoice.
The Microsoft Reconciliation page
Navigation and permissions
Broker level: Reports > Microsoft Reconciliation
-
Full access: Super Admin, Global Admin, Global View Only Admin, Global Billing Admin
The page lists your Microsoft invoices. Columns: invoice, invoice date, billing period, type (Microsoft Billing or Azure Legacy), status, Microsoft total cost, Cloudmore total cost, difference, and an Actions menu. Use the search, or the Type filter, to find an invoice.
[SCREENSHOT] The Microsoft Reconciliation page with the invoice list.
Row actions
Open the Actions menu on any invoice row.
-
View details - open the reconciliation report for the invoice below the list.
-
Download - download the detailed Excel workbook for the invoice.
Reviewing an invoice
-
Navigate to Reports > Microsoft Reconciliation.
-
Click Actions > View details on the invoice. The reconciliation report opens below the list. Large invoices can take several minutes to build on the first load.
The report has these parts:
-
Reconciliation summary: invoice, invoice date, billing period, Microsoft total cost, Cloudmore total cost, total cost difference, Cloudmore total sales, margin amount, margin percentage, and the number of discrepancies and negative margin subscriptions.
-
Billing by service model: a chart of the billing split by model (for example Seat based, Azure Plan consumption, Reserved instances) with the margin of each.
-
Discrepancy diagnosis and Negative margins: shown when the invoice has issues. See the sections below.
When there is nothing to fix, the report shows No action required with three checks: all Microsoft tenants are linked to Cloudmore organizations, no organizations were billed by Microsoft without a Cloudmore service, and no subscriptions have a negative margin.
[SCREENSHOT] The reconciliation report for an invoice, with the Reconciliation summary and Billing by service model.
Discrepancy diagnosis
The Discrepancy diagnosis table explains the total cost difference. Each row is an organization or tenant whose Microsoft cost was not fully billed in Cloudmore. Columns: organization, reason, Microsoft total cost, Cloudmore total cost and difference, with a total row that matches the total cost difference in the summary.
Reason tags
|
Reason |
What it means |
How to fix |
|---|---|---|
|
No organization mapping |
Microsoft billed a tenant that is not linked to any Cloudmore organization, so its cost was not billed to a customer. |
Link the tenant to an organization on the Link tenants tab of Services > Microsoft 365. See Manage Microsoft Customer Tenants (5.0). |
|
Azure billing, no Cloudmore service |
Microsoft billed Azure usage for an organization that does not have the Microsoft Azure service added in Cloudmore. |
Add the Microsoft Azure service to the organization. See Adding the Microsoft Azure Service (5.0). |
[SCREENSHOT] The Discrepancy diagnosis table with reason tags.
Negative margins
The Negative margins table lists the subscriptions on the invoice where the total sales are lower than the total cost, so you are selling at a loss.
Columns: organization, subscription (name and ID), total cost, total sales and margin. The table is sorted by margin, largest loss first. A total row shows the combined cost, sales and margin of the listed subscriptions.
How it's calculated
-
Each subscription's figures are the totals of all its billing lines on the invoice. That includes regular charges, prorated charges, upgrades, seat changes and credits.
-
Margin = (Total sales − Total cost) ÷ Total sales. It's calculated from the subscription totals, not by averaging the margin on each billing line.
-
A subscription is listed when its total sales are lower than its total cost, rounded to two decimals. Differences under 0.01 aren't listed.
-
Subscriptions with cost but no sales are included. Their margin shows n/a because it can't be calculated as a percentage.
-
Subscriptions whose total sales are negative (net credits or reversals) are not included.
Good to know: a subscription isn't listed if it's profitable in total, even when one of its billing lines is below cost. For example, a credit on another line can offset the loss. To check a subscription's pricing in detail, open its billing lines.
To fix a negative margin, review the sales price of the product or subscription:
-
Check the broker or organization price rule in Price List (5.0).
-
Check for a subscription price in Subscription Level Price Correction (5.0).
-
For Azure, check the margin in Azure Price Management (5.0).
[SCREENSHOT] The Negative margins table.
Downloading the reconciliation workbook
Click Actions > Download on the invoice row to download the detailed Excel workbook.
For details on how Azure Plan Consumption items are grouped and categorized in billing, see Azure Billing Settings (5.0).