How to Keep a Rent Ledger for a Small Rental (Free Method + Template)
If you own one to ten rental units and manage them yourself, a rent ledger is the single most useful record you can keep. It answers three questions in seconds: who paid, who still owes, and how much rent came in this year.
What a rent ledger is
A rent ledger is a dated list of every amount a tenant owes or pays: rent, late fees, other charges, credits and deposits. One row per transaction, kept per unit, so you can show a tenant (or a court, or your tax preparer) a clear history.
The columns you need
- Date received
- Unit
- Type (rent, late fee, pet fee, other income, deposit received, deposit refunded)
- Amount
- Payment method (bank transfer, check number, cash, app)
- Month the payment covers
- Notes (partial payment, paid late, etc.)
Step by step
- List each unit once with its tenant, monthly rent, due day and lease dates.
- Every time money arrives, add one row the same day. Don't batch it monthly; that's where mistakes creep in.
- Keep security deposits on their own row type. A deposit is generally held for the tenant, not income, until it is applied or kept under your lease and local law.
- At month end, compare expected rent to collected rent for each unit (a "rent roll"; see rent roll template).
- Give cash payers a written receipt, and keep a copy.
Common mistakes
- Mixing personal and rental money in one account, which makes the ledger hard to reconcile.
- Recording deposits as rent.
- Not noting what period a payment covers, which causes disputes when payments are late or partial.
- Charging late fees your lease (or local law) doesn't allow.
Giving tenants a receipt for each payment? See what to put on a rent receipt.
Not legal or tax advice. Landlord-tenant rules (notice periods, deposit limits and deadlines, late-fee caps, screening rules) vary by state and city and change over time. Check your state and local law or ask a qualified attorney or tax professional.