New Zealand's $16B health dept managed finances with single Excel spreadsheet

The body that runs New Zealand’s public health system uses a single Excel spreadsheet as the primary source of data to consolidate and manage its finances, which aren’t in great shape perhaps due to the sheet’s shortcomings. The spreadsheet-using agency is Health New Zealand (HNZ) which was established in 2022 to replace 20 district health boards in the expectation it would be more cost-effective and deliver more consistent services. The org has a budget of $NZ28 billion ($16 billion) and advised lawmakers it would stay within it for FY 23.24. That prediction was incorrect and HNZ blew its budget, leading to a review of its finances that last week delivered a damning report [PDF] that found the org lost “control of the critical levers that drive financial outcomes” and had an “inability to identify and respond to the disconnect between expenditure and revenue.” The Deloitte-penned report also found an Excel spreadsheet was the “primary data file used by HNZ to manage its financial p ... Read full article.