Pension duplication error

What is this error?

The pension duplication error is when an employee starts taking twice the deduction of a pension contribution. You will be able to spot this via the payslip ‘Reports > Pay Period > Payslips’ where you should see a duplication of a deduction on the payslip.

How to amend this

To fix this issue you will have to use SQL Management Studio. Once opened navigate to the company table and via ‘Databases > qtac2223 > Tables > dbo.tblCompany’ Then search for the company in question and make note of the IngFKCompany. From here we will need to find the employee through dbo.tblEmployee, you can narrow this search down by pressing Ctrl+2 and entering the IngFKCompany as well as the first name of the employee. Now make note of the IngPKEmployee and navigate to ‘dbo.tblEmployeePensionFund > Ctrl+2 > Filter IngPKEmployee’ you will now see two or more duplicate pension records, remove as necessary (usually the latest one on the bottom).

Now when going back to the payslip you should have resolved this issue, if the issue still stands you will be required to back process and reprocess ‘Employee > Back Process > Tick Leave Closed At Previous Period > Right click > Open & Pay > Calculate > Save’.

A little bit about us...

Qtac, a recognised payroll solutions provider in the UK, has been serving businesses for 30 years. Specializing in both payroll software and outsourced payroll services, Qtac caters to small businesses, large corporations, and payroll bureaux. Our software, recognised by HMRC, streamlines the payroll process, featuring RTI submissions, workplace pensions management, and a cloud-based portal for payslips and employee self-service. This software is supported by top-tier customer assistance, ensuring a smooth payroll experience.

Additionally, Qtac offers tailored ‘white-labelled’ outsourcing services. These services are particularly attractive to accountancy firms, as they save time, reduce stress, and mitigate payroll-related risks. By outsourcing to Qtac, companies can be confident in the knowledge that their payroll needs are being expertly managed.

Qtac's solutions are not just about functionality; they are about building long-lasting relationships with clients, offering them a combination of technology and expertise. Their commitment to adapting to client needs and providing reliable, efficient services has established Qtac as a trusted name in the payroll solutions sector in the UK. In essence, Qtac simplifies and enhances the payroll process for a diverse range of clients, ensuring compliance, efficiency, and customer satisfaction. 

Need some help?