Setting Up Depreciation Processing

This chapter provides an overview of depreciation processing and discusses how to:

Click to jump to parent topicUnderstanding Depreciation Processing

PeopleSoft Asset Management supports all common methods for depreciation processing and corresponds to Generally Accepted Accounting Principles (GAAP) and International Accounting Standards (IAS). Commonly-used depreciation functionality is delivered and ready to be personalized for your enterprise needs. How you define your depreciation processing here determines the depreciation calculation conventions, schedules, terms, and limits for your assets, as well as setup for compliance with periodic asset depreciation legislative and reporting requirements.

Some assets may be depreciated on an annul basis, while others accumulate depreciation monthly or quarterly. Defining depreciation calendars enables you to apply periodic depreciation allocations to assets.

Defining depreciation conventions enables you to establish the start date for asset depreciation. This is used in conjunction with an asset's placed-in-service date to calculate the correct depreciation amount for an asset.

A depreciation schedule is a special type of depreciation method. Depreciation schedules are tables specifying the percentage of depreciation expensed for each period and must be defined for assets using this treatment.

Depreciation terms are typically used in global environments where it is necessary to adjust depreciation calculations to meet local requirements.

Depreciation bonus definitions allow setup of federal or local legislation parameters. These definitions are assigned to assets or asset profiles for automated application of depreciation bonuses for qualifying assets. PeopleSoft delivers depreciation bonus definitions for prior legislation but also enables you to add and configure your own bonus definitions to meet new legislation or other needs that are specific to your organization.

Usually, depreciation limits are imposed by local taxing authorities. Defining depreciation limits enables you to apply the limits to assets accordingly.

Multi-shift codes are used in Germany to accelerate asset depreciation by specifying usage across multiple production shifts. Depreciation is increased as useful life is decreased. Enabling multi-shift codes applies this treatment to depreciation calculations.

In compliance with IAS and GAAP, PeopleSoft provides the option to stop the depreciation calculation in the event the salvage value of an asset exceeds that of its Net Book Value.

Click to jump to parent topicSetting Up Depreciation Calendars

To set up depreciation calendars, use the Detail Calendar (DETAIL_CALENDAR) component.

This section lists the pages used to define calendars for depreciation allocation.

Click to jump to top of pageClick to jump to parent topicPage Used to Set Up Depreciation Calendars

Page Name

Definition Name

Navigation

Usage

Calendar Periods - Depreciation

DETAIL_CALENDAR2

Set Up Financials/Supply Chain, Common Definitions, Calendars/Schedules, Detail Calendar, Calendar Periods, Depreciation

Define calendar periods for allocation of depreciation.

Click to jump to parent topicSetting Up Depreciation Conventions

To set up depreciation conventions, use the Depr Convention Builder (CONV_BLDR_PNLG), Depr Convention Definition (DEPR_CONVENTION), Depr Convention Multiple Copy (CONV_COPY_ALL_COMP), and Depr Convention Single Copy (CONV_COPY_PNLG) components.

This section provides an overview of depreciation conventions and discusses how to:

See Also

Processing Asset Depreciation

Understanding Depreciation Calculations

Click to jump to top of pageClick to jump to parent topicUnderstanding Depreciation Conventions

Depreciation conventions, in combination with an asset's placed-in-service date, determine when depreciation starts. For example, where a following month convention is used and an asset is placed in service on February 1, depreciation begins on March 1. PeopleSoft Asset Management delivers a wide selection of depreciation tables, including depreciation conventions. Before you set up your own Depreciation Conventions table, review the delivered tables to determine if you can use them as delivered or if modifications are required.

PeopleSoft Asset Management provides a series of pages that enable you to:

Click to jump to top of pageClick to jump to parent topicPages Used to Set Up Depreciation Conventions

Page Name

Definition Name

Navigation

Usage

Convention Builder

CONV_BLDR_PNL

Set Up Financials/Supply Chain, Product Related, Asset Management, Depreciation, Convention Builder

