Running Payroll Reports

This chapter discusses how to:

Click to jump to top of pageClick to jump to parent topicRunning Statutory Reports

This section discusses how to run the P46(car) report.

Click to jump to top of pageClick to jump to parent topicPages Used to Run Statutory Reports

Page Name

Object 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 summarises at the end of the year each employee for whom any tax and National Insurance contributions were payable. The P60 is the Tax and National Insurance certificate, or rather the Employee’s Certificate of Pay.

  • 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)

GPGB_RC_P46C

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

Run the P46(Car) report (GPGBP46C). This report is submitted to the Inland Revenue 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.

See Also

(GBR) Tracking Company Cars and Vehicle Incidents

Click to jump to top of pageClick to jump to parent topicRunning the P46(Car) Report

Access the P46(Car) page.

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.

Click to jump to top of pageClick to jump to parent topicRunning Non-Statutory Reports

This section lists common elements and discusses how to run the High/Low Earners report.

Click to jump to top of pageClick to jump to parent topicCommon Elements Used in This Section

Tax Year Begins In

(Required) Enter the tax year that you want to process.

Calendar Run ID

Select if you want to run the report for a specific calendar run ID.

Pay Entity

Select if you want to run the report for a specific pay entity.

Pay Group

Select if you want to run the report for a specific paygroup.

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 (fourweekly)

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.

Click to jump to top of pageClick to jump to parent topicPages Used to Run the Non-Statutory Reports

Page Name

Object Name

Navigation

Usage

Element Summary

GPGB_RNCTL_ES

Global Payroll & Absence Mgmt, Absence and Payroll Processing, Reports, Element Summary Report GBR

Run these reports that summarise 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.

Validations GBR

GPGB_RNCTL_VE

Global Payroll & Absence Mgmt, Absence and Payroll Processing, Reports, Validation Exception Report 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.

High/Low Earners

GPGB_GPSQR_PNL3

Global Payroll & Absence Mgmt, Absence and Payroll Processing, Reports, High/Low Earners GBR, High/Low Earners

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

Click to jump to top of pageClick to jump to parent topicRunning the Element Summary Reports

Access the Element Summary page.

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

Click to jump to top of pageClick to jump to parent topicRunning the High/Low Earners Report

Access the High/Low Earners page.

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.

Click to jump to top of pageClick to jump to parent topicSetting Up and Running Report Profiles

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

Click to jump to top of pageClick to jump to parent topicUnderstanding 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.

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

Click to jump to top of pageClick to jump to parent topicPage Used to Set Up and Run Report Profiles

Page Name

Object Name

Navigation

Usage

Report Profile

GPGB_PROFILE_PNL

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

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

GPGB_GPSQR_PNL2

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

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.

Click to jump to top of pageClick to jump to parent topicCreating Report Profiles

Access the Report Profile page.

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.