I’ve been doing this long enough to know that the biggest threat to a 401(k) plan isn’t the Department of Labor, trial lawyers, or even bad investments. It’s 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.
Every correction project starts the same way. A sponsor swears the census is perfect because “it comes straight from payroll.” Then you open the file and discover three different definitions of compensation, hire dates that change from column to column, and a column labeled “Notes—Don’t Touch” that everyone has been touching for five years. The spreadsheet becomes the truth, and the plan document becomes a suggestion.
The problem isn’t technology. The problem is faith. People believe numbers because they look confident. A spreadsheet never hesitates, never admits it’s confused, and never says, “I might be wrong.” Human beings, on the other hand, are messy, so we trust the neat rows instead of the messy reality. That’s 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.
Plan providers spend half their careers arguing with files. We ask simple questions like, “Where did this column come from?” and the answer is usually, “The old bookkeeper created it.” The old bookkeeper has been gone longer than some participants have been alive, but the column remains, immortal and incorrect.
If you want to improve a plan, don’t 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—and that is a terrifying plan administrator.
