How to Track Rent for 1–10 Rental Units (Without Expensive Software)

If you rent out one to ten homes, you probably don't need property management software built for 200-unit operators. What you need is a simple system that answers three questions at any moment: who paid, who owes, and what's late.

Most small landlords start with a mix of spreadsheets, text messages, and memory. That works until a tenant pays half, a repair gets lost in a text thread, or two units turn over in the same month. Here's a system that holds up.

The core idea: one row per unit per month

Every month, each unit gets one row. That's it. One row per unit per month keeps the record simple enough to maintain and complete enough to trust.

ColumnWhat goes in it
Month2026-11
UnitUnit A / 742 Oak St, Apt 2
TenantWho lives there now
Rent dueThe monthly amount
Due dateUsually the 1st
Amount paidWhat actually came in
Date paidWhen it arrived
MethodZelle, check, cash, bank transfer
Late feePer your lease, after the grace period
BalanceRent due + late fee − amount paid
Notes"Rest promised by the 15th"

The balance column is the whole system in one number: anything above zero is money still owed.

Partial payments and late fees

Partial payments are where most landlords' tracking breaks. The fix is boring on purpose: record exactly what arrived, on the date it arrived, and let the balance show what's left. Don't overwrite the rent-due amount — the balance does the math.

Late fees work the same way. Set a grace period in the lease (commonly 3–5 days), and only add the fee once the grace period passes. Use our free late-fee calculator to work out what a tenant owes. Rules on late fees vary by state and lease, so check your local rules — this is record-keeping guidance, not legal advice.

Track expenses and maintenance next to the rent

Rent is only half the picture. Log expenses (repairs, supplies, fees) per property with a date and category, and keep maintenance requests in one list with a status — open, in progress, done. When a tenant texts about a leak, it goes in the list the same day. That list is what keeps a small repair from becoming a big one.

The month-end routine: five numbers

Once a month, pull these five numbers together and you'll always know where the portfolio stands:

  1. Rent due this month
  2. Rent collected
  3. Rent still outstanding (and who owes it)
  4. Expenses this month
  5. Net for the month

When a spreadsheet stops being enough

A spreadsheet is a fine start. It starts to strain when you have several units, tenants paying at different times, and maintenance requests piling up — because every update is manual and nothing reminds you what's overdue. That's when a simple app earns its keep: it flags overdue rent automatically, applies the late fee, and keeps expenses and maintenance in the same place as the rent.

Start with the free version of this system.

Our free rent-tracking spreadsheet has this exact layout built in — the columns above, the balance formula, an expenses tab, and a monthly summary. Download it, use it as long as you like.

Download the free spreadsheet

When you're ready for automatic overdue flags and late fees, RentHearth is $19/month with a 14-day free trial.

This guide is general information about record-keeping, not legal, tax, or accounting advice. Late-fee rules, notice periods, and deposit rules differ by state — check your local rules or a qualified professional.