PeopleSoft Enterprise Payroll for North America 9.1 PeopleBook

Reporting Payroll

This chapter discusses how to:

Use common Payroll for North America report run control pages.
Prepare annual payroll reports.
Prepare quarterly payroll reports.
Prepare pay period tax reports.

Note. Details of other reports that support specific payroll tasks or business processes are documented throughout the chapters of this PeopleBook. Year-end tax reports are documented in the Year End Processing U.S., Puerto Rico, and U.S. Territories guide. The Year End Processing U.S., Puerto Rico, and U.S. Territories guide is updated each year and is included in the year end tax update delivered in the November time frame. The reports appendix provides a complete list of reports documented in this PeopleBook.

Using Common Payroll for North America Report Run Control Pages

This section discusses how to:

Use the PRCSRUNCNTL and PRCSRUNCNTRL pages.
Use the RUNCTL_RPT_RUNID page.
Use the RUNCTL_FRMTHRU_PAY page.
Use the RUNCTL_PAYINIT and RUNCTL_PAYINIT2 pages.

Common Run Control Pages

Page Name	Definition Name	Navigation	Usage
Varies	PRCSRUNCNTL	Varies	Run processes and reports.
Varies	PRCSRUNCNTRL	Varies	Run processes and reports.
Varies	RUNCTL_RPT_RUNID	Varies	Run processes and reports.
Varies	RUNCTL_FRMTHRU_PAY	Varies	Run processes and reports.
Varies	RUNCTL_PAYINIT	Varies	Run processes and reports.
Varies	RUNCTL_PAYINIT2	Varies	Run processes and reports.

Using the PRCSRUNCNTL and PRCSRUNCNTRL Pages

Access the PRCSRUNCNTL or PRCSRUNCNTRL page.

These pages have only the Run Control ID field. Select this value when you access the page.

Using the RUNCTL_RPT_RUNID Page

Access the RUNCTL_RPT_RUNID page.

Select a pay run ID.

Using the RUNCTL_FRMTHRU_PAY Page

Access the RUNCTL_FRMTHRU_PAY page.

Enter the from and thru period that you want to process or report.

Using the RUNCTL_PAYINIT and RUNCTL_PAYINIT2 Pages

Access the RUNCTL_PAYINIT page.

Select the run control ID value when you access the page.

On Cycle Run	Enter the pay run ID, if applicable. The payroll process uses the pay run ID, which is an identifier that is associated with each pay period. This is normally the on-cycle process. The pay run ID enables the system to assign a unique ID to each pay calendar entry, so that payroll for more than one pay group can be run together.
Off Cycle Pay Calendar	If this request involves an off-cycle pay calendar, enter the company, pay group, and pay end date (pay period end date). When you do so, the Process fields become available and you can enter the page number range of the paysheet.
Payroll Cycle	Designate whether this run cycle is on-cycle, off-cycle, or both.

Preparing Annual Payroll Reports

Year end processing is documented extensively in the Year End Processing guide, which is updated and issued every year during the November time frame in a tax update.

This section lists the pages used to print annual payroll reports that can be run throughout the year to prepare for the year end processing.

Pages Used to Print Annual Payroll Reports

Page Name	Definition Name	Navigation	Usage
Error Listing Report	PRCSRUNCNTRL	Payroll for North America, U.S. Annual Processing, Audit and Error Reports, Error Listing, Error Listing Report	Generate the TAX900 report that lists employees who have negative tax balances or reportable wage amounts that would cause overflow in fields when the system writes W-2 data to magnetic media. It also checks for other error conditions. Normally, you run this report at year-end, but you can run it at other times to verify social security numbers or to check for negative tax balances and other error conditions.
FUTA Wage Reconciliation Rpt (Federal Unemployment Tax Act wage reconciliation report)	PRCSRUNCNTL	Payroll for North America, U.S. Annual Processing, Year-End/New Year Preparation, FUTA Wage Reconciliation Rpt, FUTA Wage Reconciliation Rpt	Generate the TAX940 report that provides federal unemployment tax wage reconciliation. You normally run this at year-end, but you can run it at other times to verify data.

Preparing Quarterly Payroll Reports

This section lists the pages used to print quarterly payroll reports.

Pages Used to Print Quarterly Payroll Reports

