PeopleSoft Enterprise Global Payroll for the United Kingdom 9.1 PeopleBook

Running Payroll Reports

This chapter lists common elements used in this chapter and discusses how to:

Run statutory reports.
Run non-statutory reports.
Set up and run report profiles.

Note. This chapter does not describe all the statutory and non-statutory reports delivered with Global Payroll for the U.K. Refer to other chapters in this PeopleBook for information about banking reports, payslips, and the P45 report.

See Also

Running the Banking Processes

Generating and Viewing Payslips

Generating P45 Reports

Common Elements Used in This Chapter

Tax Year Begins In	(Required) Enter the tax year that you want to process.
Parameters	Select one of these values: Calendar Run ID: To run the report for a specific calendar run ID. When you select this parameter, the Calendar Group ID and Department field are available for entry. Pay Entity: To run the report for a specific pay entity. When you select this parameter, the Pay Entity and EmplID field are available for entry. Pay Group: To run the report for a specific pay group. Select the pay group in the Pay Group field.
All Periods	Select if you want the report to include results for the tax year that you specify. If you select All Periods but do not specify a frequency ID, the system displays all results for that tax year.
Frequency	Select the frequency ID that you require: A (annual) B (biweekly) F (four weekly) M (monthly) Q (quarterly) W (weekly) Note. If you select All Periods and also select the frequency ID that you require, the system displays the results for that frequency. For example, if you select All Periods and enter the Frequency ID M, the system displays all monthly payroll results for that tax year.
Tax Period	Enter the tax period whose results the report should display. For example, if you enter a frequency ID of Q and enter the value 4 in the Tax Period field, the report displays the payroll results of the fourth quarter of the tax year that you specify. This field is available for entry only if you enter a frequency ID and move out of the field.

Running Statutory Reports

This section discusses how to:

Run the P11, P14, P60, P32, and P35 reports.
Run the P46(car) report.

Pages Used to Run Statutory Reports

Page Name	Definition Name	Navigation	Usage
Varies by report	GPGB_GPSQR_PNL	You can access this page through multiple navigation paths. This lists shows some of the possible paths. Global Payroll & Absence Mgmt, Absence and Payroll Processing, Reports, P11-Part 1 GBR Global Payroll & Absence Mgmt, Absence and Payroll Processing, Reports, P14/P60 GBR Global Payroll & Absence Mgmt, Absence and Payroll Processing, Reports, P32 GBR Global Payroll & Absence Mgmt, Absence and Payroll Processing, Reports, P35 GBR	Use this page to run these reports: P11 - Part 1 (GPGBP11A), Part 2 (GPGBP11B), and Part 3 (GPGBP11C) reports. These list the National Insurance contributions section, PAYE income tax and tax credits section of the P11 form, and the tax credits section of the P11 deductions working sheet. P14/P60 report (GPGBP14). The P14 summarizes at the end of the year each employee for whom any tax and National Insurance contributions were payable. The P60 is the Employee's Certificate of Pay that provides income tax and national insurance information. P32 report (GPGBP32). Employer's payment record that lists required details each time that an employer makes a payment. P35 report (GPGBP35). Lists at the end of the year all PAYE tax and National Insurance contributions, as well as the employer's annual return.
P46(Car) GBR	GPGB_RC_P46C	Global Payroll & Absence Mgmt, Absence and Payroll Processing, Reports, P46(Car) GBR, P46(Car) GBR	Run the P46(Car) report (GPGBP46C). This report is submitted to HM Revenue and Customs (HMRC) every quarter for employees with a company car. The report extracts information from both PeopleSoft Enterprise Human Resources and Global Payroll for the U.K. tables: Company car data in Administer Company Cars. Employee and director information from the Global Payroll for the U.K. tax table. Employer information from the Pay Entity Details table.

Page Name

Definition Name

Navigation

Usage

Varies by report

GPGB_GPSQR_PNL

You can access this page through multiple navigation paths. This lists shows some of the possible paths.

Global Payroll & Absence Mgmt, Absence and Payroll Processing, Reports, P11-Part 1 GBR
Global Payroll & Absence Mgmt, Absence and Payroll Processing, Reports, P14/P60 GBR
Global Payroll & Absence Mgmt, Absence and Payroll Processing, Reports, P32 GBR
Global Payroll & Absence Mgmt, Absence and Payroll Processing, Reports, P35 GBR

Use this page to run these reports:

P11 - Part 1 (GPGBP11A), Part 2 (GPGBP11B), and Part 3 (GPGBP11C) reports.

These list the National Insurance contributions section, PAYE income tax and tax credits section of the P11 form, and the tax credits section of the P11 deductions working sheet.
P14/P60 report (GPGBP14).

