CSV Fields for Importing Fixed Asset Records

Name

Enter the asset's name.

Asset Description

Enter the asset's description.

Quantity

Enter the asset's quantity.

Subsidiary

Enter the asset's subsidiary. This field is required for FAM asset imports when you're importing data into a OneWorld account.

Asset Type

Enter the asset type. This field is required for FAM asset imports and must be set up in the system beforehand.

Asset Status

Set the asset status to any of the following:

• New

• Depreciating

• Fully Depreciated

• Disposed

Depreciation Active

For new and depreciating assets, set this field to TRUE. For fully depreciated and disposed assets, set this field to FALSE.

Asset Lifetime

Enter the asset's expected lifetime in multiples of the depreciation period. For example, if the depreciation period is Monthly or Annual Depreciation, Monthly Posting, enter the lifetime in months.

Asset Original Cost

Enter the asset's purchase cost.

Asset Current Cost

Enter the purchase cost less any write-down amounts applied to the asset.

Residual Value Percentage

Enter the asset's value at the end of its lifetime.

Residual Value

Depreciation Start Date

Enter the asset depreciation start date.

Last Depreciation Date

Enter the asset’s most recent depreciation date.

Last Depreciation Period

Enter the period number (within the asset's lifetime) in which the asset was most recently depreciated.

Last Depreciation Amount

Enter the most recent depreciation amount for this asset.

Current Net Book Value

Enter the current net book value. The current NBV is calculated as the original cost less the accumulated depreciation and write-down amounts.