Page Name	Definition Name	Navigation	Usage
Multiple Worksite Report	RUNCTL_QTR_YR_PAY	Payroll for North America, U.S. Quarterly Processing, Quarterly Reports, Multiple Worksite, Multiple Worksite Report	See PeopleSoft Enterprise Payroll for North America Reports.
Employee Count Report	RUNCTL_TAX004ST	Payroll for North America, U.S. Quarterly Processing, Quarterly Reports, Employee Count, Employee Count Report	See PeopleSoft Enterprise Payroll for North America Reports.
Federal Tax Summary Report	PRCSRUNCNTRL	Payroll for North America, U.S. Quarterly Processing, Quarterly Reports, Federal Tax Summary, Federal Tax Summary Report	See PeopleSoft Enterprise Payroll for North America Reports.
Local Tax Summary Report	PRCSRUNCNTRL	Payroll for North America, U.S. Quarterly Processing, Quarterly Reports, Local Tax Summary, Local Tax Summary Report	See PeopleSoft Enterprise Payroll for North America Reports.
State Tax Summary Report	PRCSRUNCNTRL	Payroll for North America, U.S. Quarterly Processing, Quarterly Reports, State Tax Summary, State Tax Summary Report	See PeopleSoft Enterprise Payroll for North America Reports.
Tax Balance Audit Report	RUNCTL_QTR_YR_PAY	Payroll for North America, U.S. Quarterly Processing, Quarterly Reports, Tax Balance Audit, Tax Balance Audit Report	See PeopleSoft Enterprise Payroll for North America Reports.
State Unemployment Tax Report	RUNCTL_TAX017	Payroll for North America, U.S. Quarterly Processing, Quarterly Reports, State Unemployment Tax, State Unemployment Tax Report	See PeopleSoft Enterprise Payroll for North America Reports.
Form 1042 Audit	RUNCTL_TAX030	Payroll for North America, Pay Period Tax Reports USA, Form 1042 Audit, Form 1042 Audit	See PeopleSoft Enterprise Payroll for North America Reports.
Create Qtrly Wage File (create quarterly wage file)	RUNCTL_TAX810XX	Payroll for North America, U.S. Quarterly Processing, State Quarterly Wage Reporting, Create Qtrly Wage File AK-ID Payroll for North America, U.S. Quarterly Processing, State Quarterly Wage Reporting, Create Qtrly Wage File IL-NC Payroll for North America, U.S. Quarterly Processing, State Quarterly Wage Reporting, Create Qtrly Wage File ND-RI Payroll for North America, U.S. Quarterly Processing, State Quarterly Wage Reporting, Create Qtrly Wage File SD-WY	See PeopleSoft Enterprise Payroll for North America Reports.

Preparing Pay Period Reports

This section provides an overview of the Payroll Summary report output and discusses how to:

Generate the Payroll Summary report.
(USF) Generate the Pennsylvania (PA) Tax Summary - State report.
(CAN) Produce a Health Insurance Premium report.
(CAN) Run the Update Source Deductions process.

Note. Periodic payroll reports can be printed at any time. You may want to print many of these reports after running the payroll for each pay period.

Understanding the Payroll Summary Report Output

Following is a detailed summary of the output of the Payroll Summary report.

Select the Summary by Selection option and populate the Pay Run ID field to create an overall summary of companies and pay end dates in the RUNID. This report is identified as a Summary report in the heading.

If the pay run ID has only one company and only one pay end date, then the company, pay period end date, and pay run ID appear in the report.

If the same pay run ID is associated with multiple companies with the same pay end date, then the pay period end date and pay run ID appear in the report. The company does not appear in the report, and the field is blank.

If the same pay run ID is associated with multiple companies that do not share the same pay end date, then only the pay run ID appears in the report. The Company and Pay End Date fields are blank.

Select the Summary by Selection option and populate the Company, Pay Group, and Pay End Date fields to create an overall summary of companies and pay end dates for this selection. This report is identified as a Summary report in the heading.

The company and pay period end date appear in the report. The Pay Run ID field contains an asterisk (*).

Select the Detail Report option and populate the Pay Run ID field to create a detail report for each company and pay end date in the run ID. This report is identified as a Detail report in the heading.

If the pay run ID is for a single company, the company, pay period end date, and pay run ID appear in the report. A Summary report is not generated.

