Spreadsheet Templates
•
Published on Nov 20, 2026
•
By SheetVault Editorial Team
•
Free .XLSX
Free Real Estate Rental Income Tracker for Excel & Google Sheets (Download)
=B2-(C2+D2+E2+F2)
What Is a Rental Property Income Tracker?
A Rental Property Income Tracker is a spreadsheet that records monthly rent, mortgage payments, utilities, maintenance, and other expenses for each property, then calculates total expenses and net income automatically.
Key Benefits
- Instant visibility of cash flow per property.
- Quick identification of under‑performing units.
- Accurate data for tax reporting and ROI analysis.
- Reusable template for any portfolio size.
How to Set Up the Tracker
- Open the provided Excel or Google Sheets file.
- Rename the sheet if desired – the default is Rental Tracker.
- Enter each property’s name in column A.
- Fill in the monthly rent (B), mortgage (C), utilities (D), maintenance (E), and other expenses (F).
- The template automatically calculates Total Expenses (G) and Net Income (H) using the formula
=B2-(C2+D2+E2+F2). - At the bottom, the TOTAL row aggregates all columns with
=SUM(...)formulas.
Pro Tips
- Copy the row for a new property and adjust the values – formulas update automatically.
- Use conditional formatting to highlight negative net income (red) or high ROI (green).
- Add a column for Vacancy Rate and incorporate it into the net income formula for more precise cash‑flow analysis.
Download Ready-to-Use Spreadsheet
Instant .xlsx file download with pre-loaded formulas, formatted totals, and clean design.
Download Template (.xlsx)Frequently Asked Questions
Can I track multiple years in the same sheet?
Yes. Add a column for the year or create separate tabs per year and link them with summary formulas.
How do I calculate ROI using this tracker?
Add a column for purchase price, then use =H2/PurchasePrice to get monthly ROI, or annualize it with =H2*12/PurchasePrice.