U.S. 2024 Payroll Tax Update
This tax update applies to:
- Microsoft Dynamics GP on Microsoft SQL Server
This article provides guidance for how to install the 2024 U.S. Payroll Tax Update for Microsoft Dynamics GP and describes changes.
This is the sixth tax update for 2024 and replaces all previous tax updates. It includes State tax table changes that take effect July 1, 2024.
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 Amount Field
Does Microsoft Dynamics GP calculate tax correctly?
Tips to install the U.S. Payroll Tax Update
Changes in July Round 6 update (Release 7/25/2024)
- Kansas
Withholding changes for Kansas
The Personal Exemption amount is $2,320 for all Filing Status.
New Standard Deduction Amount for Filing Status:
- SINGLE is $9,160
- MAR is $18,320
Withholding rates for taxpayers filing as MAR:
| If Over | But Not Over | Tax Amount | Tax Rate | On Excess Over |
|---|---|---|---|---|
| 0 | 8,240 | 0 | 0% | 0 |
| 8,240 | 54,240 | 0 | 5.2% | 8,240 |
| 54,240 | And Over | 2,392 | 5.58% | 54,240 |
Withholding rates for taxpayers filing as SINGLE:
| If Over | But Not Over | Tax Amount | Tax Rate | On Excess Over |
|---|---|---|---|---|
| 0 | 3,605 | 0 | 0% | 0 |
| 3,605 | 26,605 | 0 | 5.2% | 3,605 |
| 26,605 | And Over | 1,196 | 5.58% | 26,605 |
Changes in July Round 5 update (Release 7/17/2024)
- Arkansas
Withholding changes for Arkansas
Note
If you have employees set up to withhold Arkansas state tax, you need to be on version 18.5.1635 or later, for taxes to be correct for the year 2024. This change is for the Midrange Income look up part of the tax calculation.
- Standard Deduction Amount is $2,340
- Personal Exemption remains at $29.00
Tax Type rates for Filing Status NA:
| If Over | But Not Over | Tax Amount | Tax Rate | On Excess Over |
|---|---|---|---|---|
| 0 | 5,299 | 0 | 0.0% | 0 |
| 5,299 | 10,599 | -105.98 | 2.0% | 0 |
| 10,599 | 15,099 | -211.97 | 3.0% | 0 |
| 15,099 | 24,999 | -272.37 | 3.4% | 0 |
| 24,999 | 89,600 | -397.36 | 3.9% | 0 |
| 89,600 | 89,700 | -395.50 | 3.9% | 0 |
| 89,700 | 89,800 | -385.50 | 3.9% | 0 |
| 89,800 | 89,900 | -375.50 | 3.9% | 0 |
| 89,900 | 90,000 | -365.50 | 3.9% | 0 |
| 90,000 | 90,100 | -355.50 | 3.9% | 0 |
| 90,100 | 90,200 | -345.50 | 3.9% | 0 |
| 90,200 | 90,300 | -335.50 | 3.9% | 0 |
| 90,300 | 90,400 | -325.50 | 3.9% | 0 |
| 90,400 | 90,500 | -315.50 | 3.9% | 0 |
| 90,500 | 90,600 | -305.50 | 3.9% | 0 |
| 90,600 | 90,700 | -295.50 | 3.9% | 0 |
| 90,700 | 90,800 | -285.50 | 3.9% | 0 |
| 90,800 | 90,900 | -275.50 | 3.9% | 0 |
| 90,900 | 91,000 | -265.50 | 3.9% | 0 |
| 91,000 | 91,100 | -255.50 | 3.9% | 0 |
| 91,100 | 91,200 | -245.50 | 3.9% | 0 |
| 91,200 | 91,300 | -235.50 | 3.9% | 0 |
| 91,300 | 91,400 | -225.50 | 3.9% | 0 |
| 91,400 | 91,500 | -215.50 | 3.9% | 0 |
| 91,500 | 91,600 | -205.50 | 3.9% | 0 |
| 91,600 | 91,700 | -195.50 | 3.9% | 0 |
| 91,700 | 91,800 | -185.50 | 3.9% | 0 |
| 91,800 | 91,900 | -175.50 | 3.9% | 0 |
| 91,900 | 92,000 | -165.50 | 3.9% | 0 |
| 92,000 | 92,100 | -155.50 | 3.9% | 0 |
| 92,100 | 92,200 | -145.50 | 3.9% | 0 |
| 92,200 | 92,300 | -135.50 | 3.9% | 0 |
| 92,300 | 92,400 | -125.50 | 3.9% | 0 |
| 92,400 | 92,500 | -115.50 | 3.9% | 0 |
| 92,500 | 92,600 | -105.50 | 3.9% | 0 |
| 92,600 | 92,700 | -95.50 | 3.9% | 0 |
| 92,700 | 100,000 | -85.50 | 3.9% | 0 |
| 100,000 | And Over | -85.50 | 3.9% | 0 |
Changes in June Round 4 update (Release 6/10/2024)
- Georgia
- Idaho
- Ohio
- Utah
Withholding changes for Georgia
The Standard Deduction Amount for Filing Status:
- HOH, SINGLE, MFJ2I and MFS is $12,000
- MFJ1I is $24,000
Subtract Personal Exemptions was removed from the calculation.
Dependent Allowance $4,000
All filing status have a fixed flat tax of 5.39%.
Withholding changes for Idaho
The Personal Exemption amount is $3,600 for all Filing Status.
Withholding rates for taxpayers filing as MAR:
| If Over | But Not Over | Tax Amount | Tax Rate | On Excess Over |
|---|---|---|---|---|
| 0 | 29 ,200 | 0 | 0% | 0 |
| 29,200 | And Over | 0 | 5.695% | 29,200 |
Withholding rates for taxpayers filing as SINGLE:
| If Over | But Not Over | Tax Amount | Tax Rate | On Excess Over |
|---|---|---|---|---|
| 0 | 14,600 | 0 | 0% | 0 |
| 14,600 | And Over | 0 | 5.695% | 14,600 |
Withholding changes for Utah
Exemption amount changed. All filing statuses have the same fixed flat tax of 4.55%
Personal Exemption table type filing as MAR:
| If Over | But Not Over | Tax Amount | Tax Rate | On Excess Over |
|---|---|---|---|---|
| 0 | 0 | 1.00 | 0 | 880.00 |
Personal Exemption table type filing as SINGLE:
| If Over | But Not Over | Tax Amount | Tax Rate | On Excess Over |
|---|---|---|---|---|
| 0 | 0 | 1.00 | 0 | 440.00 |
Special table type filing as MAR:
| If Over | But Not Over | Tax Amount | Tax Rate | On Excess Over |
|---|---|---|---|---|
| 0 | 0 | 0.00 | 1.30% | 17,652 |
Special table type filing as SINGLE:
| If Over | But Not Over | Tax Amount | Tax Rate | On Excess Over |
|---|---|---|---|---|
| 0 | 0 | 0.00 | 1.30% | 8,826 |
Withholding changes for Ohio
Withholding rates for taxpayers filing as NA
| If Over | But Not Over | Tax Amount | Tax Rate | On Excess Over |
|---|---|---|---|---|
| 0 | 5,000 | 0 | .501% | 0 |
| 5,000 | 10,000 | 25.05 | 1.001% | 5,000 |
| 10,000 | 15,000 | 75.10 | 2.005% | 10,000 |
| 15,000 | 20,000 | 175.35 | 2.505% | 15,000 |
| 20,000 | 100,000 | 300.60 | 2.99% | 20,000 |
| 100,000 | And over | 2692.60 | 3.80% | 100,000 |
Changes in April Round 3 update (Released 4/9/2024)
- Virginia
Withholding changes for Virginia
The tables include increases in the standard deduction from $8,000 to $8,500 for single filers and $17,000 for married filers filing jointly.
Changes in January Round 2 update (Released 1/19/2024)
- Georgia
- Illinois
- Indiana
- Maryland
- Massachusetts
- Minnesota
- Mississippi
- North Dakota
- Vermont
Withholding changes for Georgia
The Standard Deduction Amount for Filing Status:
- HOH, SINGLE, MFJ2I and MFS is $12,000
- MFJ1I is $24,000
Subtract Personal Exemptions was removed from the calculation.
All filing status have a fixed flat tax of 5.49%.
Withholding changes for Illinois
- The Dependent Exemptions is $2,775 from $2,425.
- The Flat tax rate remains at 4.95% and allowances at 1,000.
Withholding changes for Indiana
The Flat tax rate is reduced to 3.05% from 3.15%.
Withholding changes for Maryland
For each Filing Status of Maryland:
- Standard Deduction Minimum is $1,800 from $1,700
- Standard Deduction Maximum is $2,700 from $2,550
- The Standard Deduction Percent remains at 15 percent.
For Filing Status of AAMAR (Anne Arundel 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 | 75,000 | 0 | 7.50% | 0 |
| 75,000 | 150,000 | 0 | 7.60% | 0 |
| 150,000 | 175,000 | 11,400 | 7.85% | 150,000 |
| 175,000 | 225,000 | 13,362.50 | 8.10% | 175,000 |
| 225,000 | 300,000 | 17,412.50 | 8.35% | 225,000 |
| 300,000 | 480,000 | 23,675 | 8.60% | 300,000 |
| 480,000 | And over | 24,725 | 8.950% | 480,000 |
For Filing Status of ARNDEL (Anne Arundel SGL/DEP/MFS).
Withholding rates for taxpayer:
| If Over | But Not Over | Tax Amount | Tax Rate | On Excess Over |
|---|---|---|---|---|
| 0 | 5,000 | 0 | 0% | 0 |
| 5,000 | 50,000 | 0 | 7.50% | 0 |
| 50,000 | 100,000 | 0 | 7.60% | 0 |
| 100,000 | 125,000 | 7,600 | 7.85% | 100,000 |
| 125,000 | 150,000 | 9,562.50 | 8.10% | 125,000 |
| 150,000 | 250,000 | 11,587.50 | 8.35% | 150,000 |
| 250,000 | 400,000 | 19,937.50 | 8.60% | 250,000 |
| 400,000 | And over | 20,812.50 | 8.950% | 400,000 |
For Filing Status of CCMAR (Cecil 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.50% | 0 |
| 150,000 | 175,000 | 11,250 | 7.75% | 150,000 |
| 175,000 | 225,000 | 13,187.50 | 8.00% | 175,000 |
| 225,000 | 300,000 | 17,187.50 | 8.25% | 225,000 |
| 300,000 | And over | 23,375 | 8.50% | 300,000 |
For Filing Status of CECIL (Cecil SGL/DEP/MFS).
Withholding rates for taxpayer:
| If Over | But Not Over | Tax Amount | Tax Rate | On Excess Over |
|---|---|---|---|---|
| 0 | 5,000 | 0 | 0% | 0 |
| 5,000 | 100,000 | 0 | 7.50% | 5,000 |
| 100,000 | 125,000 | 7,500 | 7.75% | 100,000 |
| 125,000 | 150,000 | 9,437.50 | 8.00% | 125,000 |
| 150,000 | 250,000 | 11,437.50 | 8.25% | 150,000 |
| 250,000 | And over | 19,687.50 | 8.50% | 250,000 |
For Filing Status of CLMAR (Caroline 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.95% | 0 |
| 150,000 | 175,000 | 11,925 | 8.20% | 150,000 |
| 175,000 | 225,000 | 13,975.00 | 8.45% | 175,000 |
| 225,000 | 300,000 | 18,200.00 | 8.70% | 225,000 |
| 300,000 | And over | 24,725 | 8.950% | 300,000 |
For Filing Status of CVMAR (Calvert 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.75% | 0 |
| 150,000 | 175,000 | 11,625 | 8.000% | 150,000 |
| 175,000 | 225,000 | 13,625 | 8.25% | 175,000 |
| 225,000 | 300,000 | 17,750 | 8.50% | 225,000 |
| 300,000 | And over | 24,125 | 8.750% | 300,000 |
For Filing Status of FREDRK (Frederick SGL/DEP/MFS).
Withholding rates for taxpayer:
| If Over | But Not Over | Tax Amount | Tax Rate | On Excess Over |
|---|---|---|---|---|
| 0 | 5,000 | 0 | 0% | 0 |
| 5,000 | 25,000 | 0 | 7.00% | 0 |
| 25,000 | 50,000 | 0 | 7.50% | 0 |
| 50,000 | 100,000 | 0 | 7.75% | 0 |
| 100,000 | 125,000 | 7,750 | 8.00% | 100,000 |
| 125,000 | 150,000 | 9,750.00 | 8.25% | 125,000 |
| 150,000 | 250,000 | 12,112.50 | 8.70% | 150,000 |
| 250,000 | And over | 20,812.50 | 8.95% | 250,000 |
For Filing Status of FRMAR (Frederick 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 | 25,000 | 0 | 7.00% | 0 |
| 25,000 | 100,000 | 0 | 7.50% | 0 |
| 100,000 | 150,000 | 0 | 7.75% | 0 |
| 150,000 | 175,000 | 11,625 | 8.00% | 150,000 |
| 175,000 | 225,000 | 13,625 | 8.25% | 175,000 |
| 225,000 | 250,000 | 17,750 | 8.50% | 225,000 |
| 250,000 | 300,000 | 18,200 | 8.70% | 250,000 |
| 300,000 | And over | 24,725 | 8.95% | 300,000 |
Withholding changes for Massachusetts
- Flat tax rate of 5% for all filing status.
- The Millionaires Tax (Surtax of 4% on employees that make over 1,000,000), which begin in January 1, 2023, is not supported by the Microsoft Dynamics GP tables.
Withholding changes for Minnesota
The Personal Exemption amount is $5,050 for all Filing Status.
Withholding rates for taxpayers filing as MAR:
| If Over | But Not Over | Tax Amount | Tax Rate | On Excess Over |
|---|---|---|---|---|
| 0 | 14,000 | 0 | 0% | 0 |
| 14,000 | 60,330 | 0 | 5.35 | 14,000 |
| 60,330 | 198,040 | 2,478.66 | 6.80% | 60,330 |
| 198,040 | 335,450 | 11,842.94 | 7.85% | 198,040 |
| 335,450 | And Over | 22,629.63 | 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,475 | 0 | 0% | 0 |
| 4,475 | 36,165 | 0 | 5.35% | 4,475 |
| 36,165 | 108,565 | 1,695.42 | 6.80% | 36,165 |
| 108,565 | 197,715 | 6,618.62 | 7.85% | 108,565 |
| 197,715 | And Over | 13,616.90 | 9.85% | 197,715 |
Withholding changes for Mississippi
Withholding rates for all Filing Status:
| If Over | But Not Over | Tax Amount | Tax Rate | On Excess Over |
|---|---|---|---|---|
| 0 | 10,000 | 0 | 0 | 0 |
| 10,000 | And over | 0 | 4.7% | 10,000 |
Withholding changes for North Dakota
The Personal Exemption amount is $4,300 for Filing Status MAR and SINGLE.
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:
| If Over | But Not Over | Tax Amount | Tax Rate | On Excess Over |
|---|---|---|---|---|
| 0 | 53,988 | 0 | 0% | 0 |
| 53,988 | 159,588 | 0 | 1.95% | 53,988 |
| 159,588 | And Over | 2,059.20 | 2.50% | 159,588 |
Withholding rates for taxpayers filing as MARHR:
| If Over | But Not Over | Tax Amount | Tax Rate | On Excess Over |
|---|---|---|---|---|
| 0 | 51,975 | 0 | 0% | 0 |
| 51,975 | 152,150 | 0 | 1.95% | 51,975 |
| 152,150 | And Over | 1,953.41 | 2.50% | 152,150 |
Withholding rates for taxpayers filing as SINGLE:
| If Over | But Not Over | Tax Amount | Tax Rate | On Excess Over |
|---|---|---|---|---|
| 0 | 54,450 | 0 | 0% | 0 |
| 54,450 | 245,500 | 0 | 1.95% | 54,450 |
| 245,500 | And Over | 3,725.48 | 2.50% | 245,500 |
Withholding rates for taxpayers filing as SINGHR:
| If Over | But Not Over | Tax Amount | Tax Rate | On Excess Over |
|---|---|---|---|---|
| 0 | 52,025 | 0 | 0% | 0 |
| 52,025 | 233,275 | 0 | 1.95% | 52,025 |
| 233,275 | And Over | 3,534.38 | 2.50% | 233,275 |
Withholding rates for taxpayers filing as HOHHR:
| If Over | But Not Over | Tax Amount | Tax Rate | On Excess Over |
|---|---|---|---|---|
| 0 | 70,900 | 0 | 0% | 0 |
| 70,900 | 261,500 | 0 | 1.95% | 70,900 |
| 261,500 | And Over | 3,716.70 | 2.50% | 261,500 |
Withholding changes for Vermont
The Personal Exemption amount is $5,100
Withholding rates for taxpayers filing as MAR
| If Over | But Not Over | Tax Amount | Tax Rate | On Excess Over |
|---|---|---|---|---|
| 0 | 11,138 | 0 | 0% | 0 |
| 11,138 | 91,088 | 0 | 3.35% | 11,138 |
| 91,088 | 204,488 | 2,678.33 | 6.60% | 91,088 |
| 204,488 | 305,788 | 10,162.73 | 7.60% | 204,488 |
| 305,788 | And Over | 17,861.53 | 8.75% | 305,788 |
Withholding rates for taxpayers filing as SINGLE
| If Over | But Not Over | Tax Amount | Tax Rate | On Excess Over |
|---|---|---|---|---|
| 0 | 3,700 | 0 | 0% | 0 |
| 3,700 | 51,600 | 0 | 3.35% | 3,700 |
| 51,600 | 119,700 | 1,604.65 | 6.60% | 51,600 |
| 119,700 | 245,700 | 6,099.25 | 7.60% | 119,700 |
| 245,700 | And Over | 15,675.25 | 8.75% | 245,700 |
Changes in January Round 1 update (Released 12/20/2023)
- FICA Social Security Limit 168,600 (Previously $160,200)
- Federal tax
- Alabama
- Arkansas
- California
- Colorado
- Connecticut
- Iowa
- Kentucky
- Maine
- Michigan
- Missouri
- Montana
- Nebraska
- New Mexico
- North Carolina
- Oregon
- Rhode Island
- South Carolina
Withholding changes for Federal
The maximum taxable earnings for Social Security increase in 2024 to $168,600 from $160,200.
Federal tax tables released 12/19/2023
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 | 16,300 | 0 | 0% | 0 |
| 16,300 | 27,900 | 0 | 10% | 16,300 |
| 27,900 | 63,450 | 1,160.00 | 12% | 27,900 |
| 63,450 | 116,825 | 5,426.00 | 22% | 63,450 |
| 116,825 | 208,250 | 17,168.50 | 24% | 116,825 |
| 208,250 | 260,025 | 39,110.50 | 32% | 208,250 |
| 260,025 | 625,650 | 55,678.50 | 35% | 260,025 |
| 625,650 | And Over | 183,647.25 | 37% | 625,650 |
Withholding rates for taxpayers filing as NRAHR:
| If Over | But Not Over | Tax Amount | Tax Rate | On Excess Over |
|---|---|---|---|---|
| 21,900 | 0 | 0% | 0 | |
| 21,900 | 27,700 | 0 | 10% | 21,900 |
| 27,700 | 45,475 | 580.00 | 12% | 27,700 |
| 45,475 | 72,163 | 2,713.00 | 22% | 45,475 |
| 72,163 | 117,875 | 8,584.25 | 24% | 72,163 |
| 117,875 | 143,763 | 19,555.25 | 32% | 117,875 |
| 143,763 | 326,575 | 27,839.25 | 35% | 143,763 |
| 326,575 | And Over | 91,823.63 | 37% | 326,575 |
Withholding rates for taxpayers filing as MAR:
| If Over | But Not Over | Tax Amount | Tax Rate | On Excess Over |
|---|---|---|---|---|
| 0 | 16,300 | 0 | 0% | 0 |
| 16,300 | 39,500 | 0 | 10% | 16,300 |
| 39,500 | 110,600 | 2,320.00 | 12% | 39,500 |
| 110,600 | 217,350 | 10,852.00 | 22% | 110,600 |
| 217,350 | 400,200 | 34,337.00 | 24% | 217,350 |
| 400,200 | 503,750 | 78,221.00 | 32% | 400,200 |
| 503,750 | 747,500 | 111,357.00 | 35% | 503,750 |
| 747,500 | And Over | 196,669.50 | 37% | 747,500 |
Withholding rates for taxpayers filing as MARHR:
| If Over | But Not Over | Tax Amount | Tax Rate | On Excess Over |
|---|---|---|---|---|
| 0 | 14,600 | 0 | 0% | 0 |
| 14,600 | 26,200 | 0 | 10% | 14,600 |
| 26,200 | 61,750 | 1,160.00 | 12% | 26,200 |
| 61,750 | 115,125 | 5,426.00 | 22% | 61,750 |
| 115,125 | 206,550 | 17,168.50 | 24% | 115,125 |
| 206,550 | 258,325 | 39,110.50 | 32% | 206,550 |
| 258,325 | 380,200 | 55,678.50 | 35% | 258,325 |
| 380,200 | And Over | 98,334.75 | 37% | 380,200 |
Withholding rates for taxpayers filing as SINGLE:
| If Over | But Not Over | Tax Amount | Tax Rate | On Excess Over |
|---|---|---|---|---|
| 0 | 6,000 | 0 | 0% | 0 |
| 6,000 | 17,600 | 0 | 10% | 6,000 |
| 17,600 | 53,150 | 1,160.00 | 12% | 17,600 |
| 53,150 | 106,525 | 5,426.00 | 22% | 53,150 |
| 106,525 | 197,950 | 17,168.50 | 24% | 106,525 |
| 197,950 | 249,725 | 39,110.50 | 32% | 197,950 |
| 249,725 | 615,350 | 55,678.50 | 35% | 249,725 |
| 615,350 | And Over | 183,647.25 | 37% | 615,350 |
Withholding rates for taxpayers filing as SGLHHR:
| If Over | But Not Over | Tax Amount | Tax Rate | On Excess Over |
|---|---|---|---|---|
| 0 | 7,300 | 0 | 0% | 0 |
| 7,300 | 13,100 | 0 | 10% | 7,300 |
| 13,100 | 30,875 | 580.00 | 12% | 13,100 |
| 30,875 | 57,563 | 2,713.00 | 22% | 30,875 |
| 57,563 | 103,275 | 8,584.25 | 24% | 57,563 |
| 103,275 | 129,163 | 19,555.25 | 32% | 103,275 |
| 129,163 | 311,975 | 27,839.25 | 35% | 129,163 |
| 311,975 | And Over | 91,823.63 | 37% | 311,975 |
Withholding rates for taxpayers filing as HOH:
| If Over | But Not Over | Tax Amount | Tax Rate | On Excess Over |
|---|---|---|---|---|
| 0 | 13,300 | 0 | 0% | 0 |
| 13,300 | 29,850 | 0 | 10% | 13,300 |
| 29,850 | 76,400 | 1,655.00 | 12% | 29,850 |
| 76,400 | 113,800 | 7,241.00 | 22% | 76,400 |
| 113,800 | 205,250 | 15,469.00 | 24% | 113,800 |
| 205,250 | 257,000 | 37,417.00 | 32% | 205,250 |
| 257,000 | 622,650 | 53,997.00 | 35% | 257,000 |
| 622,650 | And Over | 181,954.50 | 37% | 622,650 |
Withholding rates for taxpayers filing as HOHHR:
| If Over | But Not Over | Tax Amount | Tax Rate | On Excess Over |
|---|---|---|---|---|
| 0 | 10,950 | 0 | 0% | 0 |
| 10,950 | 19,225 | 0 | 10% | 10,950 |
| 19,225 | 42,500 | 827.50 | 12% | 19,225 |
| 42,500 | 61,200 | 3,620.50 | 22% | 42,500 |
| 61,200 | 106,925 | 7,734.50 | 24% | 61,200 |
| 106,925 | 132,800 | 18,708.50 | 32% | 106,925 |
| 132,800 | 315,625 | 26,988.50 | 35% | 132,800 |
| 315,625 | And Over | 90,977.25 | 37% | 315,625 |
Withholding changes for Alabama
Effective 1/1/2024 the state of Alabama has temporarily exempted all overtime wages from state tax. This will not be part of the Dynamics GP 2024 payroll tax tables. If you need this functionality in the product, you could set up a new pay code not subject to state tax, more manually tracked, or reach out to Greenshades for a more automated solution.
Withholding changes for Arkansas
Note
If you have employees set up to withhold Arkansas state tax, you need to be on version 18.5.1635 or later, for taxes to be correct for the year 2024. This change is for the Midrange Income look up part of the tax calculation.
- Standard Deduction Amount is $2,340 from $2,270
- Personal Exemption remains at $29.00
Tax Type rates for Filing Status NA:
| If Over | But Not Over | Tax Amount | Tax Rate | On Excess Over |
|---|---|---|---|---|
| 0 | 5,299 | 0 | 0.0% | 0 |
| 5,299 | 10,599 | -105.98 | 2.0% | 0 |
| 10,599 | 15,099 | -211.97 | 3.0% | 0 |
| 15,099 | 24,999 | -272.37 | 3.4% | 0 |
| 24,999 | 89,600 | -522.36 | 4.4% | 0 |
| 89,600 | 89,700 | -506.40 | 4.4% | 0 |
| 89,700 | 89,800 | -496.40 | 4.4% | 0 |
| 89,800 | 89,900 | -486.40 | 4.4% | 0 |
| 89,900 | 90,000 | -476.40 | 4.4% | 0 |
| 90,000 | 90,200 | -466.40 | 4.4% | 0 |
| 90,200 | 90,300 | -456.40 | 4.4% | 0 |
| 90,300 | 90,400 | -446.40 | 4.4% | 0 |
| 90,400 | 90,500 | -436.40 | 4.4% | 0 |
| 90,500 | 90,600 | -426.40 | 4.4% | 0 |
| 90,600 | 90,700 | -416.40 | 4.4% | 0 |
| 90,700 | 90,800 | -406.40 | 4.4% | 0 |
| 90,800 | 90,900 | -396.40 | 4.4% | 0 |
| 90,900 | 91,100 | -386.40 | 4.4% | 0 |
| 91,100 | 91,200 | -376.40 | 4.4% | 0 |
| 91,200 | 91,300 | -366.40 | 4.4% | 0 |
| 91,300 | 91,400 | -356.40 | 4.4% | 0 |
| 91,400 | 91,500 | -346.40 | 4.4% | 0 |
| 91,500 | 91,600 | -336.40 | 4.4% | 0 |
| 91,600 | 91,700 | -326.40 | 4.4% | 0 |
| 91,700 | 91,800 | -316.40 | 4.4% | 0 |
| 91,800 | 91,900 | -306.40 | 4.4% | 0 |
| 91,900 | 92,000 | -296.40 | 4.4% | 0 |
| 92,000 | 92,100 | -286.40 | 4.4% | 0 |
| 92,100 | 92,200 | -276.40 | 4.4% | 0 |
| 92,200 | 92,300 | -266.40 | 4.4% | 0 |
| 92,300 | 92,400 | -256.40 | 4.4% | 0 |
| 92,400 | 92,500 | -246.40 | 4.4% | 0 |
| 92,500 | 92,600 | -236.40 | 4.4% | 0 |
| 92,600 | 92,700 | -226.40 | 4.4% | 0 |
| 92,700 | 92,800 | -216.40 | 4.4% | 0 |
| 92,800 | 92,900 | -206.40 | 4.4% | 0 |
| 92,900 | 93,000 | -196.40 | 4.4% | 0 |
| 93,000 | 93,100 | -186.40 | 4.4% | 0 |
| 93,100 | 93,200 | -176.40 | 4.4% | 0 |
| 93,200 | 93,300 | -166.40 | 4.4% | 0 |
| 93,300 | 93,400 | -156.40 | 4.4% | 0 |
| 93,400 | 93,500 | -146.40 | 4.4% | 0 |
| 93,500 | 93,600 | -136.40 | 4.4% | 0 |
| 93,600 | 100,000 | -126.40 | 4.4% | 0 |
| 100,000 | And Over | -126.40 | 4.4% | 0 |
Tax Type Special for Filing Status NA added:
| If Over | But Not Over | Tax Amount | Tax Rate | On Excess Over |
|---|---|---|---|---|
| 0 | 100,001 | 0 | 0% | 50 |
Withholding changes for California
For Filing Status of HOH and MAR2:
- Personal Exemption is $158.40 from $154.00
- Standard Deduction is $10,726 from $10,404
- Low Income Limit is $35,538 from $34,503
For Filing Status of MAR1 and SINGLE:
- Personal Exemption is $158.40 from $154.00
- Standard Deduction is $5,363 from $5,202
- Low Income Limit is $17,769 from $17,252
Withholding rates for taxpayers filing as HOH:
| If Over | But Not Over | Tax Amount | Tax Rate | On Excess Over |
|---|---|---|---|---|
| 0 | 20,839 | 0 | 1.1% | 0 |
| 20,839 | 49,371 | 229.23 | 2.2% | 20,839 |
| 49,371 | 63,644 | 856.93 | 4.4% | 49,371 |
| 63,644 | 78,765 | 1,484.94 | 6.6% | 63,644 |
| 78,765 | 93,037 | 2,482.93 | 8.8% | 78,765 |
| 93,037 | 474,824 | 3,738.87 | 10.23% | 93,037 |
| 474,824 | 569,790 | 42,795.68 | 11.33% | 474,824 |
| 569,790 | 949,649 | 53,555.33 | 13.53% | 569,790 |
| 949,649 | 1,000,000 | 100,771.80 | 13.53% | 949,649 |
| 1,000,000 | And Over | 107,584.29 | 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 | 20,824 | 0 | 1.1% | 0 |
| 20,824 | 49,368 | 229.06 | 2.2% | 20,824 |
| 49,368 | 77,918 | 857.03 | 4.4% | 49,368 |
| 77,918 | 108,162 | 2,113.23 | 6.6% | 77,918 |
| 108,162 | 136,700 | 4,109.33 | 8.8% | 108,162 |
| 136,700 | 698,274 | 6,620.67 | 10.23% | 136,700 |
| 698,274 | 837,922 | 64,069.69 | 11.33% | 698,274 |
| 837,922 | 1,000,000 | 79,891.81 | 12.43% | 837,922 |
| 1,000,000 | 1,396,542 | 100,038.11 | 13.53% | 1,000,000 |
| 1,396,542 | And Over | 153,690.24 | 14.63% | 1,396,542 |
Withholding rates for taxpayers filing as SINGLE:
| If Over | But Not Over | Tax Amount | Tax Rate | On Excess Over |
|---|---|---|---|---|
| 0 | 10,412 | 0 | 1.1% | 0 |
| 10,412 | 24,684 | 114.53 | 2.2% | 10,412 |
| 24,684 | 38,959 | 428.51 | 4.4% | 24,684 |
| 38,959 | 54,081 | 1,056.61 | 6.6% | 38,959 |
| 54,081 | 68,350 | 2,054.66 | 8.8% | 54,081 |
| 68,350 | 349,137 | 3,310.33 | 10.23% | 68,350 |
| 349,137 | 418,961 | 32,034.84 | 11.33% | 349,137 |
| 418,961 | 698,271 | 39,945.90 | 12.43% | 418,961 |
| 698,271 | 1,000,000 | 74,644.13 | 13.53% | 698,271 |
| 1,000,000 | And Over | 115,488.06 | 14.63% | 1,000,000 |
Withholding changes for Colorado
All filing status have the same fixed flat tax of 4.40% was 4.55% (2022).
- The Personal Exemption amount is $9,000 for MAR
- The Personal Exemption amount is $4,500 For SINGLE
The following new filing status were added January 2022:
- HOH1J - Head of Household 1 Job - Exemption amount $19,500
- MAR1J - Married Filing Jointly 1 Job - Exemption amount $27,000
- SIN1J - Single/Mar filing Single 1 Job - Exemption amount $12,500
In January 2022 the state of Colorado released a new form called DR-0004 this is optional for an employee to complete.
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, it does not match the other filing status, so I choose Other and put 11.
Withholding changes for Connecticut
Withholding rates for taxpayers filing as A, D:
| If Over | But Not Over | Tax Amount | Tax Rate | On Excess Over |
|---|---|---|---|---|
| 0 | 10,000 | 0 | 2% | 0 |
| 10,000 | 50,000 | 200 | 4.5% | 10,000 |
| 50,000 | 50,250 | 2,000 | 5.5% | 50,000 |
| 50,250 | 52,750 | 2,025 | 5.5% | 50,000 |
| 52,750 | 55,250 | 2,050 | 5.5% | 50,000 |
| 55,250 | 57,750 | 2,075 | 5.5% | 50,000 |
| 57,750 | 60,250 | 2,100 | 5.5% | 50,000 |
| 60,250 | 62,750 | 2,125 | 5.5% | 50,000 |
| 62,750 | 65,250 | 2,150 | 5.5% | 50,000 |
| 65,250 | 67,750 | 2,175 | 5.5% | 50,000 |
| 67,750 | 70,250 | 2,200 | 5.5% | 50,000 |
| 70,250 | 72,750 | 2,225 | 5.5% | 50,000 |
| 72,750 | 100,000 | 2,250 | 5.5% | 50,000 |
| 100,000 | 200,000 | 4,750 | 6.0% | 100,000 |
| 200,000 | 250,000 | 10,750 | 6.5% | 200,000 |
| 250,000 | 500,000 | 14,000 | 6.9% | 250,000 |
| 500,000 | and over | 31,250 | 6.99% | 500,000 |
Withholding rates for taxpayers filing as B:
| If Over | But Not Over | Tax Amount | Tax Rate | On Excess Over |
|---|---|---|---|---|
| 0 | 16,000 | 0 | 2% | 0 |
| 16,000 | 78,500 | 320 | 4.5% | 16,000 |
| 78,500 | 78,500 | 360 | 4.5% | 16,000 |
| 78,500 | 82,500 | 3,240 | 5.5% | 80,000 |
| 82,500 | 86,500 | 3,280 | 5.5% | 80,000 |
| 86,500 | 90,500 | 3,320 | 5.5% | 80,000 |
| 90,500 | 94,500 | 3,360 | 5.5% | 80,000 |
| 94,500 | 98,500 | 3,400 | 5.5% | 80,000 |
| 98,500 | 102,500 | 3,440 | 5.5% | 80,000 |
| 102,500 | 106,500 | 3,480 | 5.5% | 80,000 |
| 106,500 | 110,500 | 3,520 | 5.5% | 80,000 |
| 110,500 | 114,500 | 3,560 | 5.5% | 80,000 |
| 114,500 | 160,000 | 3,600 | 5.5% | 80,000 |
| 160,000 | 320,000 | 7,600 | 6.0% | 160,000 |
| 320,000 | 400,000 | 17,200 | 6.5% | 320,000 |
| 400,000 | 800,000 | 22,400 | 6.9% | 400,000 |
| 800,000 | and over | 50,000 | 6.99% | 800,000 |
Withholding rates for taxpayers filing as C:
| If Over | But Not Over | Tax Amount | Tax Rate | On Excess Over |
|---|---|---|---|---|
| 0 | 20,000 | 0 | 2% | 0 |
| 20,000 | 100,000 | 400 | 4.5% | 20,000 |
| 100,000 | 100,500 | 4,000 | 5.5% | 100,000 |
| 100,500 | 105,500 | 4,050 | 5.5% | 100,000 |
| 105,500 | 110,500 | 4,100 | 5.5% | 100,000 |
| 110,500 | 115,500 | 4,150 | 5.5% | 100,000 |
| 115,500 | 120,500 | 4,200 | 5.5% | 100,000 |
| 120,500 | 125,500 | 4,250 | 5.5% | 100,000 |
| 125,500 | 130,500 | 4,300 | 5.5% | 100,000 |
| 130,500 | 135,500 | 4,350 | 5.5% | 100,000 |
| 135,500 | 140,500 | 4,400 | 5.5% | 100,000 |
| 140,500 | 145,500 | 4,450 | 5.5% | 100,000 |
| 145,500 | 200,000 | 4,500 | 5.5% | 100,000 |
| 200,000 | 400,000 | 9,500 | 6.0% | 200,000 |
| 400,000 | 500,000 | 21,500 | 6.5% | 400,000 |
| 500,000 | 1,000,000 | 28,000 | 6.9% | 500,000 |
| 1,000,000 | and over | 62,500 | 6.99% | 1,000,000 |
Withholding rates for taxpayers filing as F:
| If Over | But Not Over | Tax Amount | Tax Rate | On Excess Over |
|---|---|---|---|---|
| 0 | 10,000 | 0 | 2% | 0 |
| 10,000 | 50,000 | 200 | 4.5% | 10,000 |
| 50,000 | 56,500 | 2,000 | 5.5% | 50,000 |
| 56,500 | 61,500 | 2,025 | 5.5% | 50,000 |
| 61,500 | 66,500 | 2,050 | 5.5% | 50,000 |
| 66,500 | 71,500 | 2,075 | 5.5% | 50,000 |
| 71,500 | 76,500 | 2,100 | 5.5% | 50,000 |
| 76,500 | 81,500 | 2,125 | 5.5% | 50,000 |
| 81,500 | 86,500 | 2,150 | 5.5% | 50,000 |
| 86,500 | 91,500 | 2,175 | 5.5% | 50,000 |
| 91,500 | 96,500 | 2,200 | 5.5% | 50,000 |
| 96,500 | 100,000 | 2,250 | 5.5% | 50,000 |
| 100,000 | 101,500 | 4,750 | 6.0% | 100,000 |
| 101,500 | 200,000 | 10,750 | 6.5% | 100,000 |
| 200,000 | 250,000 | 14,000 | 6.9% | 200,000 |
| 250,000 | 500,000 | 14,000 | 6.9% | 250,000 |
| 500,000 | and over | 31,250 | 6.99% | 500,000 |
Low Income Tax Type rates for A, D and F Filing Status:
| If Over | But Not Over | Tax Amount | Tax Rate | On Excess Over |
|---|---|---|---|---|
| 0 | 105,000 | 0 | 0% | 0 |
| 105,000 | 110,000 | 25 | 0% | 0 |
| 110,000 | 115,000 | 50 | 0% | 0 |
| 115,000 | 120,000 | 75 | 0% | 0 |
| 120,000 | 125,000 | 100 | 0% | 0 |
| 125,000 | 130,000 | 125 | 0% | 0 |
| 130,000 | 135,000 | 150 | 0% | 0 |
| 135,000 | 140,000 | 175 | 0% | 0 |
| 140,000 | 145,000 | 200 | 0% | 0 |
| 145,000 | 150,000 | 225 | 0% | 0 |
| 150,000 | 200,000 | 250 | 0% | 0 |
| 200,000 | 205,000 | 340 | 0% | 0 |
| 205,000 | 210,000 | 430 | 0% | 0 |
| 210,000 | 215,000 | 520 | 0% | 0 |
| 215,000 | 220,000 | 610 | 0% | 0 |
| 220,000 | 225,000 | 700 | 0% | 0 |
| 225,000 | 230,000 | 790 | 0% | 0 |
| 230,000 | 235,000 | 880 | 0% | 0 |
| 235,000 | 240,000 | 970 | 0% | 0 |
| 240,000 | 245,000 | 1,060 | 0% | 0 |
| 245,000 | 250,000 | 1,150 | 0% | 0 |
| 250,000 | 255,000 | 1,240 | 0% | 0 |
| 255,000 | 260,000 | 1,330 | 0% | 0 |
| 260,000 | 265,000 | 1,420 | 0% | 0 |
| 265,000 | 270,000 | 1,510 | 0% | 0 |
| 270,000 | 275,000 | 1,600 | 0% | 0 |
| 275,000 | 280,000 | 1,690 | 0% | 0 |
| 280,000 | 285,000 | 1,780 | 0% | 0 |
| 285,000 | 290,000 | 1,870 | 0% | 0 |
| 290,000 | 295,000 | 1,960 | 0% | 0 |
| 295,000 | 300,000 | 2,050 | 0% | 0 |
| 300,000 | 305,000 | 2,140 | 0% | 0 |
| 305,000 | 310,000 | 2,230 | 0% | 0 |
| 310,000 | 315,000 | 2,320 | 0% | 0 |
| 315,000 | 320,000 | 2,410 | 0% | 0 |
| 320,000 | 325,000 | 2,500 | 0% | 0 |
| 325,000 | 330,000 | 2,590 | 0% | 0 |
| 330,000 | 335,000 | 2,680 | 0% | 0 |
| 335,000 | 340,000 | 2,770 | 0% | 0 |
| 340,000 | 345,000 | 2,860 | 0% | 0 |
| 345,000 | 500,000 | 2,950 | 0% | 0 |
| 500,000 | 505,000 | 3,000 | 0% | 0 |
| 505,000 | 510,000 | 3,050 | 0% | 0 |
| 510,000 | 515,000 | 3,100 | 0% | 0 |
| 515,000 | 520,000 | 3,150 | 0% | 0 |
| 520,000 | 525,000 | 3,200 | 0% | 0 |
| 525,000 | 530,000 | 3,250 | 0% | 0 |
| 530,000 | 535,000 | 3,300 | 0% | 0 |
| 535,000 | 540,000 | 3,350 | 0% | 0 |
| 540,000 | And over | 3,400 | 0% | 0 |
Low Income Tax Type rates for B Filing Status:
| If Over | But Not Over | Tax Amount | Tax Rate | On Excess Over |
|---|---|---|---|---|
| 0 | 168,000 | 0 | 0% | 0 |
| 168,000 | 176,000 | 40 | 0% | 0 |
| 176,000 | 184,000 | 80 | 0% | 0 |
| 184,000 | 192,000 | 120 | 0% | 0 |
| 192,000 | 200,000 | 160 | 0% | 0 |
| 200,000 | 208,000 | 200 | 0% | 0 |
| 208,000 | 216,000 | 240 | 0% | 0 |
| 216,000 | 224,000 | 280 | 0% | 0 |
| 224,000 | 232,000 | 320 | 0% | 0 |
| 232,000 | 240,000 | 360 | 0% | 0 |
| 240,000 | 320,000 | 400 | 0% | 0 |
| 320,000 | 328,000 | 540 | 0% | 0 |
| 328,000 | 336,000 | 680 | 0% | 0 |
| 336,000 | 344,000 | 820 | 0% | 0 |
| 344,000 | 352,000 | 960 | 0% | 0 |
| 352,000 | 360,000 | 1,100 | 0% | 0 |
| 360,000 | 368,000 | 1,240 | 0% | 0 |
| 368,000 | 376,000 | 1,380 | 0% | 0 |
| 376,000 | 384,000 | 1,520 | 0% | 0 |
| 384,000 | 392,000 | 1,660 | 0% | 0 |
| 392,000 | 400,000 | 1,800 | 0% | 0 |
| 400,000 | 408,000 | 1,940 | 0% | 0 |
| 408,000 | 416,000 | 2,080 | 0% | 0 |
| 416,000 | 424,000 | 2,220 | 0% | 0 |
| 424,000 | 432,000 | 2,360 | 0% | 0 |
| 432,000 | 440,000 | 2,500 | 0% | 0 |
| 440,000 | 448,000 | 2,640 | 0% | 0 |
| 448,000 | 456,000 | 2,780 | 0% | 0 |
| 456,000 | 464,000 | 2,920 | 0% | 0 |
| 464,000 | 472,000 | 3,060 | 0% | 0 |
| 472,000 | 480,000 | 3,200 | 0% | 0 |
| 480,000 | 488,000 | 3,340 | 0% | 0 |
| 488,000 | 496,000 | 3,480 | 0% | 0 |
| 496,000 | 504,000 | 3,620 | 0% | 0 |
| 504,000 | 512,000 | 3,760 | 0% | 0 |
| 512,000 | 520,000 | 3,900 | 0% | 0 |
| 520,000 | 528,000 | 4,040 | 0% | 0 |
| 528,000 | 536,000 | 4,180 | 0% | 0 |
| 536,000 | 544,000 | 4,320 | 0% | 0 |
| 544,000 | 552,000 | 4,460 | 0% | 0 |
| 552,000 | 800,000 | 4,600 | 0% | 0 |
| 800,000 | 808,000 | 4,680 | 0% | 0 |
| 808,000 | 816,000 | 4,760 | 0% | 0 |
| 816,000 | 824,000 | 4,840 | 0% | 0 |
| 824,000 | 832,000 | 4,920 | 0% | 0 |
| 832,000 | 840,000 | 5,000 | 0% | 0 |
| 840,000 | 848,000 | 5,080 | 0% | 0 |
| 848,000 | 856,000 | 5,160 | 0% | 0 |
| 856,000 | 864,000 | 5,240 | 0% | 0 |
| 864,000 | And over | 5,320 | 0% | 0 |
Withholding changes for Iowa
Iowa withholding calculations, federal withholding is no longer subtracted from taxable wages.
Note
Iowa W4 changed in the year 2024 and the tax tables support the amounts, they are held in the Personal Exemption table below.
- Standard Deduction for EXP1 is $14,600 previously $13,850
- Standard Deduction for EXP2 is $29,200 previously $27,700
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 | 4,896 | 0 | 4.40% | |
| 4,896 | 24,480 | 215.42 | 4.82% | 4,896 |
| 24,480 | And over | 1,159.37 | 5.70% | 24,480 |
Personal Exemption Tax Type rates for ALL filling Status:
| If Over | But Not Over | Tax Amoun | Tax Rate | On Excess Over |
|---|---|---|---|---|
| 0 | 1 | 40 | 0% | 0 |
| 1 | 2 | 80 | 0% | 0 |
| 2 | 3 | 120 | 0% | 0 |
| 3 | 4 | 160 | 0% | 0 |
| 4 | 5 | 200 | 0% | 0 |
| 5 | 6 | 240 | 0% | 0 |
| 6 | 7 | 280 | 0% | 0 |
| 7 | 8 | 320 | 0% | 0 |
| 8 | 9 | 360 | 0% | 0 |
| 9 | 10 | 400 | 0% | 0 |
| 10 | 11 | 440 | 0% | 0 |
| 11 | 12 | 480 | 0% | 0 |
| 12 | 13 | 520 | 0% | 0 |
| 13 | 14 | 560 | 0% | 0 |
| 14 | 15 | 600 | 0% | 0 |
| 15 | 16 | 640 | 0% | 0 |
| 16 | 17 | 680 | 0% | 0 |
| 17 | 18 | 720 | 0% | 0 |
| 18 | 19 | 760 | 0% | 0 |
| 19 | 20 | 800 | 0% | 0 |
| 20 | 21 | 840 | 0% | 0 |
Withholding changes for Kentucky
- The Standard Deduction Amount is $3,160 from $2,980
- The Tax Rate decreases to 4.0% formerly 4.5%
Withholding changes for Maine
- Personal Exemption is $5,000 was $4,700
Withholding rates for taxpayers filing as SINGLE, Tax table type:
| If Over | But Not Over | Tax Amount | Tax Rate | On Excess Over |
|---|---|---|---|---|
| 0 | 26,050 | 0 | 5.8% | 0 |
| 26,050 | 61,600 | 1,511 | 6.75% | 26,050 |
| 61,600 | And over | 3,911 | 7.15% | 61,600 |
Special table type:
| If Over | But Not Over | Tax Amount | Tax Rate | On Excess Over |
|---|---|---|---|---|
| 0 | 95,150 | 0 | 0 | 11,750 |
| 97,150 | 172,150 | 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 | 52,100 | 5.80% | 0 | |
| 52,100 | 123,250 | 3,022 | 6.75% | 52,100 |
| 123,250 | And Over | 7,875 | 7.15% | 123,250 |
Special table type:
| If Over | But Not Over | Tax Amount | Tax Rate | On Excess Over |
|---|---|---|---|---|
| 0 | 194,300 | 0 | 0 | 26,350 |
| 194,300 | 344,300 | 150,000 | 0 | 0 |
Withholding changes for Michigan
- The Personal Exemption Amount is $5,600 from $5,000
- The Tax Rate remains at 4.25%
Withholding changes for Missouri
- The Standard Deduction is $21,900 prior $20,800 for filing status HOH
- The Standard Deduction is $29,200 prior $27,700 for filing status MAR1
- The Standard Deduction is $14,600 prior $13,850 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,273 | 0 | 0% | 0 |
| 1,273 | 2,546 | 0 | 2.0% | 1,273 |
| 2,546 | 3,819 | 25 | 2.5% | 2,546 |
| 3,819 | 5,092 | 57 | 3.0% | 3,819 |
| 5,092 | 6,365 | 95 | 3.5% | 5,092 |
| 6,0365 | 7,638 | 140 | 4.0% | 6,365 |
| 7,638 | 8,911 | 191 | 4.5% | 7,638 |
| 8,911 | And over | 248 | 4.8% | 8,911 |
Withholding changes for Montana
The Personal Exemption amount is $0 formerly $2,070
Tax Type rates for MAR Filing Status:
| If Over | But Not Over | Tax Amount | Tax Rate | On Excess Over |
|---|---|---|---|---|
| 0 | 29,200 | 0 | 0% | 0 |
| 29,200 | 70,200 | 0 | 4.70% | 29,200 |
| 70,200 | And Over | 1,927 | 5.9% | 70,200 |
Tax Type rates for SINGLE Filing Status:
| If Over | But Not Over | Tax Amount | Tax Rate | On Excess Over |
|---|---|---|---|---|
| 0 | 14,600 | 0 | 0% | 0 |
| 14,600 | 35,100 | 0 | 4.70% | 14,600 |
| 35,100 | And Over | 964 | 5.9% | 35,100 |
Withholding changes for Nebraska
The Personal Exemption amount is $2,250 formerly $2,140 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,680 | 0 | 0 | 0 |
| 7,680 | 12,190 | 0 | 2.26% | 7,680 |
| 12,190 | 30,360 | 101.93 | 3.22% | 12,190 |
| 30,360 | 47,230 | 687.00 | 4.91% | 30,360 |
| 47,230 | 58,600 | 1,515.32 | 5.77% | 47,230 |
| 58,600 | 77,710 | 2,171.37 | 5.94% | 58,600 |
| 77,710 | And over | 3,306.50 | 6.10% | 77,710 |
Withholding rates for taxpayers filing as SINGLE:
| If Over | But Not Over | Tax Amount | Tax Rate | On Excess Over |
|---|---|---|---|---|
| 0 | 3,210 | 0 | 0 | 0 |
| 3,210 | 6,290 | 0 | 2.26% | 3,210 |
| 6,290 | 20,440 | 69.61 | 3.22% | 6,290 |
| 20,440 | 29,620 | 525.24 | 4.91% | 20,440 |
| 29,620 | 37,610 | 975.98 | 5.77% | 29,620 |
| 37,610 | 70,630 | 1,437.00 | 5.94% | 37,610 |
| 70,630 | And over | 3,398.39 | 6.10% | 70,630 |
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 | 14,600 | 0 | 0% | 0 |
| 14,600 | 22,600 | 0 | 1.70% | 14,600 |
| 22,600 | 30,600 | 136.00 | 3.2% | 22,600 |
| 30,600 | 38,600 | 392.00 | 4.7% | 30,600 |
| 38,600 | 54,600 | 768.00 | 4.9% | 38,600 |
| 54,600 | 78,600 | 1,552.00 | 4.9% | 54,600 |
| 78,600 | 114,600 | 2,728.00 | 4.9% | 78,600 |
| 114,600 | 214,600 | 4,492.00 | 4.9% | 114,600 |
| 214,600 | 329,600 | 9,392.00 | 4.9% | 214,600 |
| 329,600 | And Over | 15,027.00 | 5.9% | 329,600 |
Withholding rates for taxpayers filing as SINGLE:
| If Over | But Not Over | Tax Amount | Tax Rate | On Excess Over |
|---|---|---|---|---|
| 0 | 7,300 | 0 | 0% | 0 |
| 7,300 | 12,800 | 0 | 1.7% | 7,300 |
| 12,800 | 18,300 | 93.50 | 3.2% | 12,800 |
| 18,300 | 23,300 | 269.50 | 4.7% | 18,300 |
| 23,300 | 33,300 | 504.50 | 4.9% | 23,300 |
| 33,300 | 49,300 | 994.50 | 4.9% | 33,300 |
| 49,300 | 72,300 | 1,778.50 | 4.9% | 49,300 |
| 72,300 | 132,300 | 2,905.50 | 4.9% | 72,300 |
| 132,300 | 217,300 | 5,845.50 | 4.9% | 132,300 |
| 217,300 | And Over | 10,010.50 | 5.9% | 217,300 |
Withholding rates for taxpayers filing as HOH:
| If Over | But Not Over | Tax Amount | Tax Rate | On Excess Over |
|---|---|---|---|---|
| 0 | 10,950 | 0 | 0% | 0 |
| 10,950 | 18,950 | 0 | 1.7% | 10,950 |
| 18,950 | 26,950 | 136.00 | 3.2% | 18,950 |
| 26,950 | 34,950 | 392.00 | 4.7% | 26,950 |
| 34,950 | 50,950 | 768.00 | 4.9% | 34,950 |
| 50,950 | 74,950 | 1,552.00 | 4.9% | 50,950 |
| 74,950 | 110,950 | 2,728.00 | 4.9% | 74,950 |
| 110,950 | 210,950 | 4,492.00 | 4.9% | 110,950 |
| 210,950 | 325,950 | 9,392.00 | 4.9% | 210,950 |
| 325,950 | And Over | 15,027.00 | 5.9% | 325,950 |
Withholding changes for North Carolina
- Standard Deduction for HOH remains at $19,125
- Standard Deduction for MAR and SINGLE remains at $12,750
- Tax rate for all filing status is 4.6%
Withholding changes for Oregon
- The Standard Deduction Amount is $5,495 for MS3 and S3 Filing Status.
- The Standard Deduction Amount is $2,745 for S2 Filing Status.
- The Personal Exemption amount is $249 for all Filing Status.
- New Filing status for 2020 NOWH (No Withholding Provided) Flat tax rate of 8% (remains for 2024 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 | 8,250 | 0% | 0 |
| 49,999 | 249,999 | 8,250 | 0% | 0 |
| 249,999 | 259,999 | 6,600 | 0% | 0 |
| 259,999 | 269,999 | 4,950 | 0% | 0 |
| 269,999 | 279,999 | 3,300 | 0% | 0 |
| 279,999 | 289,999 | 1,650 | 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 | 8,250 | 0% | 0 |
| 49,999 | 124,999 | 8,250 | 0% | 0 |
| 124,999 | 129,999 | 6,600 | 0% | 0 |
| 129,999 | 134,999 | 4,950 | 0% | 0 |
| 134,999 | 139,999 | 3,300 | 0% | 0 |
| 139,999 | 144,999 | 1,650 | 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 | 36,255 | 0 | 0% | 0 |
| 36,255 | 250,000 | 1,280 | 8.75% | 21,500 |
| 250,000 | And over | 21,274 | 9.9% | 250,000 |
Tax Type rates for S2 Filing Status:
| If Over | But Not Over | Tax Amount | Tax Rate | On Excess Over |
|---|---|---|---|---|
| 0 | 39,005 | 0 | 0% | 0 |
| 39,005 | 125,000 | 639 | 8.75% | 10,750 |
| 125,000 | And Over | 10,636 | 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 | 8,600 | 249 | 4.75% | 0 |
| 8,600 | 21,500 | 658 | 6.75% | 8,600 |
| 21,500 | 50,000 | 1,529 | 8.75% | 21,500 |
Low Income Type rates for S2 Filing Status:
| If Over | But Not Over | Tax Amount | Tax Rate | On Excess Over |
|---|---|---|---|---|
| 0 | 4,300 | 249 | 4.75% | 0 |
| 4,300 | 10,750 | 453 | 6.75% | 4,300 |
| 10,750 | 50,000 | 888 | 8.75% | 10,750 |
Withholding changes for Rhode Island
For all Filing Status the Personal Exemption ($1,000) wage limit increased to $274,650
Withholding rates for taxpayers filing as MAR and SINGLE:
| If Over | But Not Over | Tax Amount | Tax Rate | On Excess Over |
|---|---|---|---|---|
| 0 | 77,450 | 0 | 3.75% | 0 |
| 77,450 | 176,050 | 2,904.38 | 4.75% | 77,450 |
| 176,050 | And Over | 7,587.88 | 5.99% | 176,050 |
Withholding changes for South Carolina
- The Personal Exemption is $4,610 for Filing Status ONE.
- The Standard Deduction Maximum is $6,925 for ONE Filing Status.
Tax Type rates for all Filing Status:
| If Over | But Not Over | Tax Amount | Tax Rate | On Excess Over |
|---|---|---|---|---|
| 0 | 3,460 | 0 | 0.0% | 0 |
| 3,460 | 17,330 | -103.80 | 3.0% | 0 |
| 17,330 | And over | -693.02 | 6.4% | 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.
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 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.
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)
Select an update method, and then choose Next.
- 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.
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.
Choose Process to start the update.
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 7/12/2024.
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.