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.
| Column | What goes in it |
|---|---|
| Month | 2026-11 |
| Unit | Unit A / 742 Oak St, Apt 2 |
| Tenant | Who lives there now |
| Rent due | The monthly amount |
| Due date | Usually the 1st |
| Amount paid | What actually came in |
| Date paid | When it arrived |
| Method | Zelle, check, cash, bank transfer |
| Late fee | Per your lease, after the grace period |
| Balance | Rent 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:
- Rent due this month
- Rent collected
- Rent still outstanding (and who owes it)
- Expenses this month
- 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.
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 spreadsheetWhen 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.