Real Estate Income Statement Template: Free Excel & PDF

A real estate income statement lists a property’s income and expenses over a set period, usually a month or a year, and shows what’s left over: your net operating income and your net profit. Investors, lenders, and buyers also call it a profit and loss statement, or P&L. Below you’ll find a free real estate income statement template with tabs for long-term rentals, small multifamily, flips, wholesaling, and short-term rentals.

The cleanest seller P&L I ever saw was also the one hiding the most expenses.

So this guide does two jobs. It shows you how to fill in your own statement, and it shows you how to read someone else’s before you write an offer.

Real Estate Income Statement Template (Free Download)

The free template is a Google Sheets workbook you can also download as an Excel file or print as a PDF. It has one tab for each investing strategy, so you track a flip like a flip and a rental like a rental.

Template tab	Best for
Long-Term Rental	One rental, tracked month by month
Portfolio	Up to six properties side by side
Seller T12 Review	Checking a seller’s numbers before you offer
Fix & Flip	One flip project, budget vs actual
Wholesaling	A wholesaling business, quarter by quarter
Short-Term Rental	Vacation rentals and nightly stays

Every blank tab has a matching example tab at the end of the workbook, filled in with the same numbers you’ll see in this article. Look at the example first to watch the formulas work, then switch to the blank tab for your own numbers.

You type only in the yellow cells. The sheet handles the math, including the split between mortgage interest and principal, which most free templates make you look up yourself. The rental tab also shows the Schedule E line next to every expense, so tax time takes an afternoon instead of a weekend.

What Is a Real Estate Income Statement?

A real estate income statement is a financial report that shows how much money a property brought in, what it cost to run, and what you kept during a specific period. “Income statement” and “profit and loss statement” mean the same document. Accountants tend to say the first, and investors tend to say the second.

An income statement always covers a stretch of time, like January through December. A balance sheet works differently. It shows what you own and what you owe on a single day.

Plenty of people read your income statement besides you. Your CPA uses it to prepare your taxes. A lender uses it to decide whether the property can carry a loan. A buyer uses it to decide what the property is worth. A partner uses it to decide whether to put money in your next deal.

If you own even one rental, keep one. Not for the IRS. For you. Without it, you’re guessing whether the property makes money, and I’ve watched investors guess wrong for years before a big repair bill told them the truth.

What Goes on a Rental Property Income Statement?

A rental property income statement has five parts: rental income, operating expenses, net operating income, financing and tax items “below the line,” and net income. Each part answers a different question, so it pays to keep them separate.

Rental Income

Start with gross potential rent, which means the rent you’d collect if every unit stayed full and every tenant paid on time. Add other income like pet rent, late fees, laundry, and parking.

Then subtract vacancy and credit loss. That line captures empty months and tenants who don’t pay. What’s left is effective gross income, the money that actually came in.

I always show vacancy as its own line, even in a great year. A statement that shows zero vacancy tells me somebody didn’t track it.

Operating Expenses

Operating expenses are the recurring costs of keeping the property rented and running. The usual list covers property taxes, insurance, property management, repairs and maintenance, owner-paid utilities, HOA dues, advertising, cleaning and turnover, and legal and accounting fees.

The tricky part is telling a repair from an improvement. A repair keeps the property in working order, like fixing a leak or patching drywall, and you deduct it in the year you pay for it. An improvement makes the property better or replaces a major system. The IRS treats replacing an entire roof, all the windows and doors, or a furnace as capital improvements that you depreciate over time (IRS, 2026). Those don’t belong in operating expenses.

Net Operating Income (NOI)

Net operating income is effective gross income minus operating expenses. It measures how well the property performs on its own, before anyone talks about how you financed it.

That’s why lenders and buyers anchor on NOI. Two investors can own identical houses, one with a big mortgage and one paid off in cash, and the houses will have the same NOI.

Mortgage Interest, Depreciation, and Capital Expenses

These items sit “below the line,” meaning below NOI. They’re real, but they describe your financing and your taxes, not how the property operates.

Mortgage interest reduces your taxable income. Principal does not. You’re paying down your own loan, so principal never counts as an expense, even though the money leaves your account.

Depreciation lets you deduct the cost of the building over its useful life. For residential rental property, the IRS sets that period at 27.5 years, and you can’t depreciate the land (IRS, 2026). Depreciation is a paper expense. No check goes out the door, but it lowers your tax bill.

Capital expenses, like that new roof, work the other way. Cash goes out, but you don’t deduct the full amount this year. You depreciate it instead.

Net Income (Profit or Loss)

Net income is NOI minus mortgage interest and depreciation. It’s the number that flows to your tax return, and it often comes out lower than your actual cash, sometimes even negative on a property that pays you every month.

