ABCAUS Excel Depreciation Calculator FY 2021-22 under Companies Act 2013 -Download

ABCAUS Excel Depreciation Calculator FY 2021-22 under Companies Act 2013 as per Schedule-II Version 06.15

The maiden ABCAUS Excel Companies Act 2013 Depreciation Calculator was first launched in March, 2015. 

The ABCAUS Depreciation calculator for FY 2021-22 has also been formulated and styled the same way as its predecessor so that users find themselves familiar with it.

This calculator is meant for companies following April to March Financial year. Also the calculator is meant only for tangible assets. Like, in last year useful life of the assets purchased during the FY 2021-22 is taken in integers only.

Any error or suggestions may please be reported at info@abcaus.in

Alternatively, users may subscribe to ABCAUS Newsletter to know the coming updates. Click Here >>

ABCAUS Excel Depreciation Calculator FY 2021-22under Companies Act 2013

Saving the file to your local computer disk

Please note that while downloading this utility save it as either Excel 97-2003 (xls) or Macro Enabled sheet in Excel 2007 or later versions (.xlsm) Only

save excel calculator 

How to use this calculator?

The calculator has been divided into five part as under:
(a) Assets
(b) Opening Details
(c) Additions
(d) Opening Deletions, and
(e) Depreciation Chart
In each part only “grey” fields are required to be filled.

Assets

Assets database should be created by providing names of the assets and by selecting the asset type as per schedule-II. Please note that no two names should be identical. If for example there are multiple computers, they should be written in different rows as computer1, computer2…and so on.

Since, you must be having the individual asset-wise list of closing wdv as on 31/03/2021 or the depreciated value of the asset as on 31/03/2014 (for SLM purposes) creating this database should not be a problem.

Please note that new assets purchased during FY 2021-22 should also be filled in this database. Again, please bear in mind that they should also be unique and not bear an identical name to an existing asset.

For example:

You have opening wdv of the block furniture individually for each asset (say, “furniture1”, “furniture2”, “furniture3”) and if during FY 2021-22 there is another addition to the block furniture, then a new nomenclature (say, “furniture4”) should be used in the asset sheet. In the “new addition sheet” this new furniture “Furniture4” is required to be selected for calculating depreciation on new additions.

Opening Balances:

Since the users must be having individual asset wise closing wdv as on 31/03/2021, the details required in the opening sheet should be filled using the wdv list as on 31/03/2021.

For SLM purposes, depreciated book value of the assets should be filled in column B.

In the Opening WorkSheet, the following particulars are required to be given:

  • Name of assets > fill the “Asset Sheet” as per closing wdv list of FY 2020-21 and select by drop down
  • Depreciated value of asset as on 01/04/2014 (if using SLM)
  • WDV as on 01-04-2021 > as per closing wdv list of FY 2020-21. If useful life of the asset was zero as on 01/04/2014 it would be equal to the residual value.
  • Remaining useful life > as per useful life as on 01/04/2014 minus three years
  • If useful life zero as on 01/04/2014 > Select Yes or No
  • If asset has been sold during FY 2021-22 > select Yes or No from drop down
  • Estimated residual value > as estimated during FY 2014-15. By default it was taken 5%
  • Depreciation Rate > The rate as calculated in FY 2014-15 should be filled
  • Rest of the values shall be calculated automatically
  • Date of format should be dd/mm/yyyy
  • No field should be left blank.

Additions made during the year

  • Date of format should be dd/mm/yyyy
  • For each new additions, first they should be created in ‘Assets” sheet.
  • For new additions made during the year, residual value has been taken @ 5% by default.
  • If any disposal has been made out of additions during the year, its details must be filled in columns ‘f” and “g” after selecting “Yes” in column “e”
  • Please note that useful lives of assets can be altered from the sheet useful life.

Opening-Deletion

  • This sheet accounts for any deletion that has been made out of the opening assets, (i.e.; out of opening sheet)
  • Only those assets which have been disposed off during FY 2021-22 should be selected under assets name list.
  • If you have selected “yes” against any asset in column “f” in opening sheet, the same asset must be selected here
  • Date of format should be dd/mm/yyyy
  • Date of purchase of disposed asset should be available as per depreciation chart prepared for FY 2014-15.
  • This sheet must be filled after completing the ‘Opening sheet”

Depreciation Chart
It should be automatically calculated.

See Video Tutorial:

The calculator is meant to guide and help in calculating the depreciation, the disclosure requirements have to be separately taken care of.

Also the WDV written off should be charged either to reserves and surplus or profit and loss account.

Similarly, Profit or loss on the disposal of assets should be reflected in profit and loss account.

ABCAUS Excel Depreciation Calculator FY 2021-22  under Companies Act 2013

Please note that by downloading the ABCAUS depreciation calculator, you agree to the terms of use that you do not have permission to modify, copy, edit, upload, reproduce, republish, distribute or transmit the utility except with the written prior approval. 

depreciation calculator FY 2021-22

Depreciation Calculators for preceding years are as under:

FY 2020-21 Click Here to download
FY 2019-20 Click Here to download
FY 2018-19 Click Here to download
FY 2017-18 Click Here to download
FY 2016-17 Click Here to download

read latest abcaus posts

----------- Similar Posts: -----------

