ESR Payroll Consolidation

and Detailed Analysis

Airedale NHS Foundation Trust, North East and Yorkshire, Acute

The problem

Various teams within the finance department needed to easily access and manipulate ESR payroll data in various ways because otherwise reporting/ queries may be time consuming and sometimes inconsistent.

The challenge

How might we provide timely and accurate ESR payroll information without having to repeatedly download files so that time is saved and data manipulation is minimised?

The outputs

The tangible products that came from our innovation were:

additional audit assurance that NIC/ pensions are correct
being able to reconcile the ESR output to what is in the ledger. The ESR output has much more data than ledger information so more detailed analysis can be carried out
ability to reconcile the gross to net reports and obtain further information behind the element names
ability to obtain ad-hoc data quickly, for example Freedom of Information Act requests, overtime information etc.
ability to look at directorate or speciality level using the hierarchy and ability to look at staff groups using the subjective hierarchy
20 months of payslip information at a glance.

The outcomes

The benefits of the innovation are that staff in the department no longer need to look within a monthly pdf for payslips, nor do they have to login to ESR to download data which could often be time consuming. This solution gives the department extensive information within one file stored locally.

The Innovation

Read the full innovation on ESR payroll consolidation and detailed analysis

All the documents and resources relating to this innovation can be found in the downloads section at the bottom of the page.

Read now

What the peer-reviewers said

“This could be used elsewhere as a template and example to integrate ESR and the general ledger.”

“Pulling data together in one place using tools accessible to anyone to produce outcomes usable by many is brilliant.”

“Addresses one of the fundamental challenges in both financial management and costing. ESR is a key feed but is rarely easily reconcilable to ledger/ financial management data and often derided for benchmarking. Being able to reconcile quickly with common tools rather than bespoke software is hugely important.”

Get Involved Today

Become a peer reviewer

The Innovation Programme would like to receive applications from individuals who have an interest in appraising NHS Finance Innovations.

Apply now

Submit problems or ideas

In 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 now