Full Term Cancellation
Full-term cancellation of legacy assets is a scenario where you cancel the asset on the Original Start Date. Billing uses the AND logical operator to validate two scenarios “if it is a cancellation & if the end date is equal to the original start date”. It proceeds with cancellation only if the validation is true, else Billing displays an error message on the asset line record page.
Prerequisites
- The object and fields required to support legacy billing for legacy asset line items are configured. For more information, see Understanding Billing Schedules and Use Case 3Billing Schedules
- The Is Legacy for Billing checkbox is set to True.
- For the Cancellation, either the “Terminate” button or its API is used.
- The Same Day Cancellation custom setting is set to True and the End Date is equal to the Original Start Date.
- Alternatively, if the Same Day Cancellation custom setting is not True then the End Date must be equal to “Original Start Date − 1”.
- The Original Start Date, Start Date, End Date, Remaining Billable Amount, TCV, Selling Term, and CPQ Pricing fields (Base Unit Price and Net Price) are captured accurately on the asset line record.
- The scenario is a full cancellation only if:
- When either End Date equal to “Original Start Date” or End Date equal to “Original Start Date-1” is populated, it’s understood as a Full Cancellation.
- When none of the above dates is populated, it’s understood as a Partial Cancellation.
- Once validated, the billing metrics API returns the refund amount on the CPQ cart.
- The cancellation Date is not a concern for Conga Billing for this functionality.
- Asset line record is marked as cancelled at the end of CPQ operation.
Cancelling the Legacy Assets
For full-term cancellation of legacy assets do the following steps:
Hence, once initiated for the full-term cancellation of the legacy assets, Conga Billing:
- Validates the full cancellation scenario and proceed with cancellation if the validation is passed, else throws an error on the asset line record page.
- Marks all the Pending billing schedules as Cancelled.
- Updates the Remaining Billable Amount to $0.00 on the asset line item since there is nothing to be billed in future.
- Adds the amount of all the Invoiced billing schedules and creates billing schedules with a negative amount to refund it to the customer.
Example 1: Cancelling Recurring asset
Suppose you are a billing administrator of a company selling computer hardware with a TCV of $5400 for 36 billing terms. You have already invoiced the customer for $2400 over a billing period of 16 months and the remaining billable amount is $3000 to be billed over a 20-month duration. The legacy contract was started in 2018 but the last known major price or config happened on 7/20/21. The asset's start date is 7/20/21. The first Billing Date is 11/20/2022.
Conga Billing produces the billing schedules as mentioned:
|
Billing Schedule ID |
Period Start Date |
Period End Date |
Fee Amount |
Type |
Status |
Legacy record? |
|---|---|---|---|---|---|---|
|
BS-001 |
7/20/2021 |
11/19/2022 |
$2,400.00 |
Informational |
Invoiced |
TRUE |
|
BS-002 |
11/20/2022 |
12/19/2022 |
$150.00 |
Contracted |
Pending Billing |
|
|
BS-003 |
12/20/2022 |
1/19/2023 |
$150.00 |
Contracted |
Pending Billing |
|
|
BS-004 |
1/20/2023 |
2/19/2023 |
$150.00 |
Contracted |
Pending Billing |
|
|
BS-005 |
2/20/2023 |
3/19/2023 |
$150.00 |
Contracted |
Pending Billing |
|
|
BS-006 |
3/20/2023 |
4/19/2023 |
$150.00 |
Contracted |
Pending Billing |
|
|
BS-007 |
4/20/2023 |
5/19/2023 |
$150.00 |
Contracted |
Pending Billing |
|
|
BS-008 |
5/20/2023 |
6/19/2023 |
$150.00 |
Contracted |
Pending Billing |
|
|
BS-009 |
6/20/2023 |
7/19/2023 |
$150.00 |
Contracted |
Pending Billing |
|
|
BS-010 |
7/20/2023 |
8/19/2023 |
$150.00 |
Contracted |
Pending Billing |
|
|
BS-011 |
8/20/2023 |
9/19/2023 |
$150.00 |
Contracted |
Pending Billing |
|
|
BS-012 |
9/20/2023 |
10/19/2023 |
$150.00 |
Contracted |
Pending Billing |
|
|
BS-013 |
10/20/2023 |
11/19/2023 |
$150.00 |
Contracted |
Pending Billing |
|
|
BS-014 |
11/20/2023 |
12/19/2023 |
$150.00 |
Contracted |
Pending Billing |
|
|
BS-015 |
12/20/2023 |
1/19/2024 |
$150.00 |
Contracted |
Pending Billing |
|
|
BS-016 |
1/20/2024 |
2/19/2024 |
$150.00 |
Contracted |
Pending Billing |
|
|
BS-017 |
2/20/2024 |
3/19/2024 |
$150.00 |
Contracted |
Pending Billing |
|
|
BS-018 |
3/20/2024 |
4/19/2024 |
$150.00 |
Contracted |
Pending Billing |
|
|
BS-019 |
4/20/2024 |
5/19/2024 |
$150.00 |
Contracted |
Pending Billing |
|
|
BS-020 |
5/20/2024 |
6/19/2024 |
$150.00 |
Contracted |
Pending Billing |
|
|
BS-021 |
6/20/2024 |
7/19/2024 |
$150.00 |
Contracted |
Pending Billing |
You have performed an invoice run to invoice one of the future billing schedules, BS-002 in this example.
|
Billing Schedule ID |
Period Start Date |
Period End Date |
Fee Amount |
Type |
Status |
Legacy record? |
|---|---|---|---|---|---|---|
|
BS-001 |
7/20/2021 |
11/19/2022 |
$2,400.00 |
Informational |
Invoiced |
TRUE |
|
BS-002 |
11/20/2022 |
12/19/2022 |
$150.00 |
Contracted |
Invoiced |
|
|
BS-003 to BS-0021 |
12/20/2022 |
7/19/2024 |
$150.00 |
Contracted |
Pending Billing |
You have cancelled the entire deal (full cancellation) by using the Terminate button on the CPQ cart. The system generates the billing schedules as shown in the table. The invoiced billing schedules are superseded.
|
Billing Schedule ID |
Period Start Date |
Period End Date |
Fee Amount |
Type |
Status |
Legacy record? |
Superseded |
|---|---|---|---|---|---|---|---|
|
BS-001 |
7/20/2021 |
11/19/2022 |
$2,400.00 |
Informational |
Invoiced |
TRUE |
Yes |
|
BS-002 |
11/20/2022 |
12/19/2022 |
$150.00 |
Contracted |
Invoiced |
Yes |
|
|
BS-003 |
12/20/2022 |
1/19/2023 |
$150.00 |
Contracted |
Cancelled |
||
|
BS-004 |
1/20/2023 |
2/19/2023 |
$150.00 |
Contracted |
Cancelled |
||
|
BS-005 |
2/20/2023 |
3/19/2023 |
$150.00 |
Contracted |
Cancelled |
||
|
BS-006 |
3/20/2023 |
4/19/2023 |
$150.00 |
Contracted |
Cancelled |
||
|
BS-007 |
4/20/2023 |
5/19/2023 |
$150.00 |
Contracted |
Cancelled |
||
|
BS-008 |
5/20/2023 |
6/19/2023 |
$150.00 |
Contracted |
Cancelled |
||
|
BS-009 |
6/20/2023 |
7/19/2023 |
$150.00 |
Contracted |
Cancelled |
||
|
BS-010 |
7/20/2023 |
8/19/2023 |
$150.00 |
Contracted |
Cancelled |
||
|
BS-011 |
8/20/2023 |
9/19/2023 |
$150.00 |
Contracted |
Cancelled |
||
|
BS-012 |
9/20/2023 |
10/19/2023 |
$150.00 |
Contracted |
Cancelled |
||
|
BS-013 |
10/20/2023 |
11/19/2023 |
$150.00 |
Contracted |
Cancelled |
||
|
BS-014 |
11/20/2023 |
12/19/2023 |
$150.00 |
Contracted |
Cancelled |
||
|
BS-015 |
12/20/2023 |
1/19/2024 |
$150.00 |
Contracted |
Cancelled |
||
|
BS-016 |
1/20/2024 |
2/19/2024 |
$150.00 |
Contracted |
Cancelled |
||
|
BS-017 |
2/20/2024 |
3/19/2024 |
$150.00 |
Contracted |
Cancelled |
||
|
BS-018 |
3/20/2024 |
4/19/2024 |
$150.00 |
Contracted |
Cancelled |
||
|
BS-019 |
4/20/2024 |
5/19/2024 |
$150.00 |
Contracted |
Cancelled |
||
|
BS-020 |
5/20/2024 |
6/19/2024 |
$150.00 |
Contracted |
Cancelled |
||
|
BS-021 |
6/20/2024 |
7/19/2024 |
$150.00 |
Contracted |
Cancelled |
||
|
BS-022 |
7/20/2021 |
11/19/2022 |
$-2400.00 |
Contracted |
Pending Billing |
|
|
|
BS-023 |
11/20/2022 |
12/19/2022 |
$-150.00 |
Contracted |
Pending Billing |
|
The entire deal is cancelled and Conga Billing updates the remaining billable amount to $0.00 since there is nothing to be billed in future for this asset. A refund of $2550 is credited to the customer.
Example 2: Cancelling One-time asset
Considering the data from the previous example, let us cancel a one-time legacy asset.
Scenario 1: Asset already billed in the legacy system
Since the asset is already billed in the legacy system, Conga Billing creates one billing schedule with the Type as Informational and assigns the Status as Invoiced:
|
Billing Schedule ID |
Period Start Date |
Period End Date |
Fee Amount |
Type |
Status |
Legacy BS record? |
|---|---|---|---|---|---|---|
|
BS-001 |
7/20/2021 |
11/19/2022 |
$5,400.00 |
Informational |
Invoiced |
TRUE |
After cancellation, the status of the Billing Schedule will be as follows depending on the same-day cancellation criteria being enabled.
|
Billing Schedule ID |
Period Start Date |
Period End Date |
Fee Amount |
Type |
Status |
Is Superseded |
Legacy BS record? |
|---|---|---|---|---|---|---|---|
|
BS-001 |
7/20/2021 |
11/19/2022 |
$5,400.00 |
Informational |
Invoiced |
Yes |
TRUE |
|
BS-001 |
7/20/2021 |
11/19/2022 |
$-5,400.00 |
Contracted |
Pending Billing |
The invoiced amount is refunded to the customer.
Scenario 2: Asset not billed in the legacy system
Since the asset is not billed in the legacy system, Conga Billing creates one billing schedule with the Type as Contracted and assigns the Status as Pending Billing:
|
Billing Schedule ID |
Period Start Date |
Period End Date |
Fee Amount |
Type |
Status |
|---|---|---|---|---|---|
|
BS-001 |
7/20/2021 |
11/19/2022 |
$5,400.00 |
Contracted |
Pending Billing |
After cancellation, the status of the billing schedule will be as follows:
|
Billing Schedule ID |
Period Start Date |
Period End Date |
Fee Amount |
Type |
Status |
|---|---|---|---|---|---|
|
BS-001 |
7/20/2021 |
11/19/2022 |
$5,400.00 |
Contracted |
Cancelled |
Since the asset is not billed yet, hence no refund is given and the pending billing schedule is marked as cancelled.
Example 3: Cancelling Usage asset
Suppose you are a billing administrator of a company selling computer hardware 'Internet Plans’ and you have already invoiced the customer. The details are summarized in the following table:
|
Original Start Date |
Start Date |
End Date |
First Billing Date |
Selling Frequency |
Billing Frequency |
Selling Term |
Quantity |
TCV |
Remaining Billable amount |
|---|---|---|---|---|---|---|---|---|---|
|
7/20/2021 |
7/20/2021 |
2/19/2023 |
11/20/2022 |
Monthly |
Monthly |
3 |
1 |
$0.00 |
$0.00 |
You processed the Usage Input for a date say 11/20/2022, 11/21/2022, and 11/25/2022 which is in the range for period start date 11/20/2022 and period end date 12/19/2022, for a fee amount of $400, Billing will update the respective billing schedule accordingly, here it is BS-002. You have invoiced BS-002.
|
Billing Schedule ID |
Period Start Date |
Period End Date |
Fee Amount |
Ready for Invoice Date |
Type |
Status |
Legacy BS record? |
|---|---|---|---|---|---|---|---|
|
BS-001 |
7/20/2021 |
11/19/2022 |
$0.00 |
7/20/2021 |
Informational |
Invoiced |
TRUE |
|
BS-002 |
11/20/2022 |
12/19/2022 |
$400.00 |
11/20/2022 |
Contracted |
Invoiced |
|
|
BS-003 |
12/20/2022 |
1/19/2023 |
$0.00 |
12/20/2022 |
Contracted |
Pending Billing |
|
|
BS-004 |
1/20/2023 |
2/19/2023 |
$0.00 |
1/20/2023 |
Contracted |
Pending Billing |
After cancellation on the same day, the status of the billing schedule will be as follows:
|
Billing Schedule ID |
Period Start Date |
Period End Date |
Fee Amount |
Ready for Invoice Date |
Type |
Status |
Is Superseded |
Legacy BS record? |
|---|---|---|---|---|---|---|---|---|
|
BS-001 |
7/20/2021 |
11/19/2022 |
$0.00 |
7/20/2021 |
Informational |
Invoiced |
TRUE |
|
|
BS-002 |
11/20/2022 |
12/19/2022 |
$400.00 |
11/20/2022 |
Contracted |
Invoiced |
Yes |
|
|
BS-003 |
12/20/2022 |
1/19/2023 |
$0.00 |
12/20/2022 |
Contracted |
Pending Billing |
||
|
BS-004 |
1/20/2023 |
2/19/2023 |
$0.00 |
1/20/2023 |
Contracted |
Pending Billing |
||
|
BS-005 |
11/20/2022 |
12/19/2022 |
$- 400.00 |
11/20/2022 |
Contracted |
Pending billing |
A refund is given to the customer.
