How Query Manager helped UK Power Networks streamline their payroll process

Labs_Coloured_blocks
Play video
My name is Liezel Terblanche, and I work for UK Power Networks. My role is SAP Payroll Reporting Analyst. We have about 6,200 employees we pay on a monthly basis, and then about 12,500 pensioners. We use Query Manager 4. In terms of payroll reporting, we have some pre-payroll run checks and reports we do, and then obviously a lot of reporting takes place post-payroll, and then third-party reporting. So that makes up a very big part of what we use it for. I think there are probably about fifteen types of different reports, give or take, that we run on a very regular basis, in terms of just completing the payroll process. We have done all bespoke reports. We initially used Query Manager 3. And then when I joined in 2018, the goal was that we transition the Query Manager 3 reports to Query Manager 4. So we've taken a look at the existing ones and seen whether they needed some improvement and refreshing, and then also to get them in line with GDPR; we had some reports that obviously weren't as compliant as we needed them to be. So it was just a bit of a review and a refresh, and then getting that into Query Manager 4. And then, obviously, with the idea of automating as much as we can, we have used the bespoke functionality that it offers. When a request lands in an inbox for a statement of earnings you can see everyone's a little wary. Where we're currently just using a Word document and having to type in figures and addresses manually, if we can use Document Builder, we can just automatically generate. That's another time saving. This kind of improvement will then make the process less mundane. So the work - by the time it gets to the administrators, there's very little for them to actually do. There'll always be a manual part to the process, but if we can eliminate it when necessary, that just reduces the risk so much.

 

In this video, Liezel Terblanche, SAP Payroll Reporting Analyst at UK Power Networks explains how the company uses Query Manager for their payroll processes and reporting. Query Manager with Document Builder™ is a powerful reporting solution which is certified by SAP for ‘Integration with SAP S/4HANA®’.

We have about 6,200 employees we pay on a monthly basis, and then about 12,500 pensioners. We use Query Manager 4. In terms of payroll reporting, we have some pre-payroll run checks and reports we do, and then obviously a lot of reporting takes place post-payroll, and then third-party reporting. I think there are probably about fifteen types of different reports that we run on a very regular basis. We have done all bespoke reports. We initially used Query Manager 3 and the goal was that we transition the Query Manager 3 reports to Query Manager 4. So we've taken a look at the existing ones and seen whether they needed some improvement and refreshing, and then also to get them in line with GDPR.  And then, obviously, with the idea of automating as much as we can, we have used the bespoke functionality that it offers. When a request lands in an inbox for a statement of earnings you can see everyone's a little wary. Where we're currently just using a Word document and having to type in figures and addresses manually, if we can use Document Builder, we can just automatically generate it. That's another time saving. This kind of improvement will then make the process less mundane. So by the time it gets to the administrators, there's very little for them to actually do. There'll always be a manual part to the process, but if we can eliminate it when necessary, that just reduces the risk so much.

Liezel Terblanche, UK Power Networks
testimonial-quote

Industry: Utilities

Solution: Query Manager