U.S. 2022 Payroll Tax Update

This tax update applies to:

  • Microsoft Dynamics GP on Microsoft SQL Server

This article provides guidance for how to install the 2022 U.S. Payroll Tax Update for Microsoft Dynamics GP and describes changes.

The fifth tax update for 2022 replaces all previous tax updates. It includes state tax table changes that take effect May 1, 2022. We recommend that you install this update as soon as you can for the year 2022.

This document assumes that you are familiar with the Microsoft Dynamics GP U.S. Payroll module.

Check out these blogs for detailed documentation on how you calculate payroll taxes in Microsoft Dynamics GP:

How to calculate Federal Tax with Dependent Claim Aount Field

Does Microsoft Dynamics GP calculate tax correctly?

Changes in June Round 5 update (Released 6/8/2022)

  • Utah

2022 state or territorial tax changes

The following tax changes are included in this update:

Withholding changes for Utah

All filing status have a fixed flat tax of 4.85% from 4.95%

  • MAR - Married - Base Allowance Exemption amount $780.00 prior amount $720.00

  • SINGLE - Single - Base Allowance Exemption amount $390.00 prior amount $360.00

  • MAR - Married - Tax Rate of 1.3% anything over $15,548 prior amount $14,256 (held in Special tax table)

  • SINGLE - Single - Tax Rate of 1.3% anything over $7,774.00 prior amount $7,128.00 (held in Special tax table)

Changes in May Round 4 update (Released 5/12/2022)

  • Alabama

2022 state or territorial tax changes

The following tax changes are included in this update:

Withholding changes for Alabama

In May the state of Alabama increased the standard deduction for married filing joint taxpayers by $1,000 and increased the standard deduction for single, head of family, and married filing separately taxpayers by $500. The act also changed the qualifying threshold for the $1,000 dependent exemption from gross income of $20,000 or less to gross income of $50,000 or less. The qualifying threshold for the $500 dependent exemption has changed from gross income of $20,000 or more to gross income of $50,000 or more.

The Income tax table did not change.

Personal Exemption Tax Type rates for HOF filling Status:

If Over But Not Over Tax Amount Tax Rate On Excess Over
0 26,000 5,200 0% 0
26,000 26,500 5,065 0% 0
26,500 27,000 4,930 0% 0
27,000 27,500 4,795 0% 0
27,500 28,000 4,660 0% 0
28,000 28,500 4,525 0% 0
28,500 29,000 4,390 0% 0
29,000 29,500 4,255 0% 0
29,500 30,000 4,120 0% 0
30,000 30,500 3,985 0% 0
30,500 31,000 3,850 0% 0
31,000 31,500 3,715 0% 0
31,500 32,000 3,580 0% 0
32,000 32,500 3,445 0% 0
32,500 33,000 3,310 0% 0
33,000 33,500 3,175 0% 0
33,500 34,000 3,040 0% 0
34,000 34,500 2,905 0% 0
34,500 35,000 2,770 0% 0
35,000 35,500 2,635 0% 0
35,500 And over 2,500 0% 0

Personal Exemption Tax Type rates for MAR filling Status:

If Over But Not Over Tax Amount Tax Rate On Excess Over
0 26,000 8,500 0% 0
26,000 26,500 8,325 0% 0
26,500 27,000 8,150 0% 0
27,000 27,500 7,975 0% 0
27,500 28,000 7,800 0% 0
28,000 28,500 7,625 0% 0
28,500 29,000 7,450 0% 0
29,000 29,500 7,275 0% 0
29,500 30,000 7,100 0% 0
30,000 30,500 6,925 0% 0
30,500 31,000 6,750 0% 0
31,000 31,500 6,575 0% 0
31,500 32,000 6,400 0% 0
32,000 32,500 6,225 0% 0
32,500 33,000 6,050 0% 0
33,000 33,500 5,875 0% 0
33,500 34,000 5,700 0% 0
34,000 34,500 5,525 0% 0
34,500 35,000 5,350 0% 0
35,000 35,500 5,175 0% 0
35,500 And over 5,000 0% 0

Personal Exemption Tax Type rates for MFS filling Status:

If Over But Not Over Tax Amount Tax Rate On Excess Over
0 13,000 4,250 0% 0
13,000 13,250 4,162 0% 0
13,250 13,500 4,074 0% 0
13,500 13,750 3,986 0% 0
13,750 14,000 3,898 0% 0
14,000 14,250 3,810 0% 0
14,250 14,500 3,722 0% 0
14,500 14,750 3,634 0% 0
14,750 15,000 3,546 0% 0
15,000 15,250 3,458 0% 0
15,250 15,500 3,370 0% 0
15,500 15,750 3,282 0% 0
15,750 16,000 3,194 0% 0
16,000 16,250 3,106 0% 0
16,250 16,500 3,018 0% 0
16,500 16,750 2,930 0% 0
16,750 17,000 2,842 0% 0
17,000 17,250 2,754 0% 0
17,250 17,500 2,666 0% 0
17,500 17,750 2,578 0% 0
17,750 And over 2,500 0% 0

Personal Exemption Tax Type rates for SINGLE and ZERO filling Status:

