Spreadsheet: 857293d1706296446-need-help-understanding-indirect-formula-copy-of-fixed-assets
Sheet: Software

Date of purchase of the asset; use preferred date format in NS | Name for the asset | Brief description of the asset. | Case sensitive, must match spelling in NS | Original (purchase) cost of the asset. No 1000 separator. | Current cost of asset after any revaluations. No 1000 separator. | Depreciation method (formula) to use when depreciating this asset. | Expected lifetime of the asset, in months. |  |  |  | HEADER  The total depreciation amount applied to date to the asset. | HEADER  The current book valuation of the asset. | GENERAL [NAME]  Select the department this asset is associated to. | GENERAL [NAME]  Select the class this asset is associated to. | GENERAL [NAME]  Select the location this asset is associated to. | Yes to include in asset reports. | Asset depreciation start date. An asset may be purchased but not received or put into service until a couple of months later. Use preferred date format in NS | GENERAL [NAME]  The date depreciation of the asset is expected to finish. This defaults to the asset's depreciation start date plus the useful lifetime. | Date of the most recent depreciation of this asset. Use preferred date format set in NS. | Period number (within the asset's lifetime) in which the asset was most recently depreciated. Use preferred date format in NS | The amount of the most recent depreciation of this asset | Depreciating or Fully Depreciated or New | Select whether the asset is active and included in depreciation processing. | Indicates if a depreciation history record for the acquisition has been created. Yes for all mid-life and fully depreciated assets. | 1. Acquisition : Asset is depreciated in the same period as it is first made active. 2. Disposal : Asset is depreciated in the final period of its lifetime. For example, if an asset is depreciating monthly for 12 months, and enters service in mid-July, acquisition rules would depreciate in July through June whilst disposal rules would depreciate in August through July. 3. Pro-rata :  Asset will depreciate in proportion to a partial month in both the period of acquisition and of disposal, based upon a standardised 30 day month. Default set by asset type. 4. Mid-month : Assets with a start before or on the 15th of the month will depreciate in the same period of its lifetime. Assets with a Start Depreciation Date after the 15th will depreciate in the final month of its lifetime. | Controls how revisions (revaluation) affect the asset. When 'Current Period' is selected, the depreciation of the asset to date is recalculated using the revised values, and the difference between the calculated depreciation and the previously posted depreciation is entered in the current period. When 'Remaining Life' is selected, the revision only applies to the asset from this point forward, so only affects future depreciation calculations. Default set by asset type. |  | Which Employee is assigned to the asset
Purchase Date | Name | Asset Description | Asset Type | Asset Original Cost | Asset Current Cost | Accounting Method | Asset Lifetime | [NAME] | Mo Held | MO Remiaing | Cumulative Depreciation | Current Net Book Value | Department | Class | Location | Include in Reports | Depreciation Start Date | Depreciation End Date | Last Depreciation Date | Last Depreciation Period | Last depreciation Amount | Asset Status | Depreciation Active | Acquisition Status | Depreciation Rules | Revision Rules | Supplier | Custodian | Subsidiary
2020-12-31 00:00:00 | MS Office | MS Office | Software | 1250.62 | 1250.62 |  | 36 |  |  |  |  |  |  |  | OR |  | 2020-12-31 00:00:00 | 2023-12-31 00:00:00 | 2023-05-31 00:00:00 | 29 | 34.74 | Depreciating | True | Yes | Acquisition | Remaining Life |  |  | CCI