Rental Property & Landlord Income Spreadsheet (Google Sheets & Excel)
Google Sheets + Excel · Light & Dark Modes
Multi-Unit Rent Roll, Maintenance Expense Tracker, Cap Rate & Schedule E
- Multi-Unit Landlord Dashboard (Track gross rents, operating costs, net cash flow & Cap Rate)
- Master Rent Roll & Tenant Tracker (Lease start/end dates, monthly rent, deposit & payment status)
- Property Maintenance & Repair Log (Deductible expense categorization by property unit)
- Mortgage & Property Tax Tracker (Tracks principal, interest, escrow, property taxes & insurance)
- Schedule E Real Estate Tax Summary (Pre-grouped for accountant and tax preparer filing)
- Financial ROI & Cash-on-Cash Return Metrics per Property Unit
- Light & Dark Mode Included (Google Sheets + Microsoft Excel)
Instant digital download. All sales final. Message us anytime for help.
Manage your long-term rental properties with professional financial clarity. The DownloadSuite Rental Property & Landlord Income Spreadsheet tracks multi-unit rent rolls, tenant leases, deductible maintenance expenses, Net Operating Income (NOI), Cap Rates, and generates Schedule E tax summaries.
What's Included in This System:
- Multi-Unit Landlord Command Dashboard: Track Gross Rental Income, Operating Expenses, Net Cash Flow, Cap Rate, and portfolio occupancy.
- Master Rent Roll & Tenant Lease Tracker: Record tenant contact info, lease start/end dates, monthly rent, security deposits, and payment status flags.
- Property Maintenance & Repair Ledger: Categorize deductible repairs, contractor invoices, and property improvements unit-by-unit.
- Mortgage, Escrow & Property Tax Tracker: Track monthly mortgage principal, interest, property taxes, and landlord insurance policies.
- Schedule E Real Estate Tax Summary Sheet: Pre-grouped expense lines ready for your accountant and IRS tax filings.
- Unit-by-Unit ROI & Cash-on-Cash Return Metrics: Compare performance across single-family rentals, duplexes, and multi-family units.
How to Use:
- Input your property addresses, unit numbers, and monthly lease rates on the Rent Roll tab.
- Log monthly tenant rent payments and property maintenance expenses.
- Review your Net Operating Income, Cap Rate, and accountant-ready Schedule E tax summary.
What's inside
- Start Here Quick-Start & Landlord Tax Deduction Guide
- Master Property Portfolio Overview Dashboard
- Rent Roll & Tenant Lease Management Tab
- Property Expense & Maintenance Ledger
- Schedule E Real Estate Tax Summary Sheet
- Property Performance & Cash-on-Cash ROI Analyzer
- Instant Google Sheets Links + Native Excel .xlsx Workbooks
FAQ
How many rental units can this spreadsheet handle?
It supports single-family homes, duplexes, triplexes, and multi-unit portfolios up to 20 units.
Does this calculate Net Operating Income (NOI) and Cap Rate?
Yes! It calculates Gross Operating Income, Total Operating Expenses, Net Operating Income (NOI), and Capitalization Rate (Cap Rate) automatically.
Does it work in Excel and Google Sheets?
Yes! Both native Excel workbooks and Google Sheets copy links in Light and Dark themes are included.