Real Estate & Landlords
Rental Property Income & Expense Tracker
Log rent collected and expenses paid across one or more properties, with automatic monthly and annual totals.
- Delivery
- Instant download
- Purchase
- One-time payment
- Format
- Google Sheets
- Excel
- Updated
- August 2026
Total net income (YTD)
$31,450
- Maple St duplex$28,800
- Oak Ave condo$16,200
Sample data preview of the Rental Property Income & Expense Tracker spreadsheet, shown for illustration only.
What this spreadsheet does
Landlord income and expenses are often scattered across bank statements and receipts, making year-end numbers hard to reconstruct.
What you can do with it
- Track rent collected each month across units
- Log repair and maintenance expenses by property
- Prepare organized numbers for tax filing
What's included
Sheet tabs
- Rent Roll
- Expense Log
- Annual Summary
Features
- Rent roll with per-unit collection tracking
- Expense log by category (repairs, insurance, taxes, management)
- Automatic monthly and annual net income totals
- Per-property breakdown for multi-property owners
How it works
- 1Add each property or unit to the Rent Roll tab
- 2Log expenses by category as they occur
- 3Review the Annual Summary tab for totals by property
Who it's for
Landlords managing one or more rental properties.
Frequently asked questions
Can I track multiple properties?
Yes, each row is tagged by property so the Annual Summary tab can break totals down per property.
Is this enough for tax filing?
It organizes your income and expenses clearly, but you should confirm final figures with a tax professional.
You might also need
Rental Property ROI Calculator
Enter price, rent and costs to see cap rate and cash-on-cash return.
- Google Sheets
- Excel
Landlord Maintenance Tracker
Log repair requests, status and cost for every unit.
- Google Sheets
- Excel
Property Comparison Spreadsheet
Compare price, condition and return across multiple listings.
- Google Sheets
- Excel
Tenant Screening & Application Log
Track every rental applicant's screening status and income-to-rent ratio in one log.
- Google Sheets
- Excel