A rental ledger is the account of a single tenancy over its whole life. It exists so that three specific questions can be answered without argument, on demand, by somebody who was not necessarily there. This page is about those three questions, and about the discipline that keeps a ledger able to answer them, written for the landlord or manager who keeps it.
What was owed on a given date
Not what is owed now: what was owed then. Arrears conversations, deposit deductions and any formal process all turn on the position at a particular date, and a ledger that can only show the current balance forces a reconstruction every time. A dated running balance answers it by reading one row, which is why the running balance is not an optional column.
What a payment was applied to
When a tenant pays an odd amount, the ledger has to say which charge it cleared. Two payments and three charges is enough to create a genuine disagreement between two honest people, and the only defence is that the application was recorded at the time under a rule both sides agreed. Record it as it happens; reconstructing it afterwards looks exactly like deciding it afterwards.
Whether the tenancy was paid on time
Not just whether it is square now. A landlord giving a reference, a lender pricing a building and a manager deciding whether to renew all want the pattern rather than the balance. A ledger that records the date each payment arrived alongside the period it covered produces that pattern for free; one that records only amounts cannot produce it at all.
Who asks to see one
The tenant, at the end of a tenancy and usually about the deposit. A buyer or lender, through an estoppel or a rent roll. Your own accountant, at the year end. And occasionally a court. All four are better served by a ledger produced from the record than by a spreadsheet assembled for the occasion, because the assembled version invites the question of what was left out.
Questions people ask about rental ledger
Is a rental ledger the same as a rent roll?
No. A ledger is one tenancy over time; a rent roll is every unit at a point in time. They should agree, and they only reliably do when both are produced from the same record.
Should a tenant be able to see their ledger?
There is rarely a reason not to, and a tenant who can see it raises questions earlier and smaller. Some states require one on request at the end of a tenancy.
What about charges other than rent?
Put them on the ledger with their own description: parking, pet rent, a rebilled utility, a repair the lease makes the tenant's. Keeping them off the ledger makes the balance unexplainable.