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
R07136 Repost Tax Ledger to Tax Summary -F06166 to F06136 Report	Use the Repost Tax Ledger to Tax Summary -F06166 to F06136 report to select all tax detail records with tax type N (School District) in the F06166 table and modify records in the F06166A and F06136A tables. You must run this report once to generate data in the F06136A and F06166A tables. Note: If F06166A and F06136A tables have data, and you run the Repost Tax Ledger to Tax Summary -F06166 to F06136 report, the system will duplicate Tax History records. This will lead to overstated tax amounts.	Type R07136 in the Fast Path field.
R07136A Populate Tax History tables (F06136A & F06166A) Report	Use the Populate Tax History tables (F06136A & F06166A) report to select records in F06166A and update F06136A. This report selects data based on the processing options.	Type R07136A in the Fast Path field.
(Release 9.2 Update) R07146 Crosscheck Federal Taxable Wages Between F06146 and F06136 Report	Use the Crosscheck Federal Taxable Wages Between F06146 and F06136 report to cross-check the F06136 and F06146 tables and find any missing wages. This report selects data based on the processing options.	Enter BV in the Fast Path field, and then enter R07146 in the Batch Application field on the Available Versions form.
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 (Release 9.2 Update) Credits and advances available to employers due to the Families First Coronavirus Response Act (FFCRA) and Coronavirus Aid, Relief, and Economic Security (CARES) legislations. (Release 9.2 Update) To comply with the FFCRA and CARES legislations passed by the US government, the Internal Revenue System (IRS) has made changes to the Form 941 Employer Quarterly Tax Return that are due with the 2nd Quarter 2020 return. The 941 Detail Wage List report includes new lines on Part 1 and Part 3 to reflect most of these changes. However, you need to calculate amounts that cannot be accumulated from the system.	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
R079430D Prevailing Wage Transaction Detail Report	Use the Prevailing Wage Transaction Detail report (R079430D) to review detail information about the prevailing wage transactions processed for each timecard included in the prevailing wage calculation.	Enter BV in the Fast Path field, and then enter R079430D in the Batch Application field on the Available Versions form.
R079430S Prevailing Wage Transaction Summary Report	Use the Prevailing Wage Transaction Summary report (R079430S) to review summary information about the prevailing wage transactions processed for each timecard included in the prevailing wage calculation.	Enter BV in the Fast Path field, and then enter R079430S in the Batch Application field on the Available Versions form.
R079440 Prevailing Wage History Report	Use the Prevailing Wage History report (R079440) to review historical information about prevailing wage transactions processed for a timecard.	Enter BV in the Fast Path field, and then enter R079440 in the Batch Application field on the Available Versions form.