IHT Planning Excel 2026-27
Inheritance Tax Planning Spreadsheet (2026/27 edition)
A linked Excel template that does the adding up for you. List what you own, record your gifts and answer a few simple questions, and the spreadsheet builds a rough, step-by-step inheritance tax estimate. You can update it whenever your figures change.
What’s inside (8 linked sheets):
- Allowances: the nil-rate band, the residence nil-rate band, the taper threshold, rates and exemptions for 2026/27, with sources. You can edit them, including any allowance transferred from a late husband, wife or civil partner.
- Estate inventory: 60 lines with categories and your share of jointly owned assets. Totals feed the estimate automatically.
- Gifts log: 100 lines. For each gift it works out the tax year, the date seven years on, whether the gift is still within seven years, and the tax rate after taper.
- Annual exemption tracker: from 2019/20 to 2034/35, so you can record past years as well as future ones, with the carry-forward worked out for you.
- Surplus income record: income, spending and regular gifts year by year.
- Step-by-step estimate: includes the residence nil-rate band taper and the 36% charity rate.
- Documents checklist: where your will, LPAs and other papers are kept.
Good to know:
- Excel file (.xlsx). It also opens in Google Sheets, Apple Numbers and LibreOffice.
- No macros, add-ins or links to other files or websites.
- You type only in the yellow cells; everything else is calculated.
- It’s designed to sit alongside our Inheritance Tax Planning Workbook. You can buy both together in the bundle and save £4.98.
Important: this spreadsheet is for education only and is not financial, tax or legal advice. It helps you organise your own information. It gives a rough estimate based on the figures you enter, and it leaves out some reliefs and rules that may apply to you. Please check any information you rely on, and consider speaking to a regulated financial adviser or a solicitor before making decisions. Fahy Life is a trading name of Dominic Fahy and is not authorised or regulated by the Financial Conduct Authority. Purchases are covered by our terms of sale at fahylife.co.uk/terms-of-sale/.