Accountio / Templates / Estate administration / Assets and liabilities schedule

Estate assets and liabilities spreadsheet for executors

List everything the person who died owned and owed, see which IHT400 schedule each asset goes on, and track letters, replies and money collected until the estate is gathered in. This estate assets and liabilities spreadsheet is one Excel workbook for estates in England and Wales, with an inheritance tax estimate and the payment and IHT400 dates.

UK practices
$19
In the pack
Estate administration pack
Files
5, Word and Excel
Buy the pack · $19
Global library · 110 packs

Get this pack and 109 more for $99

Estate administration · this packAML complianceCharity accountsMTD for Income TaxP11D and payrollingUK SRS readinessReference lettersCarbon reduction planCIS+ 101 more

What the spreadsheet looks like

Assets and liabilities schedule template
What the spreadsheet coversSheet or column in the spreadsheet
Every asset, one row each
✓
Assets: Type, Institution or description, Reference or account numberRoom for 100 assets, valued at the date of death
Assets owned alone or jointly
✓
Owned, Deceased's share, Value of deceased's shareEnter the full value and the share, and the deceased's share is worked out
The IHT400 schedule for each asset
✓
IHT400 scheduleFilled in from the asset type, such as IHT405 for a house or IHT406 for a bank account. Joint assets always show IHT404
Values still to be confirmed
✓
Value, Confirmed, Still estimatedMark each value estimated or confirmed and see how much of the estate is still an estimate
Letters to banks and providers
✓
Letter sent, Reply receivedFlags any letter with no reply after four weeks so you know who to chase
Money coming in
✓
Amount collected, Date collected, Collected so farWhat each asset paid out and when, with a running total
Debts and the funeral
✓
Liabilities: Creditor, Amount owed at death, Date paid, Still unpaidRoom for 50 debts, from the mortgage and credit cards to tax owed and care home fees
The inheritance tax estimate
✓
Summary: Nil rate band available to the estate, Residence nil rate band available, Estimated inheritance tax at 40%Net estate less spouse and charity gifts, with transferred bands and the taper above £2 million
The two dates that matter
✓
Pay inheritance tax by, IHT400 due byWorked out from the date of death
Input errors flagged
✓
CheckFor example a joint asset with no share entered, a reply dated before the letter, or a missing value

When executors need it

Before an executor can pay inheritance tax, send the IHT400 or apply for probate, they need a full list of what the estate holds and owes at the date of death. Inheritance tax is due by the end of the sixth month after the death, so someone who died in January has until 31 July. Where tax is owed, the IHT400 goes to HMRC within one year. Use the spreadsheet when:

  • You act for the executors of an estate and need one list of every asset and debt
  • You are writing to banks, pension providers and share registrars and need to track who has replied
  • You have to fill in the IHT400 and want each asset sorted by schedule
  • The executors want an early idea of the inheritance tax bill and the payment date
  • Money is coming in from several places and you need to match it to the estate accounts

How to use the estate assets and liabilities spreadsheet

  1. Delete the examples. Rows marked [Example] on the Assets and Liabilities sheets show how it works. Clear them before you enter the real estate.
  2. List the assets. One row per asset. Pick the type, say whether it was owned alone or jointly, and enter the value at the date of death. For a joint asset, enter the full value and the deceased's share.
  3. Record the letters. Enter the date you wrote and the date the reply came back, then mark the value estimated or confirmed. When money arrives, enter the amount and the date.
  4. List the debts. One row per debt, including the funeral. Enter the date paid when each one is settled.
  5. Fill in the Summary. Enter the date of death, gifts in the seven years before death, what passes to a spouse, civil partner or charity, any transferred bands and the home details. The Check cell shows OK when the inputs make sense.

Questions

What values go in an estate assets and liabilities spreadsheet?

The value of each asset and debt at the date of death, not what it later sells for. The spreadsheet keeps the value at death and the amount collected in separate columns, so a house valued at £300,000 that sells for more still shows its value at death.

Which IHT400 schedule do joint assets go on?

Jointly owned assets go on schedule IHT404, whatever kind of asset they are. The spreadsheet shows IHT404 for any row marked Joint and the usual schedule for everything else.

How does the spreadsheet estimate inheritance tax?

It takes the net estate, removes what passes to a spouse, civil partner or charity, and deducts the £325,000 nil rate band less gifts in the last seven years. If the home goes to children or grandchildren it adds the residence nil rate band of up to £175,000, cut by £1 for every £2 the estate is over £2 million. Tax is 40% of what is left.

Can a late spouse's unused nil rate band be added?

Yes. Enter the unused share of a late spouse's or civil partner's nil rate band and residence nil rate band as a percentage, and the spreadsheet adds it to the estate's own bands.

What does the inheritance tax estimate leave out?

The 36% rate for estates that leave 10% or more to charity, business and agricultural relief, gifts with reservation, trusts and taper relief on gifts. Unused pension funds come into the estate for deaths from 6 April 2027 and are also left out. Use the IHT400 for the final figure.

When is inheritance tax due?

By the end of the sixth month after the death. The Summary sheet works out that date and the IHT400 deadline, one year after the death, from the date you enter.

Also in the estate administration pack

See the whole pack →

Who it's for

Accountancy practices that act for executors, and executors handling an estate in England and Wales.

Last checked

Checked against HMRC's inheritance tax thresholds, its IHT400 schedules and GOV.UK guidance on the residence nil rate band and paying inheritance tax in November 2026.