59 Periodic Reports Processing Options

This chapter contains these topics:

• Section 59.1, "941 Worksheet (P068500) (Release A9.4 Update),"

• Section 59.2, "940 Quarterly Worksheet (P068502),"

• Section 59.3, "940 Annual Worksheet (P068503),"

• Section 59.4, "State Income Tax Report (P068400),"

• Section 59.5, "Local Income Tax Report (P068401),"

• Section 59.6, "Workers Compensation/General Liability Report (P06343),"

• Section 59.7, "Workers Compensation/General Liability Summary (P06343),"

• Section 59.8, "EEO-1 Maintenance & Survey (P05851),"

• Section 59.10, "EEO-4 Report (P068514A),"

• Section 59.11, "EEO Staff Utilization Report (P068900),"

• Section 59.12, "Railroad Retirement BA-3a (P068513),"

• Section 59.13, "Job Billing Register (P063200),"

• Section 59.14, "Job Billing Register - Detail (P063201),"

• Section 59.15, "Job Billing - Work Center by Job (P063301),"

• Section 59.16, "Job Billing Health & Welfare - Detail (P063121),"

• Section 59.17, "Job Billing Health & Welfare - Summary (P063122),"

• Section 59.18, "Job Billing Register - Summary (P063211),"

• Section 59.19, "Job Billing - PL & PD by Job (P063302),"

• Section 59.20, "Certified Payroll Report (P06371),"

• Section 59.21, "Health & Welfare by Payee & Union (P063142),"

• Section 59.22, "Union Distribution Report (P063151),"

• Section 59.23, "Health & Welfare by Employee (P063112),"

• Section 59.24, "Health & Welfare by Payee & Employee (P063132)."

59.1 941 Worksheet (P068500) (Release A9.4 Update)

Processing Option	Processing Options Requiring Further Description
1. Enter the number of quarter being processed. 1st Quarter = 1 2nd Quarter = 2 3rd Quarter = 3 4th Quarter = 4
2. Lines 5a and 5b - Enter the employee Social Security tax rate as a decimal fraction (that is 6.2% entered as .062)
3. Lines 5a and 5b - Enter the employer Social Security tax rate as a decimal fraction (that is 6.2% entered as .062)
4. Lines 5a i- Qualified sick leave wage Paid Sick Leave Employee Pay Type 1 Pay Type 2 Pay Type 3
5. Lines 5a ii- Qualified family leave wages FMLA Expansion Pay Type 1 Pay Type 2 Pay Type 3 Paid Sick Leave - Family Care Pay Type 1 Pay Type 2 Pay Type 3
6. Line 5c - Enter the Medicare tax rate as a decimal fraction (that is, 1.45% entered as .0145). The detail wage list will show employee withholding for Social Security and Medicare. These amounts will be doubled on the 941 tax return to reflect employee and employer taxes. For example, .062 will appear on the 941 report as .124 and .0145 will appear on the 941 report as .0290.
7. Line 5d - Enter the additional Medicare tax rate as a decimal fraction (that is, .9% entered as .009).
8. Line 5f - Enter the amount of tax due on unreported tips (Section 3121(q) Notice and Demand)
9. Line 9 - Enter current quarter's adjustments for tips and group-term life insurance. If adjustment is already in tax history, leave blank.
10. Line 11a - Qualified Small Business Payroll Tax Credit for Increasing Research Activities
11. Line 11b - Nonrefundable portion of credit for qualified sick and family leave wages from Worksheet 1
12. Line 11c - Nonrefundable portion of employee retention credit from Worksheet 1
13. Line 11d - Nonrefundable portion of credit for qualified sick and family leave wages for leaves taken after March 31, 2021
14. Line 11e - Nonrefundable portion of COBRA premium assistance credit (See instructions for applicable quarters).
15. Line 11f - Number of individuals provided COBRA premium assistance
16. Line 13a - Enter total deposits for this quarter, including overpayment applied from a prior quarter and overpayment applied from Form 941-X or Form 944-X. (Format: 999999999.99)
17. Line 13 b - Reserved for future
18. Line 13 c - Refundable portion of credit for qualified sick and family leave wages for leaves taken before April 1, 2021
19. Line 13 d - Refundable portion of employee retention credit from Worksheet 1.
20. Line 13e - Refundable portion of credit for qualified sick and family leave wages for leaves taken after March 31, 2021
21. Line 13 f - Refundable portion of COBRA premium assistance credit (See instructions for applicable quarters).
22. Line 13 h- Total advances received from filing Form(s) 7200 for the quarter
23. Enter 'Y' to create F068500 records. (941 Federal Tax History Summary) (Default is 'N')
24. Enter 'Y' to receive a refund for overpayment. Answering 'N' will apply overpayments towards your next return. (Default is 'Y')
25. Enter an 'M' if you were a monthly schedule depositor for the entire quarter - OR- enter an 'S' if you were a semiweekly schedule depositor for any part of this quarter. (Default is 'M')
26. Enter 'Y' to print the Detail Wage List. (Default is 'N')
27. Lines 21 - Qualified wages for the employee retention credit Pay Type 1 Pay Type 2 Pay Type 3
28. Are you a qualified employer for the employee retention credit? Blank = No Y = Yes Enter 'Y' if you are a qualified employer eligible for the employee retention credit, as defined in the CARES Act.
29. Employer Tax ID If you enter an Employer Tax ID, it will be used to select timecard history.
30. Line 19 - Qualified health plan expenses allocable to qualified sick leave wages for leaves taken before April 1, 2021
31. Line 20 - Qualified health plan expenses allocable to qualified family leave wages for leaves taken before April 1, 2021
32. Line 22 - Qualified health plan for the employee retention credit
33. Line 24 - Qualified health plan expenses allocable to qualified sick leave wages reported on Line 23
34. Line 25 - Amounts under certain collectively bargained agreements allocable to qualified sick leave wages reported on Line 23
35. Line 27 - Qualified health plan expenses allocable to qualified family leave wages reported on Line 26
36. Line 28 - Amounts under certain collectively bargained agreements allocable to qualified family leave wages reported on Line 26

