


Simply by using the below Tax Depreciation Calculator to estimate the depreciation available to you on your Investment Property. Recommendations of 50th meeting of GST Council.You could potentially be saving thousands of dollars on your Tax Return! How?.Security deposit foregone could not be claimed as revenue expenditure.Merger of Multiple User IDs in MCA V-2 Portal with new User ID in V-3 & deactivation of old ID.Requirement of compulsory filing of ITR even when income is not taxable.ABCAUS Excel Depreciation Calculator FY 2022-23 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.ĭepreciation Calculators for preceding years are as under: FY 2021-22

Similarly, Profit or loss on the disposal of assets should be reflected in profit and loss account. The calculator is meant to guide and help in calculating the depreciation, the disclosure requirements have to be separately taken care of.Īlso the WDV written off should be charged either to reserves and surplus or profit and loss account. This sheet must be filled after completing the ‘Opening sheet”.Date of purchase of disposed asset should be available as per depreciation chart prepared for FY 2014-15.If you have selected “yes” against any asset in column “f” in opening sheet, the same asset must be selected here.Only those assets which have been disposed off during FY 2022-23 should be selected under assets name list.This sheet accounts for any deletion that has been made out of the opening assets, (i.e.Please note that useful lives of assets can be altered from the sheet useful life.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”.For new additions made during the year, residual value has been taken 5% by default.For each new additions, first they should be created in ‘Assets” sheet.Rest of the values shall be calculated automatically.Depreciation Rate > The rate as calculated in FY 2014-15 should be filled.Estimated residual value > as estimated during FY 2014-15.If asset has been sold during FY 2022-23 > select Yes or No from drop down.If useful life zero as on > Select Yes or No.Remaining useful life > as per useful life as on minus three years.If useful life of the asset was zero as on it would be equal to the residual value. Depreciated value of asset as on (if using SLM).Name of assets > fill the “Asset Sheet” as per closing wdv list of FY 2021-22 and select by drop down.In the Opening WorkSheet, the following particulars are required to be given: Since, you must be having the individual asset-wise list of closing wdv as on or the depreciated value of the asset as on (for SLM purposes) creating this database should not be a problem. If for example there are multiple computers, they should be written in different rows as computer1, computer2…and so on. Please note that no two names should be identical. AssetsĪssets database should be created by providing names of the assets and by selecting the asset type as per schedule-II. In each part only “grey” fields are required to be filled. The calculator has been divided into five part as under: 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 ABCAUS Excel Depreciation Calculator FY 2022-23 under Companies Act 2013 Saving the file to your local computer disk
