Rent Ledger Template

A rent ledger template is a running record of every rent payment for one unit: what was due, what was paid, how, and the balance left. The ready-to-use version is right below, six columns you can copy into a spreadsheet today. Landlords keep one for two reasons: it backs up the numbers you file at tax time, and it settles a who-paid-what disagreement before it turns into a dispute.

The rent ledger template: six columns and a filled-in example

A working rent ledger needs six columns: date, rent period, amount due, amount paid, method, and running balance. Here’s what that looks like filled in for one unit over two months, including a partial payment and a late fee:

Each column earns its place:

• Date is when the payment actually arrived, not when it was due.
• Rent period is which month’s rent the payment covers, so a partial payment doesn’t get mistaken for the wrong month later.
• Amount due is what the lease requires for that period.
• Amount paid is what actually showed up, which may be less.
• Method is how it arrived (ACH, check, cash, online portal), so you can reconcile against bank deposits.
• Running balance is what the resident still owes after that entry. It should read $0.00 when a unit is current.

Above the payment rows, add a short header block: resident name, unit or property address, lease start and end dates, and the monthly rent amount. That way the ledger identifies itself even printed on its own page. An optional Notes column, off to the side, is useful for a one-line reminder (“payment plan agreed, see email 8/4”) without cluttering the numbers.

Why landlords keep a rent ledger: it is your backup at tax time and in a dispute

Two things make a rent ledger worth the five minutes it takes to update: it backs up what you report at tax time, and it settles disputes with a resident before they escalate.

At tax time, you’re expected to keep records that support the rental income and expenses you report. The IRS’s general rule gives it three years from when you file to question those numbers, though records tied to the property itself, like depreciation, need to last as long as you own it (IRS guidance on how long to keep records). A ledger with a date, an amount, and a method for every payment is exactly that kind of record, so you’re not reconstructing a year of activity from bank statements in April. For the fuller picture of what else to track rental income and expenses against, see our breakdown of rental property expenses, and roll those numbers into a profit and loss statement at tax time.

In a dispute, the ledger is your contemporaneous log. If a resident says they paid rent in full on a date when your ledger shows a partial payment and a late fee, you have a dated record made at the time.

Log every payment the day it lands, full or partial

Log every payment the day it lands, full or partial. Waiting a few days to catch up is how a ledger drifts out of sync with what actually happened.

• Record the payment method every time, even when it’s the same resident paying the same way every month. That’s what lets you reconcile the ledger against bank deposits later.
• On a partial payment, note exactly what was paid and carry the remaining balance forward on its own line, rather than a note that says “short this month” with the totals left unchanged.
• Record any late fee on its own line, separate from the rent itself. Charge only what your lease and applicable state law allow. There’s no universal late-fee amount or grace period. Both are set by your lease terms and by the state your property sits in.
• Keep security deposits and other fees off the rent rows entirely. They’re a different kind of money with different rules, and mixing them in makes the ledger harder to read and easier to misstate.

Digital beats paper: a spreadsheet you can sort and back up

A spreadsheet beats a paper ledger for one practical reason: it does the parts of the job you shouldn’t be doing by hand.

Set it up in a spreadsheet and you can sort or filter by resident or by month in seconds, which matters the moment you’re managing more than one unit. (Our breakdown of rental property expenses covers the other costs worth tracking alongside rent.) A single formula keeps the running balance column correct, so you’re not re-adding a column of numbers every time a payment comes in. It also backs itself up automatically if you’re using cloud storage, so a spilled coffee or a dead laptop doesn’t cost you a year of records.

Paper still works if a spreadsheet isn’t your thing, as long as you keep it just as consistently: same six columns, updated the day the payment lands, filed somewhere it won’t get lost.

Where the ledger fits in managing a rental

The rent ledger is one record among several a landlord keeps. Deposits, maintenance requests, and resident communications each deserve their own log, kept alongside it rather than folded into the rent rows.

For the rest of what a well-run rental needs beyond payment tracking, our guide to managing a rental property covers the pieces that work with the ledger: inspections, maintenance records, and resident communication.

The rent-tracking mistakes that cause disputes

The worst mistake is logging from memory or days later, once the details have blurred. Everything else on this list makes that mistake worse.

• Delayed logging. A payment not recorded the day it arrives is a payment you’ll misremember later.
• Mixing deposits into rent rows. A deposit follows different rules than rent, and folding the two together makes the ledger harder to trust.
• Relying on memory or scraps of paper. If it’s not in the ledger, it didn’t happen, as far as a dispute is concerned.
• Skipping partial payments and payment plans. Note what was paid, what’s still owed, and any arrangement you agreed to. Write it down every time.
• Leaving out the payment method. Without it, reconciling the ledger against your bank statement turns into guesswork.

FAQ

What is a rent ledger template?

It’s a running record of every rent payment for one unit: what was due, what was paid, how it was paid, and the balance left afterward. The six-column version above is ready to copy into a spreadsheet.

What should a rent ledger include?

At minimum: the resident’s name, the unit or address, the lease term and monthly rent, and a payment log with date, rent period, amount due, amount paid, method, and running balance. A Notes column for one-line context is useful but optional.

Is a digital rent ledger better than paper?

For most landlords, yes. A spreadsheet sorts and filters instantly, keeps the running balance correct with a formula, and backs itself up. Paper works if you keep it just as consistently: same columns, updated the same day.

Can a rent ledger template be customized?

Yes. Add columns for a specific lease term, a payment plan, or a second fee type if your properties need it. The six columns above are the starting point, and most landlords add at least one more.

How do I track late payments in a rent ledger?

Give the late fee its own line, separate from the rent payment itself, and update the running balance to reflect both the unpaid rent and the fee. Charge only what your lease and state law allow. There’s no standard grace period or fee amount that applies everywhere.

Should I share the rent ledger with residents?

Sharing a periodic statement, monthly or at lease renewal, heads off disputes before they start. A resident who can see their own payment history is less likely to argue with it later.

How do I use a rent ledger for multiple properties?

Keep a separate ledger, or a separate tab in the same spreadsheet, for each unit. Tracking several units in one continuous log is where balances start getting attributed to the wrong resident.

Where can I find a free rent ledger template?

The structure above is free: six columns, a filled example, and the header fields to add above it. Copy it into a spreadsheet and start logging the next payment that comes in.

This article is general information, not tax advice. Rules change, and every situation is different. For guidance on your specific recordkeeping and reporting obligations, talk to a licensed tax professional.