As a billing analyst, you can split the billing amount to adjust the payments. The split of the billing amount happens at the BSR level where you can split a BSR into two or multiple BSRs. The split of the BSR always happens by date, but the billing amount may be split based on the customer's request to split by specific amounts, by specific percentages, or by term. After the split, the fee amount is recomputed per the given amounts, percentages, or terms.

This feature is helpful for splitting a billing schedule due to a change in the billing policy, customer request, change in the tax regime, or due to a direction from regulatory authorities. For example, there is a tax increment from Jan 1, 2024, and your customer wants to split all pending billing schedules from 2023 to 2024 on  Dec 31, 2023.

For more about Billing on the Conga Platform, see  Understanding the Billing Architecture on Conga Platform.


Prerequisites

  • The order line item is active.

  • The billing summary is set to Contracted. For more information see, Setting Billing Header to Contracted.
  • The billing summary is active.
  • The Price Type is set to Recurring. 
  • If the billing frequency is one-time, proration is set to True.

When you initiate the process, Billing splits a BSR into a number of BSRs and marks the original as Superseded. The new BSRs have a Pending Billing status and the sum of their actual fee amounts is equal to the actual fee amount of the original BSR.

The original BSR's BSD is also marked as superseded and its actual fee amount is split as per the split method mentioned in the API. The new BSDs' default status is set to Approved and their Category is marked as Fee.

You can split multiple BSRs from the same billing header or a different billing header.

To split the billing schedule record

  1. Bill a One-Time or Recurring product. Call the Split Billing Schedule API to perform the split operation. 

    Contact your administrator to make this functionality available in your application so that clicking a button calls the billing service API.


  2. Enter the BSR ID for which you want to perform the split operation.
  3. Enter the number of splits you want.

    The engine creates + 1 split line items for the number of splits you enter.


  4. Enter values based on the split method you have chosen.

    1. For the split-by-amount method, enter the split date and split amount for all split line items. The total of the split amount must be less than or equal to the fee amount of the billing schedule you want to split. For example, to split a billing schedule with USD 1000 as a fee amount into four billing schedules, enter 3 as the number of splits. The engine will create n + 1 (3 + 1 = 4) billing schedules. You can split USD 1000 in two different ways:

      1. Less than the total fee amount, that is, USD 1000 = USD 250 (Split 1) + USD 200 (Split 2) + USD 300 (Split 3) = USD 750 then the 4th (n + 1) billing schedule will have USD 250 as the fee amount.
      2. Equal to the total fee amount, that is, USD 1000 = USD 300 (Split 1) + USD 200 (Split 2) + USD 500 (Split 3) = USD 1000 then the 4th (n + 1) billing schedule will have USD 0.00 as the fee amount.
    2. For the split-by-percentage method, enter the split date and split percentage for the split line items. The split percentage total must be less than or equal to 100.

    3. For the split-by-term method, enter the number of splits and the split date. 

      The application automatically calculates the Term based on the split date, the number of splits, and the proration calculation method set at the billing preference level. 

Example

If a recurring order line item has the following input parameters. Billing creates one billing header, 12 billing schedule records, and 12 billing schedule details.

Order No

Order Line No

Product

Price Type

Billing Frequency

Start Date

End Date

Quantity

Per Unit price

Net Price 

Selling Term

O-1OLI-1ServicesRecurringMonthly

01-Jan-2024 

31-Dec-2024

1USD 1200.00USD 1200.001.000

Split by Amount

To split BSR-2  by amount, which has a USD 100 fee, into three parts, you provide the value of n = 2. The start date is Feb 1, 2024, and the end date is Feb 29, 2024. You provided two split values as follows:

BSR IDSplit AmountSplit Date
BSR-2USD 30.00

08-Feb-2024

USD 40.00

16-Feb-2024

After initiating the split process, the engine generates three BSRs (2+1 = 3). As intended, the first two BSRs have a fee amount equal to (USD 30.00 + USD 40.00 = USD 70.00), and the third BSR is auto-created with a fee of USD 30.00 for the delta amount. The original BSR and its BSD are marked as superseded and the newly created BSRs and BSDs have a Pending Billing status.  

