Trust and Trustee Register Template

What a trustee register is

A trustee register template is a single Excel workbook that records who serves each trust and under what authority — trustees and successors, trust protectors and their powers, appointment and removal history, beneficiary interests, and every amendment to the trust. This trust structure spreadsheet template keeps that whole structure in one keyed file.

Most templates you’ll find are accounting ledgers — a household money map — or estate-planning deed and will forms. This is neither. It’s a structuring register: the governance surface of a trust, not the money moving through it.

This is not trust accounting: no principal-and-income ledger, no transactions or balances. It’s not a deed or will drafting form either. It records the structure a trust already has.

What’s inside the Excel workbook

The workbook ships as one Excel file, eight sheets deep. A Start Here tab leads, followed by seven data sheets spanning trusts, trustees, protectors, appointments, beneficiaries, and amendments. No formulas, no sample rows — every dropdown list is pre-built and ready for real data.

Together, those seven sheets hold 96 fields behind 16 dropdown lists. This register opens in Google Sheets as well as Excel. Every dropdown list works the same way there, so a shared workbook stays consistent no matter who opens it.

Here’s what a complete trustee register should track, sheet by sheet:

Trusts and trustee roster

Trusts — 14 fields — holds situs country and subdivision, governing law, and tax status: Grantor, Simple, or Complex. Trust type and category round out the row, alongside trust date and tax ID. A termination date closes the row when a trust winds down.

Trustees — 13 fields — keys to the trust with real roles: Sole, Co-Trustee, Successor, Investment, Distribution, or Administrative Trustee. Successor order and bond detail sit on the same row. Compensation and term dates round out what each trustee’s row records.

These two sheets form the keyed spine the rest of the workbook builds on. Every other sheet in the workbook references a trust or a trustee from here. Get one of those two rows wrong, and every appointment, protector, and beneficiary record keyed to it inherits the mistake.

Protectors, powers, and appointments

Trust Protectors — 22 fields — is the sheet nobody ships free. Each power gets its own field — modify terms, terminate the trust, change situs, remove or appoint trustees, approve fees.

Add or remove beneficiaries, modify interests, veto or direct distributions, and direct or veto investments each get a field too. A protector’s veto power discovered mid-distribution is exactly the gap this sheet closes — it’s on the row before the distribution goes out, not after.

These are record fields, not recommendations. The workbook notes what a protector can do, not what they should do.

Both appointment sheets — Trustee Appointments and Trust Protector Appointments — carry appointment source, term dates, and early-termination date, type, and reason. This doubles as a trust protector register template, keyed to the same roster.

Beneficiaries and amendments

Trust Beneficiaries — 16 fields — holds beneficiary type: Income, Remainder, Contingent, Discretionary, Charitable. Interest percentage, distribution frequency, and vesting date or event sit on the same row, alongside distribution age and withdrawal rights and amount. A spendthrift-protected flag marks the interest as shielded from creditors — miss that flag, and the protection isn’t there when a creditor comes looking.

Trust Amendments — 10 fields — tracks amendment type: Amendment, Restatement, Amendment and Restatement, Decanting, or Nonjudicial Settlement. Approved-by, court-approval-required, order date, and case number round out the row. This doubles as a beneficiary register template, keyed to the same trust.

How to keep the register

A trustee register earns its name by keeping every appointment, power, and interest on its own row. Nothing stays buried in a binder. This section shows how to keep a register of trustees and beneficiaries with this workbook.

To keep a register of trustees and beneficiaries:

1. Add a row per trust on Trusts. Every revocable, irrevocable, or testamentary trust gets its own row with situs, governing law, and tax status.
2. Add a row per trustee, with successor order. Sole, co-, successor, investment, distribution, and administrative trustees each get a row on Trustees, ranked by succession.
3. Log every appointment and removal with its authority. Trustee Appointments and Trust Protector Appointments each carry appointment source, term dates, and removal authority.
4. Record protector powers as they’re granted. Mark each of the 22 power fields on Trust Protectors for the protector who holds it.
5. Record beneficiary interests with vesting and spendthrift detail. Interest percentage, vesting date or event, and the spendthrift-protected flag all live on Trust Beneficiaries.
6. Add a new row for every amendment — never overwrite one. Trust Amendments carries amendment type, approved-by, and court order and case number for the change.

Recording appointments and removals

One row per appointment keeps the history intact. Trustee Appointments and Trust Protector Appointments both carry appointment source and term dates. Neither sheet overwrites a prior appointment when a new one begins.

Removal authority names who can remove a trustee, so a successor trustee stepping in isn’t stuck without record of the predecessor’s removal authority. Early-termination date, type, and reason capture what happened if a term ends early. That’s how to track trustee appointments and removals without losing the prior appointment when a new one starts.

Tracking amendments and court approval

Trust Amendments holds amendment type — Amendment, Restatement, Amendment and Restatement, Decanting, or Nonjudicial Settlement — plus approved-by, court-approval-required, order date, and case number. Court approval required flags the difference — a Nonjudicial Settlement needs no judge, a Modification by Court does, and the flag keeps the two from blurring.