Rental Property Income Statement Example

Here’s a full-year income statement for a single-family rental. I used realistic 2026 numbers: a $240,000 purchase with 25% down, a $180,000 loan at 6.75% over 30 years, rent of $2,200 a month, and a building value of $192,000 after taking out the land.

Line item	Annual amount
Gross potential rent ($2,200 x 12)	$26,400
Other income (pet rent, late fees)	$570
Vacancy and credit loss (5%)	($1,320)
Effective gross income	$25,650
Property taxes	$3,300
Insurance	$1,750
Property management (8%)	$2,052
Repairs	$1,600
Cleaning and turnover	$400
Utilities (water, trash)	$720
Advertising	$150
Legal and accounting	$450
Total operating expenses	$10,422
Net operating income	$15,228
Mortgage interest (year one)	($12,091)
Depreciation ($192,000 / 27.5)	($6,982)
Net income (taxable)	($3,845)

That works out to a 6.3% cap rate on the purchase price. Nothing fancy. A solid, ordinary rental.

NOI vs Cash Flow vs Taxable Income

The same property produces three different “profit” numbers, and each one answers a different question.

Measure	Amount	What it tells you
Net operating income	$15,228	How the property performs
Cash flow	$1,218	What reaches your bank account
Taxable income	($3,845)	What you report to the IRS

Cash flow equals NOI minus the full mortgage payment of $14,010, which covers both interest and principal. Taxable income equals NOI minus interest and depreciation. So this house puts about $100 a month in your pocket and still shows a tax loss.

I learned this lesson the hard way on my first rental, a three-bedroom ranch I bought for $118,000 and self-managed. My income statement said I made $2,065 that year. My bank account said I lost almost $2,000.

Both were right. The furnace died the first winter ($4,600), the water heater followed it ($1,300), and I paid about $1,600 in principal that never showed up as an expense. None of that touched my P&L the way it touched my checking account.

That’s the year I started keeping a capex reserve, a separate pot of money for big replacements. The template tracks cash flow right under net income for exactly this reason.

How Do I Make My Own Income Statement?

You make your own income statement by gathering every dollar in and out for a set period, sorting each one into a category, and subtracting expenses from income. The template does the subtraction. Your job is the sorting.

1. Pick your period: a month, a quarter, or a year.
2. Give each property its own bank account, so business money never mixes with personal money.
3. Pull your leases, bank statements, receipts, and the Form 1098 your lender sends showing mortgage interest.
4. Sort every transaction into a category, using the Schedule E categories so tax time matches your books.
5. Pick cash basis (record money when it moves) or accrual basis (record it when it’s earned), and stick with it.
6. Check your rent income against your actual bank deposits. They should match.

Most small investors use cash basis. It’s simpler, and it matches how most landlords file.

Monthly, Year-to-Date, T12, or Annual?

Period	When you use it
Monthly	Spotting problems early
Year-to-date	Checking progress mid-year
T12 (trailing 12 months)	Refinancing, selling, buying
Annual	Filing taxes

A T12 covers the most recent 12 months regardless of the calendar year, like October through September. Lenders and buyers ask for it because it smooths out seasonal swings.

Which Schedule E Line Does Each Expense Go On?

Most landlords report rental income and expenses on Schedule E (Form 1040), in Part I, on lines 3 through 19 (IRS, 2025). If your income statement uses the same categories, your CPA can copy the numbers straight across.

Income statement line	Schedule E line
Rent and other rental income	Line 3
Advertising	Line 5
Auto and travel	Line 6
Cleaning and maintenance	Line 7
Commissions and leasing fees	Line 8
Insurance	Line 9
Legal and professional fees	Line 10
Management fees	Line 11
Mortgage interest	Line 12
Other interest	Line 13
Repairs	Line 14
Supplies	Line 15
Property taxes	Line 16
Utilities	Line 17
Depreciation	Line 18
HOA dues, pest control, other	Line 19

A few lines from your income statement never show up on Schedule E. Vacancy doesn’t, because you report the rent you actually received, not the rent you missed. Principal doesn’t, because it isn’t an expense. Capital improvements reach Schedule E only through depreciation on line 18.

Tax rules have exceptions, especially for vacation homes and properties you use yourself. Have a CPA look over your return before you file.

Real Estate Profit and Loss Statement Templates by Strategy

A real estate profit and loss statement looks different for each strategy because money comes in and goes out on a different schedule. A rental earns monthly. A flip earns once. A wholesaler earns fees and spends most of them on marketing. One generic template gives all three the wrong numbers.

Small Multifamily and Portfolio P&L

Once you own more than one property, give each one its own column and add a total. The portfolio tab handles up to six.

