← All prebuilt solutions
Tax & Company

Lifetime Gifts Tracker

Record every gift, use every exemption – and know where you stand on the 7-year clock

£20

Secure checkout. Your download link is sent as soon as payment clears.

Lifetime Gifts Tracker

Overview

Gifts you make in your lifetime can reduce inheritance tax – but only if they are exempt, or you survive them by 7 years. When you die, your executors must list every gift from the last 7 years (and gifts into trust from the last 14) and prove any exemption claimed. Most families find this very hard years later. This workbook keeps the record as you go: it applies each exemption automatically, tracks each gift's 7-year clock, shows the tax that would be due if death happened on a date you choose, and lists the evidence your executors will need.

Price
£20
Who it’s for
Tax & Company
Works with
Microsoft Excel for Windows and Mac
Buy now

See how it works

A walk through the main sheets

The sheets you will use most, in the order you will use them – shown with the sample data every workbook comes with.

Step 1

Gift Register

Every gift and how it is treated – exemptions, clocks, lifetime tax and tax on death. What you do: enter the yellow columns, one row per gift.

Gift Register
Income & Expenditure

Step 2

Income & Expenditure

Surplus income by tax year to support regular gifts. What you do: enter income, tax and normal spending.

Step 3

Evidence Checklist

The paperwork each gift needs, and whether you have it. What you do: mark Yes / No.

Evidence Checklist
Annual Exemptions

Step 4

Annual Exemptions

The £3,000 exemption for every tax year – used, carried forward and lost. What you do: nothing – it is automatic.

Who it is for

Made for people like you

  • Example – text
  • Parents and grandparents helping family – A clear record of what you've given, what's exempt and what is still on the clock.
  • People making regular gifts from income – An income and spending schedule that evidences the 'normal expenditure out of income' exemption year by year.
  • Anyone who has given to a trust – Lifetime tax estimates, the 14-year shadow and its effect on later gifts.
  • Executors and advisers – A ready-made schedule of gifts with dates, values, exemptions and evidence status.
  • WATCH OUT – This is a record-keeping and estimating tool, not advice. Gifts can have capital gains tax consequences, gifts where you keep a benefit don't work, and trusts have their own rules. Inheritance tax and estate planning are complex – take professional advice before making significant gifts.

Quick start

Up and running in minutes

  1. Example – text
  1. Settings – Enter the donor's name and date of birth, the date of death you want to test, any nil-rate band transferred from a late spouse, the annual exemption brought forward into your first year, and the first tax year to show.
  2. Income & Expenditure – If you make regular gifts from income, fill in your income, tax and normal spending for each tax year.
  3. Gift Register – Add every gift: date, recipient, relationship, description, asset, value and gift category.
  4. Evidence Checklist – Mark Yes against each piece of paperwork you have filed. Grey cells aren't needed for that gift.
  5. Dashboard – See the totals, gifts still on the clock, the next to drop off, and the tax if death occurred on your chosen date.
  6. Death Scenario – See how the tax on gifts falls year by year, and the 7-year timeline against the nil-rate band.

Key features

  • A register for up to 300 gifts: date, recipient, value and type – each one automatically treated as exempt, a PET or a gift into trust (CLT).
  • Applies the exemptions for you: £3,000 annual exemption by tax year with one year's carry forward, £250 small gifts, wedding gifts (£5,000 / £2,500 / £1,000), spouse, charity, and regular gifts out of surplus income backed by an income and spending schedule.
  • A 7-year clock and drop-off date for every gift, taper relief, the 14-year shadow for trusts, and the tax if death occurred on any date you choose – year by year.
  • A rolling 7-year timeline against the nil-rate band, an evidence checklist for every gift and a one-page dashboard.

What’s included

  • Dashboard – Totals, clocks, next drop-offs and charts
  • Settings – Donor, assumed death date, late spouse band
  • Gift Register – Every gift and its treatment
  • Income & Expenditure – Evidence for regular gifts from income
  • Evidence Checklist – Paperwork for each gift
  • Annual Exemptions – £3,000 a year, used and carried forward
  • Death Scenario – Tax on gifts by date of death and the timeline
  • Scenario Workings – Behind-the-scenes workings
  • Tax Rates – Bands, rates and exemptions
  • Guide – How to use this workbook

How buying works

Your file is only released once payment has cleared.

1

Click Buy now

You are taken to our secure checkout.

2

Pay securely

Checkout takes a minute and you get a receipt by email.

3

Download your file

Your download link arrives as soon as payment clears.

Explore the range

Need it tailored to your business?

We can adapt any prebuilt solution or build something bespoke, with a lifetime bug-free guarantee.

Part of AML Finance Group

Need an accountant too?

Our sister firm, AML Accountancy Solutions, is an award-winning accountancy practice helping businesses and individuals across the UK with their accounts, tax, bookkeeping and payroll.

Visit AML Accountancy Solutions