This sheet works as a spreadsheet to track trust amendments and appointments. A row per change, never an overwrite, means a trust’s amendment history survives every restatement.

Built for family offices

Family-office principals and staff, trust counsel, and wealth-structuring advisors running multiple trusts hit the same problem first: a scattered trustee record, one binder per trust. A family trust register template for Excel gives every trust its own row instead of its own binder.

When trust counsel needs a protector’s powers across a dozen trusts, filtering one workbook by trust name replaces opening a dozen separate binders. Nothing about the beneficiary or amendment history changes shape from trust to trust — it’s the same seven sheets, keyed differently each time.

That same portfolio view extends to how family offices manage entities and trusts — the entities a family office tracks alongside every trust it administers.

When a spreadsheet stops working

This register holds raw records only, with no version history. An overwritten removal date erases its own past, and a bond expiration waits for someone to notice it. Nothing on the sheet flags either problem before it becomes one.

There’s no permission model either. Anyone with the file can edit any trust’s protector powers or beneficiary interests. A shared link means a shared risk, for every trust in the file.

From workbook to software

This template’s column headers match Lextree’s import templates, so it loads directly into trust governance software — no re-keying, no remapping. A trust’s full history moves with it, row for row.

That handoff matters most once a portfolio spans a dozen trusts, one overwritten removal date away from a dispute over who had authority. Software keys that portfolio to the entities already tracked elsewhere in Lextree. Every trust and trustee lines up with the legal entities the trust already owns.

Powers and dates that surface

Access control replaces the shared file, so only the right people edit a given trust’s protector powers. Reminders fire on bond expirations and trustee term ends, instead of waiting for a spreadsheet check. A removal that happens today shows up the moment it’s recorded.

A keyed amendment audit trail lines up every restatement, decanting, and court order automatically — not through row discipline alone. Nobody has to remember which row was the latest version.

Frequently asked questions

What is a trustee register template? A trustee register template is a single Excel workbook that records who serves each trust and under what authority — trustees and successors, trust protectors and their powers, appointment and removal history, beneficiary interests, and every amendment to the trust. It functions as a trust structure spreadsheet template for a portfolio of trusts.

What should a trustee register include? A trustee register should include the trusts themselves — type, situs, and tax status — trustees with successor order and bond detail, appointment and removal history, protector powers, beneficiary interests with vesting, and every amendment the trust has undergone. Each of those lives on its own sheet and its own row, so nothing gets buried when the file grows to cover a portfolio of trusts.

Does it track trust protectors and their powers? Yes. Trust Protectors holds 22 fields covering modify-terms, terminate, change-situs, remove/appoint-trustee, fee-approval, beneficiary, distribution, and investment powers, plus a fiduciary flag and compensation.

Can it track trustee appointments and removals? Yes. Trustee Appointments carries appointment source, term end, removal authority, and early-termination date, type, and reason for every trustee on the roster.

Does it record beneficiary interests, vesting, and spendthrift protection? Yes. Trust Beneficiaries carries beneficiary type, interest percentage, distribution frequency, vesting date or event, distribution age, withdrawal rights and amount, and a spendthrift-protected flag.

Does it track trust amendments and court approval? Yes. Trust Amendments carries amendment type — including Decanting and Nonjudicial Settlement — approved by, court-approval-required, order date, and case number.

Is this trust accounting software? No. This tracks trust structure and governance, not trust accounting — there is no principal-and-income ledger, no transactions, and no balances. Accounting stays in your accounting system.

Can I use it to draft a trust deed or will? No. This records a trust structure that already exists — it does not draft deeds, wills, or trust instruments. Drafting stays with your estate-planning attorney.

Is this a UK charity (CIO) trustee register? No. This is a US-style structuring register for a portfolio of private and family trusts — trustees, protectors, beneficiaries, and amendments across as many trusts as a family office administers. A UK Charitable Incorporated Organisation (CIO) trustee register is a different, single-charity statutory document with its own regulator-mandated fields.

Can it manage multiple trusts in one workbook? Yes. Every sheet is keyed to a trust, so one workbook covers a portfolio of many trusts instead of just one.

Does it track bond requirements and term dates? Yes. Trustees carries bond required, bond amount, and bond expiration alongside each trustee’s term start and end dates.

Does the register send reminders or alerts? No. The workbook holds raw dates only, with no built-in alerts. Add your own conditional-formatting rule, or move to software that fires reminders on its own.

Is it free, and does it work in Google Sheets? Yes. Enter your email below and the workbook is sent to your inbox — no credit card, no sales call. It opens in Google Sheets as well as Excel, dropdowns included.

Is there a free family trust register template for Excel? Yes — this one. It’s a free workbook with 8 worksheets and 96 fields, covering trustees, protectors, beneficiaries, and amendments — sent to your email.