Contents of the Manage Asset Other Books Information Screen

Use the fields and options to configure the Manage Asset Other Books Description Information Screen.

With this screen option, users do not automatically have access to data fields in other Asset Master subtasks; such access rights must be granted by the system administrator for each subtask on a screen-by-screen basis.

Note: You can enter, edit, and view other books data for an Asset Master record when you access the Manage Asset Master Information screen, which automatically grants access to all the available subtasks. An alternate access route to Asset Master subtasks gives you more flexibility when security options for users with different access needs are set up.
  • If screen rights allow you access to the Manage Asset Master Information screen, then that screen and all its subtasks are automatically accessible to you.
  • If you do not have access rights to the Manage Asset Master Information screen, the system administrator can alternately grant or deny rights using the direct menu option (via the Asset Master Records menu) on a screen-by-screen basis. In this manner, each user can access only the permissible subtasks in an Asset Master record.

When you first bring up this screen, a screen prompts you to enter a search criteria.

This screen displays data for depreciable assets only (the Depr Status is Depreciable) within the parameters of your search criteria.

Although the data displays in columnar form in the table window on this screen, data entry functionality and data rules for each column are identical to those for each corresponding field in the Other Books Info subtask of the Manage Asset Master Information screen, regardless of which entry screen methodology you establish for each user. You can also use the Form view option for this screen.

For optional books 2-10, information about depreciation parameters and calculations displays on this screen. For existing property records, you can optionally add historical depreciation data on this screen if you use additional books.

Note: On the Manage Asset Master Information screen, you were required to assign a depreciation base methodology for each depreciable asset for the G/L Book. (This data may have been edited on the Manage Asset Description Information screen.) The available options are Years, Units of Usage, or Lease Pds. The system default is Years.

For any optional books (2-10) used, the system uses the Years base method in its computations. Units of Usage and Lease Pds base methods are not available for optional books 2-10.

Optional books 2-10 are initialized and named in the Books Setup group box and Book Details block of the Configure Fixed Assets Settings screen. Each optional book can be set up and used independently, and can be used for purposes such as tax depreciation or to review the results of a change in depreciation method.

Note: Once you have added a Depr Method Code on this screen for any book, you will not be able to delete that book from the setup until you have deleted the data from the Depr Method Code column on this screen (and on the Manage Asset Template Information screen) for all asset and template records for that book.

There is no interface with the General Ledger for Books 2-10 and no postings can occur. The results of depreciation calculations display on this screen for all optional books used, and reports are available to print data by book in a number of different formats. Book 1, which is designated by the system as the "G/L Book," is the only book that interfaces with the General Ledger by means of depreciation and disposal posting entries.

Note: When you first manually add historical record with a Disposal status, you can edit all fields in the Asset Master record as needed before you save the record for the first time. If the saved Disposal record is accessed again, however, the Record Status, Depr Status, and Depr Based On group boxes in the Asset Master record are disabled. In addition, you cannot edit the fields in the Cost Info tab, Account Info tab, Other Books Info subtask (if data previously existed), and Disp Info tab (if system-generated) because they are disabled.

You can enter original data in the Other Books Info subtask for an Asset Master record with a Disposal status only if no data has previously been entered and saved. If the Other Books Info subtask already contains saved data, you cannot edit it if the status is changed to Disposal.

You cannot use this screen to add new asset records. You can enter additional optional data, change existing data, or delete existing data within the system rules already established for Asset Master record that was originally added using the Manage Asset Master Information screen and its subtasks.

On this screen, unlike maintenance table windows throughout Costpoint, the line functions in the menu (Execute, New Record, Clone Record, Delete and Undelete) are disabled.

Information about depreciation displays on this screen once depreciation for a record has begun. For existing property records, you may need to add historical depreciation data on this screen.

Data entry for all the columns on this screen is optional. Although it is not required to save data on this screen, if an asset is depreciable (the Depr Status is Depreciable), you must assign a depreciation method in the Depr Method Code and enter data in the Depr Start Date for its corresponding book to compute depreciation.

For additional information on depreciation calculations and the role of data columns on this screen, please refer to the following field descriptions on this screen and in the special topic, Calculate Depreciation.

Note: You cannot edit the columns on this screen after a disposal is posted or manually entered (for the purpose of preserving the audit trail). Although you can view the columns on this screen, you cannot save any changes to the data.

You cannot use this screen to add new asset records. You can enter additional optional data, change existing data, or delete existing data within the system rules already established for Asset Master record that was originally added using the Manage Asset Master Information screen and its subtasks.

You should enter or edit data on this screen before you calculate depreciation, as applicable. Although you can change information on this screen at any time, use caution in the timing of these edits, which can impact the calculation of depreciation as well as the types of records included in system reports.

Note: If the Fixed Assets period close process does not complete successfully, Save is disabled for active and disposed assets.

Table Window

Field Description
Asset No

This column displays the asset number assigned to this record when the asset was saved on the Manage Asset Master Information screen.

Item No

This column displays the item number assigned to this record when the asset was saved on the Manage Asset Master Information screen.

Short Desc

This column displays the optional short description entered for this record, if applicable.

The Short Desc data may have been entered or edited on the Manage Asset Master Information screen or on the Manage Asset Description Information screen. You can make edits to this column on these two screens.

Record Status

