# Depreciation Calculation Worksheet Improvement **URL:** \ **Category:** Uncategorized\ **Created:** [April 15, 2022, 12:02pm UTC](https://forum.manager.io/t/depreciation-calculation-worksheet-improvement/40591 "2022-04-15T12:02:02Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![Panashe\_Mlambo](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/panashe_mlambo/32/27658_2.png) [@Panashe\_Mlambo](https://forum.manager.io/u/Panashe_Mlambo)\ **Post date:** [April 15, 2022, 12:02pm UTC](https://forum.manager.io/t/depreciation-calculation-worksheet-improvement/40591/1 "2022-04-15T12:02:02Z")
I am calculating depreciation using the depreciation worksheet but for new assets it is using the start date per report range ![dwc-01](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/0/0/00da8ab9c72b45f7f3fbf496ad5a27c6a7dc2fb6.png) The challenge here is that new assets will be depreciation from the start date given on the report. If possible, why not include in the logic of the calculation a formula that looks whether the start date given on the report is earlier than the purchase, if earlier then calculate days from the date of purchase. ---
**Author:** ![Patch](https://avatars.discourse-cdn.com/v4/letter/p/a183cd/32.png) [@Patch](https://forum.manager.io/u/Patch)\ **Post date:** [April 15, 2022, 12:14pm UTC](https://forum.manager.io/t/depreciation-calculation-worksheet-improvement/40591/2 "2022-04-15T12:14:02Z")
The current depreciation worksheet uses a straight line approximation of residual value (exponential) depreciation. The straight line approximation only equals the exponential depreciation when calculated for one year. So to use it you need to create a new worksheet for each financial year. ---
**Author:** ![Panashe\_Mlambo](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/panashe_mlambo/32/27658_2.png) [@Panashe\_Mlambo](https://forum.manager.io/u/Panashe_Mlambo)\ **Post date:** [April 15, 2022, 12:25pm UTC](https://forum.manager.io/t/depreciation-calculation-worksheet-improvement/40591/3 "2022-04-15T12:25:29Z")
Thank you for your response. I am not sure if you understood what I am asking for. Let say for example my financial year starts on the 01 March 2021 and ends on the 28 Feb 2022. When I run my report I will select the corresponding dates. If I bought an asset, lets say on the 1st of June 2021, the worksheet does not take it account that in the list of assets its calculating depreciation some were bought during the year. It will simply calculate for the whole period. I am suggesting that in its logic, it should then look for such assets, if found then it should calculate depreciation from date of purchase. ---
**Author:** ![Patch](https://avatars.discourse-cdn.com/v4/letter/p/a183cd/32.png) [@Patch](https://forum.manager.io/u/Patch)\ **Post date:** [April 15, 2022, 12:34pm UTC](https://forum.manager.io/t/depreciation-calculation-worksheet-improvement/40591/4 "2022-04-15T12:34:57Z")
There are many ways the current implementation could be expanded. To use the current implementation you need to [https://www.manager.io/guides/25021](https://www.manager.io/guides/25021) > [@](#): > > A separate worksheet must be created beginning on the date of acquisition of the new asset, running through the end of the accounting period. If assets are acquired on staggered dates, several worksheets might be required for a single accounting period. ---
**Author:** ![Panashe\_Mlambo](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/panashe_mlambo/32/27658_2.png) [@Panashe\_Mlambo](https://forum.manager.io/u/Panashe_Mlambo)\ **Post date:** [April 15, 2022, 1:07pm UTC](https://forum.manager.io/t/depreciation-calculation-worksheet-improvement/40591/5 "2022-04-15T13:07:42Z")
Multiple reports may be a work around for the meantime but If one has bought many assets during the year the option may be time consuming. Maybe this issue may need to be moved to the ideas so that it maybe considered in future. It will save time. One does not have to go into the asset register to look for the purchase date of each asset bought and then create multiple reports to cater for that. ---
**Author:** ![Tut](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/tut/32/3286_2.png) [@Tut](https://forum.manager.io/u/Tut)\ **Post date:** [April 15, 2022, 1:23pm UTC](https://forum.manager.io/t/depreciation-calculation-worksheet-improvement/40591/6 "2022-04-15T13:23:07Z")
Implementation of automatic depreciation and amortization calculations is currently very limited, almost to the point of unusability. The developer promised improvements long ago, but localizations to comply with legal requirements seem to have taken precedence. Personally, I would not consider the automatic calculations suitable for wide usage. ---
**Author:** ![Panashe\_Mlambo](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/panashe_mlambo/32/27658_2.png) [@Panashe\_Mlambo](https://forum.manager.io/u/Panashe_Mlambo)\ **Post date:** [April 15, 2022, 1:31pm UTC](https://forum.manager.io/t/depreciation-calculation-worksheet-improvement/40591/7 "2022-04-15T13:31:26Z")
> [@Tut](#): > > The developer promised improvements long ago, but localizations to comply with legal requirements seem to have taken precedence. I see. Maybe there is a way to get it implemented with the localisations. I will try to play around with the report transformations to see if I can get something working that can then be implemented on South African localisation file. ---
**Author:** ![Tut](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/tut/32/3286_2.png) [@Tut](https://forum.manager.io/u/Tut)\ **Post date:** [April 15, 2022, 2:19pm UTC](https://forum.manager.io/t/depreciation-calculation-worksheet-improvement/40591/8 "2022-04-15T14:19:20Z")
Please do not waste your time, @Panashe_Mlambo. Depreciation and amortization calculations are a worldwide need. Localizations include only features specific to a single country. Furthermore, report transformations are only reorganizations of existing reports. Improvement of depreciation and amortization capabilities will require new routines within the program. ---
**Author:** ![Panashe\_Mlambo](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/panashe_mlambo/32/27658_2.png) [@Panashe\_Mlambo](https://forum.manager.io/u/Panashe_Mlambo)\ **Post date:** [April 15, 2022, 2:21pm UTC](https://forum.manager.io/t/depreciation-calculation-worksheet-improvement/40591/9 "2022-04-15T14:21:10Z")
Noted with thanks. > [@Tut](#): > > Please do not waste your time ---
**Author:** ![Ealfardan](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/ealfardan/32/63166_2.png) [@Ealfardan](https://forum.manager.io/u/Ealfardan)\ **Post date:** [July 5, 2026, 8:13pm UTC](https://forum.manager.io/t/depreciation-calculation-worksheet-improvement/40591/10 "2026-07-05T20:13:40Z")
Uncategorized topics older than 3 years with no recent activity