Importing Tax Method Depreciation History Records

After updating the missing fields for the tax methods, the tax method DHRs must also be imported into the system to reflect the correct values.

Before importing a tax method DHR, create a CSV file that 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.
Alternate Method	Enter the name of the associated alternate method.
Actual Depreciation Method	Enter the name of the associated depreciation method.

Note:

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

To import the CSV file as a tax 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 tax method 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

Importing Asset Depreciation History Records

Updating Tax Methods

Setting Default Values and Reference Types

General Notices