Shop · Family and Care

Inheritance Tax Gift Record: photo 1 of 5 from its Etsy listing
Family and Care

Inheritance Tax Gift Record

Inheritance Tax Gift Record UK, 7 Year Rule Gift Tracker, Gifts From Surplus Income Log, IHT403, Estate Planning Spreadsheet, Excel

£15 Buy on Etsy

Instant download: Etsy takes the payment and sends you the files straight away.

Giving money to your children or grandchildren? Keep the record HMRC will ask your family for.

Log each gift once and this spreadsheet works out which exemption it uses, applies your £3,000 annual exemption (with carry forward) in the right order, starts the 7-year clock, and shows how much of the £325,000 nil-rate band is used. Regular gifts from income get a year-by-year income and spending table, laid out like HMRC form IHT403.

Inheritance Tax Gift Record: photo 2 of 5Inheritance Tax Gift Record: photo 3 of 5Inheritance Tax Gift Record: photo 4 of 5Inheritance Tax Gift Record: photo 5 of 5

What's inside (6 tabs)

  • Start Here: Where things stand, at a glance
  • Gifts: Every gift, its exemption and its 7-year clock
  • Income & Spending: Year by year, like the table on form IHT403
  • Summary: Nil-rate band left and when gifts drop out
  • Guide: The rules in plain English

What it does

  • Every gift with its exemption, worked out for you
  • 7-year clock, taper relief and nil-rate band left
  • Income & spending table for regular gifts from surplus income (IHT403 layout)
  • Useful for executors too: type the date of death to see the position

What you get

  • 1 Excel file (.xlsx): iht_gift_record.xlsx
  • A blank copy (.xlsx): iht_gift_record_blank.xlsx, the same file empty and ready for your own
  • A step-by-step PDF setup guide
  • A Google Sheets link (in a PDF): one click and Google makes you your own copy, no uploading
  • Example data already filled in so you can see how it works. Clear it in seconds

What you need

  • Microsoft Excel 2010 or newer (including Microsoft 365), on Mac or PC
  • OR a free Google account to use it in Google Sheets (the guide shows you how)
  • Best on a computer or tablet. Not made for Apple Numbers

Please note

  • This is a digital download. No physical item will be sent
  • A record-keeping tool, not tax advice
  • Figures are for the 2026/27 tax year. They're in one place in the file, so they're easy to update
  • For your own personal use. Please don't resell or share the file

How it's made

Designed by me, built with the help of AI tools, then checked formula by formula against the official rules.

Inheritance Tax Gift Record £15
Buy on Etsy