The P14 summarizes at the end of the year each employee for whom any tax and National Insurance contributions were payable. The P60 is the Employee's Certificate of Pay that provides income tax and national insurance information.
P32 report (GPGBP32).

Employer's payment record that lists required details each time that an employer makes a payment.
P35 report (GPGBP35).

Lists at the end of the year all PAYE tax and National Insurance contributions, as well as the employer's annual return.

P46(Car) GBR

GPGB_RC_P46C

Global Payroll & Absence Mgmt, Absence and Payroll Processing, Reports, P46(Car) GBR, P46(Car) GBR

Run the P46(Car) report (GPGBP46C). This report is submitted to HM Revenue and Customs (HMRC) every quarter for employees with a company car. The report extracts information from both PeopleSoft Enterprise Human Resources and Global Payroll for the U.K. tables:

Company car data in Administer Company Cars.
Employee and director information from the Global Payroll for the U.K. tax table.
Employer information from the Pay Entity Details table.

Running the P11, P14, P60, P32, and P35 Reports

Access the P14/P60 page (Global Payroll & Absence Mgmt, Absence and Payroll Processing, Reports, P11-Part 1 GBR) or (Global Payroll & Absence Mgmt, Absence and Payroll Processing, Reports, P14/P60 GBR) or (Global Payroll & Absence Mgmt, Absence and Payroll Processing, Reports, P32 GBR) or (Global Payroll & Absence Mgmt, Absence and Payroll Processing, Reports, P35 GBR).

Note. This page is used to run the P11, P14, P60, P32, or P35 reports. The page name varies depending on the report option you selected.

P60

Select this check box to run the P60 report.

Running the P46(Car) Report

Access the P46(Car) GBR page (Global Payroll & Absence Mgmt, Absence and Payroll Processing, Reports, P46(Car) GBR, P46(Car) GBR).

Pay Entity

Select the pay entity for which you want to run the report. The system generates a report for each employee in the pay entity who has a company car or has withdrawn from the company car scheme during the quarter.

Note. Make sure that you complete the Pay Entity Details page for the pay entity. The P46(Car) report uses the employer information from the Pay Entity Details page.

Quarter Start/End Date

Enter the start and end date for the quarter.

Running Non-Statutory Reports

This section discusses how to:

Run the Validation Exception reports.
Run the Element Summary reports.
Run the End Of Year Pre Validation Report.
Run the High/Low Earners report.

Pages Used to Run the Non-Statutory Reports

Page Name	Definition Name	Navigation	Usage
Validation Exception GBR	GPGB_RNCTL_VE	Global Payroll & Absence Mgmt, Absence and Payroll Processing, Reports, Validation Exception GBR, Validation Exception GBR	Run these reports: Validation Exception (payroll) (GPGBPVE). Lists results of data validation checks for general employees. Validation Exception (starters and leavers) (GPGBSVE). Lists results of data validation checks for starters and leavers. These reports can be run before or after a payroll processing, depending on the information you want to validate. Full validation is only possible when payroll has been processed.
Element Summary Report GBR	GPGB_RNCTL_ES	Global Payroll & Absence Mgmt, Absence and Payroll Processing, Reports, Element Summary Report GBR, Element Summary Report GBR	Run these reports that summarizes total earnings and deductions for a group of payees: Element Summary (period) (GPGBEPTD). Element Summary (year to date) (GPGBEYTD). The elements are grouped by user-defined list sets.
EOYR Pre Validation GBR	GPGB_RNCTL_EOY	Global Payroll & Absence Mgmt, Year-End Processing, EOYR Pre Validation GBR, EOYR Pre Validation GBR	Run the EOY Pre Validation report (GPGBEOY) to identify data that does not meet the requirements of the HM Revenue and Customs validation standards. The report checks payee and pay entity data against the HMRC standards and lists those payees and pay entities that have missing or incorrect data. This includes payees with invalid NINO prefixes, and payees and pay entities with ECON or SCON numbers in the wrong format. There is also an option to check for invalid characters in the payee or pay entity name and address fields. Use this report to identify invalid data before you submit end of year returns. However, you can also run this report at any time during the year to check for invalid data.
High/Low Earners GBR	GPGB_GPSQR_PNL3	Global Payroll & Absence Mgmt, Absence and Payroll Processing, Reports, High/Low Earners GBR, High/Low Earners GBR	Run the High/Low Earners report (GPGBHLE). This report evaluates earnings based on an element that you select. For example, you can use this report to display all employees who earned more than 2,000 GBP as basic pay for a specific period, or to display those employees who received a tax refund during a specific period.
Gross To Net Reports	GPGB_GPSQR_PNL	Global Payroll & Absence Mgmt, Absence and Payroll Processing, Reports, Gross To Net GBR, Gross To Net Reports	Run the Gross to Net report (GPGBGTNA). Use this report to reconcile your payroll. Run at any time during the tax year.

