Estate Administration Spreadsheet: What to Track and How to Organize It

Executors should keep records of every dollar that flows through an estate. Courts may require a detailed accounting, and the IRS requires records for tax filings. If you're managing this with sticky notes and a shoebox, you're setting yourself up for trouble.

What Your Spreadsheet Needs to Track

Asset inventory. Every asset the decedent owned at death, with date-of-death fair market values. This includes bank accounts, investment accounts, real property, vehicles, life insurance policies, retirement accounts, and personal property of significant value. Note which assets pass through probate and which transfer directly to beneficiaries (POD accounts, joint tenancy, trust assets).

Debts and liabilities. All known debts: mortgage balances, credit cards, medical bills, personal loans, and tax obligations. Track the creditor name, amount claimed, date received, and whether the claim was accepted, rejected, or paid. Debts must be paid in statutory priority order before any distributions.

Estate income. Interest, dividends, rental income, and any other income generated by estate assets after the date of death. This feeds directly into Form 1041 preparation.

Expenses paid. Every expense paid from the estate account: funeral costs, attorney fees, accountant fees, property maintenance, insurance premiums, court filing fees, and your own executor commission if you take one. Keep corresponding receipts filed by date.

Distributions. What went to which beneficiary, when, and the legal basis (will provision, intestacy statute, court order). This is the section beneficiaries and courts scrutinize most closely.

Organizing by Phase

Structure your tracking by the phase of administration, not just by category:

• Immediate (first 30 days): death certificates ordered, property secured, insurance notified, probate petition filed
• Qualification (months 1-3): Letters issued, EIN obtained, estate account opened, creditor notices published, inventory filed by the court's deadline
• Administration (months 3-12): claims reviewed, taxes filed, property sold or transferred
• Closing (months 12-18): final distributions, final tax returns, court accounting, discharge order

This timeline structure makes it easy to see what's been done and what's still pending — critical when you're reviewing your own progress at 11 p.m. and can't remember whether you filed the creditor notice.

The Executor Binder

A physical or digital binder supplements the spreadsheet with source documents: copies of the will, Letters Testamentary, death certificates, insurance policies, property deeds, tax returns, bank statements, and all correspondence. Organize by category with a clear index.

The binder is what you hand to your attorney when they need a document, what you present to the court for your final accounting, and what protects you if a beneficiary challenges your administration.

Common Mistakes

Failing to record small cash transactions. Missing the date-of-death valuation for stepped-up basis calculations. Not tracking the statutory creditor claim window. Confusing estate income (post-death) with the decedent's final income (pre-death) for tax purposes.

For executors managing an estate from another state, the Long-Distance Estate Settlement toolkit includes a pre-built fiduciary expense log and asset inventory template designed to keep remote administration organized and audit-ready.

The Payoff

Good records take 15 minutes a week to maintain. Bad records can take months to reconstruct when the court or a beneficiary demands an accounting. Start the spreadsheet the day you become executor, update it with every transaction, and you'll have the documentation to close the estate cleanly.