If the pay run ID is associated with multiple companies with the same pay period end date, the system creates a Detail report for each company and pay end date in the pay run ID. This report is identified as a Detail report in the heading. In the Detail report, the company, pay period end date, and pay run ID appear. A summary of all entries in the RUNID follows with the heading of Summary Report. In the Summary report, only the pay run ID appears.

If the pay run ID is associated with multiple companies with different pay period end dates, the system creates a Detail report for each company and pay end date in the pay run ID. This report is identified as a Detail report in the heading. In the Detail report, the company, pay period end date, and pay run ID are populated. A summary of all entries in the RUNID follows with the heading of Summary Report. In the Summary report, only the pay run ID appears.

Select Detail Report and populate the Company, Pay Group, and Pay End Date fields to create a Detail report for each company, pay group, and pay end date that you selected.

The system creates a Detail report for each company and pay end date in the pay run ID. This report is identified as a Detail report in the heading. In the Detail report, the company and pay period end date appear. The Pay Run ID field contains an asterisk (*) because the report does not know the pay run ID. In this case, a Summary report is not generated.

Pages Used to Print Pay Period Reports

Page Name	Definition Name	Navigation	Usage
Tax Submission Summary Report	RUNCTL_PAYINIT	Payroll for North America, Regulatory Reports CAN, Tax Submission Summary, Tax Submission Summary Report	Generate TAX003CN that summarizes tax submission data, sorted by payroll account number.
Deduction Register	RUNCTL_PAYINIT2	Payroll for North America, Payroll Processing USA, Pay Period Reports, Deduction Register, Deduction Register Payroll for North America, Payroll Processing USF, Pay Period Reports, Deduction Register, Deduction Register	See PeopleSoft Enterprise Payroll for North America Reports.
Deduction Register	RUNCTL_PAYINIT	Payroll for North America, Payroll Processing CAN, Pay Period Reports, Deduction Register, Deduction Register	See PeopleSoft Enterprise Payroll for North America Reports.
Payroll Register	RUNCTL_PAYINIT2	Payroll for North America, Payroll Processing USA, Pay Period Reports, Payroll Register, Payroll Register Payroll for North America, Payroll Processing USF, Pay Period Reports, Payroll Register, Payroll Register	See PeopleSoft Enterprise Payroll for North America Reports.
Payroll Register	RUNCTL_PAYINIT	Payroll for North America, Payroll Processing CAN, Pay Period Reports, Payroll Register, Payroll Register	Produces a report of pay cheque data by name, employee ID, and department ID for all employees who receive a pay cheque for a pay run and pay calendar.
Cost Center Report	RUNCTL_PAYINIT2	Payroll for North America, Payroll Processing USA, Pay Period Reports, Cost Center, Cost Center Report Payroll for North America, Payroll Processing USF, Pay Period Reports, Cost Center, Cost Center Report	Generate the PAY005 report that groups employee hours and earnings, sorted by cost center. You might have to modify the Structured Query Report (SQR) to meet your organization's requirements.
Cost Center Report	RUNCTL_PAYINIT	Payroll for North America, Payroll Processing CAN, Pay Period Reports, Cost Center, Cost Center Report	Generate the PAY005 report that groups employee hours and earnings, sorted by cost center. You might have to modify the SQR to meet your organization's requirements.
Other Earnings Register	RUNCTL_PAYINIT2	Payroll for North America, Payroll Processing USA, Pay Period Reports, Other Earnings Register, Other Earnings Register Payroll for North America, Payroll Processing USF, Pay Period Reports, Other Earnings Register, Other Earnings Register	See PeopleSoft Enterprise Payroll for North America Reports.
Other Earnings Register	RUNCTL_PAYINIT	Payroll for North America, Payroll Processing CAN, Pay Period Reports, Other Earnings Register, Other Earnings Register	See PeopleSoft Enterprise Payroll for North America Reports.
Deductions in Arrears Report	RUNCTL_PAYINIT2	Payroll for North America, Payroll Processing USA, Pay Period Reports, Deductions in Arrears, Deductions in Arrears Report Payroll for North America, Payroll Processing USF, Pay Period Reports, Deductions in Arrears, Deductions in Arrears Report	See PeopleSoft Enterprise Payroll for North America Reports.
Deductions in Arrears Report	RUNCTL_PAYINIT	Payroll for North America, Payroll Processing CAN, Pay Period Reports, Deductions in Arrears, Deductions in Arrears Report	See PeopleSoft Enterprise Payroll for North America Reports.
Deductions Not Taken Report	RUNCTL_PAYINIT	Payroll for North America, Payroll Processing USA, Pay Period Reports, Deductions Not Taken, Deductions Not Taken Report Payroll for North America, Payroll Processing CAN, Pay Period Reports, Deductions Not Taken, Deductions Not Taken Report Payroll for North America, Payroll Processing USF, Pay Period Reports, Deductions Not Taken, Deductions Not Taken Report	See PeopleSoft Enterprise Payroll for North America Reports.
Employees Not Processed Report	RUNCTL_RPT_RUNID	Payroll for North America, Payroll Processing USA, Produce Payroll, Employees Not Processed Report, Employees Not Processed Report Payroll for North America, Payroll Processing CAN, Produce Payroll, Employees Not Processed Report, Employees Not Processed Report Payroll for North America, Payroll Processing USF, Produce Payroll, Employees Not Processed Report, Employees Not Processed Report	See PeopleSoft Enterprise Payroll for North America Reports.
Payroll Summary Report	RUNCTL_PAYINIT4	Payroll for North America, Payroll Processing USA, Pay Period Reports, Payroll Summary, Payroll Summary Report Payroll for North America, Payroll Processing USF, Pay Period Reports, Payroll Summary, Payroll Summary Report	See PeopleSoft Enterprise Payroll for North America Reports.
Payroll Summary Report	RUNCTL_PAY018CN	Payroll for North America, Payroll Processing CAN, Pay Period Reports, Payroll Summary, Payroll Summary Report	See PeopleSoft Enterprise Payroll for North America Reports.
Employer Benefit Contributions Report	RUNCTL_PAYINIT2	Payroll for North America, Payroll Processing USA, Pay Period Reports, Employer Benefit Contributions, Employer Benefit Contributions Report Payroll for North America, Payroll Processing USF, Pay Period Reports, Employer Benefit Contributions, Employer Benefit Contributions Report	See PeopleSoft Enterprise Payroll for North America Reports.
Employer Benefit Contributions Report (employer benefit contributions report)	RUNCTL_PAYINIT	Payroll for North America, Payroll Processing CAN, Pay Period Reports, Employer Benefit Contributions, Employer Benefit Contributions Report	See PeopleSoft Enterprise Payroll for North America Reports.
Statistics Canada Non-Educational Institutions Report	RUNCTL_PAY100CN	Payroll for North America, Payroll Processing CAN, Pay Period Reports, Statistics-Non-Educ Institute, Statistics Canada Non-Educational Institutions Report	See PeopleSoft Enterprise Payroll for North America Reports.
Workers Comp Assessments Report (workers compensation assessments report)	RUNCTL_PAY102CN	Payroll for North America, Regulatory Reports CAN, Workers Comp Assessments, Workers Comp Assessments Report	See PeopleSoft Enterprise Payroll for North America Reports.
Overtime Bank Report	RUNCTL_PAY103CN	Payroll for North America, Payroll Processing CAN, Pay Period Reports, Overtime Bank, Overtime Bank Report	See PeopleSoft Enterprise Payroll for North America Reports.
Statistics Canada Educational Institute Report	RUNCTL_MO_YR_PAY	Payroll for North America, Payroll Processing CAN, Pay Period Reports, Stats Can Educ Institute, Statistics Canada Educational Institute Report	See PeopleSoft Enterprise Payroll for North America Reports.
Tax Deposit Summary Report	RUNCTL_PAYINIT2	Payroll for North America, Pay Period Tax Reports USA, Tax Deposit Summary, Tax Deposit Summary Report Payroll for North America, Pay Period Tax Reports USF, Tax Deposit Summary, Tax Deposit Summary Report	See PeopleSoft Enterprise Payroll for North America Reports.
Local Tax Deposit Report	RUNCTL_PAYINIT2	Payroll for North America, Pay Period Tax Reports USA, Local Tax Deposit, Local Tax Deposit Report Payroll for North America, Pay Period Tax Reports USF, Local Tax Deposit, Local Tax Deposit Report	See PeopleSoft Enterprise Payroll for North America Reports.
Federal Tax Summary Report	RUNCTL_TAX010FD	Payroll for North America, Pay Period Tax Reports USA, Federal Tax Summary, Federal Tax Summary Report	See PeopleSoft Enterprise Payroll for North America Reports.
State Tax Summary Report	RUNCTL_TAX010ST	Payroll for North America, Pay Period Tax Reports USA, State Tax Summary, State Tax Summary Report	See PeopleSoft Enterprise Payroll for North America Reports.
Tax Summary Report-PA LST (tax summary report Pennsylvania - local services tax)	RUNCTL_TAX010PA	Payroll for North America, Pay Period Tax Reports USA, Tax Summary-PA LST, Tax Summary Report-PA LST Payroll for North America, Pay Period Tax Reports USF, Tax Summary-PA LST, Tax Summary Report-PA LST	See PeopleSoft Enterprise Payroll for North America Reports.
Reconciliation-Ohio Local Report	RUNCTL_MO_QTR_YR	Payroll for North America, Pay Period Tax Reports USA, Reconciliation-Ohio Local, Reconciliation-Ohio Local Report Payroll for North America, Pay Period Tax Reports USF, Reconciliation-Ohio Local, Reconciliation-Ohio Local Report	See PeopleSoft Enterprise Payroll for North America Reports.
Federal Liability by State Report	RUNCTL_PAYINIT2	Payroll for North America, Pay Period Tax Reports USA, Federal Liability by State, Federal Liability by State Report Payroll for North America, Pay Period Tax Reports USF, Federal Liability by State, Federal Liability by State Report	See PeopleSoft Enterprise Payroll for North America Reports.
Default Tax Data Report	RUNCTL_FRMTHRU_PAY	Payroll for North America, U.S. Annual Processing, Year-End/New Year Preparation, Default Tax Data Report, Default Tax Data Report Payroll for North America, Employee Pay Data USF, Tax Information, Default Tax Data Report, Default Tax Data Report	See PeopleSoft Enterprise Payroll for North America Reports.
Default Tax Data Report	RUNCTL_FRMTHRU_PAY	Payroll for North America, Year-End Processing CAN, Year-End/New Year Preparation, Default Tax Data Report, Default Tax Data Report	See PeopleSoft Enterprise Payroll for North America Reports.
Employee Check Information Employee Cheque Information	RUNCTL_TAX018	Payroll for North America, Payroll Processing USA, Produce Checks, Employee Check Information, Employee Check Information Payroll for North America, Payroll Processing CAN, Produce Cheques, Employee Cheque Information, Employee Cheque Information Payroll for North America, Payroll Processing USF, Produce Checks, Employee Check Information, Employee Check Information	See PeopleSoft Enterprise Payroll for North America Reports.
Employee Tax Information Report	RUNCTL_TAX019	Payroll for North America, Employee Pay Data USA, Tax Information, Employee Tax Information Rpt, Employee Tax Information Report Payroll for North America, Employee Pay Data CAN, Tax Information, Employee Tax Information Rpt, Employee Tax Information Report Payroll for North America, Employee Pay Data USF, Tax Information, Employee Tax Information Rpt, Employee Tax Information Report	See PeopleSoft Enterprise Payroll for North America Reports.
Form 1042 Audit	RUNCTL_TAX030	Payroll for North America, Pay Period Tax Reports USA, Form 1042 Audit, Form 1042 Audit	See PeopleSoft Enterprise Payroll for North America Reports.
EI Rebate Report (employment insurance rebate report)	RUNCTL_TAX101CN	Payroll for North America, Regulatory Reports CAN, El Rebate, EI Rebate Report	See PeopleSoft Enterprise Payroll for North America Reports.
Health Insurance Premium Report	RUNCTL_TAX102CN	Payroll for North America, Regulatory Reports CAN, Health Insurance Premium, Health Insurance Premium Report	See PeopleSoft Enterprise Payroll for North America Reports.
Update Source Deductions	RUNCTL_TAX103CN	Payroll for North America, Year-End Processing CAN, Year-End/New Year Preparation, Update Source Deductions, Update Source Deductions	See PeopleSoft Enterprise Payroll for North America Reports.
Employer Contribution to CNT (employer contribution to Commission des Normes du Travail)	PRCSRUNCNTL	Payroll for North America, Regulatory Reports CAN, Employer Contribution to CNT, Employer Contribution to CNT	See PeopleSoft Enterprise Payroll for North America Reports.
NW Territories Payroll Tax Report (Northwest Territories payroll tax report)	RUNCTL_TAX905CN	Payroll for North America, Regulatory Reports CAN, NW Territories Payroll Tax, NW Territories Payroll Tax Report	See PeopleSoft Enterprise Payroll for North America Reports.
Nunavut Payroll Tax Report	RUNCTL_TAX906CN	Payroll for North America, Regulatory Reports CAN, Nunavut Payroll Tax, Nunavut Payroll Tax Report	See PeopleSoft Enterprise Payroll for North America Reports.

