Decimal Round-off
This feature rounds the decimal balances arising from proration in the first or last billing schedule record subject to custom setting, Fee Amount Rounding Schedule set to either First or Last.
When billing is initiated for a recurring or one-time product, a billing header, schedule records, and schedule details, depending on the term and billing frequency are created. The billing schedule records are created with "Pending Billing" status. Because the Fee Amount Rounding Schedule setting is defined, billing rounds the decimal values in the first or last billing record.
- The decimal rounding functionality works for new sales, renewals, amendments, and change operations performed on one-time and recurring subscriptions.
- To know how Billing works on the Conga Platform, it is recommended to familiarize yourself with its architecture mentioned in Understanding the Billing Architecture on Conga Platform.
Suppose you are selling computer servicing with a Total Contract Value of $1000. The billing term is for 3 months starting from 01 Jan 2024 with a recurring billing schedule. Billing creates three billing schedules. The round-offs are adjusted in the first or last billing schedule depending on whether the Fee Amount Rounding Schedule is set to First or Last.
Scenario 1:
Suppose you have set the Fee Amount Rounding Schedule to First, and configured a recurring order line item with the following details:
|
Order No |
Order Line No |
Product |
Price Type |
Billing Frequency |
Start Date |
End Date |
Quantity |
Per Unit price |
Net Price |
Selling Term |
|---|---|---|---|---|---|---|---|---|---|---|
|
O-001 |
1 |
Service |
Recurring |
Monthly |
01 Jan 2024 |
31 Mar 2024 |
1 |
USD 1000 |
USD 1000.00 |
1.000 |
Contact your admin will make this functionality available in your application so that upon clicking a button you should be able to call the billing service API and get the result as shown. The API creates one Billing Header, three Billing Schedule Records, and three Billing Schedule Details.
The billing header uses the information from the order line item and contains the following data. Depending upon the information given for the pricing source, It will pick up the pricing information from the order line item or the asset line item. The Billing Header shows:
|
Billing Header ID |
Order No |
Order Line No |
Product |
Price Type |
Billing Frequency |
Billing Rule |
Start Date |
End Date |
Quantity |
Net Unit Price |
Selling Term |
Bill To |
Pricing Source |
Billing Preference |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
BH-001 |
O-001 |
1 |
Service |
Recurring |
Monthly |
Bill In Advance |
01 Jan 2024 |
31 Mar 2024 |
1 |
USD 1000.00 |
1.000 |
ABC Corporation |
OLI |
Billing Preference |
Three Billing Schedule Records are generated showing the following output:
|
Billing Schedule Record No |
Billing Header ID |
Period Start Date |
Period End Date |
Actual Fee Amount |
Ready for Invoice Date |
Status |
|---|---|---|---|---|---|---|
|
BSR-001 |
BH-001 |
01 Jan 2024 |
31 Jan 2024 |
USD 333.34 |
01 Jan 2024 |
Pending Billing |
|
BSR-002 |
BH-001 |
01 Feb 2024 |
29 Feb 2024 |
USD 333.33 |
01 Feb 2024 |
Pending Billing |
|
BSR-003 |
BH-001 |
01 Mar 2024 |
31 Mar 2024 |
USD 333.33 |
01 Mar 2024 |
Pending Billing |
The Actual Fee Amount shown in the billing schedule record is the amount that is billed to the customer.
Billing Schedule Details show the following information:
|
Billing Schedule Detail No |
Billing Schedule Record No |
Record Type |
Period Start Date |
Period End Date |
Category |
Actual Fee Amount |
|---|---|---|---|---|---|---|
|
BSD-001 |
BSR-001 |
Regular |
01 Jan 2024 |
31 Jan 2024 |
Fee |
USD 333.34 |
|
BSD-002 |
BSR-002 |
Regular |
01 Feb 2024 |
29 Feb 2024 |
Fee |
USD 333.33 |
|
BSD-003 |
BSR-003 |
Regular |
01 Mar 2024 |
31 Mar 2024 |
Fee |
USD 333.33 |
Since the Fee Amount Rounding Schedule is set to First, decimal rounding is done in the first record.
Scenario 2:
Suppose you have set the Fee Amount Rounding Schedule to Last, and configured a recurring order line item with the same details as above.
Three Billing Schedule Records are generated showing the following output:
|
Billing Schedule Record No |
Billing Header ID |
Period Start Date |
Period End Date |
Actual Fee Amount |
Ready for Invoice Date |
Status |
|---|---|---|---|---|---|---|
|
BSR-001 |
BH-001 |
01 Jan 2024 |
31 Jan 2024 |
USD 333.33 |
01 Jan 2024 |
Pending Billing |
|
BSR-002 |
BH-001 |
01 Feb 2024 |
29 Feb 2024 |
USD 333.33 |
01 Feb 2024 |
Pending Billing |
|
BSR-003 |
BH-001 |
01 Mar 2024 |
31 Mar 2024 |
USD 333.34 |
01 Mar 2024 |
Pending Billing |
The Actual Fee Amount shown in the billing schedule record is the amount that is billed to the customer.
Billing Schedule Details show the following information:
|
Billing Schedule Detail No |
Billing Schedule Record No |
Record Type |
Period Start Date |
Period End Date |
Category |
Actual Fee Amount |
|---|---|---|---|---|---|---|
|
BSD-001 |
BSR-001 |
Regular |
01 Jan 2024 |
31 Jan 2024 |
Fee |
USD 333.33 |
|
BSD-002 |
BSR-002 |
Regular |
01 Feb 2024 |
29 Feb 2024 |
Fee |
USD 333.33 |
|
BSD-003 |
BSR-003 |
Regular |
01 Mar 2024 |
31 Mar 2024 |
Fee |
USD 333.34 |
Since the Fee Amount Rounding Schedule is set to Last, the last record has rounded decimal values.