Here’s why it matters. A strong property can hide a weak one inside a combined total for years. When you line them up side by side, the property with a 50% expense ratio or a debt coverage under 1.0x stands out right away.

Fix and Flip Profit and Loss Statement

A flip P&L covers one project from purchase to sale, not one month. It lists the sale price at the top, then subtracts acquisition costs, rehab, holding costs, and selling costs.

National numbers make flipping look easier than it is. In the second quarter of 2026, the typical flip produced a gross profit of $60,526, a 21.5% margin (ATTOM, 2026). But ATTOM measures gross profit as the gap between the purchase price and the sale price, so its number leaves out rehab, holding, and selling costs (ATTOM, 2026).

Here’s the P&L from a flip I closed, held about five months on a hard money loan:

Line item	Amount
Sale price	$289,000
Purchase price	($185,000)
Buy-side closing costs	($3,200)
Rehab	($48,000)
Loan interest (12%, five months)	($8,750)
Points and lender fees	($3,500)
Taxes, insurance, utilities while holding	($2,900)
Agent commissions	($14,450)
Seller closing costs and concessions	($4,300)
Net profit	$18,900

The purchase-to-sale spread on that deal was $104,000. I kept $18,900. The flip tab shows both numbers next to each other, plus budget vs actual, so you can see exactly where the money went. On this one, rehab ran 9% over budget and the extra month of holding cost me nearly $2,000 in interest. Put the same lines in the per-deal projection of your house flipping business plan before you buy, so the budget column has something to be measured against.

One tax note: the IRS generally treats a flip as inventory, not rental property. You don’t depreciate it, and the profit usually counts as ordinary income. Confirm your situation with a CPA.

Wholesaling Business Profit and Loss Statement

A wholesaling P&L tracks a business, not a property. Income comes from assignment fees and double-close spreads, and the biggest expense is almost always marketing.

Wholesaling real estate looks simple on paper because you never own the property, but the expense side tells you whether the business actually works. Here’s one quarter for a small operation:

Line item	Amount
Assignment fees (4 deals)	$44,500
Direct mail	($9,800)
PPC and purchased leads	($6,500)
Skip tracing and data	($1,200)
Software (CRM, dialer, SMS)	($1,150)
Acquisitions commissions	($6,125)
Lost earnest money (failed deal)	($750)
Legal	($600)
Phone and miscellaneous	($400)
Net profit	$17,975

That quarter generated 410 leads, so marketing cost about $43 per lead and $4,375 per closed deal.

Watch your cost per lead next to the marketing line every quarter, because that’s the number that moves first when a campaign stops working. The wholesaling tab calculates it for you, along with cost per contract and your return on marketing spend.

Short-Term Rental Income Statement

A short-term rental income statement starts with nights booked and your average nightly rate instead of monthly rent. It adds cleaning fees you collect, subtracts platform fees, and tracks costs a long-term rental doesn’t have, like supplies, furnishings, and higher utilities.

Taxes get tricky here. Schedule E lists vacation and short-term rentals as their own property type (IRS, 2025). But if you provide substantial services for your guests, like regular cleaning during stays or changing linens, the IRS points you to Schedule C instead (IRS, 2026). The average guest stay can also change your depreciation period. Ask your CPA which rules apply to your property before you file.

Real Estate Agent Profit and Loss Statement

An agent’s P&L tracks a business, not a property. Income is commissions after your broker split. Expenses include MLS and association dues, marketing, licensing, and your car. Agents generally report this on Schedule C, not Schedule E.

Income Statement vs Pro Forma vs T12 vs Cash Flow Statement

An income statement shows what already happened, while a pro forma shows what someone expects to happen. Investors mix these up constantly, and sellers sometimes count on it.

Document	What it shows	When you use it
Income statement	Actual results for a period	Taxes, tracking, lending
T12	Actual results, last 12 months	Buying, selling, refinancing
Pro forma	Projected future results	Planning, pitching a deal
Cash flow statement	Actual cash in and out	Managing reserves

My rule: never price a deal off a pro forma alone. A pro forma tells you what the seller hopes. The T12 tells you what the property did.

How to Read a Seller’s Income Statement Before You Buy

You read a seller’s income statement by rebuilding it line by line from the rent roll, bills, and bank statements, then pricing the deal on your rebuilt NOI instead of theirs. Sellers rarely lie outright. They leave things out.

What to Ask the Seller For

Ask for a T12 broken out by month, the current rent roll, copies of every lease, the last two years of tax returns showing Schedule E for the property, 12 months of bank deposits, and 12 months of the utility bills the owner pays.

I ask for the T12 and rent roll in the letter of intent, before anyone gets emotionally attached to the deal.

Then I make access to the books a due diligence contingency in the real estate purchase agreement, so I can walk away if the numbers don’t hold up. A seller who won’t share documents has usually answered your question already.

