59 Periodic Reports Processing Options

This chapter contains these topics:

• Section 59.1, "941 Worksheet (P068500) (Release 9.3.x 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, "Veterans' Employment by B.U. & Company (P080434),"

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

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

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

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

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

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

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

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

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

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

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

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

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

59.1 941 Worksheet (P068500) (Release 9.3.x Update)

Processing Option	Processing Options Requiring Further Description
1. Enter the quarter number being processed. 1st Quarter = 1 2nd Quarter = 2 3rd Quarter = 3 4th Quarter = 4
2. Enter the employee Social Security tax rate as a decimal fraction (that is, 4.2% entered as .042) Enter the employer Social Securitytax rate as a decimal fraction (that is, 6.2% entered as .062)
3. 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. Current Quarter's Adjustments: Option 4 is for entering an adjustment for line 7c of the 941 form. If the adjustment has already been entered into tax history, leave the option blank.
4. Enter current quarter's adjustments for tips and group-term life insurance. (Format: 999999999.99)
5. 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)
6. Enter the COBRA premium payments (see instructions). (Format: 999999999.99)
7. Enter the number of individuals provided COBRA premium assistance reported in processing option 6.
8. Enter 'Y' to receive a refund for an overpayment. Answering 'N' will apply overpayments towards your next return. (Default is 'Y')
9. 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')
10. Enter 'Y' to print the Detail Wage List. (Default is 'N')
11. Enter 'Y' to create F068500 records. (941 Federal Tax History Summary) (Default is 'N')
12. Enter the amount of tax due on unreported tips (Section 3121(q) Notice and Demand)
13. Qualified Small Business Payroll Tax Credit for Increasing Research Activities.

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.3 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: ' ' '1' '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 Veterans' Employment by B.U. & Company (P080434)

Processing Option	Processing Options Requiring Further Description
Enter the Beginning and Ending dates for the reporting period. Beginning Date - Ending Date - Enter the 9 digit Dun and Bradstreet ID number.

59.13 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.14 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.15 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.16 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.17 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.18 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.19 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.20 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.21 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.22 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.23 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.

59.24 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.25 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.