How to Track Rental Property Income and ROI (Step-by-Step)
How to Track Rental Property Income and ROI (Step-by-Step)
Owning a rental property feels rewarding — until you realize you have no clear picture of whether it's actually making you money. Rent hits your account, repairs drain it, and somewhere in between sits your real return. Getting that number right isn't just satisfying; it's essential for making smart decisions about refinancing, expanding your portfolio, or knowing when to sell.
This guide walks you through the exact process: what to track, how to calculate ROI, and how to keep everything organized without a spreadsheet nightmare.
---
Why Tracking Rental ROI Matters
A property that "cash flows" isn't automatically a great investment. Your true return depends on every dollar in and every dollar out — including costs most landlords forget. Without tracking, you might be holding an underperforming asset while assuming it's your best one.
Accurate tracking lets you:
---
Step 1 — Know What to Track
Before any formula, you need a complete list of line items. Divide them into two buckets.
Income sources:Missing even one category — like capital expenditures or vacancy — can make your ROI look 20–30% better than reality.
---
Step 2 — Calculate Net Operating Income (NOI)
Net Operating Income is your starting point. It strips out financing so you can evaluate the property itself.
Formula:> NOI = Gross Rental Income − Operating Expenses
> (Operating expenses exclude mortgage payments)
Example:A single-family home rents for $2,000/month.
| Item | Annual Amount |
|---|---|
| Gross rent | $24,000 |
| Vacancy (5%) | −$1,200 |
| Property tax | −$3,000 |
| Insurance | −$1,200 |
| Maintenance | −$1,500 |
| Property management (10%) | −$2,400 |
| NOI | $14,700 |
Your property generates $14,700 per year before the mortgage touches it.
---
Step 3 — Calculate Cash-on-Cash Return
Cash-on-cash return measures what you earn relative to the cash you actually invested — the most practical metric for leveraged real estate.
Formula:> Cash-on-Cash Return = Annual Pre-Tax Cash Flow ÷ Total Cash Invested × 100
Continuing the example:Annual mortgage payment (30-yr, 7% rate on $224,000 loan): ≈ $17,900
| Item | Amount |
|---|---|
| NOI | $14,700 |
| Mortgage payments | −$17,900 |
| Annual Cash Flow | −$3,200 |
Cash-on-Cash Return = −$3,200 ÷ $64,000 = −5%
That's a negative cash flow — the property costs you $267/month out of pocket. Many investors still accept this if they believe in appreciation, but you need to know it, not discover it years later.
---
Step 4 — Calculate Total ROI (Including Appreciation and Equity)
Cash flow is only part of the picture. Total ROI folds in:
1. Cash flow (calculated above)
2. Equity build-up — the principal portion of each mortgage payment
3. Appreciation — increase in property value over time
4. Tax benefits — depreciation deductions (consult a tax professional for your situation)
Formula:> Total Annual Return = Cash Flow + Principal Paydown + Appreciation
> Total ROI % = Total Annual Return ÷ Total Cash Invested × 100
Example (Year 1):Total ROI = $8,000 ÷ $64,000 = 12.5%
A property bleeding $267/month is still delivering a 12.5% total return — context that completely changes the investment thesis.
---
Step 5 — Track It Consistently, Month by Month
One-time calculations go stale fast. Rents change, interest rates shift, repairs spike. You need a live system.
Here's a simple monthly tracking habit:
If you own multiple properties, consolidation matters enormously. Toggling between bank accounts, loan statements, and spreadsheets is where errors creep in. NOVOX lets you connect bank accounts, brokerage accounts, and real estate assets in one dashboard, so your rental income, mortgage balances, and net worth update together in real time — no manual reconciliation needed.
---
Step 6 — Use the Cap Rate for Cross-Property Comparison
When comparing two properties or evaluating a new purchase, use the capitalization rate (cap rate).
Formula:> Cap Rate = NOI ÷ Current Property Value × 100
Using our example:
Cap Rate = $14,700 ÷ $280,000 = 5.25%
A higher cap rate generally means higher income relative to value (and often higher risk). Most residential markets in 2024 see cap rates between 4% and 8%. Use this metric to compare deals apples-to-apples, independent of how each is financed.
---
Key Metrics Cheat Sheet
Here are the five numbers every rental property investor should track:
---
Common Tracking Mistakes to Avoid
---
Pulling It All Together
Tracking rental property income and ROI isn't complicated, but it does require discipline. Start with a complete expense list, calculate NOI and cash flow monthly, and compute total ROI annually. Use cap rate to compare opportunities. And build a system — whether a spreadsheet, dedicated software, or an all-in-one net-worth tracker like NOVOX — that makes the habit effortless.
When you know your numbers, you make better decisions: the right rent, the right repairs, and ultimately the right time to buy or sell.
---
FAQ
What is a good ROI for a rental property?
Most investors target a cash-on-cash return of 6–10% and a total ROI (including appreciation and equity) of 10–15% annually. What's "good" depends on your market, risk tolerance, and alternative investment options.
Should I include mortgage payments in my ROI calculation?
Yes and no. Exclude them from NOI and cap rate (which measure the property itself). Include them in cash-on-cash return and total ROI (which measure your personal investment performance).
How do I track rental income for taxes?
Keep a dedicated bank account for each property, categorize all income and expenses monthly, and retain receipts. Common deductions include mortgage interest, depreciation, repairs, insurance, and management fees — work with a CPA familiar with real estate to maximize them legally.
How often should I recalculate ROI?
Run cash flow monthly, recalculate full ROI annually, and do a deep review any time a major event occurs — a rent change, refinance, large repair, or significant shift in local property values.
What's the difference between cash flow and ROI?
Cash flow is the dollars left in your pocket each month after all expenses. ROI is a percentage that captures your total return — cash flow plus equity build-up plus appreciation — relative to your invested capital. You need both to understand a property's full performance.