59.2 940 Quarterly Worksheet (P068502)

Processing Option	Processing Options Requiring Further Description
1. Specify the calendar quarter to be included in this payroll report. Calendar Quarter 1 - Enter a 1 " " 2 - Enter a 2 " " 3 - Enter a 3 " " 4 - Enter a 4
2. Report inclusion/exclusions: '1' to include pension employees, '2' to include contract employees, '3' to include all employees. Default is ' ' for exclusion of pension and contract employees.

59.3 940 Annual Worksheet (P068503)

Processing Option	Processing Options Requiring Further Description
1. Enter the state abbreviation if you were required to pay state unemployment tax in only one state. Otherwise leave blank. Enter the percentage used to calculate the following taxes. Example: If the percentage is 6.2%, enter .062
2. The FUTA Tax rate. (The default is .006)
3. The Gross FUTA Tax rate. (The default is .060)
4. The Maximum Credit rate. (The default is .054)
5. Enter 'Y' if all taxable FUTA wages you paid were excluded from state unemployment tax. Otherwise enter 'N' and enter an amount in #6. (The default is 'Y')
6. If you entered 'N' for #5 fill out the worksheet in the Form 940 instructions and enter the amount from line 7. Otherwise leave blank. (Format: 9999999.99)
7. Enter 'Y' to receive a refund for an overpayment. Answering 'N' will apply overpayments towards your next return. (The default is 'Y')

59.4 State Income Tax Report (P068400)

Processing Option	Processing Options Requiring Further Description
1. Enter the range of dates to be included in this report in month and year format (MM/YY): From Date: Thru Date:
2. Report inclusion/exclusions: '1' to include pension employees, '2' to include contract employees, '3' to include all employees. Default is ' ' for exclusion of pension and contract employees.

59.5 Local Income Tax Report (P068401)

Processing Option	Processing Options Requiring Further Description
1. Enter the range of dates to be included in this report in month and year format - (MM/YY): From Date: Thru Date:
2. Enter '1' to print the employees address. Default = ' '.
3. Enter '1' to print employees with no wages. Default = ' '.

59.6 Workers Compensation/General Liability Report (P06343)

Processing Option	Processing Options Requiring Further Description
Enter type of report to be processed: W = Workers Compensation Ins. Report G = General Liability Ins. Report
Report Heading Date Stipulation: From - Thru - Note: Dates are for documentation only. Use DW selections for date range.
Select which employee number to print: A = Address Book Number S = Social Security Number O = Other Employee Number If you wish to display County/Provincial Information enter 'Y'. (Y/N) Default = N

59.7 Workers Compensation/General Liability Summary (P06343)

Processing Option	Processing Options Requiring Further Description
Enter type of report to be processed: W = Workers Compensation Ins. Report G = General Liability Ins. Report
Report Heading Date Stipulation: From - Thru - Note: Dates are for documentation only. Use DW selections for date range.
Select which employee number to print: A = Address Book Number S = Social Security Number O = Other Employee Number If you wish to display County/Provincial Information enter 'Y'. (Y/N) Default = N

