Transfer Types - Calculate and Enter

Transfer Type - Calculate

When you use the Calculate transfer type, the system will calculate the group reclassification based on the group amortization start date entered. The date in the Group Amortization Start Date field is defaulted to the date placed in service of the member asset. You can update the group amortization start date to any date from the current period date to its date placed in service.

Calculate Prior Period Group Amortization Start Date

When a prior period date is entered as the group amortization start date, the transaction is treated as a backdated group reclassification. This requires calculating the depreciation expense for the prior periods, and making the appropriate adjustments to the source and destination group assets.

When you make a prior period group reclassification, the system subtracts the depreciation expense from the source group asset and adds a depreciation adjustment expense, or catchup expense, to the destination group asset. This ensures that the financial impact of having the member asset in the wrong group has been reversed.

The journal entries created are as follows:

Account Description Debit Credit
Source Group Accumulated Depreciation <Source Group Depreciation>  
Source Group Depreciation Expense   <Source Group Depreciation>
Destination Group Depreciation Expense <Destination Group Depreciation>  
Destination Group Accumulated Depreciation   <Destination Group Depreciation>

The destination group asset depreciation expense is calculated using the destination group asset depreciation method. The amount is added to the destination group asset accumulated depreciation balance. This type of transfer is treated as a back dated amortized adjustments for both the source and destination group assets.

Example: Transfer Type Calculate - Between Groups

Asset Information

The following table contains asset setup information used in this example.

Group Asset A Setup

Asset Setup Item Asset Setup Information
Group Asset: Group A
Member Assets: Asset 1 (Cost: 30,000; DPIS: Q3-2000) Asset 2 (Cost: 20,000; DPIS: Q3-2000)
Depreciation Method: Flat Rate with Cost Basis Depreciable Basis Rule: Use Recoverable Cost
Depreciation Rate: 20%
Group DPIS / Prorate Date: 01-Jan-2000
Depreciation Calendar: Quarterly

The following table contains asset setup information used in this example.

Group Asset B Setup

Asset Setup Item Asset Setup Information
Group Asset: Group B
Member Assets: Asset 3 (Cost: 50,000; DPIS: Q1-2000) Asset 4 (Cost: 30,000; DPIS: Q1-2000)
Depreciation Method: Straight Line 2 Years
Group DPIS / Prorate Date: 01-Jan-2000
Depreciation Calendar: Quarterly

The following table contains asset setup information used in this example.

Group Reclassification

Asset Setup Item Asset Setup Information
Group Reclassification: Transfer Asset 1 from Group A to Group B
Period Performed: Q1-2001
Group Amortization Start Date: Q3-2000
Transfer Type: Calculate

The table below contains the quarterly cost and calculated amounts for Group Asset A.

Calendar Period Cost Depreciation Accumulated Depreciation
Q1-2000 - - -
Q2-2000 - - -
Q3-2000 50,000 2,500 2,500
Q4-2000 50,000 2,500 5,000
Q1-2001 20,000 <2,000> 3,000
Q2-2001 20,000 1,000 4,000
Q3-2001 20,000 1,000 5,000
Q4-2001 20,000 1,000 6,000

The table below contains the quarterly cost and calculated amounts for Group Asset B.

Group Asset B

Calendar Period Cost Depreciation Accumulated Depreciation
Q1-2000 80,000 10,000 10,000
Q2-2000 80,000 10,000 20,000
Q3-2000 80,000 10,000 30,000
Q4-2000 80,000 10,000 40,000
Q1-2001 110,000 25,000 65,000
Q2-2001 110,000 15,000 80,000
Q3-2001 110,000 15,000 95,000
Q4-2001 110,000 15,000 110,000

In Q1-2001, depreciation is calculated as follows:

Group A

Periodic Depreciation + Catchup Expense Up to Q3-2000

= [(50,000 - 20,000) * 20% / 4] + [(50,000 - 20,000) * 20% / 4 * 2 - (2,500 + 2,500)] = <2,000>

Group B Periodic Depreciation + Catchup Expense up to Q3-2000

