How to track rental property income and expenses (free spreadsheet template)

Why track every month

A calculator tells you what a property should earn. Tracking tells you what it actually earned. The two drift apart: a tenant pays late, the insurance renews higher, a water heater fails. Owners who check monthly catch a losing property in one quarter instead of at tax time, when the year is already gone.

What to record

For each property, every month, write down what came in and what went out, sorted into a few categories:

• Money in: rent actually received (not what was due), plus other income such as parking, laundry, pet fees, late fees and, on commercial leases, tenant reimbursements for taxes and common-area costs.
• Operating costs: property tax, insurance, HOA dues, repairs and maintenance, utilities the owner pays, property management and other recurring costs.
• Mortgage payments: kept separate, because they depend on your financing rather than on how the property performs.
• Improvements (capital expenses): a new roof, HVAC system or remodel. Also kept separate, since they're occasional and large.

If your lender collects taxes and insurance through escrow, record the escrow portion under tax and insurance rather than lumping the whole payment in as “mortgage”, or your operating costs will look too low. Security deposits aren't income while you hold them; record one only if you keep it.

Two spreadsheet layouts that work

One row per payment is the easiest to keep up and the most flexible: a date, the property, a category, an optional description and the amount (money in as positive, money out as negative). Our free template uses this layout.

One row per month, with a column for each category (Rent, Mortgage, Repairs, and so on), is quicker to read for a single property. It gets awkward with many properties or many small repairs.

Either layout can be uploaded to the rental dashboard, which reads Excel and CSV files in your browser and charts them. Adding columns for property type, purchase price and current value lets it show a whole portfolio by type and estimate how its value has grown.

The numbers to check each month

NOI = money in − operating costs

Cash flow = NOI − mortgage payments − improvements

Net operating income shows how the property itself is doing. Cash flow shows what reached your pocket. Watch three more:

• Rent collected vs. rent expected. Anything under about 95% over a few months points to vacancy, late payers or rent below market.
• Expense ratio (operating costs ÷ income). Many single-family rentals run 35–50%; a jump usually means one cost category needs a look.
• Which properties are losing money. A portfolio can look fine overall while one or two properties drain the rest. Check cash flow property by property.

A worked month

One plumbing call took more than half of that month's profit. That's normal; repairs come in lumps, which is why a single month means little and the trend over a year means a lot. Compare a full year against the estimate you made with the rental cash flow calculator when you bought.

A 15-minute monthly routine

1. Download last month's bank and card statements for your rental accounts.
2. Add each rental payment to your sheet, with the property and category.
3. Note any rent that didn't arrive and follow up the same week.
4. Check each property's cash flow and the portfolio's expense ratio.
5. Save a copy (or a dashboard backup) somewhere safe.

Common mistakes

• Mixing personal and rental money. A separate bank account for rentals makes tracking (and tax time) far easier.
• Recording rent due instead of rent received. Your bank balance only knows what arrived.
• Counting improvements as repairs. A $12,000 roof in one month makes a good property look terrible if it sits in operating costs. Keep improvements in their own category.
• Tracking only once a year. By then a vacancy or a cost increase has had twelve months to add up.

This is a system for knowing how your rentals perform. How income and expenses are treated for taxes depends on your situation; ask a tax professional.