If Over But Not Over Tax Amount Tax Rate On Excess Over
0 26,000 3,000 0% 0
26,000 26,500 2,975 0% 0
26,500 27,000 2,950 0% 0
27,000 27,500 2,925 0% 0
27,500 28,000 2,900 0% 0
28,000 28,500 2,875 0% 0
28,500 29,000 2,850 0% 0
29,000 29,500 2,825 0% 0
29,500 30,000 2,800 0% 0
30,000 30,500 2,775 0% 0
30,500 31,000 2,750 0% 0
31,000 31,500 2,725 0% 0
31,500 32,000 2,700 0% 0
32,000 32,500 2,675 0% 0
32,500 33,000 2,650 0% 0
33,000 33,500 2,625 0% 0
33,500 34,000 2,600 0% 0
34,000 34,500 2,575 0% 0
34,500 35,000 2,550 0% 0
35,000 35,500 2,525 0% 0
35,500 And over 2,500 0% 0

Special Tax Type rates for HOF, MFS, SINGLE, Zero, and MAR filling Status:

If Over But Not Over Tax Amount Tax Rate On Excess Over
0 50,000 1,000 0% 0
50,000 100,000 500 0% 0
100,000 And Over 300 0% 0

Changes in March Round 3 update (Released 3/23/2022)

  • Colorado

2022 state or territorial tax changes

The following tax changes are included in this update:

Withholding changes for Colorado

In January the state of Colorado released a new form for 2022 called DR-0004 this is optional for an employee to complete. This new form does not coincide with our tax tables very well, so a new tax update was released.

All filing status have the same fixed flat tax of 4.55%

The following new filing status were added:

  • HOH1J - Head of Household 1 Job - Exemption amount $16,500
  • MAR1J - Married Filing Jointly 1 Job - Exemption amount $23,000
  • SIN1J - Single/Mar filing Single 1 Job - Exemption amount $10,500

Existing Filing Status remain unchanged:

  • MAR - Married - Exemption amount $8,000
  • SINGLE - Single - Exemption amount $4,000

There are 2 other parts to this form that have many different exemption amounts, we cannot accommodate all of them in the tax tables. A new “OTHER” filing status was added (OTH1J) with Exemption increments of $500 that will accommodate all the "other" amounts on the form if an employee enters.

OTH1J - OTH, +1 Jobs or Child Cr Allow - Exemption amount of $500

As an example, lets say I fill out the form and choose an amount of 2500 – it does not match any of the above filing status so I would pick the OTHER status and put a 5 under Cards | Payroll | State Tax in the Number of Dependents field OR Additional Allowances. Which is 2500/500 = 5.

Another example, I put 5500 on the form. Again, that does not match the other filing status, so I choose Other and put 11.

Changes in January Round 2 update (Released 1/20/2022)

Note

If you have employees set up to withhold Wisconsin state tax, then, when you apply this update, you must also apply the January 2022 Hotfix (code) for the Wisconsin state taxes to be correct for the year 2022.

2022 state or territorial tax changes

The following tax changes are included in this update:

Withholding changes for Arkansas

Tax Type rates for Filing Status NA

If Over    But Not Over    Tax Amount    Tax Rate    On Excess Over   
0 4,999 0 0.0% 0
4,999 9,999 -99.98 2.0% 0
9,999 14,299 -199.97 3.0% 0
14,299 23,599 -257.17 3.4% 0
23,599 39,699 -634.75 5.0% 0
39,699 84,500 -833.25 5.5% 0
84,500 84,600 -823.50 5.5% 0
84,600 84,700 -813.50 5.5% 0
84,700 84,800 -803.50 5.5% 0
84,800 84,900 -793.50 5.5% 0
84,900 85,000 -783.50 5.5% 0
85,000 85,100 -773.50 5.5% 0
85,100 85,200 -763.50 5.5% 0
85,200 85,300 -753.50 5.5% 0
85,300 85,400 -743.50 5.5% 0
85,400 85,500 -733.50 5.5% 0
85,500 85,600 -723.50 5.5% 0
85,600 85,700 -713.50 5.5% 0
85,700 85,800 -703.50 5.5% 0
85,800 85,900 -693.50 5.5% 0
85,900 86,000 -683.50 5.5% 0
86,000 86,100 -673.50 5.5% 0
86,100 86,200 -663.50 5.5% 0
86,200 86,300 -653.50 5.5% 0
86,300 86,400 -643.50 5.5% 0
86,400 86,500 -633.50 5.5% 0
86,500 86,600 -623.50 5.5% 0
86,600 86,700 -613.50 5.5% 0
86,700 86,800 -603.50 5.5% 0
86,800 86,900 -593.50 5.5% 0
86,900 87,000 -583.50 5.5% 0
87,000 87,100 -573.50 5.5% 0
87,100 87,200 -563.50 5.5% 0
87,200 87,300 -553.50 5.5% 0
87,300 87,400 -543.50 5.5% 0
87,400 87,500 -533.50 5.5% 0
87,500 87,600 -523.50 5.5% 0
87,600 87,700 -513.50 5.5% 0
87,700 87,800 -503.50 5.5% 0
87,800 87,900 -493.50 5.5% 0
87,900 88,000 -483.50 5.5% 0
88,000 88,100 -473.50 5.5% 0
88,100 88,200 -463.50 5.5% 0
88,200 88,300 -453.50 5.5% 0
88,300 88,400 -443.50 5.5% 0
88,400 88,500 -433.50 5.5% 0
88,500 88,600 -423.50 5.5% 0
88,600 88,700 -413.50 5.5% 0
88,700 88,800 -403.50 5.5% 0
88,800 88,900 -393.50 5.5% 0
88,900 89,000 -383.50 5.5% 0
89,000 89,100 -373.50 5.5% 0
89,100 89,200 -363.50 5.5% 0
89,200 89,300 -353.50 5.5% 0
89,300 89,400 -343.50 5.5% 0
89,400 89,500 -333.50 5.5% 0
89,500 89,600 -323.50 5.5% 0
89,600 89,700 -313.50 5.5% 0
89,700 89,800 -303.50 5.5% 0
89,800 89,900 -293.50 5.5% 0
89,900 90,000 -283.50 5.5% 0
90,000 90,100 -273.50 5.5% 0
90,100 90,200 -263.50 5.5% 0
90,200 90,300 -253.50 5.5% 0
90,300 90,400 -243.50 5.5% 0
90,400 90,500 -233.50 5.5% 0
90,500 90,600 -223.50 5.5% 0
90,600 And over -213.50 5.5% 0