130 Comments

  1. Jagu D Solanki June 14, 2022
    • administrator June 14, 2022
  2. Jagu D Solanki June 7, 2022
    • administrator June 14, 2022
  3. Esakkiammal June 6, 2022
  4. Esakkiammal May 24, 2022
    • administrator May 27, 2022
  5. Jagu D Solanki May 18, 2022
  6. Jagu D Solanki May 10, 2022
    • administrator May 10, 2022
  7. Satyam Jaju October 2, 2020
  8. Krishna Padhi September 3, 2020
    • administrator September 12, 2020
  9. ESAKKIAMMAL June 17, 2020
    • administrator June 17, 2020
  10. ESAKKIAMMAL May 12, 2020
    • administrator May 12, 2020
      • ESAKKIAMMAL May 13, 2020
  11. santosh R September 12, 2019
  12. Dip Trivedi May 18, 2019
    • administrator May 18, 2019
  13. SIDDAPUR DISTILLERIES LIMITED May 2, 2019
  14. Jagu Solanki April 26, 2019
  15. EsakkiammL April 18, 2019
    • administrator April 18, 2019
  16. Aarya Karande August 30, 2018
  17. Vikas June 12, 2018
  18. A ESAKKIAMMAL June 2, 2018
    • administrator June 2, 2018
  19. Pawan Makhija May 31, 2018
    • administrator May 31, 2018
  20. shashi shankar April 14, 2018
    • shashi shankar April 18, 2018
      • administrator April 18, 2018
      • shashi shankar June 2, 2018
        • administrator June 2, 2018
  21. Jagu March 14, 2018
  22. VIHANG SHAH November 21, 2017
  23. CA. G. Mishra October 13, 2017
  24. CA. G. Mishra October 12, 2017
  25. Mahesh Kumar Rathi August 29, 2017
  26. JAYAKUMAR May 10, 2017
  27. jagu May 9, 2017
  28. Gopi Chand May 7, 2017
  29. J Mohan April 17, 2017
    • administrator April 19, 2017
  30. rajesh March 24, 2017
  31. administrator September 6, 2016
    • Khush May 19, 2018
  32. LATHA August 7, 2016
  33. Aditya Picha July 23, 2016
  34. Aditya Picha July 22, 2016
  35. Aditya Picha July 21, 2016
    • administrator July 21, 2016
      • Aditya Picha July 22, 2016
  36. Anupama Srinivas July 11, 2016
    • administrator July 11, 2016
  37. Sandeep Mandal July 10, 2016
  38. Madan Mohan July 9, 2016
    • administrator July 9, 2016
  39. Latha July 9, 2016
  40. Latha July 8, 2016
    • administrator July 8, 2016
  41. Rajesh Choudhary July 2, 2016
    • administrator July 2, 2016
  42. Dipankar June 30, 2016
    • administrator June 30, 2016
  43. Madan Mohan June 29, 2016
  44. Vijay Kumar Sharma June 28, 2016
  45. SHARAD SINGHAL June 25, 2016
    • administrator June 25, 2016
  46. administrator June 22, 2016
  47. Bhadresh Sanghavi June 22, 2016
  48. K V VENKITARAMAN June 17, 2016
  49. Latha Nair June 9, 2016
  50. Shiva Chandra June 8, 2016
  51. shilpa May 28, 2016
  52. NAGESH May 26, 2016
  53. Surya Shanker Mishra May 24, 2016
  54. Rounak May 23, 2016
    • administrator May 25, 2016
  55. Sridevi May 18, 2016
    • administrator May 18, 2016
  56. SHUBHAM May 18, 2016
  57. P.P.rajan May 14, 2016
  58. sovenjit sarkar May 9, 2016
    • admin May 9, 2016
  59. ercan May 9, 2016
  60. SANJEEV SHUKLA May 7, 2016
  61. Shubham May 7, 2016
  62. Dhriti Jain May 3, 2016
  63. ASIF DADANI May 3, 2016
  64. ASIF DADANI May 3, 2016
  65. Mansheet Singh April 29, 2016
    • administrator April 29, 2016
  66. RITESH GANDHI April 29, 2016
  67. RITESH GANDHI April 28, 2016
  68. Jayakumar April 27, 2016
  69. DEBJANI DAS April 26, 2016
  70. Vishal April 26, 2016
  71. SANJEEV SHUKLA April 25, 2016
  72. Jayakumar.M April 22, 2016
  73. administrator April 21, 2016
    • s.sivashankar June 2, 2016
  74. Bapuji April 21, 2016
  75. NILESH VYAS April 21, 2016
  76. ARJUN KUMAR April 16, 2016
    • administrator April 16, 2016
      • ARJUN KUMAR April 18, 2016
        • vasu April 20, 2016
  77. Paresh Soni April 16, 2016
  78. OMPRAKASH SHUKLA April 16, 2016
  79. administrator April 15, 2016
  80. OMPRAKASH SHUKLA April 15, 2016
  81. Ravi Joshi April 15, 2016
    • Parankush Tiwari June 9, 2016
  82. Janmesh Mehta April 15, 2016
  83. administrator April 13, 2016
  84. administrator April 12, 2016
    • rajes r pitalia April 13, 2016
  85. Rajesh Pitalia April 11, 2016
  86. ajay jethva April 9, 2016
    • ajay jethva April 3, 2018
      • administrator April 3, 2018
  87. Kamlesh kumar April 5, 2016
  88. Aarthi.P March 26, 2016
    • administrator March 26, 2016
      • SANJEEV SHUKLA May 20, 2016
      • parwinder February 23, 2017
    • RAJAN ASSOCIATES November 7, 2016

Leave a Reply