Executor Spreadsheet Template: Track Every Asset, Debt, and Deadline

Why a Spreadsheet Beats Loose Notes and Memory

Settling an estate involves tracking dozens of moving pieces simultaneously — bank accounts, insurance policies, creditor claims, tax deadlines, beneficiary distributions, and court filings. Most executors start with a manila folder and a legal pad, then realize within the first month that they're losing track of critical details.

A structured spreadsheet solves this by giving you a single place to record every asset, every debt, every deadline, and every communication. It also helps document your management of the estate and provides the records needed for a formal accounting when state law or a court requires one.

The Five Tabs Every Executor Spreadsheet Needs

Tab 1: Asset Inventory

This is your master list of everything the deceased owned. For each asset, record:

Ownership type matters more than most executors realize. Joint tenancy and POD/TOD accounts pass automatically to the surviving owner or named beneficiary — they don't go through probate and generally aren't part of the executor's distribution responsibilities. Misidentifying these can lead to double-counting assets in the estate inventory.

Tab 2: Debts and Liabilities

Every debt the deceased owed, organized by the payment order set by the applicable state's probate statute. The order is state-specific, so confirm it before paying claims.

Track the creditor name, account number, balance owed, whether the claim was filed during the creditor notice period, whether you've accepted or rejected the claim, and the date paid. This tab is essential for the final accounting: you need to show the court that every dollar paid out of the estate went to a legitimate, properly filed claim.

Tab 3: Deadlines and Filings

The calendar is an executor's enemy. Miss the creditor notice period and you may be personally liable for debts you didn't advertise. Miss a tax deadline and the estate eats penalties and interest.

Key deadlines to track:

• Will filing deadline — for example, a California custodian must deliver the will within 30 days after learning of the death; Illinois requires immediate delivery
• Creditor notice period — typically 3 to 6 months after the notice is published
• Final individual tax return (Form 1040) — for a calendar-year taxpayer, due by the usual filing deadline for the year of death (generally April 15 of the following year)
• Estate income tax return (Form 1041) — due on the 15th day of the fourth month after the estate's tax year ends
• Estate tax return (Form 706) — due 9 months after death when a return is required; the basic exclusion amount is $15 million for 2026
• State-specific deadlines — inheritance tax filings, property tax reassessments, vehicle title transfers

Tab 4: Beneficiary Distributions

Once all debts, taxes, and administrative expenses are paid, you distribute the remaining assets according to the will. This tab tracks what each beneficiary is entitled to receive, what they've actually received, the date of distribution, and their signed receipt or release.

Never distribute assets before all creditor claims are resolved and taxes are filed. If you distribute early and the estate can't cover a later-filed valid claim, you become personally liable for the shortfall.

Tab 5: Communication Log

Every phone call, email, and letter related to the estate goes here. Date, who you spoke with, what was discussed, what was agreed to, and any follow-up needed. This documents your communications if a beneficiary later questions the administration and helps you track any reporting deadlines imposed by state law or a court order.

Setting Up the Spreadsheet

You can build this in Google Sheets, Excel, or any spreadsheet tool. The structure matters more than the platform. A few practical tips:

• Color-code by status. Green for completed items, yellow for in-progress, red for overdue or blocked.
• Add conditional formatting on deadline columns. Highlight anything due within 14 days in yellow and anything overdue in red.
• Lock formulas and headers. If you're sharing the spreadsheet with a co-executor or attorney, protect the structural elements so they don't accidentally break the layout.
• Back up weekly. Estate administration can span 6 to 18 months. A corrupted file with no backup is a disaster.

From Spreadsheet to Formal Accounting

When a formal accounting is required to close the estate, your spreadsheet can provide its raw data. It typically summarizes what came into the estate (assets at date of death plus income earned during administration), what went out (debts, taxes, administrative expenses, distributions), and what's left. Your five tabs map directly to these categories.

Some attorneys prepare the formal accounting from your spreadsheet; others use specialized software. Either way, the executor who shows up with organized records pays significantly less in legal fees than the one who hands over a shoebox of receipts.

If you want a pre-built version with all five tabs formatted and ready to use, the Family Estate Meeting toolkit includes a printable estate tracker alongside the meeting agenda and communication scripts that help you coordinate with family members throughout the process.