How to Track Rent and Tenants Without a Spreadsheet
To track rent and tenants without a spreadsheet, keep one record per unit, log each payment the day it lands, and check who has paid on the same day every month. Add a short list of expenses with a photo of each receipt and you have what you need at tax time. Most small landlords can set this up in an afternoon.
Why small landlords outgrow the spreadsheet
Most rentals in the U.S. are small. In the 2021 Rental Housing Finance Survey from HUD and the Census Bureau, nearly 46% of the 49.5 million rental units sat in properties with one to four units. Individual investors owned 70% of those small properties, and only about 22% of small properties were managed professionally (ALTA summary of the survey, Dec 6, 2022).
So most small landlords do the books themselves. A spreadsheet works for one unit. By three or four it starts to break: a tab per year, a column someone forgot to fill, a deposit nobody can find, and no reminder when rent is late. The fix is not a bigger spreadsheet. It is a simple routine and one place for each tenant.
Step 1: Make one record per unit
Start with a card for every unit. Put these on it:
- Tenant names and the best phone and email for each.
- Lease start and end dates, and the date you need to send a renewal or a notice.
- Monthly rent, the due day, the grace period and the late fee your lease sets.
- Security deposit: the amount, the date you got it and where it is held.
- Utilities: which ones the tenant pays and which ones you pay.
- Notes: pets, parking spot, the move in inspection photos.
Late fees and deposit rules are set by your state and sometimes your city, so check the rules where your property is before you write them into the lease.
Step 2: Log every payment the day it lands
For each payment, write down 4 things: the date, the amount, how it came in (check, bank transfer, app) and which month it covers. Do it the same day. A payment logged a week later is a payment you will argue about.
Pay attention to two kinds of money that are not regular rent. The IRS counts advance rent as income in the year you receive it, no matter which months it covers. A security deposit you plan to return is not income when you get it. If you keep part of it because the tenant broke the lease, the part you keep is income that year. And if the deposit is meant to be the last month's rent, the IRS treats it as advance rent (IRS, Rental income and expenses, updated Sep 8, 2026). Keep deposits on their own line so you never mix them into rent.
Step 3: Check who paid on the same day every month
Pick one day: the first day after the grace period ends. On that day:
- Go down your units and mark each one paid, partly paid or not paid.
- Send a short, friendly reminder to anyone not paid. For example: "Hi Dana, a reminder that November rent for Unit 2 was due on the 1st. Let me know if anything is going on."
- If the lease has a late fee, add it now and note the date.
- Write down any promise to pay and the date they gave you.
A polite text on the right day is easier on both of you than a hard talk two months later.
Step 4: Track expenses by property
The IRS says to keep good records of your rental income and expenses, and that expenses generally need proof such as receipts, canceled checks or bills (IRS, Tips on rental real estate recordkeeping, updated Apr 4, 2026). Rental income and expenses usually go on Schedule E, Part I.
- Snap a photo of every receipt the day you pay it.
- Tag it with the property and a plain category: repairs, supplies, insurance, taxes, utilities, mortgage interest, travel to the property.
- Keep repairs and big improvements apart. Your tax preparer will treat them differently.
Step 5: Keep a list of repair requests
Tenants remember how fast you fixed the sink. Keep one running list per unit with the date the request came in, what it was, who fixed it, what it cost and the date it was done. This list protects you in a deposit dispute and tells you which unit costs the most to keep up.
Step 6: Set reminders for the dates that cost money
- Lease ends: a reminder 90 days ahead and again at 60, so you can renew or list the unit with time to spare.
- Rent changes: the date a new rent starts and the notice your state requires before it.
- Insurance and property tax: due dates for each property.
- Move outs: the deadline in your state to return the deposit or send an itemized list.
A monthly routine that takes 20 minutes
- Due day plus grace: mark who paid and send reminders.
- Same day: log any new receipts and repair costs.
- End of month: total rent collected, total expenses and what is still owed, per property.
- Once a quarter: look at leases ending in the next 90 days.
Two numbers tell you how the month went: rent collected against rent due, and days late on average. If one tenant keeps showing up late, talk to them early.
Keep your tenants talking about you
Good landlords and property managers get found the same way a shop does: on Google, by their reviews. If you manage for others or want better applicants, ask happy tenants for a review when they renew. The steps in our guide on getting more Google reviews work the same way for a rental.
The Owner's Page runs this from one page for $20 a month. It keeps each tenant, the rent due date and who has paid in one place, with your Google reviews and posts on the same page. You answer 2 questions and your page is built. See the page for property managers.
See a finished example for your kind of business, then make it yours. Sales, customers, Google and posts in one place. $0 to look. $20 a month when you turn it on.
See an example pageQuestions
What is the easiest way to track rent for a few units?
Keep one record per unit with the tenant, rent, due day and deposit. Log each payment the day it lands, and check who has paid on the same day every month, right after the grace period ends.
Is a security deposit income for a landlord?
Not when you plan to give it back. The IRS says a deposit you keep because the tenant broke the lease is income that year, and a deposit meant as the last month's rent counts as advance rent when you get it.
Do I have to report rent paid in advance this year?
Yes. The IRS counts advance rent as income in the year you receive it, no matter which months it covers.
What records should a small landlord keep for taxes?
Records of all rental income and expenses, with proof for expenses such as receipts, canceled checks or bills. Keep them by property so they match what goes on Schedule E.
When should I send a late rent reminder?
On the first day after the grace period in your lease ends. Keep it short and friendly, add the late fee only if your lease and local rules allow it, and write down any date the tenant promises to pay.
When should I start on a lease renewal?
Set a reminder 90 days before the lease ends and another at 60, so you have time to renew or list the unit.