An Auditor’s Tool on Depreciation Calculation- Version 3.0 – Compliant to Schedule II of Companies Act 2013 : Financial Year 2015-16 to FY 2021-22 enabled – FREE Download
WHAT IS NEW- in this updated Version 3.0
1. Calculation of Depreciation enabled upto Financial Year 2021-22.
2. Consolidated (Summarised) Fixed Asset Register – enabled upto Financial Year 2021-22.
3. Consolidated Fixed Asset Register (itemised) for enabled upto Financial Year 2021-22 , akin to gross block concept.
4. Master Pivot Table enabled upto FY 2021-22
5. Minor bug fixes
The major features of this free utility includes:
1. Calculation of Depreciation and WDV from Fin Year 2015-2016 to Fin Year 2021-22.
2. Facility to calculate Depreciation based on useful live as per Schedule II to Companies Act 2013 or as per the own estimation of the User. – Available on an itemized basis
3. Consolidated (Summarised) Fixed Asset Register – enabled upto Financial Year 21-22 (NEW FEATURE)
4. Consolidated Fixed Asset Register (itemised) for Fin Year 2014-15 to 2021-22 including location wise details, akin to gross block concept.
5. Auto calculation of itemized depreciation for Assets as per Schedule II and subsequent years’ depreciation on itemized assets. – LIFE TIME DEPRECIATION CALCULATION of a Particular ASSET
6. The aspect of sale of fixed asset and the corresponding depreciation thereof also considered in this version, including for Fin Year 2014-15 and onwards.
7. Calculation of Depreciation and Written Down Value of Asset as per Reducing balance method(“WDV”) as well as SLM Method in the same sheet – on an item wise basis.
8. Master Pivot Sheet updated to provide overview of entire fixed asset at one single sheet with features to vividly show the entire presentation of Fixed Assets schedule on a year wise basis comprising off gross block, accumulated depreciation and closing WDV and its sub parts- including location wise segregation and drill down.
9. Instruction Manual for each of the Modules provided therein.
10. Embedded Facility to provide Location of Asset and Asset Identification Number / Code – Optional
11. Option for rounding off to desired level and option for acceptable margin of error.
12. Mini Calculator being snapshot acting as tool to cross check the depreciation of asset for its entire life by giving instant calculation of depreciation including for subsequent years figures.- THE MOST AMAZING FEATURE
13. The worksheet displays the expected date of expiry of assets considering the useful life as specified in Schedule II to Companies Act or on the basis of useful life on user’s own basis, whichever is so selected for the purpose of calculation.
14. Calculation of tentative date of addition for additions made before 31st March 2014. – THE MOST AMAZING FEATURE
15. Facility to choose higher or lower useful life of the assets for the old assets as well as new assets w.e.f .1.4.2014 or even in subsequent year (s). In case of such change in useful life a warning message will appear in the respective sheet.
16. Facility to choose higher or lower Residual value (“salvage Value”) of the assets for the old assets as well as new assets w.e.f. 1.4.2014 or even in subsequent year.
17. Users can directly copy data from the earlier version _and paste the data in the current version.
18. Standalone Calculator for Old Assets at Old Rate showing the year-wise figures of Depreciation, WDV from inception till 31.3.2014 (and also for subsequent yrs at old rate) on WDV as well as SLM.
19. Version 3.0 is enabled for calculations upto Financial Year 2021-22.
Note- “ OLD ASSETS” – refers to assets purchased on or before 31st March 2014;
“ NEW ASSETS” – refers to assets purchased on or after 01st April 2014;
Link to Latest Version of Depreciation Calculator Version 3.0 is given at the end of Article.
In case of any inconsistency or clarification/ suggestions, kindly contact us
CA Pawan Kumar Agarwal & CA Amitesh Agarwal | C/o Madanlal & Associates, Chartered Accountants, Kolkata | Email: madanlalassociates@gmail.com | Mobile: 9830262464; 9830459297.
(Republished with amendments)
Author Bio
could have been a little simple, seems like too many promotions pushed in
DEAR SIR
Please send Depreciation Current Year Working sheet for Private Limited Company for the Financial Year 2022-2023.
Dear Sir,
Please Provide Depreciation Working sheet of Private Limited Company for the Financial Year 2022-2023.
Your Depreciation Calculation tools (25.5.21 Ver 3 Depreciation Calculator Sch II Companies Act 2013 an Auditors Tool) is very useful for us.
With Regards
Jitendra Shrivastava
BHILAI (CG)
Dear Sir, Please Provide Depreciation Working sheet for Private Limited Company for the Financial Year 2022-2023.
With Regards
Bhavesh Jungi
Dear Sir, Please Provide Depreciation Current Year Working sheet for Private Limited Company for the Financial Year 2022-2023.
With Regards
Jitendra Shrivastava
Please send Depreciation Current Year Working sheet for Private Limited Company for the Financial Year 2022-2023.
With Regards
Jitendra Shrivastava
No able to download inspite of several attempts.
Please try out, it is being downloaded. In case you are again unable please check your harware configuration
sir, the link is not working. probably there may be some problem in inserting the link in the article. you also please try by using some other computer and check it. Many of the readers have faced this problem
Dear Sir,
To Download kindly login on Taxguru at below link-
https://taxguru.in/wp-login.php
Really appreciate the efforts put in by your office team. Really useful tool.
Link sent for activation is not working. Please suggest.
NOT DOWNLOADING
Kindly retry. The size of the file being big and also there being traffic to download, it is taking some time to download. Hence someone may requre two- three aatempts to download.
Presently being downloaded from TaxGuru site.
Even after registering profile, I am not able to download Dep Calculator. Need Help!!
Kindly retry. The size of the file being big and also there being traffic to download, it is taking some time to download. Hence someone may requre two- three aatempts to download.
Presently being downloaded from TaxGuru site.
Small Bug Found in Version 3.0 has been resolved at 5 pm of 25th May 21, users are requested to kinldy download afresh –
FROM CA G.DUBEY
CAN NOT DOWNLOAN
Kindly retry downloading the same.
After downloading ,its prompting for password
The password will be dusplayed after you feel up the Google form lying therein
cannot dowload
Kindly check now.
First you have to login then only it can be downloaded. Olny registered persons can download it. Search for the place where you can login to taxguru
unable to download depreciation calculator even after registration how 2 downaload kindly guide how 2 download after registration
Kinldy check now. Download Error resolved
THANK YOU VERY MUCH. IT IS A GREAT TOOL AND YOUR EFFORTS ARE MARAVAKES
Thnaks
not able to download dep calculator on clicking download free
Kindly recheck now. Download issue resolved
Dear sir,
Please send Depreciation Current Year Working sheet for Private Limited Company wise
Please download the version 3.0 enabled upto 31.3.2022
sir kindly help us in editing the same.
I have got the access, but it says the worksheet is protected. Unprotect the same.
No need to unprotect the sheet, kindly fill up the data in the permitted columns and all the calculations etc will be made and displyaed automatically by the utility
I WANT TO CONTINUES WITH YOU SIR FOR MORE UPDATES
KAMAL CHASND CHORDIYA
9587435947
7597977389
New Version 3.0 release on 23 May 2021
Thank you very much
can not download your free depreciation calculator- schedule II as per companies Act.
Thanks for this utility. Its of great help. Would like to mention one bug I am facing. In the ” new asset” sheet, the column ” no: of days put to use” delivers “#value” when i input date of addition. Please suggest a solution.
Please write the date in the format as suggested in the instruction manual
dear all i found that said utility although takes a whlile to download , but is o IMMENSE HELP .
If you are facing problem in auto downloading the above calculator, you may click on the “download manually tab” given at download option by taxguru.
Be patient file size is big- but the utility it gives us is massive.
Alternatively, fill up the contact form at the below link to downlaod the said free utility from the dropbox link provided by the developer:
goo.gl/forms/0fnAAMtAvGPHR6GJ3