59.8 EEO-1 Maintenance & Survey (P05851)

Processing Option	Processing Options Requiring Further Description
1. Designate the relationship for your EEO-1 reporting locations: Blank = Company with home business units and reporting company assigned to employees in Employee Master 1 = Parent company with subsidiary companies 2 = Company with home business units and reporting company NOT assigned to employees in Employee Master

59.9 (Release A9.4 Update) EEO-1 Component 2 (P05851A)

Processing Option	Processing Options Requiring Further Description
1. Designate the relationship for your EEO-1 reporting locations: Blank = Company with home business units and reporting company assigned to employees in Employee Master 1 = Parent company with subsidiary companies 2 = Company with home business units and reporting company NOT assigned to employees in Employee Master
2. Year End ID for Component 2	The Year-End ID that the system should use to retrieve the employee's W-2 Box 1 information. The Component 2 report uses this data for pay band processing in the report.
3. Hours Worked Report Method for Exempt Employees 1 = Proxy (20/40 hours x Weeks employed) 2 = Actual hours worked	The number of hours worked by the exempt (salaried) employees.
4. Is Est Federal 1 = Yes 2 = No

59.10 EEO-4 Report (P068514A)

Processing Option	Processing Options Requiring Further Description
1. Please enter starting salary for each salary range below. Enter real dollars, i.e., 8000 instead of 8,000 or 8.0. Beginning Salary for Range 1 " Range 2 " Range 3 " Range 4 " Range 5 " Range 6 " Range 7 " Range 8
2. Enter Beginning Date of Report Period Enter Ending Date.
3. Enter address book number of jurisdiction being reported.
4. Enter Jurisdiction Control Number.
5. Enter the Employment Status Code(s) to identify full time employees. (Enclose in quotes and separate with a space. Ex: ' 'or '1' or '2')
6. Enter the data item for the payroll category code (ex. P001 - P020) that contains the employee's function code
7. Enter address book number of EE0-4 Contact Person.
8. Enter address book number of Company EE0-4 Contact Person reports to.
9. Enter address book number of Certifying Official.
10. Enter 'U' to use the Employee Hourly Rate from the Union Pay Rate Table. Blank will default the rate from the Employee Master.
11. Enter the Directory you would like your .TXT file to be written to. If left blank, it will go to a default location. Note: The Directory path should be specified with beg/end slashes. For example: /HOME/

59.11 EEO Staff Utilization Report (P068900)

Processing Option	Processing Options Requiring Further Description
1. Enter From date:
2. Enter To date:
3. Enter non-ethnic code: 4. To select only one business unit, enter the business unit number. (It must be right adjusted in the first twelve characters.) Leave blank to print all business units.

59.12 Railroad Retirement BA-3a (P068513)

Processing Option	Processing Options Requiring Further Description
1. Enter Maximum RUIA Compensation.
2. Enter Maximum Tier I Compensation.
3. Enter Maximum Tier II Compensation.
4. Enter the type of output desired: 1 = Magnetic tape 2 = Report 3 = File (File name is F068513)
5. Enter the Payroll Location number.
6. If "3" for File was selected in Option 4 above, enter the name of the library where the file should reside.

59.13 Job Billing Register (P063200)

Processing Option	Processing Options Requiring Further Description
1. Enter range of Dates to be included in the processing: From - Thru
2. Enter type of date ranges as above: Wrk Dt/PPED - ' ' = Work Dates '1' = Pay Per. End
3. Enter '1' to produce : Job Billing Register Detail P063201 Job Billing Register Summary P063211 Job Billing H & W Detail P063121 Job Billing H & W Summary P063122 Job Billing W/C by Job P063301 Job Billing PL & PD by Job P063302
4. Enter version number for: Job Billing Register Detail P063201 Job Billing Register Summary P063211 Job Billing H & W Detail P063121 Job Billing H & W Summary P063122 Job Billing W/C by Job P063301 Job Billing PL & PD by Job P063302

59.14 Job Billing Register - Detail (P063201)

Processing Option	Processing Options Requiring Further Description
1. Detail or summary: ' ' = Detail '1' = Summarize
2. Select employee number to print: A = Address Book Number S = Social Security Number O = Third Employee Number
3. Enter '1' to include payroll burden costs. '0' = No '1' = Yes Note: YOU MUST HAVE CREATED DETAILED BURDEN RECORDS (F0624) TO REPORT THEM.

59.15 Job Billing - Work Center by Job (P063301)

