Billing implements a logic that defers the rounding-off of the balances arising from renewals, cancellations, change operations, proration, odd selling terms, partial periods, or amendments in the middle of the period to either the first or last billing period. The implementation of the logic is governed by setting the Fee Amount Rounding Schedule to First or Last.

Use Case: Rounding the Decimal Values for Renewal Operation

When an existing product or service is renewed, the application shifts the rounded decimal values to the first or last billing period.

Upon renewal, the TCV (Sales)  is updated with the sum of the previous TCV (Sales) and the renewed amount. The amount in the Billable Amount from the Current Order Line Item field on the billing header is updated to the sum of the renewed billing schedule records (BSRs) fees. In other words, the sum of fees of all the BSRs (before and after renewal) equals the TCV (Sales) of the subscription.

For example, a new sale is initiated for a product or service with a TCV (Sales) of USD 1,000.00. The billing frequency is quarterly. The contract is for nine months, starting from 01-July-2024 and ending on 31-March-2025. Initiating the billing creates a billing header and three BSRs. The Fee Amount Rounding Schedule is set to Last in the Billing Settings.

New Sale

For a new sale, the billing header has the following data:

BH ID

Current OLI

Parent OLI

ALI

Billing Start Date

Billing End Date

TCV (Sales)

Billable Amount for Current OLI

Total Invoiced Amount

Pending Invoice Amount

Status

BH-1OLI-1OLI-1ALI-101-July-202431-March-2025USD 1,000.00USD 1,000.00USD 0.00USD 1,000.00Active

The BSRs have the following data. Since the Fee Amount Rounding Schedule is set to Last, the application shifts the rounded decimal values to the last period (here BSR-3).

BSR ID

BSD ID

Record Type

Category

Period Start Date

Period End Date

Actual Fee Amount

Invoice Status

BSR-1BSD-1RegularFee01-July-202430-September-2024USD 333.33Pending Billing
BSR-2BSD-2RegularFee01-October-202431-December-2024USD 333.33Pending Billing
BSR-3BSD-3RegularFee01-January-202531-March-2025USD 333.34Pending Billing

After Renewal

You wanted to renew the service for its entire term with the same TCV (Sales). While renewing, you changed the setting, Fee Amount Rounding Schedule to First in the Billing Settings, so the application shifts the rounded decimal values to the first period (here BSR-4). Initiating the billing creates a billing header and three more BSRs with the same fee amount because the TCV (Sales) remains unchanged.

The billing start date and end dates are 01-April-2024 and 31-December-2025 respectively. The TCV (Sales) field is updated with the sum of the previous TCV (Sales) and the renewed amount. The Billable Amount for Current OLI field is updated with the current renewed amount. The billing header has the following data:

BH ID

Current OLI

Parent OLI

ALI

Billing Start Date

Billing End Date

TCV (Sales)

Billable Amount for Current OLI

Total Invoiced Amount

Pending Invoice Amount

Status

BH-1OLI-12OLI-1ALI-101-April-202431-December-2025USD 2,000.00USD 1,000.00USD 0.00USD 2,000.00Active

The BSRs have the following data. Since the Fee Amount Rounding Schedule is set to first, the application shifts the rounded decimal values to the first period after renewal (here BSR-4).

BSR ID

BSD ID

Record Type

Category

Period Start Date

Period End Date

Actual Fee Amount

Invoice Status

Remarks

BSR-1BSD-1RegularFee01-July-202430-September-2024USD 333.33Pending Billing
BSR-2BSD-2RegularFee01-October-202431-December-2024USD 333.33Pending Billing
BSR-3BSD-3RegularFee01-January-202531-March-2025USD 333.34Pending Billing
BSR-4BSD-4RegularFee01-April-202531-June-2025USD 333.34Pending BillingRenewed BSR with rounded decimal amount
BSR-5BSD-5RegularFee01-July-202530-September-2025USD 333.33Pending BillingRenewed BSR
BSR-6BSD-6RegularFee01-October-202531-December-2025USD 333.33Pending BillingRenewed BSR

Use Case: Rounding the Decimal Values for Cancellation

Cancellation of a product or service may be a full-term or mid-term cancellation. In both types of cancellations, there may be schedules in Pending Billing or Invoiced statuses. When cancellation is initiated, the schedules in Pending Billing status are canceled and the ones in Invoiced status are refunded after cancellation. So the rounding of decimal values is not applicable for the cancellation operation. For more details on cancellation operation, refer to Full-Term Cancellation of Products and Mid-Term Cancellation of Products.

