Home › Guides › Track rent payments

How to track rent payments: a simple system for small landlords

By Spruce Sheets · Updated November 14, 2026 · 6 min read

Collecting rent is the heart of being a landlord, and tracking it is where small mistakes turn into big arguments. "I paid that in March" is easy to settle if your records are clear and hard if they're scattered across bank apps, texts and a notebook. Here's a simple system that works whether you have two units or forty.

What a good rent tracking system does

It should answer four questions in seconds:

1. Who has paid this month, who paid part, and who hasn't paid?
2. What does each tenant owe right now, and since when?
3. What did a specific tenant pay, and when, over the whole lease?
4. Does the rent you recorded match the money in your bank account?

If your current method can't answer all four, it's worth fixing before the next dispute or the next tax season.

Step 1: Make payments traceable

The easiest rent to track is rent that arrives electronically into one dedicated bank account, with the tenant's name and unit in the reference. Some practical choices:

• Use one account for all rental income, separate from your personal money.
• Prefer traceable methods: bank transfer, ACH through a rent-collection service, or checks you deposit promptly. Each one leaves a record.
• Avoid cash where you can. If you accept cash, always give a receipt and deposit it intact. Some states require a receipt: in New York, for example, landlords must give a written receipt for rent paid in cash or by anything other than the tenant's personal check (Real Property Law § 235-e).
• Ask tenants to use a reference, such as "Unit 2B March rent", so deposits are easy to match.

Step 2: Keep a ledger for each tenant

A tenant ledger lists every charge (rent, late fees, utility bill-backs, repair charges the lease allows) and every payment or credit, in date order, with a running balance. A positive balance means the tenant owes you; a negative balance means they've paid ahead.

The ledger is the single source of truth for each tenancy. It's what you'd print if a tenant disputes a balance, and what a court would want to see in a nonpayment case. We cover the columns in detail in rent ledger template: what to include.

Step 3: Run a monthly rent roll check

Once rent is due, look at all units side by side. Here's a made-up four-unit example a few days after the 1st:

Unit	Rent due	Received	Status	Still owed
A	$1,350	$1,350	Paid	$0
B	$1,275	$1,000	Partial	$275
C	$1,150	$0	Not paid	$1,150
D	$1,600	$1,600	Paid	$0
Total	$5,375	$3,950		$1,425

Collection rate this month: $3,950 ÷ $5,375 = 73.5%. Two follow-ups are needed: a reminder to Unit B about the $275 balance and a check-in with Unit C. Doing this on a fixed day each month (say, the day after your grace period ends) turns rent collection into a routine instead of a worry.

Step 4: Handle partial payments consistently

Partial payments are where tracking breaks down. A few rules keep things clean:

• Record the money you actually received, on the day you received it. Don't "round up" a partial payment as paid.
• Let the balance carry forward. The ledger should show the $275 owed by Unit B rolling into next month if it isn't paid.
• Apply payments in a consistent order. Many landlords apply payments to the oldest charges first. Your lease may specify an order, and some jurisdictions have rules about it, so check before you choose.
• Write down any payment plan you agree to, with dates and amounts, and note it in the ledger.
• Know your local rules. In some states, accepting a partial payment can affect an eviction that's already underway. If you're in a dispute with a tenant, check with a local attorney before accepting a partial payment.

Step 5: Late fees, if your lease has them

If your lease includes a late fee, apply it the same way to every tenant, and record it as a separate charge in the ledger (not by changing the rent amount). Many states and some cities limit late fees or require a grace period. See late rent fees: how to calculate and track them.

Step 6: Reconcile with your bank

Once a month, compare the payments in your ledgers with the deposits in your bank account. Every deposit should match a recorded payment, and every recorded payment should match a deposit. Differences usually mean a payment logged to the wrong tenant, a typo, or a bounced check that needs reversing (record the reversal and any returned-check fee your lease allows as new lines, rather than deleting the original payment).

Step 7: Pass rent income to your books

Rent is your main income line on Schedule E. If your rent ledger can list payments in the same format as your bookkeeping income log, month-end is a copy-and-paste instead of retyping. Keep security deposits separate: a deposit you expect to return isn't income when received, according to IRS Publication 527, while advance rent is income when you receive it.

Following up on late rent

A calm, consistent routine works better than improvising:

1. The day after the grace period ends: a friendly written reminder with the amount owed and how to pay.
2. A few days later: a call or message to understand what's going on. Many late payments are one-off problems that a short payment plan solves.
3. If it continues: a formal written notice, following your state's rules for content, delivery and timing. Notice requirements before an eviction filing vary widely by state.

Write down every contact in the tenant's ledger notes: date, method and what was agreed. If a dispute escalates, that record matters.

What to keep, and for how long

Keep leases, ledgers, receipts, payment records and notices for each tenancy. For tax purposes, the IRS generally says to keep records supporting your return until its period of limitations expires (three years in the normal case, longer in some situations). Many states also have rules about deposit records and statute-of-limitations periods for disputes, so many landlords keep tenancy records for several years after a tenant moves out.

Spreadsheet, app or notebook?

• A notebook works for one unit, but you can't sort, total or print it neatly.
• A spreadsheet handles a few to a few dozen units well, costs little, and keeps your data on your own computer or Drive.
• Property management software adds online payments and tenant portals, usually with a monthly fee or tenant-paid fees.

The method matters less than the routine: record every payment, check the rent roll monthly, and reconcile with your bank.

General information, not legal, tax or financial advice. Landlord-tenant law varies by state and city; check your local rules or ask a local attorney.

Frequently asked questions

What is the best way to track rent payments?

Keep a ledger per tenant that records each charge and each payment with a running balance, and check it against your bank deposits every month. A monthly rent roll then shows at a glance who has paid, who paid part, and who owes.

Do I have to give tenants a rent receipt?

It depends on your state. New York, for example, requires a written receipt when rent is paid in cash or by anything other than the tenant's personal check. Even where it isn't required, a receipt for every cash payment protects both sides.

How should I record a partial rent payment?

Record the payment for the amount actually received on the date received, and let the tenant's balance show what is still owed. Whether accepting a partial payment affects your rights in an eviction varies by state, so check local rules before accepting one from a tenant you are already in dispute with.

Keep reading

• Rent ledger template: what to include and how to keep it
• Late rent fees: how to calculate them, state limits, and how to track them
• How to track rental income and expenses in a spreadsheet