Revised Form 941 for Reporting COVID-19 Tax Credits

The IRS issued a draft of revised Form 941 to allow for the reporting of tax credits related to COVID-19. The qualified sick leave wages and qualified family leave wages have been added under the taxable social security wages 5a in Part 1 of the form. The credit for sick and family wages and the employee retention credit have been likewise added to the form. In compliance with the reporting requirements of Form 941, the existing Federal 941 Data section of the Quarterly Federal Payroll Tax Report in Costpoint was updated and transferred to a new report. This newly added report, Federal 941 Data and Tax Credit Report, shall also contain the information on the following three new COVID-19 tax credits:

• Credit for qualified sick leave wages

• Credit for qualified family leave wages

• Employee retention credit

Application Updates

Manage Pay Type Taxability (PRMPAYTT)

The screen contains the following new field:

Field

Description

COVID-19 Tax Credit

From the drop-down list, select one of following options to designate the pay type taxability : COVID-19 Paid Sick Leave: Select this option if the pay type is used for wages paid as a result of Emergency Paid Sick Leave Act (EPSLA). COVID-19 FMLA: Select this option if the pay type is used for wages paid as a result of Emergency Family and Medical Leave Expansion Act (EFMLEA). This field will be enabled if the Employer Social Security Exempt check box is selected and the Employee Social Security Exempt check box is cleared.

Print Quarterly Federal Payroll Tax Report (PRRFDTAX)

The Print Quarterly Federal Payroll Tax Report screen contains the following new group boxes and fields:

• COVID-19 Paid Sick Leave and FMLA

This group box contains the fields where the qualified expenses allocable to qualified sick leave wages and qualified family leave wages can be specified to be included in the calculation of tax credit. Also included is a field to specify the nonrefundable credits already used against the employer social security.

Field	Description
Qualified health plan expenses allocable to qualified sick leave wages	If there are qualified health plan expenses allocable to qualified sick leave wages, you must enter the amount in this field to include it in the calculation of tax credit for COVID-19 Paid Sick Leave wages.
Qualified health plan expenses allocable to qualified family leave wages	If there are qualified health plan expenses allocable to qualified family leave wages, you must enter the amount in this field so it will be included in the calculation of tax credit for COVID-19 FMLA wages.
Nonrefundable credits already used against the employer social security	If applicable, enter the amount from Form 941, line 11a (credit from Form 8974), plus the amount to be claimed on Form 5884-C for this quarter. If you are a third-party payer of sick pay that is not an agent, and you are claiming credits for amounts paid to your employees, then add the employer share of social security tax included on Form 941 line 8 in the amount of this field.

• Employee Retention Credit

This group box contains the fields related to employee retention credit of CARES Act.

Field	Description
Eligible for Employee Retention Credit	Select this check box to include employee retention credit in the calculation of the Federal 941 Data and Tax Credit Report. When you select this check box, the application will enable the fields used for entering the amount for qualified health plan expenses allocable to qualified wages for the employee retention credit.
Qualified health plan expenses	If there are qualified health plan expenses allocable to qualified wages for the employee retention credit, you must enter the amount in this field to include it in the calculation of tax credit.
Qualified health plan expenses for Mar 13 – 31, 2020	If there are qualified health plan expenses allocable to qualified wages paid March 13, 2020 through March 31, 2020 for the employee retention credit, you must enter the amount in this field to include it in the calculation of tax credit. Enter an amount here only for the second quarter Form 941.

The Federal 941 Data section was removed from the Quarterly Federal Tax Payroll Report. The section is now a new separate report named “Federal 941 Data and Tax Credit Report”, which is generated after the Quarterly Federal Tax Report.

Export Payroll Taxes (PRPEXTAX)

This release adds the following to the tax file generated by the Export Payroll Taxes screen:

• New fields in Employee Tax (ET) Record - Employer Social Security Tax (SSER) for the Check, QTD, and YTD amounts of COVID-19 Sick Leave Wages

• New fields in Employee Tax (ET) Record - Employer Social Security Tax (SSER) for the Check, QTD, and YTD amounts of COVID-19 Family Leave Wages

• New fields in Employee Tax (ET) Record - Employee Social Security Withholding (SSEE) for the Check, QTD, and YTD amounts of COVID-19 Sick Leave Wages limited by the social security wage base

• New fields in Employee Tax (ET) Record - Employee Social Security Withholding (SSEE) for the Check, QTD, and YTD amounts of COVID-19 Family Leave Wages limited by the social security wage base

Print Data Dictionary Report (SYRDD)

The report now provides information for the new COVID-19 Tax Credit (None/EPSLA/EFMLEA) (COVID_TAX_CREDIT) column in the Pay Type Taxability (PAY_TYPE_TXBL) database table.

Track Employer Portion of Social Security and Medicare Taxes for COVID-19 Tax Credit

The Families First Coronavirus Response Act (FFCRA) gives businesses with fewer than 500 employees (Eligible Employers) funds to provide employees with paid sick leave and family and medical leave for reasons related to COVID-19. The reasons can be either for the employee's own health needs or to care for family members.

The eligible employer is entitled to a fully refundable tax credit equal to the required paid sick leave and equal to the required paid family and medical leave (qualified family leave wages). This tax credit also includes the eligible employer’s share of Medicare tax imposed on those wages and its allocable cost of maintaining health insurance coverage for the employee during the sick leave period (qualified health plan expenses), and its cost of maintaining health insurance coverage for the employee during the family leave.

Note: The eligible employer is not subject to the employer portion of social security tax imposed on those wages.