Generating a Payroll Summary Report

Access the Payroll Summary Report page (Payroll for North America, Payroll Processing USA, Pay Period Reports, Payroll Summary, Payroll Summary Report; or Payroll for North America, Payroll Processing CAN, Pay Period Reports, Payroll Summary, Payroll Summary Report; or Payroll for North America, Payroll Processing USF, Pay Period Reports, Payroll Summary, Payroll Summary Report).

Summary by Selection	Select this option to report only summary subtotals.
Detail Report	Select this option to include detail.

(USA) Generating the Tax Summary - PA LST Report

Access the Tax Summary Report-PA LST page (Payroll for North America, Pay Period Tax Reports USA, Tax Summary-PA LST, Tax Summary Report-PA LST; or Payroll for North America, Pay Period Tax Reports USF, Tax Summary-PA LST, Tax Summary Report-PA LST).

Balances for Year	Enter the calendar year for which you want to run this report.
Quarter or Period	Enter the quarter or period for which you want to run this report.
Show Employee Detail, Print SSN, and Print Employee Address	Select the Show Employee Detail check box to include employee information in the report and to make the Print SSN and Print Employee Address check boxes appear on the page. Select these two additional check boxes to include the specified type of employee data in the report. If you choose to include employee addresses in the report, the system prints the employees' home addresses.
Sort Option	Select Company Within Locality or Locality Within Company.

