Fixed Assets Profile

The Fixed Assets Profile tab allows you to view or edit a fixed asset profile.

To open the Fixed Assets Profile tab, hover over a Fixed Asset number on the Fixed Assets screen and select View/Edit from the pop-up menu.

Note that:

  • If the stock number already exists, these fields are locked, and can only be changed through Equipment Profile: Location, Description, Serial Number, Purchase Date, Warranty Date, Disposable Amount, Disposable Date and Asset Account.

  • If a stock number has been invoiced, you must reverse the sale in order to change any disposal information on the stock number.

The sections of the Fixed Asset Profile include:

Main Section

The fields on the Fixed Assets Profile tab are:

Field Description
Active Indicates whether the fixed asset is active for use within the system.
Location The location of the fixed asset.
Area The area/physical location of the fixed asset within the location.
Class The asset's class code used for sorting assets into categories.
Type The type of fixed asset; either New or Used.
Description A brief description of the fixed asset.
Serial Number

The fixed asset's serial number.

This field is automatically loaded if a stock number is specified.

Purchase Information

The Purchase Information section of the Fixed Assets Profile screen displays the fixed asset's purchase information. The fields in the Purchase Information section of the Fixed Assets Profile tab are:

Purchase Information
Field Description
Vendor The vendor number of the vendor you purchased it from.
Amount

The purchase amount for the asset.

You can automatically update this field from the invoice or A/P voucher.

Adjustment The amount of adjustments made to the original cost of the asset since its purchase.
Current Cost The current cost of the asset. The Current Cost field is calculated as original costs plus additional adjustments.
Purchase Date The date the fixed asset was purchased from the supplier which can be updated from on the voucher.
Warranty Date The warranty expiration date on the asset.
Depreciation Date The date at which the asset begins to depreciate.

Disposal Information

The Disposal Information section of the Fixed Assets Profile screen displays the fixed asset's disposal information. The fields in the Disposal Information section of the Fixed Assets Profile tab are:

Disposal Information
Field Description
Amount

The disposal amount is automatically updated when an asset is sold.

Note:  The amount can also be entered manually as long as the unit does exist in the CGIBASE file and has not been invoiced (sold).

Date

The disposal date is automatically updated by the sale invoice.

Note:  The date can also be entered manually as long as the unit does exist in the CGIBASE file and has not been invoiced (sold).

Accounting Information

The Accounting Information section of the Fixed Assets Profile screen displays the fixed asset's accounting information, which includes the accounts used for the fixed assets. The Application Type that applies to the fixed asset's accounts can be one of:

Code Function
Blank Blank
I Inventory & Assets
H History
W Depreciation
S Sales

When adding a new fixed asset, after you select an Area, Class and Vendor the system automatically populates the Depreciation Account, Depreciation Expense Account and Maintenance Expense Account fields if these conditions are true:

  • The selected Asset Number has a matching equipment profile on the Equipment Listing screen.

  • The matching equipment profile is associated to an active Equipment Defaults record.

The fields in the Accounting Information section of the Fixed Assets Profile tab are:

Accounting Information
Field Description
Asset Account

The G/L asset account used for the asset.

This account must have an application type I in the chart of accounts.

Depreciation Account

The G/L accumulated depreciation account used for the asset.

This account must have an application type W in the chart of accounts.

This account is posted to during the depreciation month end final.

Depreciation Expense Account

The G/L expense account used for the depreciation of the asset.

This account must have an application type of H in the chart of accounts.

This account is posted to during the depreciation month end (opposite amount to the amount posted to depreciation account).

Maintenance Expense Account The G/L expense account used for maintenance of the asset.

The following fields appear in the Accounting, Federal, Minimum and State tabs of the Fixed Assets Profile tab:

Field Description
Method

The depreciation method used for the asset.

The system has a hard-coded depreciation threshold of $2.00, at which point the system automatically switches to a Straight Line depreciation method, regardless of whether the code assigned to the unit is supposed to be Declining Balance.

For example, if a unit has a Net Book Value (NBV) of $2.58 in the first month of the company's fiscal year, using a Declining Balance method of 45% would decrease the value of the unit to $1.42. The system recognizes this, and as such, changes the depreciation to Straight Line so that the unit only depreciates by .22 cents per month (thereby reducing the value of the unit to 0.00 after 12 months.)

Life

The life of the asset. The number of years it takes to depreciate the asset.

Only certain values can be entered in the Life field depending on the depreciation method being used.

Mid-Quarter Convention

