b2KIT

Rental Income & Expense Tracker

Track rental property income, expenses, and net operating income with monthly/yearly summaries and Schedule E categories.

Tested tool guide Tested browser tools Checked August 16, 2026

What Rental Income & Expense Tracker does, with a checked example

A mortgage payment is not an operating expense, and this tool is built around that rule. You log each dollar in or out with a date and a Schedule E category, and it rolls the entries into monthly and yearly summaries, ending in net operating income: rent collected minus operating expenses, before debt service, depreciation, and income tax. The thing most users trip on is that the payment to the bank never appears in NOI, so a property can show a healthy $1,000 NOI while the owner still covers a shortfall every month.

Worked example

A concrete input and expected output from the current implementation.

Input

Rent received: $1,500. Taxes: $180. Insurance: $60. Repairs: $110. Utilities: $90. Management fees: $60.

Expected output

May 2026 summary: income $1,500; expenses $500, split as taxes $180, insurance $60, repairs $110, utilities $90, management fees $60; net operating income $1,000.

Rent minus the five operating expenses is $1,000, and the mortgage is absent by design: NOI excludes debt service, so against a $1,300 payment the $1,000 NOI still leaves a $300 cash shortfall.

How the result is produced

1

Entries and categories

Each entry is an amount tied to a date and one of the Schedule E categories, from rent received to advertising, cleaning and maintenance, insurance, mortgage interest, repairs, taxes, and utilities. Income and expense entries tally separately, so a misdated December repair shifts the whole year it appears in.

2

Monthly and yearly NOI

The tool groups entries by month and by year, sums income and operating expenses per category, and subtracts the expense total from rental income to produce net operating income. Because NOI excludes debt service, depreciation, and capital improvements by definition, the summary describes operating performance, not cash flow and not taxable profit.

Good uses

  • Year-end tax prep: pull each category's yearly total, from repairs to mortgage interest to taxes, and transfer them line by line onto Form 1040 Schedule E Part I.
  • Monthly property review: tell whether this month's NOI dip is a one-off repair or a recurring cost, like utilities that have crept up three months running.
  • Rent-setting check: see how much of current rent operating expenses consume, and how much headroom remains before a month turns negative.

Limits and checks

  • Positive NOI is not positive cash flow. The mortgage never enters the number, and capital improvements, like a new roof, are not operating expenses, so a month can show $1,000 NOI while the owner still pays money out of pocket.
  • Totals depend entirely on the date and category you attach to each entry. A repair paid in December but logged in January lands in the wrong tax year, and prepaid insurance entered as one lump lands on a single year instead of the months it covers.
  • NOI is not taxable income even though the categories are Schedule E's. The form also deducts mortgage interest and depreciation, both absent from NOI, so positive NOI can sit beside a Schedule E loss, and a cash-negative year can still be a tax write-off.

Common questions

Should the mortgage payment go in as an expense?

For net operating income, no. NOI deliberately ignores all debt service, so the tracker holds only the interest portion, under mortgage interest, because that is the line Schedule E asks for. Principal paydown is neither an operating expense nor a tax deduction. If you want true cash flow, subtract the full payment separately, outside the NOI view.

Why doesn't my yearly summary match my tax return?

Most often because of depreciation: it is a large Schedule E deduction that no cash entry produces, so a cash-based tracker will not show it. Interest-versus-principal splits and which year you log a payment in can shift totals too. The tool is exact for what you enter; a mismatch usually means a missing deduction, not an arithmetic error.

References and verification

The example and behavioral notes were checked against the browser implementation. Standards and primary references below define the relevant format, formula, or platform behavior.

Related Tools