Setting Up a Depreciation Table

If the depreciation method for an asset is set to Table Depreciation in Asset Records (FAS), the depreciation calculation for the asset is based on a depreciation table. The table states the percentages to be applied for each year of the asset's life. This provides a flexible method of specifying depreciation.

Depreciation tables are particularly useful if you need to change the method or rate of depreciation for a given asset, part way through its life. A depreciation table can be defined with entries that reflect the depreciation that has been generated to date. The new depreciation rates can be defined for future years.

Depreciation tables can be printed on the Depreciation Tables Report.

Calculating Depreciation Using Tables

Using a depreciation table, the appropriate percentage is selected by taking the year for which depreciation is being calculated, subtracting the start depreciation year, and adding one year. The gross value of the asset is multiplied by the appropriate percentage to give the total depreciation for the financial year. Any discrepancies between the historic depreciation and what should have been calculated, are reported during Depreciation Calculation (FDC).

Note: There are limitations when reporting depreciation using tables. The depreciation must be posted at least once during each financial year.

Note: For assets configured with table depreciation, the depreciation calculation only posts amounts that are applicable to the current financial year. If, for some reason, less than the full year's depreciation was posted in the previous year, the unposted amount is not added to this year's depreciation calculation. In this circumstance you can either leave it as an unposted amount (thus causing a residual value at the end of the asset's useful life), or manually post the depreciation difference for the asset.