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

  1. Open the provided Excel or Google Sheets file.
  2. Rename the sheet if desired – the default is Rental Tracker.
  3. Enter each property’s name in column A.
  4. Fill in the monthly rent (B), mortgage (C), utilities (D), maintenance (E), and other expenses (F).
  5. The template automatically calculates Total Expenses (G) and Net Income (H) using the formula =B2-(C2+D2+E2+F2).
  6. 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.