Excel
based automatic depreciation calculator for computing depreciation for
financial year 2014-15 under the companies act, 2013.
This is just another superb
creation by CA Ashutosh Lohani
from Lucknow. LINK….
This
calculator aims to provide a help in computing depreciation for financial year
2014-15 as per the
provisions of Schedule-II. It is meant for small companies having not more than 15-20 assets type and following April to March Financial year and using WDV Method of Depreciation. Also the calculator is meant only for tangible assets.
provisions of Schedule-II. It is meant for small companies having not more than 15-20 assets type and following April to March Financial year and using WDV Method of Depreciation. Also the calculator is meant only for tangible assets.
Please note that “Completed Years” have been calculated by
rounding down the years to the nearest integer Since this calculator is a beta
version, any error can be reported at info@abcaus.in
How to use this calculator?
The calculator has been
divided into four part as under:
(a) Opening Details
(b) Additions
(c) Opening Deletions, and
(d) Depreciation Chart
(a) Opening Details
(b) Additions
(c) Opening Deletions, and
(d) Depreciation Chart
In each part only “grey” fields are required to
be filled.
1. Opening Balances:
In the Opening Balance Sheet, the following
particulars are required to be given:
of the assets as on 31-03-2014 are required to be given.
(a) WDV as on 31-03-2014
(b) Date of Purchase/use
(c) If the asset was sold in FY 2014-15, Select “Yes” or “No” from the drop down menu
(d) Residual Value as on 01-04-2015
(a) WDV as on 31-03-2014
(b) Date of Purchase/use
(c) If the asset was sold in FY 2014-15, Select “Yes” or “No” from the drop down menu
(d) Residual Value as on 01-04-2015
Date of format should be dd/mm/yyyy
If a block of assets consist of different assets each having a different date of purchase or use, the wdv as on 31-03-2014 of the block concerned should be broken down based on date of purchase/use.
If a block of assets consist of different assets each having a different date of purchase or use, the wdv as on 31-03-2014 of the block concerned should be broken down based on date of purchase/use.
If an assets has been sold during FY 2014-15, it must also be
reflected so in “Opening-Deletions” sheet
Residual value of the asset is required to be filled. Please
note that Note No. 05 to Part-C of Schedule-II restricting the residual value
to 5% of the original cost of the asset has been omitted. However it may be
kept that way.
Rest of the information should be calculated automatically.
2. Additions made during the
year
Date of format should be dd/mm/yyyy
If any disposal has been made out of additions during the year,
its details must be filled in columns ‘e” and “f” after selecting “Yes” in
column “d”
3. Opening-Deletion
This sheet accounts for any deletion that has been made out of the
opening assets, (i.e.; out of opening sheet The carrying amounts and date of
purchase should be selected out of drop down menu.
This sheet must be filled after completing the ‘Opening sheet”. For any subsequent changes in “opening sheet”, carrying amount and date of purchase must be reselected from the drop down list.
Original price/carrying amount of asset sold:
This sheet must be filled after completing the ‘Opening sheet”. For any subsequent changes in “opening sheet”, carrying amount and date of purchase must be reselected from the drop down list.
Original price/carrying amount of asset sold:
For sale of assets that have been bought during the year, original
price should be given. For sale of assets out of opening block, carrying amount
as on 31-03-2014 should be given.
4.
Depreciation Chart
Assets should be selected from the drop down
list and rest should be automatically calculated.
-
See more at:
http://abcaus.in/companiesact2013/excel-depreciation-calculator-companies-act-2013-scheduleii-download.html#sthash.NQlUEd4e.jNycCEkz.dpuf
No comments:
Post a Comment