2023 Form 941 Updates

A draft of Form 941 for use in the first quarter of 2023 was issued by the Internal Revenue Service.

The Form 941, Employer’s Quarterly Federal Tax Return verbiage was updated as follows:

Section	Current	New
The text at the rightmost column of Lines 5a, 5a(i), 5a(ii)	*Include taxable qualified sick and family leave wages paid in 2022 for leave taken after March 31, 2021, and before October 1, 2021, on line 5a. Use lines 5a(i) and 5a(ii) only for taxable qualified sick and family leave wages paid in 2022 for leave taken after March 31, 2020, and before April 1, 2021.	*Include taxable qualified sick and family leave wages paid in this quarter for leave taken after March 31, 2021, and before October 1, 2021, on line 5a. Use lines 5a(i) and 5a(ii) only for taxable qualified sick and family leave wages paid in this quarter for leave taken after March 31, 2020, and before April 1, 2021.
Worksheet 1	Worksheet 1: Credit for Sick and Family Leave Wages for Leave Taken After March 31, 2020, and Before April 1, 2021	Worksheet 1. Credit for Qualified Sick and Family Leave Wages Paid This Quarter for Leave Taken After March 31, 2020, and Before April 1, 2021
Worksheet 2	Worksheet 2: Credit for Qualified Sick and Family Leave Wages Paid in 2022 for Leave Taken After March 31, 2021, and Before October 1, 2021	Worksheet 2: Credit for Qualified Sick and Family Leave Wages Paid This Quarter for Leave Taken After March 31, 2021, and Before October 1, 2021

The labels in the Print Quarterly Federal Payroll Tax Report were updated to reflect the changes to the Form 941.

Attention: For more information, refer to:

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

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

West Virginia Q1 2023 SUTA Electronic Filing

According to the WorkForce West Virginia Magnetic Media Wage Reporting Specifications Manual, employers must report the SOC Code (or Employee Job Title) and County Name in the Quarterly Unemployment Insurance Wage Report.

Attention: For more information, refer to the Magnetic Media Wage Reporting Specifications Manual.

Note: This enhancement requires patch dbc_800_11054.

 

Manage Employee Taxes (PRMETAX)

To support the state requirements, the Manage Employee Taxes screen provides the following updates:

Note: These updates also apply to the Taxes subtask on the Manage Employee Information screen.

• The screen provides the following new field:

Field	Description
County (WV)	Enter the county to be reported in the SUTA file. For West Virginia, enter the county name in which the majority of the employee's job duties are performed.

• The label of the Occupational/SOC Code field was updated to indicate WV (West Virginia).

• The screen displays warning messages in the following cases:

• If SUTA State is West Virginia and there is no SOC Code assigned to the employee

• If SUTA State is West Virginia and there is no County assigned to the employee

 

Manage SUTA Tax File Data (PRMSMM)

The Manage SUTA Tax File Data screen features the following updates:

• The employee’s job title shall be reported in record S, position 221-250.

• The SOC Code shall be reported in record S, position 251-256.

• The employee’s county name shall be reported in record S, position 257-271.

• An error message will display if there is at least one employee where both SOC code and job title have not been assigned to the employee.

• The screen provides standard validations for fields from the Configure Company Information screen (when applicable).

 

View Employee Taxes (PRQETAX)

• The screen provides the following new field:

Field	Description
County (WV)	This field displays the county to be reported in the SUTA file. For West Virginia, this is the county name in which the majority of the employee's job duties are performed.

• The label of the Occupational/SOC Code field was updated to indicate WV (West Virginia).

 

Print Data Dictionary Report (SYRDD)

The Print Data Dictionary Report now provides information for the new County column on the Employee Tax table.

The Costpoint 8.0.32 MR installer has been updated to include the latest quarterly patch release for WebLogic 12.2.1.4.

• January 2023 SPB - p34974729_122140_Generic.zip

Also, the Java Development Kit (JDK) is upgraded to version 1.8.0_361 and is installed with the Costpoint 8.0.32 MR installer.

Defect 1812789: Cost Date references should be removed from the Costpoint Cobra Integration Technical Guide.

Defect 1871139: When you set Option to any of the available options except All Projects, an incorrect number of records was returned when you queried a part with purchase order delivery schedule.

Defect 1871638: Supply and Demand Transfer Reservations were not correctly separated by Warehouse.

Defect 1876245: When you ran MRP, the MRP substitutes did not use up the quantities of the substitute parts according to the planning order.

Defect 1877433: The application was updated to allow wage determination for all currencies, instead of for the USD (U.S. Dollar) only. This update applies to Graham Maintenance Services LP only.

Defect 1867860: The screen displayed the incorrect pay period as Next in the Pay Cycle Data group box. As a result, if you ran the process, the application sets the incorrect pay period as the Open pay period.

Defect 1879119: The 32% federal income tax bracket for Married, Step 2 Unchecked, was 379,099.99 instead of 378,999.99. This affects all Costpoint Payroll users, including those with employees in Guam and Virgin Islands.

As a workaround for this issue, you can manually enter/update the record on the Manage Federal Taxes screen. The record for Married, Step 2 Unchecked, effective 01/01/2023, should be:

Effective Date: 01/01/2023

Filing Status: Married (S_FED_FIL_STAT_CD = M)

Step 2 of W-4: Unchecked

For Taxable Income Over	Base Tax	Percent of Excess
0.00	0.00	0.00%
14,799.99	0.00	10.00%
36,799.99	2,200.00	12.00%
104,249.99	10,294.00	22.00%
205,549.99	32,580.00	24.00%
379,099.99 378,999.99	74,208.00	32.00%
477,299.99	105,664.00	35.00%
708,549.99	186,601.50	37.00%

 

