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:

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:

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

Consulting Kit

800

(800 – 0) ÷ 800 = 1

600

Strategic Planning

0

540

900

900 ÷1,000 =0.9

0.9 ×800 =720

540 ÷600 =0.9

0.9 ×600 =540

Market Research

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

Consulting Kit

800

(800 – 0) ÷ 800 = 1

200

Strategic Planning

0

180

900

900 ÷1,000 =0.9

0.9 ×800 =720

180 ÷200 =0.9

0.9 ×200 =180

Market Research

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.

Related Topics

General Notices