$ 16b Health Agency Manages Finance with Excel Spreadsheet • Register

The Body Running The New Zealand Health System Uses an Excel Spreadsheet as the main source of data to consolidate and conduct its finances due to sheet defaults.

The spreadsheet-using the agency is Health New Zealand (HNZ) established in 2022 to replace 20 district health boards to expect more effectively and can bring more consistent service. Org has a budget of $ nz28 billion ($ 16 billion) and advised legislators to stay in it for FY 23.24.

That prophecy is incorrect and HNZ wipes its budget, which leads to the review of the finances last week with an injury report .

Report written by Deloitte also found an excel spreadsheet is the “main file used by HNZ ​​handling” Journidations, Critical Business Report, and Analysis. “

Report also found five major sheet problems used in HNZ:

• Finance information is always ‘hard coded,’ hard to track the source or has updated data that goes through.
• Errors such as improper release of accruals or double release are not selected until following times.
• Changes in previous times and fte errors to district financial submissions
• Spreadsheet can easily manipulate information because there is limited tracking of source information in which information is not direct from accounting systems.
• It is easier with human error, such as accidentally typing a number or deprivation of a zero.

SPREADSHEET dependence also means Health NZ to move slowly: The report is found “monthly reporting financial analysis and five days to analyze.”

Report suggests that a long distance in which health is health.

“Using a frew spreadsheet file to track and report the financial performance for a $ 28bn expenditure organization, especially if other appropriate systems are in this scene,” the report says.

It worsens: Health Minister Simeon Brown last week given a speech Which he says HNZ acts “an estimated 6,000 applications and 100 digital networks” – or almost an application for each 16 staff staff.

He also said that members of the Senior Hannz president “began only weekly in-person meetings, despite the majority of Auckland and the organization of two and a half years old.” Most work in different buildings.

However, the minister has no plans to exit excel, or heal HNZ leadership problems.

In his speech, Simeon promised to investigate “making a separate health infrastructure under New Zealand health, to conduct and provide physical and digital properties.” But no word is when the investigation is over

Reg Writers who have learned organizations that contemplate ERP as the healing for an unrealized state of legacy apps, with one chance to spend the years to spend. So good, HNZ, you can be a day like for bad old ORG running days with spreadsheets. ®