Create a depreciation convention. Generate depreciation conventions based on monthly accounting calendars.

Convention Definition

CONVENTION_DEFN

Set Up Financials/Supply Chain, Product Related, Asset Management, Depreciation, Convention Definition, Convention Definition

Modify a convention that you have built, or add a new convention and enter all the dates associated with it.

Note. It is recommended that you use the Convention Builder page to add a new convention.

Depreciation Convention Single Copy

CONV_COPY_PNL

Set Up Financials/Supply Chain, Product Related, Asset Management, Depreciation, Convention Single Copy

Copy one convention from a setID or calendar to another setID or calendar.

Depreciation Convention Multiple Copy

CONV_COPY_ALL_PAGE

Set Up Financials/Supply Chain, Product Related, Asset Management, Depreciation, Convention Multiple Copy

Copy all conventions associated with a setID or calendar to another setID or calendar.

Click to jump to top of pageClick to jump to parent topicGenerating Conventions

Access the Depreciation Convention page (Set Up Financials/Supply Chain, Product Related, Asset Management, Depreciation, Convention Builder, Convention Builder).

Period Options

Select Mid Period or Days. Use Daysto begin depreciation based on the value specified in the Begin Date field. Use Mid Period for mid-month and mid-quarter conventions.

Generate Options

This table summarizes how the system determines the begin depreciation date for each convention type, and indicates which fields can be overridden:

Convention Type

Begin Depreciation Date

Mid Month

15 appears by default for Which Day; the begin depreciation date is day 15 of the calendar period. You can override Which Day.

End of Month

Uses the end date of the month as the begin depreciation date. You cannot override this.

End of Quarter

Uses the end date of the quarter as the begin depreciation date. You cannot override this.

End of Year

Uses the end date of the year as the begin depreciation date. You cannot override this.

Following Month

Adds one day to the end day of the month, and identifies this as the begin depreciation date. You cannot override this.

Full Year

Uses the current day of the current month as the begin depreciation date. You cannot override this.

Half Year

1 appears by default for Which Day; 7 appears by default for Which Month, so day 1 of period 7 in the calendar is the begin depreciation date. You can override Which Day and Which Month.

Mid Quarter

15 appears by default for Which Day; 2 appears by default for Which Month, so day 15 of the second month in the quarter is the begin depreciation date. You can override Which Day only.

User Defined

No defaults are provided. Specify values for Which Day, Which Month, and Summary Periods.

Begin Depr Date Options

Enter the options for which to begin depreciation for those conventions that you can override:

Which Day

Enter the numerical day of the month when depreciation is to begin.

Which Month

Enter the numerical month when depreciation is to begin.

Summary Periods

Specify how many months will be grouped or summarized into one period of the year. For example, if the Summary Periods value is 1, there will be 1 month per 1 period and there will be a total of 12 periods in one year. If the Summary Periods value is 3, there will be 3 months in 1 period and there will be a total of 4 periods in one year.

An example of beginning depreciation date options is as follows:

Period

Begin Date

End Date

Begin Depr Date

Period 1

January 1, 2009

March 31, 2009

February 15, 2009

Period 2

April 1, 2009

June 30, 2009

May 15, 2009

Period 3

July 1, 2009

September 30, 2009

August 15, 2009

Period 4

October 1, 2009

December 31, 2009

November 15, 2009

Period 5 (next year)

January 1, 2010

March 31, 2010

February 15, 2010

Calendar Options

Full Calendar

Select to build conventions for all years. When selecting this option, the From Year and To Year fields are unavailable.

Portion of Calendar

Select to build conventions for the years that you specify. When selecting this option, supply the From Year and To Year fields.

Click the Generate button to build the conventions based upon the options that you selected.

Click to jump to top of pageClick to jump to parent topicModifying Conventions

Access the Depreciation Convention page (Set Up Financials/Supply Chain, Product Related, Asset Management, Depreciation, Convention Definition).

