A rent ledger is the running account of one tenancy: what was charged, what was paid, and what is outstanding at any date. Most templates lay it out as one row per month, which works until something happens twice in a month, and then it stops working exactly when you need it. This page is about a template built on one row per event instead.
One row per event, not one per month
A charge is an event. A payment is an event. A credit, a late fee, a deposit applied at the end are all events. Give each its own dated row with an amount and a running balance and the ledger can represent anything that actually happens, including two payments in one month and a payment that covers two. A month-shaped grid cannot, and the workaround is always a note in a margin nobody reads later.
The running balance is the point
Without it a ledger is a list of transactions and the reader has to add them up, which means two readers get two answers. With it, any row answers the question what was owed on that date, which is the question every arrears conversation and every estoppel request is really asking. Compute it in the sheet rather than typing it, so it cannot be edited into disagreement with the rows above.
Partial payments need an application rule
Decide once whether a payment clears the oldest balance first or the current charge first, write the rule into the lease, and apply it the same way in every ledger. The rule matters less than the consistency: any defensible order is fine, and switching between them per tenancy is what makes a ledger unusable as evidence. The ledger should show what each payment was applied to, not just that it arrived.
What a template cannot do
Remember. A template is a shape; the moment you have several tenancies the real question is where the ledgers live, whether they agree with the receipts you issued, and who can produce one on request. That is the line between the free worksheet here and the record the paid product keeps, and it is worth being clear about which problem you currently have.
Questions people ask about rent ledger template
Should the deposit appear in the rent ledger?
As a separate line or a separate ledger, not mixed into the rent balance. Deposit money is held rather than earned, and mixing it makes both figures wrong.
What date should a payment carry?
The date it was received, with the period it applies to in its own column. Those are different facts and a ledger that conflates them cannot explain a late payment.
How long should ledgers be kept?
At least as long as your tax records for the property, and in practice for as long as a dispute could arise from the tenancy. Keeping them costs nothing.