Downloading PDF

Data warehouse cuts financial reporting time in half

Data warehouse cuts financial reporting time in half

Home » Case studies » Data warehouse cuts financial reporting time in half

We reduced the time it takes to process essential financial planning templates by 50% and established a data warehouse for financial reporting.

Background

Previously, the financial planning process at NHS Midlands and Lancashire involved individual working files for different services. To submit the planning template to NHS England and Improvement (NHSEI), the finance team was required to collate information from 40 different places and then cut this data multiple ways to complete the template. It took two full working weeks of staff time to collate and manipulate the data.

Once the detailed plan was agreed, it had to be uploaded to the ledger for reporting for the full financial year. This required going back to the individual working files and assigning codes based on top-down assumptions. The process used to take approximately 50 hours.

Action

We produced a standard template that automated the coding and categorisation of the costs to support the completion of the NHSEI template and the internal reporting requirements.

We implemented a database and invested resource in developing the reporting. The information was uploaded into a data warehouse, and this allowed it to be easily manipulated and collated to complete NHSEI reporting on time.

As all the data was in one place, it was also easier to create the journals for uploading to the ledger.

Impact

We have streamlined the process for completing the NHSEI planning templates by 50% and invested the time saved in adding value to the data rather than data collection and collation.

The process for uploading the plan to the ledger has also seen efficiencies by reducing the time needed by 75%.  This was driven by having all the data in one place which made it easier to collate, complete the template and identify and resolve discrepancies.

An added benefit of the collated data is support for other decision-making processes, which has made the finance team more responsive and allowed them to invest more time in added-value activities.

Feedback

“Investing in the data warehouse and this approach has delivered benefits in the planning process itself and further benefits on how we use this data on an ongoing basis.” 

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