Income at Risk: Why NHS Income Systems Must Evolve 

Insights from Helen Cookson, NHS Payment System and Contracts Consultant. 

I was recently asked to reflect on my time working in the income sphere within the NHS. I started my career in the equivalent of a band two position and have worked in both provider and commissioner organisations ending up in Associate Director of Finance roles.

I have lived the monthly grind of delivering contract monitoring reports and income reports for internal uses. I know that feeling of submitting flex and freeze reports with minutes to spare desperately hoping that all the data quality issues have been resolved. With the expected policy changes in NHS income, it feels like a good time to share what I have learnt from my experiences, especially the ‘what would I do differently based on what I know now’.

Why now

I have worked across many organisations and have utilised many solutions for income processing. I can clearly see how important accurate and efficient income systems are for the NHS. In an environment where it is necessary to be more efficient, improve productivity and to reduce waste, is now coupled with a necessity for high quality accurate and timely data, how a trust processes its activity and produces income reports has become even more vital.

The reintroduction of activity-based payments across some but not all lines of activity for some but not all commissioners has increased the complexity for providers in producing accurate and meaningful income reports. Income monitoring is no longer a hidden BI function; it's frontline finance with a direct impact on patient care.

The key things I now know that I wish I’d known at the start of my career: 

The greater the number of touchpoints in the data, the greater the risk of error.

The more systems, spreadsheets and touchpoints that there are between the source data and the commissioning reports being posted on to the DLP, the greater the risk of error in the reporting. In the early days, we worked across a patchwork of tools, Access databases, Excel macros, and bespoke scripts, all stitched together by well-meaning teams. But every extra step meant another place for something to go wrong. When income figures were finally reported, it was often a scramble to trace back what went wrong and where. If I’d known that this complexity could have been avoided with the utilisation of a single solution, I could have saved a lot of time and increased the credibility of our data.

Processing is Overrated: Understanding is Where the Value Lies.

Speeding up flex submissions is nice, but stopping errors before they happen is better. Much of my team's time was spent preparing data for submission, only to spend the following weeks responding to commissioner challenges. It wasn't until we started shifting focus from ‘producing’ reports to understanding them that we really started adding value. The best insights came from asking better questions about the data, like why are outpatient attendances so different to previous months or why has the average spell tariff changed so much.

Bespoke Feels Powerful - Until the Person Who Built It Leaves.

If your income process depends on one person’s spreadsheet, you don’t have a system - you have a risk. I’ve seen entire workflows grind to a halt because the one person who understood “how the model works” went on leave, or worse, left the Trust entirely. I have also seen a repeat of what is done without any understanding or adjustment when the rules change, because the person who set it up left and no-one understands why. We built tools tailored to our processes, but forgot to build in resilience. What looked like a strength, a custom setup, turned out to be a weakness. 

“The lesson? A good system is one the whole team can trust and use, not just one expert.”
Helen Cookson

NHS Payment System and Contracts Consultant

The most common challenges I have encountered with Income processes

  1. Most of the resource is spent on producing the month end reporting and then dealing with the errors in it before the next monthly cycle. This leads to sub optimal use of resource and increased commissioner challenges.

  2. The up to the wire approach to Income Monitoring, means that there is insufficient time to check the data and rectify data with coding issues, missing data and mapping errors, all of which can lead to a loss of income and a lack of trust from both internal and external stakeholders in the validity of the data produced.

  3. With all the resource focused on producing the data, there is no time to undertake added value tasks, such as an analytical review, trend analysis and discussing performance with clinical and operational colleagues to gain an understanding of the data, including supporting the services to improve the capture of data at source

  4. In situations where the income team are only able to be reactive, commissioners end up dictating what the income team are doing. This leads to teams being tied up with queries which are either without merit or could have been avoided if time had been available to understand the issue and correct it before reporting or an explanation provided to commissioner.

  5. Significant amounts of time are spent trying to reconcile datasets used for SUS, costing and income, as well as statutory reporting and operational data used by services. In many cases reconciliation is not possible due to the complex patchwork approach to the data used for the various returns and internal reporting mechanisms.
     

What does good look like

Over the years in my various roles, I was able to build an image of what good income processes look like.

The key attributes that I now look for are:

  1. An end-to-end process contained within one system.
  • A system that can take an input from a provider’s EPR or PAS and from other sources.
  • All the manipulation, grouping, applying income rules, analytical review and reporting can be undertaken within the system.
  1. Data validated as it is loaded.
  • A system that validates data as it is loaded, allowing for immediate investigation and correction as necessary. 
  1. A system that can operate commissioner specific rules.
  • LVAs reported with their actual activity but income adjusted to their block.
  • Commissioner specific rules applied to commissioners, either collectively or individually.
  • Ability to hold multiple sets of commissioner specific rules, so that each and every agreement with commissioners can be contained and operated within the one system. 
  1. Less hands-on processing time.
  • A system where much of the processing is automated.
  • This frees up time for the team to add value, such as engaging with clinical and operational teams to understand variations in activity. 
  1. Analytics produced by the system.
  • A system that automatically produces analytics that support improved data quality and understanding of the activity and income position.
  • Inclusion of analytics such as average HRG price per specialty, % of OPPROCs to attendances per specialty, items with a £0 or £1 price.
  1. A system that can hold and apply multiple data sets.
  • A system that holds the Payment rules for multiple years that can be applied to the same data set to understand the impact of rule changes.
  • The ability to apply a set of payment system rules to data from multiple years to be able to assess year on year movement without the impact of the changing payment system rules.
  1. More frequent reporting.
  • A more automated system allows for reporting beyond the single month end process.
  • This allows for changes to be made and tested before running the month end process.
  • Allows for services to have more frequent views of their activity and income position.
  • Allows for an earlier identification of data issues, and therefore more time to correct issues before external reporting
  1. A system that produces export files for DLP reporting and internal income reporting at the push of a button.
  • The ability to set up reports that fulfil the requirements of the DLP, including where necessary, specific additional fields for specific commissioners.
  • The commissioner reports can then be exported from the system and uploaded directly into the DLP.
  • The ability to design reports to meet the internal reporting requirements of the organisation, including those for financial reporting purposes as well as reports that services can use to understand their reported activity and income position.
  • Reports produced in a format that can be exported ready for use by stakeholders and/or in a format to be uploaded into the Trust’s reporting tools.
  1. Income and costing seamlessly linked.
  • A system that can utilise the same data for income and costing, allowing for easier reconciliation between the two sets of reports and greater transparency of the differences between the two.
  1. Intuitive front-end for non-technical finance users.
  • An easy-to-access front end without expensive licensing.
  • An intuitive dashboard that allows services and corporate colleagues to access information that meets their needs.

 

Questions for income teams across the NHS

If I was working with your Trust to improve your income processes, I would be keen to put the following questions to you:
  1. How do you assure yourself that we are not missing any activity?
  2. How many times do you use a separate system, spreadsheet or external database in your income processing?
  3. What do you need to be able to reduce processing time by 30%?
  4. How would you best use the freed-up time to add value to the organisation?
  5. How would you assess that the Trust’s processes compare to the ‘what does good look like’?
IMG_2657
Helen Cookson
NHS Payment System and Contracts Consultant