Consider the example given in the previous use case (Use Case: Rounding the Decimal Values for Renewal Operation). You want to initiate a full-term cancellation for this product or service effective from 01-July-2024. Based on the setting Superseding the Schedules during Asset Management is set to Always Supersede or Minimize, the cancellation BSRs and BSDs are shown below.

Setting "Superseding the Schedules during Asset Management" to Minimize

The BSRs are:

BSR ID

BSD ID

Record Type

Category

Period Start Date

Period End Date

Actual Fee Amount

Invoice Status

Remarks

BSR-1BSD-1RegularFee01-July-202430-September-2024USD 0.00CanceledThe fee amount is USD 0.00 because of the sum of the roll-up amount of actual and counter BSDs.
BSR-2BSD-2RegularFee01-October-202431-December-2024USD 0.00Canceled
BSR-3BSD-3RegularFee01-January-202531-March-2025USD 0.00Canceled

The BSDs are:

BSD ID

BSR ID

Record Type

Category

Period Start Date

Period End Date

Actual Fee Amount

Derived Invoice Status

Remarks

BSD-1BSR-1RegularFee01-July-202430-September-2024USD 300.00Canceled
BSD-1.aRegularFee01-July-202430-September-2024(USD 300.00)CanceledCounter-BSD for canceled BSD-1 can be used as a source to offset the revenue forecast from the previous BSD-1.
BSD-2BSR-2RegularFee01-October-202431-December-2024USD 300.00Canceled
BSD-2.aRegularFee01-October-202431-December-2024(USD 300.00)CanceledCounter-BSD for canceled BSD-2 can be used as a source to offset the revenue forecast from the previous BSD-2.
BSD-3BSR-3RegularFee01-January-202531-March-2025USD 300.00Canceled
BSD-3.aRegularFee01-January-202531-March-2025(USD 300.00)CanceledCounter-BSD for canceled BSD-3 can be used as a source to offset the revenue forecast from the previous BSD-3.

Setting "Superseding the Schedules during Asset Management" to Always Supersede

The BSRs are:

BSR ID

BSD ID

Record Type

Category

Period Start Date

Period End Date

Actual Fee Amount

Invoice Status

BSR-1BSD-1RegularFee01-July-202430-September-2024USD 333.33Canceled
BSR-2BSD-2RegularFee01-October-202431-December-2024USD 333.33Canceled
BSR-3BSD-3RegularFee01-January-202531-March-2025USD 333.34Canceled

Because all the schedules are canceled, so rounding the decimals is not applicable for any type of cancellation.

Use Case: Rounding the Decimal Values for Change Operation

Price changes may occur due to a discount or markup on the fee amount. When there is a rounding-off of the balances due to price change, the application shifts the rounded decimal values to the first or last billing period.

For example, a new sale is initiated for a product or service with a TCV (Sales) of USD 1,200.00. The billing frequency is quarterly. The contract is for nine months, starting from 01-July-2024 and ending on 31-March-2025. Initiating the billing creates a billing header (not shown here for simplicity) and three BSRs. The first BSR is invoiced.

BSR ID

BSD ID

Record Type

Category

Period Start Date

Period End Date

Actual Fee Amount

Invoice Status

BSR-1BSD-1RegularFee01-July-202430-September-2024USD 333.33Invoiced
BSR-2BSD-2RegularFee01-October-202431-December-2024USD 333.33Pending Billing
BSR-3BSD-3RegularFee01-January-202531-March-2025USD 333.34Pending Billing

You provided a discount of USD 25.00 (as an absolute value) for the entire term. When this amount is updated on Billable Amount from the Current Order Line field on the billing header, it is distributed based on the setting Superseding the Schedules during Asset Management is set to Always Supersede or Minimize, to the new BSRs and BSDs as shown below.

Setting "Superseding the Schedules during Asset Management" to Always Supersede

The BSRs are:

BSR ID


Period Start Date


Period End Date


Invoice Status


Actual Fee Amount


Remarks


Rounding to Last

Rounding to First

BSR-101-July-202430-September-2024InvoicedUSD 400.00
The change operation does not impact the invoiced BSR, BSR-1. The discounted amount is refunded by creating a new BSR, BSR-4.
BSR-201-October-202431-December-2024SupersededUSD 400.00

BSR-301-January-202531-March-2025SupersededUSD 400.00

BSR-401-July-202430-September-2024Pending Billing(USD 8.33)(USD 8.34)Refund BSR for BSR-1.
BSR-501-October-202431-December-2024Pending BillingUSD 391.67USD 391.67
BSR-601-January-202531-March-2025Pending BillingUSD 391.66USD 391.67

The schedules for Setting "Superseding the Schedules during Asset Management" to Minimize are not shown here. The end result remains the same as above.