Free rent tracking template for landlords with 1–5 units
Stop tracking rent in a notebook. Download a simple spreadsheet that shows who paid, who's late and how much came in this month.
Use it in Excel, Google Sheets or Numbers. One row per unit per month: fill in what was due and what came in, and the balance column shows who still owes rent.
Google Sheets: File › Import › Upload. Excel and Numbers: just open the file.
What the template looks like
| Month | Unit | Tenant | Rent due | Due date | Amount paid | Date paid | Method | Late fee | Balance | Notes |
|---|---|---|---|---|---|---|---|---|---|---|
| 2026-11 | Unit A | J. Smith | 1,450.00 | 2026-11-01 | 1,450.00 | 2026-11-01 | Zelle | 0.00 | 0.00 | |
| 2026-11 | Unit B | R. Lopez | 1,200.00 | 2026-11-01 | 600.00 | 2026-11-03 | Check | 0.00 | 600.00 | Rest promised by 11/15 |
| 2026-11 | Unit C | Vacant |
Balance = rent due + late fee − amount paid. The CSV already has the formula in each row for 5 units.
A 10-minute monthly routine
- Before the 1st: copy last month's rows and change the month and due dates.
- As payments arrive: enter the amount, date and method the same day, so nothing is forgotten.
- After your grace period: sort by Balance. Anything above zero gets a friendly reminder.
- Late fees: only charge what your lease allows, and check your state's rules on late-fee limits and timing.
- Month end: total the Amount paid column. That's your rental income for the month.
- Keep receipts: note repairs and expenses too. You'll need them at tax time.
Rather not update a spreadsheet?
RentWise tracks rent, tenants, leases, expenses and maintenance on your phone, and exports CSV and PDF reports. The basic plan covers up to 2 properties.
Questions
Is the template really free?
Yes. Download it, copy it and change it however you like. No sign-up needed.
Does it work in Google Sheets?
Yes. In Google Sheets choose File › Import › Upload and pick the CSV. The balance formulas carry over.
How many units can I track?
The file starts with 5 units. Copy a row to add more.