Currently, social security taxes can be flagged as “Exempt” on the Manage Pay Type Taxability screen, and this indicates exemption from both employee and employer portion. There is no way to indicate if a pay type is exempt from either the employer portion only or the employee portion. The same is true for Medicare taxes.

Due to the requirement in FFCRA wherein any wages paid as a result of the Emergency Paid Sick Leave Act and the Emergency Family and Medical Leave Expansion Act are not subject to the employer portion of social security taxes, the ability to track separately the employer portion of social security taxes and Medicare taxes will be added in Costpoint. Accordingly, Costpoint will now track both the employee and employer FICA taxes amounts (taxable and exempt pay type) throughout the Payroll module. This feature is not only for tracking the FICA taxability of COVID-19 pay types, but also for other similar future requirements.

Application Updates

Manage Pay Type Taxability (PRMPAYTT)

The screen now provides the ability to set the taxability of the employer portion of social security and Medicare taxes. To support the new functions, this release applies the following updates to the screen:

• A new Social Security group box allows you to select the following FICA fields related to social security:

Field	Description
Employee Social Security Exempt	Select this check box if the pay type is exempt from the employee portion of the social security taxes. When you select this check box, the screen automatically selects and disables the Employer Social Security Exempt check box because if the pay type is exempt from the employee portion of the social security tax, then the employer portion will always be exempt. When you clear this check box, the screen automatically enables the Employer Social Security Exempt check box because if the pay type is not exempt from the employee portion of the social security tax, then the employer portion can either be exempt or not.
Employer Social Security Exempt	Select this check box if the pay type is exempt from the employer portion of social security taxes.

• A new Medicare group box allows you to select the following FICA fields related to Medicare:

Field	Description
Employee Medicare Exempt	Select this check box if the pay type is exempt from the employee portion of the Medicare taxes. When you select this check box, the screen automatically selects the Employer Medicare Exempt check box because if the pay type is exempt from the employee portion of the Medicare tax, then the employer portion will always be exempt. When you clear this check box, the screen automatically selects the Employer Medicare Exempt check box because if the pay type is not exempt from the employee portion of the Medicare tax, then the employer portion will always be not exempt.
Employer Medicare Exempt	Select this check box if the pay type is exempt from the employer portion of the Medicare taxes. This field is not editable.

Export Payroll Taxes (PRPEXTAX)

This Costpoint release updates the source of the exempt pay type amount and taxable amount of the employer portion of social security and Medicare taxes in the generated tax file.

The following fields were added to the Employer Social Security Tax (SSER) record:

• Field 70: CHECK COVID-19 Sick Leave Amount

• Field 71: QTD COVID-19 Sick Leave Amount

• Field 72: YTD COVID-19 Sick Leave Amount

• Field 73: CHECK COVID-19 Family Leave Amount

• Field 74: QTD COVID-19 Family Leave Amount

• Field 75: YTD COVID-19 Family Leave Amount

Employer Social Security Tax (SSER) Record Layout

Field #	Field	Included in Total			Applicable Reporting				Type	Notes
		Check Totals	QTD Totals	YTD Totals	Periodic (Check)	Quarterly	Annual	W-2