Select System Maintained to use standard depreciation conventions that are delivered with and maintained by the PeopleSoft system.

Note. You cannot enter the from date, to date, or the begin depreciation date for system-maintained depreciation conventions.

Click to jump to parent topicSetting Up Depreciation Schedules

To set up depreciation schedules, use the Depreciation Schedule Definition (DEPR_SCHEDULE_DEFN) component.

This section provides an overview of depreciation schedules and discusses how to define depreciation schedules.

Click to jump to top of pageClick to jump to parent topicUnderstanding Depreciation Schedules

There are several different methods for calculating depreciation. Each depreciation method is an equation by which depreciation is calculated. In most methods, the same equation is used to calculate depreciation for each period. A depreciation schedule is a special type of depreciation method. Depreciation schedules are tables specifying the percentage of depreciation expensed for each period. Currently, the PeopleSoft system delivers schedules (DEPR_SCHED_TBL system table) for the following standard IRS depreciation methods:

Note. Standard depreciation schedules cannot be used for short tax year processing. For short tax year processing, you need to set up special schedules that have the short tax year worked into them.

PeopleSoft Asset Management depreciation schedules are based on the percentage depreciation tables found in IRS Publication 534. You can modify existing depreciation schedules or add new schedules, by using the Depreciation Schedule page. On the Depreciation Schedules page, the method is DB150 with a switch to straight line. The in-service period for each year of the asset's life is the key to determining the percentage of depreciation allowed for any one year. For example, suppose that your organization runs on a monthly calendar and places an asset in service in January 1997. View Year of Life 1, In-Service Period 1 to find the percentage allowed in the first year; view Year of Life 2, In-Service Period 1 to find the percentage allowed for the second year, and so on.

Click to jump to top of pageClick to jump to parent topicPage Used to Set Up Depreciation Schedules

Page Name

Definition Name

Navigation

Usage

Depreciation Schedules

DEPR_SCHEDULE_DEFN

Set Up Financials/Supply Chain, Product Related, Asset Management, Depreciation, Schedules

Add or modify depreciation tables.

Click to jump to top of pageClick to jump to parent topicDefining Depreciation Schedules

Access the Depreciation Schedules page.

Specific Convention

Select to apply a particular convention. The page refreshes and displays the Convention list box from which to choose the depreciation convention.

Convention

This field appears when selecting the Specific Convention check box. Select the convention that you want to use.

Note. The schedule periods that you set up should reflect the periods set up in your calendar.

See Also

Understanding Depreciation Calculations

Processing Asset Depreciation

Click to jump to parent topicDefining Depreciation Terms and Rates

To set up depreciation terms, use the Terms Definition (DEPR_TERMS_DEFN) component, the Rate-User Defined (UD_DEPR_RATE) component, and the Period Allocation (RUN_AMCALLOC) component.

This section lists the pages used to set up depreciation terms and rates and discusses how to define depreciation terms.

Click to jump to top of pageClick to jump to parent topicPages Used to Define Depreciation Terms

Page Name

Definition Name

Navigation

Usage

Depreciation Terms

DEPR_TERMS_DEFN

Set Up Financials/Supply Chain, Product Related, Asset Management, Depreciation, Terms Definition

Enter terms to be applied to depreciation in a global environment. These terms are used to alter depreciation calculations so that they comply with specific country requirements. Terms defined at this level are available to be selected when you are specifying depreciation methods and when you have enabled global options.

Rate-User Defined

UD_DEPR_RATE_TBL

Set Up Financials/Supply Chain, Product Related, Asset Management, Depreciation, Rate-User Defined

Establish rates by useful life.

Life and Rate Information

MR_AM_LIFERATE

Click the Life and Rate Information button from the Rate-User Defined page.

View and update rate by useful life.

AM Period Allocation

RUN_AMCALLOC

Set Up Financials/Supply Chain, Product Related, Asset Management, Depreciation, Period Allocation, AM Period Allocation

Create depreciation expense allocation tables.

