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.

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 this is incredibly helpful, thank you. Yes, I file a separate Schedule E for each of the 10 properties.

The distinction between what's paid into escrow vs. what's actually disbursed to the insurance company and the county is something I was definitely getting tripped up on. I was pulling escrow payment amounts from my monthly statements instead of looking at what was actually paid out. That explains why my numbers never quite matched up.

So to make sure I have this right: for each property I just need two documents from my lender's portal, the 1098 and the annual escrow statement. The 1098 gives me Line 12 (interest), and the escrow statement gives me the actual disbursements for Line 9 (insurance) and Line 16 (taxes). That's a much simpler process than what I was doing.

Quick follow up question: for properties where the insurance or taxes changed mid year (which happened on two of mine due to reassessments), does the escrow statement still reflect the correct total disbursed for the tax year? Or do I need to verify against the county tax records separately?

Eduardo Cavasotti · Answer

@Allan C. good point on the lender cushion policies. That actually explains some of the discrepancies I was seeing when I tried to reconcile escrow payments against actual disbursements. Different lenders were holding different cushion amounts, so the monthly escrow totals never matched what was actually paid out.

You're right that the difference is probably immaterial in most cases. My CPA flagged the same thing when I mentioned it. Still worth correcting going forward though, especially since pulling the actual insurance invoices and tax bills is honestly less work than trying to reverse engineer the escrow math each month.

This whole thread has been a solid resource. Between @Natalie Kolodij, @Aaron Zimmerman, @Jason Malabute, and now your input, I've got a much cleaner workflow for this filing season. Appreciate everyone weighing in.

Allan C. · Answer

Use your insurance invoices and tax bills to report the other expense items. You should not care about how much is paid into escrow accounts since different lenders have different cushion policies.

if you tried separating escrow payments on prior tax filings, I'm pretty sure you reported incorrectly (likely slightly higher expense reductions than actual, but also likely immaterial).

Eduardo Cavasotti · Answer

Thanks Jay, that makes sense for the interest piece. The 1098 gives me the annual mortgage interest total per loan, so that part is straightforward.

Where it gets tedious for me is the escrow side. My dec pages show the annual insurance premium and property tax amounts, but Schedule E wants those on separate lines (Line 9 for insurance, Line 16 for taxes). When I have 10 properties across different lenders, some with escrow and some without, pulling each one individually and making sure the amounts match what was actually disbursed that year takes a while.

Do you find that most of your borrowers just hand all of this to their CPA and let them sort it out? Or do the more organized ones track it throughout the year so they're not scrambling in February?

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

Most Popular Reply