FAM – Fixed asset import file headers

NetSuite Fields TAB Notes Mandatory [M] or Optional [O]   Examples 
External ID MAIN Legacy unique asset number. This will be used as a reference for data importing but will not be shown on the asset record.  O   FAM001 
Asset Name MAIN Name for the asset M Alpha Numeric String Max Size 45 DELL LAPTOP 
Asset Description MAIN Brief description of the asset. O Alpha Numeric String Max Size 46 Series 100 Dell Laptop 
Asset Type MAIN Case sensitive, must match spelling in NS M List List IT 
Asset Lifetime MAIN Expected lifetime of asset, in months [IT-36; Intangible and F&F -60] M Integer Integer 36 
Asset Serial Number MAIN A serial number which may be used to track or identify the asset. O Alpha Numeric String Max Size 46 12345 
Alternate Asset Number MAIN Additional asset reference number O Alpha Numeric String Max Size 46 B809 
Asset Status MAIN The status of the asset: New, Depreciating, Fully Depreciated or Disposed M List List Depreciating 
Asset Original Cost MAIN Original purchase cost of asset; No 1000 separator M Currency Currency 10000 
Depreciation Active MAIN Select whether the asset is active and included in depreciation processing. 
[Inactive depreciation – FALSE; Active depreciation – TRUE] 
M Boolean TRUE/ FALSE TRUE 
Accounting Method MAIN Method used when depreciating this asset M List List Straight Line 
Depreciation Period MAIN Frequency of Depreciation M List List Monthly 
Asset Current cost MAIN Current cost of Asset after any revaluations; No 1000 separator M Currency Currency 5000 
Current NET BOOK VALUE MAIN Current book valuation of the asset = Asset original cost – cumulative depreciation M Currency Currency 4500 
Cumulative Depreciation MAIN Depreciation amount applied to date M Currency Currency  
Subsidiary GENERAL Case sensitive; must match spelling in NetSuite; include hierarchy; Format  (PARENT<SPACE>:<SPACE>CHILD) M if One World List List Acsia Technologies Pvt Ltd 
Currency GENERAL The currency the asset cost was originally expressed in M if One World List List INR 
Department GENERAL Case sensitive, must match spelling in NS, include ID number if auto-generated numbers enabled, include hierarchy (format (PARENT<SPACE>:<SPACE>CHILD) M if required on Journal entry List List Finance 
Class GENERAL Case sensitive, must match spelling in NS, include ID number if auto-generated numbers enabled, include hierarchy (format (PARENT<SPACE>:<SPACE>CHILD) M if required on Journal entry List List Mortgages 
Financial Year Start GENERAL First month of Financial Year  List List April 
Physical Location GENERAL Free-text field O Alpha Numeric String Max Size 45 Manager’s cabin 
Purchase Date GENERAL Date of purchase of asset, use preferred date format in NetSuite M Date DD/MM/YYYY 12/1/2022 
Depreciation Rules GENERAL Indicates whether the asset is depreciated in the same period as it is first made active (acquisition) or in the final period of its lifetime (disposal). 
The ‘Pro-rata’ option will depreciate in proportion to a partial month in both the period of acquisition and of disposal, based upon a standardised 30 day month. 
Acquisition rules [ depreciation for the full month of acquisition] 
M List List Acquisition 
Depreciation Start Date GENERAL Date asset depreciation will start. For example, an asset may be purchased but not received or put into service until a couple of months later. Use preferred date format in NS M Date DD/MM/YYYY 11/30/2022 
Depreciation End Date XXXX GENERAL The date depreciation of the asset is expected to finish. This defaults to the asset’s depreciation start date plus the useful lifetime. 
Depreciation end date can be calculated by NS so this field can be left blank. 
However, if Depreciation Rule is set to Disposal, this should be filled up. 
O Date DD/MM/YYYY 11/30/2025 
Prior year NBV GENERAL Previous year net book value at the beginning – Previous year depreciation O Currency Currency  
Last Depreciation Date GENERAL Date of the most recent depreciation of this asset. Use preferred date format set in NS. M Date DD/MM/YYYY 11/28/2022 
Last Depreciation Period xxx GENERAL Period number (within the lifetime of the asset) in which the asset was most recently depreciated. Use preferred date format in NS M Integer Integer 23 
Last Depreciation Amount GENERAL Last charged depreciation amount O Currency Currency  
Revision rules GENERAL Controls how revisions (revaluation) affect the asset. When ‘Current Period’ is selected, the depreciation of the asset to date is recalculated using the revised values, and the difference between the calculated depreciation and the previously posted depreciation is entered in the current period. When ‘Remaining Life’ is selected, the revision only applies to the asset from this point forward, so only affects future depreciation calculations. Default set by asset type. M List List Remaining Life 
Include in Reports GENERAL Indicates whether the asset should be included in all reports. 
By default, all assets are included in the report –  
M Boolean TRUE/ FALSE TRUE/FALSE 
Annual method entry GENERAL Select when annual depreciations are posted. 
– Anniversary (that is, based on depreciation start date) 
– Fiscal Year (that is, based on last day of fiscal year) 
O List List  
Supplier GENERAL The company the asset was purchased from O List List  
Custodian GENERAL The employee responsible for the asset O List List  
ASSET ACCOUNT ACCOUNTS The main asset cost account (balance-sheet) M List List IT Equipment 
DEPRECIATION ACCOUNT ACCOUNTS The account tracking the accumulated depreciation (balance-sheet) M List List IT Equipment Accumulated Depreciation 
DEPRECIATION CHARGE ACCOUNT ACCOUNTS The expense account for depreciation charges (period depreciation amount) M List List IT Equipment Depreciation Expense 
WRITE OFF ACCOUNT ACCOUNTS Account for asset write-off expense M List List IT Equipment 
WRITE DOWN ACCOUNT ACCOUNTS Account for asset write-down expense M List List IT Equipment 
DISPOSAL COST ACCOUNT ACCOUNTS Account for asset disposal (sale) expenses M List List  
Insurance company INSURANCE The insurance company that this asset is insured with If Insured List List  
Insurance Policy number INSURANCE The policy number of the insurance policy that covers this asset. If Insured Alpha Numeric String Max Size 46  
Policy start date INSURANCE The start date of the insurance policy. If Insured Date DD/ MM/ YYYY  
Policy End date INSURANCE The end date of the insurance policy. If Insured Date DD/MM/YYYY  
Insurance value INSURANCE The value that the asset has been insured for. If Insured Integer Integer  
Payment frequency INSURANCE The insurance policy payment frequency in months. If Insured Integer Integer  
Payment Amount INSURANCE The periodic payment amount for the insurance policy. If Insured Currency Currency  
Quantity MAINTENANCE Quantity of Asset O Integer Integer 1 
Quantity disposed  MAINTENANCE Quantity of assets disposed off O Integer Integer  

Leave a comment

Your email address will not be published. Required fields are marked *