🏠 Rental Property · March 17, 2026 · 14 min read

Rental Property Depreciation Schedule in Google Sheets: 27.5-Year Calculator (2026)

Depreciation is one of the biggest tax benefits in real estate, but most landlords either skip it or guess the numbers. That costs real money every single year. This guide shows you how to build a clean, audit-ready depreciation schedule in Google Sheets using the IRS 27.5-year straight-line method. You’ll calculate your depreciable basis, handle the mid-month convention, and generate a 28-year table that ties directly to Schedule E.

27.5
Years of depreciation for residential rentals
20–30%
Typical land allocation (non-depreciable)
$0
Depreciation lost if you skip the schedule

Table of Contents

  1. Why Depreciation Matters for Landlords
  2. Step 1: Calculate Your Depreciable Basis
  3. Step 2: Apply the Mid-Month Convention
  4. Step 3: The 27.5-Year Straight-Line Formula
  5. Step 4: Build the Depreciation Schedule Table
  6. Worked Example: $300,000 Rental Property
  7. How to Handle Improvements & Repairs
  8. 6 Depreciation Mistakes That Trigger IRS Problems
  9. Google Sheets Tab Layout
  10. Copy-Paste Formula Library

Why Depreciation Matters for Landlords

Depreciation reduces your taxable rental income without reducing your actual cash flow. The IRS treats buildings as assets that “wear out” over 27.5 years, so it lets you deduct a slice of the building’s cost every year. That deduction flows straight to Schedule E, lowering your taxable income.

Example: If your annual depreciation deduction is $8,182 and your marginal tax rate is 24%, that’s $1,963 in tax savings per year. Over 10 years, that’s nearly $20,000 — without any extra work once the schedule is built.

Important: Even if you forget to claim depreciation, the IRS assumes you did. When you sell, you’ll still owe depreciation recapture. The only way to avoid paying tax on phantom depreciation is to track it correctly from day one.

Step 1: Calculate Your Depreciable Basis

The IRS only lets you depreciate the building and improvements — not the land. Your depreciable basis is the total cost of the property minus the land value and any non-depreciable items.

Component Included in Basis? Notes
Purchase price Yes Include closing costs directly tied to acquisition
Land value No Use county assessment or appraisal to allocate land
Capital improvements Yes New roof, remodel, HVAC, major upgrades
Repairs & maintenance No Deduct in the year incurred, not depreciated
Depreciable Basis
=Purchase_Price + Capital_Improvements - Land_Value
Land is not depreciable. Use a reasonable allocation (often 20–30% of total value) backed by tax records or appraisal.

Step 2: Apply the Mid-Month Convention

Residential rental property uses the mid-month convention. That means the IRS treats the property as placed in service in the middle of the month you start renting it — not the exact day. This affects your first year depreciation.

If you place a property in service on March 3, the IRS treats it as March 15. If you place it in service on March 28, it’s still March 15. That changes your first-year deduction by a partial-month amount.

Do not use full-year depreciation in year one. That’s the #1 error landlords make, and it can create issues if you’re audited or when you sell and recapture is calculated.

Step 3: The 27.5-Year Straight-Line Formula

Residential rental property depreciation is simple once the basis is set: divide your depreciable basis by 27.5 years.

Annual Depreciation (Full Year)
=Depreciable_Basis / 27.5
This is your full-year depreciation. Year 1 is prorated based on the mid-month convention.

Step 4: Build the Depreciation Schedule Table

Your schedule needs to track each year’s depreciation expense, cumulative depreciation, and ending book value. This makes tax prep easy and ensures you don’t lose track of depreciation recapture.

Year Months in Service Depreciation Expense Cumulative Depreciation Ending Book Value
1 9.5 $6,480 $6,480 $218,520
2 12 $8,182 $14,662 $210,338
3 12 $8,182 $22,844 $202,156
... ... ... ... ...
28 2.5 $1,702 $225,000 $75,000

Worked Example: $300,000 Rental Property

Let’s say you purchased a rental for $300,000 and allocated $75,000 to land (25%). The property was placed in service on March 12, 2026.

That $6,480 goes on Schedule E for 2026. The schedule keeps running until year 28, when the remaining partial-month depreciation finishes.

How to Handle Improvements & Repairs

Not every expense is depreciated. The IRS draws a hard line between repairs (deduct now) and improvements (depreciate over time). The wrong classification can cost you thousands in missed deductions or penalties.

Expense Type Deduct Now? Depreciate?
Fixing a leaky faucet Yes No
Replacing the roof No Yes (27.5 years)
Painting between tenants Yes No
Kitchen remodel No Yes (27.5 years)

For improvements, add a separate line item in your depreciation schedule with its own placed-in-service date and basis. Do not lump improvements into the original property basis — they are separate assets with their own schedules.

6 Depreciation Mistakes That Trigger IRS Problems

1. Depreciating Land

Land never depreciates. If you forget to separate land value, your depreciation deductions are overstated and can be disallowed.

2. Using the Purchase Date Instead of Placed-in-Service Date

The clock starts when the property is available for rent, not when you close. If you renovate for two months first, depreciation starts later.

3. Skipping the Mid-Month Convention

Year 1 must be prorated. Full-year depreciation in year one is incorrect for residential rentals.

4. Mixing Improvements into the Main Basis

Improvements must be tracked as separate assets. Otherwise you can’t accurately compute their remaining basis or depreciation recapture when you sell.

5. Forgetting to Track Cumulative Depreciation

Cumulative depreciation matters for book value and recapture calculations. Your sheet needs a running total column.

6. Treating Repairs as Improvements

Over-capitalizing repairs delays deductions. If it’s a routine fix, expense it now and don’t put it on the depreciation schedule.

Google Sheets Tab Layout

Tab Name What It Does
1 Inputs Purchase price, land value, placed-in-service date, improvements
2 Schedule 27.5-year depreciation table with cumulative totals
3 Summary Current year depreciation for Schedule E

Copy-Paste Formula Library

Annual Depreciation
=Depreciable_Basis/27.5
Place in the Inputs tab. Reference it across the schedule table.
Months in Service (Year 1)
=12-(MONTH(Placed_In_Service_Date)-0.5)
Mid-month convention: subtract the month, then add 0.5 to reflect half a month in service.
Year 1 Depreciation
=Annual_Depreciation * (Months_In_Service/12)
Use 9.5 months for March placement, 10.5 for February, etc.
Cumulative Depreciation
=SUM(Depreciation_Expense_Column)
Running total for recapture and book value tracking.
Ending Book Value
=Depreciable_Basis - Cumulative_Depreciation
This is the depreciable basis remaining. It should hit $0 at year 27.5.

Track Rental Property Finances in One Dashboard

Pair your depreciation schedule with a full income and expense tracker. The Freelancer Financial Dashboard is built for clean financial tracking in Google Sheets and keeps your rental data ready for tax time.

Get the Template on Etsy — $12.99 →

Build It Once, Use It Every Year

Your depreciation schedule is not a one-time task. It’s a long-term asset that protects you every year. Build it once, update it only when you add improvements or new properties, and use it to drive your Schedule E and future recapture calculations.

When tax time hits, you’ll already have the exact number your CPA needs. That saves time, reduces mistakes, and keeps more of your rental income in your pocket.

Related Guides