Note! The depreciation functionality only works when there are 12 normal periods in the system.

Before filling in the depreciations and amortisations data for future periods, make sure that the following data has been filled in on the Basic data worksheet:

•Transaction year: Required for calculating the years to be depreciated.

•Transaction period: Required for calculating the first period to be depreciated.

•Data for allocations 1-n in section Allocations (for example Goodwill and fair value adjustments) (Eliminations of Equity Investments) / Entries to non-current asset values at transaction date (basis for future depreciation adjustments) (Eliminations of Internal Margins in Non-Current Assets).

When the Basic data worksheet is saved, a block is automatically created to the Depr_amort worksheet (the name of the worksheet may be different in your system) for each allocation row on the Basic data worksheet that has a value other than zero in a transaction column.

To fill in depreciations and amortisations data:

1.Enter the number of years to depreciate (1-50) to the Years to depreciate field in each transaction/allocation block for which you want to create a plan for depreciations.

2.Save the workbook. The years are generated to the Depreciations by period section and you can hide or show the rows of a depreciation plan by clicking -/+ next to the rows (to hide or show the rows of all depreciation plans, click 1 or 2 in the left top corner of the table).

3.Fill in the following data for each transaction/allocation block:

a)Current year; P&L Acc (costs): Add the ID of the Profit and Loss account (usually income statement account) used for depreciations recorded to the selected year.

b)Current year; BS Account: Add the ID of the balance sheet account used for depreciations recorded to the selected year.

c)Opening entries; Earnings (costs): Add the ID of the account used for depreciations recorded prior to the selected year (usually opening balance account).

d)Opening entries; BS account: Add the ID of the balance sheet account used for depreciations recorded prior to the selected year.

e)Deferred tax - Current year; P&L Acc (costs) (if Defta is selected in Basic data): Add the ID of the Profit and Loss account (usually income statement account) used for deferred tax depreciations recorded to the selected year

f)Deferred tax - Current year; BS Account (if Defta is selected in Basic data): Add the ID of the balance sheet account used for deferred tax depreciations recorded to the selected year.

g)Deferred tax - Opening entries; Earnings (costs) (if Defta is selected in Basic data): Add the ID of the account used for deferred tax depreciations recorded prior to the selected year (usually opening balance account)

h)Deferred tax - Opening entries; BS account (if Defta is selected in Basic data): Add the ID of the balance sheet account used for deferred tax depreciations recorded prior to the selected year. Enter the ID directly to the field or double-click to open the account selection list. The selection list also opens automatically if you enter an invalid ID. The list contains the input and rate difference accounts that are connected to selected data type.

4.Under Depreciations by period, enter the amount to depreciate for each year and period.

5.Save the worksheet before moving on to Creating Automatic Entries.