Fixed assets, also referred to as tangible assets or property, plant, and equipment (PP&E), represent the long-term assets owned by a business or individual. These assets are essential for operations and are not intended for immediate sale. Instead, they are expected to provide value and contribute to revenue generation over an extended period. Fixed assets include items such as land, buildings, machinery, equipment, vehicles, and intangible assets like patents or trademarks.
Fixed assets are recorded on the balance sheet at their historical cost (the original purchase price plus any costs related to acquisition and installation). Over time, these assets are depreciated or amortized, which means their value is gradually reduced to reflect wear and tear, obsolescence, or loss of value over their useful life.
This article covers the necessary steps for setting up fixed assets, guiding users through the following configurations:
- Fixed Asset Configuration
- Fiscal Calendar
- GL Source
- Asset Books
- Asset Classes
- Major and Minor Asset Groups (Asset Major)
- Asset Book Defaults
- Fixed Asset Issue Types
- Asset Import Formats
Fixed Assets Configuration
- From the Main Menu, search for and click Fixed Assets Configuration.
- In the General tab, select the appropriate settings:
- Depreciation Allocation –
- If using a fiscal calendar that corresponds to calendar months (for instance, each period start date corresponds to the first day of a month and each period end date corresponds to the end date of a month) AND you wish to allocate annual depreciation evenly throughout the year, then choose “Periodic”.
- If your fiscal calendar start and end dates do not correspond to the start and end dates of a calendar month (for example, Fiscal calendar is based on a 4-4-5 cycle) OR you wish to allocate annual depreciation based on the number of days in a fiscal period, choose “Daily”.
- If no value is entered, depreciation will be allocated based on the even annual depreciation throughout the year according to the fiscal calendar months ("Periodic").
- Create Depreciation Journal Entries by Asset – Define the level of detail for creating depreciation journal entries in the General Ledger module.
- To create journal entries at a detailed level by fixed asset, check this box. This will result in all accumulated depreciation transactions being grouped by asset and GL account.
- If this volume of transactions is not desirable, uncheck this box. This will group the depreciation entries by Major and Minor groups within the GL account.
- Default Asset Type – Used to define the default type when adding a new asset. Valid values are: Capitalized, In Progress, or Expensed.
- Depreciation Allocation –
- In the Access Privileges tab, review the privileges to determine which users or roles can perform each task.
- Click OK.
Fiscal Calendar
Create Fiscal Periods for Fixed Assets to record asset transactions. This can be done for an existing Fiscal Year or when adding a new year.
Add Fixed Assets periods to an existing Fiscal Year
- From the Main Menu, search for and click Fiscal Calendar.
- Right-click the existing Fiscal Period and click Edit.
- Click Add. The Add Fiscal Period window opens.
- In Module, choose Fixed Assets.
- Verify the year and enter the period number and Start and End Dates for the period.
- In Status, choose Open.
- Click OK.
- Repeat for each period to be added to the year.
Add Fixed Assets to a New Fiscal Year.
- From the Main Menu, search for and click Fiscal Calendar.
- Click Add to add a new Fiscal Year. The Add Fiscal Period window opens.
- Verify the Year, Type, Start Date, and the number of periods to be created.
- Note: The type will default the start and end dates for the periods. Monthly will set calendar dates, the remaining options will create periods with the relevant number of weeks (eg. 4,4,5) based on the Start Date for the year.
- Check the boxes for the Modules to include in the new Fiscal Year, including Fixed Assets.
- Click OK.
GL Source
- From the Main Menu, search for and click GL Sources.
- In the source column, look for "FX" code.
- If the source code "FX" exists under the Source column, no further action is required.
- If the source code “FX” does not exist, continue with the following steps:
- Click Add. The Add GL Source window opens.
- In the Source field add FX.
- In the Description field add Fixed Assets.
- Click OK.
Asset Books
An Asset Book is used to record the values of assets. Only one Asset Book with a code of “000” can be used to record depreciation and to create journal entries. Other uses of Asset Books could be to record a fair market or insurance value of assets.
To add an Asset Book:
- From the Main Menu, search for and click Asset Book.
- Click Add. The Add Asset Book window opens.
- For a GL Book, enter the code “000”. Other books can be added with any 3-digit alphanumeric code.
- Enter a description. The best practice is to enter “General Ledger” for the GL Book.
- Click OK.
Asset Classes
Asset Classes are an optional, customizable field used to classify assets for reporting purposes. This master table can be customized to your organization’s requirements.
To add an Asset Class:
- From the Main Menu, search for and click Asset Classes.
- Click Add. The Add Asset Class window opens.
- Enter the details about the asset class:
- Class – Enter a 6-digit (or up to 6 digits) alphanumeric code for this class.
- Description – Enter the description for the class.
- Status – Choose Active. To alter a Class so it is no longer selectable, choose Inactive.
- Click OK.
Major and Minor Asset Groups
Major Asset Groups and Minor Asset Groups have a dual purpose. They are used to group like assets together for reporting purposes and to determine the GL distribution used when generating journal entries on various asset transactions. Each Major Group has a tab to enter GL distribution for the Major Group and a tab to display any GL distributions already entered for associated Minor Groups and vice-versa. This is a parent/child relationship and any GL distribution defined at a Minor Group will override the GL distribution set at the Major Group.
Add a Major Asset Group
To add a Major Asset Group and define the GL distribution:
- From the Main Menu, search for and click Major Asset Groups.
- Click Add. The Add Major Asset Group window opens.
- Enter the details about the major asset groups:
- Description – Enter a description for the group.
- Prefix – Enter the prefix to be added before the asset number for new assets created with this Major. For example, use EQ for Equipment items. This is not a required field.
- Status – Choose the status of Active. To prevent an existing Major from being selected in the future, set the status to Inactive. Majors can be deleted if entered in error and not in use.
- Code – Enter a 6-digit (up to 6 digits) alphanumeric code to identify the Major.
- If GL distribution is to be defined at the Minor only, click OK to save and exit. If distribution is to be set at the Major, continue with these instructions.
- On the GL Distributions for Major Groups tab, click Insert Row. For existing Groups, right-click on the existing row and select Insert Row.
- If using complex GL distribution, use the Sequence to define the order to evaluate rows. The best practice is to have one combination of GL Accounts for each transaction type.
- Choose the Type of transaction from the dropdown. Each transaction type will have a debit (Dr) and credit (Cr) type available to define both sides of the journal entry.
- Choose the GL Account in the GL Account Name. This can be typed into the GL Account field if you know the account number.
- Click OK when each transaction type has been added with its appropriate GL Account.
Add a Minor Asset Group
To add a Minor Asset Group and define the GL distribution:
- From the Main Menu, search for and click Minor Asset Groups.
- Click Add. The Add Minor Asset Groups window opens.
- Enter a description for the group.
- Choose the Major Group, this Minor is to be related to.
- Choose the Status of Active. To prevent an existing Minor from being selected in the future, set the status to Inactive. Minors can be deleted if entered in error and not in use.
- Enter a 6-digit (up to 6 digits) alphanumeric code to identify the Major.
- Choose the Issue Type (or group of user-defined fields) to be associated with assets in this Minor Group.
- If GL distribution is to be defined at the Major only, click OK to save and exit. If distribution is to be set at the Minor, continue with these instructions.
- On the GL Distributions for Minor Groups tab, click Insert Row. For existing Groups, right-click on the existing row and select Insert Row.
- If using complex GL distribution, use the Sequence to define the order to evaluate rows. The best practice is to have one combination of GL Accounts for each transaction type.
- Choose the Type of transaction from the dropdown. Each transaction type will have a debit (Dr) and credit (Cr) type available to define both sides of the journal entry.
- Choose the GL Account in the GL Account Name. This can be typed into the GL Account field if you know the account number.
- Click OK when each transaction type has been added with its appropriate GL Account.
Distribution Types
Following is a list of the distribution types and their usage:
- Dr Asset Cost: The Asset GL Account records the Asset Cost.
- Cr Asset Cost Clearing: Used when adding Assets. GL Transactions entered into any account defined in Cr Asset Cost Clearing can be used to Import Assets from Accounts Payable.
- Dr Depreciation Expense: The expense accounts for monthly depreciation.
- Cr Accumulated Depreciation: The “negative Asset” GL Account for the accumulated depreciation value. This account should be balanced with the asset cost account.
- Dr Proceeds & Cr Gain/Loss: Used for Asset retirement/disposal to record any proceeds (for sale of Asset) and net gain or loss from the sale or disposal of an asset.
- Dr CIP Cost & Cr CIP Cost Clearing: As per the Cost and Cost Clearing accounts above but used with the Asset has a Type of In Progress (Construction in Progress).
Asset Book Defaults
To add a new Asset Book Default:
- From the Main Menu, search for and click Asset Book Defaults.
- Click Add. The Add Asset Book Defaults window opens.
- In the Default By section:
-
- Choose the Book, most commonly the GL Book (000).
- Choose the Major Group.
- If defining at the Minor level, choose the Minor Group.
-
- In the Defaults section, add the values to default into the new asset records:
-
- Check the Depreciate box.
- Choose the method – A straight line or a declining balance option.
- Enter the default Life in years in the first box and months in the second. For example, an asset with a life of 2.5 years would have 2 in the years' box and 6 in the months.
- Salvage % – Enter the percentage of the acquired cost to calculate the default salvage value.
- Select Convention:
- Full Month – Calculate a full month of depreciation for the fiscal period corresponding to the in-service date.
- Full Year – Calculate a fiscal year of depreciation for the first fiscal period and then monthly from then on.
- Half Year – Calculate half a fiscal year of depreciation for the first fiscal period and then monthly from then on.
- Mid-Month – Calculate the first month of depreciation prorated on the number of days from in-service to the fiscal period end and then monthly from then on.
- Next Month – Begin depreciation calculations from the next fiscal period.
- Next Year – Begin depreciation calculation from the next fiscal year.
- Check the Depreciate box.
-
Fixed Asset Issue Types
The Fixed Asset Issue Types and Custom Fields are used to collect custom information against assets. Each custom field is associated with a database field.
To display the Custom Fields on the Fixed Asset, the Issue Type must be selected against the asset’s Minor Group.
The most used Custom Fields formats are:
- Alphanumeric – Free-form text field. These can be used with Validation Tables. There are 50 alphanumeric fields available within each Issue Type.
- Personnel – A dropdown that displays a list of all Personnel Contacts.
- Space – A dropdown that displays a list of all Spaces.
- Supplier – A dropdown that displays a list of all Supplier Accounts.
- Date – Used to enter dates with two-digit years. 20 date fields are available within each Issue Type.
- Contact – A dropdown that displays a list of all contacts for an account.
- Blank Line – Used to separate information.
- Customer – A dropdown that displays a list of all accounts.
- Event – A dropdown that displays a list of all events.
- Full Year Date – Used to enter dates with a four-digit year format.
- Job – A dropdown that displays a list of all Jobs.
- Header – Creates a header for grouping information in a user-defined field set.
- Member – A dropdown that displays a list of all member accounts.
- Numeric – Used to enter a number. There are 30 number fields available.
- Percent – Used to enter a percentage.
- Time – Used to enter a time.
- URL – A text field used to store a URL.
- From the Main Menu, search for and click Fixed Asset Issue Types.
- Click Add. The Add Issue Type window opens.
- Enter a Description and a Code to identify the Issue Type.
- Set the Status to Active. These can be marked as Inactive when not in use.
- Check the box for UDF Only.
- In the Custom Fields section, click Add. The Add Custom Field window opens.
- Enter a Description for this field. This will be displayed on the Asset record.
- Choose the Type of field to use (see definitions above).
- Alphanumeric fields will allow for the selection of a Validation Table and definition of the number of characters (up to 255) to be made available.
- To allow the check box for Allow Multiple Values, select a Validation Table. For more information on Validation Tables, see the article- Dependent Custom Fields/User Defined Fields (UDFs).
- For Numeric fields, define the number of decimals.
- Choose the Display Options to modify how the field displays on the screen. Display Line defines the order in which to display the fields on the Edit Asset screen. This is not controlled by the edit layout.
- To allow for only values that apply to the parent field to be displayed for selection in the child field, add Relationships between fields. To create a relationship, there must be an existing field with a Validation Table associated that can be chosen as a Parent Field. The field to create the Relationship must also have a Validation Table. To add a Relationship:
- In the Relationships section, click Add.
- Select the Parent Value – The options available are the Validation Table values of the Parent Field.
- Select the Child Value – The options available are the Validation Table values of the Child Field.
- If multiple Child Values apply to a single Parent Value, these must be entered individually.
- Check the Default box for a value that should default into the child field based on the parent selection.
- Click OK to save.
Asset Import Formats
A standard format with all fields in a fixed order is shipped with the software but using a customized format is normally more effective to match your data set. You may create multiple asset imports.
When defining the import format, these are the minimum required fields for the import to run successfully:
- Description
- Useful Life (in years)
- Major Asset Group
- Asset Type
- New or Existing Asset (N for new assets)
- Owned/Leased
All other available fields can be added to the import format to match the data available in the external file.
Note - If there is a requirement to import into the Book Value or Type fields, these will be found in the import format as Asset Cost Basis and Asset Scope, respectively.
- From the Main Menu, search for and click Fixed Asset Import Formats.
- Click Add. The Add Fixed Asset Import Formats window opens.
- Add the necessary information:
- Description – The name of the import format.
- Fixed – Select Yes, No, or Quoted.
- Delimited – None or CSV.
- Export/Import File Name – Name of the file.
- In the Details tab, click Add to add and define the fields to correspond to the fields in your data file. Refer to Add an Asset to the Asset Register for details about the most commonly used fields for Assets.
- Note - Pay particular attention to date fields and select the correct date format in the Fill Factor field.
- In the Order field, update the value for each row to determine the order of the columns. This is stored in increments of 10 and will automatically recalculate when values are updated.
- Click OK.
Comments
0 comments
Please sign in to leave a comment.