This column displays the system-required record status assigned to this record when the asset was saved on the Manage Asset Master Information screen. The options available for this display-only column are Active, Inactive, or Disposal. The system default is Active.

A record must be Active to be eligible for depreciation calculations. If you specify that a record is Inactive, the system will skip over this record for depreciation calculations and for reports that do not specify the inclusion of inactive records.

Note: The following fields display the book names that have been defined on the Configure Fixed Assets Settings screen. The convention for the following field names will be—(Book Name) (Field Name). For example, if you have named optional Book 2 as your Tax book, and the name of the field is Auto Calc, you will find that the heading will read as—Tax Auto Calc. This field naming convention is followed across all optional books on this screen.
(Book Name) Auto Calc

This column tells if the system auto-calculates the deprecation of the asset record for this book. The value displayed in this column may have been saved or edited in the Other Books Info subtask of the Manage Asset Master Information screen or on this screen.

The system default for this check box is selected. You should accept the system default if you want this record to be included in system calculations of depreciation. If you select this check box, the system will compute depreciation each period for eligible assets and will display the results in the (Book Name) Current Pd Depr column on this screen. You can always overwrite the automatic system calculation of depreciation. If this check box is selected, the system will also re-set the (Book Name) Current Pd Depr column back to zero during the Fixed Assets period close process.

Clear this check box if you want to disable the automatic system calculation of depreciation. In this circumstance, you will need to manually enter the amount of depreciation in the (Book Name) Current Pd Depr column for this record.

In general, if you need to make a one-time adjustment to current depreciation expense, you should manually override the system calculation in the (Book Name) Current Pd Depr column rather than change the default for this check box. If, however, you want to use the manually entered depreciation amount as a recurring override to system calculations, you should clear this check box and enter the override amount in the (Book Name) Current Pd Depr column.

Note: If you manually edit the system-computed value in the (Book Name) Current Pd Depr column and then want to set it back to the system-calculated number, run the Compute Depreciation process again for that asset. This is especially important if the asset is using a Date of Purchase basis depreciation method that is calculated based on days.
(Book Name) Depr Method Code

This column displays the optional depreciation method code assigned to this record for this book, if applicable, when the asset was saved or edited in the Other Books Info subtask of the Manage Asset Master Information screen or on this screen.

You can edit, enter, or click to select, the depreciation method code for this record. Valid depreciation method codes are set up during initialization on the Manage Depreciation Methods screen.

For both new and existing asset records, you can edit the depreciation method code that displays in this field. Because depreciation calculations use the depreciation method code from this field, use caution if you change the depreciation method code for property records once they have begun depreciating in the system.

(Book Name) Useful Life

This column displays the optional useful life assigned to this record for this book, if applicable, when the asset was edited or saved in the Other Books Info subtask of the Manage Asset Master Information screen or on this screen.

You can edit, or enter the useful life for this record. There is no system validation for the data in this column.

The value in this column is for data purposes only and is not used in system calculations. (When the system calculates depreciation, the depreciation year and percentage for that year is derived from the depreciation method assigned to the record. For example, if you enter a useful life of five years in this column but your depreciation method uses only three years, the system will not use the value in this column for calculations, but will instead use percentages for three years only, as specified by the depreciation method.)

(Book Name) Depr Start Date

This column displays the optional G/L book depreciation start date assigned to this record for this book, if applicable, when the asset was edited or saved in Other Books Info subtask of the Manage Asset Master Information screen or on this screen.

For a new asset record, enter, edit, or click to select, the depreciation start date for this record in this column. Even though data entry in this column is not required, this column is the most important date for depreciable assets, because the system uses this date in the computation of depreciation. Depreciation calculations will not take place if blanks display in this column, or if this date is later than the end of the current accounting period. (Specify the Fixed Assets "current" accounting period on the Configure Posting Settings screen.)

If you anticipate a depreciation start date delay due to installation or calibration requirements, for example, you can enter a future date in this column. In this circumstance, depreciation calculations will not begin until the future date coincides with your current accounting period. The date in this column must be on or before the end of the current accounting period for depreciation calculations to take place.

For both new and existing asset records you can enter or edit in this column. You should enter the historical date that depreciation began for this record and not the date that you began depreciating this record using Costpoint Fixed Assets. Because system calculations use this date to determine whether depreciation computations should take place for each record, use extreme caution if you change the depreciation start date for property records once they have begun depreciating in the system.

The relationship between this data in this column and the values in the (Book Name) Curr Depr Yr and (Book Name) Days/Pds Remaining columns is critical to the accurate calculation of depreciation for new records (only for records in which the Depr Basis is Years).

You can use the Compute/Update Depreciation Computation Data utility to assist you in verifying the relationship of the (Book Name) Depr Start Date column to the (Book Name) Curr Depr Yr and (Book Name) Days/Pds Remaining columns.

Using the value in the (Book Name) Depr Start Date column, the system prints a report by asset/item number, by book, that includes a side-by-side comparison of both the current values displayed in the Asset Master record and the values that the system would have computed for the (Book Name) Curr Depr Yr and (Book Name) Days/Pds Remaining columns.

