Asset Depreciation Schedule Issue

ERPNext Asset Management
, , ,
1

Hi All,

I have a use case where I’m not able to Understand if the behaviour is a BUG or just different approach. For better understanding the details are here:

Method : Double Declining (DDB)
I have an Existing Asset with Gross 48,00,000/-
Available to User : 01-May-2025
Purchase Date : 01-May-2025

The Asset Category has 48 Depreciation Nos configured.

image
image772×349 22.2 KB

In Asset,
Opening Accumulated Depreciation and Opening Number of Booked Depreciations are taken as 4,00,000 and 2

image
image827×177 7.88 KB

Expected output is First 10 months with 2,00,000 Depreciation but system is actually giving below output and also calculating the Depreciation 12 time on current value instead of 10 time as 2 time Depreciation is already done.

image
image829×623 44.6 KB

When using DDB is this correct calculation ? Or the system is having a BUG.

Tested with ERPNext: v15.69.2 (version-15) and Frappe Framework: v15.73.0 (version-15)
Also
with old version
ERPNext: v15.29.3 and Frappe Framework: v15.34.1

2

it should calculate depreciation based on current book value… the depreciation amount looks wrong

image
image2034×800 62.5 KB

it should follow following table

Month Start Value Depreciation End Value Method Used
1 200,000.00 40,000.00 160,000.00 DDB
2 160,000.00 32,000.00 128,000.00 DDB
3 128,000.00 25,600.00 102,400.00 DDB
4 102,400.00 20,480.00 81,920.00 DDB
5 81,920.00 16,384.00 65,536.00 DDB
6 65,536.00 13,107.20 52,428.80 DDB
7 52,428.80 10,485.76 41,943.04 DDB
8 41,943.04 8,388.61 33,554.43 DDB
9 33,554.43 6,710.89 26,843.55 DDB
10 26,843.55 26,843.55 0.00 Adjusted
3

Thanks @Maveez for confirming. So then we can consider this as a BUG or is there an other alternative where we can manage .

4

better use manual method until its fixed. erpnext is using mixed method of depreciation where initially its updating higher depreciation values and later switching to straight line method (if you have monthly depreciation)

Since ERPNext applies the double declining rate on the opening book value for the year, then spreads it monthly.

Switch to a longer depreciation period, For very short lives, DDB behaves almost like straight line. Extending life to 2 years or more makes the declining effect clearer.

refer to same asset of 200K depreciated across multiple years

image
image1627×787 43.9 KB

5

Did this solve the concern???