|
|
|
|
|
Navigator > Reports > Fixed Assets > Asset Reports > Add Layout > Depreciation Schedule
The following fields are available for the FA Depreciation Schedule report. See below for Dissection Types.
Asset Group Code |
The code for the Asset Group. |
Asset Group Name |
The name of the Asset Group. |
Asset Code |
The code for the asset. |
Asset Name |
The name of the asset. |
Asset Date |
The date the asset was first acquired. |
Opening Asset Value |
Opening value as at the first period in the Year. |
Year Asset Addition Activity |
Sum of asset dissections on addition transactions for the Year to date. |
Year Asset Disposal Activity |
Sum of asset dissections for disposal transactions for the Year to date. |
Closing Asset Value |
Opening Asset Value + Asset Activity. |
Depreciation Rate |
FA Balance for the report period, falling back to FA Value. |
Depreciation Code |
The method used for depreciation. |
Opening Depreciation To Date |
Opening Depreciation at the start of the Year. This is the total depreciation expensed (claimed) for the Asset, in the Profit and Loss Statement. |
Year Depn Depn Activity |
Sum of Depreciation dissections for Depreciation transactions for the Year to date. |
Year Depn Disposal Activity |
Sum of Depreciation dissections for disposal transactions for the Year to date. |
Closing Depreciation Value |
Opening Depreciation Value + Depreciation Activity. |
Closing Book Value |
Opening Book Value + Asset Activity - Depreciation Activity. |
Asset Location Code |
The code of the physical asset location. |
Asset Location Name |
The name of the physical asset location. |
Asset Quantity |
Quantity of the asset owned. |
Bar Code |
Bar code for the asset. |
Book Code |
The Asset Book code. |
Category 1 |
Asset Category 1, information field. |
Category 1 Description |
Asset Category 1, description field. |
Category 2 |
Asset Category 2, information field. |
Category 2 Description |
Asset Category 2, description field. |
Closing Cost To Date |
Opening Cost to Date + Addition Activity - Writeback Activity. |
Closing Depreciable Value |
Opening Depreciable Value + Adjustment Activity + Closing Adjustment Activity. |
Closing Depreciation To Date |
Opening Depreciation To Date + Expense Activity - Writeback Activity. |
Closing Disposal Value |
Opening Disposal Value + (Asset Activity - Depreciation Activity + Expense Activity on Disposal Transactions only). |
Closing Gain Loss Value |
Opening Gain Loss Value + Gain Loss Activity. |
Closing Gain Value |
Opening Gain Value + Gain Activity. |
Closing Loss Value |
Opening Loss Value + Loss Activity. |
Closing Realised Value |
Opening Realised Value + Realised Activity. |
Closing Recovered Value |
Opening Recovered Value + Recovered Activity. |
Closing Revaluation Value |
Opening Revaluation Value + Revaluation Activity. |
Created Date |
Date the Fixed Asset record was created. |
Created Time |
Time the Fixed Asset record was created. |
Created User Code |
User Code that created the Fixed Asset record. |
Custom 1 |
Asset Custom 1, information field. |
Custom 2 |
Asset Custom 2, information field. |
Image Path |
File location of the Asset Image. |
Inactive |
Indicates whether the Asset has been set to Inactive. |
Last History Period |
For Inactive Assets, the last history period for the asset. |
Modified Date |
Date the record was last modified. |
Modified Time |
Time the record was last modified. |
Modified User Code |
User Code that last modified the record. |
Opening Book Value |
Opening book value for the Asset in the Year. |
Opening Cost To Date |
Opening cost to date for the Asset in the Year. |
Opening Depreciable Value |
Opening depreciable value for the Asset in the Year. |
Opening Depreciation Value |
Opening Depreciation value for the Asset in the Year. This is the accumulated depreciation for the Asset at this point in time (in the Balance Sheet). |
Opening Disposal Value |
Opening disposal value for the Asset in the Year. |
Opening Gain Loss Value |
Opening Gain Loss value for the Asset in the Year. |
Opening Gain Value |
Opening Gain value for the Asset in the Year. |
Opening Loss Value |
Opening Loss value for the Asset in the Year. |
Opening Realised Value |
Opening realised value for the Asset in the Year. |
Opening Recovered Value |
Opening recovered value for the Asset in the Year. |
Opening Revaluation Value |
Opening revaluation value for the Asset in the Year. |
Parent Asset Code |
If the asset has a Parent Asset, the Parent Asset Code. |
Parent Asset Name |
If the asset has a Parent Asset, the Parent Asset Name. |
Period Addition Activity |
Sum of asset dissections on addition transactions for the Period. |
Period Addition Disposals |
Period Addition Activity - Period Disposal Activity. |
Period Adjustment Activity |
Sum of Adjustment dissections for the Period to date. |
Period Asset Activity |
Sum of asset dissections for the Period. |
Period Asset Addition Activity |
Sum of asset dissections on addition transactions for the Period. |
Period Asset Disposal Activity |
Sum of asset dissections for disposal transactions for the Period. |
Period Asset Revaluation Activity |
Sum of asset dissections for revaluation transactions for the Period. |
Period Asset Value |
Cost or Value of the Asset as at the Period. |
Period Book Value |
Book value for the Asset in the Period. |
Period Cost To Date |
Cost to date for the Asset in the Period. |
Period Depn Depn Activity |
Sum of Depreciation dissections for Depreciation transactions for the Period. |
Period Depn Disposal Activity |
Sum of Depreciation dissections for disposal transactions for the Period. |
Period Depn Revaluation Activity |
Sum of Depreciation dissections for revaluation transactions for the Period. |
Period Depreciable Value |
Opening depreciable value for the Asset in the Period. |
Period Depreciation Activity |
Sum of Depreciation (balance sheet) dissections for the Period. |
Period Depreciation To Date |
Opening Depreciation at the start of the Period. This is the total depreciation expensed (claimed) for the Asset, in the Profit and Loss Statement. |
Period Depreciation Value |
Opening Depreciation value for the Asset in the Period. This is the accumulated depreciation for the Asset at this point in time (in the Balance Sheet). |
Period Disposal Activity |
Sum of disposal transactions for the Period. |
Period Disposal Value |
Opening disposal value for the Asset in the Period. |
Period Expense Activity |
Sum (Depreciation) Expense dissections for the Period. |
Period Gain Activity |
Sum Gain dissections for the Period. |
Period Gain Loss Activity |
Sum Gain and Loss dissections for the Period. |
Period Gain Loss Value |
Opening Gain Loss value for the Asset in the Period. |
Period Gain Value |
Opening Gain value for the Asset in the Period. |
Period Loss Activity |
Sum Loss dissections for the Period. |
Period Loss Value |
Opening Loss value for the Asset in the Period. |
Period Realised Activity |
Sum Funds dissections on disposal transactions for the Period. |
Period Realised Value |
Opening realised value for the Asset in the Period. |
Period Recovered Activity |
Sum Recovered dissections for the Period. |
Period Recovered Value |
Opening recovered value for the Asset in the Period. |
Period Revaluation Activity |
Sum Reserve and Writedown dissections for the Period. |
Period Revaluation Value |
Opening revaluation value for the Asset in the Period. |
Record Revision |
Shows the number of times the Asset record has been revised. |
Residual Value |
FA Balance for the report period, falling back to FA Value. |
Serial No |
Asset serial number. |
Useful Life |
FA Balance for the report period, falling back to FA Value. |
Year Addition Activity |
Sum of asset dissections on addition transactions for the Year to date. |
Year Additions Disposals |
Year Addition Activity - Year Disposal Activity. |
Year Adjustment Activity |
Sum of Adjustment dissections for the Year to date. |
Year Asset Activity |
Sum of Gain and Loss dissections for the Year to date. Sum of asset dissections for the Year to date. |
Year Asset Revaluation Activity |
Sum of asset dissections for revaluation transactions for the Year to date. |
Year Depn Revaluation Activity |
Sum of Depreciation dissections for revaluation transactions for the Year to date. |
Year Depreciation Activity |
Sum of Depreciation (balance sheet) dissections for the Year to date. |
Year Disposal Activity |
Sum of Asset, Depreciation and Expense dissections on disposal transactions for the Year to date. |
Year Expense Activity |
Sum (Depreciation) Expense dissections for the Year to date. |
Year Gain Loss Activity |
Sum Gain and Loss dissections for the Year to date. |
Year Realised Activity |
Sum Funds dissections on disposal transactions for the Year to date. |
Year Recovered Activity |
Sum Recovered dissections for the Year to date. |
Year Revaluation Activity |
Sum Reserve and Writedown dissections for the Year to date. |
The Dissection Types are as follows:
Type |
Maps to |
Adds to |
Asset (A) |
GL Asset account |
Asset activity |
Depreciation (D) |
GL Depreciation Accumulated |
Depreciation activity, Writeback activity (debits only) |
Expense (E) |
GL Depreciation Expense |
Expense activity |
Recovered (C) |
GL Depreciation Recovered |
Recovered activity |
Reserve (R) |
GL Revaluation Reserve |
Revaluation activity |
Writedown (W) |
GL Revaluation Write Down |
Revaluation activity |
Gain (G) |
GL Disposal Gain |
Gain/Loss activity |
Loss (L) |
GL Disposal Loss |
Gain/Loss activity |
Funds (F) |
GL Funds (Asset clearing account) |
Cost to Date activity (Additions only) Realised activity (Disposals only) |
Adjustment (J) |
N/A |
Adjustment activity |