Importing Asset Depreciation History Records

Depreciation History Records (DHRs) recognize the depreciation transaction for an asset. A DHR must be created for every depreciation entry, which can be monthly, quarterly or annually depending on the set timing preference. In the case of mid-life assets that are already depreciating, the DHRs for prior periods must be imported in the system to reflect correct net book value of the assets.

Before importing an asset depreciation history record, make sure your CSV file contains the following fields:

Field	Description
DHR Name	Enter the name of the depreciation history record. This field identifies the depreciation period for the depreciation history records being imported. You can use any value for this field in the CSV file. Avoid using a “|” separator in the name so that the record will not be picked up in the depreciation search.
Asset Name	Enter the name of the asset associated to the DHR. This field is a combination of the unique ID and the name assigned to the asset record once it is entered in the system. For example, FAM00001 Chairs.
Subsidiary	Enter the subsidiary of the asset. This field is required for FAM depreciation history imports when you are importing data into a OneWorld account.
Quantity	Enter the quantity of the asset.
Accounting Book	Enter the associated accounting book. This field is required if there are more than one accounting book in the system.
Asset Type	Enter the asset type of the asset. This field is required for FAM depreciation history imports and must be set up in the system beforehand.
Transaction Type	Enter Depreciation as the transaction type.
Transaction Date	Enter the date of the depreciation transaction.
Transaction Amount	Enter the amount of the depreciation transaction.
Net Book Value (NBV)	Enter the balance as of the transaction.
Depreciation Period	Enter the period number covered by the depreciation transaction.
Prior Year Net Book Value	Enter the asset original cost if the transaction date is within the asset’s acquisition year. Otherwise, enter the end of the year net book value.

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:

• General Guidelines for Importing Fixed Asset Records

• Guidelines for Importing Mid-life Asset Records

• Guidelines for Importing Fully Depreciated or Disposed Asset Records

Click this link to download the CSV template to import a DHR.

To import the CSV file as an asset depreciation history record:

1. Go to Setup > Import/Export > Import CSV Records.

2. 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 Depreciation History.

   3. Select the CSV file of the asset depreciation history that you created.

   4. Click Next.

3. 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 Depreciation History.

4. In the Import Assistant – Field Mapping screen, do the following:

   1. Map the fields in your CSV file to NetSuite fields as follows:

      

   2. Click Next.

      To set default values and reference types on fields, see Setting Default Values and Reference Types.

5. 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.

Related Topics

• Setting Up the Fixed Assets Management System
• Setting CSV Import Preferences
• General Guidelines for Importing Fixed Asset Records
• Guidelines for Importing Mid-life Asset Records
• Guidelines for Importing Fully Depreciated or Disposed Asset Records
• Importing Fixed Asset Records
• Updating Tax Methods
• Importing Tax Method Depreciation History Records
• Setting Default Values and Reference Types

General Notices