Although you can print this report for all selected records, you can also print the report for exceptions only, which makes discrepancies easier to identify. After the report has printed, you can activate the option in this utility that applies the system-computed values to your asset records. This process updates the existing data in the (Book Name) Curr Depr Yr and (Book Name) Days/Pds Remaining columns by replacing your data and writing the system-computed values to these columns.

Warning:

Always carefully review and agree with the reported results on a record-by-record basis, using the Compute/Update Depreciation Computation Data utility, before performing the Update process.

You should run this utility to verify (and optionally update) your data after you initialize your historical records and reconcile the detail Asset Account and Accumulated Depreciation Account totals with your General Ledger account totals before you compute depreciation for the first time.

After initialization, you may want to run this utility on a regular basis each period as part of your company's standard procedures, to confirm that your period additions have been initialized correctly.

For additional information about this feature, please refer to the specific documentation on the Compute/Update Depreciation Computation Data utility.

During initialization, to ensure consistency of data, you may want to develop some internal rules on the use of this column.

When entering data for new records or for historical records during the initialization process, there are no system restrictions regarding the appropriateness and/or accuracy of the start date. Because of the important relationship between the start date and the data in the (Book Name) Curr Depr Yr and (Book Name) Days/Pds Remaining columns, however, in most cases you should enter the date at which depreciation originally began for this record.

Note: There are two ways to populate the (Book Name) Curr Depr Yr and (Book Name) Days/Pds Remaining columns for new records:
  1. You can manually enter this data at the same time you enter data for other Asset Master columns. For this method, you need to be very careful that your entries are correct and "in sync" with the (Book Name) Depr Start Date column.

  2. You can leave these columns blank when you initialize the Asset Master record. When you compute depreciation for the first time, the system will compute and insert the correct values for these columns, based on the data in the (Book Name) Depr Start Date column.

Because manually entered data in the (Book Name) Curr Depr Yr and (Book Name) Days/Pds Remaining columns is especially prone to user error and misinterpretation, you can use the Compute/Update Depreciation Computation Data screen to assist you in verifying the relationship of these two data columns with the (Book Name) Depr Start Date column. You can access the Compute/Update Depreciation Computation Data screen in the Fixed Assets Utilities menu. You can run it for any range of asset/item numbers.

After printing the report, you can activate the option in this utility that applies the system-computed values to your asset records. This process updates the existing data in the (Book Name) Curr Depr Yr and (Book Name) Days/Pds Remaining columns by replacing the existing data with the system-computed values. If you do not apply the system-computed values to your data, you may need to manually adjust some values in the (Book Name) Curr Depr Yr and (Book Name) Days/Pds Remaining columns (or, in some cases, the (Book Name) Depr Start Date column) to ensure the accuracy of depreciation calculations.

For additional information about this feature, please refer to the documentation for the Compute/Update Depreciation Computation Data utility.

Note: Regardless of the Date of Purchase or Fiscal Year basis assigned to any depreciation method, to ensure the accurate calculation of depreciation, you must set up all Fiscal Year (FY)/Period (Pd) data in Costpoint Fixed Assets for the current fiscal year and two future fiscal years. Use the Manage Fixed Assets Fiscal Years and Manage Fixed Assets Accounting Periods screens to manually enter this data or use the Update FA FY/Pd Information from GL FY/Pd Information screen to copy existing GL data into Costpoint Fixed Assets. It is imperative that you set up this data as part of your initialization procedures before you compute depreciation for the first time.
(Book Name) In-Srvc Date

This column displays the optional in-service date assigned to this record for this book, if applicable, when the asset was saved or edited in the Other Books Info subtask of the Manage Asset Master Information screen or on this screen.

You can enter, or click to select, the in-service date for this record in this field. The value in this field is for data purposes only and is not used in system calculations. (When the system calculates depreciation, the system checks only the date from the (Book Name) Depr Start Date field). The date in this field can be a historical, current, or future date.

For both new and existing asset records, you can edit the value that displays in this field.

(Book Name) Curr Depr Yr

This column displays the current depreciation year assigned to this book for this record when the asset was saved or edited on this screen or in the Other Books Info subtask of the Manage Asset Master Information screen (or when depreciation was first computed for the record).

This column, along with data in the (Book Name) Days/Pds Remaining and (Book Name) Depr Start Date column, plays an integral role in the system calculation of depreciation. The value in this column signifies which depreciation year of the asset's useful life is current. As a result of this data, the system can use the appropriate percentage for the current year of life from the depreciation method linked with this record. (Years of useful life and percentages for each year are set up on the Manage Depreciation Methods screen.)

For a new asset record, blanks normally display in this column as a default. You can leave this column blank because the system will insert 1 in this column for a new blank record the first time that depreciation is calculated for this asset. Alternately, you can manually enter the depreciation year (which should be 1 for a new record). If you enter a value in this column, however, you must also enter a value in the (Book Name) Days/Pds Remaining column, or you will not be able to save the asset record.

This column must be blank for the system to populate it with a 1 the first time that depreciation is calculated for this record. If you have entered any number in this column, the system will not replace your entry during depreciation calculations. If you have overwritten the system-populated value in this column with blanks, system calculations cannot take place. The reason for this is that the system cannot find the appropriate percentage to use from the Manage Depreciation Methods screen if the current depreciation year is not specified.

