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 Midlands and Lancashire Commissioning Support Unit (MLCSU) 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.

“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, MLCSU

View all

News and views

News

UK National GO Awards Shortlists MLCSU for Collaborative Procurement Initiative 

We are delighted to share the news that our collaborative endeavour with the North Midlands and Black Country…

News

Building capable communities for learning disability and epilepsy

Join us for our webinar on building capable communities to tackle premature avoidable death in people with a…

News

MLCSU to exhibit at NHS ConfedExpo 2023

We are pleased to announce that we will be exhibiting at the upcoming NHS ConfedExpo, the flagship health…

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

CHC and funded care

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 CHC and funded care
CHC and funded care

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

Accessibility Tools