Fixed Asset Management
Fixed Asset Management
Fixed Asset Management
Guide
Copyright NetSuite, Inc. 2012 All rights reserved.
Fixed Asset Management Guide
This document is the property of NetSuite, Inc., and may not be reproduced in whole or in part without
prior written approval of NetSuite, Inc.
Trademarks
The following marks are registered trademarks or service marks of NetSuite, Inc. in the United States and
other countries.
NETSUITE
The "N" in NetSuite Logo
SUITESCRIPT
SUITEFLEX
ONE SYSTEM. NO LIMITS.
PREMIER PAYROLL SERVICE
OpenAir is a trademark of OpenAir Inc.
Other trademarks and service marks used or referenced in this document are the property of their
respective owners and are hereby acknowledged.
Contents
The Fixed Assets Management module automatically updates your account whenever bug
fixes, new features, and other improvements in the bundle become available.
For more information, see:
Fixed Asset Management Overview
Installing the Fixed Assets Management Bundle 14052
Updating the Fixed Assets Management Bundle
After installing the NetSuite Fixed Asset Management Module, you need to complete the
following additional setup tasks:
Making the Fixed Assets Tab Available to Custom Roles
Setting Fixed Asset Management Permission Levels
System Setup (Fixed Assets > Setup > System Setup) - See Setting Up the Fixed Asset
Management System
Defining accounts to be used - See General Ledger Accounts for Fixed Asset
Management
Setting Up Asset Transfer Accounts (Fixed Assets > Setup > Asset Transfer Accounts) -
See Asset Transfer Accounts
Setting Up Depreciation Methods (Fixed Assets > Setup > Depreciation Methods) -
See Depreciation Methods
Setting Up Alternate Methods (Fixed Assets > Setup > Alternate Methods) - See
Alternate Methods (Tax Depreciation Methods)
Creating Asset Types (Fixed Assets > Setup > Asset Types) - See Asset Types.
To migrate fixed asset data from your previous system to NetSuite, see Creating Mid-life Assets
by Importing CSV Records.
To learn how you can create and update asset records, read the following topics:
Updating Fixed Asset Management Records
Manually Creating Asset Records
Creating Asset Records from Transactions
To learn how to manage depreciation, read the following topics in Managing Assets:
Asset Depreciation
Asset Disposal by Sale or Write-Off
Partial Disposal of an Asset
Revaluation of an Asset
Asset Split
To use saved searches and reporting features for fixed assets, read the following topics:
Fixed Asset Saved Searches
Asset Reports
To understand fixed assset background processing and error messages, see Background
Processing of Fixed Assets.
You can either set the permission within each custom record or add the Custom Record Entries
permission to a role. See Setting Permissions for a Record in the Help Center for more
information.
Record Permissions for Fixed Asset Management
Subtab Permission Level Notes
Transaction Make Journal Entry Full Processes such as Depreciation, Revaluation
and Disposal run with client user permissions
and need to create Journals
Transaction Bill View
Transaction Find Transaction Full
Transaction Invoice Full
Custom Alternate Depreciation Full
Custom Default Alternate Depreciation Full
Custom FAM - Alternate Depreciation Full
Custom FAM - Alternate Methods Full
Custom FAM - Asset Full
Custom FAM - Asset Proposal Full
Custom FAM - Asset Transfer Accounts Full
Custom FAM - Asset Type Full
Custom FAM - Asset Usage Full
Custom FAM - Depreciation History Full
Custom FAM - Depreciation Method Full
Custom FAM - Expense/Income Full
Custom FAM - Last Proposal Dates Full
Custom FAM - Lifetimes Full
Custom FAM - Repair & Maint Category Full
Custom FAM - Repair & Maint Sub A Full
Custom FAM - Repair & Maint Sub B Full
Custom FAM - System Setup Full
Custom BG - Process Instance Full
Custom BG - Process Log Full
Lists Accounts View
Lists Classes View
Lists Currency View
Lists Customers View
Lists Departments View
Lists Documents and Files View
Important: If this box is checked and the Run Server SuiteScript and Trigger
Workflows (Setup > Import/Export > CSV Import Preferences) box is also checked,
then information such as Cumulative Depreciation, Last Depreciation Date, and Last
Depreciation Period will be auto-populated with default values of 0 even if true
amounts are included in the import file.
Take note of the following rules:
If both Run Server SuiteScript and Trigger Workflows (Setup > Import/Export >
CSV Import Preferences) and Run Server Scripts on CSV Import (Fixed Assets >
Setup > System Setup) are checked, then values from the CSV will be overridden
with default values of 0 (such as Cumulative Depreciation, Last Depreciation Date,
and Last Depreciation Period)
If Run Server SuiteScript and Trigger Workflows (Setup > Import/Export > CSV
Import Preferences) is checked and Run Server Scripts on CSV Import (Fixed
Assets > Setup > System Setup) is unchecked, then values from the CSV will be
imported.
If Run Server SuiteScript and Trigger Workflows (Setup > Import/Export > CSV
Import Preferences) is unchecked, then values from the CSV will be imported,
regardless of whether Run Server Scripts on CSV Import (Fixed Assets > Setup >
System Setup) is checked or unchecked.
3. To transfer the entire asset (dispose under old field value and post current values
under the new field value), check any of the following boxes. Clear the check boxes to
affect future transaction only.
Post on Location Change: If assets will be transferred on location change, check
this box.
Post on Class Change: If assets will be transferred on class change, check this box.
Post on Department Change: If assets will be transferred on department change,
check this box.
Note: There is no Subsidiaries option because changing the subsidiary will always
transfer the asset and generate postings. For more information, see Asset Transfer
Accounts.
4. Choose a posting option when AR and AP are locked:
Post to Next Open Period if AP is Locked: Check this box to allow posting to the
next open period if AP is locked. Clear this box to allow posting to the current
period even if AP is locked.
Post to Next Open Period if AR is Locked: Check this box to allow posting to the
next open period if AR is locked. Clear this box to allow posting to the current
period even if AR is locked.
5. Choose a Summarize Journals By option:
None: Create one journal entry per asset per period.
Parent: Roll up values of sub-assets to parent and create one journal entry to
include parent and child values per period.
Sub-Category: Roll up values to sub-category and create one journal entry per
sub-category per period. This option can only be selected if Repair & Maintenance
Categories and Repair & Maintenance Subcategories have been implemented.
Asset Type: Roll up values by asset type.
6. Allow Future-dated Depreciation: Check this box to permit depreciation of assets up
to a depreciation period date beyond that of the current period. Clear the check box to
depreciate assets to the current period only.
7. Constrain Alternative Asset Life:
If this box is checked, then on the Tax Methods subtab of an Asset record, when
you add an Alternate Depreciation record with a lifetime greater than the lifetime
of the asset, a warning message appears when you click Save. Click OK to continue.
The system will not save the Alternate Depreciation record. Note that for annual
depreciation, the lifetime is indicated in years but the system multiplies this value
by 12 to obtain an equivalent lifetime in months.
If this box is not checked, then on the Tax Methods subtab of an Asset record,
when you add an Alternate Depreciation method with a lifetime greater than the
lifetime of the asset, a warning message appears when you click Save. Click OK to
continue and the system saves the asset record.
8. Write down using Depreciation Account: Check this box to post write-down amount
to depreciation account. Clear the check box to post write-down amount to the asset
account.
9. Integer (0 d.p.) Currencies: Enter the currency code of currencies that do not have a
decimal value. Separate multiple currency codes with a comma.
10. Restrict Ability to Reject Proposals: If this option is checked, the Reject Proposals
button will only be displayed on the Asset Proposal screen when accessed by users in
the Administrator role.
11. Folder to use for reporting (internal id): Enter the internal ID of the Fixed Asset
Register Reports folder in the File Cabinet where reports (Fixed Assets > Reports) are
saved.
To see the internal ID of the Fixed Asset Register Reports folder in your NetSuite
account:
a. Go to Documents > Files > File Cabinet.
b. Click SuiteBundles.
c. Click Bundle 14052.
d. Click the src folder.
Note: To display internal IDs, check the Show Internal IDs box under the General
subtab at Home > Set Preferences.
12. Asset Disposal Invoice Form (internal id): Enter the Internal ID of the preferred
Invoice form to be used to create the Sales Invoice record when disposing an asset by
Sale. If this field is left blank, the default preferred form will be used as the Invoice
form.
Note: The Features Subtab displays a list of enabled features and cannot be edited.
After completing this System Setup page, perform additional setup tasks:
Fixed Assets > Setup > System Setup - See Setting Up the Fixed Asset Management
System.
Define accounts to be used - See General Ledger Accounts for Fixed Asset
Management
Fixed Assets > Setup > Asset Transfer Accounts - See Asset Transfer Accounts.
Fixed Assets > Setup > Depreciation Methods - See Depreciation Methods.
Fixed Assets > Setup > Alternate Methods - See Alternate Methods (Tax Depreciation
Methods).
Fixed Assets > Setup > Asset Types - See Asset Types.
To migrate fixed asset data from your previous system to NetSuite, see Creating Mid-life Assets
by Importing CSV Records.
4. Click Save.
To verify successful account definition in Asset Type and Asset records:
1. Go to Fixed Assets > Setup > Asset Types > New.
2. On the Accounts subtab, verify that the account you defined is available in the
dropdown menu of the following fields (if applicable to the account you defined):
Asset Type Asset Account
Asset Type Depreciation Account
Asset Type Depreciation Charge Account
2. Select the originating subsidiary for this intercompany relationship, i.e. the from
subsidiary when transferring an asset from A to B.
3. Select the destination subsidiary for this intercompany relationship, i.e. the to
subsidiary when transferring an asset from A to B.
4. Select the transfer account for the originating subsidiary of this intercompany
relationship, i.e. the from subsidiary when transferring an asset from A to B.
5. Select the transfer account for the destination subsidiary of this intercompany
relationship, i.e. the to subsidiary when transferring an asset from A to B.
Depreciation Methods
In the Fixed Asset Management Module, each asset must be assigned a depreciation method in
order for NetSuite to calculate the assets depreciation. Depreciation methods can be linked,
which means that an asset can depreciate using one method for the first part of its lifetime, and
then switch to a different method for the remaining lifetime.
The Fixed Asset Management Module enables you to maintain separate book depreciation and
tax depreciation calculations. Book (accounting) depreciation of fixed assets is linked to
journal postings and transactions in NetSuite. You can use any of the preconfigured
depreciation methods or create a new depreciation method.
For more information, refer to the following topics:
Preconfigured Depreciation Methods
Creating a New Depreciation Method
Depreciation Formula
For information on creating and using tax depreciation methods, see Alternate Methods (Tax
Depreciation Methods).
Fixed Declining
Straight Line
Straight Line Remaining
Sum of Years/Straight Line
Sum of Years Digits
Zero Depreciation
Some of these methods are described in more detail here:
UnitsofActivityDepreciation
PerUnitDepreciation
Cost $90,000
Year1 110,000 $0.20 = $22,000 $22,000 68,000
Year2 70,000 0.20 = 14,000 36,000 54,000
Year3 90,000 0.20 = 18,000 54,000 36,000
Year4 80,000 0.20 = 16,000 70,000 20,000
Year5 50,000 0.20 = 10,000 80,000 10,000
benefit from the use of the asset. Many assets are most useful when they are new. One popular
accelerated method is the fixed declining method.
For example, a business has an asset with $1,000 original cost, $100 salvage value, and five years
(60 months) of useful life. The following table illustrates the fixed declining method of
depreciation. Book Value at the beginning of the first year of depreciation is the Original Cost
of the asset. At any time Book Value equals Original Cost minus Accumulated Depreciation.
Book Value = Original Cost - Accumulated Depreciation
The asset is depreciated until the Book Value equals Salvage Value, or Scrap Value.
Depreciation Cumulative
BookValue Period
Expense Depreciation
$1,000.00 0 0 0
$962.35 $37.65 $37.65 1
$926.12 $36.23 $73.88 2
$891.25 $34.87 $108.75 3
$857.69 $33.56 $142.31 4
$825.40 $32.29 $174.60 5
Total
BookValue Depreciation Depreciation Accumulated BookValueEndof
Depreciable
Beg.ofYear Rate Expense Depreciation Year
Cost
$1,000
$900 5/15 $300($900*5/15) $300 $700
(OriginalCost)
$700 $900 4/15 $240($900*4/15) $540 $460
underlining to show how the terms are grouped with the operators so that it is easily
seen if extra parentheses are required to change the evaluation order.
8. Accrual Convention
Note: This field is not yet being used in the Fixed Asset Management module.
Depreciation Formula
In the Fixed Asset Management Module, Each depreciation method consists of a formula that
describes how the amount of monthly or annual depreciation is calculated.
Important: For depreciation periods, only monthly is currently supported for the book
(accounting) methods. Monthly and annually are both supported for
alternate (tax depreciation) methods. For information about using tax
methods in the Fixed Asset Management module, see Alternate Methods
(Tax Depreciation Methods).
The Depreciation Method page includes a list of available operators and constants that you can
use:
^ (to the power of, i.e., 5^2 = 5 squared)
()*/+
any number with decimals (e.e., 12345.67)
~ (maximum of two values, i.e., 2~5 = 5)
Original Asset Cost (OC) the original cost of the asset, usually purchase price
Current Asset Cost (CC) the current cost of the asset. This will typically be the same
as original cost but provides an additional cost value to track and use where the cost
may vary from the original cost. Write downs affect this value.
Net Book Value (NB) the current depreciated value of the asset
Residual Value (RV) the minimum value the asset will be reduced to, usually zero
unless a residual value has been configured against the asset
Asset Lifetime (AL) the number of periods an asset will be depreciated for (asset
effective life for tax)
Current Period or Age (CP) the current age of the asset
Total Depreciation Amount (TD) the total amount of depreciation applied to the
asset
Current Usage (CU) the current recorded usage of the asset
Lifetime Usage (LU) the total usage lifetime configured against the asset
Last Depreciation Amount (LD) the last depreciation amount
Days held in current period (DH) the number of days between the asset acquisition
date or start date of the current period (whichever comes later) and the end of life
(disposal) date or the end of the current period (whichever comes earlier)
Prior year net book value (PB) the closing net book value at the end of the prior
financial year as stored on the asset record. The start and end of the year for the
method is determined by the Financial Year Start field on the Alternate Method record.
The Prior Year NBV is updated when the month being depreciated for an Alternate
Method (tax method) is the same as the month set as the Financial Year Start. This
captures the NBV value as it was for the financial year that just ended. Financial Year
Start is defined on the Alternate Methods (Tax Depreciation Methods) and on the
FAM - Alternate Depreciation Sublist.
Formula Example: Straight Line Depreciation
Straight line depreciation formula:
(CC-RV)/AL
(Current Asset Cost Residual Value) / Asset Lifetime
Example:
Current Asset Cost: 20,000
Residual Value: 2,000
Asset Lifetime: 60 months
(20,000 2,000) / 60 = 300
As it is a simple straight line depreciation this will be the same depreciation amount
every month.
Formula Example: Maximum of Two Values
The formula also has the ability to carry out two different depreciation calculations and then
select the calculation that returns the highest value to use for the deprecation. To use this
functionality the two different formulae are separated by the ~ character.
For example, the formula for the 150DB method is:
((NB-RV)*(1.5/AL))~((NB-RV)/(AL-CP+1))
Fixed Asset Management will calculate the results of ((NB-RV)*(1.5/AL)) and ((NB-RV)/(AL-
CP+1)) individually and then use the highest amount for the depreciation. The net effect of
this example is that the first formula will return the highest value for the first part of the assets
life before switching to the second.
Month 1
Net book value: 20,000
Residual value: 2,000
Asset lifetime: 60 (5 years)
Current period: 1
((20,000 2,000)*(1.5/60)) = 450
((20,000 2,000)/(60 1 + 1)) = 300
Therefore the first formula (450) is used.
Month 30
Net book value: 10,409
Residual value: 2,000
Asset lifetime: 60 (5 years)
Current period: 30
((10,409 2,000)*(1.5/60)) = 210
((10,409 2,000)/(60 30 + 1)) = 271
Now the second formula (271) will be used, and the same amount will be used for the
remainder of the lifetime because the second is a straight line depreciation method. In this
example, the formula switches a third of the way through at about period 20.
Formula Example: Diminishing Value Method for Tax
You can create a diminishing value method to calculate tax depreciation using a reduced rate in
the initial period (year of acquisition). For example:
Formula: (NB)*(DH/365)*(200/AL/12/100)
Depreciation Period: Monthly
Net book value is the depreciated value for tax purposes at the end of the prior period. The
Prior Year Net Book Value is the depreciated value for tax purposes at the end of the prior year.
Depreciation Schedule Report based on the asset type of the asset record. You can also create a
group tax depreciation method that you can use for a pool of assets.
To set up and use tax depreciation methods, refer to the following topics:
Creating Alternate Methods (Tax Depreciation Methods)
Viewing or Editing Alternate Methods (Tax Depreciation Methods)
Adding Tax Depreciation Methods to an Asset
Using Tax Depreciation Methods
2. On the New FAM - Alternate Methods record, provide values for the following fields:
Name: Type a name for this alternate method.
Description: Type a description of this alternate method.
Depreciation Method: Select a depreciation method. You can create a new
depreciation method if it is not available in the dropdown. See Depreciation
Methods.
Convention: Select an averaging convention (None, Half-Year, Mid-Quarter, or
Mid-Month).
Asset Life: Enter a value for the assets lifetime. Units are determined by the value
of the Depreciation Period (monthly or annual) on the referenced Depreciation
Method.
Financial Year Start: Select the first month of the financial year.
Subsidiary: Select the subsidiaries that this alternate method will be applied to. To
select multiple subsidiaries, press and hold the CTRL key while selecting each
subsidiary.
To manually add tax methods to an asset, read the Tax Methods Subtab topic in Manually
Creating Asset Records.
To add alternate depreciation methods to asset records using CSV import, read Adding
Alternate Depreciation Methods Using CSV Import.
Asset Types
Before you create an asset record, you must create asset types. Each asset must be assigned an
asset type, which defaults some of the asset variables (on creation of new assets) and groups
assets in reports and during processing.
General Subtab
On the General subtab, provide values for the following fields:
Asset Type Depreciation Active: Select True to default to active and include in
depreciation processing.
Note: An asset related to a job may be set to automatically start depreciation when
the job is completed.
Asset Type Include in Reports: Check this box to include the asset type in the Asset
Summary Report. By default, all assets are included in the report.
Asset Type Revision Rules: Controls how revisions (revaluation) affect the asset. If
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. If Remaining Life is
selected, the revision only applies to the asset from this point forward, so only affects
future depreciation calculations.
Asset Type Depreciation Rules: Select from:
Acquisition: Asset is depreciated in the same period as it is first made active.
Disposal: Asset is depreciated in the final period of its lifetime.
Pro-rata: Asset will depreciate in proportion to a partial month in both the period
of acquisition and of disposal, based upon a standardised 30-day month. For
example, if depreciation starts on June 18, 2011 and ends on September 17, 2011,
then 13 days worth of depreciation is recorded in the first depreciation period, and
17 days worth of depreciation is recorded in the final depreciation period.
Mid-month: If Depreciation Start Date falls within the first half of the month (for
example, July 11, 2011), then depreciation starts on the same month of the asset
acquisition (July). If Depreciation Start Date falls within second half of the month
(for example, June 18, 2011), then depreciation starts on the month after the
month of asset acquisition (July).
Asset Type Depreciation Period: The frequency at which depreciation of this asset
should take place. Select monthly or annually.
Asset Type Custodian: Select the default employee responsible for assets of this type.
Asset Type Supplier: Enter the vendor that assets of this type are purchased from.
Asset Type Disposal Item: Select a non inventory item (for sale), to be used on the
generated sales invoice, when the asset is disposed of (sold).
Accounts Subtab
On the Accounts subtab, select accounts to post to for this asset type:
Asset Type Asset Account: Select the main asset cost account (balance sheet). When
proposing new assets, this is the account that will be searched for new transactions.
Asset Type Depreciation Account: Select the account tracking the accumulated
depreciation (balance sheet).
Asset Type Depreciation Charge Account: Select the expense account for
depreciation charges (period depreciation amount).
Asset Type Write Off Account: Select the account for asset write-off expense.
Asset Type Write Down Account: Select the account for asset write-down expense.
Asset Type Disposal Cost Account: Select the account for asset disposal (sale)
expenses.
Asset Account Last Checked: Enter a start date for the New Asset Proposal process
which will search for transactions dated on or after this date. This date will be
automatically updated each time asset proposal is run.
Note: In OneWorld accounts with multiple subsidiaries, the date is tracked
independently per subsidiary.
Maintenance Subtab
On the Maintenance subtab, provide maintenance information for this asset type:
Asset Type Inspection: Check this box if inspections are required for assets assigned
to this asset type.
Asset Type Inspection Period: If assets assigned to this asset type require inspection,
enter the inspection interval, in months, of the assets.
Asset Type Warranty: Check this box if assets assigned to this asset type are covered
by a warranty agreement.
Asset Type Warranty Period: If assets assigned to this asset type are under warranty,
enter the warranty period, in months, for the assets.
4. Select an Alternate Method. The available methods for selection include only those
that you have set up in Fixed Assets > Setup > Alternate Methods.
Once you select an Alternate Method, the other fields are automatically populated:
Depreciation Method: Sourced from Alternate Method record.
Convention: Sourced from Alternate Method record.
Lifetimes Subtab
On the Lifetimes subtab, enter location-specific defaults on the asset type to default the Asset
Lifetimes for the main (accounting) method based on the location of the asset.
On Setup > Import/Export > CSV Import Preferences, check the Run Server
SuiteScript and Trigger Workflows box.
Note: This box may be left checked since it is a common setup for companies, but
the Run Server Scripts on CSV Import (Fixed Assets > Setup > System Setup) must
be left unchecked.
Take note of the following rules:
If both Run Server SuiteScript and Trigger Workflows (Setup > Import/Export >
CSV Import Preferences) and Run Server Scripts on CSV Import (Fixed Assets >
Setup > System Setup) are checked, then values from the CSV will be overridden
with default values of 0 (such as Cumulative Depreciation, Last Depreciation Date,
and Last Depreciation Period).
If Run Server SuiteScript and Trigger Workflows (Setup > Import/Export > CSV
Import Preferences) is checked and Run Server Scripts on CSV Import (Fixed
Assets > Setup > System Setup) is unchecked, then values from the CSV will be
imported.
If Run Server SuiteScript and Trigger Workflows (Setup > Import/Export > CSV
Import Preferences) is unchecked, then values from the CSV will be imported,
regardless of whether Run Server Scripts on CSV Import (Fixed Assets > Setup >
System Setup) is checked or unchecked.
Import Asset Record data first, then import Depreciation History data.
When importing data into a OneWorld account, the Subsidiary field is a required field
for FAM - Asset and FAM - Asset Depreciation History imports.
You must map the NetSuite Subsidiary field to a field in your CSV file, or the
import will fail.
CSV file values for subsidiaries should be hierarchical names, in the format
grandparent : parent : child, for example, Consolidated Parent Company : UK
Subsidiary : Euro Subsidiary.
If Multiple Currencies is enabled, the Currency Id field is a required field for FAM
Asset imports. The Currency Id is the internal id of the base currency used by the
subsidiary. To determine the internal id of a currency, go to Lists > Accounting >
Currencies.
If Location, Department or Class are mandatory fields on a journal entry, these fields
are required for FAM Asset imports.
Asset Type is a required field for FAM - Asset and FAM - Asset Depreciation History
imports.
To expose all fields for import, set the preferred form for both FAM Asset and FAM
Asset Depreciation History to the standard form. Go to Setup > Customization >
Record Types and click View. Click Forms tab and check the standard form. To
maintain data integrity, reset the preferred form back to the custom form when
imports are complete.
a. Select Add.
b. Set Custom Form = Standard FAM Asset Form.
c. Click Next.
4. In the Import Assistant Step 4 Field Mapping screen:
After the asset values have been imported for use in the Fixed Asset Management module, two
distinct Depreciation History records will be created, similar to those shown in the following
table for a single company account.
4. On the saved search results, click Export - CSV to export the Search results as a CSV
file:
Example: Original Asset Import CSV File
Next, take the resulting CSV file and use it to create Acquisition and Depreciation records.
Example Step 2: Importing the CSV File as Acquisition and Deprecia-
tion Records
Once you have created the CSV file, you import the CSV file twice:
First, create the Depreciation History - Acquisition record.
Second, create the Depreciation History - Depreciation record.
To import the CSV file for the two types of Depreciation History records:
1. Go to Setup > Import/Export > Import CSV Records.
2. In the Import Assistant Step 1 Scan & Upload CSV File screen:.
a. Choose Import Type = Custom Records.
b. Choose Record Type = FAM - Depreciation History.
c. Select the asset history CSV file.
d. Click Next.
3. In the Import Assistant Step 2 Import Options screen, set Data Handling to Add and
Custom Form to Standard FAM - Depreciation History.
4. Step through the CSV Import Assistant twice. To set default values on fields, see
Setting Default Values.
a. First, step through the CSV Import Assistant to import Depreciation History
records (Acquisition) using the following mapping:
b. Second, step through the CSV Import Assistant again to import as Depreciation
History records (Depreciation) using the following mapping:
The following screenshot shows the Reference Type for Asset being set to Internal ID.
The following screenshot shows the Depreciation Method default value being set to
Accounting Method.
Once mid-life assets have been successfully imported into the NetSuite Fixed Asset
Management system, you can view the asset records at Fixed Assets > Lists > Assets. The
depreciation history of an asset can be viewed on the Depreciation History subtab of the asset
record.
3. Go to Setup > Import/Export > Import CSV Records. In the Import Assistant Step 1 -
Scan & Upload CSV File screen:
a. Select Update.
b. Set Custom Form = Standard FAM - Asset Form.
c. Click Next.
5. In the Import Assistant Step 4 - Field Mapping screen:
a. Map the fields in your CSV file to the NetSuite fields.
Make sure that the Internal ID mapping type is set to Internal ID.
Review the CSV fields and NetSuite fields to verify that all desired fields are
mapped.
b. Click Next.
6. In the Import Assistant Step 5 - Save Mapping and Start Import screen:
a. Enter an Import Map Name and Description.
b. Click Save & Run.
Note: To see the necessary fields to be imported, refer to the FAM - Alternate
Depreciation Sublist.
Important: The Assets NetSuite Internal ID is required to link the updated
information to the correct asset.
e. Click Preview.
f. Click Export - CSV and save the CSV file.
2. On Fixed Assets > Setup > System Setup, make sure that the Run Server Scripts on
CSV Import box is clear (not checked). If this box is left checked then information
such as Cumulative Depreciation, Last Depreciation Date and Last Depreciation
Period will be auto-populated with default values of 0 even if true amounts are
included in the import file. For more information, see Import Guidelines for Mid-life
Assets.
3. Go to Setup > Import/Export > Import CSV Records. In the Import Assistant Step 1 -
Scan & Upload CSV File screen:
a. Select Add.
b. Click Next.
5. In the Import Assistant Step 4 - Field Mapping screen:
a. Map the fields in your CSV file to the NetSuite fields.
Make sure that the Internal ID mapping type is set to Internal ID.
Review the CSV fields and NetSuite fields to verify that all desired fields are
mapped.
b. Click Next.
Example: CSV values
Example: Mapping
6. In the Import Assistant Step 5 - Save Mapping and Start Import screen:
a. Enter an Import Map Name and Description.
b. Click Save & Run.
Currency
Quantity
The following fields are set to read-only once values have been saved in them:
Asset Serial Number
Alternate Asset Number
If those fields are empty, you can still edit them.
Once an asset has been disposed of (either sold or written off), all fields are set to read-only to
prevent manual editing of the asset record by anyone, regardless of the users role.
Depreciation Period: Inline HTML text showing the Depreciation Period of the
selected Accounting Method. For information, see Depreciation Methods.
Asset Lifetime Usage: If the depreciation of the asset is governed by the use made
of that asset (e.g. vehicle mileage), enter a lifetime usage figure that represents the
total number of units available for the asset. When the total usage to date equals
the lifetime usage, the asset will have reached the end of its lifetime.
Current Net Book Value: The current book valuation of the asset.
Cumulative Depreciation: The total depreciation amount applied to date to the
asset.
Asset Status: Defaults to New. Asset Status is automatically set to Disposed once
the asset is disposed of.
Customer Location: Select a customer or create a new customer record.
3. Enter values in the fields on each of the subtabs:
General Subtab
Accounts Subtab
Lease Subtab
Insurance Subtab
Maintenance Subtab
Asset Sale/Disposal Tab
4. Click Save. Once the asset record has been saved, additional subtabs appear. Enter
values on the additional subtabs:
Tax Methods Subtab
Depreciation History Subtab
Asset Usage Subtab
Sub-Assets Subtab
Income/Expense Subtab
5. Click Save.
General Subtab
On the General subtab, provide values for the following fields:
Department: Enter a department for this asset.
Class: Enter a class for this asset.
Location: Enter a location for this asset.
Note: If location, department and/or class are mandatory fields for a journal entry, then
these fields must be set on the asset record. For example, if your System Setup
requires journal entries to be posted on department change, then you must enter a
department on the asset record. For more information, see Setting Up the Fixed
Asset Management System.
Subsidiary: If a you are using a multi-subsidiary account, select the subsidiary for this
asset.
Note: For information about transfering assets between subsidiaries, see Asset
Transfer Accounts.
Currency Id: Enter the Internal Id of the asset currency. The Currency Id is the
internal id of the base currency used by the subsidiary. To determine the internal id of
a currency, go to Lists > Accounting > Currencies.
Custodian: Select the employee responsible for the asset. The Assets subtab on the
Employee record displays a list of assets that the employee is custodian of.
Physical Location: Enter where the asset is normally located.
Include In Reports: Check to include asset in the Asset Summary Report. By default,
all assets are included in the report.
Purchase Date: Enter the date of purchase of the asset.
Depreciation Start Date: Enter the date that the asset depreciation will start. For
example, an asset may be purchased but not received or put into service until a couple
of months later.
Depreciation End Date: Enter the date that the depreciation of the asset is expected to
finish. This defaults to the asset's depreciation start date plus the useful lifetime.
Last Depreciation Period: Enter the period number (within the lifetime of the asset)
in which the asset was most recently depreciated.
Last Depreciation Amount: Enter the value of the most recent depreciation of this
asset.
Last Depreciation Date: Select the date of the most recent depreciation of this asset.
Target Depreciation Date: Enter the next depreciation date as part of the depreciation
process
Depreciation Active: Select whether the asset is active and included in depreciation
processing. An asset related to a job may be set to automatically start depreciation
when the job is completed. Default set by asset type.
Acquisition Status: Indicates whether the asset acquisition has been recorded in the
deprecation history.
Depreciation Rules: Select from the following values:
Acquisition: Asset is depreciated in the same period as it is first made active.
Accounts Subtab
The Accounts subtab lists the ledger accounts that will be used when posting asset transactions.
These accounts are set by default when the asset type for this asset is selected, but you can edit
the accounts here.
Lease Subtab
Use the Lease subtab to enter details of lease agreements for the asset.
Insurance Subtab
Use the Insurance subtab to enter details of insurance policies and claims taken out or made for
this asset. Policy dates can be recorded here.
Insurance Company: Select the insurance company that this asset is insured with.
Insurance Policy Number: Enter the policy number of the insurance policy covering
this asset.
Policy Start Date: Enter the insurance policy start date.
Maintenance Subtab
Use the Maintenance subtab to enter details of any maintenance or warranty schedules
applicable to this asset.
The Tax Methods subtab shows the FAM - Alternate Depreciation sublist and the Alternate
Depreciation History sublist:
FAM - Alternate Depreciation Sublist
The FAM - Alternate Depreciation sublist in the Tax Methods subtab is where you can view
each alternate method defined on the asset record, and where you can also add more alternate
methods.
3. Select values for the fields. Most of the fields are already automatically populated.
Note: If the Override Flag is checked in the Alternate Method record (Fixed Assets > Setup
> Alternate Methods), the Depreciation Method, Convention, Asset Lifetime,
Financial Year Start, and Period Convention fields are editable when this tax
method is added to an asset record.
Alternate Method: Select a tax method name from the dropdown, or click New to
open a New FAM - Alternate Methods record and create a tax method (See
Creating Alternate Methods (Tax Depreciation Methods).
Depreciation Method: This defaults to the depreciation method defined in the
selected Alternate Method.
Convention: Sourced from Alternate Method record.
Asset Life: Sourced from Alternate Method record.
Residual Value: Sourced from Asset record.
Cumulative Depreciation: Defaults to zero.
Last Depreciation Amount: Defaults to zero.
Book Value: Sourced from the Asset Current Cost.
Forecast Amount: Defaults to zero.
Prior Year NBV: Sourced from the Asset Original Cost on the Asset record.
The Prior Year Net Book Value is the assets net book value for the selected tax
method at the end of the prior financial year. The start and end of the year for the
method is determined by the Financial Year Start field on the Alternate Method
record. The Prior Year NBV is updated when the month being depreciated for an
Alternate Method (tax method) is the same as the month set as the Financial Year
Start. This captures the NBV value as it was for the financial year that just ended.
Financial Year Start: Sourced from Alternate Method record.
Subsidiary: Sourced from Asset record.
Period Convention: Sourced from Alternate Method record.
Depreciation Period: Sourced from Depreciation Method record.
Group Depreciation: Sourced from Alternate Method record.
Group Master: This box can only be checked if the Group Depreciation box is
checked.
Original Cost: Sourced from Asset record.
Current Cost: Sourced from Asset record.
4. Click Add to add the alternate method to the asset. You can add as many tax methods
as needed.
5. Check the Store History box if you want to store depreciation history records.
Otherwise, clear the box.
Important: Asset depreciation performance will be affected if the Store History
box is checked.
6. Click Save.
Disposal Date: The date that the asset was disposed of, by sale or write-off
Disposal Type: The disposal type to indicate whether the asset was sold or written off
Disposal Item: The sales item used on the sales invoice generated when the asset was
sold
Sub-Assets Subtab
The Sub-Assets subtab is automatically added to the asset record when a new asset record is
saved.Use the Sub-Assets subtab to add child assets to an asset.
To add a sub-asset to an Asset record:
1. Go to View or Edit mode of an asset record that you want to add sub-assets to. This
asset is the parent asset.
2. Click the Sub-Assets subtab.
3. Click New FAM - Asset.
On the New FAM - Asset page, the Parent Asset field displays the name of the parent
asset.
4. Provide values for the fields and subtabs of the new asset record. See Manually
Creating Asset Records.
5. Click Save. The new asset appears on the Sub-Asset subtab of the parent asset record.
The FAM - Asset ID is automatically generated. You can click the sub-assets FAM -
Asset ID to open the record and add or edit information.
6. Repeat steps 3 to 5 to add more sub-assets to the asset.
Income/Expense Subtab
The Income/Expense subtab is automatically added to the asset record when the asset record is
saved. The Income/Expense subtab allows you to see what income you have gained from the
asset or what expenses you have incurred such as fuel or maintenance costs. It shows you the
journal reference for quick access.
Notes Subtab
Use the Notes subtab to add notes related to this asset.
Files Subtab
Use the Files subtab to attach files related to this asset.
Assets created from either page are created using background processes and if there are plenty
of assets to be created this may take some time. Refer to the following topics:
Asset Proposal and Generation
Asset Creation
Multiple Asset Proposal
To monitor the status of the asset creation process, go to Fixed Assets > Transactions >
Creation Status.
4. Click Propose New Assets to manually run a check for new transactions and create
proposals. The system searches for new assets, creates Asset Proposal records for them,
and displays them in a list on the lower part of the screen.
Note: There is no limit to the number of assets that the Fixed Asset Management module
can handle from one journal entry. However, the Asset Proposal page can only
display up to 80 items on the page.
5. Change the asset type and/or subsidiary selection to find more transactions and click
Refresh to redisplay the asset proposal records.
6. On the list of Asset Proposal records, on the lower part of the page, mark or unmark
records as required.
7. Edit proposals if necessary. See Editing Asset Proposals.
8. Click Generate Assets to create new assets from the marked Asset Proposal records.
9. Please note that asset generation is controlled by a scheduled script. To check the status
of the process:
a. Go to Fixed Assets > Fixed Assets Background Processing > Process Instance List.
b. Click View next to the process named Asset Generation.
Editing Asset Proposals
To edit an asset proposal:
1. Go to Fixed Assets > Transactions > Asset Proposal.
2. Propose new assets. For information, see Proposing New Assets and Generating Asset
Records from Proposals.
3. On the Asset Proposal page, click the Edit link of the asset proposal.
4. On the Edit FAM - Asset Proposal page, make your changes to the asset proposal.
5. On the Other Methods subtab, to add an alternate depreciation method to the asset
proposal, click New Alternate Depreciation. Available alternate methods in the
dropdown are filtered by the asset proposals Subsidiary field in the General subtab.
You can click Edit to modify the already defined Alternate Depreciation records.
6. Click Save.
Asset Creation
The Asset Creation feature in the Fixed Asset Management Module allows you to create assets
automatically without the need to propose them first. When you run the Asset Proposal
process, the system automatically creates asset records for all new transactions that have been
posted against the fixed asset general ledger accounts.
The Asset Creation page (Fixed Assets > Transactions > Asset Creation) skips the proposal
stage and simply creates the new assets. Assets that are already proposed will not be processed
by Asset Creation. To create asset records for proposed assets, use the Generate Assets option
(Fixed Assets > Transactions > Asset Proposal). For information, see Asset Proposal and
Generation.
By using Asset Creation, you will not be able to select which transactions to generate asset
records for. In some cases you may want to review, edit, and select the transactions before
creating asset records for them. For example, you may want to create parent-child relationships
between asset proposal records if you want to track them as a single asset. For information, see
Multiple Asset Proposal.
Child Proposal
Managing Assets
Asset Depreciation
Group Tax Depreciation
Asset Disposal by Sale or Write-Off
Partial Disposal of an Asset
Revaluation of an Asset
Asset Split
Asset Depreciation
In the Fixed Asset Management Module, you can run Asset Depreciation to depreciate assets
for the first time or to depreciate an asset following a revision of depreciation method or
period.
Asset depreciation may be performed periodically for a single asset type or several asset types.
This procedure is run to depreciate assets for the next period. The Fixed Asset Management
module will decide which assets require depreciation by checking depreciation start date, last
depreciation period, and depreciation rules. On posting the depreciation values, the module
will create a batch of GL journal entries.
An asset will depreciate each period, set on the depreciation method. An asset will depreciate
for each of its period intervals up to the given date entered on the Depreciate Assets page.
For example, where an asset has a depreciation period of monthly and its last depreciation in
January a depreciation run for June will cause a depreciation to happen for February, March,
April, May as well as for June.
The depreciation process itself is a manually run process. When the Depreciate Assets button is
clicked the system will check to see if there are any new transactions that will impact the asset
account and may require new assets to be generated. This check is done based upon the asset
types andsubsidiaries selected for depreciation.
If potential new assets are found, the depreciation page will display a warning that new assets
may need to be created and require you to confirm that you want to proceed with the
depreciation before creating the new assets. Check the box to proceed with the depreciation
and then re-click the Depreciate Assets button. The warning lists the Asset Types that may have
new assets pending. You can create the new assets first before doing the asset depreciation
process.
6. Click Depreciate Assets. The system displays the Asset Depreciation Status page.
The Fixed Asset Management module calculates the value to be depreciated based on
the depreciation method and period entered. The module will create journal entries
posting to the fixed asset depreciation and expense accounts entered for the assets on
the Accounts tab. A journal entry is created per asset type, per period of depreciation.
Asset Depreciation Status
You can see the status of asset depreciation on the Asset Depreciation Status window. This
window automatically opens after you click Depreciate Assets after running an asset
depreciation from Fixed Assets > Transactions > Asset Depreciation. But you can also access
the Asset Depreciation Status window from Fixed Assets > Transactions > Asset Depreciation
Status.
Current Status can be one of the following:
Queued
In Progress
Failed
Completed
Where do things stand? indicates how many assets have been depreciated.
If the Current Status is Completed, view and verify the results using the Depreciation Monthly
Report saved search at Fixed Assets > Searches > Depreciation Monthly Report.
If the Current Status is Failed or if not all the assets were depreciated, view the Background
Processing Process Instance List at Fixed Assets Background Processing > Process Instance
List. For more information, see Background Processing of Fixed Assets.
3. Click Save. The next step is to define the assets for group tax depreciation.
Define assets for group tax depreciation
1. Go to Fixed Assets > Lists > Assets.
2. Select the asset record to be included in the group depreciation.
3. Click the Tax Methods subtab of the asset record
4. Click New FAM - Alternate Depreciation Method.
5. In the Alternate Method field, select the group tax depreciation method that you
created. Notice that the Group Depreciation box is already checked.
6. Enter the Book Value (NBV).
7. Enter or edit values in the other fields.
8. Click Save.
9. Repeat steps 1 to 8 for as many assets in the same subsidiary until you have defined all
assets that are required in the group. The next step is to create a group master record
for group tax depreciation.
No: To display transactions from Asset Depreciation (Fixed Assets > Transactions >
Asset Depreciation)
All: To display all depreciation history
Sales Tax Code: Select the tax code that applies to this sale.
3. Click Dispose. A sales invoice is created and the asset status is set to Disposed.
To write off an asset:
1. Go to Fixed Assets > Transactions > Asset Disposal.
2. In the Asset Disposal page, enter values in the following fields:
Asset ID/Name. Select the desired asset by name or ID.
Disposal Date: Enter a posting date for disposal.
Disposal Type: Select Write-off.
3. Click Dispose. Writing off an asset sets the book value of the asset to zero.
Revaluation of an Asset
In the Fixed Asset Management Module, you can use the Asset Revaluation feature to write
down or revaluate an asset. A write-down is a form of depreciation that involves a partial write-
off. Writing down the asset allows you to enter a new net book value for the asset and post the
difference to the GL. Revaluation is a procedure that adjusts the true value of the fixed assets
owned.
To revaluate an asset:
1. Go to Fixed Assets > Transactions > Asset Revaluation.
2. Select an Asset ID/Name.
3. Write-down Amount: Enter a write-down amount. This amount is subtracted from
the current net book value.
4. Adjusted Residual Value: Enter the new residual value of the asset.
5. Adjusted Lifetime: Enter the new lifetime of the asset.
6. Adjusted Depreciation Method: Select the new depreciation method to be used to
depreciate this asset.
7. Transaction Reference: Enter a reference to identify the journal entry for this
transaction.
8. Transaction Date: Enter a date for the journal entry for this transaction.
9. Click Process Revaluation. Journal entries are created to post the difference in value.
Asset Split
The Fixed Asset Management Module enables you to split assets that are not yet fully
depreciated, or have not been disposed of, or are not defined as inactive on the asset record.
The quantity field on the asset records Maintenance subtab tracks the number of individual
elements that form the asset. Asset split allows a specified quantity to be separated from the
original asset and create a new asset.
When splitting assets, new values must be provided for cost and depreciation fields. Asset
depreciation will continue to work on each asset as a whole. If different depreciation rules need
to be applied to some of the quantity then that quantity must be split to create a separate asset.
Likewise, if some of the asset quantity will be transferred to a different class, department,
location or subsidiary, the asset quantity must first be split to a separate asset and then moved.
It is not possible to combine assets (e.g. reverse the process of splitting an asset).
To split an asset:
1. Go to Fixed Assets > Transactions > Asset Split.
2. Select an asset to split.
3. Enter quantity to split and <tab> or click Refresh.
Default values for the split are calculated based on the split quantity. These values may
be edited.
Important: The sum of Net Book Value and Depreciation To Date must equal Current
Cost.
4. Click Split to create new split asset and update original asset.
Asset Reports
The Fixed Asset Management Module provides several reports that offer comprehensive
reporting across assets, valuation and depreciation. With these reports, you can report on assets
across locations, subsidiaries, asset types, and more. The following reports are available at
Fixed Assets > Reports:
Asset Register Report
Asset Summary Report
Asset Depreciation Schedule Report
Asset Depreciation Schedule Report (portrait) - an alternative format of the asset
depreciation schedule report, but does not include the Save Results functionality
6. Select a class.
7. Select a period start date
8. Select a period end date.
9. Click Generate Report.
6. Select a class.
7. Select a period start date
8. Select a period end date.
9. Click Generate Report.
4. Check the Save Results box to save the calculated values in the asset records history.
Important: Save Results is used for generating Depreciation Schedule entries for
the lifetime of an asset, and for saving the entries in the asset record. When Save
Results is checked, the system ignores Start Date, End Date, Net Book Value, and
Period Depreciation to ensure that the Depreciation History table always contains a
complete depreciation schedule for the life of the asset. The entered values on the
Start Date, End Date, Net Book Value, and Period Depreciation fields will only be
used for the generated HTML report.
5. Select subsidiaries.
6. To include assets of child subsidiaries, check the Include Children box.
7. Select a class.
8. In the Select field, select one of the following: All Assets, All Assets Except Leased, or
Leased Only
9. Select a Depreciation Method. Book methods and tax methods are available for
selection.
10. Select a start date for the period.
11. Select an end date for the period.
12. Click Generate Report.
13. On the Depreciation Schedule Report Status page, click Refresh to monitor the report
generation progress.
14. When Current Status shows Completed, you can view the generated report by clicking
the link provided on the page. The report is displayed as an HTML page.
15. To view the report after it has been successfully generated:
a. Go to Lists > Search > Saved Searches > New to create a saved search.
b. Click FAM - Depreciation History.
c. Type a name for this new saved search.
d. On the Criteria subtab, click the Standard subtab.
e. On the Filter field, add the following criteria:
Schedule: Set Schedule to Yes.
Asset Type: Select the asset type that you selected when you generated the
report.
Other fields that you want to include in the search criteria, such as Subsidiary,
etc.
f. On the Results subtab:
Scheduled Amount: Set a value or a range of values.
Scheduled NBV: Set a value or a range of values.
Add or remove fields to be displayed in the search results. For example, you
may want to add Asset to display the asset IDs.
Move fields and indicate the sort order.
g. Click Save.
h. Go to Lists > Search > Saved Searches.
i. Click the Results link of the saved search that you just created.
The report shows all assets of the asset type selected for the Depreciation Schedule
report. To view the depreciation schedule for individual assets, you can view an asset
record and click its Depreciation History Subtab.
Period Depreciation