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.
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.
The following table contains asset setup information used in this example.
| 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.
| 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.
| 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.
| 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 |
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.
The following table contains asset setup information used in this example.
| 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.
| 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.
| 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.
| 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.
| 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 |
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.
The following table contains asset setup information used in this example.
| 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.
| 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.
| 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.
| 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.
| 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 |
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> |
The following table contains asset setup information used in this example.
| 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 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.
| 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.
| 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.
| 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 |