Estate Planning Asset Inventory & Probate Tracker Spreadsheet

Here is an uncomfortable truth that most people avoid: if you were incapacitated tomorrow or died next month, could your spouse, partner, children, or executor find every account you own, access every policy, locate every document, and understand your financial picture well enough to manage it? For most people, the honest answer is no — and that gap between what they have and what their family can find is where estate planning failures happen.

Estate planning is not just about having a will or a trust (though those matter). It is about having a comprehensive, accessible inventory of everything you own, everything you owe, every policy in force, every account with a beneficiary designation, and the location of every critical document. Without this inventory, even the best will is incomplete — because the executor cannot distribute assets they cannot find.

This spreadsheet is not an estate plan. It is the organisational foundation that makes an estate plan work. It catalogues every asset, liability, insurance policy, and account in one document, tracks beneficiary designations (which override wills in most cases), and provides a document locator so your executor or family knows exactly where to find everything.

Disclaimer: This tool is an organisational aid for informational and educational purposes only. It does not constitute legal, financial, or tax advice. Estate planning laws vary by state and by individual circumstance. This spreadsheet does not replace a will, trust, or professional estate plan. Consult a qualified estate planning attorney for guidance specific to your situation. SpreadsheetTemplates.info is not responsible for decisions made based on the information provided.

Why This Inventory Matters#

The Beneficiary Designation Problem#

Most people do not realise that beneficiary designations on retirement accounts, life insurance policies, and payable-on-death (POD) bank accounts override their will. If your will says “everything to my spouse” but your 401(k) still names an ex-spouse as beneficiary (a disturbingly common oversight), the 401(k) goes to the ex-spouse — regardless of what the will says.

The asset inventory tracks every beneficiary designation in one place, making it easy to review them together and ensure they align with your wishes. A single mismatch can undo years of estate planning.

The “Where Is Everything?” Problem#

In the weeks following a death, a grieving family must simultaneously manage emotional loss and a complex financial puzzle. They need to find bank accounts, contact insurance companies, locate the will, identify the mortgage lender, access digital accounts, and determine whether there are assets they do not know about. Without an inventory, this process takes months and frequently results in unclaimed assets — the National Association of Unclaimed Property Administrators reports that states hold over $80 billion in unclaimed property, much of it from estates where heirs did not know the accounts existed.

The Probate Efficiency Problem#

Probate — the legal process of settling an estate — moves faster when the executor can present a complete asset inventory to the court. Incomplete inventories trigger delays, additional hearings, and legal fees. A thorough inventory completed during your lifetime can save your estate thousands in probate costs and months of delay.

Common Estate Planning Oversights This Inventory Prevents#

Outdated beneficiary designations. Life changes — marriage, divorce, births, deaths — should trigger beneficiary reviews. Yet most people set beneficiaries when they open an account and never update them. The inventory’s beneficiary tracking section makes these designations visible in aggregate, so mismatches become obvious.

Forgotten accounts. The average adult has 5–7 financial accounts, but many have more: old 401(k)s from previous employers, savings accounts at banks they no longer use, small investment accounts opened years ago, and life insurance policies purchased by parents or grandparents. Each forgotten account is a potential unclaimed asset. The inventory process forces you to find and document every account.

Missing document access. A will locked in a safe deposit box that only the deceased could access is useless in the immediate aftermath of a death. Powers of attorney that cannot be located when incapacity strikes fail to serve their purpose. The document locator section of the inventory ensures that critical documents are both located and accessible to the right people.

Digital estate gaps. Cryptocurrency without recorded seed phrases is permanently lost. Valuable digital assets (websites, domain names, intellectual property) without documented access credentials may be irrecoverable. Online accounts with valuable content, subscriptions, or recurring charges need to be either transferred or closed. Digital estate planning is a growing area where traditional estate plans — even well-drafted ones — frequently fall short.

The Letter of Instruction#

