Pagsasanay
Module
Save money with Azure Reserved Instances - Training
Learn how to save money by taking advantage of Azure Reserved Instances.
Hindi na suportado ang browser na ito.
Mag-upgrade sa Microsoft Edge para samantalahin ang mga pinakabagong tampok, update sa seguridad, at teknikal na suporta.
Appropriate roles: Billing admin
Download reconciliation files from Partner Center to view charges for each billing period. Check the charges for each customer's subscriptions and the events that affect them, such as adding licenses mid-term. For detailed invoice information, refer to read your bill.
Here are the reconciliation files and what they show:
Reconciliation file field | Includes |
---|---|
Legacy license-based | Costs and quantities of legacy Office and Dynamics products for a billing period |
Legacy usage-based | Costs and usage of legacy Azure products for a billing period |
New commerce daily rated usage | Daily usage and charges for new commerce (Azure plan) usage-based products for a billing period |
New commerce invoice reconciliation | Aggregated costs, quantities, and usage for all new commerce products for a billing period |
Learn about the different types of charges in reconciliation data in the ChargeType
attribute.
Reconciliation line items might have formatting issues if the en-us locale isn't used.
To address the formatting issues, follow these steps:
To ensure accurate financial auditing and reporting, it's crucial to have detailed reconciliation files. These files often contain large amounts of transactional data, which can be challenging to download directly from the portal.
To make this process smoother, use the billed invoice reconciliation API. This method helps you retrieve detailed invoice data efficiently, even for large files.
To improve the download experience and boost efficiency, the Partner Center now processes new commerce reconciliation files asynchronously. To download a file:
Sign in to Partner Center and select the Billing workspace.
Go to the Billing overview (NCE) task menu > Billing | Billing Overview (NCE) page and choose the year.
Select the invoice number.
Find the reconciliation file on the side panel.
Select Download report.
Look for a notification at the top of the page indicating that your file is being processed. This file should be available shortly on the Reports (NCE) page.
Monitor your download's progress on the Reports (NCE) page using the status column of the request line item.
Check already downloaded reports on the Reports (NCE) page before submitting a new request to save time and prevent duplication.
Status meanings:
If you can't open your .csv file in Microsoft Excel because it exceeds Excel's row limit, you have these options to open the file:
Download the reconciliation file from Partner Center.
Open a new blank workbook in Microsoft Excel.
Navigate to Data tab, then select Get Data > From File > From Text/CSV, and import the .csv (Comma-Separated Values) reconciliation file.
After a while, you can see a window with the file preview.
In that window, select the Load dropdown menu > Load To.
In the Import Data dialog box, select the options as indicated in the following screenshot.
Select OK to start the loading process. Wait until it's complete.
See the file name and number of rows on the right side. Double-click this area to open the Power Query Editor.
As you scroll down, you see that new rows are added dynamically.
Tip
Fix data loading problems caused by line breaks:
To search for specific line item, use the filter option as shown in the screenshot. Additionally, aggregate line items or perform calculations with the "Group By" or "Statistics" features.
For instance, to find the number of billable days in the charge cycle, use the Custom Column feature to calculate the duration between the charge start and end dates. Power Query also provides a range of features for different computations.
After applying the required filters in the Power Query, transfer the data to Excel by following these steps.
To open a reconciliation file in Power BI:
Some reconciliation line items show negative charges for the following reasons:
Understand these negative amounts by referring to the ChargeType
attribute in the reconciliation line items. For instance, if the ChargeType
is "customerCredit," it indicates a refund due to SLA violations, Azure credit, or price adjustments.
To accurately calculate costs, always use the EffectiveUnitPrice
, not the UnitPrice
. The following factors influence the EffectiveUnitPrice
:
Promotions: Discounts or special offers that reduce the price.
Tiered pricing: Different prices based on the quantity consumed.
Adjustments such as partner earned credit: Credits earned through managed service to your customers that reduce the cost.
Additionally, the price might be adjusted based on the number of days billed. The number of days billed is counted from when a billing event occurs until the end of the charge cycle. For instance, if a billing event occurs on the 10th day of a 30-day charge cycle, the price is adjusted based on the remaining 20 days of the charge cycle.
It's important to note that during the billing term, the subscription's UnitPrice
remains constant. If you notice UnitPrice
variance in the reconciliation data, rest assured that it doesn't affect the actual cost. Always use EffectiveUnitPrice
for precise cost calculations.
Understanding how billing works for certain products, such as Azure savings plans or reservations, can help you manage your costs effectively. Here's a detailed breakdown:
Key points to understand
Fixed price commitment: You're billed a fixed amount each month, no matter how much you use the service. For example, if you agree to a fixed price of USD 100 per month for a specific Azure service, you're billed this amount each month regardless of usage.
No extra charges until the limit is exceeded: You don't get extra charges until you exceed the limit. Once your usage surpasses the agreed limit, the pay-as-you-go rate applies. For instance, if your limit is 100 hours of virtual machine usage, and you use 120 hours, you're charged for the extra 20 hours at the pay-as-you-go rate.
Visible recurring charges: Even if you don't use the product, the recurring charge for Azure savings plans or reservations still appears on your invoice data because you committed to a fixed price agreement. Extra charges apply only when usage exceeds the agreed limit. For example, if you agree to pay USD 100 per month for a service, this amount is billed every month regardless of usage. Extra charges apply only when usage exceeds the agreed limit.
To effectively monitor your costs, make sure to regularly review how your Azure reservation or savings plan is linked to your Azure subscription. Take control of your Azure costs today by regularly reviewing your subscription links and usage limits!
To find out your Azure subscription ID for each Azure resource, follow these steps:
Tip
To easily identify products purchased through different or the same Azure subscriptions, consider using resource groups or tags. This approach ensures clarity by linking each product with its respective subscription, even when subscriptions have identical names. It allows billing admins to quickly identify and organize resources based on their subscription, simplifying tracking and reporting, and boosting operational efficiency.
To identify your Azure subscription ID for any pay-as-you-go resources,
Find the SubscriptionId
on your invoice reconciliation line item.
Match it with the SubscriptionId
on your daily rated usage line item.
The EntitlementId
from the same line of your daily rated usage is your Azure subscription ID.
To identify your Azure subscription ID for an Azure reservation,
Find the ReservationOrderId
on your invoice reconciliation line item.
Connect it with the "ReservationOrderId" within the AdditionalInfo
on the daily rated usage line item.
The EntitlementId
from the same line of your daily rated usage is your Azure subscription ID.
To identify your Azure subscription ID for an Azure savings plan,
Find the ReservationOrderId
on your invoice reconciliation line item.
Connect it with the BenefitOrderId
on the daily rated usage line item.
The EntitlementId
from the same line of your daily rated usage is your Azure subscription ID.
Understanding how to track Azure credits is essential for effective reconciliation and credit management of Azure products. Here's how you can find these credits in both invoice reconciliation and daily rated usage data.
To identify the credits:
Use the ChargeType
field and filter the "customerCredit" line items. The CreditReasonCode
specifies the type of credit helping to identify the reason behind the credit.
Look for Subtotal
and Total
fields showing negative amounts for these line items.
For accuracy, group "customerCredit" line items by these fields: ProductId
, SKUId
, AvailabilityId
, OrderDate
, and either CustomerName
or CustomerId
. Then, sum the Total
to determine the credit amount.
Ensure the BillableQuantity
is the same for both charge and credit line items to maintain consistency and accuracy in your credit management process.
To filter and find credit amounts:
Use the CustomerId
, CreditType
(for example, Azure credit offer), and 100 for the CreditPercentage
value to filter the line items.
Sum the BillingPreTaxTotal
of these line items to find the credit amount. This step ensures that you capture the total pretax credit amount accurately for your records.
Note
Some Azure credits might not appear in the daily rated usage data. Always refer to the invoice reconciliation data for complete credit information.
By following these steps, you can accurately track and manage Azure credits, ensuring a clear understanding of your reconciliation data.
Follow these steps to track your telco product charges on a daily and monthly basis:
BillingPreTaxTotal
and your call minutes in "NumMin" under AdditionalInfo
. This method ensures that your daily charges and call minutes are accurately recorded and billed.Note
Quantity in the daily rated usage data represents an approximation and not the exact call minutes used.
CustomerName | ProductId | SkuId | ProductName | UsageDate | ChargeType | UnitPrice | Quantity | UnitType | BillingPreTaxTotal | BillingCurrency | AdditionalInfo | EffectiveUnitPrice |
---|---|---|---|---|---|---|---|---|---|---|---|---|
Constoso | CFQ7TTC0JL2N | 1 | Microsoft 365 International Calling Plan - Outbound US | 9/17/2021 | New | 1 | 0.1524 | Per Call | 0.15 | USD | { "NumMin": 0.2} | 0.984251969 |
Constoso | CFQ7TTC0JL2S | 1 | Microsoft 365 Audio Conferencing - Outbound US | 9/18/2021 | New | 1 | 6.6275 | Per Call | 6.623381835 | USD | { "NumMin": 24.1} | 0.999378625 |
Constoso | CFQ7TTC0JL2S | 1 | Microsoft 365 Audio Conferencing - Outbound US | 9/21/2021 | New | 1 | 2.97 | Per Call | 2.968154515 | USD | { "NumMin": 10.8} | 0.999378625 |
Constoso | CFQ7TTC0JL2S | 1 | Microsoft 365 Audio Conferencing - Outbound US | 9/22/2021 | New | 1 | 0.0585 | Per Call | 0.05846365 | USD | { "NumMin": 0.3} | 0.999378625 |
Constoso | CFQ7TTC0JL2S | 1 | Microsoft 365 Audio Conferencing - Outbound US | 9/23/2021 | New | 1 | 0.4485 | Per Call | 0.447924684 | USD | { "NumMin": 2.3} | 0.998717244 |
Constoso | CFQ7TTC0JL2S | 1 | Microsoft 365 Audio Conferencing - Outbound US | 9/24/2021 | New | 1 | 0.0975 | Per Call | 0.097374931 | USD | { "NumMin": 0.5} | 0.998717244 |
Constoso | CFQ7TTC0JL2S | 1 | Microsoft 365 Audio Conferencing - Outbound US | 9/29/2021 | New | 1 | 0.156 | Per Call | 0.15579989 | USD | { "NumMin": 0.8} | 0.998717244 |
Constoso | CFQ7TTC0JL2S | 1 | Microsoft 365 International Calling Plan - Outbound US | 9/29/2021 | New | 1 | 0.2114 | Per Call | 0.211128825 | USD | { "NumMin": 1.4} | 0.998717244 |
Constoso | CFQ7TTC0JL2S | 1 | Microsoft 365 Audio Conferencing - Outbound US | 9/30/2021 | New | 1 | 0.178 | Per Call | 0.177771669 | USD | { "NumMin": 8.9} | 0.998717244 |
Total | 10.89 | 49.3 |
BillableQuantity
and Subtotal
.CustomerName | ProductId | SkuId | ProductName | ChargeType | UnitPrice | Quantity | Subtotal | TaxTotal | Total | Currency | ChargeStartDate | ChargeEndDate | EffectiveUnitPrice | BillableQuantity |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Contoso | CFQ7TTC0JL2N | 1 | Microsoft 365 International Calling Plan - Outbound US | new | 0.381 | 1 | 0.36 | 0 | 0.36 | USD | 9/1/2021 | 9/30/2021 | 0.225 | 1.6 |
Contoso | CFQ7TTC0JL2S | 1 | Microsoft 365 Audio Conferencing - Outbound US | new | 0.352836167 | 1 | 10.53 | 0 | 10.53 | USD | 9/1/2021 | 9/30/2021 | 0.220755 | 47.7 |
Total | 10.89 | 49.3 |
If you exceed your free talk time, you pay for each extra minute. To reconcile the charges and call minutes between your daily usage and monthly invoice, use the ProductId
and SkuId
.
Check charges and minutes by call type: domestic, international, or toll-free. The bill shows total call minutes and total amount before tax. The subtotal equals the sum of BillingPreTaxTotal
, and BillableQuantity
equals the sum of "NumMin."
Tiered pricing depends on your usage tier, which categorizes your usage into different levels based on the volume of resources consumed. To find the tiered pricing in your reconciliation data, look at the following fields and ensure you're optimizing your usage to benefit from the best rates.
UnitPrice
: The "UnitPrice" in the line item shows the base unit price for the first tier in the price list.
EffectiveUnitPrice
: The "EffectiveUnitPrice" reflects the unit price for your usage tier from the price list. Adjustments like partner-earned credit might change the final price.
PriceAdjustmentDescription
: The "PriceAdjustmentDescription" indicates any discounts or adjustments that affect the final price, such as a 10% discount or partner-earned credit.
For the final cost, check the EffectiveUnitPrice
and PriceAdjustmentDescription
attributes in individual line items based on your usage tier.
To ensure a smooth experience with Azure reservations, it's essential to understand the meaning behind different Reservation Order ID prefixes. The prefix indicates where you bought your Azure reservations from:
By recognizing these prefixes, you can identify the source of each reservation, better manage your reservations, and streamline your Azure operations.
Pagsasanay
Module
Save money with Azure Reserved Instances - Training
Learn how to save money by taking advantage of Azure Reserved Instances.