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.
£14.99
Buy nowSecure checkout and instant download via Payhip. Prices include any VAT due.
- 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 bundleSecure checkout and instant download via Payhip. Prices include any VAT due.
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.
Who it's for
- Anyone who would rather keep their figures in a spreadsheet than on paper
- People making regular or larger gifts who want to keep track of the 7-year rule
- Adult children helping parents get organised, and executors
Want to start with the basics? Try our free inheritance tax estimator and our complimentary inheritance tax guide.
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.