Click to jump to top of pageClick to jump to parent topicDefining Depreciation Terms

Access the Depreciation Terms page (Set Up Financials/Supply Chain, Product Related, Asset Management, Depreciation, Terms Definition, Terms Definition).

Depreciation terms are used to adjust depreciation calculations so that they comply with specific country requirements. Using additional terms affects how depreciation is calculated:

Term

Depreciation

Special

Depreciation x Rate

Accelerated

Depreciation x Rate

Initial

Cost x Rate

Increase

Depreciation x Rate

See Also

Processing Asset Depreciation

Understanding Depreciation Calculations

Click to jump to parent topicDefining Depreciation Bonus Information

To set up depreciation bonus information, use the Depreciation Bonus (AM_DEPR_BONUS) component.

Use the Depreciation Bonus component to define Depreciation Bonus values. Depreciation Bonus values are then selected at the Asset level or Asset Profile level for qualifying assets based on depreciation bonus legislation.

This section discusses how to define depreciation bonus information.

Click to jump to top of pageClick to jump to parent topicPage Used to Define Depreciation Bonus

Page Name

Definition Name

Navigation

Usage

Depreciation Bonus Info

AM_DEPR_BONUS_INFO

Set Up Financials/Supply Chain, Product Related, Asset Management, Depreciation, Depreciation Bonus, Depreciation Bonus Info

Modify the delivered Bonus Depreciation options, if necessary, or add new Bonus Depreciation values to accommodate depreciation bonus legislation changes.

Click to jump to top of pageClick to jump to parent topicDefining Depreciation Bonus Information

Access the Depreciation Bonus Info page (Set Up Financials/Supply Chain, Product Related, Asset Management, Depreciation, Depreciation Bonus, Depreciation Bonus Info).

Use the Depreciation Bonus Info page to add new depreciation bonus values or to modify existing values to accommodate new legislation. You are then able to assign the Depreciation Bonus definitions to assets or asset profiles.

See Adding Tax Information for the Book.

See Specifying Tax Attributes in a Profile.

Although PeopleSoft Asset Management delivers several depreciation bonus values based on prior legislation, the Depreciation Bonus component gives you the flexibility to create your own Depreciation Bonus definitions in order to accommodate individual organization needs as well as new legislative changes.

Depreciation Bonus

Select (or supply) the Depreciation Bonus value to modify or add a new Depreciation Bonus value. The value can be 0 to 9 or A to Z.

Use bonus percent range

Select this check box to use a range of bonus percent values. When selected, the Bonus Percent To field appears.

Bonus Percent

Enter the percent amount of the depreciation bonus to be applied to the book(s) for a given asset profile. The amount depends on the Depreciation Bonus type, the acquisition date and in service date of the asset as well as state or local application of the depreciation allowance. For example, if your state adopted the bonus depreciation as a percentage of the Federal percentage, the amount may be calculated as an amount other than the federally allowed percentage.

Acquisition & In-Service Dates

Use same date for both

Select this check box when the asset acquisition date range is the same as the in-service date range. When selected, only one row appears for Acquisition & In-Service date range.

Acquisition & In-Service From

Enter the first date of the allowable range from which the asset is to be acquired and in-service in order to take advantage of the depreciation bonus.

Acquisition Date to

Enter the end of the allowable acquisition date range in order to take advantage of the depreciation bonus. This field becomes Acquisition & In-Service To when the Use same date for both field is selected.

In-Service Date from and In-Service Date to

Enter the allowable in-service date range for assets to take be able to take advantage of the depreciation bonus. This row appears when the Use same date for both check box is deselected.

Click to jump to parent topicDefining Depreciation Limits

To set up depreciation terms, use the Limits (DEPR_LIMIT_DEFN) component.

Depreciation limits are used to specify the maximum amount of depreciation that you can expense on your assets for each year of life.

This section discusses how to define depreciation limits.

Click to jump to top of pageClick to jump to parent topicPage Used to Define Depreciation Limits

