40 Set Up Payroll Cycle Reports

This chapter contains these topics:

40.1 Setting Up Payroll Cycle Reports

Setting up payroll cycle reports allows you to set up your own versions of the reports generated during a payroll cycle. If you do not set up your own versions, the system uses the DEMO version that JD Edwards World provides. Setting up your own version allows you to customize the title of the report, change the sequence, and meet your company's reporting needs.

When you select one of these reports as a menu selection from the setup menu, it is available only for the purpose of report setup. You cannot run the reports directly from this menu.

Setting up payroll cycle reports consists of the following tasks:

  • Setting Up the Payroll Register

  • Setting Up the Summary Payroll Register

  • Setting Up the Time and Pay Exception Report

  • Setting Up the Transaction Audit Report

  • Setting Up the Workers Compensation Insurance Register

  • Setting Up the General Liability Insurance Register

  • Setting Up the DBA Register

  • Setting Up the Wage Attachment Report

  • Setting Up the Time and Pay Register

  • Setting Up the Terminated Employees Report

40.2 Setting Up the Payroll Register

Navigation

From Payroll Master (G07), enter 29

From Payroll Setup (G074), choose Pay Cycle Report Setup

From Pay Cycle Report Setup (G0746), choose Payroll Register

Use the Payroll Register to verify that the employees' gross-to-net amounts are correct. You can review employee earnings for this payroll cycle. The report lists the following information and can be sequenced and totaled to meet your company's needs:

  • Pay types and deductions for each employee

  • Totals by pay types and deductions for each business unit

  • Totals by pay types and deductions for each company

  • Grand totals by pay types and deductions for all companies in the payroll version

Note:

When you select this report as a menu selection from the setup menu, it is available only for the purpose of report setup. You cannot run the reports directly from this menu.

40.2.1 What You Should Know About

Topic Description
Benefits and accruals You can print benefits and accruals on the Payroll Register.

40.2.2 Processing Options

See Section 62.4, "Payroll Register (P063012)."

40.2.3 Data Selection for the Payroll Register

You should not change the data selection for this report.

40.2.4 Data Sequence for the Payroll Register

Pre-payroll, Payroll Register, and Payroll Summary reports must have the same sequence.

40.3 Setting Up the Summary Payroll Register

Navigation

From Payroll Master (G07), enter 29

From Payroll Setup (G074), choose Pay Cycle Report Setup

From Pay Cycle Report Setup (G0746), choose Summary Payroll Register

The Summary Payroll Register lists one line per check, and shows which employees' gross-to-net calculations are incorrect. If you are processing payroll for a large number of employees, you might find it easier to use the Summary Payroll Register to review employees' gross-to-net earnings instead of the Payroll Register.

Note:

When you select this report as a menu selection from the setup menu, it is available only for the purpose of report setup. You cannot run the reports directly from this menu.

40.3.2 Data Selection for the Summary Payroll Register

You should not change the data selection for this report.

40.4 Setting Up the Time and Pay Exception Report

Navigation

From Payroll Master (G07), enter 29

From Payroll Setup (G074), choose Pay Cycle Report Setup

From Pay Cycle Report Setup (G0746), choose Time & Pay Exception

When you request the Time and Pay Entry Journal during pre-payroll processing, the system prints the Time and Pay Exception report only if exceptions occur. Use this report to identify employees whose timecards might contain errors. For example, this report lists employees whose hour or rate amounts are more than the maximum or less than the minimum amounts you specified in the processing options for this report.

If you set up Enhanced Subledger Accounting, you can view these values on the report.

Note: When you select this report as a menu selection from the setup menu, it is available only for the purpose of report setup. You cannot run the reports directly from this menu.

40.4.2 Data Selection for Time and Pay Exception Report

You should not change the data selection for this report.

40.5 Setting Up the Transaction Audit Report

Navigation

From Payroll Master (G07), enter 29

From Payroll Setup (G074), choose Pay Cycle Report Setup

From Pay Cycle Report Setup (G0746), choose Transaction Audit Report

You use the Transaction Audit report to review deduction, benefit, and accrual information for all employees in your payroll cycle.

Note:

When you select this report as a menu selection from the setup menu, it is available only for the purpose of report setup. You cannot run the reports directly from this menu.

