Depreciation Calculation

The year and period by which the depreciation calculation will start depends on the period type used by the accounting ledger used by the depreciation type.

To illustrate:

A fixed asset worth 12000 was purchased and activated on 20230920.

The fixed asset was connected to depreciation types 10 (updates the local accounting ledger) and 20 (updates the corporate accounting ledger).

An adjustment of 1000 was posted on depreciation type 10 and 2000 for depreciation type 20.

Both depreciation types use 1-'Linear' and lifetime was set to 10 years (120 periods).

Depreciation type 10
Description Value type Remarks
Purchase value type 1 12000
Total acquisition cost 10 12000
Adjustment - local 19 1000
Planned depreciation 11 13000
Depreciation type 20
Description Value type Remarks
Purchase value type 1 12000
Total acquisition cost 10 12000
Adjustment - corporate 20 2000
Planned depreciation 21 14000
Depreciation plan for depreciation type 10
Period Cur Fixed asset value FA value local Vtp Remaining value
202309 EUR 108.33 108.33 11 12,891.67
202310 EUR 108.33 108.33 11 12,783.34
202311 EUR 108.33 108.33 11 12,675.01
202312 EUR 108.34 108.34 11 12,566.67
202401 EUR 108.33 108.33 11 12,458.34
202402 EUR 108.33 108.33 11 12,350.01
202403 EUR 108.33 108.33 11 12,241.68
202404 EUR 108.33 108.33 11 12,133.35
202405 EUR 108.33 108.33 11 12,025.02
202406 EUR 108.33 108.33 11 11,916.69
: : : : : :
203306 EUR 108.33 108.33 11 216.69
203307 EUR 108.33 108.33 11 108.36
203308 EUR 108.36 108.36 11 0

Depreciation plan for depreciation type 20

Period Cur Fixed asset value FA value local Vtp Remaining value
202309 EUR 108.33 108.33 11 12,891.67
202310 EUR 108.33 108.33 11 12,783.34
202311 EUR 108.33 108.33 11 12,675.01
202312 EUR 108.34 108.34 11 12,566.67
202401 EUR 108.33 108.33 11 12,458.34
202402 EUR 108.33 108.33 11 12,350.01
202403 EUR 108.33 108.33 11 12,241.68
202404 EUR 108.33 108.33 11 12,133.35
202405 EUR 108.33 108.33 11 12,025.02
202406 EUR 108.33 108.33 11 11,916.69
: : : : : :
203306 EUR 108.33 108.33 11 216.69
203307 EUR 108.33 108.33 11 108.36
203308 EUR 108.36 108.36 11 0

Year-to-date Depreciation

The year-to-date depreciation will update the sequence number, fixed asset transaction, accounting ledger, voucher type, and accounting date which are automatically set in the fixed asset value per period table.

Table 1.
FA transaction Period Ser Vouch no
AP100000050 203307 P07 217161
AP100000050 202309 P07 217161
GL010000050 202309 P11 11026
GL010000100 202406 P20 222109
FA100000050 202409 P10 231011
FA100000100 202406 PD2 232002
(Continuation of Table 1)
Name Vtp Name Rcd Voucher type
AP10510 1 Purchase Cost 0 0
AP10510 10 Total Acq Cost 0 0
UPDATE 19 Adj Local 0 1
UPDATE 29 Adj Corp 0 2
FA10L1 12 10-YTD 0 1
FA10C1 22 20-YTD 0 2

If the depreciation type is not connected to the general ledger, fixed asset transaction, accounting ledger, and accounting date are still updated in FFAHIS.

Table 2.
FHSEQ7 FHFATR FHVONO FHAIT1 FHAIT2
20230921000000050 AP100000050 217161 P21541 P1020
20230921000000100 AP100000050 217161 P21541 P1020
20230921000000150 GL010000050 11026 P21541 P1020
20230921000000200 GL010000100 222019 P21541 P1020
20230921000000250 FA100000050 231011 P28110 10
20230921000000300 FA100000100 232002 P28120 20

(Continuation of Table 2)

FHAIT7 FHVSER FHVPER FHFAVA FHVOTP FHALDG FHACDT
FA70550 P07 202309 12000 0 0 20230921
FA70550 P07 202309 12000 0 0 20230921
FA70550 P11 202309 1000 1 1 20230921
FA70550 P20 202406 2000 2 2 20230921
FA10500 P10 202309 108.33 1 1 20230930
FA10500 PD2 202406 116.67 2 2 20230930
Related topics