Import employee and employer rates into Employee Deductions

Trying to import the Employer Amount into Employee Deductions and it's not updating.

• Payroll

• Employee Deductions

• Deduction and Benefit Master

• Premium Tables

• Employee Import

1. Go to Deduction and Benefit Master. (Human Resources/Payroll>Payroll>Payroll Setup>Deduction and Benefit Master)

2. Click Search. Define deduction code. Click Accept. 

3. Note the Calc Code field. If this is, 23 - HEALTH INS - PREMIUM TABLE, importing the employer or employee amount will not work.

4. Go to Employee Deductions. (Human Resources/Payroll>Payroll>Employee Maintenance>Employee Deductions)

5. Click Search. Define example employee not updating correctly. Click Accept.

6. Click the Health Insurance Tab. Note the Carrier, Plan, Coverage and Level. 

7. Go to Premium Tables program. (Human Resources/Payroll>Payroll>Payroll Setup>Deduction and Benefit Master. Click Premium Table in the Menu)

8. Click Search. Define Carrier, Plan, Coverage and Level from Employee Deduction record. Click Accept. 

   1. If the rates are incorrect, you will need to create new tables with the new rates/effective date. For more information on the Premium Table Import, see documentation in Addition Information.

   2. Once the new tables are created, the employee/employer rates will automatically pull into the Employee's Deduction record.

When using a calc code 23-premium table for a deduction, the system will always look to the premium table to pull rates, which will override the rates on an import. 

Insurance Premium Table Import