The $6 Billion Risk: Why Compensation Planning Doesn’t Belong in a Spreadsheet
Improve Your HR
If you work in compensation planning, you may think, how much damage can one spreadsheet do?
In 2012, JP Morgan Chase lost $6 billion–that’s billion with a B–in the “London Whale Disaster. It had a complex model called the Synthetic Credit Portfolio Value at Risk (VaR) Model that was manually updated in Excel. Someone made an error, and that error was repeated, ultimately resulting in huge losses.
In 2020, a UK contact tracing program left off 15,841 positive Covid cases. Why? Because no one realized Excel has a limited number of rows and additional cases didn’t get added on.
In 2024, officials in Japan’s Aomori Prefecture discovered lost tax revenue of 790 million yen (approximately $5.4 million), which they had to recalculate and contact thousands of taxpayers about. This was caused by someone making an Excel reference error.
The problem with spreadsheets
Excel isn’t evil. It’s just not built for critical, high-stakes processes, including compensation planning.
To keep reading, click here: The $6 Billion Risk: Why Compensation Planning Doesn’t Belong in a Spreadsheet
The post The $6 Billion Risk: Why Compensation Planning Doesn’t Belong in a Spreadsheet appeared first on Improve Your HR.
Go to Source
15/04/2025 – 12:00 /Evil HR Lady
SoMe: @hoffeldt.bsky.social

About Admin
As an experienced Human Resources leader, I bring a wealth of expertise in corporate HR, talent management, consulting, and business partnering, spanning diverse industries such as retail, media, marketing, PR, graphic design, NGO, law, assurance, consulting, tax services, investment, medical, app/fintech, and tech/programming. I have primarily worked with service and sales companies at local, regional, and global levels, both in Europe and the Asia-Pacific region. My strengths lie in operations, development, strategy, and growth, and I have a proven track record of tailoring HR solutions to meet unique organizational needs. Whether it's overseeing daily HR tasks or crafting and implementing new processes for organizational efficiency and development, I am skilled in creating innovative human capital management programs and impactful company-wide strategic solutions. I am deeply committed to putting people first and using data-driven insights to drive business value. I believe that building modern and inclusive organizations requires a focus on talent development and daily operations, as well as delivering results. My passion for HRM is driven by a strong sense of empathy, integrity, honesty, humility, and courage, which have enabled me to build and maintain positive relationships with employees at all levels.