Billing Schedule Record No

Billing Header ID

BSD ID

Period Start Date

Period End Date

Actual Fee Amount

Status

BSR-2BH-1BSD-2

01-Feb-2024 

29-Feb-2024 

USD 100.00Superseded
BSR-2.aBH-1BSD-2.a

01-Feb-2024  

08-Feb-2024  

USD 30.00Pending Billing
BSR-2.bBH-1BSD-2.b

09-Feb-2024 

16-Feb-2024 

USD 40.00Pending Billing
BSR-2.cBH-1BSD-2.c

17-Feb-2024 

29-Feb-2024 

USD 30.00Pending Billing

Split by Percentage

To split BSR-2 by percentage, which has a fee of USD 100 into three parts, you provide the value of n = 2. The start date is 01 Feb 2024 and the end date is 29 Feb 2024. You provided two split values as follows:

BSR IDSplit PercentageSplit Date
BSR-230

08-Feb-2024

40

16-Feb-2024

After initiating the split process, the engine generates three BSRs (2+1 = 3). As intended, the first two BSRs have a fee amount equal to the percentages mentioned, and the third BSR is auto-created for the delta amount. The original BSR and its BSD are marked as superseded and the newly created BSRs and BSDs have a status of pending billing. 

Billing Schedule Record No

Billing Header ID

BSD ID

Period Start Date

Period End Date

Actual Fee Amount

Status

BSR-2BH-1BSD-2

01-Feb-2024 

29-Feb-2024 

USD 100.00Superseded
BSR-2.aBH-1BSD-2.a

01-Feb-2024  

08-Feb-2024  

USD 30.00Pending Billing
BSR-2.bBH-1BSD-2.b

09-Feb-2024 

16-Feb-2024 

USD 40.00Pending Billing
BSR-2.cBH-1BSD-2.c

17-Feb-2024 

29-Feb-2024 

USD 30.00Pending Billing

Split by Term

You want to split BSR-2 by Term, which has a fee of USD 100.00 into three parts, you provide the value of n = 2. The Term for the entire month is considered as 1. The start date is 01 Feb 2024, and the end date is 29 Feb 2024. You provided two split values for the term and split date as follows:


SettingsBSR IDSplit Date

Proration Calculation Method = Calendar Days of First Month

Fee Amount Rounding Schedule = Last


 

BSR-2

09-Feb-2024

24-Feb-2024

Auto-computed by the application

The application automatically calculates the Term.  It is used to calculate the BSD fee amount. To understand how the application calculates the Term and the BSD fee amount, refer to the following table:

Split TermSplit DateBSD Fee Amount
Split term is automatically calculated by dividing the 
number of days of the split by the calendar days.

The split date is entered by you

The BSD fee amount is calculated using the formula:
Term * Fee amount of the original BSR (BSR to be split)

9/29 = 0.3103448275

09-Feb-2024

0.3103448275 * USD 100.00  = USD 31.03

14/29 = 0.4827586206

24-Feb-2024

0.4827586206 * USD 100.00 = USD 48.27

Auto-computed term for the third split
Term = 1 − [0.3103448275+0.4827586206]

         =  0.2068965519

Auto-computed by the application

0.2068965519 * USD 100.00 = USD 20.70

After initiating the split process, the application generates three BSRs (2+1 = 3). The original BSR is marked as superseded and the newly created BSRs have a status of pending billing. 

Billing Schedule Record No

Billing Header ID

BSD ID

Period Start Date

Period End Date

Actual Fee Amount

Status

BSR-2BH-1

BSD-2

01-Feb-2024 

29-Feb-2024 

USD 100.00Superseded
BSR-2.aBH-1

BSD-2.a

01-Feb-2024 

09-Feb-2024 

USD 31.03Pending Billing
BSR-2.bBH-1

BSD-2.b

10-Feb-2024 

24-Feb-2024 

USD 48.27Pending Billing
BSR-2.cBH-1

BSD-2.c

25-Feb-2024 

29-Feb-2024 

USD 20.70

Pending Billing