Withholding changes for Illinois

The Dependent Exemptions is $2,425 The Flat tax rate remains at 4.95 and allowances at 1,000

Withholding changes for Louisiana

The Flat tax rate for all filing status is 1.85 from 2.2

Special Type rates for EXEMPT and SM1 Filing Status:

If Over But Not Over Tax Amount Tax Rate On Excess Over
0 50,000 0 1.65% 12,500
50,000 And Over 0 .075% 50,000

Special Type rates for M2 Filing Status:

If Over But Not Over Tax Amount Tax Rate On Excess Over
0 1000,000 0 1.65% 25,000
100,000 And Over 0 .075% 100,000

Withholding changes for Minnesota

The Personal Exemption amount is $4,450 for all Filing Status.

Withholding rates for taxpayers filing as MAR:

If Over But Not Over Tax Amount Tax Rate On Excess Over
0 12,450 0 0% 0
12,450 53,500 0 5.35 12,450
53,500 175,510 2,196.18 6.80% 53,500
175,510 297,260 10,492.86 7.85% 175,510
297,260 And Over 20,050.24 9.85% 297,260

Withholding rates for taxpayers filing as SINGLE:

If Over But Not Over Tax Amount Tax Rate On Excess Over
0 4,000 0 0% 0
4,000 32,080 0 5.35% 4,000
32,080 96,230 1,502.28 6.80% 32,080
96,230 175,220 5,864.48 7.85% 96,230
175,220 And Over 12,065.20 9.85% 175,220

Withholding changes for North Carolina

Standard Deduction for HOH is $19,125 Standard Deduction for MAR and SINGLE is $12,750

Tax rate for all filing status is 5.09%

Withholding changes for North Dakota

Note

Per the state of North Dakota, there is no HOH filing status with exemptions. If an employee on the W4 chooses Filing status of HOH and does not mark step 2, you still choose HOH as the filing status in Dynamics GP.

The state relies on the Federal form W-4 to calculate the amount to withhold. Per the state, Step 3 for Dependent Claim amount is not used for ND state tax withholding.

Withholding rates for taxpayers filing as MAR and MARHR :

If Over But Not Over Tax Amount Tax Rate On Excess Over
0 12,950 0 0% 0
12,950 47,800 0 1.10% 12,950
47,800 97,175 383.35 2.04% 47,800
97,175 141,275 1,390.60 2.27% 97,175
141,275 242,125 2,391.67 2.64% 141,275
242,125 And Over 5,054.11 2.90% 242,125

Withholding rates for taxpayers filing as SINGLE and SINGHR:

If Over But Not Over Tax Amount Tax Rate On Excess Over
0 6,475 0 0% 0
6,475 48,250 0 1.10% 6,475
48,250 107,525 459,53 2.04% 48,250
107,525 217,300 1,668.74 2.27% 107,525
217,300 464,825 4,160.63 2.64% 217,300
464,825 And Over 10,695.29 2.90% 464,825

Withholding rates for taxpayers filing as HOHHR:

If Over But Not Over Tax Amount Tax Rate On Excess Over
0 9,700 0 0% 0
9,700 65,600 0 1.10% 9,700
65,600 154,100 614.90 2.04% 65,600
154,100 243,450 2,420.30 2.27% 154,100
243,450 468,050 4,448.55 2.64% 243,450
468,050 And Over 10,377.99 2.90% 468,050

Withholding changes for Rhode Island

For all Filing Status the Personal Exemption ($1,000) wage limit increased to $241,850

Withholding rates for taxpayers filing as MAR and SINGLE

If Over    But Not Over    Tax Amount    Tax Rate    On Excess Over   
0 68,200 0 3.75% 0
68,200 155,050 2,557.50 4.75% 68,200
155,050 And Over 6,682.88 5.99% 155,050

Withholding changes for Vermont

The Personal Exemption amount is $4,500

Withholding rates for taxpayers filing as MAR