Indicates if mid-quarter convention should be used. Select the checkbox for mid-quarter convention or leave checkbox blank for half year convention.

  • Mid-Quarter Convention—Use this method if the asset was purchased and placed into service in the midpoint of the last quarter of the taxable year (the previous quarter's depreciation + ½ the depreciation for the quarter the asset was purchased). Mid-Quarter Convention can only be selected for methods 16 and 17.

  • Half-Year Convention—The depreciation allowed in the first year is one half the full year's depreciation. This is based on the assumption that the asset being depreciated was placed into service half way through the first year (before July 1). The taxpayer is entitled to another half-year of depreciation at the end of the normal recovery period in order to compensate for this calculation.

Listed Property Indicates if the asset is a listed property.
Luxury Auto

Indicates if luxury auto limits should be applied to the asset.

Limits the amount of depreciation allowed per year. The limit varies depending on the date of purchase. If the calculated depreciation is greater than the limit, then the limit is used.

Business Use % The percentage of the asset that is used for business purposes. The percentage is applied to the yearly depreciation in order to figure out the depreciation allowed for business use.
Non-Depreciation Portion The amount of the asset in dollars that can not be depreciated. This reduces the depreciation basis.
Depreciation Basis

The depreciation basis for the asset, calculated as:

Original Cost - Non Depreciable portion + Adjustments - Salvage Amount - Section 179 amount.

Salvage Value

The salvage amount for the asset. This is used to calculate the depreciation basis.

If method 25, 26, 27, 28, 29 or 30 is being used (Declining Balance MethodClosed Depreciation method that provide for a higher depreciation charge in the first year of an asset's life and gradually decreasing charges in subsequent years.), the depreciation is calculated using depreciation basis plus salvage. The total depreciation allowed is still limited by the depreciation basis.

Section 179 Amount

The section 179 amount for the asset.

The section 179 amount is extra depreciation allowed in the year of purchase. The total section 179 amount allowed for all assets is limited. Refer to the depreciation and section 179 expense for the current tab year depending on the year of purchase. This value is used to calculate the depreciation basis.

  • The section 179 amount must be less than or equal to $5000 for any asset purchased prior to Jan 01/87.

  • The section 179 amount must be less than or equal to $10,000 for any assets purchased on or after Jan 01/87.

  • The section 179 amount can not be greater than the purchase amount for the unit.

  • The section 179 amount plus adjustments, less the non depreciable portion, less the salvage amount less the section 179 amount can not be less than zero.

  • A section 179 amount must be greater than or equal to zero.

Last Period/Date

The date and amount of depreciation posted to the asset during the last Deprecation Month End Final.

These values are NOT updated by any depreciation manually posted using invoicing systems.

Depreciation Year to Date The amount of depreciation posted to the asset for the current fiscal year. This does NOT include depreciation that was manually posted using invoicing systems, and only includes depreciation posted using the Depreciation Month End Final run.
Depreciation Life to Date The amount of depreciation posted to the asset for it's entire life. This includes depreciation that was posted through invoicing systems as well as depreciation posted using the Depreciation Month End Final run.
Net Book Value Net book value is calculated as original cost plus adjustments plus depreciation.

The following field appears on the Federal, Minimum and State tabs of the Fixed Assets Profile tab:

Field Description
Active If selected, activates the selected deprecation method to be used on the fixed asset.

The depreciation methods and their corresponding valid life values are:

Depreciation Methods
Method Valid Life Values
ACRSClosed Accelerated Cost Recovery System (ACRS), property class lives were established, calculations were based on an estimated salvage value of zero, and shorter recovery periods were used to calculate annual depreciation. This resulted in an accelerated write off of capital costs. Property (1981 - 1986)
01 - ACRS 03,05,10
02 - Alternate ACRS 03,05,10,12,25,35
03 - 15 Real Property 15
04 - Alternate 15 Real Property 15,35,45
05 - 15 Low Income Housing 15
06 - Alternate Low Income Housing 15,35,45
07 - 18 Real Property Mid Month 18
08 - 18 Real Property 18
10 - Alternate 18 18,35,45
11 - 19 Real Property 19
12 - Alternate 19 Real Property 19,35,45
14 - Low Income Housing After (05/08/1985) 15
MACRSClosed The Modified Accelerated Cost Recovery System (MACRS) which is the current method of accelerated asset depreciation used by the United States. Assets are divided into separate classes which indicates the number of years which an asset's cost will be recovered. Property (1987 and After)
16 - 200% Declining Balance/Straight Line 03,05,07,10
17 - 150% Declining Balance Straight Line 15,20
18 - 27.5 Year Straight Line Mid Month 28 (27.5)
19 - 31.5 Year Straight Line Mid Month 32 (31.5)
Other Methods
24 - Straight Line Mid Month
25 - 200% Declining Balance Mid Month
26 - 200 % Declining Balance/Straight Line Mid Month
27 - 150% Declining Balance Mid Month
28 - 150% Declining Balance Straight Line Mid Month
29 - 125% Declining Balance Mid Month
30 - 125% Declining Balance/Straight Line Mid Month
31 - Sum of the Year Digits Mid Month
32 - Sum of the Year Digits Mid Month
90 - Non-Depreciable

Select the Click here to view Asset History - Accounting link to view the fixed assets unit history.

Use these buttons to complete your work on the Fixed Assets Profile tab:

Button Function
Save Saves changes made on the Fixed Assets Profile tab.
Save & Close Saves changes made on the Fixed Assets Profile tab and closes the profile.
Label Opens the Print Label screen allowing you to print an equipment label for the select fixed asset.
Close Closes the Fixed Assets Profile tab without saving and returns to the Fixed Assets screen.

Data Source: FASSET, CGIBASE

Security: 602 -Financial Management - General Ledger

Revision: 2024.11