40.5.1 Data Selection for the Transaction Audit Report

You should not change the data selection for this report.

40.6 Setting Up the Workers Compensation Insurance Register

Navigation

From Payroll Master (G07), enter 29

From Payroll Setup (G074), choose Pay Cycle Report Setup

From Pay Cycle Report Setup (G0746), choose Workers Comp Insurance Register

The Workers Compensation Insurance Register lists detailed workers compensation information for all employees included in the pre-payroll processing. This report provides subtotals along with each employee's workers compensation code, work state, company, and grand totals. You must process journal entries prior to running this report, because the system calculates this information during the journal entry step of the payroll cycle.

Note:

When you select this report as a menu selection from the setup menu, it is available only for the purpose of report setup. You cannot run the reports directly from this menu.

40.6.2 Data Selection for Workers Compensation Insurance Register

You should not change the data selection for this report.

40.7 Setting Up the General Liability Insurance Register

Navigation

From Payroll Master (G07), enter 29

From Payroll Setup (G074), choose Pay Cycle Report Setup

From Pay Cycle Report Setup (G0746), choose General Liability Insurance Register

The General Liability Insurance Register is similar to the Workers Compensation Register, but lists general liability insurance information. You must post the journal entries before running this report. If you do not, no information is available.

Note:

When you select this report as a menu selection from the setup menu, it is available only for the purpose of report setup. You cannot run the reports directly from this menu.

40.7.2 Data Selection for General Liability Insurance Register

You should not change the data selection for this report.

40.8 Setting Up the DBA Register

Navigation

From Payroll Master (G07), enter 29

From Payroll Setup (G074), choose Pay Cycle Report Setup

From Pay Cycle Report Setup (G0746), choose DBA Register

The DBA Register includes the same information as the Transaction Audit report (Deduction/Benefit/Accrual report), but it lists all employees in the pre-payroll processing by deduction, benefit, and accrual.

Note:

When you select this report as a menu selection from the setup menu, it is available only for the purpose of report setup. You cannot run the reports directly from this menu.

40.8.1 Processing Options

See Section 62.9, "DBA Register (P063062)."

40.8.2 Data Selection for DBA Register

You should not change the data selection for this report.

40.9 Setting Up the Wage Attachment Report

Navigation

From Payroll Master (G07), enter 29

From Payroll Setup (G074), choose Pay Cycle Report Setup

From Pay Cycle Report Setup (G0746), choose Wage Attachment

The Wage Attachment report lists all employee wage attachments by payee. Listings with an unspecified payee are for loans.

40.9.1 Data Selection for Wage Attachment Report

You should not change the data selection for this report.

Note:

When you select this report as a menu selection from the setup menu, it is available only for the purpose of report setup. You cannot run the reports directly from this menu.

40.10 Setting Up the Time and Pay Register

Navigation

From Payroll Master (G07), enter 29

From Payroll Setup (G074), choose Pay Cycle Report Setup

From Pay Cycle Report Setup (G0746), choose Time and Pay Register

The Time and Pay Register lists the time and pay totals for the current payroll. You can choose to include employee totals on the report. Processing options determine what data is printed on the report. When you request this report in pre-payroll, the system prints the Time and Pay Exception report.

Note:

When you select this report as a menu selection from the setup menu, it is available only for the purpose of report setup. You cannot run the reports directly from this menu.

40.10.2 Data Selection for Time and Pay Register

You should not change the data selection for this report.

40.11 Setting Up the Terminated Employees Report

Navigation

From Payroll Master (G07), enter 29

From Payroll Setup (G074), choose Pay Cycle Report Setup

From Pay Cycle Report Setup (G0746), choose Terminated Employees Report

The Terminated Employees report lists those employees whose employment with the company has ended during the pay period.

Note:

When you select this report as a menu selection from the setup menu, it is available only for the purpose of report setup. You cannot run the reports directly from this menu.

40.11.1 Setting Up the Piecework Check Stub

The check stub attachment includes the detail information for employees compensated on a piecework basis. This system includes this attachment with the employee payments.

Note:

When you select this report as a menu selection from the setup menu, it is available only for the purpose of report setup. You cannot run the reports directly from this menu.