Microsoft CSP Monthly Invoicing FAQ

This article is written in a question and answer format, a problem statement/question will be listed, and then an explanation as to why this may have occurred.

 

Why doesn't my monthly Invoice Unit Price doesn't match the current pricelist?

This relates to Microsoft's Price Protection rules (Each subscription created in PRISM/Partner Centre has price protection rule applied to it. The price protection rule lasts for 12 months, at the end of the 12-month period the subscription will then revert to being charged at the current pricing; and this price will be locked in for another 12 months.).

In PRISM you can use the Pricelist feature on the left hand tool bar to look up the historical price from when the subscription was provisioned.

 

Why do I have two or more line items for the same product?

Microsoft CSP invoicing is consumption-based, so any changes made to the subscription during the period will be recorded on the invoice, and each line item will be charged pro-rata for the period it was active.

 

Why do I have two line items on my invoice for the same tenant/product with the same quantity but a different price?

This is the representation of Microsoft's Price Protection rule reverting at the end of the 12 month period from the stored price to the current price, then locking again for another 12 months.

 

My line total doesn't match the Unit Price multiplied by Quantity?

This will mean that the charge wasn't for the full month, if you review the dates next to the subscription you will note that it is for a portion of the month, this will mean that there is a pro-rata charge. In PRISM you can download the CSV file against the invoice, this will contain the billable ratio that is used to calculate the line item. The formula is Unit Price*Quantity*Billable Ratio, and includes any specific country rounding rules.

 

Why is the Retail Price the same as the Customer Price?

Microsoft sells some products that they sell to Crayon, partners and customers all at the same price. For example, Microsoft 365 Audio Conferencing

 

I provisioned a SKU in the current month but was billed for one day of the previous month?

PRISM is set in UTC time zone, so if the provisioning occurred on the last day of the month in UTC time the billing for that month capture this.

 

Where can I find Azure Usage Data?

In PRISM, navigate to the Invoices tab on the left-hand toolbar, locate the invoice relating to the period you would like to see azure usage for, then select the expand icon on the right. Then select the button Download Associated files; there will be a file for any subscriptions under Azure Classic and another file for Azure Plan; select download and the CSV files will be available for you.

 

 

 

What do the columns mean in the Azure Usage Files (CSVs)?

New Azure Plan

Column ID	Value	Column ID	Value
A	Customers Name	R	Unit
B	"Advisor MPN ID" is Crayon's MPN	S	Customer Buy Currency
C	"Billing MPN ID" is Crayon	T	RRP – Recommended Retail Price
D	Your Tenant Domains	U	Customer Buy Price
E	The Subscription ID, as per PRISM	V	Additional Info
F	The Azure Resource Group	W	Billable Contract Agreement ID
G	Instance Data	X	Consumed Service
H	Any Tags, if present	Y	Meter Type
I	The Usage Date, the metered day	Z	Product ID
J	Meter Category	AA	Product Name
K	Meter Sub Category	AB	Resource Location
L	Meter ID	AC	Resource Uri
M	Meter Name	AD	SKU ID
N	Meter Region	AE	SKU Name
O	Period Charge Start Date (this is the billing period)	AF	Vendor FX Rate, the rate Microsoft used to convert from USD to Currency
P	Period Charge End Date (this is the billing period)	AG	Vendor Subscription ID, Partner Centre ID
Q	Quantity	AH	Subscription Name

 

Why does my Azure Usage Data mention a date from a different month?

Within the new Azure Plan, Microsoft sends Crayon a reconciliation file on the first day of each month for the previous month's data (e.g. on April 1st 2022, Crayon received Azure usage data for the usage month of March 2022), usage is collated on a daily basis for Azure Plan, however, there can be a delay between the daily usage been recorded and fed into Microsoft's reconciliation file, therefore several days at the end of the month may be missed from the reconciliation, to remedy this Microsoft then adds this data into the following months' reconciliation file. An example of this is where February 27th and 28th 2022 data didn't record under the February usage (invoiced on the 1st of March 2022), so it was then added to the March 2022 reconciliation and invoiced on the 1st of April 2022.

 

What are Azure Marketplace charges?

Some products from Microsoft's Azure Marketplace are recorded separately in Microsoft's system from standard Azure Plan charges; therefore, these are created as separate invoices in PRISM due to the manual nature of exporting the charges from Microsoft's system. A technician from the partner company would have provisioned these services directly within the Azure Portal.

 

What is a billable ratio?

A billable ratio is how PRISM calculates the charge value for a pro-rata line item. To calculate the billable ratio, first, you need to take the number of days in that specific month, for example, October 2021 = 31 Days; then you need to calculate the number of days the subscription was active for in this period (including the last day) for example if the subscription was active from the 1st of October 2021 to the 19th of October 2021, which equates to 19 days. So the billable ratio formula is {Number Active Days}/{Total Days in Month}. For the previous example, this is 19/31 = 0.612903226. 

When using to calculate a line item you take the Unit Price * Quantity * Billable Ratio. For the previous example where the subscription was $10.00 and a quantity of 5 the formula would be 10*5*0.612903226 = 30.64516129, this would the be rounded using Crayon's rounding rules to $30.65