How do you handle mortgage splitting for Schedule E with multiple properties?

Question

Hey everyone — tax season question for those of you with multiple rental properties and third-party PMs.

I have 10 doors in Birmingham, all Section 8 with property managers. Every year when I sit down to do Schedule E, the most tedious part is splitting each mortgage payment into principal, interest, insurance escrow, and tax escrow for every property.

My lender sends one monthly statement per loan, but Schedule E wants interest on Line 12, taxes on Line 16, and insurance on Line 9 — all separately. With 10 properties, that's pulling amortization schedules, cross-referencing escrow statements, and manually calculating the split for each month of the year.

Last year this process alone took me about 6 hours. I've tried a few approaches:

1. Pulling the year-end interest statement (1098) for mortgage interest, then backing into the rest from the total payment amount

2. Downloading the full amortization schedule and mapping each month's principal/interest split manually

3. Asking my lender for a detailed escrow analysis to break out insurance vs. tax escrow

Option 1 is the fastest but doesn't give me the escrow breakdown. Option 2 is the most accurate but extremely time-consuming. Option 3 depends on whether the lender actually provides good data (mine doesn't always).

For those of you managing 5+ properties — how do you handle this? Do you just hand everything to your CPA and let them figure it out? Or do you have a system for tracking the splits throughout the year so it's not a last-minute scramble?

Also curious if anyone has found that their PM statements help with this at all, or if the mortgage split is entirely separate from what you get from your PM.

Would appreciate any tips. This is easily the most annoying part of filing for me.

Natalie Kolodij · Answer

**Edited after seeing your response comment above.

To confirm- you are filing a Schedule E for each of the 10 rentals correct? Not 1 combined Schedule E?

You should not need most of that information to file a rental P&L on Schedule E.

Principal Payments- Not deductible or reportable on Schedule E

Interest - You should receive a 1098 from the lender for each property stating the mortgage interest paid for the year. This is deductible on Line 12.

The 1098 may also show insurance and taxes paid for the year- if it does that is all you need to report on Line 9 and 16 of Sch E.

If the 1098 does not show this ....your Escrow statement or escrow account activity for the year should show disbursements for taxes and insurance during the tax year.

Disbursement for Insurance= Line 9 Sch E
Disbursement for Taxes = Line 16 Sch E

Insurance Escrow - The amount you paid into escrow is not what's deductible. It's the amount paid to the insurance company during the year (regardless of when the policy covers).

Tax Escrow - The amount you paid into escrow is not what's deductible. It's the amount paid to the county for property taxes during the year.

So all you should need is :

1098 - Interest expense and possibly insurance & tax expense

Annual Escrow Statement - to get amount paid/disbursed to insurance and taxes during the year if not shown on 1098.

It should take a few minutes to print those 2 items from the lender's website.

For properties without Escrow:

The 1098 will show you the mortgage interest amount

And then you are paying the taxes and interest during the year ....How do you track the rest of your expenses for that rental? Just record this the same way. Add it to your Spreadsheet/Books when you pay it.

Eduardo Cavasotti · Answer

@Jason Malabute This lines up exactly with where I landed after Natalie's breakdown earlier in the thread. The escrow disbursement vs. escrow payment distinction was where I was getting confused. Once I understood that what matters for Schedule E is what was actually paid out to the insurance company and to the county, not what I paid into the escrow account, the whole thing clicked.

Appreciate you flagging the case for properties without an escrow account. I have one DSCR loan where I pay taxes and insurance directly, so good to confirm those just get tracked as separate expense entries the same way any other rental expense would be.

And yes, separate Schedule E for each of the 10 properties. One per rental. That is how my CPA set it up from day one and I just needed to get clearer on which source document to pull for each line item.

Jason Malabute · Answer

• File a separate Schedule E for each rental (not one combined statement), ignore principal payments since they are not deductible, deduct only the mortgage interest reported on Form 1098 (Line 12), and report property taxes and insurance based on what was actually paid out during the year—not what you paid into escrow—using the lender’s 1098 and annual escrow statement; if there’s no escrow, rely on your 1098 for interest and your own records for taxes and insurance, recording expenses when they are actually paid.

Jay Hurst · Answer

You get a 1098 from your serivcer that lists the interest, the taxes are just the tax bill and insurance premium is on your dec page.

Eduardo Cavasotti · Answer

