2021 Form 941 Updates

To support the 2021 Form 941 updates, this release applies the following updates to the Federal 941 Data and Tax Credit Report generated on the Print Quarterly Federal Payroll Tax Report screen:

Report Section	Report Items	Update
Federal 941 Data	Line 11b	Blank if payroll year is earlier than 2020.
	Line 11c	Blank if payroll year is earlier than 2020.
	Line 13c	Blank if payroll year is earlier than 2020.
	Line 13d	Blank if payroll year is earlier than 2020.
Credit for Sick and Family Leave Wages	(All items)	All values in this section should be blank if payroll year is earlier than 2020.
Employee Retention Credit	(All items)	All values in this section should be blank if payroll year is earlier than 2020, or if the Eligible for Employee Retention Credit check box is clear.
Employee Retention Credit	3a	The calculation of qualified wages was updated for payroll year 2021.The report retains the existing calculation for payroll year 2020. The qualified wages for the employee retention credit, including qualified health plan expenses, are limited to a maximum of $10,000 for each employee for the quarter. (Source: Instructions for Form 941 Rev. 3-2021)
	3d	The rate was updated to 70% in the calculation for payroll year 2021. The report retains the rate of 50% for payroll year 2020. The tax credit is equal to 70% of qualified wages paid to employees after December 31, 2020. (Source: Instructions for Form 941 Rev. 3-2021)
	Labels	The label shall be updated to "Retention credit (3c x Rate*):" from "Retention credit (3c x 50%):". An italicized text "*Rate is 70% for 2021, while 50% for 2020." was added below Line 3i.

Attention: For more information, refer to the following:

• Form: http://www.irs.gov/pub/irs-pdf/f941.pdf

• Instructions: http://www.irs.gov/pub/irs-pdf/i941.pdf

New Form 1095-C Codes to Report an Offer of an Individual Coverage HRA

The IRS provided additional codes that are available for reporting an Offer of an Individual Coverage Health Reimbursement Arrangement (HRA) on the Form 1095-C.

An Applicable Large Employer that offers an individual coverage Health Reimbursement Arrangement (HRA) can use two previously reserved codes from Code Series 1 on Form 1095-C, line 14, for reporting offers of coverage for 2020 as follows:

• 1T: Individual coverage HRA offered to employee and spouse (no dependents) with affordability determined using employee's primary residence location ZIP code.

• 1U: Individual coverage HRA offered to employee and spouse (no dependents) using employee's primary employment site ZIP code affordability safe harbor.

Attention: For more information, refer to: https://www.irs.gov/forms-pubs/additional-codes-are-available-for-reporting-an-offer-of-an-individual-coverage-health-reimbursement-arrangement-hra.

Manage 1095-C Data (HBM1095C)

You can now select from the lookup of line 14 Offer of Coverage fields the following new codes:

• 1T: Individual coverage HRA offered to employee and spouse (no dependents) with affordability determined using employee's primary residence location ZIP code.

• 1U: Individual coverage HRA offered to employee and spouse (no dependents) using employee's primary employment site ZIP code affordability safe harbor.

The following reserved codes were also added to the lookup of Line 14 Offer of Coverage:

• 1V: Reserved for future use.

• 1W: Reserved for future use.

• 1X: Reserved for future use.

• 1Y: Reserved for future use. 

• 1Z: Reserved for future use.

Note: This enhancement requires PATCH3834.

Alaska 2021 Geographic Codes

The Alaska map with two-digit geographic codes was updated to subdivide Valdez-Cordova Census Area (code 75) into Chugach (code 74) and Copper River (code 76). The Valdez-Cordova Census Area (code 75) is no longer included in the list of geographic codes. Geographic codes are reported in the SUTA file of Alaska.

This Costpoint release updates the S_AK_GEO_CD table to reflect changes in Alaska’s geographic codes.

Attention: For more information, refer to: http://live.laborstats.alaska.gov/erg/areacodemap.pdf.

Manage Employee Information (LDMEINFO)

