Kentucky Estate Distribution Accounting Worksheet Template for Administrators

If you've been appointed as an estate administrator in Kentucky, you already know the paperwork can feel overwhelming. One of the most important tools you'll use is an estate distribution accounting worksheet template. This document helps you track every dollar that comes into the estate, every expense you pay out, and exactly how much each heir or beneficiary receives. Without it, you risk disputes, court objections, and personal liability. A solid worksheet keeps you organized and protects you throughout the probate process.

What exactly is an estate distribution accounting worksheet?

An estate distribution accounting worksheet is a structured document that records the financial activity of a deceased person's estate. It covers the assets collected, debts and expenses paid, income earned during administration, and the final distribution to each beneficiary. In Kentucky, administrators and executors use this worksheet to prepare their final settlement filed with the probate court.

Think of it as a detailed ledger. It shows the court and all interested parties exactly where every penny went. The worksheet typically includes columns for dates, descriptions, debits, credits, and running balances. It breaks down categories like real property, personal property, bank accounts, investments, funeral expenses, taxes, and legal fees.

Why does Kentucky require this kind of accounting?

Kentucky probate law requires fiduciaries to account for all estate assets. Under KRS 395.190, a personal representative must file a settlement of accounts with the county court. The worksheet serves as the working document behind that formal filing. If a beneficiary or the court questions your handling of the estate, this worksheet is your primary evidence of transparency and good management.

Administrators who skip this step or keep sloppy records often face surcharge meaning the court can hold them personally responsible for any losses to the estate. A worksheet template prevents that risk by giving you a consistent format to follow from day one. You can learn more about Kentucky's fiduciary accounting requirements for executors to understand the full scope of what the court expects.

When do administrators need to start using a worksheet?

The short answer: immediately. As soon as you receive your letters of administration from the probate court, you should begin recording estate activity. Don't wait until you're preparing the final settlement to backtrack through months of bank statements and receipts.

Here's a realistic timeline of when different worksheet entries typically start:

Week one: Record the initial inventory real estate appraisals, bank account balances, vehicles, personal property of value.
Months one through three: Track funeral expenses, outstanding debts, mortgage payments, utility bills, and insurance premiums you pay on behalf of the estate.
Months three through twelve: Log income collected (rental income, interest, dividends), asset sales, tax payments, attorney fees, and administrator compensation.
Final stage: Calculate the net distributable amount and record each beneficiary's share based on the will or intestate succession laws.

If the decedent died without a will, the distribution rules follow Kentucky's intestate succession statutes. Our guide on the intestate estate distribution process in Kentucky walks through how those shares are determined.

What sections should a Kentucky estate worksheet include?

A well-designed template for Kentucky administrators should contain these core sections:

1. Estate header information

This section identifies the case. Include the decedent's full legal name, the county where the estate is pending, the case number, the administrator's name, and the date of death. This information ties your worksheet directly to the probate file.

2. Asset inventory

List every asset the estate owns, grouped by type. Common categories include:

Real property (homes, land, mineral rights)
Bank accounts (checking, savings, CDs)
Investment accounts (brokerage, retirement accounts subject to probate)
Vehicles and titled personal property
Household goods and personal effects
Life insurance payable to the estate
Business interests

Each entry should show the date you identified the asset, a brief description, and the fair market value at the date of death.

3. Income received during administration

Estates often earn income while being administered. Rental payments, interest, dividends, and business income all go here. Kentucky treats estate income differently for tax purposes, so accurate tracking matters. Our article on completing estate distribution accounting forms in Kentucky covers how to handle these entries on the official filings.

4. Debts, expenses, and taxes paid

Record every payment made from estate funds. This includes:

Funeral and burial costs
Medical bills of the decedent
Credit card balances and loans
Administrative expenses (attorney fees, appraisal costs, court filing fees)
Property taxes, homeowner's insurance, and maintenance on estate property
Federal and state estate or income taxes
Administrator compensation

Attach receipts or canceled checks to support each entry. Courts can and do ask for documentation.

5. Proposed distribution

After subtracting all debts and expenses from total assets and income, the remaining balance is what gets distributed. Your worksheet should show each beneficiary's name, their relationship to the decedent, the percentage or share they're entitled to under the will or Kentucky law, and the dollar amount of their distribution.

How do you calculate each beneficiary's share?

If the decedent left a valid will, the will controls the distribution. The worksheet should reflect the exact percentages or specific bequests written in the will. If the will directs that "the residue be split equally among my three children," then divide the net estate by three.

When there's no will, Kentucky's intestate succession law applies. A surviving spouse receives a share that depends on whether there are surviving children. For example, if the decedent left a spouse and two children, the spouse receives one-half of the estate and the children split the other half equally. These calculations get more complex with blended families, predeceased heirs, or half-siblings, so double-checking against the statute is essential.

What are the most common mistakes administrators make with estate worksheets?

After working with Kentucky probate cases, several patterns emerge:

Mixing personal and estate funds. Every estate transaction should flow through a dedicated estate bank account. Never pay estate bills from your personal account or vice versa.
Forgetting to record small expenses. Postage, mileage to the property, replacement locks, storage unit rentals these small costs add up and are legitimate estate expenses. Log them as they happen.
Using date-of-death values for everything. Assets like real estate and investments change in value. Your final accounting should use the value at the time of distribution for assets that were sold, but date-of-death value for assets distributed in kind.
Not accounting for estate income. Rent collected, dividends received, and interest earned during administration are estate income, not personal income. They belong in the worksheet.
Distributing before paying debts. Kentucky law requires debts and expenses to be paid before distributions. If you distribute assets prematurely and a creditor surfaces later, you could be personally liable.

Using accounting software designed for probate work can reduce these errors significantly. If you're looking for tools, we cover the best estate distribution accounting software for Kentucky probate attorneys, and many of these tools work well for non-attorney administrators too.

Can I create my own worksheet, or should I use a template?

You can build your own spreadsheet, but most administrators benefit from starting with a proven template. A template ensures you don't overlook required categories, keeps your formatting consistent for court filing, and saves hours of setup time. The key is making sure the template you use aligns with Kentucky's specific probate requirements not all generic templates do.

A good estate distribution accounting worksheet template for Kentucky administrators will already include the sections outlined above and follow the same structure the probate court expects in a final settlement.

What supporting documents should I keep with the worksheet?

Your worksheet doesn't stand alone. Attach or file alongside it:

Bank statements for the estate account
Appraisals for real property and valuable personal property
Receipts for all expenses paid
Copies of paid invoices from attorneys, accountants, and other professionals
Tax returns filed on behalf of the estate
Closing statements from any real estate sales
Distribution receipts signed by each beneficiary

Keep these records for at least five years after the estate closes. Some attorneys recommend longer, especially if any beneficiary disputes were involved.

Quick checklist before filing your final settlement

All assets have been collected, sold, or distributed
All known debts and taxes have been paid
The worksheet balances total assets plus income minus expenses equals total distributions
Each distribution matches the will or intestate share
Every expense has a receipt or documentation attached
Beneficiaries have signed receipts acknowledging their distributions
The worksheet format matches what your county's probate court expects
You've reviewed the final numbers with your attorney or accountant

Start filling out your worksheet the day you receive your letters of administration. Record every transaction as it happens, not weeks later when details get fuzzy. If a number doesn't feel right, investigate it before filing. The time you spend on accurate record-keeping now saves you from court objections, beneficiary disputes, and personal liability down the road.