During the initialization of your historical records, you will need to enter the correct current depreciation year for each asset. If, for example, you have an asset for which you have defined a depreciation method with a useful life of five years (the Manage Depreciation Methods screen), you should enter the current year of that life (for example, 1, 2, 3, 4, or 5). In this way, the proper depreciation percentage for the current depreciation year can be used during system calculations.

For both new and historical records, once this column is initialized, the system increases the value in this column when required during the appropriate Fixed Assets period close process. The current year increments during the closing process if there are:

  • Additional years of useful life remaining for the record, and the (Book Name) Days/Pds Remaining column displays 1 (for assets using period-based depreciation)
  • Or if the number of days remaining is less than or equal to the number of days in the Fixed Assets period being closed (for assets using a Date of Purchase basis with depreciation calculated based on the number of days owned).

At the same time, the value in the (Book Name) Days/Pds Remaining column will also change appropriately.

For both new and existing asset records, you can edit data that displays in this column, if needed. Because system calculations use this data to determine whether depreciation computations should take place for each record, and the manner in which they should take place, use extreme caution if you change the current depreciation year for property records once they have begun depreciating in the system.

Note: Because manually entered data in the (Book Name) Curr Depr Yr and (Book Name) Days/Pds Remaining columns are especially prone to user error and misinterpretation, you can use the Compute/Update Depreciation Computation Data screen to assist you in verifying the relationship of these two data columns with the (Book Name) Depr Start Date column. You can access the Compute/Update Depreciation Computation Data screen in the Fixed Assets Utilities menu. You can run it for any range of asset/item numbers.

The utility produces a report, based on the depreciation start date, which shows a side-by-side comparison of both the current values displayed in the Asset Master and the system-computed values for the (Book Name) Curr Depr Yr and (Book Name) Days/Pds Remaining columns. You can print the report for all selected records or for exceptions only, which makes discrepancies easier to identify.

After printing the report, you can activate the option in this utility that applies the system-computed values to your asset records. This process updates the existing data in the (Book Name) Curr Depr Yr and (Book Name) Days/Pds Remaining columns by replacing the existing data with the system-computed values. If you do not apply the system-computed values to your data, you may need to manually adjust some values in the (Book Name) Curr Depr Yr and (Book Name) Days/Pds Remaining columns (or, in some cases, the (Book Name) Depr Start Date column) to ensure the accuracy of depreciation calculations.

Because the Update portion of this utility will overwrite your existing data with system-generated data, you should always carefully review and agree with the reported results on a record-by-record basis before performing the Update process. The Update process is similar to posting routines in that the report must first be printed before you can proceed with the Update process. Never run the Update process as a matter of routine unless you are in agreement with the system data changes that will take place in each Asset Master record.

Please refer to documentation for the Compute/Update Depreciation Computation Data screen.

(Book Name) Days/Pds Remaining

This column displays the optional number of days/periods remaining assigned to this record for this book, if applicable, when the asset was saved or edited in the Other Books Info subtask on the Manage Asset Master Information screen or on this screen.

This column, along with the columns (Book Name) Curr Depr Yr and (Book Name) Depr Start Date, plays an integral role in the system calculation of depreciation. The value in this column indicates the number of days or periods remaining in the current depreciation year of the asset's useful life. (Years of useful life and percentages for each year are set up on the Manage Depreciation Methods screen.)

For a new asset record, blanks display in this column as a default. You can leave this column blank, if desired, because the system will insert the correct value in this column for a new blank record the first time that depreciation is calculated for this asset. Alternately, you can manually enter the days or periods remaining in this column, if desired. If you enter a value in this column, however, you must also enter a value in the (Book Name) Curr Depr Yr column, or you will not be able to save the asset record

The value in this column will depend on the Date of Purchase or Fiscal Year basis assigned to the depreciation method for this asset.

  • If you have linked a Date of Purchase basis for depreciation method with this record, the value in this column should reflect the number of days or periods remaining in the current purchase year, depending on the option you selected in the System-Wide Configuration for DP Basis Depreciation Methods group box on the Configure Fixed Assets Settings screen.
  • If you have linked a Fiscal Year basis for depreciation method with this record, the value in this column should reflect the number of periods remaining in the current fiscal year. The number of periods remaining cannot be greater than 18.

This column must be blank for the system to populate it the first time that depreciation is calculated for this record. If you have entered any number in this column, the system will not replace your entry during depreciation calculations. Although this column is not required, system calculations cannot take place if you have overwritten the system-populated value in this column with blanks. The reason for this is that the system cannot depreciate correctly for the current period if the value in the column, (Book Name) Days/Pds Remaining is not specified.

During the initialization of your historical records, you will need to enter the correct days/periods remaining for each asset, as applicable.

For both new and historical records, once this column is initialized, the system changes this value, as required, during the Fixed Assets period close process. The current year increments during the closing process if there are additional years of useful life remaining for the record, and the (Book Name) Days/Pds Remaining column displays a 1 (for assets using period-based depreciation) or if the number of days remaining is less than or equal to the number of days in the Fixed Assets period being closed (for assets using a Date of Purchase basis with depreciation calculated based on the number of days owned). At the same time, when the value in the current year increases, the value in the (Book Name) Days/Pds Remaining column will also change appropriately for the basis used (DP or FY).

For both new and existing asset records, you can edit data that displays in this column, if needed. Because system calculations use this data to determine if and the manner in which depreciation computations should take place for each record, however, use extreme caution if you change data in this column for property records once they have begun depreciating in the system.

