/
How to import yearly employee accumulators

How to import yearly employee accumulators

Description of Issue
  • User needs to add yearly accumulators for COVID wages or Employer Paid HSA deductions for a lot of employees so that they can be reported on W-2s. Looking for a way to import that information.
  • Need to report employer amount of the employer sponsored health insurance on the W2s on Box 12
Context
  • EERP Payroll
  • Employee Accumulators
  • Import Yearly Employee Accumulators
  • W-2 Processing
  • W2 Processing
Cause

Instructional.

Resolution
  1. Create an Excel import file and save. (.CSV Format is recommended)
    1. Available options are Employee Number, SSN, Employee Amount, Employer Amount, Employee Gross, Hours, Pay/Deduction.
  2. Go to Employee Accumulators (Payroll>Payroll Administration>Employee Accumulators).
  3. Click Import in the toolbar.
  4. Click Custom Templates.
  5. Click New Template to create the Custom Template to match the Import file fields.  
    1. Give the Template a name.
    2. Define the delimiter if applicable (Other, then define a comma (,) if using CSV; leave as None if using an Excel file).
    3. Select the file by clicking Browse.
    4. If the file has headers, check boxes for File contains headers and Attempt field matching based on headers.
  6. Click Upload.
  7. If any column names are missing, use the white arrow to select the correct option from the dropdown.
  8. Click Save.
  9. Go back to Import screen.
  10. Click Define.
  11. Select the Template from the drop down. Select the browse option to locate the saved excel or CSV file.
  12. Define applicable Year, Type and Pay/Deduction. 
  13. Click Accept
  14. Select preferred output option. Click OK.
  15. Review Proof report carefully.
  16. Return to Import screen. Prompt will show: xx records found that are eligible to be imported. Continue with import? Click Yes to continue or No to cancel process.
Additional Information

Utilizing Flexible Import and Exports 

- Import Yearly Accumulators

  • Please note - existing accumulators cannot be updated through the import. It can only be used to import new yearly accumulators. Existing accumulators can only be updated manually.





Related content

Using Import Years Worked to increase years of service in Employee Years of Service
Using Import Years Worked to increase years of service in Employee Years of Service
More like this
Employee Accruals-Import to update Accrual Date
Employee Accruals-Import to update Accrual Date
More like this
How to Import Pay Raise Into Employee Job Salary
How to Import Pay Raise Into Employee Job Salary
More like this
How to add new Employee Accumulators
How to add new Employee Accumulators
More like this
How to Mass End Date An Accrual Type
How to Mass End Date An Accrual Type
More like this
Employee Accrual History Import Process
Employee Accrual History Import Process
More like this