Health to kill 'over-reliance' on Excel

 

Hunts integrated budget system.

The Department of Health and Ageing (DoHA) has tendered for an integrated budget and forecasting system to kill its reliance on manual systems and Excel spreadsheets.

The department has an SAP ECC 6.0 financial management information system that takes manual inputs from a variety of spreadsheets and proprietary systems.

From SAP, the financial data is outputted to a complex array of systems for external reporting and other finance requirements, including a proprietary external budget management system, NetWeaver Business Warehouse 7.0 

The department described its "over-reliance" on Excel for budgeting and forecasting as a "critical risk factor" in a request for tender this week.

"There is currently an over-reliance on division-specific Excel spreadsheets that are used to manage significant levels of funding provided by Government," it said.

"The Department does not have an integrated budget and forecasting system within their existing systems suite and hence has had to resort to Excel workbooks as an interim work-around in order to record and report budget and forecasting information. 

"It is envisaged that an automated forecasting tool would improve the management of one of the department’s key business requirements."

That requirement is for DoHA's chief financial officer to "monitor financial performance, ensure accurate budgets and forecasts for prospective business activities, implement effective financial controls and assist the Secretary in the discharge of the Department’s accountability for prudent financial management."

DoHA wants a budget management system that will automate several manual processes that are required to ensure timely and relevant information is available to support a monthly CFO Report.

The system should have effective mechanisms for establishing, monitoring and maintaining multiple user defined budgets and reporting commitment and expenditure against any budget.

It needs to be integrated with SAP for better “phasing”, forecasting and capital funding management, DoHA said.

It also needs to user friendly - easy to query data and to produce standard and ad hoc reports within a shared service support model.

Tenders close on May 16.

Copyright © iTnews.com.au . All rights reserved.


Health to kill 'over-reliance' on Excel
Piles of coins over chart with stuttering red line.
 
 
 
Top Stories
Empty terminals and mountains of data
Qantas CIO Luc Hennekens says no-one is safe from digital disruption.
 
BoQ takes $10m hit on Salesforce CRM
Regulatory hurdles end cloud pilot.
 
Toll Group to go Google
Poaches Woolworths project manager.
 
 
Piles of coins over chart with stuttering red line.
Sign up to receive iTnews email bulletins
   FOLLOW US...
Latest Comments
Polls
Who do you trust most to protect your private data?







   |   View results
Your bank
  35%
 
Your insurance company
  5%
 
A technology company (Google, Facebook et al)
  9%
 
Your telco, ISP or utility
  8%
 
A retailer (Coles, Woolworths et al)
  4%
 
A Federal Government agency (ATO, Centrelink etc)
  18%
 
An Australian law enforcement agency (AFP, ASIO et al)
  15%
 
A State Government agency (Health dept, etc)
  7%
TOTAL VOTES: 3977

Vote
Do you support the abolition of the Office of the Information Commissioner?

   |   View results
I support shutting down the OAIC.
  27%
 
I DON'T support shutting the OAIC.
  73%
TOTAL VOTES: 1358

Vote