Import template for FAM Depreciation History Record for fully depreciated assets.
Depreciation History records should only be imported after the import of the Fixed assets
If we require each depreciation history transaction to be displayed in depreciation histories in the asset record, we need to import each transaction as an import line.
Alternatively, we can also choose to show the entire depreciation history transaction as a single transaction as shown in the following template.
Note: This is regarding the fully depreciated assets. For the depreciating and new assets, we can precompute depreciation values. However, if the depreciation record prior to the last depreciation date in the asset record at the time of import is to be shown, we need to import DHR in the same manner as fully depreciated assets.
| Import column | Test data |
| DHR ID/DHR Name | DHR-FAM001 |
| Asset External ID | FAM001 |
| Asset Internal ID | 26 |
| Asset Description | Test Asset |
| Asset Type internal ID | 2 |
| Asset Lifetime | 60 |
| Asset Status | Fully Depreciated |
| Asset Original Cost | 30000 |
| Depreciation Active | FALSE |
| Accounting Method | Straight Line |
| Depreciation Period | Monthly |
| Asset Current cost | 30000 |
| Current NET BOOK VALUE | 0 |
| Depreciation Amount | 30000 |
| Subsidiary | Parent Subsidiary |
| Currency | GBP |
| Financial Year Start | June |
| Purchase Date | 31-01-2018 |
| Depreciation Start Date | 31-01-2018 |
| Depreciation Date | 31-12-2022 |
| Last Depreciation Period xxx | 60 |
| Last Depreciation Amount | 500 |
| Revision rules | Current Period |