Month-end review
and forecast tool
University Hospitals of Morecambe Bay NHS Foundation Trust, North West, Acute
-->
University Hospitals of Morecambe Bay NHS Foundation Trust, North West, Acute
The financial management team needed to streamline and automate the forecasting process to meet the faster month-end reporting deadlines and improve the quality and integrity of data. Otherwise, deadlines would be missed and earlier engagement with budget holders would not be achievable.
How might we improve the way we forecast, so that we can spend more time reviewing and influencing financial information with our senior finance colleagues and budget holders?
The outputs are:
All the documents and resources relating to this innovation can be found in the downloads section at the bottom of the page.
Read now“This innovation has had a clear and quantifiable impact on the time spent by staff.”
“Power query is a really powerful and easily accessible tool.”
“An excellent, shining example of what you can do in Excel to produce a wide variety of benefits.”
The Innovation Programme would like to receive applications from individuals who have an interest in appraising NHS Finance Innovations.
Apply nowIn order for the Forum to be able to allocate its resources in worthwhile areas for the benefit of NHS Finance we are crowdsourcing ideas and problems for assessment, research and development.
Share nowHave you developed an innovation that’s delivering value to your team? Don’t keep it to yourself, submit it to our Innovation Programme.
Submit nowHere are all of the documents and resources related to this innovation