Because manually entered data in the (Book Name) Curr Depr Yr and (Book Name) Days/Pds Remaining columns is especially prone to user error and misinterpretation, you can use the Compute/Update Depreciation Computation Data screen to assist you in verifying the relationship of these two data columns with the (Book Name) Depr Start Date column. You can access this screen from the Fixed Assets Utilities menu. Please refer to the documentation for the Compute/Update Depreciation Computation Data screen.

(Book Name) Total Cost

This column displays the optional total cost amount entered for this record for this book, if applicable. The value in this column may have been entered or edited in the Cost Info tab of the Manage Asset Master Information screen or on this screen.

You can enter or edit the total price amount in this optional column. Note that cost changes made to any optional book on this screen display in the appropriate columns on the Manage Asset Cost Information screen. Conversely, cost changes made to any optional book on the Manage Asset Cost Information screen display in the columns on this screen.

There is no system requirement that the cost for any optional books used be identical to the cost value used for the G/L Book. You can always assign a different cost basis for each optional book (for purposes of stepped-up depreciation basis, and so on). Because system depreciation calculations use this data, however, use caution if you change the cost for a record once it has begun depreciating in the system.

Note: When you first add and save an Asset Master record, the Total Cost value from the Cost Info tab of the Manage Asset Master Information screen (or from the Manage Asset Cost Information screen) displays as the default total cost for all optional books.

If you add, edit, or delete the G/L book Total Cost value from the Cost Info tab of the Manage Asset Master Information screen (or from the Manage Asset Cost Information screen), the system will display a message that asks if you want to update Total Cost of the Other Books whose cost matched the original cost.

If you select the Yes, the G/L book Total Cost value will be copied to and display as the cost for all applicable optional books. The purpose of this default feature is to save you some data entry, because, for the majority of users, the G/L Book cost amount is the same for the optional books.

(Book Name) Salvage Percent

This column displays the optional salvage percent assigned to this record, as applicable, when the asset was saved or edited on this screen or in the Other Books Info subtask of the Manage Asset Master Information screen.

For a new asset record, if applicable, enter the salvage value percentage rate to be used in the calculation of salvage and depreciable value in this column.

If you enter a salvage value percentage in this column, note that the system computes and displays the equivalent salvage value in the (Book Name) Salvage Value column. Alternately, if you do not enter a percentage in this column but instead enter a salvage value amount directly in the (Book Name) Salvage Value column, the system will compute and display the equivalent salvage value percentage in this column.

(Book Name) Salvage Percent and (Book Name) Salvage Value columns are reciprocal in that the entry in one column calculates and displays the data in the other column. Data from the (Book Name) Salvage Value column is subtracted from the (Book Name) Total Cost column and the result is displayed in the (Book Name) Amt to Depreciate column, which in turn affects the amount of depreciation calculated by the system. In a simplified example, if an asset's cost is $10,000 and its salvage value is 5%, then the amount to depreciate is $9,500 and the system will not permit depreciation in excess of $9,500 for this asset. Do not enter a value in the (Book Name) Salvage Percent or (Book Name) Salvage Value columns for salvage unless this is the point at which you want the system to stop depreciation.

For both new and existing asset records, you can edit the value that displays in this column. Because system calculations use this data to determine the manner in which depreciation computations should take place for each record (as well as the amount to depreciate), use caution if you change this column for property records once they have begun depreciating in the system.

Note: If you select the Subtract Salvage Value Before Calculation check box on the Manage Depreciation Methods screen (the check box is selected by default), the system will subtract the salvage value from the cost of the asset before performing depreciation calculations. If this check box is clear, the system will ignore salvage value from the (Book Name) Salvage Value column when computing depreciation.

