PRISM New Billing Experience - Understanding Your Invoice
This guide is designed to explain the information available under the PRISM New Billing Experience to assist with reconciliation and customer-on billing. You learn more about the PRISM New Billing Experience, please refer to this article.
What you receive with your invoice:
- Invoice via a PDF
- Invoice via a CSV
- Billing Statement via Excel
To understand what you have been charged for, the most helpful file will be the Billing Data tab under the "Billing Statement" file. Within this tab, you will see a list of all charges throughout the period of the invoice; this data is directly exported from Microsoft's Partner Centre Reconciliation file, which is why it may seem unfamiliar or confusing at first. Each row in the Billing Data tab refers to a "Line Item".
Understanding the data available to you in the Billing Data file can be most helpful, so here is a list of each column and its meaning from a Reseller perspective:
Column | Column Name | Definition |
A | Period | Month in which the invoice was sent |
B | Period Year | Year in which the invoice was sent |
C | Order Date | Provisioning Date of subscription or last renewal |
D | Publisher | Which Microsoft entity or publisher has made the charge |
E | Company Name | End Customer Name |
F | Tenant Primary Domain | End Customer Tenant |
G | Publisher Customer ID | End Customer Tenant ID with Microsoft |
H | Publisher Subscription ID | Subscription ID with Microsoft |
I | Publisher Subscription Name | Blank unless Azure Billing |
J | Product ID | Combined with SKU ID to create Product SKU ID in PRISM |
K | SKU ID | Combined with Product ID to create Product SKU ID in PRISM |
L | SKU Name | Name of the Product in Partner Centre |
M | Product Name | Name of the Product in PRISM |
N | Charge Type | The type of charge for the line item. The main types include: new, renew, addquantity, cancelimmediate, cyclechange, removequantity |
O | Currency | The currency you are been invoiced in |
P | Unit | Blank unless Azure Billing |
Q | Unit Price | The termed Reseller Unit price for the period. Example: on a monthly invoice, this refers to the price for 1 unit for 1 month |
R | Quantity | The quantity of the line item at time of charge |
S | Amount | The Reseller Line Item subtotal; calculated using the formula: Unit Price *Quantity* Billable Ratio |
T | Reservation ID | Blank unless Azure Reservation Billing |
U | Billing Frequency | The Billing Frequency against the subscription |
V | Term and Billing Cycle | The billing and commitment term listed in Partner Centre for the subscription |
W | Charge Start Date | Within the period of the invoice period, the start date of the line item |
X | Charge End Date | Within the period of the invoice period, the end date of the line item |
Y | Customer Country | End Customer's Country |
Z | Subscription Start Date | Start date/last renewal date for the subscription |
AA | Subscription End Date | Next renewal date/end date for the subscription |
AB | Reference ID | Identifier of the charge within Microsoft's Partner Centre |
AC | Product Qualifiers | These identifiers if an Add On subscription |
AD | Publisher Name | Which Microsoft entity or publisher has made the charge |
AE | Publisher ID | ID of which Microsoft entity or publisher has made the charge |
AF | Reservation Order ID | Subscription ID with Microsoft |
AG | Effective Unit Price | Representation of the Reseller Unit Price, backwards calculated from the Reseller Line Item Amount, this is calculated using the formula: Amount / Quantity / Billable Ratio |
AH | Retail Unit Price | The termed End Customer Unit price for the period. Example: on a monthly invoice, this refers to the price for 1 unit for 1 month |
AI | Retail Effective Unit Price | Representation of the End Customer Unit Price, backwards calculated from the End Customer Line Item Amount, this is calculated using the formula: Amount / Quantity / Billable Ratio |
AJ | Retail Amount | The End Customer Line Item subtotal; calculated using the formula: Unit Price * Quantity * Billable Ratio |
AK | Billable Ratio | formula for number of days subscription was active compared to the term of the subscription. See this article for further information. |
AL | Billable Contract Agreement ID | PRISM Information GUID |
AM | Customer Program Agreement ID | PRISM InformationGUID |
AN | Customer Program Agreement Item ID | PRISM Information GUID |
AO | Term Duration Number | Commitment Unit of the subscription, combined with Term Duration Unit for full context |
AP | Term Duration Unit | Commitment Term of the subscription, usually monthly or annual |
AQ | Promotion ID | Blank unless Azure Billing |
AR | Benefit ID | Blank unless Azure Billing |
AS | Benefit Order ID | Blank unless Azure Billing |
AT | Benefit Type | Blank unless Azure Billing |
Comments
0 comments
Please sign in to leave a comment.