Creating a Depreciation Schedule

If you’ve familiarized yourself with the topics in the previous two sections, you’ll be aware of the different methods for calculating straight-line vs. reducing-balance depreciation. A depreciation schedule charts the loss in value of an asset over the period you’ve designated as its useful life, using the accounting method you’ve chosen.
 
The point of having a depreciation schedule is to give you the ability to track what you’ve already deducted and stay on top of the process. What follows is one simple way to accomplish this.
 

If You’re Using the Straight-Line Method

You’ll need three columns:
 
  • The first column registers the depreciation deduction (aka depreciation expense) you plan to take each year. The number in this column will remain the same in every row, as you’ll be deducting the same amount every year.
  • The second column shows the depreciation that has accumulated at the end of each year.
  • The third column logs the book value of the asset at the end of each year.
Each row represents one year.
 

If You’re Using the Reducing-Balance Method

Basically, the only difference here is that the first column (depreciation deduction) will vary from year to year as the accelerated values at the beginning of an asset’s useful life diminish.
 
Need Business Insurance?

Need Business Insurance?

For more than 200 years businesses have trusted The Hartford. We can help you get the right coverage with an online quote.
 
The content displayed is for information only and does not constitute an endorsement by, or represent the view of, The Hartford.