JD Edwards EnterpriseOne U.S. Payroll Reports

Appendix: JD Edwards EnterpriseOne U.S. Payroll Reports

This appendix provides an overview of United States Payroll reports and enables you to:

View a summary table of all reports.
View details for selected reports.

JD Edwards EnterpriseOne U.S. Payroll Reports: A to Z

This table lists the U.S. Payroll reports, sorted alphanumerically by report ID.

Report ID and Report Name	Description	Navigation
R07347 Federal Taxation History Report	Use the Federal Tax History report to review federal tax and wage amounts for individual employees. You can review total earned income credits, as well as the federal income, FICA, and Medicare wages and taxes for each employee. At year-end, you can use the Federal Tax History report to verify the information that you print on employees' year-end forms. The information on this report is stored in the Tax History table (F06136).	U.S. History Reports menu (G07BUSP15), Federal Tax History Report.
R07348 State/Local Taxation History Report	Use the State and Local Taxation History Report (R07348) to review totals of state and local taxes that employees paid. You can review the total state and local taxes that each employee paid and the total wages on which the taxes were based. At the end of the year, you can use the State and Local Taxation History Report to verify the information that you print on employees' tax forms. The JD Edwards EnterpriseOne U.S. Payroll system retrieves information from the Tax History table (F06136) for the earnings and tax history reports. Changing the data sequencing of this report could cause undesirable results. We recommend that you do not change the data sequencing.	U.S. History Reports menu (G07BUSP15), State/Local Taxation Report.
R07371 Certified Payroll Register Report	The Certified Payroll Register report (R07371) includes detailed information regarding certified jobs. Typically, government contracts are considered certified jobs. This report is essential for meeting government reporting requirements for union employees. You can identify combinations of job types and job steps that you want to print on the report.	Periodic Processing menu (G07UN2), Certified Payroll Register.
R074xx (xx refers to the two-digit state code) State-Specific New Hire Reports	These reports are used to report new hire information to state governments. Each state has a separate report, which meets the legislative requirements for that state.	New Hire Reporting (G05BG1), New Hire Report Setup.
R07416 Tax History By Company Report	Use the Tax History by Company report to review monthly tax history for an entire year for each company in the organization. You can review gross pay, excludable wages, taxable wages, excess pay, and actual taxes for each tax type. The report also includes totals of these amounts for all tax types. The information on this report is stored in the Tax History table (F06136).	U.S. History Reports menu (G07BUSP15), Tax History By Company.
R07810 Quarterly Weeks Worked Report	This report is used to create weeks worked information, which is used to report State Unemployment Insurance information to state governments.	State Unemployment Reporting, Quarterly Weeks Worked Report.
R073162 State Tax Distribution Summary Report	This report provides summary information about state tax amounts for each employee included in a payroll cycle.	This report cannot be produced from a menu. This report can be produced only during the Reports step of the payroll cycle.
R073170 Federal Tax Distribution Summary Report	This report provides summary information about Federal earnings tax amounts for each employee included in a payroll cycle.	This report cannot be produced from a menu. This report can be produced only during the Reports step of the payroll cycle.
R073601 Workers Compensation Register Report	This report provides detailed or summary Workers' Compensation information, depending upon the processing mode used, for each employee included in a payroll cycle.	This report cannot be produced from a menu. This report can be produced only during the Reports step of the payroll cycle.
R073648 Washington Workers Comp Quarterly Report	This report includes employer- and employee-paid Industrial Insurance information. This report meets the requirements of Washington state.	Government Reporting (G05BG), Washington Quarterly Workers Comp.
R073651 General Liability Insurance Register	This report provides detailed or summary general liability insurance information for each employee included in a payroll cycle.	This report cannot be produced from a menu. This report can be produced only during the Reports step of the payroll cycle.
R073665 Employee Social Security Register	Depending on processing mode, this report can include employee- or employer-paid social security or Medicare taxes for each employee in the payroll cycle.	This report cannot be produced from a menu. This report can be produced only during the Reports step of the payroll cycle.
R0783xxC (xx refers to the two-digit state code) State-Specific SUI Continuation Reports	SUI Continuation reports are used to print detailed SUI information if the number of employees included in the report exceeds the specified number of employees that can print on the Summary report.	State Unemployment Reporting, SUI Reports Setup.
R0783xxS (xx refers to the two-digit state code) State-Specific SUI Summary Reports	SUI Summary reports list summarized state unemployment information for an organization. If you print this report in detail mode, the system includes a specified number of employees on the Summary report. If there are more employees than the specified number, the system automatically produces the corresponding state-specific SUI Continuation report.	State Unemployment Reporting, SUI Reports Setup.
R078400 State Income Tax Report	The State Income Tax report (R078400) provides a generic sample of a typical state income tax report. You can create new versions of this report to meet the specific requirements of the state. You can run this report as often as needed to satisfy government requirements.	Governmental Reporting menu (G05BG), State Income Tax Report.
R078401 Local Income Tax Report	The Local Income Tax report (R078401) provides a sample of a typical local income tax report. You can create new versions of this report to meet the specific requirements of the locality. You can run this report as often as needed to satisfy government requirements.	Governmental Reporting menu (G05BG), Local Income Tax Report.
R078433 New York State 45-CC Report	Some construction employers in the state of New York must file a quarterly report in addition to the NYS-45 that all employers must file. This report is called the New York Supplemental Return for Construction Employers (R078433), or the NYS-45-CC.	Governmental Reporting menu (G05BG), NYS-45-CC Construction Employers.
R078500 941 Detail Wage List Report	The 941 Detail Wage List report (R078500) contains the information for the employer's federal tax return. The report provides this information, which is required by the federal government: Total wages Federal income tax Social Security and Medicare taxes	Governmental Reporting menu (G05BG), 941 Wage Detail List 1.
R078502 940 Quarterly Worksheet Report	The 940 Quarterly Worksheet report (R078502) contains the quarterly unemployment tax information for the selected company. This report is not required for government reporting. You can use this report to assist in the preparation of the federal 940 Annual Worksheet report. You can use the totals from each quarterly report to verify the quarterly totals generated by the annual report.	Governmental Reporting menu (G05BG), 940 Quarterly Worksheet.
R078506 Form 941 Schedule B Report	The Form 941 Schedule B report (R078506) is a supplement to the 941 Wage Detail List 1 report (R078500). The 941 Schedule B report summarizes the company's daily tax liability for these items: Income tax withheld Employer-paid Social Security tax withheld Employee-paid Social Security tax withheld Employer-paid Medicare tax withheld Employee-paid Medicare tax withheld	Government Reporting menu (G05BG), 941 Wage Detail List 1.
R078507 940 Annual Worksheet Report	The 940 Annual Worksheet lists annual unemployment tax information for the selected company. Most employers pay federal and state unemployment tax, which requires using the Employer’s 940 Annual Federal Unemployment Tax Return. The Federal Unemployment Tax Act (FUTA), together with state unemployment agencies, provides for payments of unemployment compensation to workers who have lost their jobs.	Governmental Reporting menu (G05BG), 940 Annual Worksheet

JD Edwards EnterpriseOne U.S. Payroll: Selected Reports

These reports are listed alphanumerically by report ID in this appendix.

R07371 - Certified Payroll Register Report

The Certified Payroll Register report (R07371) includes detailed information regarding certified jobs. Typically, government contracts are considered certified jobs. This report is essential for meeting government reporting requirements for union employees. You can identify combinations of job types and job steps that you want to print on the report. The report lists this information, by employee:

Total hours worked (regular, overtime, and other).
Equal employment opportunity data.
Employee payment information.
Fringe benefits detail, if requested.
Totals for each certified job.

The information provided in this report is based on these tables:

Business Unit Master (F0006).
Employee Tax Exemptions/Overrides (F06017).
Pay Check History Summary (F06156).
Pay Check History Tax Ledger (F06166).
Benefit/Accrual Detail File (F0619).
Employee Transaction History (F0618).
Burden Distribution File (F0624).

Before you process the Certified Payroll Register, you must:

Set up the job types and job steps that you need to print for reporting purposes.
Set the Certified Payroll Register field to Y (Yes) for the business unit constants.
Activate the Certified Flag field in the job classifications constants.

See Setting Up Job Information for Employees.

See Setting Up Business Unit Information.

Processing Options for Certified Payroll Register (R07371)

Processing options enable you to specify the default processing for programs and reports.

Defaults

These processing options are used to define the default information that is used to process the report.

1. Pay Period End Date (required)	Specify the pay period to use to generate the certified payroll register. This processing option is required.
2. Period Number (required)	Specify which pay period the pay period end date is from. This processing option is required. Pay Period End Date is a processing option for the certified payroll register.
3. Check Detail	Specify whether the certified payroll register includes detailed information about the deductions associated with each payment that appears on the register. Values are: Blank: Print deductions in detail. The system prints one detail line in the Check Detail column for each deduction to a payment. This is the default. 1: Print deductions in total. The system will print one summary line in the Check Detail column for all deductions to a payment.
4. Fringe Detail	Specify whether to print fringe detail on the certified payroll register. If you print fringe detail, the information appears on the right side of the certified payroll register. Values are: Blank: Do not print fringe detail. This is the default. 1: Print fringe detail.
5. Address Information	Specify whether to print the employee's address on the certified payroll register. For example, if the certified payroll register is circulated externally, you might decide not to print the employee's address information. Values are: Blank: Print employee address information. This is the default. 1: Do not print employee address information.

R078400 - State Income Tax Report

The State Income Tax report (R078400) provides a generic sample of a typical state income tax report. You can create new versions of this report to meet the specific requirements of the state. You can run this report as often as needed to satisfy government requirements. The system retrieves this information from the Tax History table (F06136):

Listings for all states.
Gross and taxable wage information for each employee.
Employee listing by company.
Excludable wage amounts.
Tax amounts for each employee.
Totals for each state tax type.

Processing Options for State Income Tax Report (R078400)

Processing options enable you to specify the default processing for programs and reports.

Process

Use these processing options to specify which data the system uses to process the report.

1. Enter the quarter number being processed:

Specify the number that corresponds to the fiscal quarter for which you are processing the report. Valid options are:

1: First quarter

2: Second quarter

3: Third quarter

4: Fourth quarter

2. Report inclusion/exclusions:

Specify whether to include contract and pension employees on the report. Values are:

1: Include pension employees only.

2: Include contract employees only.

3: Include all employees.

Blank: Do not include pension or contract employees. Blank is the default.

R078401 - Local Income Tax Report

The Local Income Tax report (R078401) provides a sample of a typical local income tax report. You can create new versions of this report to meet the specific requirements of the locality. You can run this report as often as needed to satisfy government requirements. The system retrieves this information from the Tax History table (F06136):

Listings for all local tax types.
Gross and taxable wage information for each employee.
Employee listing by company.
Excludable wage amounts.
Tax amounts for each employee.
Totals for each local tax type.

Processing Options for Local Income Tax Report (R078401)

Processing options enable you to specify the default processing for programs and reports.

Process

Use this processing option to specify the data that the system uses to process the report.

1. Enter the quarter number to be included in this report:

Specify the number that corresponds to the fiscal quarter for which you are processing the report. Values are:

1: First quarter

2: Second quarter

3: Third quarter

4: Fourth quarter

R078433 - New York State 45-CC Report

Some construction employers in the state of New York must file a quarterly report in addition to the NYS-45 that all employers must file. This report is called the New York Supplemental Return for Construction Employers (R078433), or the NYS-45-CC.

All contractors, owners, and their agents who provide covered services must file Form NYS-45-CC. Covered services include excavating, erecting, demolishing, repairing, altering, painting, and cleaning of a building or structure. However, covered services provided in the construction of one- and two-family houses are exempt from reporting.

When you select data for inclusion in this report, select only those employees who perform these covered services.

You can set up a version of the report that you can scan and transmit directly to the New York state employment tax offices. Alternatively, you can set up a version that compiles the necessary information that you use to manually complete the scannable hard-copy report provided by the tax employment office.

Processing Options for New York Supplemental Return for Construction Employees (R078433)

Processing options enable you to specify the default processing for programs and reports.

Process

1. Employer Legal Name	Specify the employer's legal name.
2. Withholding Tax Identification Number	Specify the number that identifies your company to the tax authority. This number can include the tax ID number for an individual, a federal or state corporate tax ID, a sales tax number, and so on. This number has specifically been established for the JD Edwards EnterpriseOne Payroll system to handle the requirements of taxing authorities that require more than 9 positions for the tax identification number. Do not enter hyphens (dashes), slashes, spaces, or other punctuation in the tax identification number.
3. Quarter number to be included in this report	Specify the number that corresponds to the fiscal quarter for which you are processing the report. Values are: 1: First quarter 2: Second quarter 3: Third quarter 4: Fourth quarter
4. Year to be included in this report (YYYY)	Specify the four-digit year of the reporting period.
5. Date of the first Saturday in the quarter (MM/DD/YY)	Specify the month, day, and year of the first Saturday in the fiscal quarter for which you are processing the report.

R078500 - 941 Detail Wage List Report

The 941 Detail Wage List report (R078500) contains the information for the employer's federal tax return. The report provides this information, which is required by the federal government:

Total wages.
Federal income tax.
Social Security and Medicare taxes.

You can generate a detailed wage list or a summary of the records in the 941 - Federal Tax History table (F068500). The information provided in the federal tax return reports is based on the Tax History table (F06136).

Processing Options for 941 Detail Wage List (R078500)

Processing options enable you to specify the default processing for programs and reports.

Process

These processing options are used to determine how the system processes data for this report.

1. Quarter (Required)	Specify the number that corresponds to the fiscal quarter for which you are processing the report. Valid values are: 1: First quarter 2: Second quarter 3: Third quarter 4: Fourth quarter
2. Year (Required)	Specify the two-digit year of the reporting period. If left blank, the report does not produce any output.
3. Print Employee Detail Wage List	Specify when you want to print the Employee Detail Wage List report. This report includes employee withholding for Social Security (FICA) and Medicare taxes. Values are: Y: Yes, print the Detail Wage List report N:No, do not print the Detail Wage List report. This is the default. The withholding amounts are doubled on the 941 tax return to reflect both employee and employer taxes. For example, if the employee withholding amount for FICA is .62, the 941 report displays .124 for FICA.
4. F068500 Records.	Specify whether you want the report to create records in the 941 Federal Tax History table (F068500). Values are: N: No, do not create records in the 941 Federal Tax History table. This value is the default. Y: Yes, create records in the 941 Federal Tax History table.
5. Total Deposits for this Quarter	Specify your deposits for this quarter, including overpayment applied from a previous quarter.
6. Monthly Depositor	Specify if you were a monthly schedule depositor for the entire quarter.

Rates

Use these processing options to specify the rates the system processes for the report.

1. FICA Rate	Specify the FICA rate. Enter the rate as a decimal fraction. For example, enter .062 for 6.2 percent.
2. Medicare Rate	Specify the Medicare rate. Enter the rate as a decimal fraction. For example, enter .0145 for 1.45 percent.

Adjustments

Use these processing options to specify monetary tax adjustmentsthe system processes for the report.

1. Current Quarter's Adjustments for Tips and Group Term Life Insurance	Specify adjustments for any uncollected employee share of social security and Medicare taxes on tips and the uncollected employee share of social security and Medicare taxes on group-term life insurance premiums paid for former employees.
2. Current Year's Income Tax Withholding	Specify adjustments for the current year's income tax withholding. For example, if you made a mistake when withholding income tax from wages that were paid in earlier quarters of the same calendar year, you can enter the income tax withholding adjustment in this field. If the income tax withholding adjustment has already been included in tax history for the quarter, then you do not need to enter the same adjustment amount here.
3. Prior Quarter's Social Security and Medicare Taxes	Specify adjustments for prior quarters' social security and Medicare taxes. For example, if you made a mistake when reporting social security and Medicare taxes on previously filed Forms 941, you can enter the prior quarters' social security and Medicare taxes adjustment in this field. If you need to report both an underpayment and an overpayment, enter only the net difference.
4. Special Additions to Federal Income Tax	Specify special additions to federal income tax. This line is reserved for employers with special circumstances. Use this line only if the IRS has sent you a notice instructing you to do so.
5. Special Additions to Social Security and Medicare	Specify special additions to social security and Medicare. This line is reserved for employers with special circumstances. Use this line only if the IRS has sent you a notice instructing you to do so.

R078502 - 940 Quarterly Worksheet Report

The 940 Quarterly Worksheet report (R078502) contains the quarterly unemployment tax information for the selected company. This report is not required for government reporting. You can use this report to assist in the preparation of the federal 940 Annual Worksheet report. You can use the totals from each quarterly report to verify the quarterly totals generated by the annual report.

The 940 Quarterly Worksheet report includes this information:

Employee names.
Tax identification numbers of employees.
Gross pay, excludable pay, excess pay, taxable wages, and taxes paid for each employee.
Totals for each company.
Grand totals for the tax identification number of the company.

The information provided in this report is based on the Tax History table (F06136).

Processing Options for 940 Quarterly Worksheet (R078502)

Processing options enable you to specify the default processing for programs and reports.

Process

Use these processing options to specify the data that the system uses to process the report.

1. Enter the Quarter number being processed.

Specify the number that corresponds to the fiscal quarter for which you are processing the report. Values are:

1: First quarter

2: Second quarter

3: Third quarter

4: Fourth quarter

2. Enter the value for report inclusions/exclusions.

Specify whether to include contract and pension employees on the report. Values are:

1: Include pension employees only.

2: Include contract employees only.

3: Include all employees.

Blank: Do not include pension or contract employees. Blank is the default.

R078506 - Form 941 Schedule B Report

The Form 941 Schedule B report (R078506) is a supplement to the 941 Wage Detail List 1 report (R078500). The 941 Schedule B report summarizes the company's daily tax liability for these items:

Income tax withheld.
Employer-paid Social Security tax withheld.
Employee-paid Social Security tax withheld.
Employer-paid Medicare tax withheld.
Employee-paid Medicare tax withheld.

Depending upon the industry in which the organization does business, the local taxing authority might require you to file this report along with the 941 Detail Wage List. Contact the taxing authority for additional information about 941 reporting requirements.

Processing Options for the Form 941 Schedule B Report (R078506)

Processing options enable you to specify the default processing for programs and reports.

Process

These processing options enable you to specify the time period that the system uses to generate the report.

1. Calendar Quarter	Specify the number that corresponds to the calendar quarter for which you are processing the tax liability. If left blank, the report does not produce any output. Values are: 1: First quarter 2: Second quarter 3: Third quarter 4: Fourth quarter
2. Year	Specify the four-digit year of the reporting period. If left blank, the report does not produce any output.
3. Prior Period Adjustment Amount	Specify a tax liability adjustment from a prior period. If the adjustment amount corrects an overreported liability, enter the liability adjustment as a negative amount. Otherwise, enter the liability adjustment as a positive amount to correct an underreported liability.
4. Liability Adjustment Discovery Date	Specify the date that the liability adjustment was discovered. The system will use the date entered to determine the entry space on the form that corresponds to the date that the error was discovered. This option is required if the Prior Period Adjustment Amount option is populated with an amount.

R078507 – 940 Annual Worksheet Report

The 940 Annual Worksheet lists annual unemployment tax information for the selected company. Most employers pay federal and state unemployment tax, which requires using the Employer’s 940 Annual Federal Unemployment Tax Return. The Federal Unemployment Tax Act (FUTA), together with state unemployment agencies, provides for payments of unemployment compensation to workers who have lost their jobs.

Processing Options for the 940 Annual Worksheet Report (R078507)

Processing options enable you to specify the default processing for programs and reports.

Process

Use these processing options to specify the data that the system uses to process the report.

1. Calendar Year	Specify the calendar year processed by the 940 Annual Worksheet report.
2. State Unemployment Contributions Paid	Specify if you paid all state unemployment contributions by January 31. Values are: Blank: Yes (Default) Y:Yes N:No
3. All FUTA Wages Taxable for Sate UI Tax	Specify if all wages that were taxable for FUTA were also taxable for your state's unemployment tax. Values are: Blank: No (Default) Y:Yes N:No
4. Wages Paid in New York	Specify if there were any wages paid in the state of New York for the calendar year reported on the 940 Annual Worksheet report. Values are: Blank: No (Default) Y:Yes N:No
5. Worksheet for Credit Computation Amount	Specify the amount that was calculated by using the Worksheet for Credit Computation, which is included in the separate instructions for Form 940. Only taxpayers who made late contributions need to complete this worksheet.

Rates

Use these processing options to specify the rates the system processes for the report.

1. FUTA Tax Rate	Specify the tax rate used to calculate the quarterly Federal unemployment tax liability in part III of the 940 Annual Worksheet report. The default is .008.
2. Gross FUTA Tax Rate	Specify the tax rate used to calculate the gross FUTA tax amount. The default is .062.
3. Maximum Credit Rate	Specify the tax rate used to calculate the maximum credit amount. The default is .054.