Spreadsheet · 2026/27 edition

Inheritance Tax Planning Spreadsheet

A linked spreadsheet template that does the adding up for you. List what you own, record your gifts and answer a few questions, and it builds a rough, step-by-step inheritance tax estimate you can update whenever your figures change. It's designed to sit alongside our Inheritance Tax Planning Workbook, and to make any conversation with a solicitor or adviser quicker and more useful.

Educational only, not financial advice. This is here to help you understand the topic and inspire your own thinking. It isn't a personal recommendation or a suggestion to take any particular action. Everyone's situation is different, so speak to a regulated financial adviser before making decisions.
The Inheritance Tax Planning Spreadsheet showing a step-by-step estimate with example figures

£14.99

Buy now
  • Excel file (.xlsx), 8 linked sheets
  • Also opens in Google Sheets, Apple Numbers and LibreOffice
  • Allowances for the 2026/27 tax year, with sources
  • Annual exemption tracker from 2019/20

Like to print it out too? Get the spreadsheet and the 20-page Inheritance Tax Planning Workbook together for £24.99, saving £4.98.

Buy the bundle

What's inside

  • Allowances: the nil-rate band, residence nil-rate band, taper threshold, rates and exemptions for 2026/27, with sources. You can update them if the rules change, and add any allowance transferred from a late husband, wife or civil partner
  • Estate inventory: 60 lines with a category for each, your share of jointly owned assets, and totals that feed the estimate automatically
  • Gifts log: 100 lines. For each gift it works out the tax year, the date seven years on, whether it's 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. It pulls in your gifts and works out what's carried forward
  • Surplus income record: income, spending and regular gifts year by year, with a check that gifts stay within your surplus
  • Step-by-step estimate: net estate, exemptions, the nil-rate band after gifts, the residence nil-rate band with taper, and the 36% charity rate
  • Documents checklist: where your will, LPAs, nominations and other papers are kept

A look inside

Example figures shown.

Sample sheet: the estate inventory, with categories, ownership and a summary by category Sample sheet: the gifts log, with exemptions, 7-year dates and status Sample sheet: the annual exemption tracker from 2019/20, with amounts carried forward

Who it's for

Taking advice is particularly important if you own business or farm assets, have property abroad, have set up or benefit from a trust, have a blended family or are in a second marriage, live abroad or are not long-term UK resident, have an estate that may exceed £2 million, or are planning large gifts. The estimate leaves out reliefs and rules that may apply to you, so it can help you prepare for that conversation but isn't a substitute for it.

Want to start with the basics? Try our free inheritance tax estimator and our complimentary inheritance tax guide.

Common questions

About the spreadsheet

Is this financial or legal advice?

No. The spreadsheet helps you organise your own information and gives a rough estimate based on the figures you enter. It doesn't recommend any course of action or take your circumstances into account. For advice, please speak to a regulated financial adviser or a solicitor.

What software do I need?

It's an Excel file (.xlsx). It's built for Microsoft Excel and also opens in Google Sheets, Apple Numbers and LibreOffice, although drop-down lists and formatting can look slightly different outside Excel.

Is the file safe to open?

The spreadsheet contains no macros, add-ins or links to other files or websites, and we check it with up-to-date security software before it goes on sale. Only download it from the link in your order email or Payhip receipt, and keep your security software up to date as you would for any download. If it ever asks you to enable macros, close it and email us.

How accurate is the estimate?

It follows the main rules using the figures you enter, but it leaves out business and agricultural relief, trusts, gifts with reservation of benefit, quick succession relief, overseas assets and some detailed rules. Treat it as a starting point for a conversation with a professional.

What happens when the rules change?

The allowances are on one sheet with their sources and the date they were checked, and you can update them yourself. Rules can change, often at a Budget, so please check the latest position before relying on a figure.

How do I receive it?

After payment you can download the file straight away, and you'll also receive a download link by email.

Can I get a refund?

Because it's a digital download, you'll be asked at checkout to agree that your 14-day right to cancel ends once the download starts. If the file is faulty or not as described, you have rights under the Consumer Rights Act 2015. See our terms of sale.

General information, not advice.

Ready to talk to a regulated adviser?

Find a regulated adviser