The Blog of Ian Mercer.

Preparing for death

Cover Image for Preparing for death

Last year a close friend passed away and I became the executor for his estate. He knew his time was limited and could maybe have done a few more things to prepare. I'm listing some of the things I've come across here in the hope that it will help other people in this situation and those that they leave behind.

CAVEAT: None of this should be taken as legal or finanical advice. Consult a professional. Rules vary by country and state.

Digital footprint

We each have a large, complex 'digital footprint' consisting of bank accounts, bills, social media, loyalty programs, ... and it's increasingly hard to find, transfer or shutdown each of those accounts after death. Two-factor authentication, password reset questions, ... and many other aspects of the way websites are created these days make everything harder for those tasked with cleaning them up.

Things to do before you die

  1. Close out as many accounts as you can. Quora, LinkedIn, Reddit, Cragslist, ... just close them all as soon as you can.
  2. Move as many accounts as you can to those you will leave behind or at least add your beneficiaries as joint owners on the account so that they can operate the account after you have gone (especially utility bills).
  3. Make a giant list with everything those left behind will need to know. Bank accounts, social security numbers, dates of birth, places of birth, answers to memorable questions, ...
  4. Make sure your 401k or retirement accounts have named beneficiaries. If they do, the money can go straight to those people bypassing probate.
  5. Make sure your bank accounts are designated Joint Tenant With Rights of Survivorhsip (JTWROS) where that matters, otherwise your business partner, say, might be locked out when you die until after the estate is settled.
  6. Make sure your house title and car registrations are in joint names. Even better, can you put any of them in your beneficiaries names before death by gifting them? It might not save any tax but it will save your executor from a bunch of work.
  7. If you elected online statements from your bank, turn it off right away and go back to paper statements. On death all your accounts may need to be closed and reopened as a single 'Estate of ...' account. When that happens your executor loses access to online banking and although you can request copies from the bank that takes time.
  8. Make sure you have a register of checks written especially for taxes, home improvements and other items that will matter next year and possibly for longer. A bank statement with just "Check 1234 $567.89" is no use whatsoever in trying to figure out how much estimated tax you paid last year.
  9. Do your taxes early, or at least all the preparation work so your executor can just complete them and file them right away.
  10. Prepay insurance and other bills for several months so that nobody loses their cellphone account, or gets overdue fees during the months it will take to sort everything out.
  11. If you are leaving kids behind, make sure they have their own bank accounts, debit cards and credit cards if possible. As soon as they reach 18 convert those accounts into adult accounts so that they can have check books and other banking features that aren't available to minors. (You should do this anyway - educate your kids in money matters as early as possible).
  12. Make a file with every certificate and legal document your executor or kids might need when you are gone: birth certificate, marriage certificate, passport, ...
  13. Make a list of online accounts, usernames, passwords, ... and note what should happen to each when you are gone.
  14. Make a list of assets and the value of each: cars, jewlery, art, ... including any appraisals you have for them.
  15. Spend all your airmiles and loyalty points as you go along. The benefit from using them for travel typically outweighs any other benefit, but most of them cannot be transferred after death as travel points, some are lost entirely and some may be redeemable for gift cards. If you have any left and can convert them to gift cards, do it now, and give the cards to your beneficiaries directly! Sometimes the only option is to donate the points to charity, do that now too, don't wait, it's one less trouble for those you leave behind.
  16. Create a digital archive with all the electronic documents that might be useful to your successors. Past tax returns, copies of agreements, certificates, ... put it on an SD card and put it in dropbox or somewhere else with a secure password. Write that password down, put it in an envelope and make sure people who where to find that envelope.
  17. Sell assets: start the garage sale now and turn as many unwanted items into cash.

If anyone reading this has any other suggestions, drop me a note on Twitter @ianmercer and I'll try to add them.

Related Stories

Cover Image for Time Series Data Compression

Time Series Data Compression

This new technique to compress the time series data collected by my home automation system seems to be working really well.

Ian Mercer
Ian Mercer
Cover Image for Digital Twins are never identical

Digital Twins are never identical

Digital Twin are an online representation of a real world object, a copy of its properties in the digital world and a way to send updated and commands to it. In effect I've been making them for years but now they have a trendy name.

Ian Mercer
Ian Mercer
Cover Image for Why smarthomes are hard

Why smarthomes are hard

Why automated learning is hard for a smart home. The perils of over-fitting, under-fitting and how the general unpredictable nature of life makes it hard to build a system that learns your behavior.

Ian Mercer
Ian Mercer
Cover Image for Collinearity test for sensor data compression

Collinearity test for sensor data compression

One way to reduce the volume of sensor data is to remove redundant points. In a system with timestamped data recorded on an irregular interval we can achieve this by removing co-linear points.

Ian Mercer
Ian Mercer
Cover Image for Event blocks

Event blocks

Home automation systems need to respond to events in the real world. Sometimes it's an analog value, sometimes it's binary, rarely is it clean and not susceptible to problems. Let's discuss some of the ways to convert these inputs into actions.

Ian Mercer
Ian Mercer
Cover Image for Logistic function - convert values to probabilities

Logistic function - convert values to probabilities

Another super useful function for handling sensor data and converting to probabilities is the logistic function 1/(1+e^-x). Using this you can easily map values onto a 0.0-1.0 probability range.

Ian Mercer
Ian Mercer
Cover Image for ATAN curve for probabilities

ATAN curve for probabilities

In a home automation system we often want to convert a measurement into a probability. The ATAN curve is one of my favorite curves for this as it's easy to map overything onto a 0.0-1.0 range.

