62 Multi-Family Single Family Properties Rental Income Expense Tracker Landlords Managers Google Sheets Excel

Track Income, Expenses, Profit & Balances Due — Without Complicated Software

This all-in-one Rental Property Spreadsheet is designed for landlords and real estate investors who want clear financial tracking across multiple properties and units—without expensive property management software or a steep learning curve.

Whether you own single-family homes, duplexes, triplexes, or apartment buildings, this spreadsheet adapts to your exact property mix. I’ll set it up for your specific property configuration at no extra charge.

Works in Microsoft Excel and Google Sheets.

✅ What This Spreadsheet Does for You

• See monthly & year-to-date income, expenses, profit, and profit percentage

• Track performance for:

  • Each unit

  • Each property

  • Your entire portfolio

• Instantly see balances due from partial or late rent payments

• Track installment payments and split rent (tenant + government assistance)

• Print or email clean Profit & Loss statements for your accountant

• Stay ahead of tax and insurance deadlines with automatic alerts

No chart of accounts. No accounting experience needed.

✅ Key Features

Property & Unit Tracking

• Supports up to 62 properties/units

• Works for single-family and multi-family portfolios

• Each property and each unit has its own income & expense tab

• Building-level expenses (like landscaping) roll up automatically

Income Tracking

Track income by category, including:

• Rent

• Government payments

• Late fees

• Laundry

• Parking

• Storage

• Custom income categories (fully editable)

Expense Tracking

Track expenses by category, such as:

• Utilities

• Cleaning & maintenance

• Repairs & appliances

• Advertising

• Auto & travel

• Internet & custom expense categories

All income and expenses automatically flow into dashboards and reports.

✅ Dashboards & Reports

• Unit Dashboard – monthly income, expenses, and category breakdowns

• Property Dashboard – full building performance overview

• Main Portfolio Dashboard – all properties combined

• Automatically generated Profit & Loss Statement

• Balance Sheet template (with ratio calculations)

All reports are easy to print or email.

✅ Rent Management Tools

• Tracks rent due dates and shows days overdue in red

• Automatically calculates balances due

• Handles partial payments & late payments

• Built-in Rent Invoice (customizable with your logo & terms)

• Built-in Rent Receipt (print or email)

✅ Tenant, Vendor & Property Settings

• Tenant tracking:

  • Name, lease start & end dates

  • Security deposits

  • Notes (ideal for short-term tenants)

• Vendor directory (up to 100 vendors):

  • Contact info, services, notes

• Property settings:

  • Property codes

  • Rent amounts

  • Renewal dates

  • Notes for long-term tenants

✅ Tax, Insurance & Maintenance Tracking

• Taxes Due Tracker

  • Color-coded alerts (yellow <30 days, red overdue)

  • Track tax amounts paid and balances due

• Insurance Due Tracker

  • Automatic reminders based on due dates

• Maintenance Schedule

  • Customizable checklist for each property

✅ Easy Customization

• Change income or expense category names instantly

• No accounting setup required

✅ Compatibility

• ✔ Microsoft Excel

• ✔ Google Sheets

✅ Who This Is Perfect For

• Landlords with multiple properties or units

• Real estate investors managing mixed portfolios

• Self-managing property owners

• Anyone who wants clear financials without monthly software fees

✅ Instant Access

Once purchased, you’ll receive:

• The Rental Property Spreadsheet

• Custom setup for your property configuration

• Ongoing usability without subscriptions