The Simple Rental Property Expense Tracker Every Landlord Should Use

Landlord Philosophy
Written By Krystle Lilliestierna

You're sitting at your desk in April, tax forms scattered everywhere. Your CPA is asking which expenses you deducted last year, and you realize: you have no idea.

You know you spent money on repairs. You remember paying for insurance. But where are the receipts? How much did you actually spend?

This is the story of almost every first-time landlord.

And it costs them thousands.

The real cost of poor expense tracking

Here's what happens when you don't track expenses systematically:

Missed deductions: You forget about $2,000 in repairs because they happened in July and you didn't document them. That's roughly $600 in lost tax deductions (at a 30% tax rate).

Cash flow confusion: You don't know if your rental is actually profitable because you can't see where your money went each month.

Tax time panic: Your CPA charges extra because you hand them a shoebox of receipts instead of organized records.

Audit vulnerability: The IRS loves poorly documented expenses. Good records protect you.

The real kicker? Tracking expenses isn't hard. Most landlords just don't have a system.

WANT TO SKIP THE SETUP?

Get our pre-built expense tracker spreadsheet in The Thoughtful Landlord Toolkit ($79).

Or read on to build this yourself.

What successful landlords track (and you should too)

Your expense tracker needs to capture these key categories:

1. Mortgage Interest (Tax Deductible)

Only the interest portion of your mortgage payment is deductible—not principal. Most people get this wrong.

  • Track monthly and get your mortgage statement showing the breakdown

2. Property Taxes (Tax Deductible)

Every dollar you pay in property taxes is deductible.

  • Keep your tax bills and payment receipts

3. Insurance (Tax Deductible)

Landlord insurance, liability coverage—all deductible.

  • File annual premiums in your tracker

4. Repairs & Maintenance (Tax Deductible)

This is where landlords leave the most money on the table.

  • Broken door? Deductible.

  • New roof? Deductible.

  • Painting? Deductible.

  • Key: Keep receipts and photos.

5. Utilities You Pay (If Applicable) (Tax Deductible)

If you cover water, trash, or any utilities, track them.

  • Monthly statements prove amounts

6. Vacancy Loss (Important for Records)

Track months when the unit sits empty.

  • Helps with cash flow analysis (not directly deductible, but important)

7. Property Management Fees (Tax Deductible)

If you use a property manager, every penny is deductible.

8. Miscellaneous Expenses (Tax Deductible)

  • HOA fees

  • Lawn care

  • Pest control

  • Inspections

How to build your monthly tracking system

You don't need fancy software. A simple spreadsheet works beautifully.

Here's the system:

Step 1: Create a Monthly Tracker

Set up columns for:

  • Date

  • Expense Category

  • Description

  • Amount

  • Receipt? (Yes/No)

Step 2: Enter Expenses Weekly (Not Annually)

Don't wait until tax time. Every week, spend 10 minutes entering expenses. This is the secret to staying organized.

Step 3: Organize Receipts

  • Digital: Take photos of receipts and file them by month

  • Physical: Use a folder for each month

  • Email confirmations: Forward to a dedicated "Rental Expenses" email folder

Step 4: Monthly Reconciliation (Takes 15 Minutes)

At the end of each month:

  • Total your expenses by category

  • Verify receipts match entries

  • Note any missing documentation

Step 5: Annual Summary

At year-end, your spreadsheet automatically totals each category. Hand this to your CPA. Done.

The mistakes landlords make at tax time

Mistake #1: Treating Repairs as Capital Improvements

  • Repair: Fixing a broken window = Deductible

  • Improvement: Installing new windows = Depreciated over time

  • Know the difference. When in doubt, ask your CPA.

Mistake #2: Not Tracking Mileage

  • Drive to the property for repairs? That's deductible mileage (58.5¢ per mile in 2024).

  • Most landlords never claim this.

Mistake #3: Forgetting About Small Expenses

  • That $15 lock replacement.

  • The $30 caulk and supplies.

  • The $50 inspection fee.

  • These add up to hundreds. Track them.

Mistake #4: Mixing Personal and Rental Expenses

  • Did you use your personal phone for tenant calls? Don't deduct your whole phone bill.

  • Percentage of utility you pay = deductible. Personal utility use ≠ deductible.

  • Be honest here. The IRS notices inconsistencies.

Mistake #5: No System = Panic at Tax Time

  • You scramble to find receipts from 11 months ago.

  • Your CPA charges extra for disorganization.

  • You miss deductions because you can't find documentation.

The winning landlord approach

Here's what organized landlords do differently:

✅ They track every month, not once a year

✅ They keep receipts immediately (photo or file)

✅ They use a simple system they'll actually maintain

✅ They know their profit/loss in real-time

✅ They hand organized records to their CPA

✅ They maximize deductions and minimize stress

Here’s what you need to get started

The Thoughtful Landlord Toolkit includes:

Rental Expense Tracker Spreadsheet – Pre-built with all categories, automatically calculates totals

Monthly Rent Tracking Template – Capture tenant payments, late fees, and cash flow

Year-End Tax Summary Sheet – Hand this to your CPA

Bonus: Mileage Log – Track deductible driving

Inside the Toolkit, you'll also get:

  • Tenant welcome guide

  • Lease templates

  • Communication templates

  • And more

Get The Thoughtful Landlord Toolkit for $79 – Everything you need to run your rental professionally, with systems that actually stick.

Explore Toolkit
 
 

Continue building your thoughtful landlord system

If you're serious about managing your rental professionally, these resources will help you build a complete system.

Krystle Lilliestierna
Next

The Story of How Two Advertising Creatives Became Landlords