Rental Property Tax Organizer, Schedule E Spreadsheet for Landlords, Rental Property Expense Tracker, Google Sheets + Excel

Get a year of rental taxes organized, property by property, and hand your tax pro something they can actually use.

Most rental sheets give you one big pile of numbers. This one gives every property its own Schedule E column, explains what belongs on each line, and works out depreciation for you.

WHAT IT DOES
• Setup (about 10 minutes): tax year, then one row per property with the date it was first available to rent and the purchase numbers used for depreciation
• Log as you go: income, expenses and rental trips, each tagged to a property and a Schedule E category
• Once a year: copy each Form 1098 into Loans & 1098, add anything lasting over a year to Improvements, then work down the CPA Checklist
• File: print the Schedule E Summary, or save it as a PDF, for your tax pro or tax software

WHAT'S INSIDE (11 tabs)
• Start Here: four steps, how to read the file, and the disclosures
• Setup: up to 6 properties, rental use % for part-time rentals, fair rental and personal use days, IRS figures by year
• Income Log: 400 payments, with deposits you are only holding kept out of income
• Expense Log: 800 rows with Schedule E categories, a receipt column and checks for rows missing a property or category
• Mileage Log: 300 trips, IRS rate filled in by trip date (72.5¢ Jan to Jun and 76¢ Jul to Dec for 2026)
• Improvements: each building over 27.5 years, plus 40 improvements with 15 and 5 year classes, bonus depreciation and de minimis items
• Loans & 1098: interest, mortgage insurance, escrowed tax and insurance, and points spread over the loan
• Schedule E Summary: every line from rents to income or loss, one column per property plus a portfolio total, with a note on where each number came from
• Dashboard: rents, expenses, depreciation and the result per property, with two charts
• Explainers: every Schedule E line in plain words, repairs versus improvements, the three safe harbors, personal use, passive losses and what depreciation costs when you sell
• CPA Checklist: 16 documents to gather, plus automatic checks (missing receipts, uncategorised rows, a property with no 1098 row, items logged twice, the mid-quarter trigger, the 14-day/10% personal use line)

WHY THIS ONE
• Every number is traceable: each line says which tab and which rule it came from
• Depreciation is actually figured, including last year's depreciation carried forward
• Explanations are built in, so you are not guessing what counts as a repair
• Clean, readable design that prints properly

YOU GET
• A Start-Here PDF with one-click links to make your own Google Sheets copy (blank or sample)
• The same workbook as Excel files (blank + filled-in sample)
• A sample year with three properties so you can see every tab working first
• Reuse it every year: change the tax year on Setup and keep going

ALSO IN MY SHOP
• House Hack Tax Organizer, for owners who live in one unit of a 2-4 unit building: https://www.etsy.com/listing/4577342836/house-hack-tax-organizer-schedule-e
• Utility Split for Landlords: https://www.etsy.com/listing/4577272134/landlord-utility-bill-split-spreadsheet

PLEASE NOTE
• Digital download. Nothing is shipped.
• A worksheet to organize your records. It is not a tax return and not tax, legal or financial advice. I am not a CPA, enrolled agent or tax preparer. Have a qualified tax professional review your numbers before you file.
• Federal rules only, as of September 2026, for tax years 2025 and 2026. Tax law changes; a table on Setup lets you add each new year's figures.
• Short-term rentals can be tracked here, but stays of seven days or less often follow different rules. Ask your tax pro.
• For your personal use with your own properties. Please don't share or resell.

HOW IT WAS MADE
I designed this workbook and its images with the help of AI tools, then checked every formula in Google Sheets and in an Excel-compatible spreadsheet app.