By Cindy A B-Oracle on May 29, 2015
There are many variables that can affect the depreciation calculation for an asset. Some of the basic variables include:
- Depreciation method
- Date Placed in Service (DPIS)
- Prorate convention
- Prorate date
You can view these variables for an asset via the Financial Inquiry form and make changes to these via the Asset Workbench / Books form.
Additional factors in the calculation of depreciation for an asset include:
- Specifics of the depreciation method
- Depreciation calendar
- Depreciate when placed in service flag
- Dividing depreciation evenly or by days
- Other specifics of the prorate convention
- Prorate calendar
Some of the factors that seem to cause more confusion than others surround the allocation (divide evenly or by days) setting on the Book Controls form and the the prorate information.
If the book is set to divide depreciation evenly, the annual depreciation for the assets will be divided evenly over the number of periods in the fiscal year. If the book is set to divide daily, the annual depreciation will be divided based on the number of days of the periods in the fiscal year, with the amount of depreciation varying in each period. For sample calculations of depreciation using "Divide Depreciation By Days" (the less common scenario), review the Depreciation Methods White Paper found in Fixed Assets Depreciation Methods and Calculations With Examples (Doc ID 1179655.1). There are a number of examples using different parameters, starting on page 25. Look for those that use "Depreciation Allocation" = "Daily."
For prorates, the prorate calendar determines the number of prorate periods in your fiscal year. The depreciation program uses the prorate calendar to determine the prorate period, which is used to determine the annual depreciation amount. The prorate convention is used to determine how much depreciation to take in the first and last years of the asset's life. Together with the date placed in service (DPIS), the prorate convention helps to determine the prorate date. For example, if you use a prorate convention with a defined period of 1-JUN-2015 to 30-JUN-2015 and a corresponding prorate date of 30-JUN-2015, an asset with a DPIS of 16-JUN-2015 will start depreciating in the current month of June. If the prorate convention, instead, is set to a defined period of 1-JUN-2015 to 30-JUN-2015 with a prorate date of 01-JUL-2015, an asset with a DPIS of 16-JUN-2015 will start depreciating in the following month of July. Thus, the prorate date is tied to the DPIS, but the DPIS might not be when the asset starts depreciating. Examples of varying prorate setups can be found in the white paper in The Wonderful World of Prorate Conventions White Paper (Doc ID 115323.1)