Jun 15, 2023
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.