Refer to the these examples, each of which illustrates a different way in which to handle salvage value relative to the computation of depreciation based on years:

  • Example 1

    This example illustrates the setup for the condition in which salvage value is subtracted before depreciation calculations. This is the most common methodology for computing depreciation when there is salvage value assigned to an asset.

    Asset Master Record:

    Total Cost = $ 10,000
    Salvage Percent = 10 %
    Salvage Value = $ 1,000
    Depr Method Code = SL5
    Amt to Depreciate = $ 9,000

    Depr Method: SL5 (Straight-Line Method over 5 years)

    Total % to Depreciate = 100%

    Subtract Salvage Value Before Calculation = Check box is selected for depreciation method "SL5."

    Year % Amt to Depreciate Annual Depreciation
    1 20% x 9,000 = 1,800
    2 20% x 9,000 = 1,800
    3 20% x 9,000 = 1,800
    4 20% x 9,000 = 1,800
    5 20% x 9,000 = 1,800
    9,000

    For this example, the system subtracted the salvage value from the asset's total cost to determine the amount to depreciate (10,000 - 1,000 = 9,000). Note that the residual amount is spread uniformly across all years of useful life ($200 per year for 5 years).

    The system multiplies the amount to depreciate by the depreciation percentage for the appropriate year of life to determine annual depreciation.

  • Example 2

    This example illustrates the setup for the condition in which salvage value is not subtracted prior to depreciation calculations.

    Asset Master Record:

    Total Cost = $ 10,000
    Salvage Percent = 10 %
    Salvage Value = $ 1,000
    Depr Method Code = SL5
    Amt to Depreciate = $ 10,000

    Depr Method: SL5 (Straight-Line Method over 5 years)

    Total % to Depreciate = 100%

    Subtract Salvage Value Before Calculation = Check box is clear for depreciation method "SL5."

    Year % Amt to Depreciate Annual Depreciation
    1 20% x 10,000 = 2,000
    2 20% x 10,000 = 2,000
    3 20% x 10,000 = 2,000
    4 20% x 10,000 = 2,000
    5 20% x 10,000 = 2,000
    10,000

    For this example, the system ignored the salvage value from the asset's total cost in determining the amount to depreciate (10,000 - 0 = 10,000). The system multiplies the amount to depreciate by the depreciation percentage for the appropriate year of life to determine annual depreciation.

  • Example 3

    This example illustrates the only method available that will recognize the residual (salvage) amount in the last year of useful life. Note that only 90% of the asset was set up for depreciation when the depreciation method was defined.

    Asset Master Record:

    Total Cost = $ 10,000
    Salvage Percent = 10 %
    Salvage Value = $ 1,000
    Depr Method Code = SL5
    Amt to Depreciate = $ 9,000

    Depr Method: SL5 (Straight-Line Method over 5 years)

    Total % to Depreciate = 90%

    Subtract Salvage Value Before Calculation = Check box is clear for depreciation method "SL5."

    Year % Amt to Depreciate Annual Depreciation
    1 20% x 10,000 = 2,000
    2 20% x 10,000 = 2,000
    3 20% x 10,000 = 2,000
    4 20% x 10,000 = 2,000
    5 10% x 10,000 = 1,000
    9,000
(Book Name) Salvage Value

This column displays the optional salvage value amount assigned to this record for this book, as applicable, when the asset was saved or edited on this screen or in the Other Books Info tab of the Manage Asset Master Info screen.

Salvage value represents the expectation of value upon the retirement of the asset. It is computed as the salvage value percentage multiplied by the asset's total cost.

For a new asset record, as applicable, enter the salvage value to be used in the calculation of depreciation in this column.

If you enter a salvage value in this column, note that the system computes and displays the equivalent salvage value percentage in the (Book Name) Salvage Percent column. Alternately, if you leave this column blank but instead enter a salvage value percentage directly in the (Book Name) Salvage Percent column, the system will compute and display the equivalent salvage value in this column.

The (Book Name) Salvage Value column and the (Book Name) Salvage Percent columns are reciprocal in that the entry in one column calculates and displays the data in the other column. Salvage value is subtracted from the value in the (Book Name) Total Cost column, and the result displays in the (Book Name) Amt to Depreciate column, which in turn affects the amount of depreciation calculated by the system. In a simplified example, if an asset's cost is $10,000 and its salvage value is 5%, then the amount to depreciate is $9,500 and the system will not permit depreciation in excess of $9,500 for this asset. Do not enter a value in this column or in the (Book Name) Salvage Percent column for salvage unless this is the point at which you want the system to stop depreciation.

For both new and existing asset records, you can edit the value that displays in this column. Because system calculations use this data to determine the manner in which depreciation computations should take place for each record (as well as the amount to depreciate), use caution if you change this column for property records once they have begun depreciating in the system. For more information on salvage calculations, please refer to the examples of salvage value calculations illustrated in the (Book Name) Salvage Percent section above.

Note: If you select the Subtract Salvage Value Before Calculation check box on the Manage Depreciation Methods screen (the check box is selected by default), the system will subtract the salvage value from the cost of the asset before performing depreciation calculations. If you clear this check box, the system will ignore salvage value from the (Book Name) Salvage Value column when computing depreciation.
(Book Name) Amt to Depreciate

You cannot edit this column or make entries in it.

The system computes and displays an amount equal to the total cost of the asset less any salvage value from the (Book Name)Salvage Value field. Be certain to confirm the data in the (Book Name) Salvage Percent and (Book Name) Salvage Value fields, because they directly influence the system calculation of the (Book Name) Amt to Depreciate field.

As long as the (Book Name) Auto Calc check box is selected for this book and you have made no manual overrides to system-calculated data, the system cannot depreciate an amount greater than the amount that displays in this field.

(Book Name) FYTD Depr

This column, along with other depreciation data, plays an integral role in the system calculation of depreciation for methods using the Fiscal Year basis. (You must select a Date of Purchase or Fiscal Year basis on the Manage Depreciation Methods screen when you set up each depreciation method.)

This column displays the optional fiscal year to date depreciation amount entered for this record in this optional book, when the asset was saved or edited in the Other Books Info subtask of the Manage Asset Master Information screen or on this screen.

For a new asset record, no data should display in this column because there has been no historical fiscal year activity. You should leave this column blank for a new record, because the system will increment (or possibly decrement) the value in this column by the amount of depreciation posted cumulatively for the period each time the current Fixed Assets period is closed. The value in this column should always be equal to the posted depreciation expense for the current fiscal year, exclusive of the value in the (Book Name) Current Pd Depr column.

The value in this column will be different from the value in the (Book Name) Amt Taken Purchase YTD column except when the date of purchase coincides with the start of your fiscal year. The (Book Name) Amt Taken Purchase YTD column displays purchase year data, while the (Book Name) FYTD Depr column displays fiscal year data.

