Rental Property Spreadsheet for Landlords, Rent Tracker, Income and Expense Tracker and Schedule E Summary for Google Sheets and Excel

Built for small landlords with 1 to 10 properties: one log for rent and expenses, and every report you need at tax time.

Record each rent payment and expense once. The Rent Roll fills itself month by month, the Schedule E tab totals the year by tax category for each property, and the Dashboard shows cash flow by month and by property.

FEATURES
- Properties: up to 10, with nickname, address, units and purchase details
- Transactions: one log with property and category dropdowns
- Rent Roll: up to 20 tenants with rent, due day and lease end, a January to December payment grid, and this month's Paid, Due or Late status
- Schedule E Summary: income and expenses by IRS Schedule E category for each property, with net income per property, ready for your tax preparer
- Dashboard: rent collected, expenses, net cash flow by month and by property, with a chart

Organizes your numbers; not tax advice.

HOW YOU GET IT
This is a digital download. Nothing is shipped. After purchase, download the files from your Etsy Purchases page (or the email Etsy sends you).

WHAT'S IN THE DOWNLOAD
- The template in 3 color themes (Sage, Blush, Slate)
- Each theme with example data, so you can see it working, and a blank version to start fresh
- A Start Here PDF with setup steps for Google Sheets and Excel

WORKS WITH
- Google Sheets (free, any computer, phone or tablet app)
- Microsoft Excel 2016, 2019, 2021 and Microsoft 365
- Not tested in Apple Numbers

GOOD TO KNOW
- No macros, no add-ons, no account to make with us.
- Personal use. Please do not share or resell the files.
- Designed by Tallyhouse with the help of AI tools. Every formula is tested against worked examples before it ships.
- Questions? Message us here on Etsy. We usually reply within a day.