COLLECTING RENT
What is a rent ledger, and how do you keep one?
A rent ledger is a running record, for one tenant, of every charge (rent, fees) and every payment, with the balance after each line. It shows at a glance whether a tenant is current and how much they owe — and it's the document you'll need for a dispute, an eviction, a lender, or your taxes.
If you keep only one financial record for a rental, make it this one. A rent ledger answers the question that matters most — is this tenant current? — and proves it if anyone asks.
What it is
A rent ledger is a single running list for one tenant: every charge, every payment, and the balance after each entry. When the balance reads $0 after a payment, the tenant is paid up. When it doesn't, the ledger shows exactly what's owed and since when.
What goes in it
| Date | Description | Charge | Payment | Balance |
|---|---|---|---|---|
| Nov 1 | November rent | $1,450.00 | $1,450.00 | |
| Nov 2 | Payment — bank transfer | $1,450.00 | $0.00 | |
| Dec 1 | December rent | $1,450.00 | $1,450.00 | |
| Dec 6 | Late fee per lease | $75.00 | $1,525.00 | |
| Dec 9 | Payment — check #2231 | $1,525.00 | $0.00 |
The rules that keep it trustworthy:
- Charges on their due date, payments on the day they're received.
- Every charge on its own line — rent, a late fee, a utility bill the lease makes the tenant pay — so the balance always explains itself.
- The security deposit noted separately, never mixed into the rent balance.
- One ledger per tenant. When a tenant moves out, their ledger closes; the next tenant gets a new one.
Ledger vs. receipts vs. rent roll
- A receipt confirms one payment.
- A ledger shows the whole history for one tenant.
- A rent roll is a snapshot of every unit at once — useful once you have several.
Why it matters most when things go wrong
- Late rent or eviction: a court will want to see exactly what was charged and paid, and when.
- Deposit disputes: unpaid charges on the ledger are what you can deduct.
- Lenders and buyers: rental income history, documented.
- Taxes: the year's rent received, in one column.
How to keep one
A spreadsheet works well for one or two tenants. Our free rent ledger template pre-fills a year of rent charges for your tenant with a running-balance formula — download it for Excel or Google Sheets, or print it.
As you add tenants, the ledger is the first thing worth automating: when payments, fees, and receipts record themselves, the ledger stays right without you touching it.
Common questions
What should a rent ledger include?
The date, a description of each charge or payment, the charge amount, the payment amount, and the running balance. Many landlords also note the payment method or check number.
Is a rent ledger the same as a rent roll?
No. A rent ledger is the full payment history for one tenant. A rent roll is a snapshot of all units at once — who lives where, the rent, and the current balance.
Should the security deposit be in the rent ledger?
Record it, but keep it separate from the rent balance. A deposit isn't rent; it belongs to the tenant until you account for it at move-out.
General information, not legal or tax advice. Where we state a law, we link the statute and re-check it on a schedule; your city or county can add rules of its own.