1	Record Indicator				Y	Y	Y	N	VARCHAR2(2)	ET: Employee Tax record
2	Tax Service Company ID				Y	Y	Y	N	VARCHAR2(25)	This is the company Identifier as assigned by the payroll tax service.
3	Tax Service Group ID				Y	Y	Y	N	VARCHAR2(25)	This is the grouping number assigned to the employee.
4	Employer/Agent Identification Number (EIN)				Y	Y	Y	N	VARCHAR2(30)	This is the Tax ID assigned to the taxable entity being reported.
5	Employee ID				Y	Y	Y	N	VARCHAR2(12)	This is the unique Costpoint identifier for the employee.
6	Employee SSN				Y	Y	Y	N	NUMBER(9)	Format: 9999999999
7	Paycheck Type				Y	N	N	N	VARCHAR2(1)	This is populated with the type of check being reported: R = Regular B = Bonus V = Void (Reversal) W = Replacement X = Manually entered check Y = Manually entered check This applies to periodic (check) reporting only.
8	Check Date				Y	N	N	N	DATE	Format: MMDDYYYY This is the date of the check being reported. This applies to periodic (check) reporting only.
9	Check Number				Y	N	N	N	NUMBER(10,0)	This is the check number assigned to the check being reported. This applies to periodic (check) reporting only.
10	Deltek Tax Type				Y	Y	Y	N	VARCHAR2(6)	'SSER' FDEE = Federal Employee Withholding SSEE = Social Security Employee Withholding SSER = Social Security Employer Tax MDEE = Medicare Employee Withholding AMEE = Medicare Additional Employee Withholding MDER = Medicare Employer Tax FUTA = FUTA Tax FCRA = FUTA Credit Reduction Act STEE = State Employee Withholding SUTA = SUTA Tax LCEE = Local Employee Withholding LCER = Local Employer Tax
11	Tax Code				Y	Y	Y	N	VARCHAR2(25)	This is the code used to identify the tax in the payroll tax product.
12	State				N	N	N	N	VARCHAR2(2)	<NULL Value> This applies to State Withholding, SUTA, FUTA Credit Reduction, and Local Withholding reporting only.
13	Tax ID				Y	Y	Y	N	VARCHAR2(30)	This is the Tax ID assigned to the taxable entity being reported.
14	CHECK Total Hours				Y	N	N	N	NUMBER(14,2)	This is populated with the hours worked from the check being reported. This applies to periodic (check) reporting only.
15	QTD Total Hours				Y	Y	N	N	NUMBER(14,2)	This is populated with the hours worked from checks paid in the quarter being reported. This applies to periodic (check) and quarterly reporting only.
16	YTD Total Hours				Y	Y	Y	N	NUMBER(14,2)	This is populated with the hours worked from checks paid in the year being reported.
17	CHECK Gross Amount				Y	N	N	N	NUMBER(14,2)	This is populated with the gross wages from the check being reported. This applies to periodic (check) reporting only.
18	QTD Gross Amount				Y	Y	N	N	NUMBER(14,2)	This is populated with the gross wages from checks paid in the quarter being reported. This applies to periodic (check) and quarterly reporting only.
19	YTD Gross Amount				Y	Y	Y	N	NUMBER(14,2)	This is populated with the gross wages from checks paid in the year being reported.
20	CHECK Exempt Amount				Y	N	N	N	NUMBER(14,2)	This is populated with the wages exempt from Employer-Paid Social Security Taxes within the check being reported. This applies to periodic (check) reporting only.
21	QTD Exempt Amount				Y	Y	N	N	NUMBER(14,2)	This is populated with the wages exempt from Employer-Paid Social Security Taxes from checks paid within the quarter being reported. This applies to periodic (check) and quarterly reporting only.
22	YTD Exempt Amount				Y	Y	Y	N	NUMBER(14,2)	This is populated with the wages exempt from Employer-Paid Social Security Taxes from checks paid within the year being reported.
23	CHECK Subject Amount				N	N	N	N	NUMBER(14,2)	<NULL Value> This applies to FUTA and SUTA reporting in the periodic (check) file only.
24	QTD Subject Amount				N	N	N	N	NUMBER(14,2)	<NULL Value> This applies to FUTA and SUTA reporting in the periodic (check) and quarterly files only.
25	YTD Subject Amount				N	N	N	N	NUMBER(14,2)	<NULL Value> This applies to FUTA and SUTA reporting in the periodic (check), quarterly, and annual files only.
26	CHECK Taxable Amount				Y	N	N	N	NUMBER(14,2)	This is populated with the Employer-Paid Social Security Taxable Wage Amount for the check being reported. This applies to periodic (check) reporting only.
27	QTD Taxable Amount				Y	Y	N	N	NUMBER(14,2)	This is populated with the Employer-Paid Social Security Taxable Wage Amount from checks paid within the quarter being reported. This applies to periodic (check) and quarterly reporting only.
28	YTD Taxable Amount				Y	Y	Y	N	NUMBER(14,2)	This is populated with the Employer-Paid Social Security Taxable Wage Amount from checks paid within the year being reported. For W-2 reporting, this is populated with the amount from W-2 Box 1.
29	CHECK Excess Amount				N	N	N	N	NUMBER(14,2)	<NULL Value> This applies to FUTA, FUTA Credit Reduction, and SUTA reporting in the periodic file only.
30	QTD Excess Amount				N	N	N	N	NUMBER(14,2)	<NULL Value> This applies to FUTA, FUTA Credit Reduction, and SUTA reporting in the periodic and quarterly files only.
31	YTD Excess Amount				N	N	N	N	NUMBER(14,2)	<NULL Value> This applies to FUTA, FUTA Credit Reduction, and SUTA reporting in the periodic, quarterly, and annual files only.
32	Tax Rate (FUTA and SUTA only)				N	N	N	N	NUMBER(9,8)	<NULL Value> This applies to FUTA, FUTA Credit Reduction, SUTA, and PA-Local reporting in the periodic, quarterly, and annual files only.
33	CHECK Tax Amount	Y			Y	N	N	N	NUMBER(14,2)	This is populated with the Employer-Paid Social Security Tax Amount for the check being reported. This applies to periodic (check) reporting only.
34	QTD Tax Amount		Y		Y	Y	N	N	NUMBER(14,2)	This is populated with the Employer-Paid Social Security Tax Amount from checks paid within the quarter being reported. This applies to periodic (check) and quarterly reporting only.
35	YTD Tax Amount			Y	Y	Y	Y	N	NUMBER(14,2)	This is populated with the Employer-Paid Social Security Tax Amount from checks paid within the year being reported. For W-2 reporting, this is populated with the amount from W-2 Box 2.
36	Month 1 Employee Worked Indicator (Quarterly reporting)				N	Y	N	N	VARCHAR2(1)	Y/N This applies to quarterly reporting only.
37	Month 2 Employee Worked Indicator (Quarterly reporting)				N	Y	N	N	VARCHAR2(1)	Y/N This applies to quarterly reporting only.
38	Month 3 Employee Worked Indicator (Quarterly reporting)				N	Y	N	N	VARCHAR2(1)	Y/N This applies to quarterly reporting only.
39	Weeks Worked (Quarterly reporting)				Y	Y	N	N	NUMBER(5,0)	If applicable, this is populated with the number of weeks worked by the employee in the quarter. This applies to periodic (check) and quarterly reporting.
40	Local Tax Type				N	N	N	N	VARCHAR2(1)	<NULL Value> This only applies to Local Tax reporting.
41	Local Ohio Tax Collection Agency				N	N	N	N	VARCHAR2(1)	<NULL Value> This applies to Ohio Local City Tax reporting.
42	Local Ohio School Code				N	N	N	N	VARCHAR2(20)	<NULL Value> This applies to Ohio Local School Tax reporting.
43	Local Ohio City Code				N	N	N	N	VARCHAR2(20)	<NULL Value> This applies to Ohio Local City Tax reporting.
44	Local Pennsylvania Worksite PSD Code				N	N	N	N	VARCHAR2(20)	<NULL Value> This applies to Pennsylvania Local Tax reporting.
45	Employee Resident PSD Code				N	N	N	N	VARCHAR2(15)	<NULL Value> This applies to Pennsylvania Local Tax reporting.
46	Local Indiana County Code				N	N	N	N	VARCHAR2(20)	<NULL Value> This applies to Indiana Local Tax reporting.
47	Local Disability Insurance Type				N	N	N	N	VARCHAR2(1)	<NULL Value> This applies to Local Tax reporting.
48	Local Family Leave Insurance Type				N	N	N	N	VARCHAR2(1)	<NULL Value> This applies to Local Tax reporting of family leave insurance taxes.
49	Workers' Comp Class Code				N	N	N	N	VARCHAR2(6)	<NULL Value> This applies to SUTA Tax reporting.
50	Worker's Comp Rate				N	N	N	N	NUMBER(6,4)	<NULL Value> This applies to SUTA Tax reporting.
51	CHECK Worker's Comp Hours				N	N	N	N	NUMBER(14,2)	<NULL Value> This applies to SUTA Tax reporting.
52	QTD Worker's Comp Hours				N	N	N	N	NUMBER(14,2)	<NULL Value> This applies to SUTA Tax reporting.
53	YTD Worker's Comp Hours				N	N	N	N	NUMBER(14,2)	<NULL Value> This applies to SUTA Tax reporting.
54	QTD Educational Wage Amount				N	N	N	N	NUMBER(14,2)	<NULL Value> This applies to SUTA Tax reporting.
55	Employee Geographic Code				N	N	N	N	VARCHAR2(2)	<NULL Value> This applies to SUTA Tax reporting for Alaska.
56	Employee Occupational Code				N	N	N	N	VARCHAR2(30)	<NULL Value> Applies to SUTA Tax reporting for Alaska.
57	Employee Coverage Type				N	N	N	N	VARCHAR2(1)	<NULL Value> This applies to SUTA Tax reporting for Wyoming.
58	Employee Wage Plan Code				N	N	N	N	VARCHAR2(1)	<NULL Value> This applies to SUTA Tax reporting for California.
59	Employee Worksite Number/Reporting Unit Number				N	N	N	N	NUMBER(5,0)	<NULL Value> This applies to SUTA Tax reporting for Indiana, Iowa, Massachusetts, Michigan, Minnesota, and New Mexico.
60	Employee Seasonal Employee (Optical) Code				N	N	N	N	VARCHAR2(2)	<NULL Value> This applies to SUTA Tax reporting for Arkansas and Indiana.
61	CHECK Severance Wages				Y	N	N	N	NUMBER(14,2)	<NULL Value> This applies to the federal (FDEE) record and SUTA record in the periodic (check) file only.
62	QTD Severance Wages				Y	Y	N	N	NUMBER(14,2)	<NULL Value> This applies to the federal (FDEE) record and SUTA record in the periodic (check) and quarterly files only.
63	YTD Severance Wages				Y	Y	Y	N	NUMBER(14,2)	<NULL Value> This applies to the federal (FDEE) record and SUTA record in the periodic (check), quarterly, and annual files only.
64	CHECK Federal-Non-Taxable Sick Pay Wages				Y	N	N	N	NUMBER(14,2)	<NULL Value> This applies to the federal (FDEE) and SUTA records in the periodic (check) file only.
65	QTD Federal-Non-Taxable Sick Pay Wages				Y	Y	N	N	NUMBER(14,2)	<NULL Value> This applies to the federal (FDEE) and SUTA records in the periodic (check) and quarterly files only.
66	YTD Federal-Non-Taxable Sick Pay Wages				Y	Y	Y	N	NUMBER(14,2)	<NULL Value> This applies to the federal (FDEE) and SUTA records in the periodic (check), quarterly, and Annual files only.
67	Employer-Paid Health Insurance Premium				N	N	N	N	NUMBER(14,2)	<NULL Value> This applies to the federal (FDEE) and SUTA records in the quarterly and Annual files only.
68	W-2 Dependent Care Benefits (W-2 Box 10)				N	N	N	N	NUMBER(14,2)	<NULL Value> This applies to federal (FDEE record) reporting in the W-2 file only.
69	Box 11 Amount (Nonqualified Plans)				N	N	N	N	NUMBER(14,2)	<NULL Value> This applies to federal (FDEE record) reporting in the W-2 file only.
70	CHECK COVID-19 Sick Leave Amount				Y	N	N	N	NUMBER(14,2)	This is populated with the COVID-19 sick leaves wages from the check being reported. This amount should not be limited by the social security wage base. This applies to periodic (check) reporting only.
71	QTD COVID-19 Sick Leave Amount				Y	Y	N	N	NUMBER(14,2)	This is populated with the COVID-19 sick leaves wages from checks paid within the quarter being reported. This amount should not be limited by the social security wage base. This applies to periodic (check) and quarterly reporting only.
72	YTD COVID-19 Sick Leave Amount				Y	Y	Y	N	NUMBER(14,2)	This is populated with the COVID-19 sick leaves wages from checks paid within the year being reported. This amount should not be limited by the social security wage base.
73	CHECK COVID-19 Family Leave Amount				Y	N	N	N	NUMBER(14,2)	This is populated with the COVID-19 family leave wages from the check being reported. This amount should not be limited by the social security wage base. This applies to periodic (check) reporting only.
74	QTD COVID-19 Family Leave Amount				Y	Y	N	N	NUMBER(14,2)	This is populated with the COVID-19 family leave wages from checks paid within the quarter being reported. This amount should not be limited by the social security wage base. This applies to periodic (check) and quarterly reporting only.
75	YTD COVID-19 Family Leave Amount				Y	Y	Y	N	NUMBER(14,2)	This is populated with the COVID-19 family leave wages from checks paid within the year being reported. This amount should not be limited by the social security wage base.

 