Page Name

Definition Name

Navigation

Usage

Depreciation Limits

DEPR_LIMIT_DEFN

Set Up Financials/Supply Chain, Product Related, Asset Management, Depreciation, Limits

Specify the maximum amount of depreciation that you can expense on your assets for each year of life. As a rule, depreciation limits are specified by tax authorities.

Click to jump to top of pageClick to jump to parent topicDefining Depreciation Limits

Access the Depreciation Limits page (Set Up Financials/Supply Chain, Product Related, Asset Management, Depreciation, Limits).

If you choose, you can use the delivered Depreciation Limit table to reduce the number of table setup tasks. PeopleSoft Asset Management delivers limits based on U.S. tax law. Currently, this defines depreciation limits for luxury automobiles.

See Also

Understanding Depreciation Calculations

Processing Asset Depreciation

Click to jump to parent topic(DEU) Setting Up Multi-shift Codes

To set up multi-shift codes, use the Multi-Shift Codes (MULTI_SHIFT_DEFN) component.

This section provides an overview of multi-shift codes and lists the page used to define multi-shift codes.

Click to jump to top of pageClick to jump to parent topicUnderstanding Multi-shift Codes

German businesses can accelerate their depreciation by specifying usage across multiple production shifts. This increases the depreciable amount and reduces the useful life. This functionality was developed to satisfy German asset accounting rules. You can do so by establishing codes for each additional shift that indicate the rate by which annual depreciation should increase. Once you have defined these codes, you can select them for assets as they are added to the system. When you run depreciation, the Depreciation (AM_DEPR_CALC) application engine applies the rates to the depreciation calculations. As annual depreciation increases, the useful life of an asset decreases.

The following tables show the effect of multi-shift codes on depreciation amounts and useful life. In the tables, the example assumes that the asset has a cost of 1,000 EUR, a useful life of 10 years, and an in-service date of January 1, 2001. The end depreciation date is December 31, 2010. It is being depreciated by using the Straight Line method.

Example Without Multi-shift Rates

The following table shows depreciation with no multi-shift rates applied.

Year

NBV

Number of Shifts

Factor

Depreciation Amount

Year 1

1000

1

0%

100

Year 2

900

1

0%

100

Year 3

800

1

0%

100

Year 4

700

1

0%

100

Year 5

600

1

0%

100

Year 6

500

1

0%

100

Year 7

400

1

0%

100

Year 8

300

1

0%

100

Year 9

200

1

0%

100

Year 10

100

1

0%

100

Example with Multi-shift Rates

In the following multi-shift operation, the Two Shifts Factor has been established as 50 percent and the Three Shifts Factor has been established as 100 percent. Annual depreciation therefore increases, and the asset's useful life decreases from ten years to seven years:

Year

NBV

Number of Shifts

Factor

Depreciation Amount

Year 1

1000

1

0%

100

Year 2

900

1

0%

100

Year 3

800

2

50%

150

Year 4

650

2

50%

150

Year 5

500

3

100%

200

Year 6

300

3

100%

200

Year 7

100

2

50%

100

Year 8

-

-

-

-

Year 9

-

-

-

-

Year 10

-

-

-

-

Example with Multi-shift Rates by Accounting Period

The next multi-shift operation demonstrates multi-shift rates by accounting period:

Year

Period

NBV

Number of Shifts

Factor

Depreciation Before Multi-shift

Depreciation After Multi-shift

Depreciation Periods

Year 1

01-12

1000

1

0%

100

100

12

Year 2

01-12

900

1

0%

100

100

12

Year 3

01-09

800

2

50%

75

112.50

13.5

Year 3

10

687.5

3

100%

8.33

16.66

2

Year 3

11

670.84

3

100%

8.33

16.67

2

Year 3

12

654.18

3

100%

8.33

16.67

2

Year 4

01-12

637.5

2

50%

100

150

18

Year 5

01-06

487.5

2

50%

50

75

9

Year 5

07-12

412.5

1

