How to Track Rental Property Cash Flow in a Spreadsheet

Landlords with one to a handful of units rarely need a full property management platform on day one. They need a clear monthly picture: rent collected, expenses paid, cash left over, and year-to-date totals for tax prep. A free rental property tracker spreadsheet does exactly that per unit.

Set up one row per unit (or one tab per property)

For each rental:

1. Monthly rent — contract amount, not what you hope to collect.
2. Actual rent received — what hit the bank, including late payments in the month they arrived.
3. Operating expenses — mortgage interest, insurance, repairs, utilities you pay, HOA, management fees.
4. Net cash flow — rent received minus expenses for the month.

Roll those nets up quarterly and annually. That is the number you care about when deciding whether to keep, sell, or refinance.

Log expenses when you pay, not at tax time

The painful landlord spreadsheet is the one rebuilt from bank statements in March. Enter expenses when they happen — even a note in the sheet with the receipt filed elsewhere. Categories matter for Schedule E: repairs vs. improvements, mortgage interest vs. principal.

Use the sheet to spot problems early

• Vacancy — zero rent received for a month should trigger a vacancy row, not a missing update.
• Expense spikes — a $3,000 repair line should prompt a note on what broke and whether it is recurring.
• Negative cash flow streaks — three red months means revisit rent, expenses, or the hold/sell decision with real numbers.

When to upgrade beyond a spreadsheet

Multi-unit operators who need tenant portals, maintenance ticketing, automatic rent reminders, or owner statements at scale will outgrow a sheet. Until then, a well-maintained tracker beats an expensive platform you only use as a glorified ledger.

These templates are operational record tools, not tax or legal advice. Consult a qualified tax professional for rental reporting requirements.