Executor Accounting Template: Track Every Dollar In and Out of the Estate

What an Executor Accounting Is

An executor accounting is a formal financial report you file with the probate court before the estate can be closed. It shows every dollar that came into the estate, every dollar that went out, and the resulting balance available for distribution to beneficiaries. Most courts require one. Even in states that allow informal closing (where all beneficiaries sign a waiver), having a complete accounting protects you from claims that you mismanaged funds.

The court reviews this document to confirm that you administered the estate properly: debts were paid in the correct priority order, administrative expenses were reasonable, your executor compensation fell within statutory limits, and the remaining assets match what you're proposing to distribute.

The Core Structure

Every executor accounting follows the same basic formula:

Assets on hand at date of death. This is your starting inventory — every asset the estate held, valued as of the date of death. Bank account balances, investment account values, real estate appraisals, vehicle valuations, personal property. This number is your baseline.

Plus: income received during administration. Interest earned on estate accounts, dividends paid on stocks, rental income from estate property, tax refunds, insurance proceeds paid to the estate (not to named beneficiaries), final paychecks, and any asset sale proceeds above the date-of-death value.

Minus: expenses paid during administration. This breaks into subcategories:

• Administrative expenses — court filing fees, attorney fees, accounting fees, bond premiums, appraisal costs, property maintenance and insurance during administration
• Executor compensation — your fee, calculated under your state's law or the will; the formula and timing vary by jurisdiction
• Creditor payments — every debt paid, listed individually with the creditor name, amount, date, and priority class
• Tax payments — federal and state income tax (the deceased's final return plus any estate fiduciary returns), estate or inheritance taxes
• Property expenses — mortgage payments, property taxes, utilities, repairs, and insurance on real property held during administration

Equals: balance available for distribution. The net amount after all income and expenses. This is what gets divided among beneficiaries according to the will or intestacy law.

Tracking Income and Expenses in Practice

The accounting you file with the court is a summary. Behind that summary sits detailed transaction records — bank statements, receipts, invoices, cancelled checks, wire confirmations — that document every line item. You need both: the summary for the court and the backup for anyone who challenges your numbers.

Set up a simple spreadsheet with these columns:

• Date — when the transaction occurred
• Description — what it was ("Paid Commonwealth Edison final bill," "Received Fidelity 401(k) distribution")
• Category — administrative, creditor payment, tax, property expense, income, distribution
• Amount in — money received by the estate
• Amount out — money paid by the estate
• Running balance — the estate's current cash position
• Receipt/reference — where the backup document is filed (binder tab, scan folder)

Update this spreadsheet every time money moves. Reconstructing six months of transactions from bank statements at the end of administration is miserable work and invites errors that create court problems.

The Creditor Payment Section

Courts pay close attention to the creditor payment portion of your accounting because this is where executor liability hides. The court wants to see that you:

1. Identified all known creditors through your notification process
2. Published any notice required by your state's process, gave direct notice where required, and tracked the applicable claims deadline
3. Paid creditors in the correct priority order per your state's statute
4. Handled any late-filed claims under your state's rules; do not assume a claim is barred solely because a date has passed
5. Documented the basis and written terms for any negotiated settlement

Each creditor payment should list: the creditor name, the original claim amount, the settlement amount (if different), the priority class, and the date paid. If you negotiated a reduction — settling a $12,000 credit card balance for $7,200, for example — note the settlement terms and file the written agreement in your executor binder.

Common Mistakes That Trigger Court Scrutiny

Commingling funds. Never mix estate money with your personal accounts. Open a dedicated estate bank account the day you receive letters testamentary. Every estate transaction goes through that account. Commingling is grounds for removal and surcharge.

Missing receipts. A court-appointed auditor can disallow any expense you can't document. That $200 in gas driving to the deceased's house to meet the appraiser? Without a mileage log or gas receipt, the court may deduct it from your compensation.

Paying yourself first. Follow your state's rules for the timing and approval of executor compensation; some states require court approval before you take any fee. Taking compensation ahead of creditor claims without legal authority can breach your fiduciary duty.

Rounding or estimating. Courts want exact numbers pulled from actual records. "Approximately $4,000 in utility payments" won't fly. List each payment individually with the exact amount and date.

The Debt Settlement & Creditor Notification Toolkit includes a debt tracking spreadsheet and priority-of-claims worksheet that feed directly into your final accounting — every creditor payment organized by priority class, with settlement documentation, so the court section writes itself.