Already bought?All tools

Property & letting · Excel · 5 tabs

Rent and repairs ledger

Log rent as it arrives and repairs as they're reported. Arrears add up per property and the year summary is ready for your tax return.

£12once · download straight away
Works in Excel or Google SheetsNo subscription
Close-up of the Rent ledger tab, from the free example file for the Rent and repairs ledger
DuePaidArrearsStatus
1 Aug£500.00£495.00Part paid
1 Sep£1,490.00£0.00Paid late
20 Sep £1,250.00Not paid

Example data. The free example file shows the full layout.

Inside the free example file

Rendered from the example file in Excel, at the size it opens on screen. The rows are sample data, and the file is marked as an example.

Rent ledger, from the free example file for the Rent and repairs ledger
Rent ledger
Repairs log, from the free example file for the Rent and repairs ledger
Repairs log
Year summary, from the free example file for the Rent and repairs ledger
Year summary

Download the free example file

What it does

Log rent as it arrives and repairs as they're reported. Arrears add up per property and the year summary is ready for your tax return.

Best for: Self-managing landlords who want proof of every payment and repair.

What’s included

Excel · 5 tabs

  • Rent ledger with arrears per property and late-payment flags
  • Repairs log that counts days to fix
  • Contractor list and a tax-year summary per property

How it works

  1. Add a row for each rent due date.
  2. Fill in the date and amount when money arrives.
  3. Log repairs when they're reported; add the fixed date later.
  4. Check the year summary before your tax return.

What it doesn’t do

Doesn't connect to your bank. You type or paste in each payment.

Packs help you organise and prepare. They are not legal or tax advice and can’t guarantee you meet every rule.

Price and delivery

£12once
  • Download links straight after payment, by Stripe
  • Links work 3 times within 14 days; the file is stamped with your email and order number
  • Lost the links? Ask for them again

Also in these bundles

  • Landlord complete · 4 packs for £29 (£45 separately)Buy £29
  • Everything · 8 packs for £39 (£78 separately)Buy £39

Questions

Can I see it before I buy?

Yes. Download the free example file: it shows the layout with sample data, as a locked preview. The paid file is yours to fill in.

What do I get, and how?

The file downloads straight away after payment. Your links work 3 times within 14 days, and the file is stamped with your email and order number. Lost the links? Ask for them again.

Does it work in Google Sheets?

Yes. Every pack works in Excel or Google Sheets, and the Word files open in Word or Google Docs. There are no macros.

Is it a subscription?

No. One payment, and the file is yours to keep using.

Can I get a refund?

As these are digital files, change-of-mind refunds are not available once they are issued, so please look at the free example first. If a file is faulty or not as described, your legal rights are not affected. Refund terms.

More in Property & letting

All property tools
Flat 2, Elm Road01 Tenancy and tenants02 Deposit03 Safety certificates04 EPC and energy06 Rent07 Costs and receipts

Paperwork organiser

One folder system for every property, a checklist of the 21 documents you should hold, and a rule for naming files.

£12 once · Zip
PropertyNext dueStatus
Flat 2, Elm Rd10 Dec 2026Due soon
14 Mill Lane30 Mar 2027OK
7 Park View20 Sep 2026Overdue

Property compliance tracker

Every certificate and deadline in one spreadsheet. Next due dates work themselves out and turn amber, then red.

£12 once · Excel
1. Pet request: agree
Dear [Tenant name], thank you for your request of [date] to keep a cat at the property. I'm happy to agree…

Landlord letters pack

Ready-to-edit letters for the moments landlords most often get wrong: pet requests, rent increases and the information sheet.

£9 once · Word