Tenant Ledger Template for 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.
The columns you need
- Date
- Description (June rent, late fee, utilities, payment)
- Charge (amounts the tenant owes)
- Payment (amounts received)
- Balance (previous balance + charge − payment)
Example (fictional)
| Date | Description | Charge | Payment | Balance |
|---|---|---|---|---|
| 2026-05-01 | May rent | 1,200.00 | 1,200.00 | |
| 2026-05-03 | Payment, transfer | 1,200.00 | 0.00 | |
| 2026-06-01 | June rent | 1,200.00 | 1,200.00 | |
| 2026-06-03 | Payment, transfer (partial) | 600.00 | 600.00 | |
| 2026-06-10 | Late fee (your own rule) | 30.00 | 630.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
- Mixing charges and payments in one column. Keep them apart so the balance is easy to check.
- Overwriting old lines. When something is wrong, add a correcting line or mark the old one void, so history stays readable.
- Forgetting partial payments. Record the amount actually received, not the amount you expected.
- Mixing currencies. Keep a separate ledger for each currency.
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 RentLedger
RentLedger 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.
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