A rent ledger is a running record of every rent payment for one unit
It lists each payment by date, how much was due, how much arrived, and the balance left over. One ledger per unit, or per lease, kept continuously from move-in to move-out. That is the whole idea. Everything else is formatting.
Landlords reach for one at three moments: a tenant disputes whether they paid, a lender or buyer asks for proof of income, or a court wants a payment history. In all three, memory and a folder of e-transfer screenshots lose. A dated ledger wins.
What belongs in a rent ledger
Six columns cover almost every situation:
| Column | What goes in it |
|---|---|
| Date due | The date rent was owed under the lease |
| Amount due | Contract rent for that period |
| Date paid | When the money actually arrived |
| Amount paid | What actually arrived |
| Method | E-transfer, cheque, cash, direct deposit |
| Balance | Running total still owed |
Add a notes column for anything unusual: a partial payment, a late fee, an agreed deferral. Those notes are what make the ledger persuasive later, because they show the record was kept as events happened rather than reconstructed afterwards.
Rent ledger vs rent roll
They get confused constantly. A rent ledger is deep and narrow: one unit, every payment, over time. A rent roll is wide and shallow: every unit you own, as of one date, showing current rent and occupancy.
You use a ledger to settle a dispute about one tenant. You use a rent roll to show a lender the whole portfolio at a glance. If it is the portfolio view you need, the free rent roll template totals occupancy and rent across every unit.
Why the spreadsheet version breaks
A spreadsheet works until it doesn't. The common failures are boring and predictable: the file lives on one laptop, tabs multiply per year, a formula gets overwritten, and nobody can say which version is current. Worse, the ledger sits apart from the lease and the receipts that prove each line, so assembling evidence means opening four places at once.
The fix is not a better spreadsheet. It is keeping the payment record attached to the unit, the lease and the documents it refers to.
Keeping one without a spreadsheet
UnitDocs stores payments against the unit they belong to, so the ledger builds itself as you record transactions. The lease, the receipts and the tenancy timeline sit on the same unit, which means a payment history and its supporting documents are one click apart rather than one archaeology project apart.
If you want the ledger itself right now, the free rent ledger template fills one in and works out the running balance, or prints blank so you can do it by hand. For proof of a single payment, the free rent receipt generator produces a PDF receipt without an account.
How long to keep it
Keep a ledger for as long as you might need to defend the tenancy, which in practice means the length of the tenancy plus your local limitation period for civil claims, and longer if the numbers feed a tax return. Rules vary by province and state, so check your own jurisdiction rather than trusting a number from a blog. The safe default most landlords land on is seven years, matching common tax record-keeping guidance.