A real Excel register: Schedule II lives pre-loaded, SLM/WDV formulas that pro-rate on days and stop at residual, the 180-day rule and block of assets built in.

One register, both Acts — Schedule II lives already in it, formulas that cannot go negative, the 180-day split done for you, and the deferred-tax line at the bottom.

v2.1 — Office paste note updated after Microsoft shipped a fix.

AI tools for chartered accountants · income tax tools

AI tools for chartered accountants

Fixed Asset Register + Schedule II Depreciation Workbook

by CA Karan Gupta

One register, both Acts — Schedule II lives already in it, formulas that cannot go negative, the 180-day split done for you, and the deferred-tax line at the bottom.

Last statutory update: 29 Sept 2026 — v2.1 — Office paste note updated after Microsoft shipped a fix.

Statutory context

Companies Act, 2013 Schedule II Part C useful lives (27 classes) with NESD flags. Income-tax block of assets under s.33 of the Income-tax Act, 2025 with Appendix I rates (13 blocks) and the 180-day split. SLM and WDV floored at residual value. Rules carried from the live schedule2-depreciation-web tool and re-verified 6 September 2026. Confirm the live Schedule II and Appendix I before you sign the schedule.

Open the tool

The workspace opens on tools.cakarangupta.com so site login and browser storage stay isolated. Print and local downloads work in the tool itself.

Book a consultation

Feedback