I\u2019ve been doing this long enough to know that the biggest threat to a 401(k) plan isn\u2019t the Department of Labor, trial lawyers, or even bad investments. It\u2019s a spreadsheet that someone created in 2017 and has been copying ever since. That spreadsheet has formulas nobody understands, tabs nobody checks, and assumptions that died during the Obama administration. Yet it quietly runs the plan like an unelected dictator.<\/p>\n
Every correction project starts the same way. A sponsor swears the census is perfect because \u201cit comes straight from payroll.\u201d Then you open the file and discover three different definitions of compensation, hire dates that change from column to column, and a column labeled \u201cNotes\u2014Don\u2019t Touch\u201d that everyone has been touching for five years. The spreadsheet becomes the truth, and the plan document becomes a suggestion.<\/p>\n
The problem isn\u2019t technology. The problem is faith. People believe numbers because they look confident. A spreadsheet never hesitates, never admits it\u2019s confused, and never says, \u201cI might be wrong.\u201d Human beings, on the other hand, are messy, so we trust the neat rows instead of the messy reality. That\u2019s how you get late deposit calculations based on the wrong pay frequency or eligibility lists that still include employees who retired during the Bush presidency.<\/p>\n
Plan providers spend half their careers arguing with files. We ask simple questions like, \u201cWhere did this column come from?\u201d and the answer is usually, \u201cThe old bookkeeper created it.\u201d The old bookkeeper has been gone longer than some participants have been alive, but the column remains, immortal and incorrect.<\/p>\n
If you want to improve a plan, don\u2019t start with investments or fees. Start with the spreadsheet that feeds everything else. Treat it like a suspect, not a witness. Until you do, the plan will be governed by a piece of software with no fiduciary duty and no fear of litigation\u2014and that is a terrifying plan administrator.<\/p>\n
<\/span><\/p>","protected":false},"excerpt":{"rendered":" I\u2019ve been doing this long enough to know that the biggest threat to a 401(k) plan isn\u2019t the Department of Labor, trial lawyers, or even bad investments. It\u2019s a spreadsheet that someone created in 2017 and has been copying ever … Continue reading