Rental Property Expenses Spreadsheet: Track Every Deductible Dollar

A rental property expenses spreadsheet mapped to IRS Schedule E. Worked example showing how a 4-property landlord tracks $47K in annual deductions.

By Amanda Orson
Published
Updated
Track every deductible dollar of rental property expenses.

A rental property expenses spreadsheet categorizes every cost by IRS Schedule E line item, so you capture every deduction and don't scramble to reconstruct 12 months of expenses in March.

The average self-managing landlord misses $1,000-3,000 in annual deductions. Most of those missed deductions come from expenses that were real, paid, and legitimate, but never recorded.

The Complete Expense Category List

The IRS allows these deductions on Schedule E for rental properties. Your spreadsheet needs a row or category for every one. If you're already using a rental property spreadsheet to track portfolio performance, this expense layer sits alongside it.

Fixed Monthly Costs

CategorySchedule E LineNotes
Mortgage interestLine 12Interest only — principal is NOT deductible
Property taxesLine 16Full amount, no SALT cap for rental properties
Insurance premiumsLine 9Landlord policy, not homeowner's
HOA feesLine 19 (Other)Fully deductible for rental properties
Property management feesLine 19 (Other)8-10% of rent is typical — include even if self-managing

Variable Operating Costs

CategorySchedule E LineNotes
RepairsLine 14Restores existing condition (fix, patch, replace in kind)
MaintenanceLine 14Lawn care, snow removal, cleaning between tenants
Utilities (landlord-paid)Line 17Water, sewer, trash, gas, electric if you pay
Pest controlLine 14Quarterly or as-needed treatments
SuppliesLine 14Smoke detectors, locks, light bulbs, batteries

Professional Services

CategorySchedule E LineNotes
Legal feesLine 10Lease review, eviction filings, entity formation
Accounting/CPA feesLine 10Tax prep, bookkeeping, entity tax returns
Eviction costsLine 10Court fees, process server, attorney
Tenant screeningLine 19 (Other)Fees you absorb (not passed to tenant)

Travel & Administrative

CategorySchedule E LineNotes
Mileage to propertiesLine 19 (Other)70 cents/mile for 2025
Travel for out-of-state propertiesLine 15Flights, hotels, meals for property visits
Home officeForm 8829Must qualify under exclusive-use test
Phone and internetLine 19 (Other)Business-use percentage only
Software and subscriptionsLine 19 (Other)Property management tools, accounting software
Advertising for tenantsLine 1Listing fees, signage, online ads

Capital & Depreciation

CategoryForm/LineNotes
DepreciationLine 18 / Form 4562Calculated separately — not a cash expense
Amortized closing costsLine 18Spread over loan term
Points paid on mortgageLine 18Amortized over loan life

Worked Example: 4-Property Portfolio Annual Expenses

Here's what a real expense spreadsheet looks like for a landlord with 4 single-family rentals worth a combined $680,000.

Property Details

PropertyValueRentYear Built
A — 3bd/2ba, Indianapolis$165,000$1,500/mo2001
B — 3bd/1ba, Memphis$120,000$1,200/mo1985
C — 4bd/2ba, Kansas City$195,000$1,650/mo1998
D — 2bd/1ba, Birmingham$100,000$1,050/mo1972
Total$580,000$5,400/mo—

Annual Expense Summary

CategoryProp AProp BProp CProp DTotal
Mortgage interest$6,420$4,380$7,680$3,540$22,020
Property taxes$2,475$1,080$3,315$850$7,720
Insurance$1,200$1,080$1,440$960$4,680
Repairs$1,100$2,400$800$1,800$6,100
Maintenance$600$480$720$360$2,160
Supplies$180$240$150$310$880
Advertising$0$150$0$75$225
Mileage (70¢/mi)$420$0$350$0$770
Travel (out-of-state)$0$680$0$520$1,200
Software$300———$300
CPA fees$400———$400
Total cash expenses$13,095$10,490$14,455$8,415$46,455
Depreciation (27.5 yr)$4,364$3,171$5,149$2,636$15,320
Total deductions$17,459$13,661$19,604$11,051$61,775

At a 24% marginal tax rate, $61,775 in deductions saves $14,826 in taxes. Miss 10% of those deductions and you're overpaying the IRS by $1,483/year.

The Three Mistakes That Cost Landlords $1,000+/Year

1. Not tracking mileage

Every trip to your rental property is deductible at 70 cents per mile. Ten trips at 20 miles round-trip = $140 in deductions per property.

With 4 properties and 8-12 trips each per year, that's $560-840 in mileage deductions. Most landlords track zero of this because they forget to log the trip when it happens.

Fix: Use a mileage app (MileIQ, Everlance) or add a "Mileage" column to your expense log. Record the date, property, and miles driven for every trip, even 5-minute runs to drop off a key.

2. Lumping repairs and improvements

A repair restores something to working condition and is fully deductible this year:

  • Fixing a leaky faucet: $180 repair (deduct now)
  • Patching drywall: $250 repair (deduct now)
  • Replacing a broken garbage disposal: $350 repair (deduct now)

An improvement adds value or extends useful life and must be depreciated over 27.5 years:

  • New roof: $8,500 improvement (deduct $309/year for 27.5 years)
  • Kitchen renovation: $15,000 improvement (deduct $545/year for 27.5 years)
  • New HVAC system: $6,000 improvement (deduct $218/year for 27.5 years)

Miscategorizing a $3,000 repair as an improvement costs you $2,891 in immediate deductions. You'd only claim $109 this year instead of the full $3,000.

Fix: Add a "Repair or Improvement?" column to your spreadsheet. If it restores existing function → repair. If it makes the property better than before or extends useful life → improvement.

3. Forgetting small purchases

Think of the $47 deadbolt, the $23 in smoke detector batteries, the $89 locksmith call, and the $35 in cleaning supplies between tenants.

These individually feel too small to record. Across 4 properties and 12 months, they add up to $500-1,200/year in deductions that never make it into your spreadsheet.

Fix: Keep a dedicated credit card for rental expenses, and put every charge on that card into the spreadsheet. Skip the mental filter of "is this worth recording?" and log everything.

Spreadsheet Structure That Actually Works

Tab 1: Expense Log

Every expense gets one row:

DatePropertyCategoryVendorDescriptionAmountPayment MethodReceipt LinkRepair/Improvement
2/3Prop BRepairsHome DepotReplace kitchen faucet$180Chase ****4521[link]Repair
2/8Prop AMileage—Inspection trip, 24 mi RT$16.80———
2/15Prop DInsuranceState FarmAnnual premium renewal$960Auto-pay[link]—

Tab 2: Monthly Summary

Use a pivot table or SUMIFS to pull from the Expense Log, grouped by property and category. This is your dashboard, so glance at it monthly to catch anomalies.

MonthProp AProp BProp CProp DTotal
Jan$1,045$890$1,210$680$3,825
Feb$980$1,340$1,150$720$4,190
Mar$1,100$870$2,450$695$5,115

A spike in one property (like Prop C in March) tells you to investigate, since it might be a one-time repair or it might be a pattern.

Tab 3: Year-End Report

This is a one-click summary matching IRS Schedule E, sorted by property. Hand it to your CPA and save 2-3 hours of back-and-forth.

Critical rule: Enter expenses weekly, not quarterly. The landlord who waits until March to organize expenses is the landlord who misses 20% of deductions.

When Your Spreadsheet Needs More Than a Spreadsheet

Expense tracking works in a spreadsheet. What doesn't work in a spreadsheet:

Knowing if your rents are at market. You're carefully tracking $46K in expenses, but you have no idea whether your $1,200/month Memphis rental should be $1,350. That $150/month gap is $1,800/year in missed income, which is more than most expense tracking errors.