Ian Mercer
Ian Mercer
Cover Image for Home Construction Advice

Home Construction Advice

Several years ago we did a major remodel. I did all of the finish electrical myself and supervised all of the rough-in electrical. I also put in all of the electrical system and water in our barn. I have opinions ...

Ian Mercer
Ian Mercer
Cover Image for T-Mobile home internet

T-Mobile home internet

I'm testing a T-Mobile Home Internet device as a backup to XFinity and a way to offload half our monthly traffic to avoid the XFinity 1.2TB cap

Ian Mercer
Ian Mercer
Cover Image for iBeacon meetup in Seattle - January 2015

iBeacon meetup in Seattle - January 2015

My notes on the iBeacon meetup in Seattle held in January 2015

Ian Mercer
Ian Mercer
Cover Image for Home Automation Systems as a Graph

Home Automation Systems as a Graph

Using nodes and links to represent a home and all the devices in it

Ian Mercer
Ian Mercer
Cover Image for Showing home status with just a single RGB LED

Showing home status with just a single RGB LED

Multicolored LEDs can convey a lot of information in a small space

Ian Mercer
Ian Mercer
Cover Image for A wireless sensor network using Moteino boards

A wireless sensor network using Moteino boards

The diminutive Arduino boards include a powerful transmitter/receiver

Ian Mercer
Ian Mercer

JSON Patch - a C# implementation

Ian Mercer
Ian Mercer
Cover Image for A Quantified House - My Talk to the Seattle Quantified Self Meetup

A Quantified House - My Talk to the Seattle Quantified Self Meetup

My talk to the Seattle Quantified Self meetup

Ian Mercer
Ian Mercer

Integrating an Android phone into my home automation system

Some new features for my home automation using an Android phone

Ian Mercer
Ian Mercer

Before there was the web there was BeebTel

Just thought I should mention that I built a web-like system before the web existed

Ian Mercer
Ian Mercer

My first programme [sic]

At the risk of looking seriously old, here's something found on a paper tape

Ian Mercer
Ian Mercer
Cover Image for The Internet of Dogs

The Internet of Dogs

Connecting our dog into the home automation

Ian Mercer
Ian Mercer

Finally got the 1U Atom Server racked up

Ian Mercer
Ian Mercer

Timelapse video using the GoPro HD Hero

Ian Mercer
Ian Mercer

Web site crawler and link checker (free)

Ian Mercer
Ian Mercer

Smart home energy savings - update for 2010

Ian Mercer
Ian Mercer

I should have created Four Square ...

Ian Mercer
Ian Mercer
Cover Image for How can I tell if my house is smart?

How can I tell if my house is smart?

Ian Mercer
Ian Mercer

Asian Gadgets

Ian Mercer
Ian Mercer

A great video explaining the Semantic Web

Ian Mercer
Ian Mercer

Interesting Twitter Posts March 15th-

Ian Mercer
Ian Mercer

Twitter links for Week beginning March 8th

Ian Mercer
Ian Mercer

Elliott 803 - An Early Computer

Ian Mercer
Ian Mercer

Facebook, social gaming and points

Ian Mercer
Ian Mercer

Useful Twitter links Feb 8-Feb 15 2010

Ian Mercer
Ian Mercer

Looking forward to the new year and our new datacenter

Historical note about moving my servers into a datacenter

Ian Mercer
Ian Mercer

When will people learn to backup?

A rant about RAID

Ian Mercer
Ian Mercer

Future proof your home with a new conduit system?

Running conduit can be expensive but maybe you don't need one to every room

Ian Mercer
Ian Mercer

Balloon Boy was much ado about nothing - Twitter

Some of the more witty comments on Twitter about the Balloon Boy hoax

Ian Mercer
Ian Mercer

Shortened URLs should be treated like a Codec ...

Expanding URLs would help users decide whether or not to click a link

Ian Mercer
Ian Mercer

Tagging File Systems

Isn't it time we stopped knowing which drive our file is on?

Ian Mercer
Ian Mercer

WMPnetwk.exe started using 50% of my CPU

Uninstalling Windows Media Player - the end of an era

Ian Mercer
Ian Mercer

Introducing Jigsaw menus

A novel UI for menus that combines a breadcrumb and a menu in one visual metaphor

Ian Mercer
Ian Mercer

Amazon Instance vs Dedicated Server comparison

Some benchmark performance for Amazon vs a dedicated server

Ian Mercer
Ian Mercer

Agile Software Development is Like Sailing

You cannot tack too often when sailing or you get nowhere. Agile is a bit like that.

Ian Mercer
Ian Mercer

AntiVirus Software is the Worst Software!

When your anti-virus software starts stealing your personal data, it's time to remove it!

Ian Mercer
Ian Mercer

Second Drobo Update

At this point things were looking up for my Drobo

Ian Mercer
Ian Mercer

It's all about disk speed

Why disk speed is the most critical aspect for most modern PCs and servers

Ian Mercer
Ian Mercer

Comcast woes and a new monitoring utility

Monitoring a cable modem using its HTML management interface

Ian Mercer
Ian Mercer

Core duo desktop machine runs cool

Ian Mercer
Ian Mercer
Cover Image for Giving up on Internet Explorer

Giving up on Internet Explorer

Ian Mercer
Ian Mercer
Cover Image for New Home Automation Server

New Home Automation Server

Ian Mercer
Ian Mercer

Dell upgrades - a pricey way to go

Ian Mercer
Ian Mercer