Importing Fixed Asset Records

Before attempting to import asset data, perform a test import first to verify that your CSV import works without errors. Set up a test CSV file of a few assets and review the formatting to ensure that the data is imported with correct values.

Make sure that your CSV file contains the following fields:

Fields	Description
Name	Enter the name of the asset.
Asset Description	Enter the description of the asset.
Quantity	Enter the quantity of the asset.
Subsidiary	Enter the subsidiary of the asset. This field is required for FAM asset imports when you are importing data into a OneWorld account.
Asset Type	Enter the asset type of the asset. 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 expected lifetime of the asset, 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 purchase cost of the asset.
Asset Current Cost	Enter the purchase cost less any write-down amounts applied to the asset.
Residual Value Percentage	Enter the value of the asset at the end of its lifetime.
Residual Value
Depreciation Start Date	Enter the start date of the asset depreciation.
Last Depreciation Date	Enter the date of the asset’s most recent depreciation. Note: The asset may not depreciate or depreciation period may be skipped if this value is incorrect.
Last Depreciation Period	Enter the period number (within the lifetime of the asset) in which the asset was most recently depreciated. Note: The asset may not depreciate or depreciation period may be skipped if this value is incorrect.
Last Depreciation Amount	Enter the amount of the most recent depreciation of 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.

Fields

Description

Name

Enter the name of the asset.

Asset Description

Enter the description of the asset.

Quantity

Enter the quantity of the asset.

Subsidiary

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

Asset Type

Enter the asset type of the asset. 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 expected lifetime of the asset, 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 purchase cost of the asset.

Asset Current Cost

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

Residual Value Percentage

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

Residual Value

Depreciation Start Date

Enter the start date of the asset depreciation.

Last Depreciation Date

Enter the date of the asset’s most recent depreciation.

Note:

The asset may not depreciate or depreciation period may be skipped if this value is incorrect.

Last Depreciation Period

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

Note:

The asset may not depreciate or depreciation period may be skipped if this value is incorrect.

Last Depreciation Amount

Enter the amount of the most recent depreciation of 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.

Note:

You can use the sample files available in CSV Templates for Fixed Assets Import Data. To ensure that your CSV files are successfully imported, review the following guidelines:

The following video shows you how to import mid-life assets and depreciation history records using the CSV Import Assistant:

To import fixed asset records:

Go to Setup > Import/Export > Import CSV Records.
In the Import Assistant – Scan & Upload CSV File screen, do the following:
1. From the Import Type list, select Custom Records.
2. From the Record Type list, select FAM Asset.
3. Select the asset CSV file.
4. Click Next.
In the Import Assistant – Import Options screen, do the following:
1. Set Data Handling to Add.
2. From the Custom Form list, select Standard FAM Asset Form.
3. Click Next.
In the Import Assistant – Field Mapping screen, do the following:
1. Map the fields in your CSV file to NetSuite fields as follows:
  
  You can add values for other fields, as well. When you are finished, review the CSV and NetSuite fields to verify that all desired fields are mapped.
  
  Note:
  If the NetSuite fields are not listed, then the standard form is not selected as the preferred form. Be sure to select the standard form to show all fields.
2. Click Next.
  
  To set default values and reference types on fields, see Setting Default Values and Reference Types.
In the Import Assistant - Save Mapping and Start Import screen, do the following:
1. Enter an Import Map Name and Description.
2. Click Save & Run.

Important:

When creating asset records through CSV import, default tax methods associated to asset types are also imported. Some fields for the tax methods, however, are not populated. You must perform another import to update the fields with missing values. For more information, see Updating Tax Methods.

To import fixed asset records:

Related Topics