UK Landlord Portfolio Spreadsheet 2026/27

Why this one

A portfolio is taxed as one property business, not as several — profits and losses across your properties are pooled before tax, and that catches people out. This workbook records income and costs per property so you can see which ones actually earn, then pools them the way HMRC does for the tax figure.

What you get

• One Excel workbook (.xlsx) with 11 tabs: Start Here, Dashboard, Settings, Income, Expenses, Mileage, Home Working, Quarterly Summary, Tax Estimate, Rates 2026-27, Lists
• A quick start guide (PDF) with instructions for Excel and for Google Sheets
• Income and expense categories written for letting, matching the HMRC property pages
• A dashboard showing profit, tax to set aside and where the money went
• A sourced rates tab listing every figure with the GOV.UK page it came from

Built for the 2026/27 UK tax year

Every figure is for the 2026/27 tax year and sits on its own tab with the GOV.UK page it came from.

• The mortgage interest tax reducer at 20%, calculated as the lowest of three figures the way HMRC does it, rising to 22% from April 2027
• Rental profit correctly carrying no Class 2 or Class 4 National Insurance, because property income is not trading income
• A warning that claiming the £1,000 property allowance cancels the interest relief entirely
• Personal allowance of £12,570, with the taper above £100,000
• Income tax for England, Wales and Northern Ireland, and all six Scottish bands
• Expense categories matching the boxes on the HMRC property pages
• Making Tax Digital quarter dates, with the threshold measured on gross rent rather than profit

Need more than one? This is also in the UK Landlord Complete Tax Bundle 2026/27 (£34.99) — the same files at a lower price than buying them one by one.

Questions