How to Track Rental Property Income and Expenses in Google Sheets (Landlord's Complete Guide)

Managing rental property finances doesn't require expensive software. A well-structured Google Sheets spreadsheet gives you everything you need to track income, categorize expenses for tax time, and actually understand whether your property is making money.

Why Proper Expense Tracking Matters More Than You Think

Most new landlords start with a vague sense of their numbers. Rent comes in, mortgage goes out, and whatever's left feels like profit. But this approach hides the real story — and it costs you at tax time.

Rental property income is reported on Schedule E of your tax return. Every deductible expense reduces your taxable rental income, and rental real estate offers some of the most generous deductions in the entire tax code (including depreciation — more on that later). But you can only claim what you can document.

The IRS requires landlords to maintain records that substantiate income and expenses. If you're ever audited, "I think I spent about $3,000 on repairs" won't cut it. A well-organized spreadsheet with categorized expenses and receipt references will.

What You Gain From a Tracking System

• Tax savings: Capture every deductible expense, properly categorized for Schedule E
• Cash flow clarity: Know your actual net operating income (NOI), not a guess
• Decision data: See which properties are performing and which are draining you
• Audit protection: Clean records make IRS inquiries painless
• Refinance/sale readiness: Lenders and buyers want organized financials

What Every Landlord Needs to Track

Your rental property spreadsheet needs to capture two sides of the equation: money in and money out.

Income Sources

Expense Categories

Expenses should be categorized to match IRS Schedule E line items. This makes tax filing dramatically easier — you're essentially pre-filling your tax return throughout the year.

Schedule E Categories: The Landlord's Tax Roadmap

Schedule E (Supplemental Income and Loss) is where you report rental property income and expenses. Here are the expense categories the IRS uses, and what belongs in each:

Key distinction — Repairs vs. Improvements: A repair restores something to working condition (deductible immediately). An improvement adds value or extends useful life (must be depreciated over time). Fixing a broken faucet = repair. Remodeling the entire bathroom = improvement. The IRS takes this distinction seriously.

How to Structure Your Rental Property Spreadsheet

A well-organized Google Sheets workbook for rental property management should have these tabs:

Building the Income Tracking Sheet

Your income sheet should capture every dollar that comes in, with enough detail to reconcile with your bank statements.

Column Structure

1. Date Received — When payment hit your account
2. Property — Which property (dropdown for consistency)
3. Unit — For multi-unit properties
4. Tenant Name — Who paid
5. Category — Rent, late fee, pet rent, application fee, etc.
6. Amount — Payment amount
7. Payment Method — Check, Venmo, Zelle, direct deposit
8. Notes — Anything relevant (partial payment, applied to past-due, etc.)

Google Sheets tip: Use data validation dropdowns for the Property, Category, and Payment Method columns. This prevents typos, ensures consistency, and makes filtering and pivot tables actually work. Go to Data → Data Validation → List of items.

Formulas to Include

At the top or bottom of your income sheet, add summary formulas:

• =SUMIFS(F:F, B:B, "123 Main St", A:A, ">="&DATE(2026,1,1)) — Total income per property per year
• =SUMIFS(F:F, E:E, "Rent") — Total rent collected across all properties
• =COUNTIFS(E:E, "Late Fee") — Number of late payments (a useful operational metric)

Building the Expense Tracking Sheet

The expense sheet is where the real tax savings happen. Every entry here potentially reduces your taxable income.

Column Structure

1. Date — When expense was incurred or paid
2. Property — Which property (same dropdown as income sheet)
3. Category — Schedule E category (use the table above)
4. Vendor/Payee — Who you paid (plumber's name, Home Depot, etc.)
5. Description — What was done ("replaced kitchen faucet", "annual insurance premium")
6. Amount — How much
7. Payment Method — How you paid
8. Receipt — Link to receipt image in Google Drive (or checkbox for "filed")
9. Tax Deductible — Yes/No (most will be yes, but track non-deductible items too)

Pro Tips for Expense Tracking

• Photograph every receipt immediately. Use Google Drive or a dedicated folder. Thermal receipts fade within months.
• Record expenses the day they happen. A 30-second entry now saves 30 minutes of detective work later.
• Be specific in descriptions. "Plumbing" tells you nothing in 8 months. "Fixed leaking P-trap under unit 2 kitchen sink" tells you everything.
• Track mileage separately. Every drive to the property, hardware store, or meeting with tenants is deductible. Use a simple mileage log tab.

Creating a Property Dashboard

The dashboard is your at-a-glance view of portfolio performance. Use SUMIFS and QUERY formulas to pull data from your Income and Expense sheets.

Key Metrics to Display

Formula example for NOI:

=SUMIFS(Income!F:F, Income!B:B, "Property A") - SUMIFS(Expenses!F:F, Expenses!B:B, "Property A")

Add conditional formatting to highlight negative cash flow in red and positive in green. This gives you an instant visual health check across your portfolio.

Managing Multiple Properties

If you own more than one rental, your spreadsheet structure becomes even more important. Here's what works:

Option 1: Single Workbook with Property Filters

Keep all income and expenses in shared sheets with a "Property" column. Use data validation dropdowns for property names and filter/pivot as needed. This works well for up to 5-10 properties.

Advantage: One file to maintain, easy to see portfolio-wide totals, simpler to create a unified dashboard.

Option 2: Separate Tabs Per Property

Create duplicate income/expense tabs for each property (e.g., "Income - 123 Main", "Expenses - 123 Main"). Roll everything up to a master dashboard tab.

Advantage: Cleaner when properties have very different financial profiles. Easier to share individual property data with partners or accountants.

Which to Choose?

For most landlords with 1-5 properties, Option 1 (single workbook, property column) is more efficient. The filtering and SUMIFS approach keeps everything in one place without duplicating structure. If you have 10+ properties or different ownership entities, consider separate workbooks per entity.

Rental Property Tax Deductions You Shouldn't Miss

Rental real estate has some of the most powerful tax advantages in the code. Make sure you're capturing all of them.

Depreciation — The "Paper Loss" Powerhouse

You can depreciate the cost of your rental building (not land) over 27.5 years. This is a non-cash deduction that can create a tax loss even when you're cash-flow positive.

Example: You bought a property for $250,000. The land is worth $50,000, so the building value is $200,000. Annual depreciation: $200,000 ÷ 27.5 = $7,273/year. That's $7,273 in deductions without spending a dime.

Improvements to the property (new roof, HVAC system, renovations) are also depreciable — but on different schedules depending on the type of improvement.

Repairs vs. Capital Improvements

This is one of the most misunderstood areas of rental property taxation:

• Repairs (immediately deductible): Fixing a broken window, patching drywall, unclogging drains, replacing a garbage disposal, repainting a unit between tenants
• Improvements (must be depreciated): New roof, new HVAC system, kitchen remodel, adding a deck, replacing all windows, new flooring throughout

The IRS test: Does it restore the property to working condition, or does it improve, adapt, or betterment the property? When in doubt, consult a tax professional — the difference can affect thousands of dollars in deductions.

Travel and Mileage

Every trip to the property, hardware store, meeting with contractors, or bank for property-related business is deductible. Use the standard mileage rate ($0.70/mile in 2026) or track actual vehicle expenses. Keep a mileage log.

The $25,000 Rental Loss Allowance

If your adjusted gross income (AGI) is under $100,000 and you actively participate in managing your rental, you can deduct up to $25,000 in rental losses against your other income (W-2, self-employment, etc.). This phases out between $100K-$150K AGI.

With depreciation creating paper losses, many landlords show a tax loss on profitable rental properties — and use that loss to reduce taxes on their regular income. This is one of the biggest advantages of rental real estate.

Pass-Through Deduction (Section 199A)

Rental income may qualify for the 20% qualified business income (QBI) deduction under Section 199A. If your rental activity qualifies as a business (and most do, especially if you use a safe harbor), you can deduct 20% of your net rental income. On $30,000 of net rental income, that's a $6,000 deduction.

Common Tracking Mistakes Landlords Make

1. Mixing Personal and Rental Finances

Open a separate bank account for your rental business. Every rental dollar in, every rental expense out — all through one account. This alone makes tracking 10x easier and provides a clean audit trail.

2. Not Tracking Small Expenses

That $15 trip to Home Depot for caulk. The $8 key copies at the hardware store. The $25 in cleaning supplies. Individually, they seem trivial. Over a year, they add up to hundreds or thousands of dollars in missed deductions.

3. Confusing Repairs and Improvements

Classifying a $15,000 roof replacement as a "repair" will raise red flags with the IRS. Conversely, depreciating a $200 faucet replacement over 27.5 years is unnecessary — it's clearly a repair. Know the difference and categorize correctly.

4. Forgetting Depreciation

Depreciation is mandatory — the IRS will recapture it when you sell the property whether you claimed it or not. So if you're not claiming depreciation, you're paying extra taxes now AND you'll pay recapture tax later. Always claim it.

5. No Receipt System

Create a Google Drive folder structure: Rental Properties → [Property Address] → [Year] → Receipts. Photograph every receipt, every invoice, every contractor bill. Link to these files from your expense spreadsheet. When tax time comes (or if the IRS calls), everything is organized and accessible.

6. Year-End Scramble

If you're spending your December digging through bank statements trying to categorize 12 months of expenses, your system is broken. Record expenses within 48 hours. Set a weekly 10-minute review. Your year-end "tax prep" should take 15 minutes of verifying totals, not 15 hours of data entry.

Why Google Sheets Works for Landlords

Property management software like Stessa, Buildium, or AppFolio has its place — especially for landlords with 20+ units or those who want built-in rent collection. But for most individual landlords with 1-10 units, Google Sheets offers real advantages:

• $0 cost — No monthly subscription fees (which are themselves a deductible expense, at least)
• Full control — Customize categories, formulas, and layout to match your exact needs
• Accessibility — Access from any device, anywhere, with automatic cloud backup
• Sharing — Easily share with your accountant, business partner, or property manager
• No lock-in — Your data is yours. Export to Excel, CSV, or PDF anytime
• Formulas and automation — SUMIFS, QUERY, pivot tables, conditional formatting — powerful tools that cost nothing

The downside: you have to build it (or buy a template). But once set up, a well-designed spreadsheet runs for years with minimal maintenance.

Next Steps

Start with the basics: create a Google Sheet with Income and Expense tabs. Use Schedule E categories for expense classification from day one. Build the habit of recording every transaction within 48 hours.

If you're looking for a ready-made solution, we're building a Rental Property Tracker template designed specifically for landlords — with multi-property support, Schedule E categories, automated dashboards, and cash flow analysis. Follow our Etsy shop to be notified when it launches.

In the meantime, check out our Freelance Tax Deductions Checklist if you're also doing freelance work alongside your rental properties — many of the same principles apply.

Disclaimer: This article is for informational purposes only and does not constitute tax or legal advice. Consult a qualified tax professional for advice specific to your situation.

← Back to Blog