Printable Rent Ledger (Free PDF): 12-Month Payment Tracker

Every landlord has an answer to “where do you write the rent down?” Phone notes, the back pages of a planner, or just memory. The problem: scattered records aren’t records. If you can’t answer “did March get paid?” with a document, you don’t have a system. So start with the simplest one that works: a one-page printable rent ledger.

📄 Download the rent ledger (PDF, free). No sign-up, no email; click and print.

What’s on the page

One A4 page covers one unit for one year:

• Header fields: property/unit, tenant, monthly rent, lease start, so the page identifies itself at a glance.
• 12-month table: due date, amount, date paid, payment method, a “paid” checkbox, and a notes column for every month.
• Notes section: three lines for deposit, inventory, and contact details.

If you own several units, print one page per unit; the first rule of managing multiple rentals is keeping records separated by property.

How to use it: three habits

1. Fill in all due dates up front. January through December, straight from the lease, so the ledger doubles as a calendar.
2. Tick on payment day, not later. “I’ll write it down tonight” is how records die; the moment the transfer lands, write date + method and tick the box.
3. Treat the notes column as negotiation memory. Partial payment, late payment, a repair offset: one sentence is enough, and at year-end those sentences are gold.
4. Write the transfer reference. This is the only thing that makes the record provable. “Paid” is your assertion; a bank reference is the bank’s record, and it comes from a third party.

Tell your tenant what to put in the payment reference. Agreeing the wording up front removes all the matching work later. One line does it: “Please write: Flat 4, October rent.” With three flats, three transfers from three tenants look identical on a month-end statement. Without a reference you infer which is which from the amounts, and if two amounts match you can’t.

The same rule matters more with cash: there is no bank record at all, so yours is the only one. Pair every cash payment with either a receipt or a message the tenant has confirmed.

What to write when payment is short or late

The ledger’s real test is the month the money doesn’t arrive in full. There are three cases and they’re written differently:

Short payment. Don’t tick the box. Put the amount received in the amount column. The shortfall and its reason go in the notes: “£300 received, £150 short; says the boiler repair will be offset.” Ticking the box instead makes you read that month as “fine” three months later.

Late payment. The due date and the payment date are already two separate columns; fill in both. At year-end, the gap between those two columns shows the tenant’s actual payment behaviour: “usually pays, but always ten days late” is something you want in hand at renewal.

Offsets. If you’re deducting a cost the tenant covered, write the document number in that month’s notes: “invoice 4417, £150, kitchen tap.” Offsets are the most disputed item at year-end. One line of note ends that argument before it starts.

Which of these conversations belongs in writing is covered in landlord–tenant written communication.

If you’re a letting agent: same sheet, two sets of books

For an agent this page doesn’t do the same job, because the money you’re tracking isn’t yours. A landlord looks at one question: has the rent arrived? An agent looks at two: has it been collected, and has it been passed on? In a portfolio of 30–40 units, the first week of the month is almost entirely those two questions.

Three changes are enough in practice:

• Group the sheets by owner, not by unit. Keep one owner’s flats together; payouts happen per owner, not per flat.
• Add three columns: collection date · payout date · commission. The middle one doesn’t exist on a landlord’s ledger at all, and it’s what an agent gets asked about most.
• Flag the month a tenancy changed. That month carries both a partial collection and vacant days; a year later it’s the answer to “why did this unit bring in less.”

The record-keeping need is the same as a landlord’s: rent day, tenant, lease end and costs, per unit. The difference is the unit count; and the more units, the shorter paper’s useful life.

There’s also one record an agent needs that a landlord never does: the terms agreed with each owner. Commission rate, payout day, which costs come off whose side: written once per owner, so it isn’t renegotiated monthly. Undocumented, it gets renegotiated monthly, and that becomes the biggest time sink of the month as the portfolio grows.

What the ledger gives you at year-end

Record-keeping pays out in December. A completed ledger answers four questions without argument:

1. What did this unit actually bring in? The total of the amount column: the money that actually arrived, not the twelve months you expected. The gap is usually a surprise.
2. How many days late, in total? The sum of the gaps between the due and payment columns. That number is the most concrete thing you can bring to a renewal conversation. “You always pay late” is an impression; “74 days late across the year” is data.
3. Which months closed short? The unticked boxes. Without a ledger, February’s shortfall is entirely forgotten by August.
4. Where does the deposit stand? The line in the notes block. It’s the first thing asked at move-out; what can be deducted is covered in what can be deducted from a deposit.

If you’re handing it to an accountant, a copy of the ledger isn’t enough on its own: put the year’s bank statement next to it. The ledger is your record, the statement is a third party’s; side by side, any discrepancy surfaces in December rather than in April.

And print next year’s ledger in December, not January. A ledger printed in January always has its first month filled in retrospectively, and a retrospective row is limited to what you happen to remember. Managing the increase window is in the 5-step renewal plan.

Paper, spreadsheet, or app?

The honest answer: each has its place.

• Paper (this ledger): perfect for one or two units; it lives on the fridge and everyone sees it. Its weakness: it doesn’t remind you, and it doesn’t add anything up.
• Spreadsheet: when you want totals and late-payment flags, move up to the rent tracker Excel template. Excel has limits of its own; I covered them in a separate post.
• App: if you want rent day remembered for you and lease renewals flagged weeks ahead, that’s exactly what RentMind does: rent, tenants, leases and expenses on one screen, with staged reminders. First 2 properties free. Beyond about four units paper stops coping on its own, because the question changes from “has this flat paid?” to “which flats haven’t paid this month?”. And you can’t answer that without laying the sheets side by side.

The order doesn’t matter; keeping records does. Start on paper, move up as the portfolio grows.

There’s a printable for the lease side too: the lease agreement checklist.

Frequently Asked Questions

Can I start the ledger mid-year? Yes. Back-fill past months from bank statements and receipts, then track normally. An incomplete history beats no history.

How should I record cash payments? Date + amount + “cash” in the method column, ideally with a simple signed receipt. That column exists precisely so year-end doesn’t turn into an argument about which payment arrived how.

Should the tenant get a copy too? Good practice: yes. When both sides see the same ledger, most “I paid it / it never arrived” disputes die before they start.

Should I tick the paid box when rent arrives short? No. Put the amount received in the amount column, leave the box empty, and write the shortfall and its reason in the notes. A ticked box makes you read that month as “fine” three months later, and the shortfall disappears permanently.

I’m a letting agent: how should I use this ledger? Group the sheets by owner rather than by unit, and add three columns: collection date, payout date, commission. A landlord looks at “has the rent arrived”; an agent looks at “has it been collected, and has it been passed on”; that middle column doesn’t exist on a landlord’s ledger.

Fuat Çakır — industrial engineer, management consultant and the developer of RentMind. He builds apps under the Sofft umbrella around one idea: never miss a date.