Use Case: To understand renewal with an example
Suppose you are a billing administrator of a company selling computer hardware 'Installation Device MF9’ with a TCV of $1800 for 12 months (billing term). You have already invoiced the customer for an amount of $900 over a billing period of 6 months and the Remaining Billable Amount is $900 to be billed over 6 months. The legacy contract was started in 2018 but the last known major price or config happened on 7/20/21. So the asset's start date is 7/20/21. Let's consider the first Billing Date as 11/20/0222. The legacy in Conga should have details as mentioned in the table.
|
Asset Name |
Original Start Date |
End Date |
First Billing Date |
Selling/Billing Frequency |
Selling Term |
Quantity |
TCV |
Remaining Billable Amount |
Net Unit Price |
|---|---|---|---|---|---|---|---|---|---|
|
Installation Device MF9 |
7/20/2021 |
5/19/2023 |
11/20/2022 |
Monthly |
12.00 |
1.00 |
$1800.00 |
$900.00 |
$150.00 |
Upon activating, Conga Billing creates 21 billing schedules, BS-001 for the already billed amount in the legacy system with Type as "Informational" and assigns the status as "Invoiced", BS-002 onwards are normal billing schedules with Type as Contracted and status as "Pending Billing" for 6 months.
|
Billing Schedule ID |
Period Start Date |
Period End Date |
Fee Amount |
Ready for Invoice Date |
Type |
Status |
Legacy record? |
|---|---|---|---|---|---|---|---|
|
BS-001 |
7/20/2021 |
11/19/2022 |
$900.00 |
7/20/2021 |
Informational |
Invoiced |
TRUE |
|
BS-002 |
11/20/2022 |
12/19/2022 |
$150.00 |
11/20/2022 |
Contracted |
Pending Billing |
|
|
BS-003 |
12/20/2022 |
1/19/2023 |
$150.00 |
12/20/2022 |
Contracted |
Pending Billing |
|
|
BS-004 |
1/20/2023 |
2/19/2023 |
$150.00 |
1/20/2023 |
Contracted |
Pending Billing |
|
|
BS-005 |
2/20/2023 |
3/19/2023 |
$150.00 |
2/20/2023 |
Contracted |
Pending Billing |
|
|
BS-006 |
3/20/2023 |
4/19/2023 |
$150.00 |
3/20/2023 |
Contracted |
Pending Billing |
|
|
BS-007 |
4/20/2023 |
5/19/2023 |
$150.00 |
4/20/2023 |
Contracted |
Pending Billing |
Invoice the billing schedules and then perform renewal operations from the CPQ cart. Select the Asset and in the cart set the Adjustment Amount>> Base Price Override = 200. Click Reprice and then FInalize the cart. The renewal of the asset extends by 12 months.
|
Billing Schedule ID |
Period Start Date |
Period End Date |
Fee Amount |
Ready for Invoice Date |
Type |
Status |
Legacy record? |
|---|---|---|---|---|---|---|---|
|
BS-001 |
7/20/2021 |
11/19/2022 |
$900.00 |
7/20/2021 |
Informational |
Invoiced |
TRUE |
|
BS-002 |
11/20/2022 |
12/19/2022 |
$150.00 |
11/20/2022 |
Contracted |
Invoiced |
|
|
BS-003 |
12/20/2022 |
1/19/2023 |
$150.00 |
12/20/2022 |
Contracted |
Invoiced |
|
|
BS-004 |
1/20/2023 |
2/19/2023 |
$150.00 |
1/20/2023 |
Contracted |
Invoiced |
|
|
BS-005 |
2/20/2023 |
3/19/2023 |
$150.00 |
2/20/2023 |
Contracted |
Invoiced |
|
|
BS-006 |
3/20/2023 |
4/19/2023 |
$150.00 |
3/20/2023 |
Contracted |
Invoiced |
|
|
BS-007 |
4/20/2023 |
5/19/2023 |
$150.00 |
4/20/2023 |
Contracted |
Invoiced |
|
|
BS-008 |
5/20/2023 |
6/19/2023 |
$200.00 |
5/20/2023 |
Contracted |
Pending Billing |
|
|
BS-009 |
6/20/2023 |
7/19/2023 |
$200.00 |
6/20/2023 |
Contracted |
Pending Billing |
|
|
BS-010 |
7/20/2023 |
8/19/2023 |
$200.00 |
7/20/2023 |
Contracted |
Pending Billing |
|
|
BS-011 |
8/20/2023 |
9/19/2023 |
$200.00 |
8/20/2023 |
Contracted |
Pending Billing |
|
|
BS-012 |
9/20/2023 |
10/19/2023 |
$200.00 |
9/20/2023 |
Contracted |
Pending Billing |
|
|
BS-013 |
10/20/2023 |
11/19/2023 |
$200.00 |
10/20/2023 |
Contracted |
Pending Billing |
|
|
BS-014 |
11/20/1023 |
12/19/2023 |
$200.00 |
11/20/2023 |
Contracted |
Pending Billing |
|
|
BS-015 |
12/20/2023 |
1/19/2024 |
$200.00 |
12/20/2023 |
Contracted |
Pending Billing |
|
|
BS-016 |
1/20/2024 |
2/19/2024 |
$200.00 |
1/20/2024 |
Contracted |
Pending Billing |
|
|
BS-017 |
2/20/2024 |
3/19/2024 |
$200.00 |
2/20/2024 |
Contracted |
Pending Billing |
|
|
BS-018 |
3/20/2024 |
4/19/2024 |
$200.00 |
3/20/2024 |
Contracted |
Pending Billing |
|
|
BS-019 |
4/20/2024 |
5/19/2024 |
$200.00 |
4/20/2024 |
Contracted |
Pending Billing |
The remaining billable amount gets updated to $2400.00 which is equal to the renewal amount.
