• News
    • Tech News
    • AI
  • Gadgets
    • Apple
    • iPhone
  • Gaming
    • Playstation
    • Xbox
  • Science
    • News
    • Space
  • Streaming
    • Netflix
  • Vehicles
    • Car News
  • Social Media
    • WhatsApp
    • YouTube
  • Advertise
  • Terms
  • Privacy & Cookies
  • LADbible Group
  • LADbible
  • UNILAD
  • SPORTbible
  • GAMINGbible
  • Tyla
  • FOODbible
  • License Our Content
  • About Us & Contact
  • Jobs
  • Latest
  • Topics A-Z
  • Authors
Facebook
Instagram
X
TikTok
Snapchat
WhatsApp
Submit Your Content
$16,000,000,000 health department used a single Excel spreadsheet to manage its finances and it didn't end well

Home> News

Published 11:23 10 Mar 2025 GMT

$16,000,000,000 health department used a single Excel spreadsheet to manage its finances and it didn't end well

Who thought this would turn out well?!

Rebekah Jordan

Rebekah Jordan

A billion-dollar public health system uses a single Excel spreadsheet to manage its finances - and it's not going well.

Health New Zealand (HNZ) was set up in 2022 to replace 20 district health boards in the hope of being more cost-effective and consistent.

With a budget of NZ$28 billion (around US$16 billion), the organisation assured lawmakers it would stay within its financial limits for the 2023-24 fiscal year. However, the prediction turned out to be incorrect and HNZ blew its budget, triggering a financial review that uncovered some serious issues.

Advert

A Deloitte-led review found that HNZ had essentially lost 'control of the critical levers that drive financial outcomes' and could not 'identify and respond to the disconnect between expenditure and revenue.'

One of the biggest revelations was that the entire system’s financial management was presented on a single Microsoft Excel spreadsheet, including 'consolidation, journals, business-critical reporting, and analysis.'

Besides the obvious issues, the report also noted five major problems with the sheet.

The Washington Post / Contributor / Getty
The Washington Post / Contributor / Getty

Advert

First, the financial information was reportedly often 'hard-coded,' making it difficult to trace changes or update information efficiently.

It was found that errors typically went unnoticed until later periods such as double-releasing funds or misreporting accruals, not to mention the spreadsheet carried a high risk of human error such as simple typos or misplaced zeros.

Additionally, any changes made to past financial reports and district-level data often didn’t carry over correctly which resulted in data discrepancies.

Finally, the spreadsheet was easy to manipulate information on as there was no direct link between the spreadsheet and accounting systems. On top of that, HNZ’s reliance on this system made financial reporting a slow process. "Monthly financial reporting usually took 12-15 days to consolidate and five days to analyse," the report said.

Advert

“The use of an Excel spreadsheet file to track and report financial performance for a NZ$28bn expenditure organisation raises significant concerns, particularly when other more appropriate systems are present on the IT landscape."

Andrew Brookes / Getty
Andrew Brookes / Getty

If Excel as the backbone of a national health budget wasn’t enough of a red flag, Health Minister Simeon Brown revealed even more about HNZ’s operational challenges.

According to Brown, the HNZ runs around 'an estimated 6,000 applications and 100 digital networks,' which equates to one application for every 16 staff members. Despite the organisation being 'two years old,' Senior Leadership Team members 'have only just begun weekly in-person meetings, and have continued to operate from different offices.'

Advert

Surprisingly, despite all that's gone wrong, the Minister doesn’t have a plan to get off Excel or address its wider tech issues.

What he did promise though was to investigate 'creating a separate Health Infrastructure Entity under Health New Zealand, to manage and deliver physical and digital assets.' But the details of that plan or an expected timeline for rollout are still up in the air.

Featured Image Credit: The Washington Post / Contributor / Getty
Health
Microsoft

Advert

Advert

Advert

Choose your content:

6 hours ago
7 hours ago
8 hours ago
9 hours ago
  • 6 hours ago

    How a bike shop owner accidentally discovered he was Jeff Bezos' dad after making 'big mistake'

    He described his relationship with the billionaire as the 'biggest mistake of his life'

    News
  • 7 hours ago

    Sam Altman calls out Mark Zuckerberg with claims Meta tried to lure OpenAI staff with $100,000,000 salaries

    The OpenAI CEO has claimed that Meta are offering its staff enormous signing bonuses

    News
  • 8 hours ago

    Elon Musk beams uncensored internet to Iranian population through 20,000 hidden satellites

    Some say it's the 'final nail' in Iran's coffin

    News
  • 9 hours ago

    Every citizen who would be drafted if the US went to war tomorrow following Russian general's declaration of WW3

    Millions would be called forward to fight

    News
  • Man didn't look at a screen for two months and it changed his life in this unexpected way
  • Biohacker trying to 'live forever' reveals reason he will never do a cold plunge despite health benefits
  • Horrifying simulation shows life-threatening impact of drinking too much water and how it can lead to death