Depreciation Expense Tracker (up to 95 Fixed Assets at Once)

This was designed to be an easy tool to figure out what your monthly/annual depreciation expense is going to be over time.

$45.00 USD

The template will be immediately available to download after purchase. Note, I added a comparison section and charts that are not in the video. This part now compares the straight line vs. double declining balance results on the 15-year schedule. This is included in the Accounting Templates for Excel bundle.


depreciation expense tracker

The tool allows you to define the following for each item:
  • Fixed asset purchase price
  • Salvage value
  • Useful life
  • Date of purchase
Summaries Include:
  • Up to 30 years for the monthly and annual depreciation expense.
  • Up to 30 years for the ending monthly and annual book value of the aggregate.
  • A standalone double declining balance helper that goes out 15 years.
If you really want to use the double declining balance you could copy and paste that section as many times as you want and then sum up the yearly values.

The idea is to understand the monthly depreciation that you may be able to deduct as an expense when you have a wide range of depreciable fixed assets that have been purchased at different times and have different useful lives. Also, to see the total book value of all fixed assets over time.

Note, section 179 deductions are not accounted for here and that may be a viable option that allows much of the cost to be expenses up front. You may want to consider bonus depreciation options / accelerated depreciation options if you are a real estate investor as this can accelerate the amount of expense you can take in a given year that is able to offset other income and reduce your overall tax liability. Consult with a tax / CPA professional on this.

Note, if you do take all the depreciation up front, that will give you more money now, but less tax benefit in the future.

More Accounting Spreadsheets / Calculators / Tools: