Rental Property Expense Spreadsheet Template (Free Excel)

The IRS requires landlords to report rental income and deduct rental expenses on Schedule E (Supplemental Income and Loss). The average landlord with one rental property can deduct $8,000-$15,000 in expenses annually, mortgage interest, property taxes, insurance, repairs, depreciation, management fees, and more. Landlords who don't track these categories throughout the year miss an average of $2,100 in legitimate deductions because they can't reconstruct them at tax time.

What Is a Rental Property Expense Spreadsheet?

A rental property expense spreadsheet is a financial tracking tool that records all income received from and expenses paid for a rental property, organized by category and date. At year end, it produces the summary data your accountant or tax software needs to complete Schedule E, and throughout the year, it shows you whether each property is generating positive cash flow.

A well-designed spreadsheet tracks:

• Rental income by unit and month
• All IRS-deductible expense categories (Schedule E lines 5-20)
• Non-deductible capital expenditures (improvements that must be depreciated)
• Net operating income and cash flow per property

When to Use This Template

• From day one of owning a rental. Retroactive record reconstruction is error-prone and audit-risky
• When converting from shoe-box receipts. Set up the spreadsheet for the current tax year and scan past receipts
• For each property you own. Run a separate tab or separate file per property, not one combined ledger
• When evaluating whether to sell. A complete income/expense history is required for capital gains calculation

Deductible Expense Categories (IRS Schedule E)

These are the categories your spreadsheet must track. All are deductible in the year incurred unless they are capital improvements (which must be depreciated over 27.5 years for residential property under MACRS):

Capital improvements (NOT immediately deductible): New roof, new HVAC system, addition, new flooring, these must be capitalized and depreciated. Track them separately.

Rental Property Expense Spreadsheet Template

This spreadsheet template is designed for one property per file. Duplicate for additional properties.

TAB 1: ANNUAL SUMMARY

TAB 2: TRANSACTION LOG

TAB 3: CAPITAL IMPROVEMENTS

TAB 4: PROPERTY INFORMATION

Need Help Tracking Your Rental Property Finances?

Our vetted property management VAs maintain your income and expense records year-round, so tax season is a one-hour review, not a month of scrambling.

<form action="/api/lead" method="POST" className="cta-form">
  <input type="hidden" name="source_page" value="/resources/templates/rental-property-expense-spreadsheet-template" />
  <input type="text" name="name" placeholder="First name" required />
  <input type="email" name="email" placeholder="Email address" required />
  <input type="url" name="site" placeholder="Property website or portfolio URL" />
  <button type="submit">Get My Free VA Consultation</button>
</form>

How to Customize This Template

Separating repairs from capital improvements: This is the single most important accounting distinction for landlords. A repair restores something to its original condition (replacing a broken window, fixing a leaking pipe), fully deductible in the year paid. A capital improvement adds value or extends the useful life of the property (replacing all windows, installing a new HVAC system, adding a deck), must be capitalized and depreciated over 27.5 years. If you misclassify a $12,000 roof replacement as a repair, the IRS can disallow the deduction and assess back taxes plus penalties.

Tracking mileage correctly: You can deduct miles driven to and from your rental property for inspections, repairs, and tenant-related business at the IRS standard mileage rate ($0.67/mile in 2024). Use a mileage log app or a simple date/destination/miles spreadsheet. The IRS requires contemporaneous records, reconstructed mileage logs from memory are rarely accepted in audit.

Depreciation timing: You begin depreciating a rental property in the month it is first placed in service (available for rent), not the month you purchased it. Use IRS Form 4562 to calculate depreciation; your accountant should handle this for the first year. The annual depreciation amount goes in the Depreciation line of Schedule E and significantly reduces your taxable rental income.

Common Mistakes

Combining personal and rental expenses. Using a personal credit card or bank account for rental expenses makes record-keeping exponentially harder at tax time. Open a dedicated bank account and credit card for each rental property. Every transaction in that account is rental-related; your personal account is personal.

Missing the home office deduction. If you manage your rental portfolio from a home office used exclusively for that purpose, you may be able to deduct a portion of your home expenses (mortgage interest, utilities, insurance) as a rental business expense. Most self-managing landlords miss this because they don't realize it applies to rental activities.

Not saving receipts for repairs under $500. Small repairs add up: a $45 filter here, a $120 plumbing part there. Landlords who throw away receipts under some mental threshold miss $800-$1,500 in legitimate deductions annually. Set a rule: every receipt goes in the file, no minimum.

Related Resources

• Property Management Checklist for Landlords, Ongoing landlord responsibilities
• Rental Property Maintenance Checklist, Track repair needs that generate expenses
• New Landlord Checklist, Full setup checklist including financial record setup
• All Resources, Complete library of templates, checklists, and guides