Keeping a Tenant Ledger: What to Record and How to Read It

A tenant ledger is the most boring document in a rental and the most useful one. It is a dated list of every charge and every payment in one tenancy, with a running balance. Kept every month, it settles disputes in minutes, backs up every late fee and every deposit deduction, and tells you which tenants need a conversation before they need a notice.

Ledger or rent roll?

A rent roll is the whole property on one page: each unit, its tenant, its rent and its lease dates, as of a day. A tenant ledger is one tenancy over time. You need both: the rent roll to see the building, the ledger to see the tenant. The totals of every ledger for a month should match the rent roll and the bank statement.

What to record

Five columns do the job:

• Date: the day a charge was due or a payment arrived.
• Entry: rent and the period it covers, a fee and the lease section behind it, a credit and why, or a payment with its method and reference (check number, transfer confirmation, receipt number).
• Charge: anything the tenant owes.
• Payment: anything the tenant paid or was credited.
• Balance: what is owed after this line.

Record the security deposit too, but on its own line or its own ledger. It belongs to the tenant until move-out, and many states limit how it can be held and used. Counting it as rent is the most common ledger mistake there is.

A worked ledger: three months

A tenant moves in on Monday, October 12, 2026. The rent is $1,500, due on the 1st, with a five-day grace period and a 5% late fee in the lease. The first month is prorated by the actual days: 20 of October’s 31 days, or $1,500 × 20 ÷ 31 = $967.74. The deposit of $1,500 is held on a separate line.

Date	Entry	Charge	Payment	Balance
Oct 12	Rent, Oct 12–31 (20 of 31 days)	$967.74		$967.74
Oct 12	Check 1041		$967.74	$0.00
Nov 1	Rent, November	$1,500.00		$1,500.00
Nov 2	Bank transfer		$1,500.00	$0.00
Dec 1	Rent, December	$1,500.00		$1,500.00
Dec 7	Late fee, 5% (lease § 4)	$75.00		$1,575.00
Dec 10	Money order		$1,500.00	$75.00
Dec 15	Bank transfer		$75.00	$0.00

Two lines deserve a closer look.

December 7. The grace period ran through December 6, so the fee applies from the 7th. The late fee calculator shows the same day count and the same $75, and checks the fee against your state’s cap; the late fee laws by state table lists every cap.

December 10. The $1,500 money order goes to the oldest charge first: December’s rent. That leaves the $75 fee open, and it is paid on the 15th. Applied the other way, the fee would be paid and $75 of rent left unpaid, which in some leases starts a new late fee. Unless your lease or state law sets the order, oldest-first keeps the ledger readable and the fees honest.

The first month’s math comes from the prorated rent calculator, and the receipt for it from the rent receipt, which prints the amount in words and the period covered.

Credits and adjustments

Not every line is rent. Three kinds of adjustment show up in most tenancies, and each goes in the payment column with a note saying why:

• A concession. $100 off the first full month for signing by a set date. Charge the full $1,500 on November 1 and credit $100 on the same day, so the ledger shows the real rent and the discount separately.
• An approved repair the tenant paid for. The tenant replaces a failed smoke alarm with your written OK and sends a receipt for $42. Credit $42 on the day you approve it.
• A correction. A fee charged in error comes off as its own line, dated the day you fix it. Never delete the original: a ledger with gaps in it is worth far less in a dispute than one that shows its own mistakes.

Charges work the same way. A utility bill passed through to the tenant under the lease, or a returned-check fee, is a charge with its source in the note.

How to read a ledger

Look at four things, in this order:

1. The balance today. Zero, owed, or a credit.
2. The pattern of payment dates. A tenant who pays on the 2nd every month is not the same as one who pays on the 9th every month, even if both balances are zero. The second one is paying a late fee every month, or should be.
3. A balance that never returns to zero. $75 carried for three months means a disputed charge nobody has talked about. Talk about it.
4. Returned payments. A check that bounces shows as a reversal: the payment line is cancelled by a new charge for the same amount. Two in a year is worth a change in payment method. The guide to payment reversals and NSF fees covers the fees, and the glossary has NSF and payment reversal.

The ledger at move-out

At the end of a tenancy, the ledger and the deposit meet. The final balance, any damage deductions with their invoices, and the refund all go on one statement, sent by your state’s deadline. California allows 21 days after the tenant leaves, with an itemized statement; the security deposit limits by state table has every state. A clean ledger makes that statement a copy-and-paste job.

For tenants: check your own ledger

Ask your landlord for your ledger once a year, or any time a balance looks wrong. Match it against your bank statement and your receipts. If a payment is missing, send the proof in writing, with the date and the reference. Most errors are a payment posted to the wrong month, and a ledger makes that easy to spot and easy to fix.

Keeping it up takes ten minutes a month

Update the ledger the day money arrives, send a receipt when a tenant pays in cash or by money order, and total every ledger at the end of the month against the bank. Ten minutes a month now saves an afternoon of reconstructing a year from bank statements later, usually on the day you need it most.