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.
See Also
PeopleSoft Enterprise Payroll for North America Reports
Accessing Year-End Processing Instructions
PeopleTools PeopleBook: Using PeopleSoft Applications
Year End Processing: U.S., Puerto Rico, and the U.S. Territories Guide
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.
Page Name |
Object 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. |
Access the PRCSRUNCNTL or PRCSRUNCNTRL page.
These pages have only the Run Control ID field. Select this value when you access the page.
Access the RUNCTL_RPT_RUNID page.
Select a pay run ID.
Access the RUNCTL_FRMTHRU_PAY page.
Enter the from and thru period that you want to process or report.
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. |
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.
This section provides overviews of the Quarterly State Employee Wage Listing reports and the education and government Quarterly State Employee Wage Listing report and lists the pages used to print quarterly payroll reports.
There is a general version of TAX002, but it is typically not used. Each state has its own version of the report, called TAX002XX. XX represents the state abbreviation. Some states require additional information when generating the report. It is documented below.
These are the state-specific parameters:
Report ID |
State-Specific Parameters |
TAX002CA |
Employee count by month by company. |
TAX002CO |
Report due date. |
TAX002ME |
Indicate Report Form 841ME or Report Form 941/C1–ME LOOSE |
TAX002MN |
Report due date, employer’s phone, earnings code included in quarter-to-date (QTD) hours reported |
TAX002MO |
Report probationary employees. |
TAX002NH |
Report due date. |
TAX002NJ |
Base weeks for each employee, minimum weekly earnings. |
TAX002NV |
Earnings codes for tips. |
TAX002OR |
Earnings codes included in quarter-to-date (QTD) hours reported. |
TAX002WI |
Report due date. |
Some states have special quarterly reporting requirements for public sector organizations that are not currently supported by TAX002XX. For these organizations, you must select the Education and Government check box on the Installation Table - Products page, which causes an additional field (Separate Tax Report) to appear on the TAX002XX run control page. This field is used only by T002XXHP. It determines whether to report state withholding tax, state unemployment tax, and disability separately. These reports have different report identifications—T002XXHP, where XX is the abbreviation for the state.
This report includes the following information, grouped by employer ID (when the Employer ID field is populated in the Company State Tax table and the Separate Tax Report check box is selected on the run control page):
State withholding
State unemployment
State disability
The run control page is the same as the standard Quarterly State Employee Wage Listing report run control page.
Page Name |
Object Name |
Navigation |
Usage |
RUNCTL_TAX002CA |
Payroll for North America, U.S. Quarterly Processing, State Quarterly Wage Reporting, State Wage Listing Report, California |
Generate the TAX002CA report that provides state unemployment wage listings in a general format for quarterly reporting, including page and state totals. |
|
RUNCTL_TAX002CO |
Payroll for North America, U.S. Quarterly Processing, State Quarterly Wage Reporting, State Wage Listing Report, Colorado |
Generate the TAX002CO report that provides state unemployment wage listings in a state specific format for quarterly reporting, including page and state totals. |
|
RUNCTL_TAX002ME |
Payroll for North America, U.S. Quarterly Processing, State Quarterly Wage Reporting, State Wage Listing Report, Maine |
Generate the TAX002ME report that provides state unemployment wage listings in a state specific format for quarterly reporting, including page and state totals. |
|
RUNCTL_TAX002MN |
Payroll for North America, U.S. Quarterly Processing, State Quarterly Wage Reporting, State Wage Listing Report, Minnesota |
Generate the TAX002MN report that provides state unemployment wage listings in a state specific format for quarterly reporting, including page and state totals. |
|
RUNCTL_TAX002MO |
Payroll for North America, U.S. Quarterly Processing, State Quarterly Wage Reporting, State Wage Listing Report, Missouri |
Generate the TAX002MO report that provides state unemployment wage listings in a state specific format for quarterly reporting, including page and state totals. |
|
RUNCTL_TAX002NH |
Payroll for North America, U.S. Quarterly Processing, State Quarterly Wage Reporting, State Wage Listing Report, New Hampshire |
Generate the TAX002NH report that provides state unemployment wage listings in a state specific format for quarterly reporting, including page and state totals. |
|
RUNCTL_TAX000NJ |
Payroll for North America, U.S. Quarterly Processing, State Quarterly Wage Reporting, State Wage Listing Report, NJ/NV/OR/WI/Other, New Jersey |
Generate the TAX000NJ report that provides state unemployment wage listings in a state specific format for quarterly reporting, including page and state totals. |
|
RUNCTL_TAX002NV |
Payroll for North America, U.S. Quarterly Processing, State Quarterly Wage Reporting, State Wage Listing Report, NJ/NV/OR/WI/Other, Nevada |
Generate the TAX0002NV report that provides state unemployment wage listings in a state specific format for quarterly reporting, including page and state totals. |
|
RUNCTL_TAX002OR |
Payroll for North America, U.S. Quarterly Processing, State Quarterly Wage Reporting, State Wage Listing Report, NJ/NV/OR/WI/Other, Oregon |
Generate the TAX0002OR report that provides state unemployment wage listings in a state specific format for quarterly reporting, including page and state totals. |
|
RUNCTL_TAX002WI |
Payroll for North America, U.S. Quarterly Processing, State Quarterly Wage Reporting, State Wage Listing Report, NJ/NV/OR/WI/Other, Wisconsin |
Generate the TAX0002WI report that provides state unemployment wage listings in a state specific format for quarterly reporting, including page and state totals. |
|
RUNCTL_TAX002XX |
Payroll for North America, U.S. Quarterly Processing, State Quarterly Wage Reporting, State Wage Listing Report, Others |
Generate the TAX002XX report that provides state unemployment wage listings in the state's required format for quarterly reporting, including page and state totals. |
|
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. |
|
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. |
|
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. |
|
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. |
|
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. |
|
RUNCTL_TAX017 |
Payroll for North America, U.S. Quarterly Processing, Quarterly Reports, State Unemployment Tax, State Unemployment Tax Rpt |
See PeopleSoft Enterprise Payroll for North America Reports. |
|
RUNCTL_TAX030 |
Payroll for North America, Pay Period Tax Reports USA, Form 1042 Audit, Form 1042 Audit Report |
See PeopleSoft Enterprise Payroll for North America Reports. |
|
RUNCTL_TAX810XX |
|
See PeopleSoft Enterprise Payroll for North America Reports. |
|
RUNCTL_TAX811GA |
Payroll for North America, U.S. Quarterly Processing, State Quarterly Wage Reporting, Create Georgia Wage Diskette, Create Georgia Wage Diskette |
See PeopleSoft Enterprise Payroll for North America 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.
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.
Page Name |
Object Name |
Navigation |
Usage |
RUNCTL_PAYINIT |
Payroll for North America, Regulatory Reports CAN, Tax Submission Summary, Tax Submission Summary Rpt |
Generate TAX003CN that summarizes tax submission data, sorted by business number. |
|
RUNCTL_PAYINIT2 |
|
See PeopleSoft Enterprise Payroll for North America Reports. |
|
RUNCTL_PAYINIT |
Payroll for North America, Payroll Processing CAN, Pay Period Reports, Deduction Register, Deduction Register |
See PeopleSoft Enterprise Payroll for North America Reports. |
|
RUNCTL_PAYINIT2 |
|
See PeopleSoft Enterprise Payroll for North America Reports. |
|
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. |
|
RUNCTL_PAYINIT2 |
|
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. |
|
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. |
|
RUNCTL_PAYINIT2 |
|
See PeopleSoft Enterprise Payroll for North America Reports. |
|
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. |
|
RUNCTL_PAYINIT2 |
|
See PeopleSoft Enterprise Payroll for North America Reports. |
|
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. |
|
RUNCTL_PAYINIT |
|
See PeopleSoft Enterprise Payroll for North America Reports. |
|
RUNCTL_RPT_RUNID |
|
See PeopleSoft Enterprise Payroll for North America Reports. |
|
RUNCTL_PAYINIT4 |
|
See PeopleSoft Enterprise Payroll for North America Reports. |
|
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 Ben Contributions Rpt (employer benefit contributions report) |
RUNCTL_PAYINIT2 |
|
See PeopleSoft Enterprise Payroll for North America Reports. |
Employer Ben Contributions Rpt (employer benefit contributions report) |
RUNCTL_PAYINIT |
Payroll for North America, Payroll Processing CAN, Pay Period Reports, Employer Benefit Contributions, Employer Ben Contributions Rpt |
See PeopleSoft Enterprise Payroll for North America Reports. |
Statistics Canada (Non-Educ) (statistics Canada [non-educational]) |
RUNCTL_PAY100CN |
Payroll for North America, Payroll Processing CAN, Pay Period Reports, Statistics-Non-Educ Institute, Statistics Canada (Non-Educ) |
See PeopleSoft Enterprise Payroll for North America Reports. |
Workers Comp Assessments Rpt (workers compensation assessments report) |
RUNCTL_PAY102CN |
Payroll for North America, Regulatory Reports CAN, Workers Comp Assessments, Workers Comp Assessments Rpt |
See PeopleSoft Enterprise Payroll for North America Reports. |
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. |
|
RUNCTL_MO_YR_PAY |
Payroll for North America, Payroll Processing CAN, Pay Period Reports, Statistics-Education Institute, Statistics Canada (Educ) |
See PeopleSoft Enterprise Payroll for North America Reports. |
|
RUNCTL_PAYINIT2 |
|
See PeopleSoft Enterprise Payroll for North America Reports. |
|
RUNCTL_PAYINIT2 |
|
See PeopleSoft Enterprise Payroll for North America Reports. |
|
RUNCTL_TAX010FD |
Payroll for North America, Pay Period Tax Reports USA, Tax Summary-Federal, Tax Summary Report - Federal |
See PeopleSoft Enterprise Payroll for North America Reports. |
|
RUNCTL_TAX010ST |
Payroll for North America, Pay Period Tax Reports USA, Tax Summary-State, Tax Summary Report - State |
See PeopleSoft Enterprise Payroll for North America Reports. |
|
RUNCTL_TAX010PA |
|
See PeopleSoft Enterprise Payroll for North America Reports. |
|
Reconciliation-Ohio Local Rpt (reconciliation-Ohio local report) |
RUNCTL_MO_QTR_YR |
|
See PeopleSoft Enterprise Payroll for North America Reports. |
Federal Liability by State Rpt (federal liability by state report) |
RUNCTL_PAYINIT2 |
|
See PeopleSoft Enterprise Payroll for North America Reports. |
RUNCTL_FRMTHRU_PAY |
|
See PeopleSoft Enterprise Payroll for North America Reports. |
|
RUNCTL_FRMTHRU_PAY |
Payroll for North America, Employee Pay Data CAN, Tax Information, Default Tax Data Report, Default Tax Data Report |
See PeopleSoft Enterprise Payroll for North America Reports. |
|
Employee Check Info Report (employee check information report) |
RUNCTL_TAX018 |
|
See PeopleSoft Enterprise Payroll for North America Reports. |
Employee Tax Information Rpt (employee tax information report) |
RUNCTL_TAX019 |
|
See PeopleSoft Enterprise Payroll for North America Reports. |
RUNCTL_TAX030 |
Payroll for North America, Pay Period Tax Reports USA, Form 1042 Audit, Form 1042 Audit Report |
See PeopleSoft Enterprise Payroll for North America Reports. |
|
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 Rpt (health insurance premium report) |
RUNCTL_TAX102CN |
Payroll for North America, Regulatory Reports CAN, Health Insurance Premium, Health Insurance Premium Rpt |
See PeopleSoft Enterprise Payroll for North America Reports. |
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 Rpt (Northwest Territories payroll tax report) |
RUNCTL_TAX905CN |
Payroll for North America, Regulatory Reports CAN, NW Territories Payroll Tax, NW Territories Payroll Tax Rpt |
See PeopleSoft Enterprise Payroll for North America Reports. |
RUNCTL_TAX906CN |
Payroll for North America, Regulatory Reports CAN, Nunavut Payroll Tax, Nunavut Payroll Tax Report |
See PeopleSoft Enterprise Payroll for North America Reports. |
Access the Payroll Summary Report page.
Click Run to run the report by using PeopleSoft Process Scheduler.
Summary by Selection |
Select this option to report only summary subtotals. |
Detail Report |
Select this option to include detail. |
Access the Tax Summary Report-PA OPT page.
Click Run to run the report by using PeopleSoft Process Scheduler.
Balances for Year |
Enter the calendar year for which you want to run this report. |
Quarter and Period |
Enter the quarter and period for which you want to run this report. |
Show EE Detail? (show employee detail?) |
Select this check box to display employee’s information. |
Sort Option |
Select Company Within Locality or Locality Within Company. |
Access the Health Insurance Premium Rpt page.
Click Run to run the report by using PeopleSoft Process Scheduler.
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. |
Access the Update Source Deductions page.
Click Run to run this request. PeopleSoft Process Scheduler runs the Update Source Deductions process at user-defined intervals.
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 cleared when the new record is created. N: The Reset Cross Province check box and associated field values are copied to the newly created record. |