UK Rent a Room Scheme Calculator 2026/27

Why this one

The Rent a Room allowance is £7,500 a year, and it is a genuine choice rather than an automatic relief. Below the threshold you usually take the allowance and declare nothing. Above it you can take the allowance and pay tax on the excess, or ignore the scheme and deduct expenses instead. This workbook works out both and shows you which leaves you better off.

What you get

• One Excel workbook (.xlsx) with 12 tabs: Start Here, Dashboard, Settings, Income, Expenses, Mileage, Home Working, Quarterly Summary, Which Method, 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 Rent a Room allowance of £7,500, halving to £3,750 where the income is shared
• Both methods worked out side by side: the allowance, or deducting your share of real costs
• A clear statement of when there is nothing to declare at all
• The rule that a loss cannot be created under the Rent a Room scheme
• Personal allowance of £12,570, with the taper above £100,000
• Income tax for England, Wales and Northern Ireland, and all six Scottish bands
• A note on what the scheme does not cover: a whole flat, a self-contained annexe, or a property you have moved out of

Questions