Importing Asset Depreciation History Records

Depreciation History Records (DHRs) capture an asset's depreciation transactions. You must create a DHR for every depreciation entry, which can be monthly, quarterly or annually depending on your timing preference. For mid-life assets already depreciating, import prior period DHRs to show the correct net book value of the asset.

Before importing a depreciation history record, make sure your CSV file includes the following fields:

Field	Description
DHR Name	Enter the depreciation history record name. This field identifies the depreciation period for the DHRs you're importing. You can enter any value for this field. Avoid using a “|” separator in the name. Otherwise, the record won't appear in depreciation searches.
Asset Name	Enter the name of the asset linked to the DHR. This field is a combination of the unique ID and the name assigned to the asset record when it's entered in the system. For example, FAM00001 Chairs.
Subsidiary	Enter the asset's subsidiary. This field is required for FAM depreciation history imports when you're importing data into a OneWorld account.
Quantity	Enter the asset's quantity.
Accounting Book	Enter the associated accounting book. This field is required if the system has more than one accounting book.
Asset Type	Enter the asset type. This field is required for FAM depreciation history imports and must already exist in the system.
Transaction Type	Enter Depreciation as the transaction type.
Transaction Date	Enter the depreciation transaction date.
Transaction Amount	Enter the depreciation transaction amount.
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:

Use the sample files in CSV Templates for Fixed Assets Import Data. To ensure that your CSV files import successfully, 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 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