In addition to the asset inventory, many estate planners recommend a Letter of Instruction — an informal document (not legally binding) that guides your executor through the practical steps of settling your affairs. Unlike a will, which directs asset distribution, a letter of instruction covers the practical logistics: who to notify (employer, Social Security, credit card companies, subscription services), funeral and burial preferences, location of the asset inventory and other documents, names and contact information for your attorney, accountant, financial advisor, and insurance agent, and any personal messages or explanations you want to convey. The asset inventory is the data; the letter of instruction is the roadmap for using it. Together, they transform estate settlement from a months-long detective exercise into a structured, manageable process.

What the Spreadsheet Tracks#

The inventory is organised into eight sections, each capturing a different category of assets, liabilities, or critical information.

Section 1: Bank and Cash Accounts#

For each account: institution name, account type (checking, savings, CD, money market), account number (last four digits for security — full numbers stored separately in a secure location), approximate balance, named beneficiaries (POD designations), joint account holders, and online access information (stored securely).

Section 2: Investment Accounts#

For each brokerage, mutual fund, or other investment account: institution name, account type (individual, joint, custodial), account number, approximate value, named beneficiaries (TOD — transfer on death — designations), and the financial advisor’s contact information if applicable.

Section 3: Retirement Accounts#

For each retirement account: institution and plan name, account type (401(k), 403(b), traditional IRA, Roth IRA, SEP IRA, pension, deferred compensation), account number, approximate value, primary and contingent beneficiary designations, and employer contact information for workplace plans. This section is critical — retirement accounts are often the largest non-real-estate assets and the most likely to have outdated beneficiary designations.

Section 4: Real Property#

For each property: address, type (primary residence, rental, vacation, land), estimated market value, mortgage lender and account number, outstanding loan balance, property tax authority and account number, insurance carrier and policy number, and how title is held (sole ownership, joint tenants, tenants in common, community property, trust). The titling detail matters enormously for probate: jointly held property with right of survivorship passes automatically to the surviving owner without probate. Property held in a trust avoids probate entirely.

Section 5: Insurance Policies#

For each policy: type (life, health, auto, home, umbrella, disability, long-term care), carrier name, policy number, coverage amount or benefit, premium amount and frequency, named beneficiaries, and agent contact information. Life insurance is particularly important — it provides immediate liquidity for the estate and surviving family, but only if the policy can be located and a claim filed. For comparing life insurance coverage, see our life insurance comparison spreadsheet.

Section 6: Debts and Liabilities#

For each debt: creditor name, account type (mortgage, auto loan, student loan, credit card, personal loan, business loan), outstanding balance, monthly payment, interest rate, and whether there is a co-signer or guarantor. Debts do not disappear at death — they become obligations of the estate. Executors need a complete picture to manage creditor claims and determine whether the estate is solvent.

Section 7: Personal Property of Value#

Significant items that have financial or sentimental value and need specific disposition: vehicles (make, model, year, VIN, title location), jewellery and art (description, appraised value), collections (description, estimated value), digital assets (cryptocurrency holdings, valuable domain names, revenue-generating websites), business interests (ownership stakes, partnership agreements, operating agreements), and intellectual property (patents, royalties, licensing agreements).

Section 8: Document Locator#

The practical section that executors need most urgently: the physical or digital location of the will, living trust, power of attorney (financial), healthcare power of attorney / healthcare proxy, advance directive / living will, birth certificate, marriage certificate, Social Security cards, passport, vehicle titles, property deeds, tax returns (past three years), and digital account credentials (stored in a password manager — provide access instructions, not individual passwords).

How to Use the Spreadsheet#

Step 1: Complete the inventory section by section. Start with bank accounts and work through each section systematically. Do not try to complete everything in one sitting — spread it across a week. The first pass will be imperfect. That is fine. An 80% complete inventory is infinitely more useful than no inventory at all.

Step 2: Verify every beneficiary designation. Log into each retirement account, life insurance policy, and POD/TOD account. Confirm the named primary and contingent beneficiaries. Update any that are outdated (ex-spouse, deceased relative, missing contingent). This single action prevents more estate planning failures than any other.

