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.

Feedback

“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

For more information

For more information and to learn how we can help your organisation, please contact us.

View all

News and views

News

NHS Midlands and Lancashire’s Digital Data and Technology Directorate Awarded “Towards Excellence in Digital…

We are excited to share that our Digital Data and Technology (DDaT) directorate has been formally presented with…

News

New Podcast: Revolutionising patient engagement and care with personalised healthcare videos

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

News

Enhancing our expertise in Workforce Planning to meet growing needs

NHS Midlands and Lancashire (ML) are excited to announce that we’ve secured five places for members of our…

View all

How we can help health systems

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

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

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

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

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

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

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

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
MLCSU

Accessibility Tools