Schedule E for Multiple Rental Properties (Spreadsheet Guide)

shape
shape
shape
shape
shape
shape
shape
shape
Schedule E for multiple rental properties: lines, property codes and a spreadsheet

Updated October 2026 · 5 minute read

With one rental, Schedule E is simple. With four or five, the hard part is keeping each property’s income and expenses separate all year so the form takes an hour, not a weekend. This guide explains how multiple properties work on Schedule E, what goes on each line, and how to set up a spreadsheet that totals every property for you.

Quick answer
  • Three properties per Schedule E: columns A, B and C.1
  • More than three? Attach as many Schedules E as you need.1
  • Combined totals for all properties go on lines 23a–26 of only one Schedule E.1
  • Track every property separately all year: rent on line 3, expenses on lines 5–19.
  • Personal use over the greater of 14 days or 10% of rented days can limit deductions.1

How multiple properties work

Number of rentalsSchedules EWhere the totals go
1 to 31Lines 23a–26 of that form
4 to 62Lines 23a–26 of one form only
7 to 93Lines 23a–26 of one form only

Based on the IRS 2025 Instructions for Schedule E: one column per property, attach extra Schedules E as needed, and complete lines A, B and 23a–26 on only one, with combined totals.1

Schedule E lines, per property

Each property’s column has the same lines. Line names are as printed on Schedule E; the examples are ours.

LineNameWhat landlords usually put here
3Rents receivedAll rent collected for that property, including advance rent and fees tenants pay you
5AdvertisingListing fees, signs, rental ads
6Auto and travelTrips to the property for rental business
7Cleaning and maintenanceCleaning, lawn care, pest control, routine upkeep
8CommissionsLeasing commissions paid to agents
9InsuranceLandlord, fire and liability premiums for that property
10Legal and other professional feesTax prep for the rental, attorney, eviction costs
11Management feesProperty manager fees
12Mortgage interest paid to banks, etc.Interest on Form 1098 for that property
13Other interestInterest not on a Form 1098, such as a private loan
14RepairsFixes that keep the property in working order
15SuppliesSmall items used for the rental
16TaxesProperty tax for that property
17UtilitiesUtilities you pay as landlord, including rental-related phone calls
18Depreciation expense or depletionYearly depreciation from Form 4562
19OtherExpenses not on lines 5–18, such as HOA dues or software, listed by type
20Total expensesLines 5 to 19 added up
21Income or (loss)Line 3 or 4 minus line 20

Line 4 is for royalties. Lines 22 to 26 handle loss limits and the totals across all properties; see the IRS instructions and Form 8582 if you have a loss.1

Property types and rental days

Line 1b codeProperty type
1Single family residence
2Multi-family residence
3Vacation or short-term rental
4Commercial
5Land
6Royalties
7Self-rental
8Other (attach a statement)

Line 2 asks for fair rental days and personal use days for each property. If your personal use is more than the greater of 14 days or 10% of the days rented at a fair price, the unit counts as a home and deductions may be limited; rent it for fewer than 15 days and you don’t report the income or the expenses at all.1

Shared expenses across properties

Some costs cover several rentals: one umbrella insurance policy, one property manager invoice, one software subscription, one trip that visits three units. Schedule E needs each property’s share.

  1. Keep the original bill and note which properties it covers.
  2. Pick a reasonable split, such as equal shares, units or square footage, and write down why.
  3. Use the same method every year so your numbers stay consistent.
  4. Ask your tax professional if a split is not obvious.
Check each property’s cash flow too. Our free DSCR calculator shows whether a rental’s income covers its loan payment, the number lenders look at when you buy the next one.

Set up a multi-property spreadsheet

  1. One transaction log with columns for date, property, Schedule E line, payee and amount.
  2. Drop-downs for property and line, so nothing is misspelled.
  3. A summary tab with one column per property and one row per Schedule E line, filled with SUMIFS, for example =SUMIFS(Amount,Property,"Elm St",Line,"16 Taxes").
  4. A rent roll so expected rent and received rent can be compared each month.
  5. A days log for any property you also use yourself.

At tax time the summary tab reads straight across into columns A, B and C, then onto a second Schedule E if you have more than three.

Schedule E totals for every property, done

The Landlord Rental Property Tracker keeps your rent roll, expenses, NOI and DSCR per property and totals each Schedule E line for each rental. Excel and Google Sheets.

See the template ($29)

Questions

How many properties can go on one Schedule E?

Three. Each property gets its own column, A, B or C. If you have more, attach as many Schedules E as you need, and put the combined totals for all properties on lines 23a to 26 of just one of them.

Do I file one Schedule E per rental property?

No. One Schedule E holds up to three properties. Five rentals means two Schedules E: three on the first, two on the second, with combined totals on only one form.

How do I split expenses that cover more than one rental?

Keep the bill and divide it between the properties on a reasonable basis that you can explain, for example by square footage or number of units, and use the same method every year. Ask your tax professional which basis fits.

What property type codes go on line 1b?

Code 1 single family residence, 2 multi-family residence, 3 vacation or short-term rental, 4 commercial, 5 land, 6 royalties, 7 self-rental and 8 other, which needs an attached statement.

What if I also used the rental myself?

If your personal use is more than the greater of 14 days or 10% of the days rented at a fair price, the IRS treats the unit as a home and your rental deductions may be limited. Expenses for personal-use days are not rental expenses.

Sources

  1. IRS: 2025 Instructions for Schedule E (Form 1040)
  2. IRS: Publication 527, Residential Rental Property
TA

Tahir Abbas
Founder of Softotech Solutions. Tahir builds Excel and Google Sheets tools for landlords, including rent roll and Schedule E trackers. This guide is general information about the form, not tax advice; check your own return with a tax professional.

Leave a Reply

Your email address will not be published. Required fields are marked *