Download the fixed asset schedule and calculate depreciation automatically as per the Companies Act 2013 without a fixed asset register. These are made as per current reporting requirements in India.
Well, if you are looking for a fixed asset register then, here it is. But if you just want to calculate the depreciation and prepare the Fixed asset schedule which is a part of financial statements (as notes to accounts) then you should check these out.
Download for the Financial year
FY 2014-15
FY 2015-16
FY 2016-17
FY 2017-18
FY 2018-19
FY 2019-20
FY 2020-21
FY 2021-22
UPDATE:
FY 2022-23
These sheets are designed to automate the process of depreciation to the maximum possible extent. Also, your fixed asset schedule is automatically ready. These will be of great help to those who want their financials ready without a fixed asset register. I cannot guarantee 100% accuracy therefore, it is better to cross-verify from other tools.
Hope you would find these helpful.
Please like, comment, and share!!!
CAN YOU ALSO PLEASE SEND DEPRECIATION IN SLM METHOD FOR F.YEAR 19-20
LikeLike
Hi friends, the depreciation calculator for FY 2019-20 and 20-21 is up and running. Do share and follow. Thanks for your support.
LikeLike
Why depreciation is negative in some assets
LikeLike
Where any asset is over depreciated under manual or old system of calculation, this utility reverses that effect to bring that asset to its residual value (i.e.5%). Over depreciated means depreciation of more than 95% is charged.
LikeLike
Its very helpful for me…thanks
LikeLike
In this sheet treatment of asset sold was not given. Plz suggest the formula for calculating dep on sold asset.
LikeLike
Hi, Sorry for the delay. I have uploaded a new version. You may download the new depreciation calculator and refer the ‘help’ tab for your problem.
LikeLike
When will the version for FY. 17-18 release?
LikeLiked by 1 person
It will be released within 4 days. Keep sharing and supporting this blog. Thanks!
Update: It is up.
LikeLike
Hi
Given calculator is very helpful. However following issues :-
1. Residual value is not being considered
2. Treatment of Sale of asset
Kindly clarify
LikeLike
1. Residual value of 5% is considered.
2. Sale of asset should be treated manually. Please refer ‘Help’ tab for more info on sale of asset (last dummy entry is an example of sale of asset).
LikeLike
It is being delayed because the .xlsm file is not supported for upload anymore and also .xlsx is showing same error. Will fix this and upload soon.
LikeLike
It’s up and running!
LikeLike
Very Useful.
LikeLiked by 1 person
Thank You, Mohinder!
LikeLike