Compute Payroll (PRPCPR)

The Compute Payroll screen now calculates and stores the employer portion of FICA taxes.

The Social Security wage base accumulation will be done with respect to the employee Social Security taxes on compensation to an employee who received qualified leave wages.

Manage Payroll Records (PRMPTF)

The Manage Payroll Records screen can now recalculate, store, and display the employer portion of FICA taxes. To support the new functions, this release applies the following changes to the screen:

• Payroll Edit tab

• The unemployment taxes fields were transferred to the new Employer Accrual tab.

• The social security Accrued Expense field and the Medicare Accrued Expense field on this tab are no longer editable.

• Employer Accrual tab

• This new tab allows you to access the Unemployment Taxes fields transferred from the Payroll Edits tab and the employer FICA Taxes fields.

• The FICA Taxes group box provides the following fields:

Social Security

Field	Description
Exempt Pay Types	Enter the amount for the employer portion of social security exempt pay types.
Exempt Deductions	The field displays the total of the social security exempt deductions. This field is not editable.
Taxable Wages	Enter the amount for the employer portion of social security taxable wages.
Accrued Expense	This field displays the employer expense accrued for social security.

Medicare

Field	Description
Exempt Pay Types	Enter the amount for the employer portion of Medicare exempt pay types.
Exempt Deductions	This field displays the total of the Medicare exempt deductions. This field is not editable.
Taxable Wages	Enter the amount for the employer portion of Medicare taxable wages.
Accrued Expense	This field displays the employer expense accrued for Medicare.