You can now select the updated geographic codes of Alaska in the Geographic Code field on the Taxes subtask.

Manage Employee Taxes (PRMETAX)

You can now select the updated geographic codes of Alaska in the Geographic Code field on the Tax Reporting Information tab.

Create Quarterly SUTA Tax File (PRPSMM)

The updated geographic codes will be reflected in the generated SUTA file for Alaska.

Note: This enhancement requires PATCH3836.

Arkansas 2021 Supplemental Tax Rate

Arkansas recently released its 2021 Withholding Tax Employer’s Instructions. The supplemental wages decreases from 6.9% to 5.9%. This release sets the Supplemental Tax Rate of Arkansas to 5.9% effective 01/01/2021 on the Manage State Taxes screen.

Attention: For more information, refer to: https://www.dfa.arkansas.gov/images/uploads/incomeTaxOffice/withholdInstructions.pdf.

Note: This enhancement requires PATCH3837.

Costpoint adds the ability to print Form 1095-C and 1094-C using the 2019 report layout. The following screens now provide the corresponding options for printing:

• Print 1094-Cs (HBR1094C)

• Print 1094-Cs Current Report: Select this report to print current year 1094-C data using the current year report layout.

• Print 1094-Cs 2019 Report: Select this report to print 2019 1094-C data using the 2019 report layout.

• Print 1095-CS (HBR1095C)

• Print 1095-Cs Current Report: Select this report to print current year 1095-C data using the current year report layout.

• Print 1095-Cs 2019 Report: Select this report to print 2019 1095-C data using the 2019 report layout.

Costpoint now determines and stores the total amount deferred in Q3 2020 and the total amount deferred in Q4 2020. The Manage Deferred Tax Payments screen provides new fields, which display the amount of Social Security deferred for each employee in Q3 2020 and Q4 2020.

You can also print a report which provides information on the Social Security repayment amounts per pay check and whether or not that repayment is used to pay the Q3 2020 SS withholding due or the Q4 2020 SS withholding due.

Note: This enhancement requires PATCH3835.

Manage Deferred Tax Payments (EMMDFRDTAXPAY)

The screen features the following new fields:

Field	Description
Q3 2020 Deferred Amount	The IRS requires employers to report the amount being repaid for the Social Security tax that was deferred in Q3 2020 separately from the amount being repaid for the Q4 2020 deferral. Enter the Social Security withholding amount deferred for the employee in Q3 2020 in this field. You may manually enter the amount, or you can automatically populate this field using the Update Q3/Q4/Total Deferred Amounts and Deferral Period End Date option in the Create Manage Deferred Tax Payment Records toolkit of the Payroll Toolkit application.
Q4 2020 Deferred Amount	Enter the amount of Social Security withholding deferred for the employee in Q4 2020, or you can automatically populate this field using the Update Q3/Q4/Total Deferred Amounts and Deferral Period End Date option in the Create Manage Deferred Tax Payment Records toolkit of the Payroll Toolkit application.

Payroll Toolkit (PRPTOOLKIT)

The Payroll Toolkit screen provides the following updates:

• The label for the existing Update Total Deferred Amount and Deferral Period End Date check box changed to “Update Q3/Q4/Total Deferred Amounts and Deferral Period End Date.”

Note: If you use the Create Manage Deferred Tax Payments Records toolkit and select the Generate new records option, you will need to run the same toolkit with both of the following options selected:

• Update existing records based on selection criteria and Deferral Period Start Date option

• Update Q3/Q4/Total Deferred Amounts and Deferral Period End Date check box

• The application now determines the Social Security withholding amount that was deferred in Q3 2020 when the Source of Total Deferred Amount method is Deferred Social Security withholding from earnings history. This process will update the Q3 2020 Deferred Amount field on the Manage Deferred Tax Payments screen for any employees that had deferred Social Security withholding in a check dated within Q3 2020.

• The application now determines the Social Security withholding amount that was deferred in Q4 2020 when the Source of Total Deferred Amount method is Deferred Social Security withholding from earnings history. This process will update the Q4 2020 Deferred Amount field on the Manage Deferred Tax Payments screen for any employees that had deferred Social Security withholding in a check dated within Q4 2020.

