Cash Flow Tracker

What's included

• Multiple income stream tracking (properties, businesses, investments)
• Expense categorization for tax preparation
• Property-by-property breakdown and comparison
• Monthly and annual summary dashboards
• Cash flow trend analysis over time
• Income vs. expense visualization charts
• Tax category tagging for Schedule E preparation
• Vacancy tracking by property

How to Calculate Rental Property Cash Flow Like a Pro

Real cash flow isn't just rent minus mortgage. You need to account for all operating expenses: property taxes, insurance, property management (include this even if self-managing—value your time), maintenance and repairs, vacancy reserve (5-10% of rent), and capital expenditure reserve for major repairs. Only after subtracting ALL expenses do you have true cash flow. This rental property cash flow calculator helps you track actual performance versus projections.

The Complete Expense Breakdown for Rental Properties

Operating expenses typically run 35-50% of rent for single-family rentals, higher for older properties. Break them down: Property taxes (check assessor), Insurance (landlord policy), Property management (8-10% if hired, opportunity cost if not), Maintenance (1-2% of property value annually), Vacancy (5-10% depending on market), CapEx (5-10% for reserves). Our cash flow tracker categorizes all expenses automatically for accurate analysis.

Understanding Vacancy Factor in Cash Flow

Even the best properties have turnover. Between tenants you lose rent, pay for cleaning, repairs, and marketing. Budget 5% vacancy in strong rental markets, 8-10% in average markets, more in weak markets. Calculate by: Annual Rent × Vacancy Rate. A $1,500/month property with 8% vacancy factor loses $1,440/year in expected income. This cash flow tracker lets you input actual vacancy and compare to projections.

Tracking Cash Flow Across Multiple Properties

Portfolio landlords need visibility into each property's performance and the total picture. Which properties carry the portfolio? Which underperform? This cash flow tracker provides property-by-property breakdown plus aggregate totals. Identify properties to sell or refinance, properties needing rent increases, and overall portfolio health. Essential for scaling your rental business.

Key formulas

Cash Flow Formula:
Monthly Cash Flow = Total Income - Total Expenses

Rental Property Cash Flow:
Cash Flow = Rent Collected - (Mortgage + Taxes + Insurance + Management + Maintenance + Vacancy + CapEx Reserve)

Cash Flow Per Door:
Total Portfolio Cash Flow / Number of Units

Operating Expense Ratio:
Operating Expenses / Gross Operating Income × 100
(Target: 35-50% for residential rentals)

Monthly Cash Flow Tracking for a Rental Property

1. Record monthly rent collected: $1,600 (tenant paid on time)
2. Subtract mortgage payment (PITI): $1,100 (principal + interest + tax escrow + insurance)
3. Subtract property management: $160 (10% of rent)
4. Subtract maintenance this month: $0 (no repairs needed)
5. Set aside CapEx reserve: $100 (6.25% for future roof, HVAC, etc.)
6. Set aside vacancy reserve: $80 (5% of rent)
7. Monthly Cash Flow: $1,600 - $1,100 - $160 - $0 - $100 - $80 = $160
8. Annual Cash Flow Projection: $160 × 12 = $1,920

This property cash flows $160/month after ALL reserves. On $40,000 invested (down payment + closing), that's 4.8% cash-on-cash return. Acceptable but not exceptional.

Frequently Asked Questions

What's the difference between cash flow and profit?

Cash flow is actual money moving in and out of your accounts each month. Profit (net income) is an accounting concept that includes non-cash items like depreciation. For landlords, cash flow is more important for day-to-day operations, while 'profit' on paper may look different due to depreciation deductions. You can have positive cash flow and show a 'loss' for taxes.

How do I improve rental property cash flow?

Three approaches: Increase income (raise rents to market, add amenities like washer/dryer, reduce vacancy through better tenant screening), Decrease expenses (shop insurance annually, handle simple maintenance yourself, refinance to lower rate), or Refinance to reduce mortgage payment. This cash flow tracker helps identify which lever to pull.

What's a good cash flow per rental property?

Minimum $100-200/month per door after all expenses and reserves. Strong markets might only yield $100-200, while cash flow markets can produce $300-500/door. The key is consistency—avoid negative cash flow properties that drain your portfolio. Use this tracker to ensure every property contributes positively.

How do I track cash flow for multiple properties?

This cash flow tracker includes separate tabs for each property plus a portfolio summary. Enter income and expenses by property monthly. The dashboard shows each property's performance and total portfolio cash flow. Identify which properties carry the portfolio and which underperform.