(CAN) Producing a Health Insurance Premium Report

Access the Health Insurance Premium Report page (Payroll for North America, Regulatory Reports CAN, Health Insurance Premium, Health Insurance Premium Report).

Balance ID	The default value is the balance ID for the calendar year. This field is unavailable for entry.
Balance Year and Balances for Period	Enter the year and month for which you want to run this report.
Summary Report	Select this option to report summary totals by company and province.
Detail Report	Select this option to include the employee detail listing.

(CAN) Running the Update Source Deductions SQR Report Process (TAX103CN)

Access the Update Source Deductions page (Payroll for North America, Year-End Processing CAN, Year-End/New Year Preparation, Update Source Deductions, Update Source Deductions).

Federal Increase By	Use this group box to perform updates to employees' federal basic claim amounts. Use percent or amount only; specifying the value of the increase.
Quebec Increase By	Use this group box to perform updates to employees' Quebec basic claim amounts. Use percent or amount only; specifying the value of the increase.
Provincial Increase By	Use this group box to perform updates to employees' provincial basic personal amounts. Add rows to enter multiple provinces. Use percent or amount only; specifying the value of the increase.

Reset Special Letters	Enter Y (yes) to reset the special letters amount to zero.
Reset Special Letters (Quebec)	Enter Y to reset the Quebec special letters amount to zero.
Reset CPP Subject Months (reset Canada Pension Plan subject months)	Y: Reset the employee's CPP subject months to 12. N (no): Reset the employee's CPP subject months to zero when the employee's original CPP subject months are fewer than 12 (for example, to reset CPP subject months to zero for employees who no longer contribute to CPP). If the employee's original CPP subject months are 12, they remain 12.
Reset Federal Commission	Enter Y to reset the federal commission amounts to zero.
Reset Quebec Commission	Enter Y to reset the Quebec commission amounts to zero.
Reset Cross Province	Y: The Cross Province check box on the Canadian Income Tax Data 2 page is deselected when the new record is created. N: The Reset Cross Province check box and associated field values are copied to the newly created record.