Create Custom Depreciation Rate Schedules
Security:
Set Up: Business Asset Accounting
domain in the Business Asset Accounting functional area.Rate schedules enable you to define custom depreciation percentages for each period that assets depreciate.
You can use custom depreciation rate schedules as an alternative to Workday-owned depreciation methods when:
- No Workday-owned depreciation method fits your depreciation requirements.
- You anticipate you'll need to reassess the amortization or depreciation of assets during their useful life.
- Access theCreate Rate Scheduletask.
- As you complete the task, consider:
Option Description Usage CountDisplays how many depreciation profiles and asset book configurations use this rate schedule. You can delete rate schedules or edit period ranges on rate schedules only when their usage count is zero.Currency for Depreciable BasisDetermines the decimal precision for the sample depreciation expense lines.Depreciable BasisWorkday uses this amount to calculate the sample depreciation expense lines. - As you add rows for your depreciation period ranges, consider:
Option Description Depreciation Percentage for RangeEnter the total depreciation percentage between theFrom Periodand theTo Period.The depreciation percentages for all ranges must total 100.Periodic RateIllustrates the percentage of depreciation for 1 period based on the information that you enter.Sample Depreciation ExpenseIllustrates the depreciation expense for 1 period based on the information that you enter. This informational field doesn't reflect lifecycle events that you perform on assets.
To track intangible assets following a 3-year sales curve with an estimated amortization of 56% for the first year, 24% for the second year, and 20% for the third year, you create a rate schedule with these period ranges:
From Period | To Period | Depreciation Percentage for Range |
|---|---|---|
1 | 12 | 56% |
13 | 24 | 24% |
25 | 36 | 20% |
To populate rate schedules on assets:
- Create new depreciation profiles with a depreciation method ofRate Schedule.
- Update your asset book rules.
To change rate schedules on assets when you reassess their amortization or depreciation, access the
Adjust Asset
task. See Concept: Asset Accounting Tasks.