Rental property maintenance log template
One row per repair: when it was reported, what was done, what you paid and when it was closed. Choose an Excel-format spreadsheet with instructions and examples, or a printable log with its own field guide.
This template provides general information and does not provide legal advice. For advice about your circumstances, speak to a solicitor or another qualified legal adviser with experience in housing law.
- No email needed
- Excel-format spreadsheet
- Prints on A4
- Written by
- The Stega team
- Content reviewed
- 26 Oct 2026
- Reading time
- 4 minutes
Free to use and adapt. Check formulas and formatting if you open it in another spreadsheet app. Version 2, 26 Oct 2026.
What a filled-in log looks like
Three rows from the example tab. All details are invented.| Ref | Property | Reported | What was reported | Status | Elapsed days | Amount paid | Closed |
|---|---|---|---|---|---|---|---|
| R-1042 | Flat 2 | 2 Nov 2026 | Kitchen tap dripping, 2 photos | Closed | 6 | £85.00 | 8 Nov 2026 |
| R-1043 | Flat 2 | 9 Nov 2026 | Extractor fan not working | Visit booked | 3 | – | – |
| R-1044 | Orchard House | 10 Nov 2026 | Back gate latch broken | Reported | 2 | – | – |
For these examples, we count elapsed days up to 12 Nov 2026. In the spreadsheet, open repairs are counted up to today's date. The day reported is day 0. The day count and colours help you spot older records. They do not assess urgency, safety or legal deadlines.
How to use it
- 01Start a row the day you hear about it. Give it the next reference number and write what your tenant told you.
- 02Update the status and last update date when something changes. Keep earlier dated updates and supporting records separately, linked by the repair reference.
- 03Ask whether the problem has been resolved. Record the tenant's response and any follow-up. When you mark it closed, add the date, amount paid and invoice reference. Elapsed days stops counting.
What each spreadsheet column is for
| Column | What to write |
|---|---|
| Ref | A reference you give the repair, such as R-1042 |
| Property | A short name you will recognise. Even a property reference may identify a person |
| Reported | The date your tenant told you |
| What was reported | A short description and a reference to any photos or supporting notes |
| Category | Pick one from the list |
| Status | Reported, Visit booked, Work in progress, Waiting for parts or Closed |
| Planned visit | The date a tradesperson is booked to visit |
| Last update | The date of the latest update. Keep earlier dated notes separately, linked by the repair reference |
| Tradesperson or company | Who is booked to visit or carried out the work |
| Amount paid (£) | What you paid. Keep payment dates and any outstanding balance separately |
| Invoice ref | Their invoice or receipt number |
| Closed | The date you marked the repair closed after recording the outcome |
| Closure notes | What was done, the tenant's response and any follow-up needed |
| Elapsed days | Calculated from Reported to Closed, or to today. The day reported is day 0. This is not a safety assessment or legal deadline |
This log helps you organise repair information. Keeping it does not, by itself, show that a repair is safe or that your legal duties have been met. Get appropriate emergency help first and record what happened when it is safe to do so.
Not sure what to write down at each step? Read managing a tenant repair, from first report to completion.