= [(110,000 - 20,000) / 6] + [(110,000 - 20,000) / 6 * 2 - (10,000 + 10,000)] = 25,000

The system creates journal entries in Q1-2001 as follows:

Account Description Debit Credit
Group A Accumulated Depreciation 2,000  
Group A Depreciation Expense   2,000
Group B Depreciation Expense 25,000  
Group B Accumulated Depreciation   25,000

Add a Standalone Asset

When you add a standalone asset into a group asset, the system uses the group asset amortization start date to calculate any required catchup expenses. The catchup expense for a standalone asset is calculated using the depreciation method of the standalone asset. It is deducted from the standalone asset accumulated depreciation balance before it is added to a group asset. The remaining accumulated depreciation balance of the standalone asset is added to the group asset when it becomes a member asset. Also, the cost of the member asset is added to the cost of the group asset.

The catchup depreciation expense is calculated using the group asset depreciation method. The catchup depreciation amount is added to the group asset accumulated depreciation balance in the current period of the transfer. This type of transfer is treated as a backdated amortized adjustment to the group asset.

The table below contains the annual cost and calculated amounts for the group and member assets.

Example: Transfer Type Calculate - Add A Standalone Asset Into A Group Asset

The following table contains asset setup information used in this example.

Standalone Asset 1 Setup

Asset Setup Item Asset Setup Information
Asset: Asset 1 (Cost: 20,000; DPIS: Q3-2000)
Depreciation Method: Flat Rate of 20% with Cost Basis Depreciable Basis Rule: Use Recoverable Cost
Depreciation Calendar: Quarterly

The following table contains asset setup information used in this example.

Group Asset B Setup

Asset Setup Item Asset Setup Information
Group Asset: Group B
Member Assets: Asset 3 (Cost: 50,000; DPIS: Q1-2000), Asset 4 (Cost: 30,000; DPIS: Q1-2000)
Depreciation Method: Straight Line 2 years
Depreciation Calendar: Quarterly

The following table contains asset setup information used in this example.

Group Reclassification

Asset Setup Item Asset Setup Information
Group Reclassification: Add Asset 1 to Group B
Period Performed: Q1-2001
Group Amortization Start Date Q4-2000
Transfer Type: Calculate

The table below contains the quarterly cost and calculated amounts for Asset 1.

Member Asset 1

Calendar Period Cost Depreciation Accumulated Depreciation
Q1-2000 - - -
Q2-2000 - - -
Q3-2000 20,000 1,000 1,000
Q4-2000 20,000 1,000 2,000
Q1-2001 20,000 <1,000> 0
Q3-2001 20,000 - 0
Q4-2001 20,000 - 0

The table below contains the quarterly cost and calculated amounts for Group Asset B.

Group Asset B

Calendar Period Cost Depreciation Accumulated Depreciation
Q1-2000 80,000 10,000 10,000
Q2-2000 80,000 10,000 20,000
Q3-2000 80,000 10,000 30,000
Q4-2000 80,000 10,000 40,000
Q1-2001 100,000 17,600 58,600
Q2-2001 100,000 13,800 72,400
Q3-2001 100,000 13,800 86,200
Q4-2001 100,000 13,800 100,000

In Q1-2001, Group Reclassification is calculated as follows:

Asset 1 Catch Up Expense = -20,000 * 20% / 4 = <1,000>

Asset 1 Accumulated Depreciation Transferred to Group B = 2,000 - 1,000 = 1,000

Group B Depreciation = Periodic Depreciation + Catchup Expense for Q4-2000 = [(100,000 - 30,000 - 1,000) / 5] + [(100,000 - 30,000 - 1,000) / 5 - 10,000] = 18,000

The system creates journal entries in Q1-2001 as follows:

Account Description Debit Credit
Asset 1 Accumulated Depreciation 1,000  
Asset 1 Depreciation Expense   1,000
Account Description Debit Credit
Asset 1 Accumulated Depreciation 1,000  
Group B Accumulated Depreciation   1,000
Account Description Debit Credit
Group B Depreciation Expense 17,600  
Group B Accumulated Depreciation   17,600