• The application now determines the Social Security withholding amount that was deferred in Q3 2020 when the Source of Total Deferred Amount method is The difference between calculated and actual Employee withholding. This process will update the Q3 2020 Deferred Amount field on the Manage Deferred Tax Payments screen for any employees that had a variance between calculated and actual Social Security withholding in a check dated within Q3 2020.

• The application now determines the Social Security withholding amount that was deferred in Q4 2020 when the Source of Total Deferred Amount method is The difference between calculated and actual Employee withholding. This process will update the Q4 2020 Deferred Amount field on the Manage Deferred Tax Payments screen for any employees that had a variance between calculated and actual Social Security withholding in a check dated within Q4 2020.

• The existing Update Existing Soc Sec Deferred Withholding Payment Records report now provides information on the before and after Q3 and Q4 2020 deferred Social Security withholding amounts.

Print Quarterly Federal Payroll Tax Report (PRRFDTAX)

The screen provides a new Report Type option, Repayment of DeferredSS Withholding (941-V). This report includes the information needed to report the Q3 2020 and Q4 2020 deferred Social Security withholding amounts on the 941-V.

This release also applies the following changes to the screen:

• The Reporting Date label changed to “Reporting Dates.”

• The Options group box label changed to “Report Type.”

• The 1st Sort field label changed to “Primary Sort”

• The Sort By group box label changed to "Report Options."

Reporting of Deferred Social Security Amounts Example

The following example shows how to track and report deferred Social Security amounts:

1. An employee has the following deferred Social Security withholding amounts from 2020:

Check Date	Quarter in Which Check Date Falls	Social Security Amount Deferred
09/02/2020	Q3 2020	227.74
09/17/2020	Q3 2020	227.75
10/02/2020	Q4 2020	227.75
10/17/2020	Q4 2020	227.75
11/02/2020	Q4 2020	227.75
11/17/2020	Q4 2020	227.75
12/02/2020	Q4 2020	227.75
12/17/2020	Q4 2020	227.75

Total

1,821.99

2. When Costpoint provided the deferral repayment functionality in 2020, employers set up the employee’s record on the Manage Deferred Tax Payments screen as follows:

3. In MR 7.1.17, employers run the updated Create Manage Deferred Tax Payment Records toolkit on the Payroll Toolkit screen to populate the new Q3 2020 Deferred Amount and Q4 2020 Deferred Amount data fields. This results in the following:

• The Q3 2020 Deferred Amount field would be populated with $455.49, which is the employee’s total deferred amount in Q3 2020 (sum from the check dates from September 2020).

• The Q4 2020 Deferred Amount field would be populated with $1,366.50, which is the employee’s total deferred amount in Q4 2020 (sum from the check dates from October, November, and December 2020).

4. Employers print the Repayment of Deferred SS Withholding (941-V) report type on the Print Quarterly Federal Payroll Tax Report (PRRFDTAX) screen. This report provides information on the Social Security repayment amounts per pay check and whether or not that repayment is used to pay the Q3 2020 Social Security withholding due or the Q4 2020 Social Security withholding due.

Defect 1424508: You encountered an error when you attempted to process a check that has more than 10,000 vouchers associated with it.

Defect 1419952: A critical system error occurred when you tried to access the Modifications tab for some records.

Defect 1438159: When you ran a job asynchronously or on a different terminal (or browser), which was a long running action, and then submitted a new job to the job server that included a parallel step from the previous job submitted, the step with the parallel action in the new job would lock and retry until the system completed the step. As a result, when the new job completed and you opened the View Action and Report Status screen and viewed the job steps, some data related to the Job Server was missing for the job that ran asynchronously and for the steps that completed prior to the parallel step in the newer job.

Defect 1425896: When you ran Update Material Requirements Plan and queried the database, the process inserted a single space on the SCHED_RECPT.RES_WHSE_ID table.

