Setting Up Depreciation Processing

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

Click to jump to parent topicUnderstanding Depreciation Processing

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 and to meet subsequent periodic asset depreciation 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 of 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.

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

Multishift 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 multishift codes applies this treatment to depreciation calculations.

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

Object 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. Asset Management is delivered with 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 is or if modifications are required.

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

Object Name

Navigation

Usage

Depreciation 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.

Depreciation Convention

CONVENTION_DEFN

Set Up Financials/Supply Chain, Product Related, Asset Management, Depreciation, 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.

System Maintained

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

Period Option

Select Mid Period or Days. Days to begin depreciation based on the value specified in the Which Day 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.

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

Access the Depreciation Convention page.

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.

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

Object 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.

Convention

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

Processing Asset Depreciation

Understanding Depreciation Calculations

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

Object 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.

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 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

Object 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.

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

See Also

Processing Asset Depreciation

Understanding Depreciation Calculations

Click to jump to parent topic(DEU) Setting Up Multishift Codes

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

This section provides an overview of multishift codes and lists the page used to define multishift codes.

Click to jump to top of pageClick to jump to parent topicUnderstanding Multishift 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 multishift 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 Multishift Rates

The following table shows depreciation with no multishift 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 Multishift Rates

In the following multishift 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 Multishift Rates by Accounting Period

The next multishift operation demonstrates multishift rates by accounting period:

Year

Period

NBV

Number of Shifts

Factor

Depreciation Before Multishift

Depreciation After Multishift

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 multishift 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 Multishift Codes

Page Name

Object 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 an asset is used.