Billing scenarios for one-time and recurring purchases in Cloud Solution Providers program (CSP) new commerce experience (NCE)
Appropriate roles: Admin agent | Billing admin | Helpdesk agent | Sales agent
Note
For a list of Cloud Solution Providers program (CSP) legacy billing scenarios, see Common billing scenarios for legacy CSP program partners working in Partner Center.
New commerce billing period or billing cycle
The new commerce billing period, or billing cycle is a clear and structured approach to managing subscription payments and invoicing within Cloud Solution Provider program (CSP). This system ensures transparency and predictability for partners and customers regarding financial aspects of their subscriptions. Let’s break down its key components and processes:
The billing period is fixed to a full calendar month, simplifying the tracking and management of subscription costs. This standardized approach ensures that billing periods align with the calendar, making it easier for partners to plan and reconcile their expenses.
Billing term
Billing terms define the duration of a subscription commitment. This duration can vary, with options ranging from monthly to multi-year agreements. Longer commitments often lead to discounted rates, offering financial benefits.
Billing plan (payment/billing frequency)
Billing plans set the payment schedule over the billing term. Options such as monthly, annual, or upfront payments are available, allowing you to choose based on their financial preferences and capabilities.
Invoicing and reconciliation
Invoices and reconciliation information are provided in the month following the billing period. For example, for a billing period from January 1 to 31, expect you invoices and detailed reconciliation information between February 6 and 8. This timeline ensures timely review and reconciliation of costs.
Benefits
The new commerce billing period provides several advantages:
Predictability: With fixed billing periods and clear billing terms and plans, partners can more accurately anticipate expenses.
Flexibility: Various billing terms and plans allow partners to choose options that best fit their budget and financial strategy.
Simplicity: Aligning billing periods with calendar months simplifies subscription tracking and management.
Timely information: A consistent schedule for invoices and reconciliation information ensures partners and customers have the information they need for efficient financial management.
The new commerce billing period offers a streamlined, flexible approach to managing subscription costs within the CSP program. By providing clear billing options and a predictable invoicing schedule, it supports effective financial planning and management for both partners and customers.
New commerce charge cycle
The new commerce charge cycle is designed to manage subscription payments efficiently, ensuring you understand when charges occur and how they're calculated. Unlike a billing period, which typically aligns with a calendar month, the charge cycle refers to the number of days billed for a subscription. This distinction is crucial for planning your finances and managing your payment schedules.
Key features of the charge cycle
Definition: The charge cycle is the period for which you're billed for a subscription, not necessarily aligned with a calendar month.
Variable duration:
- Typically lasts 30 or 31 days.
- For February, it can be 28 or 29 days, depending on whether it's a leap year.
- Annual subscriptions have a charge cycle of 365 days, or 366 days in a leap year.
Start date: The cycle begins on the initial purchase date or when renewal/recurring charges start.
Cycle end: The cycle ends one day before the same date of the next month, year, or billing term.
Consistency: The cycle starts on the same day each month, year, or billing term, ensuring predictability in billing dates.
Example
Annual subscription with monthly billing: Consider an annual "Microsoft 365 Office E3" subscription purchased on February 21, 2022, with a monthly billing plan. This pattern continues, adjusting for the number of days in each month. Here's how it works:
Subscription start date: February 21, 2022
Billing plan: Monthly
Subscription term: Annual
- First charge cycle: February 21, 2022, to March 20, 2022 (28 days)
- Second charge cycle: March 21, 2022, to April 20, 2022 (31 days)
- Third charge cycle: April 21, 2022, to May 20, 2022 (30 days)
Benefits of the charge cycle
Financial planning: Knowing the exact dates and durations of charge cycles helps you budget more accurately and forecast your finances better.
Simplified management: By understanding when charges occur, you can manage your subscriptions easily and avoid unexpected charges or service interruptions.
Consistency: The recurring nature of the charge cycle, starting on the same day each month or year, provides consistency and makes tracking easier.
The new commerce charge cycle offers flexibility and predictability in managing subscription payments. By understanding the structure of the cycle, plan your finances effectively, predict expenses, and ensure continuous access to services without interruptions.
Tip
To end a subscription with another subscription or a calendar month, see align subscription end dates.
Calculate one-time and recurring charges
Important
To reconcile, include these billing details: Charge Start Date, Charge End Date, Effective Unit Price, Billable Quantity, Billing Frequency, Subscription Start Date, Subscription End Date, and Amount.
For more information, see CSP one-time purchase reconciliation file fields.
Example 1
Let's say, on June 18, 2020, you bought 10 licenses of Microsoft 365 Business Standard monthly subscription for a unit price of EUR 10.08. Your goal is to reconcile your charges in the billing period efficiently.
Scenario:
Monthly subscription (initial purchase)
- OrderDate: June 18, 2021
- ChargeStartDate: June 18, 2021
- ChargeEndDate: July 17, 2021
- SubscriptionStartDate: June 18, 2021
- SubscriptionEndDate: July 17, 2021
- ChargeType: new
- UnitPrice: EUR 10.08
- EffectiveUnitPrice: EUR 10.08
- BillableQuantity: 10
Billing process:
Initial purchase (June 18, 2021 - July 17, 2021):
You start with 10 licenses at EUR 10.08 each for one month. This calculation is straightforward - you pay the full price because you're using the licenses for the entire period:
EUR 10.08 per license × 10 licenses = EUR 100.8 total
Initial purchase (June 18, 2021 - July 17, 2021):
If you renew the subscription for another month, you maintain 10 licenses at EUR 10.08 each for another month. The only difference to note is that the
ChargeType
changes to "Renew."EUR 10.08 per license × 10 licenses = EUR 100.8 total
Reconciliation line items for the June billing period:
OrderDate | ChargeStartDate | ChargeEndDate | ChargeType | EffectiveUnitPrice | BillableQuantity | Total | SubscriptionStartDate | SubscriptionEndDate |
---|---|---|---|---|---|---|---|---|
June 18, 2021 | June 18, 2021 | July 17, 2021 | new | 10.08 | 10 | 100.8 | June 18, 2021 | July 17, 2021 |
Example 2
Let's say, on June 18, 2020, you bought 10 licenses of Microsoft 365 Business Standard annual subscription with monthly billing plan for a unit price of EUR 10.08. Your goal is to reconcile your charges in the billing period efficiently.
Scenario:
Annual subscription (monthly payment/billing)
- OrderDate: June 18, 2021
- ChargeStartDate: June 18, 2021
- ChargeEndDate: July 17, 2021
- SubscriptionStartDate: June 18, 2021
- SubscriptionEndDate: July 17, 2022
- ChargeType: new
- UnitPrice: EUR 10.08
- EffectiveUnitPrice: EUR 10.08
- BillableQuantity: 10
Billing process:
Initial purchase (June 18, 2021 - July 17, 2021):
You start with 10 licenses at EUR 10.08 each for one month. This calculation is straightforward - you pay the full price because you're using the licenses for the entire period:
EUR 10.08 per license × 10 licenses = EUR 100.8 total
Initial purchase (June 18, 2021 - July 17, 2021):
Since you choose to pay for the subscription each month, you see the same charges on your bill every month. However, the
ChargeType
changes to "cycleCharge" starting from the second month until the end of the billing term on June 17, 2022.EUR 10.08 per license × 10 licenses = EUR 100.8 total
Reconciliation line items for the June billing period:
OrderDate | ChargeStartDate | ChargeEndDate | ChargeType | EffectiveUnitPrice | BillableQuantity | Total | SubscriptionStartDate | SubscriptionEndDate |
---|---|---|---|---|---|---|---|---|
June 18, 2021 | June 18, 2021 | July 17, 2021 | new | 10.08 | 10 | 100.8 | June 18, 2021 | June 17, 2022 |
Example 3
Let's say, on June 18, 2020, you bought 10 licenses of Microsoft 365 Business Standard annual subscription with upfront payment for a unit price of EUR 100. Your goal is to reconcile your charges in the billing period efficiently.
Scenario:
Annual subscription (upfront payment/billing)
- OrderDate: June 18, 2021
- ChargeStartDate: June 18, 2021
- ChargeEndDate: July 17, 2022
- SubscriptionStartDate: June 18, 2021
- SubscriptionEndDate: July 17, 2022
- ChargeType: new
- UnitPrice: EUR 100.00
- EffectiveUnitPrice: EUR 100.00
- BillableQuantity: 10
Billing process:
Initial purchase (June 18, 2021 - July 17, 2022):
You start with 10 licenses at EUR 100 each for one month. This calculation is straightforward - you pay the full price because you're using the licenses for the entire period:
EUR 100 per license × 10 licenses = EUR 1,000.00 total
Reconciliation line items for the June billing period:
OrderDate | ChargeStartDate | ChargeEndDate | ChargeType | EffectiveUnitPrice | BillableQuantity | Total |
---|---|---|---|---|---|---|
June 18, 2021 | June 18, 2021 | June 17, 2022 | new | 100 | 10 | 1,000.00 |
Your reconciliation data shows how much you're billed for your subscriptions. Clearly understanding these details helps you stay on top of your subscription costs and simplify your financial tracking.
Effective billing reconciliation ensures accurate financial records and smooth management of your business subscriptions.
- Maintain accuracy: Regularly check your billing statements to verify that all transactions match your records.
- Identify discrepancies: Quickly spot any inconsistencies to address potential issues before they escalate.
- Streamline processes: Implement efficient systems to automate and simplify your billing reconciliation tasks.
Understand the reconciliation process of complex products like Microsoft 365 E5
When you buy Microsoft 365 E5, which includes both telecommunication and non-telecommunication services—your invoice shows two separate charges for clarity and easier management. Here's how these charges are typically broken down:
Service categories
- Telecommmunication services: Includes communication-related services like phone calls and Microsoft Teams calls.
- Non-telecommmunication services: Encompasses Office apps, storage, and security features.
Billing reconciliation
- Single reconciliation, two lines: Two line items on the same invoice reconciliation for easier expense categorization.
Telecommunication charges
Telecommunication charges typically cover services like phone calls, audio conferencing, and other communication-related features included in the Microsoft 365 E5 plan.
Example line item for telecommunication charges:
OrderDate | ChargeStartDate | ChargeEndDate | ChargeType | EffectiveUnitPrice | BillableQuantity | Total | ProductName | SubscriptionId |
---|---|---|---|---|---|---|---|---|
June 18, 2021 | June 18, 2021 | July 17, 2021 | new | 5.00 | 10 | 50.00 | Office 365 E5 | aaaa0a0a-bb1b-cc2c-dd3d-eeeeee4e4e4e |
Non-telecommunication charges
Non-telecommunication charges cover everything else included in the Microsoft 365 E5 suite, such as productivity tools (Word, Excel, PowerPoint), email services (Outlook), collaboration tools (Teams, SharePoint), and more.
Example line item for non-telecommunication charges:
OrderDate | ChargeStartDate | ChargeEndDate | ChargeType | EffectiveUnitPrice | BillableQuantity | Total | ProductName | SubscriptionId |
---|---|---|---|---|---|---|---|---|
June 18, 2021 | June 18, 2021 | July 17, 2021 | new | 25.00 | 10 | 250.00 | Office 365 E5 | aaaa0a0a-bb1b-cc2c-dd3d-eeeeee4e4e4e |
Calculation for Microsoft 365 E5 total charges
To determine the total charges for your Microsoft 365 E5 subscription, add together the totals from both the telecommunication and non-telecommunication line items using the SubscriptionId
.
Total charges calculation:
Total charges = Total telecommunication charges + Total non-telecommunication charges
Total charges = USD 50.00 + USD 250.00 = USD 300.00
Purpose of separation
- Tax and regulatory compliance: Telecom services often have different tax rates and regulations, making separation necessary for accurate reporting.
- Expense tracking and budgeting: Separating these charges helps allocate funds for communication versus software, helping financial planning.
License-based and usage-based
- Bundle inclusion: Microsoft 365 E5 includes both types of services, allowing organizations to assess usage for future license adjustments.
- Charge calculation: Telecom charges might be usage-based, while non-telecom could be flat-rate per user. Check the details before purchasing. For more information, see reconciliation of telco pay-as-you-go charges.
This method of billing provides clarity and simplifies the reconciliation process, allowing you to effectively track and manage your subscription costs, and supporting both financial and regulatory needs.
Distinguish between one-time and recurring charges in invoice reconciliation files or line items
To effectively differentiate between one-time and recurring charges in invoice reconciliation files or line items, follow these guidelines:
One-time or upfront charges:
Ensure that the
ChargeStartDate
andChargeEndDate
match theSubscriptionStartDate
andSubscriptionEndDate
.Verify that the
BillingFrequency
is left blank.
Recurring payment or billing plan:
Check that the
ChargeStartDate
andChargeEndDate
are a month apart and confirm theBillingFrequency
is "Monthly."Alternatively, ensure the
ChargeStartDate
andChargeEndDate
are a year apart, with theBillingFrequency
set to "Annual."
By following these steps, you should be able to clearly distinguish between one-time and recurring charges, ensuring accurate and efficient reconciliation.
Calculate the costs of a product or subscription with both fixed fee and pay-as-you-go charges
Maximizing the benefits of your subscription-based products is straightforward. Many products come with a fixed number of prepaid units and extra usage charged at a pay-as-you-go rate. For example:
With a Microsoft 365 subscription, you pay USD 10 per month for 100 minutes of calls. Any extra minutes cost 10 cents each.
With SendGrid, you pay USD 10 per month to send 100 emails. Extra emails cost 10 cents each.
To efficiently manage your subscription costs using daily rated usage and invoice reconciliation data, follow these steps:
Understand daily charges: The
BillingPreTaxTotal
shows your daily pay-as-you-go charges. For instance, using 50 extra minutes at 10 cents per minute cost you USD 5 for that day.Verify charges: Compare your monthly pay-as-you-go charges shown in the invoice reconciliation data (
Total
) with your daily usage charges. For example, if you see USD 5 for 50 extra units (BillableQuantity
), it matches your daily usage.Identify subscription costs: Your fixed monthly plan cost is shown in the
Total
, which should be USD 10 each month.Calculate total cost: Check the Product and SKU IDs in the invoice reconciliation data. Typically, you have line items for both fixed fees and pay-as-you-go costs. The combined total should be USD 15.
By following these steps, you can effectively manage and optimize your subscription expenses. This approach encourages smart usage and clear oversight of your costs.
Determine the product category
Here's how you can identify the product category in the reconciliation data. These methods are effective for most transactions, with occasional exceptions.
Condition | Product Category |
---|---|
PublisherName says "Microsoft" or "Microsoft Corporation" |
Microsoft product |
PublisherName isn't "Microsoft" or "Microsoft Corporation," and PublisherId isn't empty. |
Non-Microsoft or marketplace product |
TermAndBillingCycle mentions "Reservation" |
Azure reservation |
TermAndBillingCycle includes "Savings Plan" |
Azure savings plan |
TermAndBillingCycle contains "one-month," "one-year," or "three-year" |
License-based. However, double-check to be sure. |
TermAndBillingCycle mentions "Subscription" If "Subscription" is missing, use the SKU name like "SQL Server" or "Windows Server." |
Software subscription |
TermAndBillingCycle is blank, and ChargeEndDate is empty |
Perpetual software |
SubscriptionDescription says "Azure plan" |
Azure plan |
For all remaining conditions | Use "Azure plan" as the name for the remaining product category. Feel free to customize each subscription name as needed. Ensure nothing is missing. |
These guidelines should help you efficiently categorize your products, making your reconciliation process smoother and more accurate.
Determine the billing term and billing plan in invoice reconciliation files or line items
Understanding your subscription's billing term and plan is key to managing payments and renewals. Here's how to interpret these details in your invoice reconciliation files or line items:
Key definitions
Billing term:
The total duration of your subscription, from theSubscriptionStartDate
to theSubscriptionEndDate
.- Example: A one-year term spans from May 25, 2021 to May 24, 2022.
Billing plan:
How often you’re billed within the term, defined by the interval betweenChargeStartDate
andChargeEndDate
.- Example: A one-year term with monthly billing charges you every month (May 25–June 24, June 25–July 24, etc.).
Interpret the TermAndBillingCycle
field
This field varies by subscription type and isn't standardized. Use the dates to clarify:
TermAndBillingCycle | Subscription Start Date | Subscription End Date | Charge Start Date | Charge End Date | Billing Frequency/Plan | Billing Term |
---|---|---|---|---|---|---|
One-month commitment for monthly billing | May 25, 2021 | June 24, 2021 | May 25, 2021 | June 24, 2021 | One-month | |
One-year commitment for monthly/yearly billing | May 25, 2021 | May 24, 2022 | May 25, 2021 | June 24, 2021 | Monthly | One-year |
One-year term duration | May 25, 2021 | May 24, 2022 | May 25, 2021 | May 24, 2022 | One-year | |
Three-year commitment for monthly/yearly billing | May 25, 2021 | May 24, 2024 | May 25, 2021 | June 24, 2021 | Monthly | Three-year |
Three-year commitment for monthly/yearly billing | May 25, 2021 | May 24, 2024 | May 25, 2021 | May 24, 2022 | Annual | Three-year |
Three-year commitment for monthly/yearly billing | May 25, 2021 | May 24, 2024 | May 25, 2021 | May 24, 2024 | Three-year |
Follow these steps for clarity
Check dates, not
TermAndBillingCycle
:Use
SubscriptionStartDate
andSubscriptionEndDate
to confirm the term.Billing term = SubscriptionEndDate - SubscriptionStartDate
Use
ChargeStartDate
andChargeEndDate
to identify billing frequency.Billing plan = ChargeEndDate - ChargeStartDate
- When charge period equals subscription period, the subscription is billed upfront.
Cross-reference
BillingFrequency
:Monthly: Charges repeat every month within the billing term.
Annual: Charges repeat yearly within the billing term.
Empty: Single charge for the full term (for example, one-month or three-year upfront).
By understanding these terms, manage your subscriptions and charge cycles. This knowledge empowers you to keep track upcoming charges and can avoid any confusion related to your billing statements.
Subscription expiration and renewal dates on special cases
Here's when monthly subscriptions expire when you buy near the end of a month:
- If you buy on the last day of a month
- If you buy on the day before the last day or second-last day of a month
When you buy on the last day of a month
If you start a monthly or annual subscription billed monthly on the last day of a month, your next billing or renewal occurs one day earlier in the following month.
Example:
- If the next month has 31 days, your subscription ends on the 30th day.
- If the next month has 30 days, your subscription ends on the 29th day.
- If the next month is February in a nonleap year, your subscription ends on the 27th day.
- If the next month is February in a leap year, your subscription ends on the 28th day.
Note
Each line item is a standalone entity with its own charge cycle. All dates are in Coordinated Universal Time (UTC).
Reconciliation line items of the subscription:
BillingTerm | OrderDate | ChargeType | SubscriptionStartDate | SubscriptionEndDate | RenewDate | ChargeStartDate | ChargeEndDate |
---|---|---|---|---|---|---|---|
Monthly | January 31, 2021 | new | January 31, 2021 | February 27, 2021 | February 28, 2021 | January 31, 2021 | February 27, 2021 |
Monthly | February 28, 2021 | new | February 28, 2021 | March 30, 2021 | March 28, 2021 | February 28, 2021 | March 30, 2021 |
Monthly | May 31, 2021 | new | May 31, 2021 | June 29, 2021 | June 30, 2021 | May 31, 2021 | June 29, 2021 |
Monthly | June 30, 2021 | new | June 30, 2021 | July 29, 2021 | July 30, 2021 | June 30, 2021 | July 29, 2021 |
Monthly | July 31, 2021 | new | July 31, 2021 | August 30, 2021 | August 31, 2021 | July 31, 2021 | August 30, 2021 |
When you buy on the day before the last day or second-last day of a month
If you start a monthly or annual subscription billed monthly on the second-last day of a month, your next billing or renewal occurs two days earlier in the following month.
Example:
- If the next month has 31 days, your subscription ends on the 29th day.
- If the next month has 30 days, your subscription ends on the 28th day.
- If the next month is February in a nonleap year, your subscription ends on the 26th day.
- If the next month is February in a leap year, your subscription ends on the 27th day.
Note
Each line item is a standalone entity with its own charge cycle. All dates are in Coordinated Universal Time (UTC).
Reconciliation line items of the subscription:
BillingTerm | OrderDate | ChargeType | SubscriptionStartDate | SubscriptionEndDate | RenewDate | ChargeStartDate | ChargeEndDate |
---|---|---|---|---|---|---|---|
Monthly | January 30, 2021 | new | January 30, 2021 | February 26, 2021 | February 27, 2021 | January 30, 2021 | February 26, 2021 |
Monthly | February 27, 2021 | new | February 27, 2021 | March 29, 2021 | March 30, 2021 | February 27, 2021 | March 29, 2021 |
Monthly | May 30, 2021 | new | May 30, 2021 | June 29, 2021 | June 30, 2021 | May 30, 2021 | June 29, 2021 |
Monthly | June 29, 2021 | new | June 29, 2021 | July 28, 2021 | July 29, 2021 | June 29, 2021 | July 28, 2021 |
Monthly | July 30, 2021 | new | July 30, 2021 | August 29, 2021 | August 30, 2021 | July 30, 2021 | August 29, 2021 |
Reconcile charges after adding or removing licenses of a subscription
Learn how we adjust charges for license-based products when you update the license count, including prorated charges and refunds.
Key concepts
Charge cycle: Typically 30 or 31 days, but 28 or 29 for February for monthly billed subscriptions. It starts from your initial purchase date or when renewal or recurring charges begin. For annual subscriptions, the cycle charge is 365 days (366 in leap years). To learn more about how charge cycles are determined, see new commerce charge cycle.
Daily rate: Unit price ÷ total days in the charge cycle.
Prorate charge cycle or billing days: Number of days from the change until the end of the charge cycle.
Effective unit price: Daily rate × billing days.
Total: Effective unit price x license count.
Total amounts might change due to taxes, exchange rates, and other adjustments.
Add licenses
Scenario:
Let's say you bought 10 licenses of a monthly "Microsoft 365 Business Standard" subscription on June 18, 2021. Each license costs EUR 10.08. On June 20, you added two more licenses.
- June 18: Purchase 10 licenses of "Microsoft 365 Business Standard" at EUR 10.08/month.
- June 20: Add two licenses (total 12).
- Charge cycle: June 18 – July 17 (30 days) since June has 30 days.
- Prorate charge cycle or billing days: June 20 – July 17 (28 days).
To change the number of licenses, the system goes through a two-step process that happens simultaneously:
Refund (Wipe): Refund your unused portion. The system looks at:
- Your current number of licenses
- The remaining days in your billing cycle
- The daily rate for each license
Charge (Recreate): Charge for the new license count, but only for the remaining days.
Billing process
Initial purchase (June 18):
You start with 10 licenses at EUR 10.08 each for a full 30-day cycle. This calculation is straightforward - you pay the full price because you're using the licenses for the entire period:
EUR 10.08 per license × 10 licenses = EUR 100.80 total
Adding licenses (June 20):
When you add two licenses two days into your cycle, the system calculates:
First, the refund for your existing 10 licenses:
Original daily rate: EUR 10.08 ÷ 30 days = EUR 0.336 per day
Remaining days: 28 days
Effective unit price: EUR 0.336 × 28 = EUR 9.408 per license
Refund amount: EUR 9.408 × 10 licenses = EUR 94.08 (rounded down to two decimal places)
Then, the new charge for 12 licenses:
Same daily rate: EUR 0.336 per day
Same remaining days: 28 days
Same effective unit price: EUR 9.408 per license
New charge: EUR 9.408 × 12 licenses = EUR 112.89 (rounded down to two decimal places)
Remove licenses
Scenario:
If you removed four licenses on June 20, we adjust the charges accordingly.
- June 20: Add two licenses (total 12).
- June 20: Remove four licenses (total 8).
- Charge cycle: June 18 – July 17 (30 days) since June has 30 days.
- Prorate charge cycle or billing days: June 20 – July 17 (28 days).
Billing process
Removing licenses (June 20):
First, refund the current 12 licenses:
Daily rate: EUR 0.336 per day
Remaining days: 28 days
Effective unit price: EUR 9.408 per license
Refund amount: EUR 9.408 × 12 licenses = EUR 112.89 (rounded down to two decimal places)
Then, charge for the new eight licenses:
Same daily rate: EUR 0.336 per day
Same remaining days: 28 days
Same effective unit price: EUR 9.408 per license
New charge: EUR 9.408 × 8 licenses = EUR 75.26 (rounded down to two decimal places)
Reconciliation line items for June billing period after adding and removing the licenses:
OrderDate | ChargeType | UnitPrice | ChargeStartDate | ChargeEndDate | EffectiveUnitPrice | BillableQuantity | Total |
---|---|---|---|---|---|---|---|
June 18, 2021 | new | 10.08 | June 18, 2021 | July 17, 2021 | 10.08 | 10 | 100.8 |
June 20, 2021 | addQuantity | 10.08 | June 20, 2021 | July 17, 2021 | –9.408 | 10 | –94.08 |
June 20, 2021 | addQuantity | 10.08 | June 20, 2021 | July 17, 2021 | 9.408 | 12 | 112.89 |
June 20, 2021 | removeQuantity | 10.08 | June 20, 2021 | July 17, 2021 | –9.408 | 12 | –112.89 |
June 20, 2021 | removeQuantity | 10.08 | June 20, 2021 | July 17, 2021 | 9.408 | 8 | 75.26 |
Add and remove license with cross-charge-cycle:
Scenario:
Assuming you added two licenses on July 2 and removed four licenses on July 3, these changes would be reflected in the July reconciliation line items. Our billing cycle aligns with the calendar month, and according to our reconciliation principles, only transactions occurring within a specific month are included in that month's reconciliation. This method ensures accuracy and transparency in our billing process.
- June 18: Purchase 10 licenses of "Microsoft 365 Business Standard" at EUR 10.08/month.
- July 2: Add two licenses (total 12).
- July 3: Remove four licenses (total 8).
- Charge cycle: June 18 – July 17 (30 days). The changes occurred in July, while the purchase was made in June, which has 30 days.
- Prorate charge cycle or billing days when adding license: July 2 – July 17 (16 days).
- Prorate charge cycle or billing days when removing license: July 5 – July 17 (13 days).
Billing process
Initial purchase (June 18):
Initial purchase was on June 18 and already included in the June reconciliation line items. It doesn't appear again in July reconciliation line items.
Adding licenses (July 2) :
When you add two licenses two days into your cycle, the system calculates:
First, the refund for your existing 10 licenses:
Original daily rate: EUR 10.08 ÷ 30 days = EUR 0.336 per day
Remaining days: 16 days
Effective unit price: EUR 0.336 × 16 = EUR 5.376 per license
Refund amount: EUR 5.376 × 10 licenses = EUR 53.76 (rounded down to two decimal places)
Then, the new charge for 12 licenses:
Same daily rate: EUR 0.336 per day
Same remaining days: 16 days
Same effective unit price: EUR 5.376 per license
New charge: EUR 5.376 × 12 licenses = EUR 64.51 (rounded down to two decimal places)
Removing licenses (July 5) :
When you remove four licenses two days into your cycle, the system calculates:
First, the refund for your existing 12 licenses:
Original daily rate: EUR 10.08 ÷ 30 days = EUR 0.336 per day
Remaining days: 13 days
Effective unit price: EUR 0.336 × 13 = EUR 4.368 per license
Refund amount: EUR 4.368 × 12 licenses = EUR 52.41 (rounded down to two decimal places)
Then, the new charge for eight licenses:
Same daily rate: EUR 0.336 per day
Same remaining days: 13 days
Same effective unit price: EUR 4.368 per license
New charge: EUR 4.368 × 8 licenses = EUR 34.94 (rounded down to two decimal places)
Reconciliation line items for July billing period after adding and removing the licenses:
OrderDate | ChargeType | UnitPrice | ChargeStartDate | ChargeEndDate | EffectiveUnitPrice | BillableQuantity | Total |
---|---|---|---|---|---|---|---|
July 2, 2021 | addQuantity | 10.08 | July 2, 2021 | July 17, 2021 | –5.376 | 10 | –53.76 |
July 2, 2021 | addQuantity | 10.08 | July 2, 2021 | July 17, 2021 | 5.376 | 12 | 64.51 |
July 5, 2021 | removeQuantity | 10.08 | July 5, 2021 | July 17, 2021 | –4.368 | 12 | –52.41 |
July 5, 2021 | removeQuantity | 10.08 | July 5, 2021 | July 17, 2021 | 4.368 | 8 | 34.94 |
Understand the refund calculation process for cancellations
When you cancel a subscription, the system performs two main calculations:
- Determines what you already paid for.
- Calculates the refund for the unused portion.
Key concepts
Charge cycle: Typically 30 or 31 days, but 28 or 29 for February for monthly billed subscriptions. It starts from your initial purchase date or when renewal or recurring charges begin. For annual subscriptions, the cycle charge is 365 days (366 in leap years). To learn more about how charge cycles are determined, see new commerce charge cycle.
Daily rate: Unit price ÷ total days in the charge cycle.
Cancellation and unused days: Number of days from the cancellation until the end of the charge cycle.
Effective unit price for refund: Daily rate × unused days.
Total refund: Effective unit price x license count.
Total cost and refund might change due to taxes, exchange rates, and other adjustments.
Cancel a subscription
Scenario:
Let's assume, you bought 10 licenses of a monthly "Microsoft 365 Business Standard" subscription on July 15, 2021, and canceled it on July 17. Each license costs EUR 10.08.
- July 15: Purchase 10 licenses of "Microsoft 365 Business Standard" at EUR 10.08/month.
- July 17: Canceled the subscription.
- Charge cycle: July 15 – August 14 (31 days). July has 31 days.
- Unused days after canceling the subscription: July 17 – August 14 (29 days).
Billing process
Initial purchase (July 15):
You start with 10 licenses at EUR 10.08 each for a full 31-day cycle. This calculation is straightforward - you pay the full price because you're using the licenses for the entire period:
EUR 10.08 per license × 10 licenses = EUR 100.80 total
Then, you cancel the subscription on July 17:
Original daily rate: EUR 10.08 ÷ 31 days = EUR 0.32516129 per day
Remaining days: 29 days
Effective unit price: EUR 0.32516129 × 29 = EUR 9.429677419 per license
Refund amount: EUR 9.429677419 × 10 licenses = EUR 94.20 (rounded down to two decimal places)
Reconciliation line items for the July billing period after cancellation:
OrderDate | ChargeType | UnitPrice | ChargeStartDate | ChargeEndDate | EffectiveUnitPrice | BillableQuantity | Total |
---|---|---|---|---|---|---|---|
July 15, 2021 | new | 10.08 | July 15, 2021 | August 14, 2021 | 10.08 | 10 | 100.8 |
July 17, 2021 | cancelImmediate | 10.08 | July 17, 2021 | August 14, 2021 | –9.429677419 | 10 | –94.20 |
Refund calculation summary for cancellations
The refund policy applies to all new commerce per-user or license-based subscriptions, regardless of length.
24-hour full refund:
- Eligibility: Cancel within 24 hours of purchase or renewal.
- Cancellation method: Self-serve through the system.
- Refund processing time: Takes up to 24 hours. Check your estimates files or line items for confirmation.
Seven-day prorated refund:
- Eligibility: Cancel after 24 hours but within seven days of purchase or renewal.
- Refund calculation: Based on the time elapsed ("unused portion").
- Cancellation method: Self-serve through the system.
- Refund processing time: Takes up to 24 hours. Check your estimates files or line items for confirmation.
Beyond seven days no refund:
- After seven days, no refund is provided. Cancellation method: For unique situations or exceptional cases, open a support ticket but the refund isn't guaranteed. For more information, see new commerce cancellation policy.
- Refund processing time: Depends on the eligibility checks and processing time. Check your estimates files or line items for confirmation.
Important
Annual subscriptions: The daily rate calculation remains consistent. For an annual subscription with 365 or 366 (leap year) days, the daily rate would be:
- Daily rate = (Annual unit price) ÷ (365 or 366)
The same method applies for calculating unused days and the refund amount.
- Varying month lengths: The calculation adjusts based on the number of days in the charge cycle. For example, if it starts in February, the daily rate accounts for whether the month has 28 or 29 days.
The refund process is designed to ensure fairness by prorating based on unused days. Understanding the daily rate calculation and how it applies to different scenarios helps in predicting refund amounts and managing subscription costs effectively. For specific cases like annual subscriptions or multiple licenses, the same principles apply, with adjustments for the unique parameters of each situation.
Reconcile and link upgraded subscriptions
Understanding how to upgrade a subscription is essential to effectively managing your services and costs. Here's how the process works:
When you upgrade a subscription, you transition from one service tier to another. The system ensures you're billed accurately for the services you use. If you upgrade from a basic to a premium subscription mid-month, you're charged the basic rate for the period you used it and the premium rate for the rest of the charge cycle.
There are two main types of upgrades:
Full upgrade: Moving all your licenses from one service level to another. All users have access to the new service tier.
Partial upgrade: Upgrade only a portion of your licenses to the premium service level. This process allows you to customize service levels according to specific needs within your organization.
By understanding these upgrade options, you can manage your subscriptions and costs more effectively. Upgrades help a smooth transition to a service level that aligns perfectly with your requirements.
Key concepts of reconciling old and new subscriptions
Identify the upgrade date: Determine the exact date when the upgrade occurred. This date marks the transition point from the old subscription to the new one and the prorated refunds and charges are calculated from this date.
Charge cycle: Typically 30 or 31 days, but 28 or 29 for February for monthly billed subscriptions. It starts from your initial purchase date or when renewal or recurring charges begin. For annual subscriptions, the cycle charge is 365 days (366 in leap years). To learn more about how charge cycles are determined, see new commerce charge cycle.
Daily rate: Unit price ÷ total days in the charge cycle.
Prorate charge cycle or billing days: Number of days from the upgrade until the end of the charge cycle.
Effective unit price: Daily rate × billing days.
Calculate prorated charges and refunds:
For the old subscription: Compute the refund for the period from the upgrade date to the end of the charge cycle. Use the formula:
- Refund = Effective unit price × license count.
For the new subscription: Calculate the charge from the upgrade date to the end of the charge cycle using the same formula.
- Charge = Effective unit price × license count.
Total refunds and charges might change due to taxes, exchange rates, and other adjustments.
Full upgrade
Scenario:
Let's say, you bought 300 licenses of a monthly "Microsoft 365 Business Standard" subscription on June 18 for your customer Contoso. Each license costs EUR 10.08. On June 25, you upgraded the subscription to "Office 365 E1," as per Contoso's request. The new subscription's price for each license is EUR 6.43.
- June 18: Initial purchase of 300 licenses of a "Microsoft 365 Business Standard" subscription at EUR 10.08/month.
- June 25: Upgrade all 300 licenses to "Office 365 E1" subscription at EUR 6.43/month.
- Charge cycle: June 18 to July 17 (30 days total) since June has 30 days.
Billing process:
Initial charge (June 18 - July 17):
You're initially charged for "Microsoft 365 Business Standard" from June 18 to July 17.
Total charge: 300 licenses × EUR 10.08 per license = EUR 3,024 (rounded down to two decimal places)
Refund for unused period (June 25 - July 17):
After you upgrade the subscription to "Office 365 E1" on June 25, a refund is issued for the unused portion of "Microsoft 365 Business Standard" from June 25 to July 17.
Daily rate: EUR 10.08 ÷ 30 days = EUR 0.336 per day Remaining period: 23 days (June 25 to July 17) Effective unit price: EUR 0.336 × 23 days = EUR 7.72 per license Total refund: EUR 7.72 × 300 licenses = EUR 2,316 (rounded down to two decimal places)
Charge for new subscription (June 25 - July 17):
You're billed for "Office 365 E1" from June 25 to July 17.
Daily rate: EUR 6.43 ÷ 30 days = EUR 0.214 per day Same remaining period: 23 days (June 25 to July 17) Effective unit price: EUR 0.214 × 23 days = EUR 4.92 per license Total charge: EUR 4.92 × 300 licenses = EUR 1,476 (rounded down to two decimal places)
Reconciliation line items for June billing period after full upgrade:
OrderDate | ProductName | ChargeType | UnitPrice | ChargeStartDate | ChargeEndDate | EffectiveUnitPrice | BillableQuantity | Total | SubscriptionId | ReferenceId |
---|---|---|---|---|---|---|---|---|---|---|
June 18, 2021 | Microsoft 365 Business Standard | new | 10.08 | June 18, 2021 | July 17, 2021 | 10.08 | 300 | 3024 | aaaa0a0a-bb1b-cc2c-dd3d-eeeeee4e4e4e | aaaa0000-bb11-2222-33cc-444444dddddd |
June 25, 2021 | Microsoft 365 Business Standard | convert | 10.08 | June 25, 2021 | July 17, 2021 | –7.72 | 300 | –2316 | aaaa0a0a-bb1b-cc2c-dd3d-eeeeee4e4e4e | bbbb1111-cc22-3333-44dd-555555eeeeee |
June 25, 2021 | Office 365 E1 | convert | 6.43 | June 25, 2021 | July 17, 2021 | 4.92 | 300 | 1476 | bbbb1b1b-cc2c-dd3d-ee4e-ffffff5f5f5f | bbbb1111-cc22-3333-44dd-555555eeeeee |
Partial upgrade
Scenario:
Let's say, you bought 300 licenses of a monthly "Microsoft 365 Business Standard" subscription on June 18 for your customer Contoso. Each license costs EUR 10.08. On June 25, you upgraded 100 licenses of the subscription to "Office 365 E1," as per Contoso's request. The new subscription's price for each license is EUR 6.43.
- June 18: Initial purchase of 300 licenses of a "Microsoft 365 Business Standard" subscription at EUR 10.08/month.
- June 25: Upgrade only 100 licenses to "Office 365 E1" subscription at EUR 6.43/month.
- Charge cycle: June 18 to July 17 (30 days total) since June has 30 days.
Billing process:
Initial charge (June 18 - July 17):
You're initially charged for "Microsoft 365 Business Standard" from June 18 to July 17.
Total charge: 300 licenses × EUR 10.08 per license = EUR 3,024 (rounded down to two decimal places)
Refund for unused period (June 25 - July 17):
After you upgrade the subscription to "Office 365 E1" on June 25, a refund is issued for the unused portion of "Microsoft 365 Business Standard" from June 25 to July 17.
Daily rate: EUR 10.08 ÷ 30 days = EUR 0.336 per day Remaining period: 23 days (June 25 to July 17) Unused license count: 100 becuse you upgraded those licenses Effective unit price: EUR 0.336 × 23 days = EUR 7.72 per license Total refund: EUR 7.72 × 100 licenses = EUR 772 (rounded down to two decimal places)
Charge for new subscription (June 25 - July 17):
You're billed for "Office 365 E1" from June 25 to July 17.
Daily rate: EUR 6.43 ÷ 30 days = EUR 0.214 per day Same remaining period: 23 days (June 25 to July 17) Same license count: 100 becuse you upgraded those licenses Effective unit price: EUR 0.214 × 23 days = EUR 4.92 per license Total charge: EUR 4.92 × 100 licenses = EUR 492 (rounded down to two decimal places)
Reconciliation line items for June billing period after partial upgrade:
OrderDate | ProductName | ChargeType | UnitPrice | ChargeStartDate | ChargeEndDate | EffectiveUnitPrice | BillableQuantity | Total | SubscriptionId | ReferenceId |
---|---|---|---|---|---|---|---|---|---|---|
June 18, 2021 | Microsoft 365 Business Standard | new | 10.08 | June 18, 2021 | July 17, 2021 | 10.08 | 300 | 3024 | aaaa0a0a-bb1b-cc2c-dd3d-eeeeee4e4e4e | aaaa0000-bb11-2222-33cc-444444dddddd |
June 25, 2021 | Microsoft 365 Business Standard | convert | 10.08 | June 25, 2021 | July 17, 2021 | –7.72 | 100 | -772 | aaaa0a0a-bb1b-cc2c-dd3d-eeeeee4e4e4e | bbbb1111-cc22-3333-44dd-555555eeeeee |
June 25, 2021 | Office 365 E1 | convert | 6.43 | June 25, 2021 | July 17, 2021 | 4.92 | 100 | 492 | bbbb1b1b-cc2c-dd3d-ee4e-ffffff5f5f5f | bbbb1111-cc22-3333-44dd-555555eeeeee |
Note
Charge types:
- The "convert" charge type is used when upgrading to a new subscription.
- The "moveQuantity" charge type applies when you already have the advanced subscription and are adjusting quantities.
This approach ensures transparent and equitable billing, accurately reflecting the services used before and after the upgrade. Final amounts may vary due to taxes and exchange rates, but the core principle of paying only for what you use remains consistent.
Link old and new subscriptions after upgrade
To associate the refund for the old subscription with the charge for the new subscription, follow these steps:
Identify the
SubscriptionId
: Find theSubscriptionId
of the original subscription. This step helps with tracking all related transactions.Find the matching
ReferenceId
: Search through your reconciliation files or line items to match theReferenceId
linked to your baseSubscriptionId
. ThisReferenceId
connects the refund to the subsequent charge.Link related transactions: Use the identified
ReferenceId
to associate all related transactions. This step includes the refund for the old subscription and the charge for the new one. This step ensures a clear and direct connection between these financial adjustments.
By following these steps, you can manage and reconcile your billing information, ensuring transparency and accuracy in your financial records.
Tip
Optimize your subscription after upgrading from lower to higher product version or SKU
If you upgraded to a product that includes your base services and previous add-ons, check if you can cancel the redundant add-ons and get refunds for unused portions. Here's how to do it:
Review your subscriptions Understand the services provided by your current subscription and add-ons. Identify overlaps with your upgraded product.
Check eligibility for cancellations and refunds Contact support to inquire about the criteria for canceling add-ons and getting refunds. Discuss:
Terms and conditions: Ask about specific rules for cancellation and refunds.
Unused period: Confirm how the unused portion is calculated and what refund you might be eligible for.
Refund process: Understand how to request and receive refunds, including any necessary documentation or steps.
Submit your cancellation and refund requests
Once you know you're eligible and understand the process, submit your requests to cancel the add-ons and start the refund process. Follow the support team's instructions carefully to ensure smooth processing.
By following these steps, you can seamlessly transition to your upgraded product and avoid paying for unnecessary services.
Determining the total number of licenses of a subscription after multiple adjustments
Calculating total licenses accurately is crucial for effectively managing subscriptions. Here's a streamlined process using Contoso as an example to illustrate this calculation methodically.
Example
Let's say, you initially purchased 10 licenses of an annual "Microsoft 365 Business Standard" subscription with a monthly billing plan for your customer Contoso on March 5, 2022. Throughout the billing period, you made several changes to the license count based on their team size and project requirements.
March 5: Purchased 10 licenses of "Microsoft 365 Business Standard" subscription. The
SubscriptionId
for this purchase is "284b0ff0-0e74-4f65-cb23-f8ad95867994."March 7: Added 5 licenses.
March 10: Added 10 licenses.
March 12: Removed 2 licenses.
March 14: Removed 3 licenses.
March 25: Added 10 licenses.
March 27: Upgraded five licenses to Office 365 E1.
To determine the total number of licenses after adjustments for the Microsoft 365 Business Standard subscription purchased for Contoso, follow these steps:
Step-by-step calculation process
Identify the initial transaction:
- Search for the initial transaction in the billing line items where
ChargeType
is "new" or "cycleCharge" or "renew" for ongoing charge cycle. - Ensure
ProductName
orSkuName
matches "Microsoft 365 Business Standard." - Note the
OrderDate
andSubscriptionId
for this transaction. In this case, theOrderDate
is March 5, 2022 andSubscriptionId
is "284b0ff0-0e74-4f65-cb23-f8ad95867994."
- Search for the initial transaction in the billing line items where
Track subsequent changes:
- Identify all line items related to this subscription by using this condition:
SubscriptionId = "284b0ff0-0e74-4f65-cb23-f8ad95867994" and OrderDate >= "March 5, 2022"
. - For each change (additions or removals), note the
ChargeType
,BillableQuantity
, andEffectiveUnitPrice
.
- Identify all line items related to this subscription by using this condition:
Handle upgrades:
- Treat the full upgrade as both a removal and an addition. Remove the old licenses and add the new ones. For partial upgrades, consider only the removal the old licenses because the upgraded licenses move under a new subscription.
Sum positive adjustments:
Sum the
BillableQuantity
for all line items with a positiveEffectiveUnitPrice
from theOrderDate
(from step 1) onwards. This step includes all licenses added during the billing period.Suggested condition to check:
SubscriptionId = "284b0ff0-0e74-4f65-cb23-f8ad95867994" and OrderDate >= "March 5, 2022" and EffectiveUnitPrice > 0
.Initial purchase: 10 licenses
March 7 addition: 5 licenses
March 10 addition: 10 licenses
March 25 addition: 10 licenses
We get a positive total of 35 licenses.
Sum negative adjustments:
Sum the
BillableQuantity
for all line items with a negativeEffectiveUnitPrice
(excluding "customerCredit"ChargeType
) from theOrderDate
onwards. This step includes all licenses removed during the billing period.Suggested condition to check:
SubscriptionId = "284b0ff0-0e74-4f65-cb23-f8ad95867994" and OrderDate >= "March 5, 2022" and EffectiveUnitPrice < 0
.March 12 removal: 2 licenses
March 14 removal: 3 licenses
March 27 removal: 5 licenses (partially upgraded from Microsoft Business Standard to Office 365 E1)
We get a negative total of 10 licenses.
Calculate net licenses:
Subtract the total removed licenses (from step 5) from the total added licenses (from step 4) to get the net licenses billed for the period.
-
Total = Sum of positive adjustments - Sum of negative adjustments In this case: 35 - 10 = 25 total licenses
By following these steps, systematically track all changes and accurately determine the total number of licenses billed for the period after all adjustments. This approach ensures clarity and helps in managing subscriptions effectively.
Considerations for other billing plans
This method works well for monthly billing plans, as adjustments are typically reflected in each billing cycle. For annual or one-time billed subscriptions, verify each line item individually when changes occur, as billing patterns and adjustment calculations vary.
Reconciliation line items in the March billing period after adjusting and upgrading the licenses:
OrderDate | ProductName | ChargeType | UnitPrice | BillableQuantity | EffectiveUnitPrice | Total | SubscriptionId | ChargeStartDate | ChargeEndDate | ReferenceId |
---|---|---|---|---|---|---|---|---|---|---|
March 5, 2022 | Microsoft 365 Business Standard | new | 12 | 10 | 12.00 | 120 | 284b0ff0-0e74-4f65-cb23-f8ad95867994 | March 5, 2022 | April 4, 2022 | 7d71c595-4635-40d1-a9e2-b34e63b01764 |
March 7, 2022 | Microsoft 365 Business Standard | addQuantity | 12 | 10 | –11.23 | –112.25 | 284b0ff0-0e74-4f65-cb23-f8ad95867994 | March 7, 2022 | April 4, 2022 | 12d33e18-061e-4040-ad77-fcd77c1a9943 |
March 7, 2022 | Microsoft 365 Business Standard | addQuantity | 12 | 15 | 11.23 | 168.38 | 284b0ff0-0e74-4f65-cb23-f8ad95867994 | March 7, 2022 | April 4, 2022 | 12d33e18-061e-4040-ad77-fcd77c1a9943 |
March 10, 2022 | Microsoft 365 Business Standard | addQuantity | 12 | 15 | –10.06 | –150.96 | 284b0ff0-0e74-4f65-cb23-f8ad95867994 | March 10, 2022 | April 4, 2022 | dc2a0a41-6a51-4837-8956-af5ffd92b094 |
March 10, 2022 | Microsoft 365 Business Standard | addQuantity | 12 | 25 | 10.06 | 251.61 | 284b0ff0-0e74-4f65-cb23-f8ad95867994 | March 10, 2022 | April 4, 2022 | dc2a0a41-6a51-4837-8956-af5ffd92b094 |
March 12, 2022 | Microsoft 365 Business Standard | removeQuantity | 12 | 25 | –9.29 | –232.25 | 284b0ff0-0e74-4f65-cb23-f8ad95867994 | March 12, 2022 | April 4, 2022 | 2f8965ff-512b-4233-9a74-1f54a6ad71d0 |
March 12, 2022 | Microsoft 365 Business Standard | removeQuantity | 12 | 23 | 9.29 | 213.67 | 284b0ff0-0e74-4f65-cb23-f8ad95867994 | March 12, 2022 | April 4, 2022 | 2f8965ff-512b-4233-9a74-1f54a6ad71d0 |
March 14, 2022 | Microsoft 365 Business Standard | removeQuantity | 12 | 23 | –8.52 | –195.87 | 284b0ff0-0e74-4f65-cb23-f8ad95867994 | March 14, 2022 | April 4, 2022 | 73b3dc36-f36d-4bbf-af8f-30c9b73ac4f6 |
March 14, 2022 | Microsoft 365 Business Standard | removeQuantity | 12 | 20 | 8.52 | 170.32 | 284b0ff0-0e74-4f65-cb23-f8ad95867994 | March 14, 2022 | April 4, 2022 | 73b3dc36-f36d-4bbf-af8f-30c9b73ac4f6 |
March 25, 2022 | Microsoft 365 Business Standard | addQuantity | 12 | 20 | –4.26 | –85.16 | 284b0ff0-0e74-4f65-cb23-f8ad95867994 | March 25, 2022 | April 4, 2022 | 6759acd5-a8a9-4402-94b7-803baa64a78e |
March 25, 2022 | Microsoft 365 Business Standard | addQuantity | 12 | 30 | 4.26 | 127.74 | 284b0ff0-0e74-4f65-cb23-f8ad95867994 | March 25, 2022 | April 4, 2022 | 6759acd5-a8a9-4402-94b7-803baa64a78e |
March 27, 2022 | Microsoft 365 Business Standard | convert | 12 | 5 | –3.48 | –17.4 | 284b0ff0-0e74-4f65-cb23-f8ad95867994 | March 27, 2022 | April 4, 2022 | a11af6ef-8523-4eba-b1fa-fe5069dedea7 |
March 27, 2022 | Office 365 E1 | convert | 10 | 5 | 2.90 | 14.50 | c30e1e5c-a20f-4640-83d1-1f7a3e664b43 | March 27, 2022 | April 4, 2022 | a11af6ef-8523-4eba-b1fa-fe5069dedea7 |
Reconcile charges after converting a trial subscription to the paid version
Reconciling your billing after converting a trial subscription into the paid version requires a systematic review of your billing records. This approach ensures accuracy and proper accounting.
Key concepts of reconciling free trial and paid subscription
Identify the conversion date: Determine the exact date when the subscription was converted to paid version. This date marks the transition point from the trial version to the paid version and the prorated refunds and charges are calculated from this date.
Charge cycle: Typically 30 or 31 days, but 28 or 29 for February for monthly billed subscriptions. It starts from your initial purchase date or when renewal or recurring charges begin. For annual subscriptions, the cycle charge is 365 days (366 in leap years). To learn more about how charge cycles are determined, see new commerce charge cycle.
Daily rate: Unit price ÷ total days in the charge cycle.
Prorate charge cycle or billing days: Number of days from the upgrade until the end of the charge cycle.
Effective unit price: Daily rate × billing days.
Calculate prorated charges and refunds:
For the trial subscription: Compute the refund for the period from the conversion date to the end of the charge cycle. Use the formula:
- Refund = Effective unit price × license count. However, the refund is always zero because the subscription is a free trial with zero cost. This step is actually to close out the trial subscription.
For the paid subscription: Calculate the charge from the conversion date to the end of the charge cycle using the same formula.
- Charge = Effective unit price × license count.
Total refunds and charges might change due to taxes, exchange rates, and other adjustments.
Scenario:
Suppose you started a free trial for 25 "Dynamics 365 Guides" licenses on June 25, 2021. The trial lasts for one month, ending on July 25, 2021. You can switch to a paid version anytime during or after the trial. However, you converted to a paid version on June 30, 2021.
- June 25: Initial purchase of 25 licenses of a "Dynamics 365 Guides" subscription at USD 0/month (free trial).
- June 30: Updated to the paid version for the same number of licenses at USD 52.61/month.
- Charge cycle: June 25 to July 24 (30 days total) since June has 30 days.
- Unit price: 0 (indicating it's a free trial).
- Remaining days or prorated billing day after conversion: 25 days (June 30 – July 24).
Billing process:
Initial trial purchase (June 25- July 24):
You're initially charged zero amount for "Dynamics 365 Guides" from June 25 to July 24 because it's a trial version. This entry has some distinctive characteristics, such as the
ProductQualifiers
field includes ["Trial"] to mark this purchase as a trial subscription.Total charge: 25 licenses × USD 0 per license (trial price) = USD 0 total cost
Close out the trial subscription for the unused period (June 30- July 24):
After you convert the subscription to paid version on June 30, a refund is issued for the unused portion of "Dynamics 365 Guides" from June 30 to July 24. This line item is a conversion entry that closes out your trial subscription.
Daily rate: USD 0 (trial price) ÷ 30 days = USD 0 per day Remaining period: 25 days (June 30 to July 24) Unused license count: 25 becuse you converted those licenses to paid version Effective unit price: USD 0 × 25 days = USD 0 per license Total refund: USD 0 × 25 licenses = USD 0
Charge for paid subscription (June 30- July 24):
This line item is the conversion entry that initiates your paid subscription. You're billed for "Office 365 E1" from June 30 to July 24.
Daily rate: USD 52.61 ÷ 30 days = USD 1.753666667 per day Same remaining period: 25 days (June 30 to July 24) Same license count: 25 becuse you upgraded all licenses to paid version Effective unit price: USD 1.753666667 × 25 days = USD 43.84166667 per license Total charge: USD 43.84166667 × 25 licenses = USD 1096.00 (rounded down to two decimal places)
Reconciliation line items for June billing period after the trial to paid conversion:
OrderDate | ChargeType | UnitPrice | ChargeStartDate | ChargeEndDate | EffectiveUnitPrice | BillableQuantity | ProductQualifiers | Total |
---|---|---|---|---|---|---|---|---|
June 25, 2021 | new | 0 | June 25, 2021 | July 24, 2021 | 0 | 25 | ["Trial"] | 0 |
June 30, 2021 | convert | 0 | June 30, 2021 | July 24, 2021 | 0 | 25 | ["Trial"] | 0 |
June 30, 2021 | convert | 52.61 | June 30, 2021 | July 24, 2021 | 52.61 | 25 | 1,096.00 |
By following this reconciliation process, manage and verify the charges associated with converting a trial subscription to a paid one. This systematic approach ensures transparency and accuracy in your billing records.
Reconcile billing line items after changing billing plans
Think of billing plan changes like switching from annual to monthly payments on a three-year car lease, the total commitment remains the same, but the payment structure changes. Let's explore how this change of billing plan works with respect to CSP billing and invoice reconciliation.
You can switch your billing plan after the first charge cycle ends. For instance, if you initially opted for yearly payments, you could change to monthly payments after one year, at the end of the first charge cycle or the first year.
Key concepts of switching billing plans of a subscription
Identify the billing plan switching date: Determine the exact date when the subscription was converted to a paid version. From this date, the prorated refunds and charges are calculated.
Charge cycle: Typically 30 or 31 days, but 28 or 29 for February for monthly billed subscriptions. It starts from your initial purchase date or when renewal or recurring charges begin. For annual subscriptions, the cycle charge is 365 days (366 in leap years). To learn more about how charge cycles are determined, see new commerce charge cycle.
Calculate the monthly rate equivalent: If the monthly rate is USD 21 per license, over 12 months, the cost is USD 252 annually. However the standard annual rate is USD 240, there's a slight discount for committing annually.
Daily rate: Unit price ÷ total days in the charge cycle.
Prorate charge cycle or billing days: Number of days from the change until the end of the charge cycle.
Effective unit price: Daily rate × billing days.
Total: Effective unit price x license count.
Total charges might change due to taxes, exchange rates, and other adjustments.
Important
Switching your billing plan only changes the billing frequency and amount for the charge cycle, not the subscription start date and end date.
Scenario:
Let's say you purchased 10 licenses of a three-year "Dynamics 365 Commerce" subscription on September 20, 2021, with an annual billing plan. You switched to a monthly billing plan on September 20, 2022. The next month, in October 2022, your bill showed a monthly charge. Later on, March 20, 2023, you changed your billing plan back to an annual billing plan.
- September 20, 2021: A user initially purchased 10 licenses of triennial (three-year) "Dynamics 365 Commerce" subscription with an annual plan at USD 240 each, totaling USD 2,400 annually.
- September 20, 2022: Switches to a monthly plan at USD 21 per license, making the monthly payment USD 210.
- March 20, 2023: Switch back to an annual plan at USD 240 per license.
Billing process:
Initial trial purchase (September 20, 2021 - September 19, 2022):
You start with 10 licenses at USD 240 each for a full one year cycle. This calculation is straightforward - you pay the full price because you're using the licenses for the entire period:
USD 240 per license × 10 licenses = USD 2,400 total
Switched from annual billing plan to monthly on September 20, 2022 (September 20, 2022 - October 19, 2022):
When you switch to monthly billing in September 2022, the system creates a conversion record that reflects your new payment structure
Monthly rate per license: USD 21 Total monthly cost: USD 21 x 10 licenses = USD 210
Switched from monthly billing plan to annual on March 20, 2023 (March, 20 2023 - September 19, 2023):
The process works similarly in reverse, but with an interesting pricing adjustment. The system prorates the annual cost.
Daily rate: USD 240 ÷ 365 days = USD 0.657534247 per day Same remaining period: 214 days (March 20, 2023, to September 19, 2023) Same license count: 10 Effective unit price: USD 0.657534247 × 214 days = USD 120.9863014 per license Total charge: USD 120.9863014 × 10 licenses = USD 1,209.80 (rounded down to two decimal places)
Tip
- Check the
ChargeType
: Ensure its value is "convert" to indicate a billing plan change. - Confirm
BillingFrequency
: Check that it reflects the new billing plan (annual or monthly). - Review
EffectiveUnitPrice
: Understand that theEffectiveUnitPrice
may be a prorated value, reflecting adjustments for the remaining period and any applicable discounts.
Reconciliation line items when you switch billing plan:
ChargeType | BillableQuantity | UnitPrice | EffectiveUnitPrice | Total | ChargeStartDate | ChargeEndDate | BillingFrequency |
---|---|---|---|---|---|---|---|
new | 10 | 240 | 240 | 2,400 | September 20, 2021 | September 19, 2022 | Annual |
convert | 10 | 21 | 20 | 210 | September 20, 2022 | October 19, 2022 | Monthly |
By applying these principles and understanding, manage and reconcile billing changes when you change your billing plans.
Validate charges in legacy and new commerce reconciliation data after migrating to new commerce
Migrating from a legacy subscription to a new commerce subscription during an ongoing billing period requires several steps and careful planning to ensure a seamless transition and accurate billing. Here's a detailed breakdown based on the provided example:
Key concepts
Migration policy: When migrating from a legacy subscription to a new commerce subscription, choose one of the options:
- Continue with the remaining billing term of the legacy subscription and pay monthly. For example, keep the "Microsoft Office 365 E3" subscription until July 20, 2022, with a monthly charge of USD 16 for each full month.
- Continue with the remaining billing term of the legacy subscription and pay the remaining balance upfront. For example, keep the "Microsoft Office 365 E3" subscription until July 20, 2022, while making a one-time payment covering roughly seven months.
- Extend the subscription term by starting a new annual billing term from the migration date and pay monthly. For example, start a new annual term for the "Microsoft Office 365 E3" subscription until January 24, 2023, with USD 16 charged each full month.
- Extend the subscription term by starting a new annual billing term from the migration date and pay upfront. For example, start a new annual term for the "Microsoft Office 365 E3" subscription until January 24, 2023, with a one-time payment of USD 192.
Each option allows you to smoothly transition while managing your subscription costs effectively. Consider your payment preferences and subscription needs to select the best option for your company.
Charge cycle: Typically 30 or 31 days, but 28 or 29 for February for monthly billed subscriptions. It starts from your initial purchase date or when renewal or recurring charges begin. For annual subscriptions, the cycle charge is 365 days (366 in leap years). To learn more about how charge cycles are determined, see new commerce charge cycle.
Daily rate: Unit price ÷ total days in the charge cycle
.
Prorate charge cycle or billing days: Number of days from the change until the end of the charge cycle.
Effective unit price: Daily rate × billing days
. Legacy reconciliation doesn't have the concept of the effective unit price. When changes occur mid-cycle, the legacy Unit Price
is replaced with a calculated prorated effective unit price.
Total: Effective unit price x license count
. In legacy, Unit price x license count
.
Total amounts might change due to taxes, exchange rates, and other adjustments.
Example
Scenario:
Let's say you purchased 10 licenses of a "Microsoft Office 365 E3" legacy annual subscription on July 21, 2021, with a monthly billing plan. Each license costs USD 16 per month. On January 25, 2022, you migrated to a new commerce subscription.
Check out the billing process of all scenarios in the new commerce subscription migration with this example.
Legacy invoice reconciliation (before migration)
Period: Up to January 21, 2022
July 21, 2021: Purchase 10 licenses of "Microsoft Office 365 E3" at USD 16/month.
January 25, 2022: Migrated to new commerce.
Unit price: USD 16/month
Legacy charge cycle: January 21 – February 20 (31 days) since January has 31 days.
Prorate charge cycle or billing days: No prorated charges since billed for the full month.
Effective unit price: same as the unit price (USD 16)
Legacy invoice reconciliation (after migration)
Period: After January 21, 2022
January 25, 2022: Migrated to new commerce.
Unit price: USD 16/month
Daily rate: USD 16 ÷ 31 = USD 0.5161290323
Legacy charge cycle: February 21 – March 20 (28 days) since February has 28days.
Prorate charge cycle or billing days: 3 days (January 21 to January 24)
Effective unit price: USD 0.5161290323 per license x 3 days = USD 1.548387097
Billing process
Regular cycle charge (January 21 – February 20):
You continued to pay monthly for 10 licenses at EUR 10.08 each. This calculation is straightforward - you pay the full price because you're using the licenses for the entire period:
Charged amount: USD 16 per license × 10 licenses = USD 160.00
Prorated charges after migrating to new commerce (January 21 – January 24):
Before the migration, the February charge cycle began, resulting in charges for that period. However, after the migration, the system refunded those February charges. Similarly, in January, the system also billed for the full billing cycle. However, the product was available in the legacy platform for only three days. As a result, the system refunded the entire January amount and applied charges solely for those three days of usage.
- First, the charge for your existing 10 licenses for February.
Charged amount: USD 16 per license × 10 licenses = USD 160.00
- Then refund the same amount for those licenses for February.
Refund amount: USD 16 per license × 10 licenses = USD 160.00
- Then refund the amount for those licenses for January.
Refund amount: USD 16 per license × 10 licenses = USD 160.00
- Finally, charge the prorated amount for only three days for using the license from January 21 to 24.
Original daily rate: USD 16 ÷ 31 days = USD 0.5161290323 per day
Used days: 3 days (January 21 to 24)
Effective unit price: EUR 0.5161290323 × 3 = USD 1.548387097 per license
Charged amount: USD 1.548387097 × 10 licenses = USD 15.40 (rounded down to two decimal places)
Legacy license-based invoice reconciliation line items:
ProductName | ChargeType | UnitPrice | SubscriptionStartDate | SubscriptionEndDate | BillingFrequency | ChargeStartDate | ChargeEndDate |
---|---|---|---|---|---|---|---|
Microsoft Office 365 E3 | Prorate fees when purchase | 16 | July 21, 2021 | July 2, 2022 | Monthly | January 2, 2022 | February 20, 2022 |
New commerce invoice reconciliation (after migration)
Migration Date: January 25, 2022
Continue with the same billing term and billing plan
Unit price: USD 16/month
Daily rate: USD 16 ÷ 31 = USD 0.5161290323
Subscription start date: January 25, 2022
Subscription end date: July 20, 2022
Billing frequency: Monthly
Charge start date: January 25, 2022
Charge end date: February 20, 2022
Prorate charge cycle or billing days: 27 days (January 25 – February 20)
Effective unit price: USD 0.5161290323 per license x 27 days = USD 13.93548
Billing process
Prorated cycle charge from the migration date (January 25 – February 20):
You migrated the subscription on January 25, 2022, while keeping the same legacy charge cycle. As a result, the first billing cycle ended on February 20, 2022, lasting only 27 days.
Original daily rate: USD 16 ÷ 31 days = USD 0.5161290323 per day
Remaining days: 27 days (January 25 – February 20)
Effective unit price: USD 0.5161290323 × 27 = USD 13.93548387 per license
Charged amount: USD 13.93548387 × 10 licenses = USD 139.30 (rounded down to two decimal places)
Continue with the same billing term and pay upfront the remaining balance
Unit price: USD 192/year
Daily rate: USD 192 ÷ 365 = USD 0.5260273973
Subscription start date: January 25, 2022
Subscription end date: July 20, 2022
Billing frequency: Upfront
Charge start date: January 25, 2022
Charge end date: July 20, 2022
Prorate charge cycle or billing days: 177 days (January 25 – July 20)
Effective unit price: USD 0.5260273973 per license x 177 days = USD 93.10684932
Billing process
Prorated cycle charge from the migration date (January 25 – July 20):
You migrated the subscription on January 25, 2022, but opted to pay the remaining balance upfront. As a result, the charge cycle ended on July 20, 2022, lasting for 177 days.
Original daily rate: USD 192 ÷ 31 days = USD 0.5260273973 per day
Remaining days: 177 days (January 25 – July 20)
Effective unit price: USD 0.5260273973 × 177 = USD 93.10684932 per license
Charged amount: USD 93.10684932 × 10 licenses = USD 931.00 (rounded down to two decimal places)
Start with a new annual billing term and pay monthly
Unit price: USD 16/month
Daily rate: USD 16 ÷ 31 = USD 0.5161290323
Subscription start date: January 25, 2022
Subscription end date: January 24, 2023
Billing frequency: monthly
Charge start date: January 25, 2022
Charge end date: February 24, 2022
Prorate charge cycle or billing days: full one month
Effective unit price: USD 16
Billing process
Initial cycle charge from the migration date (January 25 – February 24):
You migrated the subscription on January 25, 2022, to start a new annual billing term with a monthly billing plan. As a result, you're billed for one full month in your first charge cycle, and this charge continues until the subscription ends or renews—unless you make adjustments mid-term.
Charged amount: USD 16 per license × 10 licenses = USD 160.00
Start with a new annual billing term and pay upfront
Unit price: USD 192/month
Daily rate: USD 192 ÷ 365 = USD 0.5260273973
Subscription start date: January 25, 2022
Subscription end date: January 24, 2023
Billing frequency: Upfront
Charge start date: January 25, 2022
Charge end date: January 24, 2023
Prorate charge cycle or billing days: Full one year
Effective unit price: USD 192
Billing process
Initial cycle charge from the migration date (January 25 – February 24):
You migrated the subscription on January 25, 2022, to start a new annual billing term with an upfront payment. As a result, you're billed for one full year in your first charge cycle.
Charged amount: USD 192 per license × 10 licenses = USD 1,920.00
New commerce invoice reconciliation line items of January 2022 billing period:
- Same billing term and plan
- Same billing term and upfront payment
- New annual term and monthly plan
- New annual term and upfront payment
For the January billing period, charges are divided between legacy and new commerce invoices on a prorated basis.
ProductName | ChargeType | UnitPrice | EffectiveUnitPrice | BillableQuantity | Total | SubscriptionStartDate | SubscriptionEndDate | BillingFrequency | ChargeStartDate | ChargeEndDate |
---|---|---|---|---|---|---|---|---|---|---|
Microsoft Office 365 E3 | new | 16 | 13.93548 | 10 | 139.30 | January 25, 2022 | July 20, 2022 | Monthly | January 25, 2022 | February 20, 2022 |
Total charge verification
Check legacy invoice: Ensure it covers up to January 24, 2022, with accurate prorated charges and refunds.
Review new commerce invoice: Confirm it starts from January 25, 2022, with correct proration based on the billing term and plan.
Verify seamless transition: Make sure there's no double billing or gaps between the invoices.
Annual vs. monthly billing
Monthly new commerce price: Confirm the price is USD 16 per month, with appropriate proration.
Annual new commerce price: Verify the price is USD 192 annually, prorated accurately for the initial period.
Final validation
Ensure legacy charges: They should be correctly prorated, and any unused periods refunded.
Check new charges: Should reflect the correct start date and billing frequency.
Match total billed amount: Confirm it aligns with the expected fees without discrepancies.
Following these steps help you accurately reflect the migration from legacy to new commerce in the invoices, ensuring correct proration and eliminating billing errors.
Verify the license-based subscription transfer between partners (P2P transfer) in reconciliation files or line items
Think of a P2P transfer like moving your cell phone service from one carrier to another while keeping your same plan and phone number. Just as you need to verify both the cancellation with your old carrier and activation with the new one, you also need to check both the source and target partner's reconciliation files or line items.
To verify the license-based subscription transfer between partners (P2P transfer) in reconciliation files or line items, follow these detailed steps. This process ensures transparency and accuracy when subscriptions are migrated or transferred from one partner to another. For more information about the transfer, see transfer new commerce license-based subscriptions from one transacting CSP partner to another.
Verification checklist based on this scenario
Scenario:
Initially, the source partner (Partner A) had an annual subscription (SubscriptionId: 8691daa7-4760-4b4a-c193-8c1755b44ab5
) starting on May 10, 2024, with a monthly payment of USD 45.60 for three licenses. The regular billing cycle ran from the 10th of each month to the 9th of the next month.
On November 1, 2024, they transferred the subscription to the target partner (Partner B). The reconciliation files or line items reflect several key changes post-transfer:
Understand the transfer process
A subscription transfer involves two main steps:
- Cancellation of the subscription with the source partner.
- Repurchase of the subscription with the target partner.
SubscriptionId
changes after the transfer, but key properties like autorenewal settings remain consistent.
Verify the reconciliation for the source partner (Partner A)
Check subscription cancellation:
- Look for the
ChargeType
attribute listed as "cancelImmediate" for the transferred subscription. - Verify the
OrderDate
matches the effective cancellation date or the transfer date.
- Look for the
Verify subscription dates:
- Ensure that
SubscriptionStartDate
andSubscriptionEndDate
remain unchanged, reflecting the original billing term.
- Ensure that
Review prorated refund:
- Check the
ChargeStartDate
andChargeEndDate
for the canceled subscription. These dates should reflect the period from the transfer date to the end of the charge cycle. If the subscription is transferred on November 1, 2024, the prorated refund should reflect the period from November 1, 2024, to November 9, 2024 (the end of the charge cycle). - Verify the
EffectiveUnitPrice
is prorated based on the number of days remaining in the charge cycle. For more information, see how prorated charges or refunds are calculated.
- Check the
Final charge period:
- Ensure that the final charge period only covers the partial month (for example, October 10-31, 2024).
Verify the reconciliation for the target partner (Partner B)
Check new subscription creation:
- Confirm that a new subscription ID is generated for the transferred subscription
SubscriptionId: 5d3a7501-3b4a-4012-db07-ebc4192985b7
. - Look for a new entry with
ChargeType
as "new" in the reconciliation line item. - Verify the
OrderDate
matches the transfer date.
- Confirm that a new subscription ID is generated for the transferred subscription
Verify subscription dates:
- Ensure the
SubscriptionStartDate
aligns with the transfer date, and theSubscriptionEndDate
matches the end of the original billing term (for example, May 09, 2025).
- Ensure the
Review prorated charges:
- Check the
ChargeStartDate
andChargeEndDate
for the first billing period. These dates should reflect the prorated period from the transfer date to the end of the first charge cycle (for example, November 1-9, 2024). - Verify the
EffectiveUnitPrice
, which should be prorated based on the number of days in the first billing cycle. For more information, see how prorated charges or refunds are calculated.
- Check the
Regular monthly billing:
- Confirm that regular monthly billing of USD 45.60 per license begins from the correct date (for example, November 10, 2024).
General verification
- Subscription properties:
- Confirm that key settings like autorenewal are preserved and carried over to the target partner (Partner B).
- Charge cycle continuity:
- Ensure that the charge cycle remains unchanged (for example, monthly).
- License quantity:
- Verify that the number of licenses (for example, 3) remains the same with the target partner (Partner B).
- Duplicate or overlapping charges:
- Ensure no gaps or overlaps in billing between the source and target partners. Billing for the target partner should start from the transfer date, with refunds for the source partner also starting from the transfer date.
Key points to remember
- Subscription ID changes: The subscription ID changes when transferred from the source to the target partner.
- Prorated charges: Prorated charges are based on the number of days in the partial charge cycle. For example, if the transfer occurs on the 10th, the prorated charge would be calculated for the remaining days in the charge cycle.
- Accurate billing cutover: Billing starts on the transfer date for the target partner, and refunds for the source partner also begin then, preventing overlapping or duplicate charges.
- Consistent Subscription Dates: The overall subscription term remains consistent, with the
SubscriptionStartDate
andSubscriptionEndDate
reflecting the original billing term. - Charge types: Look for "cancelImmediate" for the source partner and "new" for the target partner to identify the transfer.
- Customer notification: Ensure that the customer is notified of the partner change and that there's no disruption to their service.
Billing process for the source partner (Partner A):
Initial purchase (May 10 - June 9):
You start with three licenses at USD 45.6 each for a full month charge cycle. This calculation is straightforward - you pay the full price because you're using the licenses for the entire period:
Total charge: 3 licenses × USD 45.6 per license = USD 136.8 total (rounded down to two decimal places)
Regular cycle charge for October (October 10 - November 9):
Your regular cycle charges continued until the October billing period.
Total charge: 3 licenses × USD 45.6 per license = USD 136.8 total (rounded down to two decimal places)
Transfer the subscription (November 1 - November 9):
Refund the current three licenses, as the transfer initiates subscription cancellation, which in turn triggers a refund.
Daily rate based on October charge cycle: 45.6 ÷ 31 days = USD 1.4709677419 per day Remaining period: 9 days (November 1 to November 9) License count: 3 (Transferred subscription has three licenses) Effective unit price: USD 1.4709677419 × 9 days = USD 13.23870968 per license Total charge: USD 13.23870968 × 3 licenses = USD 39.69 (rounded down to two decimal places)
Billing process for the target partner (Partner B):
Charges after transfer (November 1 - November 9):
After the target partners accepted the subscription transfer, the target partner is billed only for the remaining 9 days (November 1 – 9) in the October charge cycle to avoid any billing overlap or gap.
Same Daily rate: 45.6 ÷ 31 days = USD 1.4709677419 per day Remaining period: 9 days (November 1 to November 9) Same license count: 3 (Transferred subscription has three licenses) Effective unit price: USD 1.4709677419 × 9 days = USD 13.23870968 per license Total charge: USD 13.23870968 × 3 licenses = USD 39.69 (rounded down to two decimal places)
Regular cycle charge from November (November 10 - December 9):
Your regular cycle charges continued until the October billing period.
Total charge: 3 licenses × USD 45.6 per license = USD 136.8 total (rounded down to two decimal places)
Reconciliation line items after P2P transfer:
Billing period | PartnerId | CustomerName | OrderDate | ProductName | ChargeType | UnitPrice | BillableQuantity | Subtotal | TaxTotal | Total | Currency | SubscriptionId | ChargeStartDate | ChargeEndDate | EffectiveUnitPrice | SubscriptionStartDate | SubscriptionEndDate |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
First billing period | 11111111-aaaa-11aa-aa11-111111111111 | Contoso | May 10, 2024 | Microsoft 365 E3 | new | 45.6 | 3 | 136.8 | 0 | 136.8 | USD | 8691daa7-4760-4b4a-c193-8c1755b44ab5 | May 10, 2024 | Jun 09, 2024 | 45.6 | May 10, 2024 | May 09, 2025 |
Billing period before the transfer | 11111111-aaaa-11aa-aa11-111111111111 | Contoso | Oct 10, 2024 | Microsoft 365 E3 | cycleCharge | 45.6 | 3 | 136.8 | 0 | 136.8 | USD | 8691daa7-4760-4b4a-c193-8c1755b44ab5 | Oct 10, 2024 | Nov 09, 2024 | 45.6 | May 10, 2024 | May 09, 2025 |
Billing period after the transfer | 11111111-aaaa-11aa-aa11-111111111111 | Contoso | Nov 01, 2024 | Microsoft 365 E3 | cancelImmediate | 45.6 | 3 | –39.69 | 0 | –39.69 | USD | 8691daa7-4760-4b4a-c193-8c1755b44ab5 | Nov 01, 2024 | Nov 09, 2024 | –13.23870968 | May 10, 2024 | May 09, 2025 |
By reviewing and verifying these key elements, ensure that the P2P transfer process is accurately reflected and accounted for in your reconciliation files or line items.