Defect 1418219: When you assigned an existing purchase order (PO) to a requisition line, and the buyer limit has been exceeded for the PO line or the PO total, the system did not provide a warning/error message.

Defect 1419396: When you assigned an existing purchase order (PO) to a requisition line, and the buyer limit has been exceeded for the PO line or the PO total, the system did not provide a warning/error message.

Defect 1419400: When you assigned an existing purchase order (PO) to a requisition line, and the buyer limit has been exceeded for the PO line or the PO total, the system did not provide a warning/error message.

Defect 1430900: When you added a new requisition line and entered a part, the warehouse ID that defaulted was incorrect.

Defect 1420211: When parts/items were separated by company, you were unable to load line types even though you were logged into the company where the parts exist.

Defect 1421521: When you did a relief of a manufacturing order (MO) with a serial/lot reference loaded from the MO, and then you used the Autoload button on the Serial/Lot subtask, a second record was created in the Serial/Lot table. This caused errors when trying to transfer the particular part/serial.

Defect 1428947: When you changed the date or added notes to the line details of a sales order with Discount and Trans Currency Net Unit Price that have minor adjustments, Costpoint recalculated the original amount, and the status went back to Pending.

Defect 1430337: You received an AIRSH100 transmission error during file submission for prior years.

Defect 1342260: When you used the Paste Data from Excel function from the Copy menu, the application inserted the Personnel Action Description field values to the Personnel Action Code field.

Defect 1437022: The Disable ESS W-4 check box was not enabled even if your ESS version was higher than 7.5.

Defect 1441189: The application did not display an error if the input file contained a Project Account Abbreviation that is not valid for a company.

 

You encountered this issue if:

1. You set up multiple companies in Costpoint that use an identical Project Account Group.

2. You assigned the Project Account Abbreviation to the Project Account Group of one of the companies.

3. You uploaded the input file for a company that uses the same Project Account Group but not the Project Account Abbreviation.

Defect 1433417: When you entered default values and selected the Apply to Lower Levels check box for a lower level project on the Manage Employee Project Timesheet Defaults screen, Costpoint applied the default values to all project levels that have the same top level project.

Defect 1425817: The Close Leave Year process did not complete when you ran the process with the Base New Balances and Payout on New Leave Year Salary check box selected. When you ran the process with the Base New Balances and Payout on New Leave Year Salary check box cleared, it took an extremely long time to complete, for example, 16 hours.

Defect 1443794: The bank rejected the Payroll ACH file because the file contained an extra dash ( -) in the following fields:

• Field 41-50 of record line 5

• Field 45-54 of record line 8

As a workaround, manually update the file before you send it to the bank.

Defect 1417831: Project Labor Categories (PLCs) were not created for some levels of projects.

Defect 1430022: PLC routines were running slower than expected.

Defect 1403753: You received an error when you tried to create Outlooks in Organization Budgets/Outlooks.

Defect 1432445: Computed Rate Reports were not picking up allocations.

Defect 1427378: When you tried to upload budgets/EACs in Oracle, the process took longer than expected.

Defect 1421372: When you changed the Pool Org ID, the system caused the routine to create doubled lines for the same fiscal year, period, and subperiod.

Defect 1435303: Manage Burden Templates was not calculating burden as expected.

Defect 1440989: A new Estimate at Complete (EAC) was not pulling prior year revenue.

Defect 1428881: Project Cost Summary Level was pulling from Project Summary when it should pull from General Ledger instead. This caused the ITD Cost in the Level Down section to be different from the ITD on the Burdened Cost subtask.

Defect 1396340: Line 16, Field 1 in the generated FTP file displayed NONE instead of SERVICES even if Line 3 was SVC.

Defect 1430227: COMPANY_ID has been added to some SQL statements to improve the application's performance.

Defects 1426389 and 1431771: Updates have been made to enhance the application's performance.

Defect 1430226: COMPANY_ID has been added to some SQL statements to improve the application's performance.

Defect 1431972: You received a critical system error for deadlocks when you tried to update projects.