If Over    But Not Over    Tax Amount    Tax Rate    On Excess Over   
0 9,788 0 0% 0
9,788 80,238 0 3.35% 9,788
80,238 180,088 2,360.08 6.60% 80,238
180,088 269,288 8,950.18 7.60% 180,088
269,288 And Over 15,729.38 8.75% 269,288

Withholding rates for taxpayers filing as SINGLE

If Over    But Not Over    Tax Amount    Tax Rate    On Excess Over   
0 3,250 0 0% 0
3,250 45,400 0 3.35% 3,250
45,400 105,450 1,412.03 6.60% 45,400
105,450 216,400 5,375.33 7.60% 105,450
216,400 And Over 13,807.53 8.75% 216,400

Withholding changes for Wisconsin

January Hotfix Code is required to install this tax update for the state of WI

Added to the Sequence of WI tax calculation Apply Special Table for Deduction Exemption

The Personal Exemption amount is $400.00

Tax Type rates for SINGLE and MAR Filing Status:

If Over But Not Over Tax Amount Tax Rate On Excess Over
0 12,760 0 3.54% 0
12,760 25,520 451.70 4.65% 12,760
25,520 280,950 1,045.04 5.30% 25,520
280,950 And Over 14,582.83 7.65% 280,950

Special Type rates for MAR Filing Status:

If Over But Not Over Tax Amount Tax Rate On Excess Over
0 25,727 9,461 0% 0
25,727 73,032 0 20% 0
73,032 And Over 0 0% 0

Special Type rates for SINGLE Filing Status:

If Over But Not Over Tax Amount Tax Rate On Excess Over
0 17,780 6,702 0% 0
17,780 73,630 0 12% 0
73,650 And Over 0 0% 0

Changes in January Round 1 update (Released 12/21/2021)

  • FICA Social Security Limit $147,000
  • Federal tax tables added 12/30/2021
  • California
  • Georgia
  • Iowa
  • Kentucky
  • Maine
  • Maryland
  • Michigan
  • Missouri
  • Nebraska
  • New Mexico
  • New York
  • Oklahoma
  • Oregon
  • South Carolina
  • Yonkers

2022 Federal tax changes

The maximum taxable earnings for Social Security increase in 2022 to $147,000 from $142,800.

Federal tax tables released 12/30/2021

The Personal Exemption is $4,300 for SINGLE, MAR, HOH, NRA

Withholding rates for taxpayers filing as NRA

Note

For non-resident aliens, if the employee filled out a W-4 after 01/01/2020, the filing status Non Resident Alien HR (NRAHR) must always be used.

If Over But Not Over Tax Amount Tax Rate On Excess Over
0 13,000 0 0% 0
13,000 23,275 0 10% 13,000
23,275 54,775 1,027.00 12% 23,275
54,775 102,075 4,807.50 22% 54,775
102,075 183,050 15,213.50 24% 102,075
183,050 228,950 34,647.50 32% 183,050
228,950 552,900 49,335.50 35% 228,950
552,900 And Over 162,718.00 37% 552,900

Withholding rates for taxpayers filing as NRAHR

If Over But Not Over Tax Amount Tax Rate On Excess Over
19,425 0 0% 0
19,425 24,563 0 10% 19,425
24,563 40,313 513.75 12% 24,563
40,313 63,963 2,403.75 22% 40,313
63,963 104,450 7,606.75 24% 63,963
104,450 127,400 17,323.75 32% 104,450
127,400 289,375 24,667.75 35% 127,400
289,375 And Over 81,359.00 37% 289,375

Withholding rates for taxpayers filing as MAR

If Over But Not Over Tax Amount Tax Rate On Excess Over
0 13,000 0 0% 0
13,000 33,550 0 10% 13,000
33,550 96,550 2,055.00 12% 33,550
96,550 191,150 9,615.00 22% 96,550
191,150 353,100 30,427.00 24% 191,150
353,100 444,900 69,295.00 32% 353,100
444,900 660,850 98,671.00 35% 444,900
60,850 And Over 174,253.50 37% 660,850

Withholding rates for taxpayers filing as MARHR:

If Over But Not Over Tax Amount Tax Rate On Excess Over
0 12,950 0 0% 0
12,950 23,225 0 10% 12,950
23,225 54,725 1,027.50 12% 23,225
54,725 102,025 4,807.50 22% 54,725
102,025 183,000 15,213.50 24% 102,025
183,000 228,900 34,647.50 32% 183,000
228,900 336,875 49,335.50 35% 228,900
336,875 And Over 87,126.75 37% 336,875

Withholding rates for taxpayers filing as SINGLE:

If Over But Not Over Tax Amount Tax Rate On Excess Over
0 4,350 0 0% 0
4,350 14,625 0 10% 4,350
14,625 46,125 1,027.50 12% 14,625
46,125 93,425 4,807.50 22% 46,125
93,425 174,400 15,213.50 24% 93,425
174,400 220,300 34,647.50 32% 174,400
220,300 544,250 49,335.50 35% 220,300
544,250 And Over 162,718.00 37% 544,250

Withholding rates for taxpayers filing as SGLHHR:

