Exact Financials (v3)

Fixed Assets Manual - [Master data, Maintenance, General, Index tables]

[Master data, Maintenance, General, Index tables]

If a table already exists, all the years and corresponding percentages for the selected table are displayed.

Table

Enter a unique code for the table you are creating.

Year

Enter a sequence number for the year you want to include in the depreciation table. The number for the first year you entered, should always be 'one'. Create a sequence number for every year of the total number of depreciation years for each asset to be linked.

• The sequence numbers for the contigious years should increase with 1 and no gaps are allowed.

Percentage

Enter a percentage that will be used to depreciate your fixed asset for that year.

• If depreciation is based on a 100% depreciation, make sure that the total sum of the percentages entered equals 100%. For special occasions it is made possible you can enter more than 100% cumulatively.

Example

The following table is defined:

Year 1 : 20%

Year 2 : 15%

Year 3 : 10% etc.

This table is linked to the depreciation formula:

Depreciation costs per period = (Depreciation basis) * (percentage /12).

This formula means that during each period, i.e. month, a twelfth of that year's amount to be depreciated will be depreciated.

Finance Manual C/S > Contents > Working with fixed assets > Creating index tables > [Master data, Maintenance, General, Index tables]