Free Depreciation Schedule Spreadsheet Template for Google Sheets & Excel
Fourteen rows for the assets you own, each with a cost, a purchase date and a useful life, and the annual straight-line charge falling out of cost divided by life. The Free Depreciation Schedule spreadsheet template totals the cost of the asset base and the yearly charge in a strip above the register, and leaves the asset names as free text. One working sheet, Google Sheets or Excel. No macros, no VBA, no sign-up.
The FinancialAha Free Depreciation Schedule Spreadsheet Template is a one-sheet workbook for Google Sheets and Excel, with a How to Use guide on a second tab. It works as a Free Depreciation Schedule Excel template and a Free Depreciation Schedule Google Sheets template from the same download. This Free Depreciation Schedule spreadsheet template lists your assets with what each cost, when it was bought, how long it is expected to last and the annual charge against it. That last figure is worked out for you - cost divided by useful life, on a straight-line basis. No macros, no VBA, no sign-up.
Inside the workbook
What's inside the FinancialAha Free Depreciation Schedule spreadsheet template
The FinancialAha Free Depreciation Schedule Spreadsheet Template runs on a single working sheet, with the instructions on a tab of their own. It works in both Microsoft Excel and Google Sheets and here is what the Free Depreciation Schedule spreadsheet holds.
01of 01
Depreciation
A row per asset, each with a name, the date it was bought, what it cost, the years of life you expect from it, and the annual depreciation charge. A strip above totals the cost of everything on the sheet and the yearly charge across it, which is the figure that goes into a set of accounts.
One thing to be clear about before you rely on it: the annual charge is worked out for you, as cost divided by useful life, rounded to whole currency. There is no salvage value column, though - so if an asset is expected to be worth something at the end of its life, that has to come out of the cost before it goes in. The Essentials build takes a salvage value directly, and carries the accumulated total and remaining book value alongside.
Depreciation
Included guide
How to Use
A step-by-step guide on its own tab, covering how to replace the sample values and how to change the currency. Because it ships inside the file, the instructions travel with the template wherever it is opened.
Works in both Google Sheets and Excel
Free Depreciation Schedule Spreadsheet template for Google Sheets
Upload the Free Depreciation Schedule Spreadsheet Template to Drive, right-click it, and choose "Open with Google Sheets". This Free Depreciation Schedule Google Sheets template needs no conversion step and nothing gets rewritten on the way in - the totals recalculate exactly as they do in Excel. The currency dropdown beside the title relabels the money columns, and the whole Free Depreciation Schedule spreadsheet is small enough to open instantly.
Free Depreciation Schedule Google Sheets template setup
A shared copy of the Free Depreciation Schedule Google Sheets template suits a business and its bookkeeper working the same asset list, where one records purchases and the other confirms the charge. Sheets version history covers a figure typed over.
Sharing the Free Depreciation Schedule Google Sheet
This is not a daily sheet. The Free Depreciation Schedule Google Sheet is updated when an asset is bought or disposed of, and read at the end of a period when the annual charge is needed.
Free Depreciation Schedule Spreadsheet template for Excel
The Free Depreciation Schedule spreadsheet Excel download is a plain .xlsx. Excel opens this Free Depreciation Schedule Excel template directly, with no import step and no compatibility prompt. There are no macros and no VBA in the file, so it opens without a security warning.
Free Depreciation Schedule Excel template setup
The same Free Depreciation Schedule Excel template opens in Excel on Windows, Excel on Mac, and Excel for the web. It is also the identical file you would upload to Drive, so there is no separate Free Depreciation Schedule spreadsheet download to choose between.
The Free Depreciation Schedule spreadsheet Excel file carries no macros and no VBA, so Excel opens it without a trust prompt - which matters when a schedule is being sent to an accountant whose system blocks macro-enabled attachments.
Opening the Free Depreciation Schedule spreadsheet Excel file
Nothing in the Free Depreciation Schedule Excel template is version-specific, so this Free Depreciation Schedule spreadsheet Excel workbook behaves identically in Excel on Windows, Excel on Mac, and older builds.
The FinancialAha Free Depreciation Schedule Spreadsheet Template lists your assets a row each, works the annual charge out as cost divided by life, and totals both. What it does not do is take a salvage value, carry an accumulated total or report a remaining book value. The Essentials Depreciation Schedule Spreadsheet Template for Google Sheets and Excel calculates the charge from the cost, the salvage value and the life, works the accumulated depreciation from the purchase date in whole completed years, and carries the remaining book value on every asset, with a dashboard and a chart setting cost against book value.
Notes on working in the Free Depreciation Schedule spreadsheet template
The annual charge is worked out for you - cost divided by useful life, rounded to whole currency.
A life left blank or set to zero returns nothing rather than an error.
There is no salvage value column, so the figure is cost over life rather than cost less salvage over life.
The purchase date is recorded but not used in any calculation, so a part-year of ownership is yours to prorate.
Both this and the Essentials build are straight-line. Neither offers declining balance, sum-of-years-digits or a tax recovery method.
The dropdown beside the title relabels the cost and depreciation columns. It changes the label and nothing else.
How the Depreciation Schedule template works
The Free Depreciation Schedule Spreadsheet Template lists your assets with what each cost, when it was bought, how many years of life you expect from it, and the annual charge against it. A strip above totals the cost of the asset base and the yearly charge across it, which is the figure that goes into a set of accounts. The annual charge is worked out for you on a straight-line basis - cost divided by useful life, rounded to whole currency. What the sheet does not take is a salvage value, so the figure is cost/life rather than (cost - salvage)/life.
When this template helps
01
You want a written asset register rather than figures scattered across invoices.
02
Your accountant has asked for a list of fixed assets and what is being charged on each.
03
You want the total annual charge in one place at period end.
04
You would rather keep a file than pay for fixed-asset software.
Tips to get the most out of it
Anything expected to be worth something at the end needs that taken off the cost before it goes in, since there is no salvage column.
The strip totals the asset base beside the yearly charge across it, which is the figure that goes into a set of accounts.
Because the charge follows the life, testing a different life is a single edit per asset.
Common mistakes to avoid
Depreciating the full cost of something with real residual value. Without a salvage column that has to come out of your own arithmetic.
Charging a full year on an asset bought in the last quarter. Nothing here prorates from the purchase date.
Treating a useful life as a settled fact. What is reasonable, and what a tax authority accepts, are different questions and both belong with your accountant.
How to Use the Free Depreciation Schedule Spreadsheet Template
1
List your assets
One row per item, named as you would recognise it.
2
Record cost and date
What was paid, and when the asset was acquired.
3
Assign a useful life
How many years you expect it to be useful.
4
Read the annual charge
Worked out for you as cost divided by useful life - nothing to type there.
We use Claude AI to draft each template, after a deep research. Then our team steps in. We refine the layout, stress-test every formula, fix edge cases, and polish the design until it feels like something we would actually use ourselves. The AI gets us 80% there. The last 20% is all human judgment.
Excel
Sheets
No signup
Download instantly, no email required
Formula-driven
All calculations update automatically
Dual compatible
Works in Excel and Google Sheets
Sample data included
See the template in action right away
Frequently Asked Questions
What is the difference between the free and Essentials Free Depreciation Schedule spreadsheet template?
Free is a single-sheet starter template with sample data and a How to Use guide. Essentials ($19) is the fuller build - more capacity, more detail, and more worked out for you rather than typed. This template has no Ultimate build. What each tier holds differs by template - the comparison table on every template page lists it exactly.
Which Free Depreciation Schedule spreadsheet template should I download?
Upgrade to Essentials if you want a dashboard with charts, more categories, larger capacity, and a more polished spreadsheet for ongoing use. The Free version is a good fit for one-off planning or trying out the layout.
Can I upgrade the Free Depreciation Schedule spreadsheet template later?
Essentials is a one-time $19 purchase with no subscription. It typically adds a full dashboard, 30-50% more categories or rows than the Free version, and richer formulas. Most buyers upgrade after using the Free version for a few weeks and hitting its limits.
Is the FinancialAha Free Depreciation Schedule Spreadsheet Template a Google Sheets template?
Yes. Upload the file to Drive and choose "Open with Google Sheets". Nothing needs rewriting in the Free Depreciation Schedule Google Sheets template, and the currency dropdown still relabels the money columns.
Is the FinancialAha Free Depreciation Schedule Spreadsheet Template an Excel template?
Yes. The download is a plain .xlsx, so the Free Depreciation Schedule Excel template opens directly in Excel with no import step. There are no macros and no VBA, which matters when a schedule goes to an accountant.
Will the Free Depreciation Schedule spreadsheet Excel file open in older versions of Excel?
Yes. The Free Depreciation Schedule spreadsheet Excel workbook ships as a plain .xlsx, so it opens identically in current Excel and in builds that predate dynamic arrays.
Does the Free Depreciation Schedule spreadsheet template calculate depreciation?
Yes, on a straight-line basis. The annual charge is cost divided by useful life, rounded to whole currency, and it recalculates as you change either. What it does not take is a salvage value, so the figure is cost/life rather than (cost - salvage)/life. The Essentials build takes salvage, counts whole completed years from the purchase date, and carries accumulated depreciation and book value per asset.
Which depreciation methods does the Free Depreciation Schedule spreadsheet support?
Neither this nor the Essentials build offers declining balance, sum-of-years-digits or a tax recovery method. Both are straight-line, and this one leaves the arithmetic to you.
Is there a salvage value column in the Free Depreciation Schedule spreadsheet?
No. If an asset will be worth something at the end of its life, take that off before working out the figure you enter. The Essentials build has a salvage column and handles it.
Is the Free Depreciation Schedule spreadsheet template safe to download?
Yes. No macros, no sign-up, no tracking. The file is a plain .xlsx that opens directly in Excel or Google Sheets.
How do I open the Free Depreciation Schedule spreadsheet template in Google Sheets?
Upload the .xlsx file to Google Drive, then open it with Google Sheets. All formulas and formatting will be preserved.
Can I use the Free Depreciation Schedule spreadsheet template for commercial work?
All free templates are released under CC BY 4.0 (Creative Commons Attribution). You can use, modify, and share them freely - including for commercial purposes - as long as you credit FinancialAha.com. They are provided as-is and do not constitute financial advice.
