Rental Property Income Tracker

🏡 KNOW EXACTLY WHICH PROPERTIES MAKE YOU MONEY

Stop guessing whether a rental is actually profitable. This Rental Property Income Tracker calculates your true cash flow, cap rate, cash on cash return, and ROI, automatically, for up to 6 properties. See at a glance which units are earning and which are quietly bleeding money.

Replaces $12 to 50 a month landlord software. One payment. Yours forever. Works in BOTH Microsoft Excel and Google Sheets.

WHAT'S INSIDE (6 connected tabs)

• DASHBOARD: Live portfolio overview with auto updating charts: monthly income vs. expenses, net cash flow trend, and cash flow by property. Plus instant KPI cards (total rent, monthly & annual cash flow, portfolio cap rate, average cash on cash return).
• PROPERTIES: The powerhouse tab. For each property, enter the purchase price, loan, rent, and expenses, and instantly get:
• Monthly mortgage payment (full amortization math built in)
• Monthly & annual cash flow
• Cap rate
• Net Operating Income (NOI)
• Cash on cash return
• Total ROI
• INCOME & EXPENSES: Log every rent payment and expense with easy dropdowns for property, type, and category.
• MONTHLY SUMMARY: Automatic month by month breakdown of income, expenses, and net cash flow.
• SETTINGS: Set your vacancy rate, management fee %, and tax year once; everything updates.
• START HERE: Simple setup instructions plus plain English definitions of every metric.

WHY INVESTORS LOVE IT

• Built in mortgage calculator, no separate tool needed
• Instantly spot underperforming or negative cash flow properties
• Compare every property side by side on one dashboard
• Real investor metrics: cap rate, cash on cash, NOI, ROI
• No monthly subscription, one payment vs. $600+/year software
• Beautiful, clean layout, no spreadsheet skills required
• Comes pre filled with sample properties so it makes sense instantly
• Fully editable and works in Excel AND Google Sheets

PERFECT FOR

• New landlords evaluating their first rental
• Experienced investors managing a small portfolio
• Anyone analyzing a deal before they buy
• Tax season organization of rental income & expenses

INSTANT DIGITAL DOWNLOAD

Your files are available immediately after purchase. Nothing is shipped.

You'll receive:

• The spreadsheet file (.xlsx, opens in Excel & uploads to Google Sheets)
• A Start Here guide with setup instructions

HOW TO USE IN GOOGLE SHEETS

1. Go to Google Drive, New, File Upload, select the file
2. Open it, then choose File, Save as Google Sheets
3. Done! All formulas and charts carry over.

(Full instructions are included on the Start Here tab.)

NEED HELP?

Questions or a hiccup? Just message the shop, we respond quickly and we're happy to help you get set up. Your success (and a kind review!) means everything to a small shop like ours. 💚

This tool is for informational and organizational purposes only and is not financial, accounting, investment, or tax advice. Always consult a licensed professional regarding your specific situation.

© McGuigan Software · Smart Sheets. Powerful Insights.