/
How to set up multiple state tax table deductions

How to set up multiple state tax table deductions

Description of Issue

I need to add two state tax tables to be withheld for a remote employee

Context
  • Payroll
  • Tax Tables
  • Deduction and Benefit Master
  • Employee Deduction
Cause


Resolution

Create the states tax table in the Tax Tables Program

  1. Go to Tax Tables program. (Payroll>Payroll Setup>Income Tax Setup>Tax Tables)
  2. Click Add.
  3. Define the effective date for the new year (example, 01/01/2020), State code, Marital Status, and Pay Period field as A-Annual (or specific pay period (B-Biweekly, W-Weekly, etc) if that is how the the State Tax Tables need to be setup)
  4. Click on the Calc option in the toolbar to define any necessary amounts/percentages based on particular state's setup.  
    1. Each state has a specific setup based on the State Code used when creating the Tax Table so there may be other required options within the Calc Screen toolbar that need to be clicked and defined.
      1. For Example, CT State Tax Tables have multiple options in the toolbar that need to be defined, Recapture Amount, Credits, Exemptions, etc.) 
    2. Click Return.
  5. Click on Tax Table in the menu to define amounts for the standard withholding schedule (If necessary for particular State). Click Return.
  6. Repeat Steps 1-5 for each Marital Status that needs to be created. (Example, Married, Single and Head of Household would need three separate tables) 


If copying tables to a new year use: Copy payroll tax tables to the new year


Once the Tax Tables have been created:

  1. Go to Deduction and Benefit Master. (Payroll>Payroll Setup>Deduction and Benefit Master)
  2. Click Add to create a deduction for the new state tax. (Be sure to use 4000 range)
    1. Calc Code- 05- TAX TABLE 
      1. Or 06-TAX TABLE PLUS AMT for employees withholding an additional amount.
    2. State Code- select the state.
  3. Enter other desired field information.
  4. Click Accept.

Once the Deduction code has been created:

  1. Go to Employee Deductions. (Payroll>Employee Maintenance>Employee Deductions)
  2. Click Search. Define Employee Number.  Click Accept
  3. Click Add. Define Deduction Number. Hit TAB on keyboard to define fields as needed.
  4. Make sure to use correct Marital Status based on Tax tables created.
  5. Click Accept.

The employee will now have a deduction for each state tax that needs to be withheld. 

Additional Information






Related content

Mississippi State Tax Tables
Mississippi State Tax Tables
More like this
Illinois State Tax Table Setup
Illinois State Tax Table Setup
More like this
Louisiana 2025 State Withholding Calculation
Louisiana 2025 State Withholding Calculation
More like this
How to Setup Maine Paid Family Medical Leave Deduction for January 2025 Withholdings
How to Setup Maine Paid Family Medical Leave Deduction for January 2025 Withholdings
More like this
How to Calculate MA State Tax Before and After the Deduction Limit
How to Calculate MA State Tax Before and After the Deduction Limit
More like this
2022 Wisconsin State Income Tax Withholding Changes
2022 Wisconsin State Income Tax Withholding Changes
More like this