Rental Property Income Statement: Template

A rental property income statement lists one property's rental income and operating expenses for a month, quarter, or year. It shows net operating income (NOI); a separate cash-flow section subtracts loan payments and capital spending. Below you'll find a reusable template, a worked example, and a month-end checklist.

What an income statement actually is

An income statement is also called a rental profit and loss statement (P&L). Keep one per property, with the property address, reporting period, and accounting basis at the top. A trailing 12-month statement (T-12) combines the most recent 12 months. A rent roll, by contrast, lists leases and scheduled rent, not expenses or profitability.

Rental property income statement template

Copy these rows into a spreadsheet, with one column per month and a year-to-date total. For a collected-income report, start with rent actually received. Keep scheduled rent and unpaid balances alongside it for comparison, rather than counting unpaid rent as cash.

The standard structure

Keep the operating result separate from financing and capital spending. Here's what goes where.

1. Gross income

• Rent received on a cash basis, or earned on an accrual basis
• Late fees, pet fees, parking, laundry, storage
• Lease cancellation fees
• Security deposits retained as income; refundable deposits held are not income

2. Vacancy & bad debt

On a scheduled-rent analysis, show rent lost to vacancy and rent not collected as separate deductions. On a cash-basis report, track those gaps separately from expenses. A lender's assumed vacancy allowance belongs in its underwriting forecast, not in your historical actuals.

3. Operating expenses

The non-debt costs of keeping the property running:

• Property taxes
• Insurance (landlord policy, umbrella allocation)
• Property management fees
• Repairs & maintenance
• Routine turnover costs (cleaning, touch-up paint, leasing fees)
• Utilities you (not tenant) pay
• HOA / condo dues
• Lawn / snow / pest
• Accounting, software, legal

4. Net Operating Income (NOI)

Effective rental income − operating expenses. NOI excludes mortgage, depreciation, and capital expenditures. It's the number banks and appraisers use to value the property — see cap rate vs cash-on-cash.

5. Debt service

Principal + interest on every loan against the property. List separately if you have multiple loans (1st mortgage, HELOC). Escrowed property taxes and insurance still belong in operating expenses, not debt service; do not count them twice.

6. Cash flow

NOI − debt service is cash flow before capital spending and income tax. Subtract actual capital spending to show cash flow after CapEx. Manager reserve transfers and owner distributions can make the bank deposit different from either figure.

7. Below-the-line items (optional, but useful)

• Capital expenditures (CapEx)
• Depreciation (non-cash, but lowers tax)
• Principal paydown (not an expense — it's equity)

Worked example: a single-family rental, full year

This is an illustrative example, not a customer's records. Assume scheduled rent of $1,800 per month, $1,038 of uncollected rent, and the annual expenses and P&I payments shown below.

Operating expenses total $11,154: $20,682 − $11,154 = $9,528 NOI. Subtract $18,420 of loan payments for −$8,892 before CapEx, then $9,000 for the roof to reach −$17,892 after CapEx. The roof lowers cash flow, not NOI. See how rental records flow onto Schedule E and how depreciation is calculated.

Right vs wrong: how landlords get NOI wrong

The same property looks completely different when line items are miscategorized. Underwriters spot this instantly.

Related reading

• Cap rate vs cash-on-cash return — what NOI feeds into
• How to analyze a rental property — using the statement to underwrite deals
• When to refinance — banks pull NOI straight from this document
• How rental income is taxed — mapping line items to the tax return

Common mistakes

• Mixing repairs and capital improvements (deflates NOI artificially)
• Including principal paydown as an expense (it's equity, not cost)
• Including depreciation in operating expenses (banks back it out anyway)
• Mixing scheduled rent and collected rent without labeling the basis
• One blended statement for the whole portfolio (you can't see which property is bleeding)

Income statement vs cash flow vs Schedule E

NOI measures property operations. Cash flow also accounts for full loan payments and capital spending. Taxable rental income uses tax rules: mortgage interest may be deductible, principal is not, and depreciation is a non-cash deduction. An operating statement is supporting bookkeeping, not a substitute for Schedule E or a promise that every expense is deductible.

The IRS explains cash versus accrual reporting, refundable deposits, deductible interest, repairs, and improvements in Publication 527 (Residential Rental Property). Confirm tax classifications with your tax professional.

Month-end checklist: build it without double-counting

1. Choose one property, one reporting period, and a consistent accounting basis.
2. Check rent received against the lease ledger; show vacancy and unpaid rent separately.
3. Review the property manager's statement and include expenses you paid directly.
4. Match invoices to statement charges. An invoice supporting an existing charge is backup paperwork, not another expense.
5. Separate routine repairs from capital improvements, and separate P&I from taxes and insurance.
6. Recompute NOI and cash flow, then check the distribution against your bank deposit and any manager reserve changes.

Start with the owner statement walkthrough if you use a property manager, or use the rental income calculator to explore income and expenses before building your monthly report.

How often to run one

• Monthly: catch leaks early (5-minute review)
• Quarterly: compare to YTD budget
• Annually: feeds Schedule E, refi packages, sale memos