See Also

Setting Up and Running Report Profiles

Running the Validation Exception Reports

Access the Validation Exception GBR page (Global Payroll & Absence Mgmt, Absence and Payroll Processing, Reports, Validation Exception GBR, Validation Exception GBR).

Calendar Group ID, Pay Entity, Pay Group, Company

Use these fields to define the group of employees to include in the report.

Running the Element Summary Reports

Access the Element Summary Report GBR page (Global Payroll & Absence Mgmt, Absence and Payroll Processing, Reports, Element Summary Report GBR, Element Summary Report GBR).

List Set

Select the list set you want to use for the report. To define list sets, use the Define List Set page (Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Elements, Define List Set). PeopleSoft delivers two list sets for the U.K., ELEMENT_SUMMARY and ELEMENT_LIST.

Modify the delivered list sets to include the elements that you want included in the report.

From the Process Scheduler Request page, you can select the period report or the year to date report.

See Also

Setting Up List Sets

Running the End Of Year Pre Validation Report

Access the EOYR Pre Validation GBR page (Global Payroll & Absence Mgmt, Year-End Processing, EOYR Pre Validation GBR, EOYR Pre Validation GBR).

Tax Year

Enter the year in which the tax year starts.

When the report runs, it checks payee data for those payees who are in the selected pay entity and who will be included in the end of year return for the tax year you specify.

Character Set

Select this check box if you want the report to check for invalid characters, including the payee and pay entity name and address fields. If this check box is selected, the report lists the data fields that contain invalid characters.

If you don't select the check box, the report does not check for invalid characters.

Running the High/Low Earners Report

Access the High/Low Earners GBR page (Global Payroll & Absence Mgmt, Absence and Payroll Processing, Reports, High/Low Earners GBR, High/Low Earners GBR).

PIN Code (pay item name code)

Select the element that you want to evaluate against the statement.

Operation

Select the operator that you want to use in the calculation: <, <=, =, >, or >=.

Condition Amount

Enter the amount against which you want to evaluate the element.

Setting Up and Running Report Profiles

This section provides an overview of report profiles and discusses how to create report profiles.

Understanding Report Profiles

The Profile Report is provided as a mechanism for creating simple listing reports of selected elements. For example, you can use profile reporting to create a payment or deduction listings.

Before you can run the Profile report, you must first set up a report profile that lists the elements to include in the report. Use the Report Profile GBR component (GPGB_PROFILE_PNLG) to define report profiles.

Global Payroll core provides generic reporting that enables you to define your own reports of basic payroll results.

See Also

Setting Up and Running Generic Reports

Pages Used to Set Up and Run Report Profiles

Page Name	Definition Name	Navigation	Usage
Report Profile GBR	GPGB_PROFILE_PNL	Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Reports, Report Profile GBR, Report Profile GBR	Create a profile for a user. This profile is then used in the Profile Report, which displays exactly the information that you specified.
Profile Report GBR	GPGB_GPSQR_PNL2	Global Payroll & Absence Mgmt, Absence and Payroll Processing, Reports, Profile Report GBR, Profile Report GBR	Run the Profile report (GPGBRPRF). This report displays exactly the information that you require based on report profiles that you create. Note. You must set up Report Profiles before you can run this report.

Page Name

Definition Name

Navigation

Usage

Report Profile GBR

GPGB_PROFILE_PNL

Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Reports, Report Profile GBR, Report Profile GBR

Create a profile for a user. This profile is then used in the Profile Report, which displays exactly the information that you specified.

Profile Report GBR

GPGB_GPSQR_PNL2

Global Payroll & Absence Mgmt, Absence and Payroll Processing, Reports, Profile Report GBR, Profile Report GBR

Run the Profile report (GPGBRPRF). This report displays exactly the information that you require based on report profiles that you create.

Note. You must set up Report Profiles before you can run this report.

Creating Report Profiles

Access the Report Profile GBR page (Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Reports, Report Profile GBR, Report Profile GBR).

Element Order

Enter the order in which you want the elements to appear in the Profile Report.

Entry Type

Select the type of element that you want to display on the Profile Report.

Element Name

Select the element that you want to appear on the Profile Report. The elements that are available are those belonging to the entry type that you select.

PIN Code (pay item name code)	Select the element that you want to evaluate against the statement.
Operation	Select the operator that you want to use in the calculation: <, <=, =, >, or >=.
Condition Amount	Enter the amount against which you want to evaluate the element.

Element Order	Enter the order in which you want the elements to appear in the Profile Report.
Entry Type	Select the type of element that you want to display on the Profile Report.
Element Name	Select the element that you want to appear on the Profile Report. The elements that are available are those belonging to the entry type that you select.