Processing Option	Processing Options Requiring Further Description
1. Select employee number to print: A = Address Book Number S = Social Security Number O = Third Employee Number
2. Include payroll burden costs: ' ' = No '1' = Flat Burden '2' = Actual Burden
Note: YOU MUST HAVE CREATED DETAILED BURDEN RECORDS (F0624) TO REPORT ACTUAL.

59.16 Job Billing Health & Welfare - Detail (P063121)

Processing Option	Processing Options Requiring Further Description
1) Select employee number to print: A = Address Book Number S = Social Security Number O = Third Employee Number
2) Include payroll burden costs: ' ' = No '1' = Flat Burden '2' = Actual Burden
Note: YOU MUST HAVE CREATED DETAILED BURDEN RECORDS (F0624) TO REPORT ACTUAL.

59.17 Job Billing Health & Welfare - Summary (P063122)

Processing Option	Processing Options Requiring Further Description
1) Include payroll burden costs: ' ' = No '1' = Flat Burden '2' = Actual Burden
Note: YOU MUST HAVE CREATED DETAILED BURDEN RECORDS (F0624) TO REPORT ACTUAL.

59.18 Job Billing Register - Summary (P063211)

Processing Option	Processing Options Requiring Further Description
1. Include payroll burden costs: ' ' = No '1' = Yes
NOTE: YOU MUST HAVE CREATED DETAILED:
BURDEN RECORDS (F0624) TO REPORT THEM.:
2. Summarize benefits: ' ' = Do not summarize '1' = Summarize by benefit '2' = Summarize all benefits

59.19 Job Billing - PL & PD by Job (P063302)

Processing Option	Processing Options Requiring Further Description
1. Select employee number to print: A = Address Book Number S = Social Security Number O = Third Employee Number
2. Include payroll burden costs: ' ' = No '1' = Flat Burden '2' = Actual Burden
Note: YOU MUST HAVE CREATED DETAILED BURDEN RECORDS (F0624) TO REPORT ACTUAL.
3. General Liability set up as 'GENL' on Worker's Comp Table: '1' = Yes

59.20 Certified Payroll Report (P06371)

Processing Option	Processing Options Requiring Further Description
1. Enter the Pay Period Ending Date to be processed.
2. Enter Period Number. If left blank, the period number from the fiscal date patterns will be printed.
3. Enter '1' to display deductions in total or a default of blank will cause the deductions to display in detail.
4. Enter '1' to display "Fringe Detail" IF PRINTING "FRINGE DETAIL", THE FORM WIDTH MUST BE SET TO 162.
5. Include Jobs that are closed or have not started (Posting edit code = 'N') Y = Yes - include in report N = No - omit from report Default is 'N' - omit from report
6. Employee Social Security Number: Blank = Print entire SSN on report. 1 = Print only last 4 digits of SSN. 0 = Omit SSN from report.
7. Employee address: Blank = Print employee address. 1 = Omit employee address.
8. Employee phone number: Blank = Print employee phone number 1 = Omit employee phone number

59.21 Health & Welfare by Payee & Union (P063142)

Processing Option	Processing Options Requiring Further Description
1) Enter range of dates to be included in the processing: From - Thru -
2) Above dates by Pay Period End, or Work Dates: ' ' = Work Dates '1' = Pay Per. End
3) Enter '1' for a total page by payee.

59.22 Union Distribution Report (P063151)

Processing Option	Processing Options Requiring Further Description
Specify the Pay Period Ending Date to be printed on this report. Note: This date is informational; you need to specify the date range in data selection to be processed.
2) Select employee number to print: A = Address Book Number S = Social Security Number O = Third Employee Number

59.23 Health & Welfare by Employee (P063112)

Processing Option	Processing Options Requiring Further Description
1) Enter range of dates to be included in the processing: From - Thru - 2) Enter type of date range as above Work/PPED - ' ' = Work Dates '1' = Pay Per. End 3) Enter '1' for a total page by payee. 4) Select employee number to print: A = Address Book Number S = Social Security Number O = Third Employee Number

59.24 Health & Welfare by Payee & Employee (P063132)

Processing Option	Processing Options Requiring Further Description
1. Enter Range of dates to be included in the processing: From - Thru - 2. Enter type of date ranges as above: Wrk Dt/PPED- ' ' = Work Dates '1' = Pay Per. End 3. Enter '1' for a total page by payee.
4. Select employee number to print: A = Address Book Number S = Social Security Number O = Third Employee Number 5. Enter 'Y' to suppress print of wages.