For both new and historical records that are being initialized, the system will increase or decrease the value in this column by the amount of the total depreciation posted cumulatively for the period when the Fixed Assets current period is closed. Data from this column is added to the data from the (Book Name) Prior FY Depreciation and the (Book Name) Current Pd Depr columns to derive the total calculated value displayed in the (Book Name) Accum Depreciation column.

The value in this column will be updated by the system when you perform the Fixed Assets period close process on the last period in your fiscal year. The value in this column will be added to the value in the (Book Name) Prior FY Depreciation column and the value in the (Book Name) FYTD Depr column will be set back to zero.

For both new and existing asset records you can edit data that displays in this column. Because system calculations use this data to determine if and the manner in which depreciation computations should take place for each record, however, use caution if you change data in this column for property records once they have begun depreciating in the system.

(Book Name) Prior FY Depreciation

This column, along with other depreciation data, plays an integral role in the system calculation of depreciation for methods using the Fiscal Year basis. (You must select a Date of Purchase or Fiscal Year basis on the Manage Depreciation Methods screen when you set up each depreciation method.)

This column displays the optional cumulative depreciation amount for all prior fiscal years entered for this record in this optional book, when the asset was saved on the Manage Asset Master Information screen. The value in this column should reflect cumulatively the total depreciation expense for all past fiscal years, and should not include the current fiscal year amount. Data displayed in this column may have been edited in the Other Books Info subtask of the Manage Asset Master Information screen or directly on this screen.

For a new asset record, no data should display in this column because there has been no prior fiscal year activity. The value in this column should always be equal to the cumulative depreciation expense for all prior fiscal years, exclusive of the value in the (Book Name) Current Pd Depr column. This column will be updated when you perform the Fixed Assets period close process on the last period in your fiscal year. The value in the (Book Name) FYTD Depr column will be added to the value in this column, and the (Book Name) FYTD Depr column will be set back to zero.

For both new and historical records, the system adds data from this column to the data from the (Book Name) FYTD Depr and (Book Name) Current Pd Depr columns to derive the (Book Name) Accum Depreciation column calculated total.

For both new and existing asset records, you can edit data that displays in this column. Because system calculations use this data to determine whether depreciation computations should take place for each record, and the manner in which they should take place, use caution if you change the value in this column for property records once they have begun depreciating in the system.

(Book Name) Annual Depr

This column, along with data in the (Book Name) Curr Depr Yr and the (Book Name) Days/Pds Remaining columns, plays an integral role in the system calculation of depreciation for both Date of Purchase or Fiscal Year basis methods.

You should leave this column blank for a new asset record, unless you want to overwrite the system calculation of annual depreciation and you clear the (Book Name) Auto Calc check box.

The system will populate this column when you calculate depreciation for this record, when you select the (Book Name) Auto Calc check box and the date in the (Book Name) Depr Start Date column is not a future date (or later than the end of the current period).

Manual entries are always permitted in this column, regardless of the status of the (Book Name) Auto Calc check box and the date in the (Book Name) Depr Start Date column. However, enter manual overwrites with caution. The timing of any manual entries to this column are especially important; if you select the (Book Name) Auto Calc check box, any manual edits to this column will be overwritten by the system when you compute depreciation.

For both new and historical records, data from this column is used by the system during system depreciation calculations. You can perform depreciation calculations multiple times within the same accounting period. If you have made no manual corrections to critical columns (such as asset cost, annual depreciation, current depreciation year, periods remaining, and so on), there is no danger that the system will calculate a different annual depreciation value for the same asset in the same accounting period.

Annual depreciation is computed as: total cost (or cost minus salvage value) times the depreciation percentage (from the depreciation method assigned to the asset) for the year specified in the (Book Name) Curr Depr Yr column.

The system does not re-set the value in this column to zero during the period close process.

For both new and existing asset records, you can edit data that displays in this column. Because system calculations use this data for depreciation calculations, however, use caution if you change this column for an asset record once it has begun depreciating in the system.

(Book Name)Current Pd Depr

You should leave this column blank for a new asset record, unless you want to overwrite the system calculation of annual depreciation and you clear the (Book Name) Auto Calc check box.

For a new asset record, blanks normally display in this column. If you clear the (Book Name) Auto Calc check box and you manually entered a value in this column last period, this column should still display the manually entered value.

Note: If you manually change the current depreciation expense and then want to set it back to the system-calculated number, run the Compute Depreciation process again for that asset. This is especially important if the asset is using a Date of-Purchase basis depreciation method that is calculated based on days.

This column will be populated by the system when you calculate depreciation for this record, if the (Book Name) Auto Calc check box has been selected and the date in the (Book Name) Depr Start Date column is not a future date (that is, later than the end of the current period). (The current Fixed Assets period is specified on the Configure Posting Settings screen.) Manual entries and edits are always permitted in this column, regardless of the status of the (Book Name) Auto Calc check box and the date in the (Book Name) Depr Start Date column. However, manual entries and overwrites should be entered with caution.

For both new and historical records, data from this column is added by the system to the data from the (Book Name) FYTD Depr and (Book Name) Prior FY Depreciation columns to derive the (Book Name) Accum Depreciation column calculated total. When you close the current accounting period, the value in this column will be set back to zero unless you clear the (Book Name) Auto Calc check box.

