Downloading PDF

Better efficiency in uploading the financial forecast

Better efficiency in uploading the financial forecast

Home » Case studies » Better efficiency in uploading the financial forecast

We halved the time it takes to load the financial forecast into the ledger and reduced the risk of errors.

Background
NHS Midlands and Lancashire used a manual process to load the financial forecast into the ledger by changing each subjective code line by line. This process was extremely time consuming for the following reasons:

  • It was necessary to run multiple reports from the ledger to extract the data to create the forecast journals
  • Checks had to be made to ensure the journals had achieved the desired position and we could make corrections if necessary
  • The risk of errors was high due to the reports having opposite signs to the journal entry requirements.

Action
The bulk upload template is Web Applications Desktop Integrator (Web ADI) and allows for multiple lines (or cost centres) to be amended in one go.

The Forecast Out Turn uploader tool ensures that there are no errors prior to the upload as there are control checks embedded within. The tool also populates the income the correct way so that when a report is downloaded, this is captured and mirrored in the accurate way.

The tool was initially tested, and a procedure note produced so the knowledge could be shared across the team.  Based on experience it was identified this was only effective if you were changing multiple lines (or multiple costs centres) as downloading the Web ADI can take some time.

Impact

Within the first month the tool was implemented there was a 50% efficiency achieved despite the learning curve of implementing.

This approach has also been embedded into month-end processes and is providing ongoing benefits.

“This review of the process allowed us to use technology available to quickly streamline and improve the process.  Driving efficiency allows us to invest time in adding value.”
Lyn Tallentire, Deputy Finance Director, NHS Midlands and Lancashire

View all

News and views

News

NHS Midlands and Lancashire Gender Pay Gap Report 2023

NHS Midlands and Lancashire has published its Gender Pay Gap Report for 2023. Download the report here.

News

New Podcast: Unravelling unconscious bias in healthcare

Join host Richard Caddy for another thought-provoking session in our latest podcast with our Inclusion Unit. Tune in…

Blog

In-depth analysis and insight: A cancer pathway review within Staffordshire and Stoke on Trent…

As referenced in the national NHS priorities and operational planning guidance for 2023/24, the significance of early cancer…

View all

How we can help health systems

Developing health systems

Acting as an independent and trusted partner within the system to facilitate working across stakeholders and integrate elements of the provider system…

Learn more about Developing health systems
Developing health systems

Workforce resilience and transformation

Supporting systems to build a sustainable and integrated workforce, transforming systems, organisations and the workforce experience to improve resilience.

Learn more about Workforce resilience and transformation
Workforce resilience and transformation

Communications and engagement

Supporting ICSs with approaches to design and deliver effective communication, engagement and behavioural insights as a key enabler for system change and…

Learn more about Communications and engagement
Communications and engagement

Digitally enabled transformation and IT

Digitising care and partnering with systems for the transformation of digitally enabled service delivery (and other supporting processes) across vision, planning and…

Learn more about Digitally enabled transformation and IT
Digitally enabled transformation and IT

PHM analytics and decision support

Applying intelligence-led understanding of the health of the population to support the redesign of care and improve patient and financial outcomes across…

Learn more about PHM analytics and decision support
PHM analytics and decision support

Place and primary care transformation

Supporting providers to work together at a place and neighbourhood level to manage common resources, integrate community teams, improve health and reduce…

Learn more about Place and primary care transformation
Place and primary care transformation

Clinical redesign and provider collaboration

Redesigning how health and care works across England - placing people at the centre of their own health and care and utilising…

Learn more about Clinical redesign and provider collaboration
Clinical redesign and provider collaboration

Personalised healthcare commissioning services

Providing end-to-end funded care services, including patients as active partners in identifying their healthcare needs and then commissioning care to meet these.…

Learn more about Personalised healthcare commissioning services
Personalised healthcare commissioning services

Business enabling services

Delivering a wide range of support functions through transactional services, business partnering and transformation that drives efficiencies and releases value and time…

Learn more about Business enabling services
Business enabling services
MLCSU

Accessibility Tools