You are using an unsupported browser. Please update your browser to the latest version on or before July 31, 2020.
close
You are viewing the article in preview mode. It is not live at the moment.
Home > Transformations > Prebuilt File Transformations > Standard 401k to Vestwell (all state run plans)
Standard 401k to Vestwell (all state run plans)
print icon

This article will descript the file transformation that has been created in detamoov to transform the standard 401k file format to the Vestwell (non-state rule plans) file specifications.  This transformation is used in a detamoov integration with Vestwell.

 

Source File   Destination file
Standard 401k Vestwell (state run plans)

 

File Specifications

 

File Type Generated   CSV

Header Row(s) Generated

  Yes
Footer Row(s) Generated   NO
End of Row Character   CRLF
File Naming Generated   [2 Digit State Code]_[Company EIN no dash]_[Check Date in YYYY-MM-DD]_[current time in YYYYMMHHMMSSS].csv    

 

Field Mappings

 

The table below details the specific field mapping and transformation rules applied to ensure the Vestwell csv format is created correctly from the standard 401k format.

 

Vestwell Field Name   Standard 401k Field Name   Details  
Last Name LAST NAME  
First Name FIRST NAME  
Social Security Number SSN Format SSN
Contribution Amount CURRENT PAYROLL EMPLOYEE ROTH Numeric only, round 2 decimals
UID EMPLOYEE NUMBER External Payroll ID
Division* moov configuration field override aka payroll group

 

*The Vestwell team will confirm the Division Name with each payroll provider for each test file.

scroll to top icon