Red Flags on a Seller’s P&L

The same five problems show up again and again:

• Zero vacancy. Nobody runs a rental for a year with zero vacancy and zero late payments.
• No management fee. The seller manages the property personally and prices their own time at nothing.
• Missing owner-paid utilities. Water and sewer on small multifamily often fall on the owner and quietly vanish from the statement.
• Repairs that look too low. Old roofs and 20-year-old water heaters don’t come with $1,900 repair budgets.
• “Market” rents instead of actual rents. The statement shows what units could rent for, not what tenants pay.

Tired landlords hand over the most misleading statements I see. Usually they aren’t trying to fool anyone. They stopped tracking their own costs years ago, and the statement reflects the property they remember, not the one they own.

Rebuilding the Numbers Before You Offer

Here’s a fourplex I bought from a tired landlord. He was asking $540,000, which matched his NOI at roughly an 8% cap rate. Then I rebuilt his statement from the leases, invoices, and utility bills.

Line item	Seller’s version	Rebuilt version
Gross rent	$52,800	$51,000
Vacancy and credit loss	$0	($3,060)
Property taxes	$5,200	$6,400
Insurance	$2,400	$3,100
Management	$0	$3,835
Repairs	$1,900	$3,600
Water and sewer	Missing	$3,000
Turnover and leasing	Missing	$1,200
Net operating income	$43,300	$26,805

His gross rent listed every unit at $1,100. The actual leases ran $950 to $1,150. Taxes would jump after the sale because the county reassesses on transfer. And the property had no management, no vacancy, and no water bill on paper.

Run the 50% rule as a quick check. The rule says operating expenses, not counting the mortgage, run about half of gross rent over time. Half of $51,000 is $25,500, which lands close to my rebuilt NOI of $26,805. The seller’s version implied expenses of just 18% of rent.

At the same 8% cap rate, my rebuilt NOI supported about $335,000, not $540,000. I offered $340,000 and walked him through the rebuilt statement line by line. We closed at $365,000.

The rebuilt NOI, not the seller’s version, should set your offer to a motivated seller. The Seller T12 Review tab in the template does this side by side and shows the value each version supports.

Which Numbers Do Lenders Pull From Your Income Statement?

Lenders pull your NOI, your debt service coverage ratio, and, for conventional loans, the numbers on your tax return. A clean income statement makes every one of those easier to defend.

The debt service coverage ratio (DSCR) divides NOI by your annual mortgage payments. The example rental above has a DSCR of 1.09, meaning NOI covers the mortgage with just 9% to spare. That’s thin. Many lenders want more cushion, so check your lender’s minimum before you apply.

For conventional loans, your Schedule E often matters more than your spreadsheet. Fannie Mae tells lenders to document rental income on properties you already own with your most recent tax return, including Schedule E (Fannie Mae, 2026). If a property doesn’t appear on Schedule E yet, the lender counts 75% of the lease amount instead (Fannie Mae, 2026).

Here’s the part most investors miss. When the lender figures your rental cash flow, it adds depreciation, interest, HOA dues, taxes, and insurance back to the net number on Schedule E (Fannie Mae, 2026). So a tax loss from depreciation doesn’t sink your loan application.

Private lenders and partners will want the same income statement attached to any real estate investment proposal you send them. They’ll also look at your cap rate (NOI divided by price) and your cash-on-cash return (annual cash flow divided by the cash you put in).

Common Income Statement Mistakes Investors Make

The most common income statement mistakes come from mixing up money that isn’t the same kind of money.

• Mixing personal and property money. One shared account turns your P&L into a guessing game and makes your records harder to defend in an audit.
• Deducting improvements as repairs. A new roof belongs in depreciation, not in this year’s repairs line.
• Depreciating the land. Only the building depreciates. Split the purchase price between land and building before you start.
• Leaving out vacancy and reserves. A property can show a profit for three years and then hand you a $12,000 roof in year four. Budget for it now.

Final Thoughts

An income statement isn’t paperwork. It’s how you know whether a property makes money, and it’s how you catch a seller’s numbers that don’t add up before you sign anything.

Grab the template, start with one property, and update it monthly. Once the habit sticks, you’ll read every deal differently. When you’re ready to run these numbers on real deals, our exchange lists verified off-market leads you can screen before you ever call a seller.

References

1. ATTOM, 2026. Home Flipping Profits Continue Gradual Two-Year Decline.
2. Fannie Mae, 2026. Selling Guide B3-3.8-04, Rental Income from Non-Subject Property.
3. Internal Revenue Service, 2025. Schedule E (Form 1040), Supplemental Income and Loss.
4. Internal Revenue Service, 2026. Publication 527 (2025), Residential Rental Property.