How to Analyze a Client’s Schedule E, Property by Property
Schedule E tells you what each rental did for the client’s tax bill. It does not tell you what the property did for the client. A rental can show a loss on the return and still put cash in the client’s pocket, or show a profit while the client quietly funds it every month. This guide covers how to read Part I of Schedule E one property at a time, what the form leaves out, how the passive loss limits change what the client can deduct, and how Leveridge builds each property from the return.
This guide covers rental real estate in Part I. Partnerships, S corporations, estates and trusts (Parts II and III) follow their own rules and are outside its scope.
What Part I shows
Part I gives each rental property its own column, A, B or C. A client with more than three rentals has more than one page of Part I, so count the columns on every page before assuming you have the whole portfolio.
The lines that matter for planning:
Lines 1a and 1b
The property's address and a type code: single family, multi-family, vacation or short-term rental, commercial, land, royalties, self-rental or other.
Line 2
The days the property was rented at fair rental value and the days of personal use. A property with meaningful personal use falls under different rules, covered below.
Line 3
Rents received.
Lines 5 through 19
Expenses, including insurance (line 9), management fees (line 11), mortgage interest paid to banks (line 12), other interest such as a loan from a private lender (line 13), repairs (line 14), taxes, mostly property tax (line 16), and depreciation (line 18).
Line 20
Total expenses.
Line 21
Rents minus total expenses. This is the property's taxable income or loss for the year.
Line 22
For a property with a loss on line 21, the part of that loss the client could deduct this year after the passive loss limits, figured on Form 8582. If line 22 is smaller than the loss on line 21, the rest was not deductible this year. A property with income on line 21 shows line 22 blank or at zero.
From taxable result to cash flow
Line 21 is a tax number. Two adjustments turn it into cash flow.
Add back depreciation (line 18). Depreciation is a deduction, not a payment. The client spent nothing on it this year.
Subtract what the client paid that is not on the form. Two payments never appear as expenses on Schedule E:
- Loan principal. Lines 12 and 13 carry only the interest portion of the loan payment. The Schedule E instructions allow only the interest the client paid on those lines; the principal part of the payment repays the loan and has no line on the form.
- Capital improvements.A new roof or a replaced HVAC system is capitalized and depreciated over time, not deducted in the year it is paid. The cash left the client’s account this year; only a small slice of it shows up, inside depreciation.
So, for each property:
Cash flow = line 21 + depreciation (line 18) − loan principal paid − capital improvements paid
Mortgage interest is already inside line 21, because it was deducted on line 12 or 13. Subtract it again and you count it twice.
What the form leaves out
Schedule E is a one-year snapshot of income and deductions. Several numbers a planning conversation needs are not on it:
What the property is worth
The return shows no value.
The loan balance
Line 12 shows interest paid, not what is still owed.
Depreciation taken to date
Line 18 is this year's deduction only. The running total, which drives depreciation recapture on a sale, lives in the preparer's depreciation schedule.
Suspended losses
Losses the client could not deduct in earlier years carry forward on Form 8582 and its worksheets, not on Schedule E.
How the activities are grouped
Whether the client's rentals are treated as one activity or several affects what a sale releases, and it is not visible on the form.
Each of these is a question for the client or their CPA, not something to estimate from the return alone.
The passive loss limits
Rental real estate is a passive activity by default, whatever the client’s involvement. A passive loss can offset passive income, such as a profit from another rental, but generally not wages or portfolio income. What happens to a net rental loss depends on facts the return does not always show.
If the client actively participates (makes management decisions in a significant and bona fide sense, such as approving new tenants, deciding on rental terms and approving expenditures, and, together with a spouse, owns at least 10% of the property by value throughout the year), up to $25,000 of rental loss can offset other income. That $25,000 shrinks by 50 cents for every dollar of modified adjusted gross income (MAGI) above $100,000, and is gone at $150,000. MAGI here is figured for this rule: adjusted gross income without passive losses, taxable Social Security benefits or IRA deductions, among other items. For a married client filing separately the limits are halved if they lived apart all year, and the allowance is not available at all if they lived together at any point during the year.
If the client qualifies as a real estate professional (more than 750 hours of services, and more than half of all their working hours, in real property trades or businesses in which they materially participate; on a joint return, one spouse must meet both tests alone), rentals in which they materially participate are not passive, and the limits above do not apply.
If neither applies,a net rental loss is suspended. It is not lost. It carries forward, and in a later year it can offset passive income from any of the client’s passive activities, or use the $25,000 allowance if the client qualifies that year. Whatever remains is released in full when the client sells their entire interest in the activity to an unrelated party in a fully taxable sale, meaning one in which all the gain is recognized. A 1031 exchange defers gain, so it is not a fully taxable sale and does not release the balance in full.
When a sale releases a suspended loss, the loss is reported on Schedule E like any other rental loss, so it is an ordinary loss. It does not reduce the gain on the sale itself. Because it lowers the client’s total income for the year, it can still lower the tax the sale produces, and the client’s CPA will work out by how much.
Short-term rentals are different. If the average guest stay is seven days or less, the activity is not a rental activity under the passive loss rules at all, and different tests apply. The type code on line 1b is the first clue.
How Leveridge does it
Leveridge reads the client’s tax return and builds each rental from its Schedule E column, so the rents, expenses, mortgage interest and depreciation come from the return rather than from manual entry. Each property gets its own net cash flow, equity and tax exposure, instead of the single aggregate rental line most planning software carries.
Leveridge’s net cash flow is the adjustment above, done for every property. It starts from rent less operating expenses, leaves depreciation and mortgage interest out of those expenses, then subtracts the full loan payment, principal and interest together. Depreciation never inflates the figure, and interest is never counted twice.
Leveridge also applies the passive loss limits to the household: the $25,000 allowance and its phase-out between $100,000 and $150,000 of MAGI. It shows how much of a loss is deductible this year and how much carries forward. A traceability view on each figure shows where the value came from, so any number can be checked against the return line by line.
That per-property view is what the planning conversation runs on: hold, sell and 1031 exchange compared side by side for each property the client already owns, with the numbers ready to enter into eMoney, RightCapital or MoneyGuidePro.
A worked example
A married couple files jointly. They own two rentals and make the management decisions on both. Their MAGI is $130,000.
Property A, a duplex
Property B, a single-family rental
Property B shows an $8,000 loss on the return and breaks even in cash. Property A shows $12,000 of taxable income and puts $15,000 in the client’s pocket. Neither story is visible from line 21 alone.
On the tax side, B’s loss is passive, so it first offsets A’s passive income. The couple’s net rental result is $4,000 of income, and the passive loss limits never come into play.
Change one fact. Suppose the couple owned only Property B. Now the $8,000 is a net passive loss, and the allowance decides what they can deduct:
- At $130,000 of MAGI: the allowance is $25,000 − (50% × $30,000) = $10,000. The whole $8,000 is deductible.
- At $140,000 of MAGI: the allowance is $25,000 − (50% × $40,000) = $5,000. $5,000 is deductible this year, and $3,000 carries forward.
- At $150,000 of MAGI or more: the allowance is zero. The full $8,000 carries forward.
Same property, same cash flow, three different answers on the return. That is why the client’s income belongs in any analysis of their rentals.
What gets missed
Treating line 21 as cash flow
It is a tax figure. Depreciation pushes it down; principal and improvements do not appear in it.
Counting mortgage interest twice
Interest is already deducted on line 12 or 13, and so is inside line 21. Subtract only the principal portion of the payment.
Assuming a rental loss is deductible
Above $150,000 of MAGI, a client without real estate professional status usually cannot deduct a net rental loss against wages. Compare line 22 with the loss on line 21.
Losing the suspended balance
Years of carried-forward losses can be a meaningful deduction in the year of a taxable sale. It sits on Form 8582, not on Schedule E, so it is easy to leave out of a sell-versus-hold comparison.
Reading the depreciation line as the total
Line 18 is one year. Depreciation recapture on a sale is based on all the depreciation taken, or that could have been taken, since the property was placed in service. See how to model depreciation recapture on a client’s rental.
What to confirm with the client’s CPA
The return shows the result. These facts decide it, and the CPA is the person who knows them:
- Whether the client actively participates in each rental, and owns at least 10% of it together with a spouse.
- Whether the client qualifies as a real estate professional, and has the hours documented.
- Whether the rentals are grouped as a single activity or treated separately.
- The prior-year suspended loss balance, from last year's Form 8582 worksheets.
- The depreciation schedule for each property, including any cost segregation study.
- For any property with personal use or short stays, how the vacation home or short-term rental rules were applied.
This page explains how Schedule E works and how Leveridge reads it, and is intended for financial advisors. It is not tax advice. Filing positions, elections, and the treatment of a specific client’s facts belong with the client’s CPA or tax attorney.
Sources
Related guides
What the depreciation on line 18 adds up to when the property sells.
Where the suspended loss balance and the cash flow above become a decision.
The path that defers the gain, and why it does not release suspended losses in full.
How the platform works end to end, from setting up a client to generating reports.