The Owner's Page

How to Track Rent and Tenants Without a Spreadsheet

The Owner's Page · November 7, 2026

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:

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:

  1. Go down your units and mark each one paid, partly paid or not paid.
  2. 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."
  3. If the lease has a late fee, add it now and note the date.
  4. 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.

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

A monthly routine that takes 20 minutes

  1. Due day plus grace: mark who paid and send reminders.
  2. Same day: log any new receipts and repair costs.
  3. End of month: total rent collected, total expenses and what is still owed, per property.
  4. 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.

Your whole business, on one page.

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 page

Questions

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.