The Executor Accounting Spreadsheet, Replaced by a Ledger

Most executors start with a spreadsheet: one tab for money in, one for money out, a running total at the bottom. It works — until the totals stop matching, or you realize the fee was charged on a base including shipping and tax, and everything reconciling is on you. An estate ledger is a spreadsheet that knows what the numbers mean.

What breaks in the spreadsheet approach

• Four kinds of money get mixed in one column. Estate receipts ("money in") are not the same as beneficiary distributions, and an expense you paid personally is neither — until the Ledger separates receipts, disbursements, distributions, and executor reimbursable expenses automatically.
• Income and principal get merged. Courts and trusts usually want them separate: interest and rent are income; the house itself is principal. In the Ledger every movement carries its account.
• Totals go stale. A spreadsheet total is right only at the moment you last checked it. The Ledger recalculates every running balance on every entry.
• Descriptions decay. "Check 1042" means nothing in month nine. The Ledger nudges toward court-standard descriptions — it flags vague ones like "check" or "misc".

What the Ledger does that no spreadsheet does

It separates the four movement kinds, splits principal from income, tracks executor out-of-pocket as a reimbursable claim, and — at the end — assembles the whole thing into a charge-and-discharge statement with a balance check. The same records drive the inventory, the ledger, and the final account. You never retype anything.

When a spreadsheet is still fine

If the estate is simple — one bank account, no house, no sales — a sheet may honestly be enough. The Ledger earns its keep once there is real property, receipts you must support, distributions to multiple heirs, or any sale where proceeds minus date-of-death value needs to flow into the final account by itself.

Estate Ledger is an educational organizing tool — not legal advice. Court filing formats vary; confirm your court's requirements. Content checked 2026-10-17.