Rental Property Depreciation & Schedule E Organizer: Landlord Tax Spreadsheet for 1-8 Rentals (Excel + Google Sheets)

Tax time for landlords means two headaches: figuring depreciation, and turning a year of records into Schedule E numbers. This organizer does both in one spreadsheet.

What's inside

• Properties: up to 8 rentals. Enter purchase price, closing costs that add to basis, and land value. It figures building basis, this year's depreciation (27.5 years, mid-month convention), accumulated depreciation, remaining basis and years left.

• Improvements: 80 rows for roofs, HVAC, appliances, flooring and more, with 27.5, 15, 7 or 5-year lives from a dropdown. Depreciation rolls up to each property.

• Schedule E Summary: up to 4 properties side by side, laid out like Schedule E lines 3 to 21 (rents, advertising, insurance, mortgage interest, repairs, taxes, utilities and more). Depreciation fills in automatically. Totals for all properties.

• Tax Docs Checklist: 20 year-end documents to gather (Have / Need / N/A), plus questions to ask your tax preparer.

Blank owner-name fields, no logos on the pages. It's your organizer. Works in Excel, Google Sheets and LibreOffice. Example properties are filled in so you can see how it works.

Not legal advice. Not tax advice. It is an organizer and estimating tool. Tax rules change and every situation is different. Check irs.gov and talk to a tax professional before you file.