This appendix contains the following topics:
Section A.1, "JD Edwards EnterpriseOne U.S. Payroll Reports: A to Z"
Section A.2, "JD Edwards EnterpriseOne U.S. Payroll: Selected Reports"
This table lists the U.S. Payroll reports, sorted alphanumerically by report ID.
These reports are listed alphanumerically by report ID in this appendix.
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:
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.
Processing options enable you to specify the default processing for programs and reports.
These processing options are used to define the default information that is used to process the report.
Specify the pay period to use to generate the certified payroll register. This processing option is 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.
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.
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.
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.
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):
Processing options enable you to specify the default processing for programs and reports.
Use these processing options to specify which data the system uses to process the report.
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
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.
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 enable you to specify the default processing for programs and reports.
Use this processing option to specify the data that the system uses to process the 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
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 enable you to specify the default processing for programs and reports.
Specify the employer's legal name.
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.
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
Specify the four-digit year of the reporting period.
Specify the month, day, and year of the first Saturday in the fiscal quarter for which you are processing the 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 enable you to specify the default processing for programs and reports.
These processing options are used to determine how the system processes data for this report.
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
Specify the two-digit year of the reporting period. If left blank, the report does not produce any output.
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.
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.
Specify your deposits for this quarter, including overpayment applied from a previous quarter.
Specify if you were a monthly schedule depositor for the entire quarter.
Use these processing options to specify the rates the system processes for the report.
Specify the FICA rate. Enter the rate as a decimal fraction. For example, enter .062 for 6.2 percent.
Specify the Medicare rate. Enter the rate as a decimal fraction. For example, enter .0145 for 1.45 percent.
Use these processing options to specify monetary tax adjustments the system processes for the report.
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.
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.
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.
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.
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.
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 enable you to specify the default processing for programs and reports.
Use these processing options to specify the data that the system uses to process the 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
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.
The 943 Wage Detail List program (R078505) was unintentionally omitted from previous J.D. Edwards EnterpriseOne U.S. Payroll publications. This documentation describes the R078505 and lists the processing options that you set before running the report. You run the 943 Wage Detail List program to report federal income tax withheld and employer and employee social security and Medicare taxes on wages paid to farm workers. The program is located on the Government Reporting menu (G05BG).
Use the processing options on this tab to specify how the report processes data.
Use this processing option to enter the FICA rate. Enter this rate as a decimal fraction. For example, enter .062 to indicate 6.2 percent.
Use this processing option to enter the Medicare rate. Enter this rate as a decimal fraction. For example, enter .0145 to indicate 1.45 percent.
Use this processing option to specify whether to print the Employee Detail Wage List report. This report shows employee withholding for Social Security (FICA) and Medicare taxes. Values are:
N: Do not print. (Default)
Y: Yes, print the report.
Note that the withholding amounts are doubled on the 943 tax return to reflect both employee and employer taxes. For example, if the employee withholding amount for FICA is .62, the 943 report shows .124 for FICA.
Use this processing option to enter the adjustment amount. Enter a negative amount if subtracting from taxes. Enter a positive amount if adding to taxes.
Use this processing option to enter the amount of the total tax deposit. This amount will be subtracted from net taxes and it should always be a positive amount.
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 enable you to specify the default processing for programs and reports.
These processing options enable you to specify the time period that the system uses to generate the report.
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
Specify the four-digit year of the reporting period. If left blank, the report does not produce any output.
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.
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.
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 enable you to specify the default processing for programs and reports.
Use these processing options to specify the data that the system uses to process the report.
Specify the calendar year processed by the 940 Annual Worksheet report.
Specify if you paid all state unemployment contributions by January 31. Values are:
Blank: Yes (Default)
Y: Yes
N: No
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
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
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.
Use these processing options to specify the rates the system processes for the report.
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.
Specify the tax rate used to calculate the gross FUTA tax amount. The default is .062.
Specify the tax rate used to calculate the maximum credit amount. The default is .054.
Use this processing option to enter the credit dollar amount for timely state unemployment tax payments. For example, how much did you pay on time? Contact your taxing authority to help you determine what amount to enter in this option.
Use this processing option to specify the single state experience rate. Enter a value in this option only if the experience rate was less than .054.
Use this processing option to specify whether you have multi-state experience rates that were less than .054. Values are:
Blank or N: No
Y: Yes
Use this processing option to enter the dollar amount of state unemployment tax that you paid late.