Skip to content
The title slide and first slides of the Rental Property Depreciation Schedule template

Rental Property Depreciation Schedule

Spreadsheet template for Google Sheets and Excel

Make a copy in Google Sheets
Price
Free
Slides
6
Difficulty
Beginner
Updated
November 15, 2026

Every slide (6)

Overview

Landlords with a duplex, a rented house or a few furnished units use this schedule to keep their depreciation figures in one place. The Assets tab takes cost, land part, recovery years and years already claimed, then works out basis, the full-year amount, the amount claimed so far, this year's figure and what is left. The Improvements tab logs repairs that may add to basis. The Projection tab estimates future years, and the Dashboard groups basis by asset type.

Begin with the purchase of the building and remove the land share, which depreciation does not cover. Add appliances, furniture and improvements as separate rows because each can have its own recovery period. Update the years claimed once a year after filing. Show the schedule to your tax professional, who decides the method and the amounts that go on the return.

Useful for

  • Keep a running schedule across several rental assets
  • Separate land from the building cost
  • Plan how much depreciation remains in later years

What's included

  • 5 tabs: Dashboard, Assets, Improvements, Projection, How to use
  • Dashboard: a dashboard with 4 summary figures
  • Assets: a table
  • Improvements: a table
  • Projection: a table
  • 1 chart that update as you type
  • Formulas, dropdowns and colour rules already set up
  • Sample rows that show how to fill it in

How to use it

  1. 1

    Click Make a copy in Google Sheets, then confirm on the Google page. The copy is saved to your own Google Drive.

  2. 2

    Start on the Assets tab: replace the sample rows with your own.

  3. 3

    Keep the formula columns as they are; they fill in as you type.

  4. 4

    Read the How to use tab for tips. For Excel, download the .xlsx file instead.

What you need

Requirements

  • A Google account, or Microsoft Excel for the download

Works with

  • Google Sheets
  • Microsoft Excel (download the .xlsx)

Questions

How is a depreciation schedule set up for a rental property?

List each asset with the cost and the date it was placed in service, remove the land part, and add its recovery period. Then record how many years you have claimed. The sheet turns those inputs into yearly and remaining amounts.

Which recovery period should I use?

The period depends on the type of asset and current IRS tables, so the sheet leaves it as an input. Look up the figure for the year the asset started service, or consult a tax professional, then type it in the Recovery years column.

What happens to the basis when I make an improvement?

Costs that add value or extend life are usually added to the basis of the property, while routine repairs are not. Log the cost on the Improvements tab and ask your tax professional how to treat it before adding it as an asset.

  • #tax-tracker
  • #rental-property-depreciation-schedule
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

Also in Finance

All finance templates
Get this template

Preparing your template…