A rental ledger template is a shape plus four decisions, and the decisions are what determine whether it still makes sense in three years. Most templates make them implicitly and badly. This page is the four, made explicitly, for a landlord setting one up for the first time or replacing one that has stopped working.
Decision one: what a row is
An event, not a month. A charge is a row, a payment is a row, a credit is a row, a late fee is a row. Month-shaped ledgers work until two things happen in one month and then the workaround is a comment nobody reads. Event rows represent anything that can actually occur, including the awkward cases that are exactly the ones later disputed.
Decision two: the balance is computed, not typed
Each row carries the running balance after it, calculated from the rows above rather than entered. Typed balances drift from their own arithmetic and the drift is invisible. Computed, the ledger cannot contradict itself, and any single row answers the question of what was owed on that date, which is the question that matters.
Decision three: the application rule, written down
When a payment does not match a charge, what does it clear first. Oldest balance or current charge; either is defensible and consistency is what matters. Write the rule into the lease so the tenant knows it too, and apply it in every ledger. A ledger where the rule changed mid-tenancy cannot be used as evidence of anything.
Decision four: where it lives and who can read it
With the tenancy, alongside the receipts it should agree with, in a place a second person could find. A ledger on one laptop is a single point of failure, and the failure tends to coincide with the moment it is needed. The paid product keeps this as the record rather than as a file, which is the only one of these four decisions a template cannot make for you.
Questions people ask about rental ledger template
Should one ledger cover several units for the same tenant?
No. One tenancy, one ledger, with any transfer between them stated explicitly on both. A blended ledger has a balance nobody can explain.
Do I need separate columns for rent and other charges?
A description column is enough, provided every row has one. What matters is that a reader can see what each charge was for.
How do I start a ledger mid-tenancy?
With an opening balance row, dated, saying what it represents and how it was arrived at. An unexplained opening balance is the flaw that undermines everything after it.