Payroll Reports that the Report Design service can't create

Summary

The types of reports that the Report Design Service can't create for Sage 50 Payroll.

Sometimes it's not possible to create certain reports in Sage 50 Payroll.

To save you from requesting a report for an area we don't cover, check the list below before you log a request.

We can't create the following reports:

We don't create or amend BACS/Bank transfer/upload reports. This is to ensure the accuracy and integrity of the BACS output file contents.

We recommend using either e-banking or Salary and Supplier Payments.

It isn't possible to show NI/PAYE/Pension at a pay element level. Sage 50 Payroll doesn't calculate this way.

We don't create or amend any audit trail or event log reports as Report Designer can't access timestamp data.

We don't create or amend any reports that require joins as there's no join editor in Sage 50 Payroll.

Unable to create or amend nominal link reports or any report requiring information from those tables.

Unable to create or amend FPS and RTI reports or any report requiring information from those tables.

Below are reports we can't create, grouped by location in the program:

Report type	What's not possible	Reason
Online payslips	Create or amend online payslips	Not part of the main program, and it doesn't use Report Designer. There's no access to edit the report files the online payslip service uses.
Analysis of Payroll Totals	Amend the Analysis of Payroll totals or create from new	The report uses the maximum number of variables for a report as standard. Adding extra variables makes the report unstable.

Report type	What's not possible	Reason
Historical payslips	Add further holiday information	The 'Accrued Holidays' values don't react to the date range like the rest of the report. Values will always be either up to the process date or for the full year.
Legislative reports, for example P32, P45, Minimum Wage check	Create or amend any type of legislative report	To ensure their accuracy and integrity, we don't edit these reports.
A report that calculates holiday pay on a 52-week period for non-weekly pay frequency	Create a 52-week report for fortnightly, monthly or four-weekly employees	Unable to calculate averages accurately and exclude the required periods for any frequency other than weekly.
Show changes to employees' pay between periods	Create reports that compare periods to see changes	Configure and use the Variance Reporting feature instead.
Monthly absence reports	Create reports to show absences per month	Absence dates go from the start of the illness, so they won't react to dates within a month.
Combined absence and historical process date values	We can't combine absence information with process date values	There's no link between absence history and process date history.

Report type	What's not possible	Reason
Statement of Employment templates	Create or amend the Statement of Employment templates	Unable to add further sections or change section heights. Limited to changing text as long as the changes fit within the existing section heights.
Changes to employee record	Create a report to show all changes ever made to employee record details	We can create a report to help to an extent with this. However, it can only compare entries in the current record with the last entries updated. The report can only compare certain variables this way.
Employee Groups	Create a report to represent existing Employee Groups within a company	Employee Groups don't have a variable that Report Designer can use.