RentRoll

Tenant Ledger Template for Landlords

By the RentRoll team · Updated 2026-11-18 · Plain-language guide for small landlords

General information, not legal or tax advice. Rules differ by country, state and city and change over time. Check requirements with a qualified professional.

Short answer. A tenant ledger is a running list of what a tenant was charged and what they paid, with a balance after every line. Charges go up the balance, payments bring it down.

The columns you need

Example (fictional)

DateDescriptionChargePaymentBalance
2026-05-01May rent1,200.001,200.00
2026-05-03Payment, transfer1,200.000.00
2026-06-01June rent1,200.001,200.00
2026-06-03Payment, transfer (partial)600.00600.00
2026-06-10Late fee (your own rule)30.00630.00

Free CSV template

Download tenant-ledger-template.csv. The balance column is left for you to fill by hand or with a simple sum formula in your spreadsheet.

Common mistakes

Several tenants on one lease

Decide in advance whether the ledger is for the lease as a whole or per person. If you split the rent, say so in the description of each line so you can answer “who paid what” later.

Do it in RentRoll

RentRoll builds this ledger for you: each lease has charges generated from its schedule, each payment is matched to them, and the balance updates at once. You can edit or undo any line and restore it from the trash. Several tenants can share a lease for free; Pro adds shares so you can see each person’s part.

Coming soon to Google Play

Quick answers

Do I need a ledger per tenant or per lease?

Per lease is the simplest. If several people share a lease and you split the rent, note who paid on each line.

How long should I keep ledgers?

Record-retention periods differ by country and purpose. Check with your accountant or local rules.

Can I add a late fee line?

Yes, if your lease or local rules allow one. Record it as its own charge with a clear description.

Related guides

More: all guides · features · FAQ · disclaimer