Rental Property Income & Expense Tracker | 6-Year Excel Template | ZAR

🏠 Rental Property Income & Expense Tracker | 6-Year Excel Template

Finally, a Simple Way to Track Your Rental Property Finances!

Are you a rental property owner, Airbnb host, or short-term rental investor struggling to keep track of income, expenses, and profitability? This professionally designed Excel spreadsheet does the heavy lifting for you!

✨ What's Included:

📊 6 Years of Tracking (2025-2030)

• Track monthly income and expenses across 6 full years
• 17 pre-built expense categories (cleaning, utilities, repairs, mortgage, and more)
• Auto-calculated yearly totals, profit/loss, and occupancy rates

📅 Monthly Summary Templates

• Easy-to-use monthly tracking sheets
• Simply copy the template each month
• Transfer totals to your yearly sheet with ease
• Includes a filled example to guide you

📈 4 Automated Charts

• Occupancy Rate Chart with customizable target line
• 5-Year Profit Trend visualization
• Revenue Trend Chart
• Expenses Trend Chart

🏦 Property Loan Calculator

• Calculate monthly loan payments
• Determine minimum rental income needed to break even
• Debt Service Coverage Ratio (DSCR) analysis
• Cash-on-Cash Return calculator
• See if your rental income covers your costs!

📋 Comprehensive User Guide

• Step-by-step instructions included
• Tips for success
• Troubleshooting guide
• No Excel expertise required!

🎯 Key Features:

✅ Easy Data Entry – Only edit the BLUE cells; everything else calculates automatically

✅ Multi-Unit Support – Track multiple apartments/units with occupancy calculations

✅ Formula Protected – Formulas are locked to prevent accidental edits

✅ Currency: ZAR (R) – Designed for South African landlords (easily changeable to $, €, £)

✅ No Macros – Works on any device that supports Excel

✅ Instant Download – Start tracking immediately

📊 Expense Categories Include:

Cleaning Services | Cleaning Supplies | Repair Services | Furniture | Appliances/Electronics | Decorations/Art | Toiletries | Internet | Gas | Water | Plants & Flowers | Insurance | Streaming Services | Electricity | Linen | Guest Consumables | Mortgage/Loan

Plus: Miles Driven tracking for tax deductions!

👤 Perfect For:

• Airbnb & short-term rental hosts
• Property investors
• Landlords managing 1+ units
• Anyone wanting to understand their rental profitability
• First-time rental property owners

💡 Why Choose This Template?

❌ No expensive software subscriptions

❌ No complicated accounting knowledge needed

❌ No hours spent building your own spreadsheet

✅ One-time purchase, use forever

✅ Works offline in Excel

✅ Full control of your data

✅ See your profitability at a glance

📁 What You'll Receive:

• 1x Excel file (.xlsx)
• Ready to use immediately
• Works with Microsoft Excel (desktop & online), Google Sheets, and LibreOffice

🔄 How to Change Currency:

This template uses South African Rand (R) by default. To change to USD, EUR, GBP, or any other currency:

1. Press Ctrl+H (Find & Replace)
2. Find: "R " (R with space)
3. Replace with: "$ " (or your symbol)
4. Click Replace All

Full instructions included in the workbook!

⚠️ Requirements:

• Microsoft Excel 2016 or later (recommended)
• Google Sheets (compatible)
• Basic computer skills

📧 Support:

Questions? Contact me and I'll help you get set up!