If Over But Not Over Tax Amount Tax Rate On Excess Over
0 6,475 0 0% 0
6,475 11,613 0 10% 6,475
11,613 27,363 513.75 12% 11,613
27,363 51,013 2,403.75 22% 27,363
51,013 91,500 7,606.75 24% 51,013
91,500 114,450 17,323.75 32% 91,500
114,450 276,425 24,667.75 35% 114,450
276,425 And Over 81,359.00 37% 276,425

Withholding rates for taxpayers filing as HOH:

If Over But Not Over Tax Amount Tax Rate On Excess Over
0 10,800 0 0% 0
10,800 25,450 0 10% 10,800
25,450 66,700 1,465.00 12% 25,450
66,700 99,850 6,415.00 22% 66,700
99,850 180,850 13,708.00 24% 99,850
180,850 226,750 33,148.00 32% 180,850
226,750 550,700 47,836.00 35% 226,750
550,700 And Over 161,218.50 37% 550,700

Withholding rates for taxpayers filing as HOHHR:

If Over But Not Over Tax Amount Tax Rate On Excess Over
0 9,700 0 0% 0
9,700 17,025 0 10% 9,700
17,025 37,650 732.50 12% 17,025
37,650 54,225 3,207.50 22% 37,650
54,225 94,725 6,854.00 24% 54,225
94,725 117,675 16,574.00 32% 94,725
117,675 279,650 23,918.00 35% 117,675
279,650 And Over 80,609.25 37% 279,650

2022 state or territorial tax changes

The following tax changes are included in this update:

Withholding changes for California

For Filing Status of HOH and MAR2:

  • Personal Exemption is $141.90 from $136.40
  • Standard Deduction is $9,606 from $9,202
  • Low Income Limit is $31,831 from $30,534

For Filing Status of MAR1 and SINGLE:

  • Personal Exemption is $141.90 from $136.40
  • Standard Deduction is $4,803 from $4,601
  • Low Income Limit is $15,916 from $15,267

Withholding rates for taxpayers filing as HOH:

If Over But Not Over Tax Amount Tax Rate On Excess Over
0 18,663 0 1.1% 0
18,663 44,217 205.29 2.2% 18,663
44,217 56,999 767.48 4.4% 44,217
56,999 70,542 1,329.89 6.6% 56,999
70,542 83,324 2,223.73 8.8% 70,542
83,324 425,251 3,348.55 10.23% 83,324
425,251 510,303 38,327.68 11.33% 425,251
510,303 850,503 47,964.07 12.43% 510,303
850,503 1,000,000 90,250.93 13.53% 850,503
1,000,000 And Over 110,477.87 14.63% 1,000,000

Withholding rates for taxpayers filing as MAR1 and MAR2

If Over But Not Over Tax Amount Tax Rate On Excess Over
0 18,650 0 1.1% 0
18,650 44,214 205.15 2.2% 18,650
44,214 69,784 767.56 4.4% 44,214
69,784 96,870 1,892.64 6.6% 69,784
96,870 122,428 3,680.32 8.8% 96,870
122,428 625,372 5,929.42 10.23% 122,428
625,372 750,442 57,380.59 11.33% 625,372
750,442 1,000,000 71,551.02 12.43% 750,442
1,000,000 1,250,738 102,571.08 13.53% 1,000,000
1,250,738 And Over 136,495.93 14.63% 1,250,738

Withholding rates for taxpayers filing as SINGLE:

If Over But Not Over Tax Amount Tax Rate On Excess Over
0 9,325 0 1.1% 0
9,325 22,107 102.58 2.2% 9,325
22,107 34,892 383.78 4.4% 22,107
34,892 48,435 946.32 6.6% 34,892
48,435 61,214 1,840.16 8.8% 48,435
61,214 312,686 2,964.71 10.23% 61,214
312,686 375,221 28,690.30 11.33% 312,686
375,221 625,369 35,775.52 12.43% 375,221
625,369 1,000,000 66,868.92 13.53% 625,369
1,000,000 And Over 117,556.49 14.63% 1,000,000

Withholding changes for Georgia

The Standard Deduction Amount for Filing Status:

  • HOH and SINGLE is $5,400
  • MFJ1I is $7,100
  • MFJ2I and MFS is $3,550

Withholding changes for Iowa

The Standard Deduction Amount for Filing Status:

  • EXP1 is $2,210
  • Filing Status EXP2 is $5,450

Withholding rates for taxpayers filing as EXP1 and EXP2 are as follows:

If Over But Not Over Tax Amount Tax Rate On Excess Over
0 1,743 0 0.33% 0
1,743 3,486 5.75 0.67% 1,743
3,486 6,972 17.43 2.25% 3,486
6,972 15,687 95.87 4.14% 6,972
15,687 26,145 456.67 5.63% 15,687
26,145 34,860 1,045.46 5.96% 26,145
34,860 52,290 1,564.87 6.25% 34,860
52,290 78,435 2,654.25 7.44% 52,290
78,435 And over 4,599.44 8.53% 78,435

Withholding changes for Kentucky

The Standard Deduction Amount is $2,770 from $2,690 The Tax Rate remains at 5%

Withholding changes for Maine

  • Personal Exemption is $4,450

Withholding rates for taxpayers filing as SINGLE, Tax table type

If Over But Not Over Tax Amount Tax Rate On Excess Over
0 23,000 0 5.8% 0
23,000 54,450 1,334 6.75% 23,000
54,450 And over 3,457 7.15% 54,450