0%

50

50

6

Year 6

01-12

362.5

3

100%

100

200

24

Year 7

01-12

162.5

2

50%

100

150

18

Year 8

01-12

12.5

1

0%

12.5

12.5

1.5

Year 9

01-12

-

-

-

 

 

-

Year 10

01-12

-

-

-

 

 

-

Note. Zero or no accounting period denotes that the whole fiscal year uses the same number of shifts. Accounting period 1 to 13 indicates multi-shift operation applies only to that specific period. If you don't set up the fiscal year or accounting period, one shift operation appears by default.

Click to jump to top of pageClick to jump to parent topicPage Used to Set Up Multi-shift Codes

Page Name

Definition Name

Navigation

Usage

Multi-Shift Codes

MULTI_SHIFT_DEFN

Set Up Financials/Supply Chain, Product Related, Asset Management, Depreciation, Multi-Shift Codes

Enter rates by which depreciation should be increased based on the number of production shifts that an asset is used.

Click to jump to parent topicEnabling Options to Stop Negative Depreciation

This section provides an overview of the setup necessary to stop negative depreciation and lists the pages used to enable this option.

Click to jump to top of pageClick to jump to parent topicUnderstanding the Option to Stop Negative Depreciation

In compliance with International Accounting Standards (IAS) and Generally Accepted Accounting Principles (GAAP), PeopleSoft provides the option to stop the depreciation calculation in the event the salvage value of an asset exceeds that of its NBV. Based on the rules you establish at the Installation Option and Business Unit/Book levels, the depreciation calculation program stops depreciating assets when the NBV is less than the salvage value. Hence, the system does not create negative depreciation amounts in order to reach to the salvage value at the end of the asset's useful life.

It is important to understand that the depreciation program works at the ChartField level such that you can define a particular salvage value for one ChartField value but not for the other. For example, assume that an asset belongs to two different departments (X and Y, 40% and 60%, respectively) and the total cost of the asset is 62,000 USD. However, the salvage value could be zero for department X and 2,000 USD for department Y. The depreciation calculation generates depreciation for each department separately as two independent rows.

Enable the option to stop negative depreciation for the following:

The Asset Net Book Value report shows multi-ChartField assets that have had their depreciation stopped for at least one ChartField. You can select to show assets with negative NBV only and you can select to show assets whose NBV is less than the salvage value.

The alternate approach to handling an asset when the NBV of an asset becomes less than its salvage value is to allow the system to generate negative depreciation until the NBV equals the salvage value at the end of the asset's useful life. To use this approach, simply do not select the Stop Depr when NBV < Salvage options.

PeopleSoft also delivers a Negative Depreciation query (AM_NEG_DEPR_NBV_LT_SALVAGE) that reports those assets that have a NBV that is less than their salvage value for any given fiscal year and period. This query is based upon the depreciation reporting table (DEPR_RPT).

See Calculating Depreciation When Salvage Value Exceeds Net Book Value (NBV).

Click to jump to top of pageClick to jump to parent topicPages Used to Set Up the Stop Depreciation Option

Page Name

Definition Name

Navigation

Usage

Installation Options - Asset Management

INSTALLATION_AM

Set Up Financials/Supply Chain, Install, Installation Options, Asset Management

Select the Stop Depr when NBV < Salvage check box to enable the option system-wide.

Asset Management Definition - Business Unit/Book Feature

BU_BOOK_FEATURE

Set Up Financials/Supply Chain, Business Unit Related, Assets, Asset Management Definition, Business Unit/Book Feature

Select the Stop Depr when NBV < Salvage check box to enable the option at the business unit level.

Asset Net Book Value report (AMDP2100)

RUN_AMDP2100

Asset Management, Financial Reports, Cost and Depreciation, Asset Net Book Value, Parameters

Select to report assets with negative NBV only and assets with NBV < Salvage.

See Also

Defining Asset Management Installation Options

Defining Business Unit/Book Feature Options

Depreciation Reports