Rent Roll & Rental Income Tracker: Landlord Spreadsheet for 1-25 Units (Excel & Google Sheets)

Stop piecing rent together from bank apps and sticky notes. This Home1 Solutions spreadsheet shows, at a glance, who has paid, who still owes and what your rentals actually earned this year.

6 tabs, all formulas included

• Units & Leases: up to 25 units with tenant, lease dates, rent, deposit, due day, late fee and status, plus an automatic "renewal due soon" alert 60 days out.

• Payments: log rent, late fees, pet rent and other income using unit and type dropdowns.

• Expenses: 400 rows with 13 categories that roughly follow common rental expense groupings, with "ALL" for shared costs.

• Rent Roll: collected vs. expected rent for every unit and month, with balances owed highlighted.

• P&L: monthly income, expenses by category, net income, running year-to-date and per-unit net.

• Start Here: a simple setup guide.

Sample data is included so you can see how it works. Clear it and add your own. Works in Excel, Google Sheets and LibreOffice.

Not tax or legal advice; check your state and local rules and talk to a tax professional.