make your free estate administration worksheet
what is an estate administration worksheet?
it's difficult when a loved one passes. an estate administration worksheet can help with handling the estate side of things. you need to figure out the proper procedure: who are the beneficiaries? which documents do you need? what was the financial situation of the person who passed? ideally, all of this is clearly addressed in a will, but if it isn't then getting things figured out might all be up to you - and it's important that you don't miss something. this encompassing document can be your guide to quickly getting estates handled. when you have an estate administration worksheet, you can speed up the process to make sure your loved one's wishes are fulfilled.
when to use an estate administration worksheet:
- you want to gather and organize estate information.
- you need to get beneficiaries and financial information figured out.
- you'd like to finalize which documents you need.
- you just want to figure out the estate procedures after someone passes.
sample estate administration worksheet
the terms in your document will update based on the information you provide
estate administration worksheet
for
prepared on
a. initial procedures necessary in order to begin formal probate administration |
1. will and related documents. obtain and review the decedent's will and any codicils to the will. further review any related trust agreement, tangible personal property list, declaration of final wishes, or premarital agreement. the will names the executor (sometimes known as "personal representative"), the person or organization who will carry out the terms of the will. the executor must be approved by the probate court in order to take official acts on behalf of the decedent's estate. however, in the meantime the executor should begin the process described in this checklist, including applying for formal court appointment.
date of decedent's will:
name of executor/personal representative:
other documents:
description | date |
2. estate attorney. choose and hire an attorney who will assist the executor (personal representative) in administering the estate. the choice does not need to be the attorney who drafted the will, or even the attorney nominated by the decedent in the will, if any. however, the attorney should be a lawyer who regularly handles estates.
name of attorney: |
address: |
,
phone number: |
e-mail: |
3. immediate needs.
a. family needs. provide for the decedent's surviving spouse and/or minor children, if any. it may be necessary to obtain probate court authority to pay an "allowance" to the immediate family members until the estate assets are eventually distributed.
b. safeguard assets. where necessary, safeguard the decedent's real estate, vehicles and personal property, and establish a system to pay bills.
c. insurance protection. verify the existence and adequacy of property and liability insurance for the decedent's assets.
d. change of address. arrange for mail to be forwarded to the appropriate party. complete and mail change of address forms, as appropriate.
4. gather information. obtain general and financial information about the decedent and the decedent's family and beneficiaries that will be useful in administering the estate.
. sources of information. the following sources will help provide the needed information.
decedent's family and friends. the decedent's family and perhaps close friends will know much of the personal information that is needed.
death certificate. obtain a copy of the decedent's death certificate from the funeral service provider or directly from the appropriate local government office. several copies should be obtained.
issuing authority: |
certificate number: |
personal papers and effects. the decedent's residence will usually contain personal records that include financial information. if the decedent's financial affairs were being handled by a third party (perhaps an agent under a power of attorney), you will need to contact that third party.
insurance policies. obtain copies of policies covering property (real estate, vehicles, contents of residence) liability, and health.
income tax returns. obtain copies of the decedent's most recent income tax returns (perhaps the last three years).
types of tax return | year |
the mail. bank statements, insurance premiums, utility bills, and other incoming mail items will contain important financial information.
safe deposit box. find out if the decedent rented a safe deposit box, and if so, obtain the location of the box, the box number, and the location of the keys to the box. safe deposit boxes often contain personal property, stock certificates, insurance policies, real estate documents, and other helpful information.
box number | location |
advisors of the decedent. the decedent's various advisors may be able to provide very important information and assistance. obtain the names, addresses and contact information of the decedent's advisors, which may include an attorney, accountant or tax return preparer, insurance agent, financial planner, investment broker, and banker.
. decedent's personal information. obtain the following information about the decedent.
decedent's name: |
address: |
,
date of birth: |
date of death: |
age at death: |
marital status: |
state of residence: |
year residence established: |
. employment information. contact the decedent's employer, or a past employer for a retired decedent, who may have very important insurance or employee benefits information.
decedent's occupation:
. family and beneficiary information. obtain the names, addresses, phone numbers and birth dates for the decedent's spouse and children (to the extent applicable) and the beneficiaries under the decedent's will.
. fiduciaries under the decedent's will. obtain the names and contact information for any executors (personal representatives), trustees, or guardians that are named in the decedent's will.
. financial information. obtain detailed information regarding the decedent's property and debts. the values of the decedent's various assets as of the date of death will need to be determined. in some cases, appraisals from third party experts may be needed to determine the values.
cash, bank accounts and certificates of deposit. prepare a listing of all cash related items. determine the named owner of each account, the manner in which title is held, date-of-death balance, and accrued interest to date of death. the banking institution can be contacted to obtain this information, which should be compared with the decedent's personal information.
savings bonds. make a listing of the bonds, including the date of purchase, face amount, named owner, and the manner in which title is held.
stocks, mutual funds and other securities investments. list the various investments of the decedent in securities. the list should include the named owners, the manner in which title is held, and the value as of the date of death. if an item is in certificate form make a copy of the certificate so that you have a record of the number of shares, the name of the investment and the "cusip" number. obtain date-of-death market quotations for each security. a broker's expertise may be needed to help value securities that are not regularly traded in the stock market.
if the investment is held in a brokerage account, make a copy of a recent account statement that shows the name of brokerage firm, the name of the broker agent (if any), the account number, and each investment in the account. contact the broker to help you determine the values of each investment as of the date of death, and whether there were any dividends or interest that were payable to the account as of the date of death.
real estate. make a listing of all real estate owned by the decedent and their values. include street addresses and legal descriptions for each property. obtain copies of deeds, abstract of title and/or title insurance policy, and recent real estate tax statements. determine whether any of the real estate is subject to a mortgage. if so, determine the balance of the mortgage, name of lender, loan number, and names of the borrowers.
obtain copies of property insurance policies and other information which shows the name of the company, account number, amount of coverage, expiration date, premium payment date, and agent's name, address, and phone number. determine whether environmental problems may exist for any of the real estate. a real estate appraisal may be needed to determine the value of the real estate.
vehicles. list each vehicle and obtain copies of vehicle titles and registrations which will show the named owners and the manner in which title is held. obtain date-of-death retail values for each vehicle from a dealer or a recently-published "blue book" that lists vehicle values.
personal property. make a list of household goods, furniture, personal effects, and miscellaneous property owned by the decedent. in many cases, the listing can be summary in form. for example, if the decedent owned very little furniture of a reasonably small value, the list may include "furniture - $500," rather than showing each individual item of furniture. in valuing personal property, use the "garage-sale value" for items of limited value. the appraisal of a jeweler or coin dealer may be needed for jewelry or a coin collection.
life insurance. make a listing of each life insurance policy owned by the decedent. although life insurance proceeds will not be controlled by the will (unless the will is the designated beneficiary), the life insurance information will be needed to properly prepare and file the federal estate tax return and any required state death tax return. the list should include policies on the decedent's life, as well as policies owned by the decedent on other individuals.
in each case, the list should include the insurance company, a phone number or address for contacting the company, the face amount of the policy, the policy number, and the name(s) and address(es) of the beneficiaries. in addition, obtain the cash surrender value of the policy, particularly if the policy insures the life of someone other than the decedent.
if the decedent created a life insurance trust at any time, obtain a copy of the trust agreement, and make a list of all insurance policies owned by the trust. determine the dates that each policy was obtained or transferred into the trust, as well as all of the above details.
retirement plans / annuities. make a list of all pensions, annuities, retirement plans, individual retirement accounts, and other retirement benefits that the decedent may have had. in each case, the remaining values of these accounts will need to be determined.
government and employment benefits. determine whether the decedent was receiving any government benefits, and whether the decedent's survivors are entitled to any continuing benefits. such benefits may include social security benefits, veteran's benefits, and railroad retirement benefits.
determine whether the decedent was entitled to any unpaid employee benefits, including accrued salary, accrued vacation pay, accumulated sick pay, group life insurance, workers compensation benefits, company death benefits, retirement plan benefits, deferred compensation benefits, and stock options. make a list of each item and its date of death value.
other property. determine whether the decedent owned any other property. if so, obtain information on such property so that it can be described and valued as of the date of death. other property may include tax refunds, recently inherited property, and refunds of insurance, subscriptions and other items.
debts and expenses. make lists of any unpaid bills owed by the decedent as of the date of death. such bills may arrive in the mail for up to several months following the death. typical expenses include utilities, final medical expenses, and funeral expenses.
. estate information. the following information will be needed, although some of it will not be available initially. the information will be generated as part of the estate administration process.
* | the county or other jurisdiction where the estate is being administered. |
* | the name of the court that is administering or "probating" the will, and the number assigned to the estate by the court. |
* | the date that the will was "admitted" to probate, or the date that the estate was opened. |
county/jurisdiction: ____________________________________
name of court: ____________________________________
court number: ____________________________________
date of estate opening: ____________________________________
fiduciary bond information. a bond may be required by the terms of the will or by the court; a bond is similar to an insurance policy, designed to protect the beneficiaries from misappropriation of assets by the executor / personal representative.
. fiduciary roles of the decedent. make a list of all fiduciary obligations of the decedent, if any, as of the date of death. such responsibilities will need to be transferred to others. such fiduciary obligations could include trustee of a trust, executor of an estate, conservator or guardian for someone else, custodian for a minor, agent under a power of attorney, registered agent for a company.
. guardianship / conservatorship. if the decedent was the "ward," whose affairs were being handled by a conservator or guardian for the decedent's benefit, such guardianship and/or conservatorship proceedings will need to be concluded and terminated.
5. | court procedures. certain procedures will need to be followed in having the will "probated" by the proper court. these procedures vary from one state to another, but can include the following. |
a. will. apply to the court that handles probate matters to have the decedent's will "admitted" to probate. if the will appears to be legitimate and if it appears to have been signed following all of the necessary formalities, the court will accept the will, subject to possible objections by potential heirs and beneficiaries.
b.self-proving affidavit. a "self-proving affidavit" may have been attached to the will. this affidavit is a sworn statement signed by the decedent and the witnesses to the will, in the presence of a notary public, swearing that all of the formalities in signing the will were followed. if no such affidavit is attached to the will, or if state law does not recognize the self-proving affidavit, it may be necessary to locate one or more of the witnesses and obtain from them a sworn statement to the same effect.
c.appointment of executor / personal representative. apply to the court to appoint an executor / personal representative who will have the authority to collect, manage and distribute the decedent's assets and pay the decedent's debts and expenses. the executor will be required to provide the court with a sworn promise to act honestly and use his/her best abilities in carrying out the duties in that role.
d.fiduciary bond. if necessary, obtain a fiduciary bond on the executor to protect the beneficiaries against misappropriation of assets by the executor. the court may agree not to require a bond, depending upon the provisions of state law, whether the decedent requested that no bond be required, and/or if the beneficiaries collectively agree not to require a bond.
e.notice to creditors, heirs and beneficiaries. notify all of the decedent's creditors, beneficiaries and heirs of the admission of the will to probate and the appointment of the executor / personal representative. this is done to provide the heirs and beneficiaries with a limited period of time during which they can object. for example, objections may be made on grounds that the will was not properly witnessed and signed, that the decedent signed the will under the improper influence of a beneficiary, or that a more recent will exists. the notice is provided to creditors to give them an opportunity to state that the decedent owed some amount to them.
date that notice is given: _______________________
f.will challenges. if any heirs or beneficiaries file a challenge to the will, such challenges will be handled by the executor / personal representative in accordance with state law procedures.
g.probate - other states. if the decedent owned real estate or other property in other states, it may be necessary to initiate probate procedures in those states.
6. | non-court procedures. the following procedures should be followed as part of the estate administration process. |
a.estate checking account. in most estates, it is appropriate and desirable to open an estate checking account, which can be used to facilitate collection of assets and payment of expenses. it is also an integral part of the estate's record-keeping system.
account number: ____________________________________
name of bank: ____________________________________
contact information: ____________________________________
b.obtain a federal identification number. for many estates, it is necessary to obtain a federal identification number for the estate. this number is obtained from the irs, using form ss-4. it may also be advisable to use form 54 to notify the internal revenue service of the authority of the executor / personal representative to act for the decedent.
federal identification number: _______________________
c.obtain benefits. apply for social security, veterans, employee, and other survivor's benefits.
description of benefit | amount | date obtained | other information |
___________________ | ______ | _____________ | ________________ |
___________________ | ______ | _____________ | ________________ |
___________________ | ______ | _____________ | ________________ |
d.life insurance. send requests to insurance companies to obtain death benefits. obtain irs "form 712" from insurance companies, including forms for policies on the lives of others; this form confirms the value of the insurance and the identity of the beneficiaries.
insurance co. | policy no. | amount | date obtained | other information |
_________________ | _________ | ______ | ____________ | ________________ |
_________________ | _________ | ______ | ____________ | ________________ |
_________________ | _________ | ______ | ____________ | ________________ |
e.insurance claims. if necessary, submit, pay or settle hospitalization and medical insurance claims.
medical claim | amount | date paid | other information |
____________ | _______ | _________ | ________________ |
____________ | _______ | _________ | ________________ |
____________ | _______ | _________ | ________________ |
____________ | _______ | _________ | ________________ |
____________ | _______ | _________ | ________________ |
f. liability and property insurance. notify liability and casualty insurers of the estate administration process.
insurance company | type of insurance | date notified | other information |
_________________ | _______________ | ___________ | ________________ |
_________________ | _______________ | ___________ | ________________ |
_________________ | _______________ | ___________ | ________________ |
g. credit cards. terminate charge accounts and credit cards.
credit card company | outstanding balance | date terminated |
___________________ | __________________ | _______________ |
___________________ | __________________ | _______________ |
___________________ | __________________ | _______________ |
___________________ | __________________ | _______________ |
___________________ | __________________ | _______________ |
h.refund requests. request cancellations and refunds for subscriptions, memberships, health insurance, and similar items.
type of refund | amount | date received | other information |
_____________ | _______ | _____________ | ________________ |
_____________ | _______ | _____________ | ________________ |
_____________ | _______ | _____________ | ________________ |
_____________ | _______ | _____________ | ________________ |
_____________ | _______ | _____________ | ________________ |
i. business property. make sure that businesses of the decedent have continued management. for example, if the decedent was a landlord or creditor, notify the tenants and/or debtors of the place and method for payment.
type of action | date action taken | other information |
____________________ | _________________ | ________________ |
____________________ | _________________ | ________________ |
____________________ | _________________ | ________________ |
j.surviving spouse - planning. if applicable, consider whether or not changes should be made to the surviving spouse's will, living trust, power of attorney, or health care power of attorney.
type of planning | date action taken | other information |
_____________________ | _________________ | ________________ |
_____________________ | _________________ | ________________ |
_____________________ | _________________ | ________________ |
k.disclaimers / post-death estate planning. consider whether steps should or could be taken to reduce or eliminate taxes. for example, "disclaimers" are sometimes filed by beneficiaries who elect not to accept a bequest in order to reduce taxes.
type of planning | date action taken | other information |
_____________________ | _________________ | ________________ |
_____________________ | _________________ | ________________ |
_____________________ | _________________ | ________________ |
7. rights of surviving spouse and minor children. in most states, a surviving spouse and minor children have certain rights to protect them.
a.election of spouse. determine whether the surviving spouse will accept the provisions of the will, or alternatively, demand a share of the estate as may be provided by law. a premarital agreement may specify how this issue should be handled.
type of action | date action taken | other information |
____________________ | _________________ | ________________ |
____________________ | _________________ | ________________ |
____________________ | _________________ | ________________ |
b.support allowance for spouse. if appropriate and necessary, apply to the court for a support allowance for the spouse and/or minor children to be paid from the decedent's assets until the assets can be distributed.
type of action | date action taken | other information |
____________________ | _________________ | ________________ |
____________________ | _________________ | ________________ |
____________________ | _________________ | ________________ |
c.other spousal rights. determine whether the surviving spouse will elect to exercise certain rights, such as occupying the residence and/or protecting certain property as exempt from creditors.
type of action | date action taken | other information |
____________________ | _________________ | ________________ |
____________________ | _________________ | ________________ |
____________________ | _________________ | ________________ |
b. gathering assets. after the executor / personal representative receives formal court appointment, the executor / personal representative has authority to deal with the decedent's assets, subject to court supervision.
1. financial information review. review the financial information already gathered and complete the information, contacting various third parties for additional information as needed.
2. probate assets. determine which assets are "subject to probate" (pass to the beneficiaries pursuant to the will), and which assets will pass automatically to the survivor or named beneficiary. for example, real estate may be held by two persons "jointly, with rights of survivorship" so that upon the death of one, the survivor immediately becomes the sole owner, regardless of what the will may state. life insurance and retirement plan benefits are paid directly to the designated beneficiaries. finally, bank or brokerage accounts and savings bonds may be "payable-on-death to" a named beneficiary.
3. possession of assets. the executor (personal representative) should take physical custody or control of the probate assets, as appropriate.
a.real estate. inform the utility companies, insurance company, and tenants of the executor's authority and responsibility. consider ordering a real estate title search to determine the extent of the decedent's holdings and the state of title (liens, joint owners, etc.).
type of action | date action taken | other information |
____________________ | _________________ | ________________ |
____________________ | _________________ | ________________ |
____________________ | _________________ | ________________ |
b.business operations. assume responsibility and oversight of business operations, as appropriate.
type of action | date action taken | other information |
____________________ | _________________ | ________________ |
____________________ | _________________ | ________________ |
____________________ | _________________ | ________________ |
c.personal property. secure and insure the decedent's household contents, collectibles, vehicles, equipment, jewelry, and other personal property, as appropriate.
type of action | date action taken | other information |
____________________ | _________________ | ________________ |
____________________ | _________________ | ________________ |
____________________ | _________________ | ________________ |
d.cash and investment accounts. change the title of brokerage, bank, and other financial accounts into ownership of the estate, if appropriate.
type of action | date action taken | other information |
____________________ | _________________ | _______________ |
____________________ | _________________ | _______________ |
____________________ | _________________ | _______________ |
e.securities certificates. take possession of the certificates of stocks and bonds held in certificate form, and consider depositing them into a brokerage account to safeguard them and for ease in later distribution or liquidation.
type of action | date action taken | other information |
____________________ | _________________ | _______________ |
____________________ | _________________ | _______________ |
____________________ | _________________ | _______________ |
4. valuation of assets. review the initial efforts in obtaining financial information. obtain valuations and appraisals as necessary.
a.independent appraisals. arrange for independent appraisals of real estate, collectibles, jewelry, and business interests. it is necessary to obtain accurate values of the property for death tax returns and/or to establish a new cost "basis" for the recipient beneficiaries. the "basis" information becomes important in determining taxable gain (profit) to the recipient beneficiary upon that beneficiary's subsequent sale of the inherited property.
type of action | date action taken | other information |
____________________ | _________________ | ________________ |
____________________ | _________________ | ________________ |
____________________ | _________________ | ________________ |
b.published sources of values. consult published valuation guides for publicly-traded securities and vehicles.
c.confirmations from third parties. the confirmations from banks, brokers, insurance companies and other third parties will help establish the values of cash accounts, securities, life insurance and similar items.
d.valuation date. asset values should be determined as of the date of death. if federal estate taxes are payable, the asset values should also be determined as of the "alternate valuation date" (six months after the date of death).
c. payment of debts and expenses. in addition to gathering and valuing the estate property, the executor / personal representative must also determine what debts and expenses should be paid before making distributions to the beneficiaries.
1. debts. the debts of the decedent as of the date of death must be paid. typically, these debts are paid from the estate checking account as estate assets are collected and liquidated. debts can include utilities, medical expenses, and credit card balances.
description of debt | date paid or other action taken |
___________________________ | ________________________________ |
___________________________ | ________________________________ |
___________________________ | ________________________________ |
___________________________ | ________________________________ |
___________________________ | ________________________________ |
2. contested debts. any claims filed in the probate court proceedings must be evaluated. some claims may not be legitimate and should be denied by the executor, which may result in a court hearing to decide the matter.
type of action | date action taken | other information |
____________________ | _________________ | ________________ |
____________________ | _________________ | ________________ |
____________________ | _________________ | ________________ |
3. estate expenses. the expenses incurred in administering the estate must also be paid. these expenses may include storage fees, maintenance costs, appraisal fees, commissions, insurance premiums, fees of brokers, agents, and accountants, safe deposit box rent, utilities, court costs, executor fees, and attorney fees. an accounting of expenses paid should be maintained.
4. tax returns. tax returns must be filed and any taxes owed must be paid. these returns may include a federal estate tax return, a state inheritance or estate tax return, final individual income tax returns (federal form 1040 and applicable state return) for the decedent, a gift tax return (if the decedent made substantial gifts) during the year before death, fiduciary income tax returns (federal and state) for the estate's income, fiduciary income tax returns (federal and state) for the income of any trust, and business and/or employment tax returns for business interests. maintain a list of tax returns to be filed, the due dates for filing the returns, the amount of tax owed, and the actual dates of filing. consult with an appropriate tax professional.
d. sale or distribution of assets. after the debts and expenses, including taxes, have been paid, the executor / personal representative needs to make proper distribution of the remaining assets. the executor must be sure that he/she is authorized by the will or by court approval to sell and/or distribute the assets.
1. specific bequests. pay/distribute any specific bequests of cash or items of property. obtain a receipt for each distribution.
description of bequest | date paid or distribution |
___________________________ | ________________________________ |
___________________________ | ________________________________ |
___________________________ | ________________________________ |
2. liquidation of assets. sell property which will not be distributed "in kind," including property which must be sold in order to pay debts and expenses. maintain a list of property sold, the date of sale, and the amount of the proceeds. this information will be needed to file income tax returns.
3. establish trusts. establish any trusts that are required by the provisions of the will. for example, a children's trust for minor children or a bypass trust for the benefit of a spouse.
4. distribution of remaining assets. distribute the remaining assets of the estate to the "residuary beneficiaries," subject to payment of any final administrative expenses. obtain a receipt from each beneficiary. maintain an accounting record of the distributions.
e. closing the estate. the following steps must be followed to close the estate.
1. tax clearances. in many cases, approvals (sometime known as "clearances") must be obtained from the appropriate government agencies. for example, if a federal estate tax return is required to be filed, a "federal estate tax closing letter" must be obtained from the irs before closing the estate. in many states, similar clearances must be obtained for state death taxes and state income taxes.
type of clearance | date received | other information |
___________________________ | ________________ | _____________________ |
___________________________ | ________________ | _____________________ |
___________________________ | ________________ | _____________________ |
2. final report / accounting. the executor / personal representative must provide an "accounting" to the beneficiaries of all receipts, disbursements and activities of the estate and the executor. usually, the beneficiaries are given the opportunity to file objections to the final report and accounting if they have questions. in such cases, the probate court must resolve any disputes after giving both sides an opportunity to be heard.
3. court approval and discharge. approval of the accounting and final report (as may have been adjusted by objections) is obtained from the court, and the executor / personal representative is released from his/her official duties.
date of discharge: ___________________
4. termination of bond. if the executor was required to be bonded, the bond can be terminated.
date of termination of bond: ___________________
5. payment of final expenses. any final expenses approved in the final report should be paid. any remaining insurance and utilities can be canceled.
6. close estate account. any remaining balance in the estate checking account can be distributed and the account closed.
date closed: ___________________