Carve In/Carve Out Adjustment Example With Kit Items
In this example, Insight Partners, a business consulting firm, provides a one-month consulting package to Simple Tech, a tech start-up, for $800. The consulting package includes two services:
-
Strategic Planning
-
Market Research
All revenue is recognized at the end of the month, as it's a one-month package.
In October, the following records are created in NetSuite:
-
Two non-inventory items for sale: Strategic Planning and Market Research. The Allocation Type is set to Normal and the Create Revenue Plans On field is set to Fulfillment for both items. The Amount Source field on the revenue recognition rule is set to Event-Percent based on quantity.
-
A kit/package item with Strategic Planning and Market Research as its components. Auto-Expansion for Revenue Management is checked and the Allocation Type is set to Normal. The Create Revenue Plans On field is set to Fulfillment. The Amount Source field on the revenue recognition rule is set to Event-Percent based on quantity.
-
Two fair value price records for both Strategic Planning and Market Research. Strategic Planning has a base fair value of 900 and Market Research has a base fair value of 100. The fair value formula is Quantity*FV.
-
A sales order is created for the Consulting Kit, which includes Strategic Planning and Market Research, totaling $800.
-
A revenue arrangement is generated for the sales order reflecting the transaction total of $800.
-
A one-month revenue recognition plan, with all revenue to be recognized on October 31st.
-
Two invoices.
-
Revenue recognition journal entry.
-
Two carve-in/carve-out adjustments.
-
Unbilled receivable adjustment.
-
Reversal of prior unbilled receivable adjustment.
Sales Order and Revenue Arrangement
The parent Consulting Kit represents the total package sold for $800, while the fair value of the child elements total $1000. Revenue is allocated based on the fair value of each component: Strategic Planning is allocated 90% of the total revenue and Market Research is allocated 10%.
The revenue element for the parent Consulting Kit item has a sales amount but no fair value amount. The revenue elements for the kit components, Strategic Planning and Market Research, have fair value amounts but no sales amounts.
Item |
Parent Kit Element |
Quantity |
Discounted Sales Amount |
Base Fair Value |
Calculated Fair Value Amount |
Revenue Amount |
Revenue Allocation Ratio |
---|---|---|---|---|---|---|---|
Consulting Kit |
— |
1 |
800 |
— |
— |
— |
— |
Strategic Planning |
Consulting Kit |
1 |
0 |
900 |
900 |
720 |
90% |
Market Research |
Consulting Kit |
1 |
0 |
100 |
100 |
80 |
10% |
Total |
— |
— |
800 |
— |
1,000 |
800 |
100% |
Revenue Plan
Insight Partners updates their revenue plans. Revenue will be recognized in October.
Item |
Plan Total |
Amount Recognized |
Remaining |
Planned Period |
---|---|---|---|---|
Strategic Planning |
720 |
0 |
720 |
October |
Market Research |
80 |
0 |
80 |
October |
Partial Invoice 1
On October 15, Insight Partners bills $600 of the $800 sales order.
Item |
Quantity |
Amount |
---|---|---|
Consulting Kit |
0.75 |
600 |
The general ledger impact of the invoice is as follows:
Account |
Debit |
Credit |
---|---|---|
Accounts Receivable |
600 |
|
Deferred Revenue |
|
600 |
Revenue Recognition Journal
On October 30, after completing the consulting services, Insight Partners recognizes all the revenue for the provided services.
The general ledger impact of the revenue recognition journal is as follows:
Account |
Item |
Debit |
Credit |
---|---|---|---|
Deferred Revenue |
Strategic Planning |
720 |
|
Income |
Strategic Planning |
|
720 |
Deferred Revenue |
Market Research |
80 |
|
Income |
Market Research |
|
80 |
Carve In/Carve Out Adjustment 1
On October 30, Insight Partners runs reclassification. Since the discounted sales amount is not equal to the revenue amount, a carve in/carve out adjustment is posted to accurately allocate the revenue to each element.
The carve-in and carve-out ratios are used to allocate the billing amount to the revenue elements. The carve-out for the Consulting Kit is $600 because it has zero fair value, resulting in a 100% carve out. Consequently, deferred revenue for the Consulting Kit is debited, reducing its deferred revenue balance by the carve-out amount of $600. The $600 is reallocated to its kit components using the carve-in amount.
The carve-in allocations for the kit components are 90% and 10% of $600, respectively. Consequently, the deferred revenue for Strategic Planning and Market Research is credited, increasing their deferred revenue balances by the carve-in amounts of $540 and $60. Since 75% of the sales order is billed, only 75% the revenue amount is allocated.
For more information, see Fair Value and Allocation.
Item |
Discounted Sales Amount |
Billed Amount |
Calculated Fair Value Amount |
Revenue Allocation Ratio |
Revenue Amount |
Carve-in Ratio |
Carve-out Ratio |
Carve-in |
Carve-out |
---|---|---|---|---|---|---|---|---|---|
C |
800 |
— |
— |
— |
— |
— |
(800 – 0) ÷ 800 = 1 |
— |
600 |
S |
0 |
540 |
900 |
900 ÷1,000 =0.9 |
0.9 ×800 =720 |
540 ÷600 =0.9 |
— |
0.9 ×600 =540 |
— |
Market R |
0 |
60 |
100 |
100 ÷1,000 =0.1 |
0.1 ×800 =80 |
60 ÷600 =0.1 |
— |
0.1 ×600 =60 |
— |
Total |
800 |
600 |
1,000 |
— |
800 |
— |
— |
600 |
600 |
The general ledger impact of carve-in/carve-out adjustment 1 is as follows:
Account |
Item |
Debit |
Credit |
---|---|---|---|
Deferred Revenue |
Consulting Kit |
600 |
|
Deferred Revenue |
Strategic Planning |
|
540 |
Market Research |
|
60 |
Unbilled Receivable Adjustment
An unbilled receivable adjustment is posted in October because cumulative billing is less than cumulative revenue recognition.
The unbilled calculations are as follows:
-
For Strategic Planning, the billed amount is $540 and the recognized amount is $720, leaving an unbilled amount of $180.
-
For Market Research, the billed amount is $60 and the recognized amount is $80, leaving an unbilled amount of $20.
The general ledger impact of the unbilled receivable adjustment is as follows:
Account |
Item |
Debit |
Credit |
---|---|---|---|
Unbilled Receivable |
Strategic Planning |
180 |
|
Market Research |
20 |
|
|
Deferred Revenue |
Strategic Planning |
|
180 |
Market Research |
|
20 |
Invoice 2
On October 31, Insight Partners bills the rest of the sales order. The sales order is now fully billed.
Item |
Quantity |
Amount |
---|---|---|
Consulting Kit |
0.25 |
200 |
The general ledger impact is as follows:
Account |
Debit |
Credit |
---|---|---|
Accounts Receivable |
200 |
|
Deferred Revenue |
|
200 |
Carve In Carve Out Adjustment 2
On October 31, after billing the rest of the sales order, Insight Partners runs reclassification again.
The carve-in and carve-out ratios are used to allocate the billing amount to the revenue elements. The carve-out for the Consulting Kit is $200 because it has zero fair value, resulting in a 100% carve out. Consequently, deferred revenue for the Consulting Kit is debited, reducing its deferred revenue balance by the carve-out amount of $200. The $200 is reallocated to its kit components using the carve-in amount.
The carve-in allocations for the kit components are 90% and 10% of $200, respectively. Consequently, the deferred revenue for Strategic Planning and Market Research is credited, increasing their deferred revenue balances by the carve-in amounts of $180 and $20. The full revenue amount is now allocated.
For more information about carving ratios, see Fair Value and Allocation.
Item |
Discounted Sales Amount |
Billed Amount |
Calculated Fair Value Amount |
Revenue Allocation Ratio |
Revenue Amount |
Carve-in Ratio |
Carve-out Ratio |
Carve-in |
Carve-out |
---|---|---|---|---|---|---|---|---|---|
C |
800 |
— |
— |
— |
— |
— |
(800 – 0) ÷ 800 = 1 |
— |
200 |
S |
0 |
180 |
900 |
900 ÷1,000 =0.9 |
0.9 ×800 =720 |
180 ÷200 =0.9 |
— |
0.9 ×200 =180 |
— |
Market R |
0 |
20 |
100 |
100 ÷1,000 =0.1 |
0.1 ×800 =80 |
20 ÷200 =0.1 |
— |
0.1 ×200 =20 |
— |
Total |
800 |
200 |
1,000 |
— |
800 |
— |
— |
200 |
200 |
The general ledger impact of carve-in/carve-out adjustment 2 is as follows:
Account |
Item |
Debit |
Credit |
---|---|---|---|
Deferred Revenue |
Consulting Kit |
200 |
|
Deferred Revenue |
Strategic Planning |
|
180 |
Market Research |
|
20 |
The summarized calculations of the carve-in/carve-out adjustments show that the carve amounts are the difference between the discounted sales amount and revenue amount for each element:
Consulting Kit:
-
Discounted sales amount: $800
-
Revenue amount: $0
-
Total carve-out amount: $800
Strategic Planning:
-
Discounted sales amount: $0
-
Revenue Amount: $720
-
Total carve-in amount: $720
Market Research:
-
Discounted sales amount: $0
-
Revenue amount: $80
-
Total carve-in amount: $80
Reversal of Prior Unbilled Receivable
A reversal of the prior unbilled receivable adjustment is created because the sales order is now fully billed.
The general ledger impact of the reversal unbilled receivable adjustment is as follows:
Account |
Item |
Debit |
Credit |
---|---|---|---|
Unbilled Receivable |
Strategic Planning |
|
180 |
Market Research |
|
20 |
|
Deferred Revenue |
Strategic Planning |
180 |
|
Market Research |
20 |
|
T Accounts
The following T accounts show the balances, transactions, and dates for accounts receivable, unbilled receivable, deferred revenue, and income accounts during the revenue recognition process for Insight Partners.
The accounts receivable account has total debits of $800 from two invoices, resulting in an ending balance of $800.
Accounts Receivable |
|
---|---|
Debit |
Credit |
600 (Oct 15 – Invoice 1) |
|
200 (Oct 31 – Invoice 2) |
|
800 (Ending Balance) |
|
The unbilled receivable account for Strategic Planning has equal total debits and credits of $180, resulting in an ending balance of $0 after billing is completed.
Unbilled Receivable Strategic Planning |
|
---|---|
Debit |
Credit |
180 (Oct 30 – Unbilled Adjustment) |
|
|
180 (Oct 31 – Reversal of Unbilled Adjustment) |
0 (Ending Balance) |
|
The unbilled receivable account for Market Research has equal total debits and credits of $20, resulting in an ending balance of $0 after billing is completed.
Unbilled Receivable Market Research |
|
---|---|
Debit |
Credit |
20 (Oct 30 – Unbilled Adjustment) |
|
|
20 (Oct 31 – Reversal of Unbilled Adjustment) |
0 (Ending Balance) |
|
The deferred revenue account for the Consulting Kit has equal total debits and credits of $800, resulting in an ending balance of $0.
Deferred Revenue Consulting Kit |
|
---|---|
Debit |
Credit |
|
600 (Oct 15 – Invoice 1) |
600 (Oct 30 – Carve Adjustment 1) |
|
|
200 (Oct 31 – Invoice 2) |
200 (Oct 31 – Carve Adjustment 2) |
|
0 (Ending Balance) |
|
The deferred revenue account for Strategic Planning has equal total debits and credits of $900, resulting in an ending balance of $0.
Deferred Revenue Strategic Planning |
|
---|---|
Debit |
Credit |
720 (Oct 30 – Rev Rec Journal) |
|
|
540 (Oct 30 – Carve Adjustment 1) |
|
180 (Oct 30 – Unbilled Adjustment) |
|
180 (Oct 31 – Carve Adjustment 2) |
180 (Oct 31 – Reversal of Unbilled Adjustment) |
|
0 (Ending Balance) |
|
The deferred revenue account for Market Research has equal total debits and credits of $100, resulting in an ending balance of $0.
Deferred Revenue Market Research |
|
---|---|
Debit |
Credit |
80 (Oct 30 – Rev Rec Journal) |
|
|
60 (Oct 30 – Carve Adjustment 1) |
|
20 (Oct 30 – Unbilled Adjustment) |
|
20 (Oct 31 – Carve Adjustment 2) |
20 (Oct 31 – Reversal of Unbilled Adjustment) |
|
0 (Ending Balance) |
|
The income account for the Strategic Planning has total credits of $720, resulting in an ending balance of $720.
Income Strategic Planning |
|
---|---|
Debit |
Credit |
|
720 (Rev Rec Journal) |
|
720 (Ending Balance) |
The income account for Market Research has total credits of $80, resulting in an ending balance of $80.
Income Market Research |
|
---|---|
Debit |
Credit |
|
80 (Rev Rec Journal) |
|
80 (Ending Balance) |
At the end of October, the revenue arrangement has been full recognized and reclassified. The deferred revenue balance is $0.