Post Payroll Journal (PRPPPCLS)

The Post Payroll Journal screen now has the ability to post the employer portion of FICA taxes. To support the new function, this release applies the following changes to the screen:

• To track the employer amounts of social security taxes, this release adds the following columns to the EMPL_EARNINGS table:

• SS_ER_EXMPT_PT_AMT

• SS_ER_TXBL_AMT

• To track the employer amounts of Medicare taxes, this release adds the following columns to the EMPL_EARNINGS table:

• MDCR_ER_EXMPT_PT_AMT

• MDCR_ER_TXBL_AMT

• When you post payroll, the application includes the following data:

• Employer Social Security Exempt Pay Types (SS_ER_EXMPT_PT_AMT)

• Employer Social Security Taxable Wages Employer Social Security (SS_ER_TXBL_AMT)

• Employer Medicare Exempt Pay Types (MDCR_ER_EXMPT_PT_AMT)

• Employer Medicare Taxable Wages (MDCR_ER_TXBL_AMT)

Manage Employee Earnings History (PRMERF)

The Manage Employee Earnings History screen now displays the employer portion of exempt pay types and taxable wages of FICA taxes. To support the new functions, this release applies the following changes to the screen:

• Employee Earnings tab

• The unemployment taxes fields were transferred to the new Employer Accrual tab.

• The social security Accrued Expense field and the Medicare Accrued Expense field on this tab are not editable.

• Employer Accrual tab

• This new tab allows you to access the Unemployment Taxes fields transferred from Payroll Edits tab and the employer FICA Taxes fields.

• The FICA Taxes group box provides the following fields:

Social Security

Field	Description
Exempt Pay Types	Enter the amount for the employer portion of social security exempt pay types.
Exempt Deductions	The field displays the total of the social security exempt deductions. This field is not editable.
Taxable Wages	Enter the amount for the employer portion of social security taxable wages.
Accrued Expense	This field displays the employer expense accrued for social security.

Medicare

Field	Description
Exempt Pay Types	Enter the amount for the employer portion of Medicare exempt pay types.
Exempt Deductions	This field displays the total of the Medicare exempt deductions. This field is not editable.
Taxable Wages	Enter the amount for the employer portion of Medicare taxable wages.
Accrued Expense	This field displays the employer expense accrued for Medicare.

• The YTD Taxes subtask provides new fields for year-to-date employer taxable amounts:

Employer Social Security

Field	Description
Taxable	This field displays the year-to-date employer portion of taxable social security wages.
Accrued	This field displays the accrued year-to-date employer portion of taxable social security wages.

Employer Medicare

Field	Description
Taxable	This field displays the year-to-date employer portion of taxable Medicare wages.
Accrued	This field displays the accrued year-to-date employer portion of taxable Medicare wages.

• Labels of the following existing fields in the YTD Taxes subtask were updated:

• Employee Social Security

• Employee Medicare

Print Quarterly Federal Payroll Tax Report (PRRFDTAX)

The following are updates to the Print Quarterly Federal Tax Report screen:

• The application now calculates and includes the employer portion of the social security and Medicare taxes in the Quarterly Federal Payroll Tax Report.

• The Advance EIC column will no longer be included in the report.

• This release updates the source of exempt pay type amount and taxable amount in the calculation of the social security and Medicare accrual amount.

Recompute Taxable Wages (PRPRCOMP)

The application now recomputes, stores, and reports the employer portion of FICA taxes.

• The application recomputes and stores the following amounts:

• Employer Social Security Recomputed Taxable Wages

• Employer Social Security Recomputed Exempt Pay Types

• Social Security Accrual Wages

• Employer Medicare Recomputed Taxable Wages

• Employer Medicare Recomputed Exempt Pay Types

• Medicare Accrual Wages

• The report now includes the following tax types:

• Employer Social Security

• Employer Medicare

• The following tax types in the report changed:

• “Social Security” is now “Employee Social Security.”

• “Medicare” is now “Employee Medicare.”

• To indicate recomputation of FICA accruals, this release changes the following labels on the screen:

• The Social Security check box is now labeled as Social Security Taxable and Accrual.

• The Medicare check box is now labeled as Medicare Taxable and Accrual.

• The application now provides a new Accrued Taxes Adjustment Report which prints after the Recompute Taxable Wages Report. This report is sorted by tax type.

Void/Replace Posted Paychecks (PRPAVCK)

The application now updates employee payroll records with the employer portion of FICA taxes when voiding paychecks. This release applies the following changes to the Void/Replace Posted Paychecks Report:

• New employer taxable amount fields were added for both social security and Medicare.

• New employer pay type exempt amount fields were added for both social security and Medicare.

• Labels of the existing social security and Medicare fields now have “EE” at the beginning.

• The State Withholding and Local Withholding values were relocated in the report layout.

Print Payroll Edit Report (PRRPTF)

This release adds the employer portion of FICA taxes in the reports generated by the Print Payroll Edit Report screen.

Print Employee Earnings Report (PRRERF)

This release adds the employer portion of FICA taxes in the reports generated by the Print Employee Earnings Report screen.

Print Data Dictionary Report (SYRDD)

The report now provides information for columns added and updated in the following database tables:

• Pay Type Taxability (PAY_TYPE_TXBL)

• Employee Payroll (EMPL_PAYROLL)

• Employee Payroll Audit (EMPL_PAYROLL_ADT)

• Employee Earnings (EMPL_EARNINGS)

• Employee Earnings Audit (EMPL_E_ADT)

2020 Arizona SUTA Electronic Filing

Effective February 28, 2020, the Arizona Department of Economic Security department discontinued allowing quarterly SUTA wage data to be submitted on CDs or diskettes in the MMREF format.

Arizona now requires employers to file wage data in one of the following formats:

• Comma Separated Value (CSV) file upload on the Arizona Unemployment Tax and Wage System website (https://uitws.azdes.gov/App/EmployerLogin.aspx)

• Bulk filing process (server to server process using the XML file format)

Costpoint will support the CSV format for Arizona SUTA quarterly reporting. The Create Quarterly SUTA Tax File (PRPSMM) application was updated to generate a CSV file in the following format:

Field	Description
Social Security Number	Required No spaces or special characters
Last Name	Required Up to 30 characters (letters, numbers, hyphens, apostrophes, periods, and spaces only)
First Name	Required Up to 15 characters (letters, numbers, hyphens, apostrophes, periods, and spaces only)
Total Wages (Current Quarter Wages)	Required Format is 9999.99. Minimum amount is 0.01. Maximum amount is 9999999.99.
Excess Wages (Current Quarter Excess Wages)	Optional Format is 9999.99. Maximum amount is 9999999.99. Excess Wages is an optional field for the upload file; however, you must either include Excess Wages for all employees or leave them off for all employees. If you include them, you must enter an amount in the Excess Wages field for each employee. Enter 0.00 for employees who have not been paid Excess Wages.

 

Attention: For more information, refer to the Wage File Upload Instructions - Required Format from the department’s website: https://des.az.gov/services/employment/unemployment-employer/wage-file-upload-instructions-required-format.

SUTA Electronic Filing File Types by State

The Costpoint Online Help now provides an updated table of the electronic file types that the Create Quarterly SUTA Tax File screen generates for each state. You can access the updated Costpoint SUTA Electronic Filing File Types topic when you open the online help from the screen. You can also access the help topic from the Table of Contents under the following location: People > Payroll Overview > Tax Reporting > State and Local Taxes > Create Quarterly SUTA Tax File > Costpoint SUTA Electronic Filing File Types.

Compute Revenue has been enhanced to process more efficiently and decrease its runtime during simultaneous or batch processing. Deltek recommends that you install the Costpoint 7.1.7 MR in a test environment and test the application before deploying the MR to production.

Defect 1304524: When you created a new purchase order (PO) voucher from a receipt for a PO that already has an existing receipt and voucher, Costpoint computed the new voucher amount incorrectly.

Defect 1308852: When you used the Web Integration Console (WIC) to enter a purchase order (PO) voucher for a Subcontract Agreement PO with a PO line that has a Match Type of 3, you encountered a system error and the voucher was not entered.

Defect 1302137: When you entered a cash receipt with a Bill Currency that is different from the Pay Currency, Costpoint did not calculate the gain/loss.

Defect 1295353: When you selected certain advanced mapping definitions on the Manage Cobra Resource Templates screen, and then you ran the Cobra integration, a system error occurred.

Defect 1300319: A system error displayed when you ran the Compute Cobra Burden Cost System process.

Defect 1311418: The Cobra integration process sent only one line of data from the CSV transaction file to the Cobra web service.

Defect 1308736: The application did not validate when you entered a file location that had no Folder/URL field value on the Manage Alternate File Locations screen. This issue existed in the following fields:

• Batch File

• Export File

• Error Log

Defect 1296408: When you did not set up the connection to Cobra, and then you queried records on the screen, a system error occurred.

Defect 1301693: Performance issues occurred when Costpoint connected to the Cobra web service.

This issue also existed in the following applications:

Affected Application	Defect No.
Manage Cobra Charge Templates	1301691
Manage Cobra Cost Templates	1301694
Manage Cobra Extraction Parameters	1301695
Manage Cobra Project Mapping	1301696

Defect 1302431: The application did not populate the Supplier/Vendor Rating subtask on the Manage Contracts screen even though the migrated GovWin Capture Management records contained the corresponding data.

Defect 1304907: You were unable to add an employee as a billing analyst on the Manage Contracts screen. The lookup of the Billing Analyst field incorrectly excluded employees with no corresponding salary record in the EMPL_LAB_INFO table.

Defect 1304534: Costpoint did not automatically generate opportunity IDs for imported opportunities.

Defect 1310762: SAML authentication sometimes failed when the SAML XML token contained non-US/Western characters. This affected those who used SAML single sign-on and whose user account or employee first or last name contained non-US/Western characters.

Defect 1300940: A system error occurred in the Manage Purchase Order Vouchers (POMPOVCH) application when the date was set as the current date.

Defect 1306879: An upload to SharePoint failed if the library contained different document types and was over the 5,000 files threshold.

Defect 1314758: Costpoint MR 7.1.4 and later installers failed when the application server has Federal Information Processing Standards (FIPS) configured. The error occurred when clicking the Next button on the installer dialog box after entering the system administrator password.

Defect 1295532: When you adjusted parts with tracking required for project, the utility threw an error for parts in projects that do not require serial/lot tracking.

Defect 1300426: When you entered the material requirements planning (MRP) part and clicked Execute, the Planned Order Selection Status option was unavailable and did not reflect the Released option selected in the Selection Status drop-down list of the Planned Order Supply subtask.

Defect 1304045: When you created a manufacturing order (MO), the common stock (CS) abbreviation did not default from the selected inventory project. However, when you manually entered a CS abbreviation that belongs to a non-common project, Costpoint allowed it on the field but displayed an error upon save.

Defect 1306200: When you split the orders in Manufacturing Execution System (MES), and then processed orders with both accepted and rejected quantity, quality control inspection failed.

Defect 1298529: When you deleted a sales order (SO) invoice, only one of the issue lines invoice quantity was updated to zero.

Defect 1304947: You encountered a system error when you manually inserted serial/lot tracked parts and the Allow Inventory Allocations check box was not selected in Configure Inventory Settings.

Defect 1298921: A patch was released to fix a defect which resulted from another fix. The change requires PATCH3784.

Defect 1253478: The census report displayed inactive dependents who were not assigned to any benefit plans as insured dependents.

Defect 1299250: The report displayed an error message which stated that employees must be flagged for both Shop Floor Time (SFT) and Manufacturing Execution (MES). This occurred even though you were licensed for only MES. This defect affects you if you import employee data and you have a license for only MES.

Defect 1144926: An error message displayed when an employee who did not have a medical plan elected a health savings account (HSA).

Defect 1295445: When an employee changed information on the screen and then deleted the change, the application deleted current direct deposit selections.

Defect 1211017: The rounding of coverage amounts was incorrect. It should be in sync with the calculation on the Update Benefit Option/Election Tables screen.

Defect 1294776: The application should generate deletion records for DEL_PROJ_EMPL and DEL_PROJ_E_LAB_CAT records regardless of the project’s Active flag, Allow Charging flag, and Export Project value. The Project Work Force Required flag would remain a condition for export.

Defect 1126847: When you saved your changes, the screen automatically recalculated the manually edited functional and transaction amounts on a timesheet line that was created by copying an existing timesheet line.

As a workaround, you can manually edit the amounts after you saved your changes. You can also opt not to use the Clone/Copy function, and then manually enter a new line for the timesheet.

Defect 1298204: The Auto Adjust % field did not load the correct default value that was set on the Manage Timesheet Periods screen. This defect affects you if you use Costpoint MR 7.1.5.003 and use the auto-adjust functionality.

Defect 1299675: The application did not allow you to enter or change the value in the Withholding State field. As a workaround, enter the withholding state on the following screens:

• Manage Employee Project Timesheet Defaults

• Manage Employee Proj-Acct-Group Timesheet Defaults

Defect 600822: When you posted a timesheet with a used leave, the application updated the following columns to zero for the corresponding leave type:

• EMPL_LV_BAL.AVG_FUNC_AMT

• EMPL_LV_HIST.AVG_FUNC_AMT

This issue occurred for a leave type that had a beginning balance record with NULL or zero values in its currency fields.

This issue affects you if you use the Multicurrency functionality.

Defect 1307671: The Post Leave Accruals process posted duplicate expense records to the GL Detail. This occurred if you have the following setup:

• Multiple currencies are assigned to different employees within the same home organization.

• Multiple currencies have the same expense account but different projects on the Manage Leave Types screen.

Defect 1310589: If the LAST_NAME or FIRST_NAME column on the EMPL table contains a value with a comma, the application should not include the comma in the generated CSV file.

Defect 1296523: The SAL_AMT column on the EMPL_PAYROLL_ADT table displayed 0.00 instead of a blank/NULL value. It should refelct the NULL value in the SAL_AMT column on the EMPL_PAYROLL table.

Defect 1264619: The Post Payroll Journal process inserted an E value in the S_ID_TYPE column on the OPEN_BILLING_DETL table, but then the process inserted a corresponding blank value in the S_ID_TYPE column on the GL_DETL table. This issue caused Costpoint not to insert records on the IWO_ALLOC_LAB table.

Defect 1307933: You encountered a system error when you printed payment advices. This issue occurred on all advice types, whether you set the Paystub Hourly Rate Consolidation Method to consolidate or not. As a workaround, you can print for one employee at a time.

Defect 1294827: The report displayed incorrect calculated amounts and the calculated taxable amounts. The incorrect values were large negative amounts.

Defect 1299251: When you clicked Print on the Update Excess Life Deductions screen, Costpoint inserted the computed amounts on the Manage Employee Deductions screen. In this scenario, Costpoint should insert the computed amounts only after you run the Update Excess Life Deductions or Print/Update Excess Life Deductions process.

Defect 1166887: Data Dictionary did not include New Business Budgets tables and columns.

Defect 1299490: You encountered performance issues when you ran the Post Install using a multi-company environment.

Defect 1234426: The Refresh process ran the Project Summary step (310) before running the Ceiling Burden step (390). This resulted to the Ceiling burden being outdated.

Defect 1297979: You encountered performance issues when you tried to run the Labor Cost Analysis report.

Defect 1306347: You received a system error when you updated the pool rates.

Defect 1297980: You encountered performance issues when you tried to run the Time Collection Hours - Range report.

Defect 1253311: When you uploaded a project in Project Budgets/EACs using Import Budget/EACs from Excel, the Revenue Type did not default to None when the project had no revenue formula.

Defect 1308904: When you used the Append option in uploading an EAC, the actuals of the older version of the EAC were deleted.

Defect 1206011: The Subcontractor Labor Account was populating as default in the Non-Labor Sheet when it should be blank.

Defect 1272267: When EAC Last Closed Period was unlocked and edited, the system did not recalculate the cost for that period.

Defect 1309681: The OK button was not displayed after you ran the Create/Commit action. The Process bar was removed to resolve this issue.

Defect 1304494: The report did not display detailed level information by vendor employee ID.

Defect 1262638: The report did not display the dollar amount associated with the labor.

Defect 1266009: The Vendor option was not included as one of the Resource Type parameters.

Defect 1306915: The application was taking too long to process data and also stopped responding.

Defect 1262520: The posting process was running longer than expected.

Defect 1282163: You were unable to approve purchase requisitions after running the Compute Over Budget Transactions screen. You received the following error in Approve Purchase Requisitions: "Requisition cannot be Approved until Released by the Compute Over Budget Transactions process."

Defect 1307099: A system error occurred when you processed a range of projects with prior year revenue. As a workaround, you can process the project records individually to avoid the error.

Defect 1287240: A system error occurred during validation of the inter-company work order (IWO) when the destination sales tax code of the receiving company contains rows with the same recovery Suspense Account and Suspense Organization combination. This defect occurred in Oracle databases only. As a workaround, on the Manage Sales or Value Added Taxes screen, delete the duplicate row for the destination sales tax code or use a different suspense account/organization combination in the duplicate row.

Defect 1300497: The Project Status Report and Revenue Worksheet had the same prior year revenue amounts. The Project Revenue Summary Report, however, did not include the overceiling amounts in the Prior Year Revenue and Target Contract To Date Revenue columns.

Defect 1290074: The contract ID (CTRN_ID) was not imported into the PROJ_MOD table. As a workaround, you can copy the imported PROJ_MOD record in the Manage Modifications application. Once the record is copied, the newly created record will display the CTRN_ID value of the PROJ_ID linked to the PROJ_MOD record. However, this workaround is recommended for one or two records only, as copying more records can be time-consuming. Also note that this works only if the PROJ.csv file is imported with the PROJ_MOD.csv file, or if the project used in PROJ_MOD.csv has the CNTR_ID value before copying it using Manage Modifications or Manage Project User Flow.

Defect 1293214: Costpoint displayed the following incorrect error message when you saved award fee information in more than one modification at the same time: "The award fee accrual period entered cannot overlap with another." As a workaround, you can save award fee information for one project at a time. Alternatively, you can use the Manage Project User Flow screen to save multiple records at the same time.

Defect 1295119: When you ran the Project Initialization subtask in Manage Contracts to update the employee workforce, Costpoint added the employees from the template project instead of the employees recently added to the Team tab of Manage Contracts. As a workaround, you can manually delete the incorrect employees added to the workforce and add the correct employees.

Defect 1308130: When a charge branch included multiple levels, the Charge Tree did not display the -/+ options that allow you to expand or collapse the levels.

Defect 1297257: After you estimated mileage and a per diem meal on an expense authorization, those values displayed as 0.00 on the commitment report.

Defect 1299551: When a Lodging expense was split with an Other expense, and both were allocated to different charges, the Other amount did not round up.

Defect 1307681: When you added a new default charge to an expense report, and if a new project was used with that new line, the project in the original line was also changed, resulting in both default charges using the same project.

Defect 1308889: When Link UDT09/UDTO3 was enabled as Direct on the UDT Options tab in General Configuration and both charges required validation, an employee who selected the linked charge received a message stating that the link was invalid. This error occurred only if Link 12 (UDT01/UDT02) was also configured as Direct.

Defect 1297791: When you copied a timesheet line that included UDT10, you received an error message when adding hours if UDT10 was configured to exclude lookup or manual updating.

Defect 1301073: If an employee ran sessions in two different browsers and in the first session viewed a timesheet in the middle of a correction that was then undone, the status of the timesheet in the second session was Open.

Defect 1310168: When a supervisor created a new timesheet for an employee, the Post-Save stored procedure failed to run.

Defect 1310285: If Use Group Cache for Charge Lookup was selected on the Miscellaneous tab of Configure General Settings, an Authorization error occurred when a UDT02 charge was manually added to a timesheet line.

Defect 1311367: After you selected a UDT02 charge that was invalid, the error message that should have resulted did not display.

Defect 1297260: You were allowed to save a parameter with Current Period selected for a timesheet schedule where no current period existed, which caused the report to fail when submitted to the job queue a second time.

The report was updated so that year and period values cannot be set when either Current Period or Previous Period is selected for a saved parameter, because these values are based on the present date by default.