Special table type

If Over But Not Over Tax Amount Tax Rate On Excess Over
0 85,850 0 0 10,100
85,850 160,850 75,000 0 0

Withholding rates for taxpayers filing as MAR, Tax table type

If Over But Not Over Tax Amount Tax Rate On Excess Over
0 46,000 5.80% 0
46,000 108,900 2,668 6.75% 46,000
108,900 And Over 6,914 7.15% 108,900

Special table type

If Over But Not Over Tax Amount Tax Rate On Excess Over
0 171,700 0 0 23,050
171,700 321,700 150,000 0 0

Withholding changes for Maryland

For Filing Status of SMMAR (St. Mary MFJ/HOH).

Withholding rates for taxpayer:

If Over But Not Over Tax Amount Tax Rate On Excess Over
0 5,000 0 0% 0
5,000 150,000 0 7.85% 0
150,000 175,000 11,775 8.10% 150,000
175,000 225,000 13,800 8.35% 175,000
225,000 300,000 17,975 8.6% 225,000
300,000 And over 24,425 8.85% 300,000

For Filing Status of STMARY (St. Mary SGL/DEP/MFS):

If Over But Not Over Tax Amount Tax Rate On Excess Over
0 5,000 0 0% 0
5,000 100,000 0 7.85% 0
100,000 125,000 7,850 8.10% 100,000
125,000 150,000 9,875 8.35% 125,000
150,000 250,000 11,962.50 8.6% 150,000
250,000 And over 20,562.50 8.85% 250,000

For Filing Status of WASHTN (Washington SGL/DEP/MFS):

If Over But Not Over Tax Amount Tax Rate On Excess Over
0 5,000 0 0% 0
5,000 100,000 0 7.75% 0
100,000 125,000 7,750 8.00% 100,000
125,000 150,000 9,750 8.25% 125,000
150,000 250,000 11,812.50 8.5% 150,000
250,000 And over 20,312.50 8.75% 250,000

For Filing Status of WHMAR (Washington MFJ/HOH):

If Over But Not Over Tax Amount Tax Rate On Excess Over
0 5,000 0 0% 0
5,000 150,000 0 7.75% 0
150,000 175,000 11,625 8.0% 150,000
175,000 225,000 13,625 8.25% 175,000
225,000 300,000 17,750 8.5% 225,000
300,000 And over 24,125 8.75% 300,000

Withholding changes for Michigan

The Personal Exemption Amount is $5,000 from $4,900 The Tax Rate remains at 4.25%

Withholding changes for Missouri

The Standard Deduction is $19,400 for filing status HOH The Standard Deduction is $25,900 for filing status MAR1 The Standard Deduction is $12,950 for filing status MAR2 and SINGLE

Withholding rates for all filing status

If Over But Not Over Tax Amount Tax Rate On Excess Over
0 1,121 0 1.5% 0
1,121 2,242 17.00 2.0% 1,121
2,242 3,363 39.00 2.5% 2,242
3,363 4,484 67.00 3.0% 3,363
4,484 5,605 101.00 3.5% 4,484
5,605 6,726 140.00 4.0% 5,605
6,726 7,847 185.00 4.50% 6,726
7,847 8,968 235.00 5.0% 7,847
8,968 And over 291.00 5.3% 8,968

Withholding changes for Nebraska

The Personal Exemption amount is $2,080 for Filing Status MAR and SINGLE.

Withholding rates for taxpayers filing as MAR:

If Over But Not Over Tax Amount Tax Rate On Excess Over
0 7,100 0 0 0
7,100 11,270 0 2.26% 7,100
11,270 28,070 94.24 3.22% 11,270
28,070 43,670 635.20 4.91% 28,070
43,670 54,180 1,401.16 6.20% 43,670
54,180 71,850 2,052.78 6.59% 54,180
71,850 And over 3,217.23 6.95% 71,850

Withholding rates for taxpayers filing as SINGLE:

If Over But Not Over Tax Amount Tax Rate On Excess Over
0 2,975 0 0 0
2,975 5,820 0 2.26% 2,975
5,820 18,900 64.30 3.22% 5,820
18,900 27,390 485.48 4.91% 18,900
27,390 34,780 902.34 6.20% 27,390
34,780 65,310 1,360.52 6.59% 34,780
65,310 And over 3,372.45 6.95% 65,310

Withholding changes for New Mexico

Withholding rates for taxpayers filing as MAR:

If Over But Not Over Tax Amount Tax Rate On Excess Over
0 12,950 0 0% 0
12,950 20,950 0 1.70% 12,950
20,950 28,950 136.00 3.2% 20,950
28,950 36,950 392.00 4.7% 28,950
36,950 52,950 768.00 4.9% 36,950
52,950 76,950 1,552.00 4.9% 52,950
76,950 112,950 2,728.00 4.9% 76,950
112,950 212,950 4,492.00 4.9% 112,950
212,950 327,950 9,392.00 4.9% 212,950
327,950 And Over 15,027.00 5.9% 327,950

Withholding rates for taxpayers filing as SINGLE:

