Rental property investing can generate steady income and long-term wealth. But only if you track the finances properly. Too many landlords manage their rental finances with a folder of receipts, a vague sense of how much rent comes in, and a annual panic when their accountant asks for expense details.
Whether you own one rental property or ten, you need a system to track rental income, operating expenses, mortgage payments, vacancy periods, maintenance costs, and net operating income (NOI) — per property and in aggregate. A Google Sheets spreadsheet is one of the most practical tools for this job.
The Metrics Every Landlord Should Track
Gross Rental Income
This is the total rent collected from all units across all properties. Track it monthly, broken down by property and unit. Include not just base rent but also late fees, pet fees, parking fees, and laundry income if applicable.
Vacancy Rate
Vacancy rate is the percentage of available rental days that are unoccupied. A 5% vacancy rate means your unit sits empty about 18 days per year. Tracking vacancy by property helps you identify underperformers.
Calculation: Vacancy Rate = (Vacant Days / Total Available Days) × 100.
Operating Expenses
Operating expenses include property management fees (typically 8-12% of rent), property taxes, insurance, repairs and maintenance, utilities paid by the owner, HOA fees, landscaping, pest control, advertising for vacancies, and legal and accounting fees.
These expenses should be tracked by property so you can see the profitability of each investment individually.
Net Operating Income (NOI)
NOI is the most important profitability metric for rental properties. It tells you how much income the property generates after operating expenses but before mortgage payments and taxes.
Calculation: NOI = Gross Rental Income – Operating Expenses – Vacancy Loss.
Cash Flow
Cash flow is what’s left after paying the mortgage — the money that actually hits your bank account each month.
Positive cash flow means the property is generating monthly income. Negative cash flow means you’re subsidizing the property from other income.
Cap Rate
Capitalization rate measures the property’s return independent of financing. It’s useful for comparing properties.
Calculation: Cap Rate = NOI / Property Market Value × 100.
A 6% cap rate means the property generates 6% of its market value in annual NOI.
Setting Up Your Rental Property Spreadsheet
A comprehensive rental property spreadsheet needs these core tabs:
Properties Tab
A directory of all your properties: address, purchase price, current market value, mortgage balance, monthly mortgage payment, number of units, and monthly rent per unit.
Rental Income Tab
Log every rent payment: date, property, unit, tenant name, amount, payment method, and status (received, late, partial). This becomes your revenue record and helps identify consistently late payers.
Expenses Tab
Log every expense: date, property, category, vendor, amount, and notes. Categories should align with IRS Schedule E for rental property deductions.
Mortgage Tab
Track mortgage payments by property: date, principal portion, interest portion, total payment, and remaining balance. This is important because only the interest portion is tax-deductible — the principal repayment is not a deductible expense.
Vacancy Tracker
Log vacant periods by property and unit: start date, end date, days vacant, and estimated lost rent. This feeds your vacancy rate calculation.
Dashboard
A summary view showing total rental income, total expenses, NOI per property and overall, cash flow, vacancy rate, and year-to-date P&L.
We’re currently building a dedicated Rental Property Financial Tracker that includes all six of these tabs with per-property P&L, depreciation tracking, and a visual dashboard. It will be available soon at gigaware.co/products.
Tax Deductions for Rental Property Owners
Rental property offers significant tax advantages, but only if you track the eligible deductions. Key deductions include mortgage interest (not principal), property taxes, insurance premiums, property management fees, repairs and maintenance (but not capital improvements — those are depreciated), advertising costs for vacancies, travel expenses for property management, legal and professional fees, depreciation (the biggest non-cash deduction — typically the property value minus land value, divided by 27.5 years for residential properties), and home office expenses if you manage properties from a dedicated workspace.
Tracking these deductions throughout the year — rather than scrambling to reconstruct them at tax time — can save thousands of dollars annually. A well-organized spreadsheet with proper categories makes this effortless.
The 1% and 50% Rules of Thumb
Two quick rules of thumb help evaluate rental property investments:
The 1% Rule: Monthly rent should be at least 1% of the purchase price. A $200,000 property should generate at least $2,000/month in rent. Properties that meet this threshold tend to cash flow positively.
The 50% Rule: Expect roughly 50% of rental income to go to operating expenses (not including mortgage). On $2,000/month rent, budget $1,000 for expenses, leaving $1,000 for mortgage payment and cash flow. This is a rough estimate — actual expenses vary by property age, location, and condition.
These rules are starting points, not guarantees. Your spreadsheet will give you actual numbers that are far more reliable.
Frequently Asked Questions
Should I use property management software instead of a spreadsheet?
Property management software (Buildium, AppFolio, Rentec Direct) is designed for landlords managing 10+ units who need tenant portals, online rent collection, and maintenance request systems. For 1-5 properties, a spreadsheet provides the financial tracking you need at zero ongoing cost. The software becomes worthwhile when you have enough units that tenant communication and rent collection automation save significant time.
How do I track depreciation in a spreadsheet?
Straight-line depreciation for residential rental property is calculated by dividing the depreciable basis (property value minus land value) by 27.5 years. For a property worth $200,000 where the land is valued at $40,000, the annual depreciation is ($200,000 – $40,000) / 27.5 = $5,818 per year, or $485 per month. This is a non-cash deduction that reduces your taxable income.
Do I need a separate bank account for rental income?
Yes, strongly recommended. A dedicated bank account for each rental property (or at minimum, one for all rental activity) makes bookkeeping dramatically easier, provides a clear audit trail, and helps you separate personal finances from investment finances.
How to Track Rental Property Finances in Google Sheets
Rental property investing can generate steady income and long-term wealth. But only if you track the finances properly. Too many landlords manage their rental finances with a folder of receipts, a vague sense of how much rent comes in, and a annual panic when their accountant asks for expense details.
Whether you own one rental property or ten, you need a system to track rental income, operating expenses, mortgage payments, vacancy periods, maintenance costs, and net operating income (NOI) — per property and in aggregate. A Google Sheets spreadsheet is one of the most practical tools for this job.
The Metrics Every Landlord Should Track
Gross Rental Income
This is the total rent collected from all units across all properties. Track it monthly, broken down by property and unit. Include not just base rent but also late fees, pet fees, parking fees, and laundry income if applicable.
Vacancy Rate
Vacancy rate is the percentage of available rental days that are unoccupied. A 5% vacancy rate means your unit sits empty about 18 days per year. Tracking vacancy by property helps you identify underperformers.
Calculation: Vacancy Rate = (Vacant Days / Total Available Days) × 100.
Operating Expenses
Operating expenses include property management fees (typically 8-12% of rent), property taxes, insurance, repairs and maintenance, utilities paid by the owner, HOA fees, landscaping, pest control, advertising for vacancies, and legal and accounting fees.
These expenses should be tracked by property so you can see the profitability of each investment individually.
Net Operating Income (NOI)
NOI is the most important profitability metric for rental properties. It tells you how much income the property generates after operating expenses but before mortgage payments and taxes.
Calculation: NOI = Gross Rental Income – Operating Expenses – Vacancy Loss.
Cash Flow
Cash flow is what’s left after paying the mortgage — the money that actually hits your bank account each month.
Calculation: Cash Flow = NOI – Mortgage Payment (principal + interest).
Positive cash flow means the property is generating monthly income. Negative cash flow means you’re subsidizing the property from other income.
Cap Rate
Capitalization rate measures the property’s return independent of financing. It’s useful for comparing properties.
Calculation: Cap Rate = NOI / Property Market Value × 100.
A 6% cap rate means the property generates 6% of its market value in annual NOI.
Setting Up Your Rental Property Spreadsheet
A comprehensive rental property spreadsheet needs these core tabs:
Properties Tab
A directory of all your properties: address, purchase price, current market value, mortgage balance, monthly mortgage payment, number of units, and monthly rent per unit.
Rental Income Tab
Log every rent payment: date, property, unit, tenant name, amount, payment method, and status (received, late, partial). This becomes your revenue record and helps identify consistently late payers.
Expenses Tab
Log every expense: date, property, category, vendor, amount, and notes. Categories should align with IRS Schedule E for rental property deductions.
Mortgage Tab
Track mortgage payments by property: date, principal portion, interest portion, total payment, and remaining balance. This is important because only the interest portion is tax-deductible — the principal repayment is not a deductible expense.
Vacancy Tracker
Log vacant periods by property and unit: start date, end date, days vacant, and estimated lost rent. This feeds your vacancy rate calculation.
Dashboard
A summary view showing total rental income, total expenses, NOI per property and overall, cash flow, vacancy rate, and year-to-date P&L.
We’re currently building a dedicated Rental Property Financial Tracker that includes all six of these tabs with per-property P&L, depreciation tracking, and a visual dashboard. It will be available soon at gigaware.co/products.
Tax Deductions for Rental Property Owners
Rental property offers significant tax advantages, but only if you track the eligible deductions. Key deductions include mortgage interest (not principal), property taxes, insurance premiums, property management fees, repairs and maintenance (but not capital improvements — those are depreciated), advertising costs for vacancies, travel expenses for property management, legal and professional fees, depreciation (the biggest non-cash deduction — typically the property value minus land value, divided by 27.5 years for residential properties), and home office expenses if you manage properties from a dedicated workspace.
Tracking these deductions throughout the year — rather than scrambling to reconstruct them at tax time — can save thousands of dollars annually. A well-organized spreadsheet with proper categories makes this effortless.
The 1% and 50% Rules of Thumb
Two quick rules of thumb help evaluate rental property investments:
The 1% Rule: Monthly rent should be at least 1% of the purchase price. A $200,000 property should generate at least $2,000/month in rent. Properties that meet this threshold tend to cash flow positively.
The 50% Rule: Expect roughly 50% of rental income to go to operating expenses (not including mortgage). On $2,000/month rent, budget $1,000 for expenses, leaving $1,000 for mortgage payment and cash flow. This is a rough estimate — actual expenses vary by property age, location, and condition.
These rules are starting points, not guarantees. Your spreadsheet will give you actual numbers that are far more reliable.
Frequently Asked Questions
Should I use property management software instead of a spreadsheet?
Property management software (Buildium, AppFolio, Rentec Direct) is designed for landlords managing 10+ units who need tenant portals, online rent collection, and maintenance request systems. For 1-5 properties, a spreadsheet provides the financial tracking you need at zero ongoing cost. The software becomes worthwhile when you have enough units that tenant communication and rent collection automation save significant time.
How do I track depreciation in a spreadsheet?
Straight-line depreciation for residential rental property is calculated by dividing the depreciable basis (property value minus land value) by 27.5 years. For a property worth $200,000 where the land is valued at $40,000, the annual depreciation is ($200,000 – $40,000) / 27.5 = $5,818 per year, or $485 per month. This is a non-cash deduction that reduces your taxable income.
Do I need a separate bank account for rental income?
Yes, strongly recommended. A dedicated bank account for each rental property (or at minimum, one for all rental activity) makes bookkeeping dramatically easier, provides a clear audit trail, and helps you separate personal finances from investment finances.