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.