If Over But Not Over Tax Amount Tax Rate On Excess Over
0 6,475 0 0% 0
6,475 11,975 0 1.7% 6,475
11,975 17,475 93.50 3.2% 11,975
17,475 22,475 269.50 4.7% 17,475
22,475 32,475 504.50 4.9% 22,475
32,475 48,475 994.50 4.9% 32,475
48,475 71,475 1,778.50 4.9% 48,475
71,475 131,475 2,905.50 4.9% 71,475
131,475 216,475 5,845.50 4.9% 131,475
216,475 And Over 10,010.50 5.9% 216,475

Withholding rates for taxpayers filing as HOH:

If Over But Not Over Tax Amount Tax Rate On Excess Over
0 9,700 0 0% 0
9,700 17,700 0 1.7% 9,700
17,700 25,700 136.00 3.2% 17,700
25,700 33,700 392.00 4.7% 25,700
33,700 49,700 768.00 4.9% 33,700
49,700 73,700 1,552.00 4.9% 49,700
73,700 109,700 2,728.00 4.9% 73,700
109,700 209,700 4,492.00 4.9% 109,700
209,700 324,700 9,392.00 4.9% 209,700
324,700 And Over 15,027.00 5.9% 324,700

Withholding changes for New York and New York-Yonkers

Withholding rates for taxpayers filing as MAR:

If Over But Not Over Tax Amount Tax Rate On Excess Over
0 8,500 0 .0400 0
8,500 11,700 340.00 .0450 8,500
11,700 13,900 484.00 .0525 11,700
13,900 80,650 600.00 .0585 13,900
80,650 96,800 4,504.00 .0625 80,650
96,800 107,650 5,514.00 .0711 96,800
107,650 157,650 6,285.00 .0761 107,650
157,650 211,550 10,090.00 .0804 157,650
211,550 323,200 14,425.00 .0675 211,550
323,200 373,200 21,961.00 .1123 323,200
373,200 1,077,550 27,576.00 .0735 373,200
1,077,550 2,155,350 79,346.00 .0765 1,077,550
2,155,350 5,000,000 0 .1045 0
5,000,000 25,000,000 0 .1110 0
25,000,000 And over 0 .1170 0

Withholding rates for taxpayers filing as SINGLE:

If Over But Not Over Tax Amount Tax Rate On Excess Over
0 8,500 0 .0400 0
8,500 11,700 340.00 .0450 8,500
11,700 13,900 484.00 .0525 11,700
13,900 80,650 600.00 .0585 13,900
80,650 96,800 4,504.00 .0625 80,650
96,800 107,650 5,541.00 .0732 96,800
107,650 157,650 6,308.00 .0782 107,650
157,650 215,400 10,219.00 .0675 157,650
215,400 265,400 14,117.00 .0994 215,400
265,400 1,077,550 19,085.00 .0735 265,400
1,077,550 5,000,000 0 .1045 0
5,000,000 25,000,000 0 .1110 0
25,000,000 And over 0 .1170 0

Withholding changes for Oklahoma

Withholding rates for taxpayers filing as MARH:

If Over But Not Over Tax Amount Tax Rate On Excess Over
0 12,700 0 0% 0
12,700 14,700 0 .25% 12,700
14,700 17,700 5.00 .75% 14,700
17,700 20,200 27.50 1.75% 17,700
20,200 22,500 71.25 2.75% 20,200
22,500 24,900 134.50 3.75% 22,500
24,900 And Over 224.50 4.75% 24,900

Withholding rates for taxpayers filing as SINGLE, MFS, MAR2:

If Over But Not Over Tax Amount Tax Rate On Excess Over
0 6,350 0 0% 0
6,350 7,350 0 .25% 6,350
7,350 8,850 2.50 .75% 7,350
8,850 10,100 13.75 1.75% 8,850
10,100 11,250 35.63 2.75% 10,100
11,250 13,550 67.25 3.75% 11,250
13,550 And Over 153.50 4.75% 13,550

Withholding changes for Oregon

The Standard Deduction Amount is $4,840 for MS3 and S3 Filing Status.

The Standard Deduction Amount is $2,420 for S2 Filing Status.

The Personal Exemption amount remains at $213.00 for all Filing Status.

New Filing status for 2020 NOWH (No Withholding Provided) Flat tax rate of 8% (remains for 2022 year)

HB2119 requires employers to withhold income tax at a rate of 8 percent of employee wages if they employee has not provided a withholding statement or exemption certificate.
Continue withholding at the 8 percent rate until the employee submits a withholding statement and exemption certificate.

Special Tax Type rates for MS3 Filing Status:

If Over But Not Over Tax Amount Tax Rate On Excess Over
0 49,999 7,250 0% 0
49,999 249,999 7,250 0% 0
249,999 259,999 5,800 0% 0
259,999 269,999 4,350 0% 0
269,999 279,999 2,900 0% 0
279,999 289,999 1,450 0% 0
289,999 And over 0 0% 0

Special Tax Type rates for S2 and S3 Filing Status:

If Over But Not Over Tax Amount Tax Rate On Excess Over
0 49,999 7,250 0% 0
49,999 124,999 7,250 0% 0
124,999 129,999 5,800 0% 0
129,999 134,999 4,350 0% 0
134,999 139,999 2,900 0% 0
139,999 144,999 1,450 0% 0
144,999 And over 0 0% 0