You can perform depreciation calculations multiple times within the same Fixed Assets period. If you have made no manual corrections to critical columns (such as asset cost, annual depreciation, current depreciation year, periods remaining, and so on), there will be no difference in the depreciation amount recomputed.

Note: Changes can take place by means of manual overwrites in this column or as a result of depreciation calculations performed after changes have been made to other critical columns.

Current period depreciation expense is computed as a result of the Date of Purchase or Fiscal Year basis assigned to each depreciation method (established on the Manage Depreciation Methods screen).

Unlike the G/L Book, in which depreciation can be computed based on Years, Units of Usage, or Lease Pds, depreciation for all optional books used can be computed based only on Years.

The basic premise for depreciation calculations in which the 'catch-up' amount is allocated among remaining periods are as follows:

  • If you have linked a Date of Purchase basis for depreciation method with the asset, this column will display the annual depreciation expense less the amount taken this purchase year divided by the number of periods remaining in the calendar year.
  • If you have linked a Fiscal Year basis for depreciation method with the asset, this column will display the annual depreciation expense less the FYTD amount divided by the number of periods remaining in the fiscal year.
Note: Actual depreciation calculations may be more complex than the simplified explanation given, because you may have selected to use 'catch-up' depreciation calculations for the current period or to compute depreciation on a "days" basis.

For additional information on depreciation calculations, please refer to special topic, Calculate Depreciation.

Example

In the following simplified example, consider the basic differences in current period depreciation calculations for a $9,000 asset, useful life of five years, no salvage value, using straight-line depreciation, for both the FY and DP basis. For this example, the current fiscal year is CY 2002 the current Fixed Assets accounting period is 10, the number of accounting periods in the fiscal year is 12, and the start date is 10-01-02.

Item DP (Date Purchased) FY (Fiscal Year)
Asset Cost $ 9,000 $ 9,000
Annual Depreciation $ 1,800 $ 1,800
Current Pd Depr $ 150 $ 600
Note: The computed annual depreciation expense is identical for both the Date of Purchase and Fiscal Year basis. The current period depreciation expense, however, is different.

When you use the Date of Purchase basis for depreciation, the system divides the annual depreciation expense of $1,800 by the number of accounting periods remaining in the purchase year (12). One period of expense is charged for the current period, irrespective of the fiscal year. The depreciation year begins at the date in the Depr Start Date column (10-01-2002).

When you use the Fiscal Year basis for depreciation, the annual depreciation expense of $1,800 is divided by the number of accounting periods remaining in the fiscal year. In the example above, there are only three accounting periods remaining in the fiscal year over which to spread the annual depreciation cost of $1,800.

Note: The date in the (Book Name) Depr Start Date field does not influence the start of the depreciation year until the date window coincides with the current accounting period. If the end of the accounting period occurs before the depreciation start date, the system will not calculate depreciation for this record.

For both new and existing asset records, you can edit data that displays in this field, if needed, but make all edits with caution.

(Book Name) Accum Depreciation

The system totals the values from the (Book Name) FYTD Depr, (Book Name) Prior FY Depreciation, and (Book Name) Current Pd Depr columns and displays the result in this non-editable column.

(Book Name) Book Value

The system subtracts the value in the (Book Name) Accum Depreciation field from the value in the (Book Name) Amt to Depreciate field and displays the results in this non-editable field.

(Book Name) Amt Taken Purchase YTD

This column, along with data in the (Book Name) Curr Depr Yr and the (Book Name) Days/Pds Remaining columns, plays an integral role in the system calculation of depreciation for methods using the Date of Purchase basis.

This column displays the optional amount taken purchase YTD assigned to this record for this book, as applicable, when the asset was saved or edited in the Other Books Info subtask on the Manage Asset Master Information screen or on this screen.

This column is active only for depreciation methods that use the Date of Purchase basis. (You must select a Date of Purchase or Fiscal Year basis on the Manage Depreciation Methods screen when you set up each depreciation method.)

  • If the method from the (Book Name) Depr Method Code column on this screen references a method that uses a Date of Purchase basis, this column is active.
  • If the method from the (Book Name) Depr Method Code column on this screen references a method that uses a Fiscal Year basis, this column is not active.

For a new asset record, no data should display in this column because there has been no historical purchase year activity. You should leave this column blank for a new record, because the system will increment (or possibly decrement) the value in this column by the amount of depreciation posted each time the current Fixed Assets period is closed.

The value in this column will be different from the value in the (Book Name) FYTD Depr column except when the date of purchase coincides with the start of your fiscal year. The (Book Name) Amt Taken Purchase YTD column displays purchase year data, while the (Book Name) FYTD Depr column displays fiscal year data.

During the initialization of your historical records, for records linked to depreciation methods that use a Date of Purchase basis, you should enter the correct value in this column for the current purchase year of the asset. Please refer to special topic, Calculate Depreciation, for additional information on how to correctly initialize this column.

For both new and historical records, the system will change the value in this column by the amount of depreciation posted when the current accounting period is closed.

For both new and existing asset records, you can edit data that displays in this column. Because system calculations use this data to determine whether depreciation computations should take place for each record, and the manner in which they should take place, use caution if you change data in this column for property records once they have begun depreciating in the system.