/
Insurance deductions didn't pull into projection

Insurance deductions didn't pull into projection

Description of Issue

We have several insurance deductions that didn't pull into our projection, why didn't they pull in?

Context
  • Munis
  • Salary and Benefit Projections
  • 2017.1+
Cause

Insurance deductions that didn't pull into the projection were end dated prior to the projection start date.

Resolution

Manually update the end date

  1. Access Employee Deductions: Payroll > Employee Maintenance > Employee Deductions
  2. Search on the deduction record > click Update
  3. Enter an end date that is after the projection start date, or equal to the projection end date
  4. Click Accept
  5. Repeat for other impacted records
  6. Recreate the projection

Import deductions into the projection:

  1. Access Employee Deductions: Payroll > Employee Maintenance > Employee Deductions
  2. Search for the deductions that didn't pull into the projection and select the Excel output icon
  3. Enable the desired fields you wish to include on the import (at minimum must include employee number, deduction code, start date, and end date)
    1. Where these are insurance deductions also include the insurance carrier, coverage, plan and level
    2. add a header for Action at the end of the file and define with a value of A for each cell
  4. Access Employee Import from your projection: Human Resources > Position Control and Budgeting > Salary and Benefit Projections > Projection Start and Status > Salary Projection Processing > Projection Employee Import
  5. Click Custom TemplatesNew Template > > Employee Deduction Import  > Click OK > enter a file name, select the flat file type
  6. Click Browse select the export file you created from Employee Deductions
  7. Enable the settings for First line contains headers and Attempt field matching based on headers > Click Upload
  8. Verify the column headers on the template match the column headers on the Excel file
    1. If they don't select the appropriate header from the drop-down to match the file
  9. Click Save
  10. Return to the Employee Import screen > click Define > Enable Employee Deduction Import > Select your template from the drop-down and select your import file > Enable First line contains headers > Click Accept
Additional Information






Related content

Health Insurance deduction showing incorrect rates in projection
Health Insurance deduction showing incorrect rates in projection
More like this
Insurance Premium Error Either a valid pre-tax or Post-tax deduction is required
Insurance Premium Error Either a valid pre-tax or Post-tax deduction is required
More like this
Import for Employee Deductions in Salary and Benefit Projection
Import for Employee Deductions in Salary and Benefit Projection
More like this
Import employee and employer rates into Employee Deductions
Import employee and employer rates into Employee Deductions
More like this
Payroll Projection not using Deduction Exceptions
Payroll Projection not using Deduction Exceptions
More like this
Employee Deduction annual amount field not populating in projection
Employee Deduction annual amount field not populating in projection
More like this