Tax Type rates for MS3 and S3 Filing Status:

If Over But Not Over Tax Amount Tax Rate On Excess Over
0 37,910 0 0% 0
37,910 250,000 1,126 8.75% 18,900
250,000 And over 21,347 9.9% 250,000

Tax Type rates for S2 Filing Status:

If Over But Not Over Tax Amount Tax Rate On Excess Over
0 40,330 0 0% 0
40,330 125,000 563 8.75% 9,450
125,000 And Over 10,674 9.9% 125,000

Low Income Type rates for MS3 and S3 Filing Status:

If Over But Not Over Tax Amount Tax Rate On Excess Over
0 7,500 219 4.75% 0
7,500 18,900 575 6.75% 7,500
18,900 50,000 1,345 8.75% 18,900

Low Income Type rates for S2 Filing Status:

If Over But Not Over Tax Amount Tax Rate On Excess Over
0 3,750 219 4.75% 0
3,750 9,450 397 6.75% 3,750
9,450 50,000 782 8.75% 9,450

Withholding changes for South Carolina

The Personal Exemption is $2,750 for Filing Status ONE. The Standard Deduction Maximum is $4,580 for ONE Filing Status.

Tax Type rates for all Filing Status:

If Over But Not Over Tax Amount Tax Rate On Excess Over
0 2,980 0 0.2% 0
2,980 5,960 -83.44 3.0% 0
5,960 8,940 -143.04 4.0% 0
8,940 11,920 -232.44 5.0% 0
11,920 14,900 -351.64 6.0% 0
14,900 And over -500.64 7.0% 0

Resources to assist you

If you have questions about U.S. Payroll tax updates and your Microsoft Partner isn't available, there are several resources, in addition to this document, to assist in answering your questions.

U.S. Payroll Tax Updates

Take a look at this location to find out the tax changes included in each update and to download the update. All instructions for downloading and installing the tax updates also are provided here.

eSupport

For support requests that can be handled with email, go to https://support.microsoft.com/supportforbusiness. On average, the response time is nearly twice as fast as telephone support.

Discussion

On the Dynamics GP community site, you can start a tax update discussion with other members of the Microsoft customer community. This database provides you with the opportunity to exchange information with other customers, which is perfect for providing tips and answers to questions about tax updates.

Preparing for installation

Use the instructions in this section to prepare for the U.S. Payroll Tax Update. For detailed information about the changes in the current tax update round, see Changes in this update.

Are you using a supported version?

To identify the version, you're using, start Microsoft Dynamics GP. Choose Help>> About Microsoft Dynamics GP. The information window displays the version number in the lower right corner.

This U.S. Payroll Tax Update is supported for Microsoft Dynamics GP on Microsoft SQL Server.

If you're not using one of the supported versions, you must upgrade to a supported version before installing this tax update.

Have you obtained the update files?

If your computer is connected to the Internet, the Payroll Update Utility (PUE) automatically can download the tax table update file (TX.cab) from the Internet.

If your computer isn't connected to the Internet, you can obtain the file from Dynamics GP Downloads or your Microsoft Partner and copy it to your computer before running what's known as a "manual" installation.

Tax updates are distributed in the form of .CAB files. Copy the .CAB file to a folder that you can readily access, such as the folder that contains Dynamics.exe. Copying the .CAB file to your computer does not complete the installation. Refer to the following section for instructions on how to install the tax update.

Installing the tax update

The Round 3 2022 tax update installation can be run from any workstation. The update installs payroll tax table data on the server computer where your existing Microsoft Dynamics GP application data is located. You need to install the tax table update only once.

If you have issues installing the update, review the article on Tips to install the U.S. Payroll Tax Update.

Before you begin, ask all Microsoft Dynamics GP users to exit the application until the update is complete. Exit all other applications, turn off the screen saver, and back up important data (including Forms.dic, Reports.dic, and Dynamics.vba if they exist) before you proceed with the installation.

  1. Log onto Microsoft Dynamics GP with the system administrator rights, (user SA) and open the Payroll Tax Update window. (Microsoft Dynamics GP menu >> Maintenance >> U.S. Payroll Updates >> Check for Tax Updates)

  2. Select an update method, and then choose Next.

    A screenshot

    • The Automatic option downloads the current tax table update from the Internet to the default location. An Internet connection is required.
    • The Manual option processes the tax table update from a location you choose. You might choose Manual if you need to update a computer that isn't connected to the Internet. To use this method, you should already have obtained the tax table update file, TX.cab, and copied it to a location your computer can readily access.
  3. If you selected Automatic, enter your 10-digit authorized telephone number. Choose Log in to start the download.

    If you selected Manual, specify the location where the tax table update file is located.

  4. Choose Process to start the update.

  5. Verify that the latest Payroll tax table update has been installed. Choose Microsoft Dynamics GP menu >> Tools >> Setup >> System >> Payroll Tax. The Last Tax Update value should be 6/3/2022.

What's next

If you upgrade to another version of Microsoft Dynamics GP, you must install the most recent service pack (if any), as well as the most recent tax table updates for that release, to ensure you have the latest tax information. Newer releases of Microsoft Dynamics GP do not include current payroll tax information.