Preparing Pay Period Reports

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.

Page Name

Definition Name

Usage

Tax Submission Summary Report Page

RUNCTL_PAYINIT

(CAN) Generate TAX003CN that summarizes tax submission data, sorted by payroll account number.

Deduction Register Page

RUNCTL_PAYINIT2

(USA, USF) Print Deduction Register pay period report.

Deduction Register Page

RUNCTL_PAYINIT

(CAN) Print Deduction Register pay period report.

Payroll Register Page

RUNCTL_PAYINIT2

(USA, USF) Print Payroll Register pay period report.

Payroll Register Page

RUNCTL_PAYINIT

(CAN) 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 Page

RUNCTL_PAYINIT2

(USA, USF) 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 Page

RUNCTL_PAYINIT

(CAN) 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 Page

RUNCTL_PAYINIT2

(USA, USF) Print Other Earnings Registerr pay period report.

Other Earnings Register Page

RUNCTL_PAYINIT

(CAN) Print Other Earnings Register pay period report.

Deductions in Arrears Report Page

RUNCTL_PAYINIT2

(USA, USF) Print Deductions in Arrears pay period report.

Deductions in Arrears Report Page

RUNCTL_PAYINIT

(CAN) Print Deductions in Arrears pay period report.

Deductions Not Taken Report Page

RUNCTL_PAYINIT

Print Deductions Not Taken pay period report.

Employees Not Processed Report Page

RUNCTL_RPT_RUNID

Print Employees Not Processed pay period report.

Payroll Summary Report Page

RUNCTL_PAYINIT4

(USA, USF) Print Payroll Summary pay period report.

Payroll Summary Report Page

RUNCTL_PAY018CN

(CAN) Print PAY018CN Payroll Summary pay period report.

Employer Benefit Contributions Report Page

RUNCTL_PAYINIT2

(USA, USF) Print Employer Benefit Contributions Report pay period report.

Employer Benefit Contributions Report Page

RUNCTL_PAYINIT

(CAN) Print Employer Benefit Contributions pay period report.

Statistics Canada Non-Educational Institutions Report Page

RUNCTL_PAY100CN

(CAN) Print PAY100CN Statistics Canada Non-Educational Institutions pay period report.

Workers Comp Assessments Report Page (workers compensation assessments report)

RUNCTL_PAY102CN

(CAN) Print PAY102CN Workers Comp Assessments pay period report.

Overtime Bank Report Page

RUNCTL_PAY103CN

(CAN) Print PAY103CN Overtime Bank pay period report.

Statistics Canada Educational Institute Report Page

RUNCTL_MO_YR_PAY

(CAN) Statistics Canada Educational Institutional pay period report.

Tax Deposit Summary Report Page

RUNCTL_PAYINIT2

(USA, USF) Print Tax Deposit Summary pay period report.

Local Tax Deposit Report Page

RUNCTL_PAYINIT2

(USA, USF) Print Local Tax Deposit pay period report.

Federal Tax Summary Report Page

RUNCTL_TAX010FD

(USA) Print TAX010FD Federal Tax Summary pay period report.

State Tax Summary Report Page

RUNCTL_TAX010ST

(USA) Print TAX010ST State Tax Summary pay period report.

Tax Summary Report-PA LST Page (tax summary report Pennsylvania - local services tax)

RUNCTL_TAX010PA

(USA, USF) Print TAX010PA Report-PA LST pay period report.

Tax Summary-PA EIT Page (tax summary \Pennsylvania - earned income tax)

RUNCTL_TAX011PA

(USA, USF) Print TAX011PA Report-PA EIT pay period report.

Reconciliation-Ohio Local Report Page

RUNCTL_MO_QTR_YR

(USA, USF) Print Reconciliation-Ohio Local pay period report.

Federal Liability by State Report Page

RUNCTL_PAYINIT2

(USA, USF) Print Federal Liability by State pay period report.

Default Tax Data Report Page

RUNCTL_FRMTHRU_PAY

(USA, USF) Print FRMTHRU_PAY Default Tax Data pay period report.

Default Tax Data Report Page

RUNCTL_FRMTHRU_PAY

CAN) Print FRMTHRU_PAY Default Tax Data pay period report.

Employee Check Information Page

Employee Cheque Information Page

RUNCTL_TAX018

(USA, USF) Print TAX018 Employee Check Information pay period report.

(Can) Print Employee Cheque Information pay period report.

Employee Tax Information Report Page

RUNCTL_TAX019

Print TAX019 Employee Tax Information pay period report.

