Everything here is free. Making it takes time and money. Everything here is free.

Buy us a coffee

Rental property · RP-06

Rent Payment Ledger

A free printable rent ledger — rent due, rent received, the date it actually arrived and the running balance owing, for one tenancy.

First page of the Rent Payment Ledger — Settle an arrears question with a document rather than a memory, and hand an accountant something that already adds up.
Download Free · no sign-up

One page. Choose your paper size — both versions are laid out identically, so neither one gets shrunk to fit.

Print it and write on it

Fill it in type and save

The fillable versions have real form fields — open them in any PDF reader, type into them and save. Printing help.

What this sheet is for

Settle an arrears question with a document rather than a memory, and hand an accountant something that already adds up.

Who it is for

Landlords with one property or twenty, letting agents, and anyone renting a room out who wants the money side written down.

How to use it

  1. One sheet per tenancy. Fill the header in once.
  2. Record the date the money actually arrived, not the date it was due — the gap between the two is the part worth seeing.
  3. Keep the running balance going down the page. A positive balance is arrears.
  4. Note the payment reference; it is what identifies a payment months later.
  5. Carry the closing balance onto the next sheet when this one fills.

What is on the sheet

One page, top to bottom:

Printed under the title: Every rent payment for one tenancy on one page — what was due, what arrived, when, and what is outstanding.

One tenancy per sheet. One tenancy per sheet. Record the date the money actually arrived, not the date it was due — the gap between the two is the useful part — and carry the running balance down the page. A record sheet, not a legal document: what a tenancy requires depends on where the property is.

Write-on lines: Property · Tenant · Tenancy from · Rent due · Rent due on (day of month) · Paid by · Year · Sheet

Table, 12 rows: Period covered · Due date · Amount due · Date received · Amount received · Method · Reference · Balance owing · Notes

Write-on lines: Balance carried forward · Checked on · Checked by

Questions

Is this a legal document?

No, and it is not legal advice. It is a record sheet. What a tenancy legally requires — notice periods, how a deposit must be held, which certificates must be in place and how long records must be kept — depends entirely on where the property is, and it changes. Nothing of that kind is printed here. Establish what applies to you locally and keep this alongside it.

What if the rent changes mid-tenancy?

Write the new amount in the Amount due column from the period it applies to and carry on. The ledger records what happened rather than assuming the rent is fixed.

Related sheets

Rental Property Inspection Record

Record a property visit properly, with space for photograph references and both signatures, so the visit is evidenced.

RP-02 2 pages

Rent Receipt Book

Give a tenant paying in cash the proof they have no other way of holding, and keep a matching record yourself.

RP-07 1 page

Also in the resources library

The same subject, with a version you can fill in on screen.

Rent Payment Ledger

A dated line for every rent due and every payment made.

RL-62 Log PDF Excel Online

Everything here is free

Every sheet, binder, game and puzzle on Upkeep Papers is free to download, with no email and no account. Making them is not free: each one takes days of research, design and checking, and the site costs money to run. If something here saved you time, you can buy us a coffee. It is entirely optional: nothing is locked, and nothing changes if you don’t.

Buy us a coffee

Opens PayPal in a new tab. Any amount, and nothing changes if you would rather not.