• 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.

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.'

Advert

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

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

Advert

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.

“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."

Advert

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.'

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

Advert

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

  • Man didn't look at a screen for two months and it changed his life in this unexpected way
  • Man drops GoPro down a 300ft well to see what truly lies at the bottom and it will leave you feeling uneasy
  • Horrifying simulation shows life-threatening impact of drinking too much water and how it can lead to death

Choose your content:

an hour ago
4 hours ago
  • Westend61 / GettyWestend61 / Getty
    an hour ago

    Scientists reveal the 36 names least likely to get a job in shocking new study

    Employers are taking first impressions to the extreme

    Science
  • Kmatta/Getty ImagesKmatta/Getty Images
    an hour ago

    Video shows what really happens to your body if you drink seawater

    Salt content in seawater is much higher than what can be processed by the human body

    Science
  • Spencer Platt/Getty ImagesSpencer Platt/Getty Images
    an hour ago

    Donald Trump and family make $6,000,000,000 overnight after launching new crypto currency

    A whopping $1 billion changed hands within the first hour of trading

    News
  • panida wijitpanya via Gettypanida wijitpanya via Getty
    4 hours ago

    Facebook users warned Meta could be 'secretly' scanning your phone's camera roll without permission

    Thankfully, there's a way to turn the feature off

    News