Form 1042 Audit Page

RUNCTL_TAX030

(USA) Print TAX030 Form 1042 Audit pay period report.

EI Rebate Report Page (employment insurance rebate report)

RUNCTL_TAX101CN

(CAN) Print TAX101CN EI Rebate pay period report.

Health Insurance Premium Report Page

RUNCTL_TAX102CN

(CAN) Print TAX102CN Health Insurance Premium pay period report.

Update Source Deductions Page

RUNCTL_TAX103CN

(CAN) Print TAX103CN Update Source Deductions pay period report.

Employer Contribution to CNT Page (employer contribution to Commission des Normes du Travail)

PRCSRUNCNTL

(CAN) Print Employer Contribution to CNT pay period report.

NW Territories Payroll Tax Report Page (Northwest Territories payroll tax report)

RUNCTL_TAX905CN

(CAN) Print TAX905CN NW Territories Payroll Tax Report pay period report.

Nunavut Payroll Tax Report Page

RUNCTL_TAX906CN

(CAN) Print TAX906CN Nunavut Payroll Tax Report pay period report.

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.

(USA, USF) Use the Payroll Summary Report page (RUNCTL_PAYINIT4) to print the Payroll Summary report.

Navigation

  • 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

Image: Payroll Summary Report page

This example illustrates the fields and controls on the Payroll Summary Report page.

Payroll Summary Report page

Field or Control

Definition
Summary by Selection

Select this option to report only summary subtotals.
Detail Report

Select this option to include detail.

(USA, USF) Use the Tax Summary Report-PA LST (tax summary report Pennsylvania - local services tax) page (RUNCTL_TAX010PA) to print the Tax Summary report for Pennsylvania local services tax.

Navigation

  • 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

Image: Tax Summary Report PA LST page

This example illustrates the fields and controls on the Tax Summary Report PA LST page.

Tax Summary Report-PA LST page

Field or Control

Definition
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.

(USA, USF) Use the Tax Summary-PA EIT (tax summary report Pennsylvania - earned income tax) page (RUNCTL_TAX011PA) to print the Tax Summary report for Pennsylvania earned income tax.

Navigation

  • Payroll for North America > Pay Period Tax Reports USA > Tax Summary-PA EIT > Tax Summary Report-PA EIT

  • Payroll for North America > Pay Period Tax Reports USF > Tax Summary-PA EIT > Tax Summary Report-PA EIT

Image: Tax Summary Report PA EIT page

This example illustrates the fields and controls on the Tax Summary Report PA EIT page.

Tax Summary Report PA EIT page

The fields and controls here are the same as on the Use the Tax Summary Report-PA LST (tax summary report Pennsylvania - local services tax) page (RUNCTL_TAX010PA).

(CAN) Use the Health Insurance Premium Report page (RUNCTL_TAX102CN) to print the TAX102CN Health Insurance Premium report.

Navigation

Payroll for North America > Regulatory Reports CAN > Health Insurance Premium > Health Insurance Premium Report

Image: Health Insurance Premium Report page

This example illustrates the fields and controls on the Health Insurance Premium Report page.

Health Insurance Premium Report page

Field or Control

Definition
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) Use the Update Source Deductions page (RUNCTL_TAX103CN) to print TAX103CN Update Source Deductions report.

Navigation

Payroll for North America > Year-End Processing CAN > Year-End/New Year Preparation > Update Source Deductions > Update Source Deductions

Image: Update Source Deductions page

This example illustrates the fields and controls on the Update Source Deductions page.

Update Source Deductions page

Reset Options

Field or Control

Definition
Reset Special Letters

Enter Y (yes) to reset the special letters amount to zero.
Reset Federal Commission

Enter Y to reset the federal commission amounts to zero.
Reset CPP Subject Months (reset Canada Pension Plan subject months)

Y (yes): 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 Cross Province

Y (yes): The Cross Province check box on the Canadian Income Tax Data 2 page is deselected when the new record is created.

N (no): The Reset Cross Province check box and associated field values are copied to the newly created record.
Reset Special Letters (Quebec)

Enter Y (yes) to reset the Quebec special letters amount to zero.
Reset Quebec Commission

Enter Y (yes) to reset the Quebec commission amounts to zero.
Reset Quebec Health

Enter Y (yes) to deselect the Exempt from Quebec Health check box on the Quebec Income Tax Data page for all employees for whom Exempt from Quebec Health is currently selected. Resetting in this way makes no employee exempt from Quebec Health.

Basic Claim Amounts

Field or Control

Definition
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.