Landlord Tax Spreadsheet UK 2025/26 – Rental Income Self Assessment, Section 24 Mortgage Interest Credit

Get your property income ready for the 31 January 2027 Self Assessment deadline. For UK landlords with 1 to 5 properties: log rent and costs through the year and the workbook lays out your figures for the UK property pages (SA105) and estimates your tax bill — including the 20% mortgage interest credit (Section 24).

WHAT'S INSIDE

• Properties — up to 5, with annual mortgage interest and profit per property
• Rent log — 500 rows: date, property, tenant, period, amount
• Expenses log — 500 rows with categories matching the SA105 boxes, plus allowable % for mixed costs
• Mortgage interest handled correctly — not deducted, but given as a 20% tax credit
• Summary — figures for the UK property pages plus an estimated bill, taking your salary/pension into account
• 'Do I need to tell HMRC?' checker
• Rates tab — 2025/26 rates & allowances (England, Wales & NI), editable
• Key dates with tick boxes

FORMAT

Instant download (.xlsx). Works in Excel, Google Sheets and Apple Numbers.

PLEASE NOTE

An organiser and estimator, not tax advice; it doesn't file your return. Doesn't cover capital gains, furnished holiday lets or company-owned property. Scottish income tax bands differ. Not affiliated with HMRC.

Instant digital download: by buying you agree to immediate supply and lose the 14-day cancellation right for digital content. SoleTraderSheetsUK is a trading name of EXTRACT API LTD (company number 17469044), registered office 66 Paul Street, London EC2A 4NA.