Guidelines for Importing Fully Depreciated or Disposed Asset Records

When you're importing records for fully depreciated or disposed assets, you must include additional fields and validations. These extra entries ensure that no other depreciation charge is recorded against these assets.

Before you import fully depreciated and disposed assets, review the CSV import file and make the following changes:

Set the Asset Status column to Fully Depreciated or Disposed.
Set the Depreciation Active column to FALSE. This ensures that no depreciation entry is recognized.
Make sure the Last Depreciation Period matches the Last Depreciation Date. The period number (within the asset's lifetime) must match the asset’s most recent depreciation date. For example, if the Depreciation Start Date is July 1, 2021 and the Last Depreciation Date is December 31, 2021, then the Last Depreciation Period should be 6. If the Last Depreciation Period and Last Depreciation Date don't match, an error may occur.
For fully depreciated assets, if there is a Residual Value Percentage, the Current Net Book Value should be equal to the Residual Value. If there is no Residual Value Percentage, the Current Net Book Value should be zero.
For disposed assets, the Current Net Book Value must always be zero.

Use this template as a guide when you prepare the CSV import file for fully depreciated and disposed asset.

To import fully depreciated or disposed fixed asset records, see Importing Fixed Asset Records.

Related Topics