Fixed asset depreciation schedule generator
Build a complete depreciation schedule for one asset — by financial year and by month, with a part-year first year when it goes into service mid-year — and download it as an Excel workbook or CSV.
Asset
Rate: 20.00% of the depreciable amount a year (1 ÷ 5 years). Depreciation runs Apr 2026 – Mar 2031.
Delivery van — depreciation schedule by financial year
| Financial year | Months | Opening book value | Depreciation | Accumulated | Closing book value |
|---|---|---|---|---|---|
| 2026 Jan 2026 – Dec 2026 | 9 | $30,000.00 | $4,050.00 | $4,050.00 | $25,950.00 |
| 2027 Jan 2027 – Dec 2027 | 12 | $25,950.00 | $5,400.00 | $9,450.00 | $20,550.00 |
| 2028 Jan 2028 – Dec 2028 | 12 | $20,550.00 | $5,400.00 | $14,850.00 | $15,150.00 |
| 2029 Jan 2029 – Dec 2029 | 12 | $15,150.00 | $5,400.00 | $20,250.00 | $9,750.00 |
| 2030 Jan 2030 – Dec 2030 | 12 | $9,750.00 | $5,400.00 | $25,650.00 | $4,350.00 |
| 2031 Jan 2031 – Dec 2031 | 3 | $4,350.00 | $1,350.00 | $27,000.00 | $3,000.00 |
Each year of the asset’s life is charged with the method’s annual amount and spread evenly over its 12 months; the months are then grouped into your financial years. Figures are rounded to cents and the last month of each asset year absorbs the rounding. This is book (accounting) depreciation — tax depreciation (capital allowances, MACRS, prescribed WDV rates) follows local rules, so confirm tax treatment with your accountant.
How to create a depreciation schedule
Four steps. Every number is an input you control, and nothing leaves your browser.
Enter the asset name, cost, salvage value and useful life in years.
Choose straight-line, WDV/reducing balance (with your rate), DDB or sum-of-years’-digits.
Enter the in-service month, the month your financial year ends and the first-year convention.
Review the yearly or monthly schedule, then download it as Excel or CSV.
What you need to know
A depreciation schedule lists, for every period of an asset’s life, its opening book value, the depreciation charge, accumulated depreciation and closing net book value. This generator builds that schedule for any fixed asset. Enter the cost, salvage (residual) value and useful life, choose straight-line, reducing balance (written-down value, WDV, at your own rate), double-declining balance or sum-of-the-years’-digits, then set the month the asset went into service and the month your financial year ends.
Real assets rarely start on the first day of a financial year. With the monthly pro-rata convention, depreciation starts in the in-service month: each year of the asset’s life gets the method’s annual charge, spread evenly over its 12 months, and the months are grouped into your financial years — so a van bought in April with a July–June year gets three months of depreciation in its first year, and the remainder in the year after its life ends. Choose the full-year convention instead if your policy charges a full year in the year of purchase. Switch the table between the yearly and the monthly view.
Download the schedule as an Excel workbook — yearly and monthly sheets whose running totals are live formulas, plus an inputs sheet — or as CSV. Everything runs in your browser. Use the depreciation calculator for a quick year-by-year comparison of methods; use this generator when you need the full schedule for your books. Results are book (accounting) depreciation; tax rules such as capital allowances, MACRS or prescribed WDV rates differ, so confirm tax treatment with your accountant.
Ready to move beyond the calculator?
On the Business plan, Asetavo depreciates your whole register every month — compute a draft run, review it, then post it.
- Straight-line, reducing-balance, DDB, SYD, units, MACRS and UK capital allowances
- Separate book and tax schedules — tax runs never change book NBV
- Excel and CSV export of every run
Questions, answered
Ready to account for every asset?
Tag, track and audit everything you own — from a handheld scanner to a boardroom report.
No card required · Workspace ready in minutes · Simple USD pricing