@Aaron Zimmerman @Jason Malabute thank you both. Really helpful to get multiple CPAs aligned on the same approach.

I went ahead and pulled the 1098s and annual escrow statements for all 10 properties to test this workflow. The good news: every lender portal I checked had the year end escrow summary available, and it breaks out total disbursed for insurance and property taxes separately. Combined with the 1098, that covers Lines 9, 12, and 16 cleanly.

To close the loop on my earlier question about properties where insurance or taxes changed midyear: the annual escrow statement handles it. It shows the total actually disbursed regardless of rate changes during the year. Two of mine had insurance premium increases after reassessments, and the escrow summary reflected the correct full year totals.

The whole process took maybe 20 minutes for 10 properties. Compared to the 6 hours I spent last year pulling amortization schedules and reconciling monthly escrow payments, this is a completely different experience. The key insight from this thread (especially @Natalie Kolodij's point) is that Schedule E cares about what was actually disbursed, not what you paid into escrow each month. That distinction alone saved me hours of unnecessary reconciliation.

Appreciate everyone's help on this. Solid thread for anyone else filing multiple Schedule Es this season.

Eduardo Cavasotti · Answer

@Natalie Kolodij Yes, separate Schedule E for each property. 10 doors is 10 forms.

The 1098 is the right starting point. The snag I kept hitting: several of my servicers were not breaking out insurance vs. property taxes individually on the 1098. They showed aggregate escrow disbursements. That forced me to pull the Annual Escrow Analysis from each servicer separately, and with 10 properties across different lenders that was the step eating up the time, not the actual filing.

For anyone hitting the same wall: once you have both documents the math is clean. 1098 covers mortgage interest for Line 12. The Annual Escrow Statement gives you insurance (Line 9) and property tax (Line 16) disbursements for the year. That is the complete picture.

Jason Malabute · Answer

Good news — you really don't need most of what you've been pulling. The whole job comes down to two documents per property: the 1098 and the annual escrow statement, both of which only take a few minutes to grab from the lender's website. Interest comes off the 1098 and goes on Line 12. The 1098 will often show insurance and taxes paid for the year too, and when it does, that's all you need for Lines 9 and 16. When it doesn't, the annual escrow statement will show the actual disbursements — insurance disbursed goes on Line 9, taxes disbursed go on Line 16. The key thing to remember on escrow is that what's deductible isn't what you paid into escrow, it's what was actually paid out to the insurance company and to the county during the year. Principal payments, by the way, aren't deductible or reportable on Schedule E at all, so you can ignore those entirely. For properties without an escrow account, the 1098 still gives you the interest, and you'd just track the tax and insurance payments the same way you track any other expense for that rental. One last thing to confirm: you should be filing a separate Schedule E for each of the 10 rentals, not one combined Schedule E.

Eduardo Cavasotti · Answer

@Natalie Kolodij Thanks for taking the time on this. The clarification was exactly what I needed.

I was overcomplicating it. Schedule E only needs the mortgage interest from the 1098, property taxes from the annual tax bill, and the insurance premium from the dec page. Separate filing per property. None of the escrow split math I was trying to track matters for Schedule E purposes.

Knox reads the tax bills, dec pages, and mortgage statements throughout the year and generates a Schedule E export per property. My CPA imports it directly into Drake. What used to take a full weekend across 10 properties is now about 30 minutes of review. Sharing in case it helps anyone else in the same spot.

Eduardo Cavasotti · Answer

@Natalie Kolodij Yes, filing separately for each property. One Schedule E per rental, 10 properties means 10 Schedule E pages. My CPA set it up that way from the start.

Looking back at your original answer, I think I was overcomplicating the source data. I was trying to manually back into each component from the monthly payment amounts rather than just pulling the 1098 for interest and the annual escrow statement for actual disbursements. The disbursement vs contribution distinction you laid out is exactly what I was missing.

The piece that was slowing me down practically is that several of my DSCR servicers make it tedious to pull the annual escrow analysis. Some send it automatically, some require logging into a portal and digging around. Nothing conceptually complicated, just more friction than I expected at scale across 10 loans with different servicers.

Appreciate the follow-up, Natalie. This kind of CPA level clarity is genuinely useful to have in a thread where others can find it later.

How do you handle mortgage splitting for Schedule E with multiple properties?

Most Popular Reply