Try the sheet here, on the example
The sheet is open below with sample numbers. Change any white cell and watch the results update, or press the blank-copy button to type your own data from scratch. Nothing you type leaves your browser.
Example from the sheet
| As of date | 46356 | Change the report year, the as-of date and the declining balance factor on the Settings sheet. | |||
|---|---|---|---|---|---|
| Report year | 2026 | Depreciation expense, report year | 23,702.75 | ||
| Assets in totals | 12 | Fully depreciated assets | 1 | ||
| Cost of assets in use | 187,800.00 | Assets not yet bought | 1 | ||
| Accumulated depreciation | 107,137.97 | Disposals in report year | 1 | ||
| Net book value | 80,662.03 | Gain or (loss) on those disposals | 3,500.00 | ||
| Category | Assets | Cost | Accumulated depreciation | Net book value | Expense, report year |
| Computers | 3 | 12,800 | 9,647 | 3,153 | 2,538 |
| Furniture | 2 | 11,000 | 5,617 | 5,383 | 1,175 |
| Vehicles | 1 | 32,000 | 25,040 | 6,960 | 3,378 |
| Machinery | 4 | 92,400 | 39,934 | 52,466 | 10,613 |
| Office equipment | 1 | 3,600 | 3,400 | 200 | 0 |
| Leasehold improvements | 1 | 36,000 | 23,500 | 12,500 | 6,000 |
Example from the “Summary” tab, with the numbers and formulas that are in the file.
What is inside
- Summary: Cost, accumulated depreciation and net book value of the assets in use on your as-of date, the report-year expense, fully depreciated and not-yet-bought assets, disposals in the year and their gain or loss, a table by category and by year, and three charts.
- Assets: The register: ID, description, category, purchase date, cost, salvage value, life, method, disposal date and sale proceeds. It adds months in service, accumulated depreciation, net book value, the expense for the report year, a status and the gain or loss on disposal. Room for 100 assets.
- Schedule: Every asset across 10 calendar years starting with the report year: the depreciation expense for each year, a total, and the net book value at each year end, with column totals on top.
- Settings: Company name, currency symbol, report year, the as-of date, the declining balance factor and your list of asset categories (up to 8).
- Calc: A working sheet with the months in service and accumulated depreciation at every year end. Nothing to type there.
The file opens on a start tab (“Start here”) that explains how to use it.
What makes it different
Many depreciation templates calculate one asset at a time or only whole years. This one is a full register: it depreciates month by month from the purchase month, stops at the disposal month, never takes an asset below its salvage value and shows the book value of the whole fleet at any date. The sample is a small workshop with 14 assets, including one sold in 2026, one fully depreciated and one planned for 2027.
How do I calculate depreciation in Excel?
For straight-line, take cost minus salvage value and spread it evenly over the useful life: (cost - salvage) / (life x 12) per month in this sheet. The 1,800 laptop with a 200 salvage value and a 4-year life loses 1,600 over 48 months, so 400 a year.
For declining balance, the annual rate is the factor divided by the life (a factor of 2 is double declining balance). Each month the rate is applied to what is left of the book value, so the charge is biggest in year one, and the asset stops at its salvage value. The sheet works this out in one formula from the purchase date, so you do not build a table row by row.
What is a fixed asset register and what goes in it?
A fixed asset register is the list of the things your business owns and uses for more than a year: vehicles, machinery, computers, furniture, fit-out. For each you keep an ID, description, category, purchase date, cost, salvage value, life and method, and what happened to it if it was sold or scrapped.
On the sample as of 2026-11-30, 12 assets are in use with a cost of 187,800, accumulated depreciation of 107,137.97 and a net book value of 80,662.03. The expense for 2026 across all assets is 23,702.75.
How do I record the sale of a fixed asset?
Type the disposal date and the sale proceeds on the asset's row (leave proceeds empty if it was scrapped). The sheet depreciates it up to the disposal month, compares the book value at that point with the proceeds, and shows the gain or (loss). In the sample, the pickup truck bought in 2019 is sold in September 2026 for 7,500 when its book value is down to its 4,000 salvage value, a gain of 3,500.
Depreciation methods, lives and rates for tax are set by your local rules and your accountant, so check them before using any figure here in a return. Once the register is in place, compare it with your running costs in the business expenses budget.
How to use it
- On the Settings sheet type your company name, the year you are reporting on, the "as of" date for accumulated depreciation and book values, and the declining balance factor. List your asset categories below.
- On the Assets sheet enter one asset per row: ID, description, category, purchase date, cost, salvage value, useful life in years and method (Straight-line or Declining balance).
- If an asset is sold or scrapped, type the disposal date and the sale proceeds (leave the proceeds empty for a scrapped asset).
- The grey columns calculate by themselves: months in service, accumulated depreciation, net book value, depreciation for the report year, status, and gain or loss on disposal.
- Open Schedule for the depreciation expense and the year-end net book value of every asset over 10 years, starting with the report year.
- Open Summary for totals as of your date, a breakdown by category and charts of expense and book value.
Before you start:
- Capacity: 100 assets and 8 categories. The Schedule covers 10 years starting with the report year, on a calendar-year basis.
- Depreciation is monthly and starts in the month of purchase (a full month, whatever the day). If your policy differs, enter the purchase date that matches it.
- Straight-line: (cost - salvage) / (life x 12) per month until the life ends. Declining balance: the annual rate is factor / life, applied each month to the remaining book value, and an asset never goes below its salvage value.
- A disposed asset is depreciated up to and including the month of disposal, then stops. Gain or loss = sale proceeds - book value at disposal.
- Totals on Summary count assets that have been bought by the "as of" date and not yet disposed of. The report-year expense includes every asset depreciated in that year.
- Depreciation methods, rates and lives for tax are set by local rules and your accountant. The sample lives and salvage values are illustrations only; check your local rules.
Still running this on Excel?
This sheet depends on someone entering journal entries accurately and reviewing them. In ProfAcc, double-entry postings are made automatically, periods are closed, and the financial statements are produced directly from the entries.
| In this sheet | In ProfAcc — Manufacturing Accounts |
|---|---|
| Changing any cell can alter the numbers of a period that has ended. | Correct double-entry from day one, with automatic posting and period closing that locks what has been closed. |
| Tax is calculated in one place and invoices live in another. | Every sales invoice calculates VAT within the journal entry that records it. |
| You only learn the stock balance after the month-end count. | Stock balances are live and move with every posting. |
| One file per company you serve, and the files can get mixed up. | Each company is created from a Google account in about a minute with nothing to install, its data is kept separate, and it is reached through its own link. |
Frequently asked questions
Is this depreciation schedule template free?
Yes. Download it, use it for your business and change anything you like. There is nothing to sign up for to open the file.
Which depreciation methods does it support?
Straight-line and declining balance, with a factor you set (2 for double declining balance, 1.5 for 150%). If the method cell is empty the asset is treated as straight-line.
Does it use full-year or monthly depreciation?
Monthly, starting in the month of purchase as a full month. If your policy is different, enter the purchase date that matches your policy. Check your local rules for how tax depreciation is timed.
Can I use it for tax depreciation such as MACRS?
No. It uses straight-line and declining balance for management and book accounts. Tax systems often use their own tables and conventions, so ask your accountant or check your local rules.
How many assets can it hold?
100 assets and 8 categories, with the 10-year schedule for every asset. When the register is full, save a copy and start a new one with the net book values carried forward.
Is the template free?
Yes, with no sign-up and no email address. Use it, edit it and share it as you like.
Does it work in Google Sheets and on mobile?
The sheet uses formulas supported by Excel 2016 and later, Google Sheets and LibreOffice, so you can upload it to Google Drive and open it with Google Sheets on a computer or a phone.
What is the difference between the white and the gray cells?
You type in the white cells; the gray cells are calculated automatically. Don't type in a gray cell, or you will erase its formula.
Can I use the sheet from an AI assistant?
Yes. Add our MCP server (URL https://softwiro.com/api/mcp, no key needed) to your assistant and ask it to do the calculation in this template. The numbers come from the sheet's own formulas, and we do not store your data. The steps and a ready-made prompt are in this article: https://softwiro.com/blog/mcp-excel-templates-ai-agent-guide.html
More free templates for: Accounting
More free templates
- Cash Flow Forecast Template for Excel (12 Months)
- General Journal and Trial Balance Template for Excel
- Small Business Budget Template for Excel (Monthly)
- Annual Department Budget Template for Excel (Budget vs Actual)
- Customer Statement Template with Aging (Excel)
- Gym Membership Tracker for Excel
- Freelance Project and Invoice Tracker for Excel
- Event Planning Checklist and Budget Template for Excel
- Fleet Fuel and Maintenance Log Template for Excel
- Ad Performance Tracker for Excel (ROAS, CPA)
- A/B Test Log Template for Excel (Experiment Tracker)
- Ecommerce Profit Margin Calculator for Excel