Step 3: Store the inventory securely but accessibly. Your executor, spouse, or designated family member must be able to find this document when it is needed. Options include a fireproof home safe (tell someone the combination), a safety deposit box (ensure someone else has access), a secure digital location (encrypted file with shared access or a password manager with emergency access), or a copy with your estate planning attorney.

Step 4: Update annually. Set a calendar reminder for an annual review — ideally timed to coincide with tax preparation, when financial documents are already gathered. Update balances, add new accounts, remove closed accounts, and verify beneficiary designations.

Step 5: Share the existence (not the contents) with your executor. Your executor needs to know this document exists and where to find it. They do not need to see the contents now — they need to be able to locate it when the time comes. A letter of instruction stored with your will that says “My complete asset inventory is located at [location]” is sufficient.

Download: Estate Planning Asset Inventory — Excel (.xlsx) For tracking the ongoing value of your assets in a simpler monthly format, our net worth tracker provides a complementary view.

Frequently Asked Questions#

Is this spreadsheet a substitute for a will?

No. A will is a legal document that directs how assets are distributed. This spreadsheet is an organisational tool that catalogues what those assets are and where they can be found. You need both. The spreadsheet without a will leaves asset distribution to state intestacy laws (which may not reflect your wishes). A will without this spreadsheet leaves your executor searching for assets they may not know about.

How should I handle digital assets and passwords?

Do not store passwords directly in this spreadsheet. Instead, use a password manager (1Password, Bitwarden, LastPass) and include the master password access instructions in the document locator section. Alternatively, provide your executor with sealed instructions for accessing your password manager. Digital assets to inventory include email accounts, social media profiles, cryptocurrency wallets (seed phrases are critical — without them, the funds are permanently inaccessible), cloud storage, and any accounts with financial value.

What is the difference between a beneficiary designation and a will?

Beneficiary designations on financial accounts (retirement accounts, life insurance, POD bank accounts, TOD brokerage accounts) supersede the will. They are direct transfer mechanisms that pass assets to the named beneficiary outside of probate. The will governs assets that do not have beneficiary designations or that are titled in the deceased’s name alone. This is why keeping beneficiary designations current is arguably more important than keeping the will current.

Should I include my business in this inventory?

Yes, if you own a business or have ownership stakes in any business entity. Include the business name, entity type (LLC, S-corp, partnership), your ownership percentage, the location of operating agreements or partnership agreements, co-owner contact information, and any buy-sell agreements that govern what happens to your share upon death or incapacity.

How does the federal estate tax exclusion work in 2026?

The 2026 federal estate tax exclusion is $15,000,000 per individual (increased under the OBBBA from $13,990,000 in 2025). Estates valued below this threshold owe no federal estate tax. For married couples, the effective exclusion is $30,000,000 through portability. However, some states impose their own estate or inheritance taxes with much lower thresholds. The inventory helps you estimate your estate’s total value for planning purposes, but consult an estate planning attorney for tax-specific guidance.

What if I am the executor for someone else’s estate?

This spreadsheet works equally well as a probate tracking tool. When settling an estate, use it to inventory the deceased’s assets, track creditor claims against the estate, and monitor the distribution of assets to beneficiaries. The document locator section is particularly valuable during the initial phase of locating accounts and documents.

How detailed should the personal property section be?

Focus on items with significant financial value (over $1,000) or strong sentimental importance that you want directed to specific recipients. You do not need to inventory every household item. The most commonly disputed estate items are jewellery, art, collections, vehicles, and family heirlooms — these deserve specific documentation and, ideally, explicit instructions about who should receive them.

Can I use this spreadsheet for incapacity planning, not just death?

Absolutely. Incapacity — from illness, injury, or cognitive decline — creates many of the same practical challenges as death. Your agent under a financial power of attorney needs to find and manage your accounts. This inventory provides that roadmap. Ensure your designated agent knows the inventory exists and can access it.