Rental Property Income & Expense Tracker

What you must track per property

Track everything at the property level, not just in one big pile. When you sell, refinance, or get audited, "the portfolio did fine" isn't an answer — per-property numbers are.

• Income: rent collected (by unit and month), late fees, pet rent, laundry or parking income, and any other receipts. Log the date received, not just the month — it matters for security-deposit disputes and vacancy math.
• Operating expenses: mortgage interest (not principal — principal isn't deductible), property taxes, insurance, HOA dues, property management fees, utilities you pay, repairs and maintenance, pest control, landscaping, snow removal.
• Turnover costs: cleaning, painting, lock changes, advertising, tenant screening — tracked separately, because a $2,800 turnover is the real cost of a vacancy, not just the lost rent.
• Capital improvements: roof, HVAC, appliances, flooring. These get depreciated over years rather than deducted at once — your CPA needs them itemized with dates and amounts, not buried in "repairs."
• Mileage and travel: trips to the property, to the hardware store, to meet contractors. At the 2026 IRS rate of $0.76/mile, 2,000 landlord miles is a $1,520 deduction most owners simply forget.

The three numbers that tell you the truth

Once the tracking exists, three calculations tell you whether a property earns its keep:

1. Monthly cash flow = rent collected − (mortgage payment + taxes + insurance + all operating expenses). Positive is good; consistently under $200/door after all expenses means you're working for free.
2. True vacancy cost = lost rent + turnover expenses + your time. A one-month vacancy on a $1,600 unit with a $2,200 turnover costs $3,800 — which is why tenant retention beats rent increases.
3. Maintenance reserve rate = maintenance spend ÷ gross rent. Under 5% and you're probably deferring (a future roof bill is forming); over 15% sustained and the property may be a money pit wearing a rental costume.

None of these are visible without categorized tracking. That's the whole game.

Spreadsheet vs. shoebox vs. software

For most landlords, the spreadsheet is the sweet spot: Schedule-E-ready categories, per-property profit and loss, and no monthly fee eating the cash flow you're trying to measure. Software earns its keep around ten-plus doors or when you hire a manager who needs access.

The 20-minute monthly routine

1. Log the month's income — rent per unit, fees, other income. Five minutes.
2. Enter expenses from statements — mortgage, taxes, insurance, plus any receipts from repairs. Categorize as you go; never "later."
3. Photograph receipts immediately. Phone photo → cloud folder named Property / Year / Month. Paper fades; the IRS accepts digital.
4. Review the per-property P&L. Is cash flow positive? Any category spiking? This is where you catch the slow leak — the water bill creeping up for three months before anyone notices the running toilet.
5. Update the mileage log while the trips are fresh. Reconstructing December mileage in April is how deductions die.

Depreciation: the quiet giant

The biggest rental "expense" most landlords never feel is depreciation — the IRS lets you deduct a portion of the property's value (excluding land) every year for 27.5 years on residential rentals. On a $275,000 building value, that's roughly $10,000 a year in paper deductions against your rental income, and it often turns a cash-flow-positive property into a tax loss on paper. Two things matter for tracking: first, keep the purchase closing statement forever — it establishes your starting basis. Second, log every capital improvement separately with its date and cost, because each one starts its own depreciation clock. This is the category where good tracking literally pays for itself at tax time.

Frequently asked questions

Related guides

• Mileage Log for Tax Deductions — stop leaving the $0.76/mile landlord deduction on the table.
• Schedule C Deductions Checklist — the self-employed companion for side-income landlords.
• Monthly Budget Template for Excel — keep the personal budget as clean as the rental books.