SQL
Transforming Finance Processes
Blackpool Teaching Hospitals NHS Foundation Trust, North West, Acute
-->
Blackpool Teaching Hospitals NHS Foundation Trust, North West, Acute
The PIE group needed to streamline, automate and standardise financial processes in order to move forward as a finance department and meet the increasing pace and demands of the wider organisation and NHS healthcare environment.
The PIE group needed to streamline, automate and standardise financial processes in order to move forward as a finance department and meet the increasing pace and demands of the wider organisation and NHS healthcare environment.
SQL automated processes for the following areas (each taking approximately 5 mins to prepare data and run):
management accounts:
income team:
All the documents and resources relating to this innovation can be found in the downloads section at the bottom of the page.
Read now“The idea of utilising SQL to automate manual repetitive processes has resulted in better value to the organisation through a quantifiable reduction to monthly processing time..”
“Excel is a very generic solution, but as identified here, using SQL allows a more targeted analysis of data.”
“Maximising the use of SQL to automate manual repetitive processes has saved this organisation approximately 60 hours of Excel time per month which can be reinvested in reviewing the outputs to facilitate a better financial understanding for the organisation.”
The Innovation Programme would like to receive applications from individuals who have an interest in appraising NHS Finance Innovations.
Apply nowIn order for the Forum to be able to allocate its resources in worthwhile areas for the benefit of NHS Finance we are crowdsourcing ideas and problems for assessment, research and development.
Share nowHave you developed an innovation that’s delivering value to your team? Don’t keep it to yourself, submit it to our Innovation Programme.
Submit nowHere are all of the documents and resources related to this innovation