How to Track Rent Payments: A Simple System for Small Landlords
To track rent payments, give every unit one row per month that shows the rent due, each payment received with its date and method, any late fee, and the balance still owed. Check it on the same days each month, give receipts for cash, and keep rent in its own bank account. For a few units this takes about 15 minutes a month in a spreadsheet.
What do you need to record for each payment?
| Field | Why it matters |
|---|---|
| Unit and tenant | So every payment lands on the right account |
| Month the rent is for | A payment on 11/02 may still be for October |
| Amount due | Rent plus any fees from the lease |
| Date received | Decides whether it was late |
| Amount received | Shows partial payments clearly |
| Method | Check number, Zelle, ACH, money order or cash |
| Late fee | Only if your lease and state law allow it |
| Balance | What is still owed after this payment |
The balance column is the one that saves you. When a tenant, a court or a housing agency asks what is owed, you can answer in seconds with a tenant ledger.
How to set up your rent tracker in 5 steps
- List your units. One line for each door, such as 1418 Elm St Unit A and Unit B.
- Add tenants and leases. Monthly rent, due date, grace period and late fee from each lease.
- Open a separate bank account for rent. Ask tenants to pay only into it. Your bank statement becomes a second record.
- Pick the payment methods you accept and write them in the lease.
- Create the rows for the year. Our template creates one row per unit per month and marks each one Paid, Paid late, Partial, Unpaid or Vacant.
Your 15 minute monthly routine
| When | What to do |
|---|---|
| Day 1 to 2 | Check the rent account. Enter every payment with date and method. |
| Day after the grace period ends | Mark unpaid units. Add a late fee if your lease and state law allow it. See late rent fee rules. |
| Same day | Send a friendly reminder or a written late notice. |
| Any cash or money order | Give a receipt right away. Use our rent receipt template. |
| End of month | Match the ledger to the bank statement. Every deposit should match a ledger line. |
Which payment methods are easiest to track?
| Method | Tracking tip |
|---|---|
| Zelle or bank transfer | Ask tenants to add the unit and month in the memo |
| ACH through a rent app | Export the payment report each month |
| Check | Record the check number, deposit within a few days |
| Money order | Copy the serial number before you deposit it |
| Cash | Always give a written receipt. Some states, such as New York and Texas, require one |
Example: one month for a duplex
James Carter owns a duplex. Rent is $1,350 for each unit, due on the 1st, with a 5 day grace period and a $50 late fee in the lease. In October 2026:
| Date | Unit | Entry | Charge | Payment | Balance |
|---|---|---|---|---|---|
| 10/01/2026 | A | October rent | $1,350.00 | $1,350.00 | |
| 10/01/2026 | A | Zelle payment | $1,350.00 | $0.00 | |
| 10/01/2026 | B | October rent | $1,350.00 | $1,350.00 | |
| 10/03/2026 | B | Partial payment, check #2214 | $900.00 | $450.00 | |
| 10/07/2026 | B | Late fee (after grace period) | $50.00 | $500.00 | |
| 10/12/2026 | B | Zelle payment | $450.00 | $50.00 |
At a glance James can see that Unit A is paid and Unit B still owes $50. Before he accepted the partial payment he checked the rules in our partial rent payment guide, because in some states accepting part of the rent can affect an eviction.
When should you switch to rent software?
A spreadsheet works well for small landlords. Consider an app if most tenants want to pay by card, you want automatic reminders, or you keep forgetting to enter payments. Our Stessa vs TurboTenant vs Baselane comparison shows the real fees.
Late fee and receipt rules differ by state and city. Check your local rules before you charge a fee or refuse a payment.
Keeping records for years, not just months? Read landlord record keeping: what to keep and for how long.
Have more than one unit? See how to keep a rent ledger for a duplex or triplex in one file.
Frequently asked questions
What is the easiest way to track rent payments?
For a small landlord, a spreadsheet with one row per unit per month and a running balance is the easiest and cheapest way. Pair it with a separate bank account for rent.
Should I keep a separate bank account for rent?
Yes. It makes every payment easy to find, keeps rental money out of your personal spending and makes tax time much simpler.
How do I track a partial rent payment?
Enter the full rent as the charge, the partial amount as a payment, and let the balance show what is still owed. Check your state rules before accepting it.
Do I have to give receipts for rent?
Some states require receipts for cash payments, and some tenants ask for them. Giving a receipt for every cash or money order payment protects both of you.
How long should I keep rent records?
Keep them at least as long as you keep the tax return they support, generally 3 years after filing, and longer if a dispute is possible.