Seeing your portfolio as a portfolio. A spreadsheet shows you Property B had $2,400 in repairs. It doesn't tell you that Property B's cash-on-cash return dropped from 6.2% to 3.8% because of those repairs combined with stale rent pricing.

Spotting below-market rents across multiple properties. If you own 4-10 properties in 2-3 markets, manually checking rent comps for each one every quarter is a 4-6 hour project. Most landlords don't do it, and the result is rent erosion that compounds across the portfolio.

Expense Benchmarks by Property Type

Use these as sanity checks when reviewing your annual numbers:

Expense Category% of Gross Rent$ Range (per unit)
Property taxes10-20%$1,000-4,000/year
Insurance5-10%$800-2,000/year
Repairs5-10%$800-2,000/year
CapEx reserves5-10%$1,000-2,500/year
Property management8-10%$960-1,800/year
Vacancy5-8%$750-1,500/year
Total operating expenses40-55%$5,000-12,000/year

If your total expenses consistently run below 35% of gross rent, you're probably under-budgeting repairs or CapEx. If above 60%, either your rents are too low or your properties need significant capital investment. Either way, these numbers feed directly into your cash flow analysis.


FAQ

What expenses can I deduct for a rental property?

Deductible rental property expenses include mortgage interest, property taxes, insurance, property management fees, repairs, maintenance, utilities (if landlord-paid), professional services (legal, CPA), mileage at 70 cents/mile, advertising, and depreciation over 27.5 years. All deductible expenses are reported on IRS Schedule E. Principal payments and capital improvements are not immediately deductible.

What is the difference between a repair and an improvement for taxes?

A repair restores something to working condition (fixing a leaky faucet, patching drywall, replacing a broken disposal) and is fully deductible in the current year. An improvement adds value or extends useful life (new roof, kitchen renovation, new HVAC) and must be depreciated over 27.5 years. Miscategorizing a $3,000 repair as an improvement defers $2,891 in deductions you could claim this year.

How often should I update my rental property expenses spreadsheet?

Update weekly. Landlords who wait until month-end or tax time typically miss 15-20% of deductible expenses because receipts get lost, small purchases are forgotten, and mileage goes unrecorded. Weekly entry takes 10-15 minutes across a 4-property portfolio. Use a dedicated credit card for rental expenses to simplify recording.

What percentage of rental income goes to expenses?

Total operating expenses typically run 40-55% of gross rental income for residential investment properties. This includes property taxes (10-20%), insurance (5-10%), repairs (5-10%), CapEx reserves (5-10%), property management (8-10%), and vacancy (5-8%). If your expenses consistently run below 35%, you're likely under-budgeting maintenance or CapEx.

Does Operator track rental property expenses?

No. Operator isn't expense tracking or bookkeeping software. It checks your rents against live market comps every month, shows cap rate and cash-on-cash for the properties you own, and tells you when rents fall below market. Keep using your expense spreadsheet for costs. Plans start at $49/mo with a 7-day free trial.

Built for this

Operator runs your buy box every day and sends you only the new matches, including off-market properties. It calculates NOI and DSCR for any address, shows cap rate and cash-on-cash for the properties you own, and checks your rents against the market every month. Plans start at $49/mo with a 7-day free trial.

Explore Buy Box Agent
operator.galleon.io/buy-box

North Jersey 5–8

5–8 units · ≤ $1.6M · Cap ≥ 6.5%
Sample listings matching the North Jersey 5–8 buy box
18 Grove StreetPaterson, NJ
$945K1857.80%$74K52dNew
412 Hawthorne AveNewark, NJ
$1.19M1917.40%$88K61dNew
1144 Market StreetPaterson, NJ
$980K1817.20%$71K54dReviewing
27 Elm StreetJersey City, NJ
$1.42M1926.90%$98K83dReviewing
901 Broad StreetNewark, NJ
$1.26M1836.60%$83K79dUnder offer