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.
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.
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.
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
News and views
We tackled overmedication in individuals with learning disabilities and autism by upskilling primary care pharmacists, facilitating structured medication…
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