Standard 401k to NestEggs

Travis Viall

Nov 20, 2023

This article will describe the file transformation that has been created in detamoov to transform the standard 401k file format to the NestEggs file specifications. This transformation is used in a detamoov integration with NestEggs.

Source File	Destination file
Standard 401k	NestEggs

File Specifications

File Type Generated	CSV
Header Row(s) Generated
Footer Row(s) Generated
End of Row Character	CRLF
File Naming Generated	[Company Legal Name]_[Check Date in yyyMMMddd]_[GUID].csv

Field Mappings

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

NestEggs Field Name	Standard 401k Field Name	Field Type	Details
NestEggs Field Name	Standard 401k Field Name	Field Type	Details
SSN	SSN	STRING	Format to SSN, keep dashes
FIrst Name	FIRST NAME	STRING
Middle Name	MIDDLE NAME/INITIAL	STRING
Last Name	LAST NAME	STRING
Address 1	ADDRESS LINE 1	STRING
Address 2	ADDRESS LINE 2	STRING
City	CITY	STRING
State	STATE	STRING
Zip	ZIP	NUMBER
Work Email	EMAIL	STRING
Phone number	PHONE	STRING
Date of birth	DOB	DATE	yyyyMMdd
Date of hire	HIRE DATE	DATE	yyyyMMdd
Date of termination	TERMINATION DATE	DATE	yyyyMMdd
Date of rehire	REHIRE DATE	DATE	yyyyMMdd
Period Gross Compensation	CURRENT PAY PERIOD GROSS PAY	NUMBER
Period Hours	CURRENT PAY PERIOD HOURS WORKED	NUMBER
Pre-tax deferrals	CURRENT PAYROLL EMPLOYEE PRETAX	NUMBER
Roth deferrals	CURRENT PAYROLL EMPLOYEE ROTH	NUMBER
After-tax deferrals	CURRENT PAYROLL EMPLOYEE POSTTAX	NUMBER
Match	CURRENT PAYROLL EMPLOYER MATCH	NUMBER
Safe Harbor Match	CURRENT PAYROLL SH MATCH	NUMBER
Safe Harbor Non-Elective	CURRENT PAYROLL SH NON ELECTIVE	NUMBER
Profit Sharing	CURRENT PAYROLL NON ELECTIVE	NUMBER
Loan payment	401K LOAN 1 REPAYMENT	NUMBER
Check Date	PAYROLL CHECK DATE	DATE	yyyyMMdd
Begin Payroll Period	PAY PERIOD START DATE	DATE	yyyyMMdd
End Payroll Period	PAY PERIOD END DATE	DATE	yyyyMMdd
Division Name		NUMBER
CompensationYTD	YTD GROSS PAY	NUMBER
HoursWorkedYTD	YTD HOURS WORKED	NUMBER
401k Pre-Tax Election %		NUMBER
401k Pre-Tax Election Dollar Amount		NUMBER
Roth Election %		NUMBER
Roth Election Dollar Amount		NUMBER
Employee ID	EMPLOYEE NUMBER	STRING

Tags