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.
The Midlands and Lancashire Commissioning Support Unit (MLCSU) 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.
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.
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, MLCSU
News and views
Nicola Ainscough, Head of System Delivery, MLCSU The recent communication from NHSE, referencing the letter titled ‘Addressing the…
Recorded live at the Digital Healthcare Show 2023, host Andy Downton engages in a captivating conversation with Priyantha…
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
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
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
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
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
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
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
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
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