# I just found a new way of doing depreciation thought I would share

**URL:** <https://forum.manager.io/t/i-just-found-a-new-way-of-doing-depreciation-thought-i-would-share/15388>\
**Category:** Uncategorized\
**Created:** [April 10, 2018, 10:27pm UTC](https://forum.manager.io/t/i-just-found-a-new-way-of-doing-depreciation-thought-i-would-share/15388 "2018-04-10T22:27:03Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Wornout](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/wornout/32/19913_2.png) [@Wornout](https://forum.manager.io/u/Wornout)\
**Post date:** [April 10, 2018, 10:27pm UTC](https://forum.manager.io/t/i-just-found-a-new-way-of-doing-depreciation-thought-i-would-share/15388/1 "2018-04-10T22:27:03Z")

</div>

I have a couple custom fields in fixed assets  
Depreciation% where I put the Rate  
Months where I put how many months asset has been owned  
Depreciation Equation =((H2\*D2)/12)\*F2 which purchase cost X by rate and then divide it by 12 months and X by months.  
Then I right click on fixed asset screen and send to excel then I just drag down the equation to give me the years depreciation. shame I can not just import the depreciation amounts to manager I still have to put them in by hand into each asset.

 ![image](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/2X/d/d30b30cae9b582c46f17aaf7af600aa23a158303.png)

---

<div class="post-metadata">

**Author:** ![acecombat2](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/acecombat2/32/6638_2.png) [@acecombat2](https://forum.manager.io/u/acecombat2)\
**Post date:** [April 11, 2018, 7:12am UTC](https://forum.manager.io/t/i-just-found-a-new-way-of-doing-depreciation-thought-i-would-share/15388/2 "2018-04-11T07:12:24Z")

</div>

I think you can just retype of each asset depreciation amount as you tested one by one by following the computed amount… a bit of work but not tedious thought. unless there is a function of might available in excel to change it’s underlying text from formula to the computed calculation numerical numbers. it’s brilliant.

---

<div class="post-metadata">

**Author:** ![Wornout](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/wornout/32/19913_2.png) [@Wornout](https://forum.manager.io/u/Wornout)\
**Post date:** [April 12, 2018, 1:48am UTC](https://forum.manager.io/t/i-just-found-a-new-way-of-doing-depreciation-thought-i-would-share/15388/3 "2018-04-12T01:48:03Z")

</div>

got I coded it in vba and did a shortcut key from the keyboard so I can automate it shame we can not update with the depreciation amount with the date from excel to manager. I know lazy

---

<div class="post-metadata">

**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:** [January 18, 2023, 3:12pm UTC](https://forum.manager.io/t/i-just-found-a-new-way-of-doing-depreciation-thought-i-would-share/15388/4 "2023-01-18T15:12:03Z")

</div>