Payroll Files Consolidation

Southern Health NHS Foundation Trust, South East, Integrated

The problem

We wanted to easily be able to review various payroll transactions with the ability to interrogate it by division and/or staff group which is not possible with the existing payroll interface files

The challenge

How might we consolidate various payroll files (2/3 a month) into one file that can be easily interrogated by different members of the team.

The outputs

  • A single file where all payroll transactions can be accessed and reviewed.
  • Quicker access to payroll information by division before it has interfaced into the ledger
  • A lot of time saved on compiling data for control accounts due to having pre-set pivots and the data already being refreshed in one place.

The outcomes

  • The file is used to check basic arrears payments, help populate control accounts.
  • Check what clinical excellence awards (CEAs) / overtime / bank holiday enhancements have been paid. The calendar loaded allows you to look at trends of these items.
  • It is also used to check payroll movements between months at category levels to understand the movements for day 1 reporting.
  • Management accountants can also use it to access payroll data early if they need to move staff before they see it in the ledger the following day.

The Innovation

Read the full innovation on the award recognition scheme

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

“It is quick and easy to get going with it and will have an immediate impact.”

“I think it is a nice simple innovation but that can lead to more harmony in the office with staff learning to share ideas.”

“This innovation allows for time to be spent on adding value and analysing trends and cause rather than spending the time manipulating isolated data.”

Get Involved Today


Here are all of the documents and resources related to this innovation