For companies with Guam and Virgin Islands employees, you can manually update the tax tables for these states on the Manage State Tax Tables screen to mirror the federal tax tables.

Defect 1878077: The tax tables for the following counties had the corresponding issues:

• Frederick County: The second row was missing in each tax table. If a married employee has an annual taxable income of over 100,000, then the tax is calculated as the amount over 100,000 times 7.75 percent. The initial 100,000 is not taxed at all because the base tax amount is missing.

• Anne Arundel County: The second row was missing in each tax table. To address this, the tables have been revised (recalculated) so that the lower income tax rate of 2.70% (using 2.75% tables) will be used on the first $50,000 of taxable income for every taxpayer. The base tax has been recalculated starting from the second row.

As a workaround for these issues, you can manually enter/update the records for Anne Arundel County and Frederick County on the Manage State Tax Tables screen.

Anne Arundel County

State: MD

Effective Date: 01/01/2023

Filing Status: Anne Arundel - Married/Head of Household (ANNE ARUNDEL-MARRIED)

For Taxable Income Over	Base Tax	Percent of Excess
0.00	0.00	7.5000%
50,000.00	3,750.00	7.6000%
150,000.00	11,350.00	7.8500%
175,000.00	13,312.50	8.1000%
225,000.00	17,362.50	8.3500%
300,000.00	23,625.00	8.6000%

 

State: MD

Effective Date: 01/01/2023

Filing Status: Anne Arundel - Single or Married w/h at Single rate (ANNE ARUNDEL-SINGLE)

For Taxable Income Over	Base Tax	Percent of Excess
0.00	0.00	7.5000%
50,000.00	3,750.00	7.6000%
100,000.00	7,550.00	7.8500%
125,000.00	9,512.50	8.1000%
150,000.00	11,537.50	8.3500%
250,000.00	19,887.50	8.6000%

 

Frederick County

State: MD

Effective Date: 01/01/2023

Filing Status: Frederick - Married/Head of Household (FREDERICK-MARRIED)

For Taxable Income Over	Base Tax	Percent of Excess
0.00	0.00	7.5000%
100,000.00	0.00 7,750.00	7.7500%
150,000.00	11,625.00	8.0000%
175,000.00	13,625.00	8.2500%
225,000.00	17,750.00	8.5000%
300,000.00	24,125.00	8.7500%

 

State: MD

Effective Date: 01/01/2023

Filing Status: Frederick - Single or Married w/h at Single rate (FREDERICK-SINGLE)

For Taxable Income Over	Base Tax	Percent of Excess
0.00	0.00	7.5000%
50,000.00	0.00 3,875.00	7.7500%
100,000.00	7,750.00	8.0000%
125,000.00	9,750.00	8.2500%
150,000.00	11,812.50	8.5000%

Defect 1870820: If the benefit plan’s Coverage Calculation Method was Coverage Table, and the Coverage Table was Age, the application calculated contributions using the Coverage Limit on the Manage Benefit Plans screen. Instead, the application should use the limit on the Manage Coverage Amounts by Age screen.

Defect 1866810: The Administrator column has been renamed NB Admin.

Defect 1867850: The Burden Template field has been disabled and set to DEFAULT to fix the issue that occurs when the Use Reorg Structure field in Configuration Settings is set to Yes.

Defect 1874589: You encountered deadlock issues when multiple users were simultaneously creating, committing, and approving a budget.

Defect 1867670: The project P&L report details did not display when the Budget Group setting was BUDGET but displayed when the setting was BUD.

Defect 1874585: The temporary table for PSR_PY_SUM did not generate data when you created an EAC.

Defect 1848173: You encountered deadlock issues when multiple users were simultaneously creating, committing, and approving a budget/EAC.

Defect 1870177: Revenue adjustments were not taken into account during Over Ceiling - Funding calculation. This resulted in an incorrect value that displayed on the Revenue Analysis screen.

Defect 1871036: When an indirect Period of Performance (PoP) was shortened, newly created budgets/EACs did not pick up the revised start date and the forecast data either went missing or was moved.

Defect 1872025: The Burden Template field has been disabled and set to DEFAULT to fix the issue that occurs when the Use Reorg Structure field in Configuration Settings is set to Yes.

Defect 1879353: You encountered issues when creating, committing, and approving a budget/EAC.

Defect 1707891: When you calculated retroactive bills for the RSBFNLBF (Loaded Labor Rate w/Burden w/Fee plus Non-Labor w/Burden w/Fee) formula, the fee calculation did not take labor discounts into account.

As a workaround, you can manually edit fee amounts on the Manage Standard Bills screen.

Defect 1708002: Fee calculations were incorrect for multicurrency bills with an LLRFNLBF (LLR w/Fee Plus Non-Labor w/Burden w/Fee) formula and labor discounts.

As a workaround, you can manually edit fee amounts on the Manage Standard Bills screen.

Defect 1869258: The application was not picking up rows with MUX_RATE_GRP_ID set to null in the BILLING_DETL_HIST table during calculation.

Defect 1871826: Support was added for the following new currency codes: SLE, STN, SVC, UYW, VED, VES, and ZWL.

Defect 1877380: When you entered two identical meals as an Entertainment expense but did not save prior to entering the second one, you did not receive a duplication error.

Defect 1869440: When you approved a signed timesheet, you received an error message with a server log attached. No errors were displayed when viewing and opening the timesheets.

Defect 1874652: When you saved a timesheet with 56 hours recorded, you received an error stating that the timesheet has fewer than the minimum number of regular hours.