Depreciation Schedule Generator
One fixed asset register in, two correctly-shaped schedules out — Companies Act books and Income Tax Act blocks, plus the difference between them.
How it works
- Pick the financial year and your default method (SLM or WDV).
- Drop in your fixed asset register — CSV, Excel, or PDF.
- Confirm each asset category once — this sets the useful life (books) and tax rate (Income Tax Act) used.
- Get an asset-wise books schedule and a block-wise tax schedule, plus the timing difference, downloadable as an Excel workbook.
Why two schedules instead of one?
Books depreciation (Schedule II, per asset, SLM or WDV, day-wise pro-rata) and tax depreciation (Income Tax Act, per rate block, WDV with the 180-day rule) are genuinely different computations with different useful lives and different rates — that's not a limitation of this tool, it's how Indian depreciation actually works. The gap between the two totals is the number that typically feeds a deferred tax working.
How does the tool decide the useful life and tax rate for each asset?
Every asset is matched to one of about a dozen common categories (Furniture, Plant & Machinery, Computers, Motor Vehicles, and so on), each pre-filled with the Schedule II useful life and Income Tax Act block rate for that category. You confirm the category for each distinct label in your file once — not per asset row — and can override the useful life, rate, or residual value for any individual asset if your facts differ from the default.
What's deliberately out of scope?
Two things this tool won't silently approximate: Schedule II's extra depreciation for double/triple-shift plant, and a tax block that goes negative because disposals during the year exceeded its value (that's short-term capital gain territory, not ordinary depreciation) — both need a professional's judgement on facts this tool doesn't have, so they're flagged for manual review instead of computed.
What format does my fixed asset register need to be in?
CSV, Excel, a Tally masters XML export (Fixed Assets ledgers), or a PDF schedule all work. Only an asset name and one value column are actually required — either the original cost, or just a current/closing value if that's all your export has. Category, dates, and opening WDV are all optional and auto-detected where present, with a column-matching step if they can't be. A PDF is read positionally (no fixed template — any tabular layout with a row-numbered asset list works), so it's the most best-effort of the four formats; if it doesn't pick up your table correctly, exporting CSV or Excel instead will always be more reliable.
Is my asset data uploaded anywhere?
No — every file you drop in is parsed and computed entirely in your browser using JavaScript. Nothing about your assets, costs, or values is ever sent to a server.