If Asset 1 and Group Asset B have different balancing segment values, and you enabled allow intercompany member asset assignments, Oracle Assets creates intercompany balancing journal entries for Q1-2001 as follows:

Account Description Debit Credit
Company 01 Asset 1 Accumulated Depreciation 1,000  
Company 01 Asset 1 Depreciation Expense   1,000
Account Description Debit Credit
Company 01 Asset 1 Accumulated Depreciation 1,000  
Company 02 Group B Accumulated Depreciation   1,000
Account Description Debit Credit
Company 02 Group B Depreciation Expense 17,600  
Company 02 Group B Accumulated Depreciation   17,600
Account Description Debit Credit
Company 02 Intercompany AR 1,000  
Company 01 Intercompany AP   1,000

Transfer a Member Asset out of a Group Asset

When you remove the group assignment of a member asset (removing the member asset from the group), the group amortization start date is generally defaulted to the date placed in service of the member asset. However, if the member asset has already performed a group reclassification, the group amortization start date will default to the last group reclassification amortization start date.

You cannot backdate a group reclassification transaction for a member asset before its last group reclassification amortization start date or its last retirement date.

All group reclassifications of member assets are treated as amortized adjustments to the member and the group asset. You cannot perform an expensed adjustment for a standalone asset if it was formerly a member asset, which experienced amortized adjustments while part of a group asset.

Example: Transfer Type Calculate - Remove a Member Asset from Group Asset

The following table contains asset setup information used in this example.

Group Asset A Setup

Asset Setup Item Asset Setup Information
Group Asset: Group A
Member Assets: Asset 1 (cost: 20,000; dpis: Q1-2000), Asset 2 (cost: 30,000; dpis: Q3-2000)
Depreciation Method: Straight Line 2 years
Depreciation Calendar: Quarterly

The following table contains asset setup information used in this example.

Member Asset 2 Setup

Asset Setup Item Asset Setup Information
Asset: Asset 2 (cost: 20,000; dpis: Q3-2000)
Depreciation Method: Straight Line 3 years
Depreciation Calendar: Quarterly

The following table contains asset setup information used in this example.

Group Reclassification

Asset Setup Item Asset Setup Information
Group Reclassification: Remove Asset 2 from Group B
Period Performed: Q1-2001
Group Amortization Start Date: Q3-2000 (Restricted to the DPIS of Asset 2)
Transfer Type: Calculate

The table below contains the quarterly cost and calculated amounts for Group Asset A.

Group Asset A

Calendar Period Cost Depreciation Accumulated Depreciation
Q1-2000 20,000 2,500 2,500
Q2-2000 20,000 2,500 5,000
Q3-2000 50,000 7,500 12,500
Q4-2000 50,000 7,500 20,000
Q1-2001 20,000 <7,500> 12,500
Q2-2001 20,000 2,500 15,000
Q3-2001 20,000 2,500 17,500
Q4-2001 20,000 2,500 20,000

The table below contains the quarterly cost and calculated amounts for Asset 2.

Asset 2

Calendar Period Cost Depreciation Accumulated Depreciation
Q1-2000 - - -
Q2-2000 - - -
Q3-2000 30,000 - 0
Q4-2000 30,000 - 0
Q1-2001 30,000 7,500 7,500
Q2-2001 30,000 2,500 10,000
Q3-2001 30,000 2,500 12,500
Q4-2001 30,000 2,500 15,000

In Q1-2001, depreciation is calculated as follows:

Group A Depreciation = Periodic Depreciation + Catchup Expense for Q1-2000 = [(20,000 - 5,000) / 6] + [(20,000 - 5,000) / 6 * 2 - (7,500 + 7,500)] = <7,500>

Asset 2 Depreciation = 30,000 / 12 * 3 = 7,500

The system creates journal entries in Q1-2001 as follows:

Account Description Debit Credit
Group A Accumulated Depreciation 7,500  
Group A Depreciation Expense   7,500
Account Description Debit Credit
Asset 2 Depreciation Expense 7,500  
Asset 2 Accumulated Depreciation   7,500

Calculate - Current Period Group Amortization Start Date

When the group amortization start date is in the current period, the transaction results in a current period transfer of accumulated depreciation. There is no need to adjust depreciation amounts that have already been taken for the member asset or the group asset. The transfer is processed in the current period by removing the calculated accumulated depreciation amount from the source group asset, and adding it to the accumulated depreciation balance of the destination group asset. The journal entries created are as follows:

Source

Account Description Debit Credit
Group Accumulated Depreciation <Source Group Depreciation>  
Group Depreciation Expense   <Source Group Depreciation>

Destination

Account Description Debit Credit
Group Depreciation Expense <Destination Group Depreciation>  
Group Accumulated Depreciation   <Destination Group Depreciation>

Example: Transfer Type Calculate - Between Groups

The following table contains asset setup information used in this example.

Asset A Setup

Asset Setup Item Asset Setup Information
Group Asset: Group A
Member Assets: Asset 1 (cost: 20,000; dpis: Q1-2000) Asset 2 (cost: 20,000; dpis: Q1-2000)
Depreciation Method: Flat Rate of 20% with Cost Basis Depreciable Basis Rule: Use Recoverable Cost
Depreciation Calendar: Quarterly

The following table contains asset setup information used in this example.

Asset B Setup

Asset Setup Item Asset Setup Information
Group Asset: Group B
Member Assets: Asset 3 (cost: 50,000; dpis: Q1-2000), Asset 4 (cost: 30,000; dpis: Q1-2000)
Depreciation Method: Straight Line 2 years
Depreciation Calendar: Quarterly

The following table contains asset setup information used in this example.

Group Reclassification

Asset Setup Item Asset Setup Information
Group Reclassification: Transfer Asset 1 from Group A to Group B
Period Performed: Q1-2001
Group Amortization Start Date: Q1-2001
Transfer Type: Calculate

The table below contains the quarterly cost and calculated amounts for Group Asset A.

Group Asset A

Calendar Period Cost Depreciation Accumulated Depreciation
Q1-2000 40,000 2,000 2,000
Q2-2000 40,000 2,000 4,000
Q3-2000 40,000 2,000 6,000
Q4-2000 40,000 2,000 8,000
Q1-2001 20,000 1,000 5,000
Q2-2001 20,000 1,000 6,000
Q3-2001 20,000 1,000 7,000
Q4-2001 20,000 1,000 8,000

The table below contains the quarterly cost and calculated amounts for Group Asset B.

Group Asset B

Calendar Period Cost Depreciation Accumulated Depreciation
Q1-2000 80,000 10,000 10,000
Q2-2000 80,000 10,000 20,000
Q3-2000 80,000 10,000 30,000
Q4-2000 80,000 10,000 40,000
Q1-2001 100,000 14,000 58,000
Q2-2001 100,000 14,000 72,000
Q3-2001 100,000 14,000 86,000
Q4-2001 100,000 14,000 100,000

In Q1-2001, Group Reclassification is calculated as follows:

Member Asset 1 Accumulated Depreciation Transferred Out = (40,000 - 20,000) * 20% / 4 * 4 = 4,000

Group Asset A Depreciation Expense = New Cost * Annual Depreciation Rate / Periods per Year = (40,000 - 20,000) * 20% / 4 = 1,000

Group Asset B Depreciation Expense = (New Cost - Recalculated Accumulated Depreciation) / Remaining Life = [(80,000 + 20,000) - 4,000 - 40,000] / 4 = 14,000

The system creates journal entries in Q1-2001 as follows:

Group Reclassification:

Account Description Debit Credit
Group A Accumulated Depreciation 4,000  
Group B Depreciation Expense   4,000

Periodic Depreciation:

Account Description Debit Credit
Group A Depreciation Expense 1,000  
Group A Accumulated Depreciation   1,000
Group B Depreciation Expense 14,000  
Group B Accumulated Depreciation   14,000