Managing rental properties without a tracking system is like flying blind. Whether you have one rental or fifty, a well-organized spreadsheet helps you track cash flow, spot problems early, prepare for tax season, and make smarter investment decisions.
Below we've created comprehensive spreadsheet templates covering every aspect of rental property management — from monthly income tracking to deal analysis and tax preparation.
What Your Rental Property Spreadsheet Should Track
A complete rental property tracking system covers five key areas:
1. Monthly Income & Expenses
Track every dollar in and every dollar out for each property, every month. This is the foundation of your financial management.
- Rent collected (actual vs. expected)
- Late fees and other income
- Mortgage payment (principal + interest)
- Property taxes and insurance
- Repairs and maintenance
- Property management fees
- Utilities (if landlord-paid)
- HOA dues
2. Property Performance Dashboard
At-a-glance metrics for your entire portfolio:
- Net operating income (NOI) per property
- Cap rate and cash-on-cash return
- Occupancy rate
- Expense ratio
- Year-over-year comparison
3. Tenant Information
Centralized records for every tenant:
- Contact information
- Lease start/end dates
- Monthly rent amount
- Security deposit amount and account info
- Payment history
4. Maintenance Log
Track every repair and maintenance item:
- Date reported and date completed
- Description and category
- Vendor used and cost
- Warranty information
5. Deal Analysis Calculator
Evaluate potential purchases before buying:
- Purchase price and financing terms
- Expected rent and expenses
- Cap rate, CoC return, and total ROI
- Break-even analysis
Template 1: Monthly Income & Expense Tracker
This is the spreadsheet every landlord needs. Track income and expenses for each property monthly.
| Property | Month | Rent Due | Rent Collected | Late Fee | Other Income | Mortgage | Tax | Insurance | Repairs | PM Fee | Net Cash Flow |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 123 Oak St | Jan | $1,500 | $1,500 | $0 | $0 | $850 | $175 | $95 | $0 | $0 | $380 |
| 123 Oak St | Feb | $1,500 | $1,500 | $75 | $0 | $850 | $175 | $95 | $250 | $0 | $205 |
| 123 Oak St | Mar | $1,500 | $1,500 | $0 | $25 | $850 | $175 | $95 | $0 | $0 | $405 |
| 456 Elm Ave | Jan | $1,200 | $1,200 | $0 | $0 | $650 | $140 | $80 | $125 | $120 | $85 |
| 456 Elm Ave | Feb | $1,200 | $0 | $0 | $0 | $650 | $140 | $80 | $0 | $0 | -$870 |
Key Formulas
- Total Income: =Rent Collected + Late Fee + Other Income
- Total Expenses: =Mortgage + Tax + Insurance + Repairs + PM Fee + Utilities + HOA
- Net Cash Flow: =Total Income - Total Expenses
- Expense Ratio: =Total Expenses / Gross Rent (target: below 50%)
- Annualized Return: =Annual Net Cash Flow / Total Cash Invested
Template 2: Portfolio Performance Dashboard
See your entire portfolio's performance at a glance. Update monthly for portfolio-level insights.
| Property | Purchase Price | Current Value | Monthly Rent | Monthly NOI | Cap Rate | CoC Return | Equity | Occupancy |
|---|---|---|---|---|---|---|---|---|
| 123 Oak St | $185,000 | $210,000 | $1,500 | $680 | 4.4% | 8.2% | $72,000 | 100% |
| 456 Elm Ave | $145,000 | $160,000 | $1,200 | $420 | 3.5% | 6.1% | $48,000 | 92% |
| 789 Pine Rd | $220,000 | $245,000 | $1,800 | $850 | 4.6% | 9.5% | $85,000 | 100% |
| TOTAL | $550,000 | $615,000 | $4,500 | $1,950 | 4.3% | 8.1% | $205,000 | 97% |
Template 3: Deal Analysis Calculator
Run the numbers on any potential property before making an offer.
| PURCHASE DETAILS | |
|---|---|
| Purchase Price | $200,000 |
| Down Payment (25%) | $50,000 |
| Loan Amount | $150,000 |
| Interest Rate | 7.0% |
| Loan Term | 30 years |
| Closing Costs | $5,000 |
| Rehab Budget | $10,000 |
| Total Cash Needed | $65,000 |
| INCOME | |
| Monthly Rent | $1,800 |
| Other Monthly Income | $50 |
| Vacancy (5%) | -$93 |
| Effective Monthly Income | $1,757 |
| MONTHLY EXPENSES | |
| Mortgage (P&I) | $998 |
| Property Tax | $200 |
| Insurance | $100 |
| Maintenance (10%) | $180 |
| CapEx Reserve (5%) | $90 |
| Property Management (10%) | $180 |
| Total Monthly Expenses | $1,748 |
| RETURNS | |
| Monthly Cash Flow | $9 |
| Annual Cash Flow | $108 |
| Cash-on-Cash Return | 0.2% |
| Cap Rate | 4.2% |
| 1% Rule | 0.9% ❌ |
| Verdict | PASS — too tight |
Template 4: Tax Preparation Worksheet
Make tax season painless by tracking deductible expenses year-round.
| Category (Schedule E) | Q1 | Q2 | Q3 | Q4 | Annual Total |
|---|---|---|---|---|---|
| Gross Rent Received | $4,500 | $4,500 | $4,500 | $4,500 | $18,000 |
| Advertising | $150 | $0 | $0 | $0 | $150 |
| Insurance | $285 | $285 | $285 | $285 | $1,140 |
| Legal/Professional | $0 | $300 | $0 | $0 | $300 |
| Mortgage Interest | $2,100 | $2,080 | $2,060 | $2,040 | $8,280 |
| Repairs | $250 | $0 | $850 | $150 | $1,250 |
| Property Tax | $525 | $525 | $525 | $525 | $2,100 |
| Depreciation | $1,364 | $1,364 | $1,364 | $1,364 | $5,455 |
| Net Rental Income | -$675 |
Notice how depreciation creates a paper loss even though the property generates positive cash flow? That's one of the biggest tax advantages of rental property. Learn more: Complete guide to rental property tax deductions.
Spreadsheet vs. Property Management Software
| Factor | Spreadsheet | Software |
|---|---|---|
| Cost | Free | $10-100+/month |
| Best for | 1-10 properties | 10+ properties |
| Customization | Unlimited | Limited to features |
| Automation | Manual entry | Bank feeds, auto-categorize |
| Tenant portal | No | Yes |
| Maintenance tracking | Basic | Full workflow |
| Tax reports | Manual formulas | One-click exports |
Start with spreadsheets. Move to software when tracking manually becomes painful (usually around 5-10 properties). Check our reviews of the best property management software when you're ready to upgrade.
How to Set Up Your Spreadsheet System
- Create one workbook per year with tabs for each property plus a summary dashboard
- Enter data weekly — waiting until month-end means you'll forget transactions
- Save receipts digitally — take photos of paper receipts and store in Google Drive or Dropbox, organized by property and month
- Reconcile monthly — compare your spreadsheet to bank statements to catch missing transactions
- Back up everything — use cloud storage (Google Sheets is ideal since it auto-saves)
Want the Complete Property Management System?
Our Growth Playbook includes financial templates, KPI dashboards, and the exact systems used by PMs managing 500+ doors.
Get the Growth Playbook →Essential Formulas for Landlords
- Cap Rate: =(Annual NOI / Property Value) × 100
- Cash-on-Cash Return: =(Annual Cash Flow / Total Cash Invested) × 100
- Gross Rent Multiplier: =Property Price / Annual Gross Rent
- Debt Service Coverage Ratio: =NOI / Annual Debt Service (lenders want 1.25+)
- Break-Even Ratio: =(Operating Expenses + Debt Service) / Gross Income
- Depreciation (Residential): =(Building Value / 27.5) per year
- Vacancy Rate: =(Vacant Days / 365) × 100
FAQ
Should I use Google Sheets or Excel?
Google Sheets for most landlords — it's free, auto-saves, accessible from any device, and easy to share with your accountant. Use Excel if you need advanced features like Power Query or macros.
How do I track multiple properties?
Create a separate tab for each property's monthly income/expenses, plus a summary dashboard tab that pulls totals from each property tab using SUMIF formulas.
When should I switch to property management software?
When you hit 5-10 properties, have multiple tenants paying rent, and want automation (online rent collection, maintenance requests, tenant screening). Our CRM guide and software reviews can help you choose.
What's the most important metric to track?
Net cash flow per property. If a property consistently shows negative cash flow, you need to either increase rent, reduce expenses, or consider selling. Track your key performance indicators monthly.