Standard 401k to Alliance Benefit Group

Sep 10, 2026

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

Source File	Destination file
Standard 401k	Alliance Benefit Group

File Specifications

File Type Generated	CSV
Header Row(s) Generated	Yes
Footer Row(s) Generated	No
End of Row Character	CRLF
File Naming Generated	Production: [PlanId]_MMDDYYYYHHMMSSFFF.csv Testing: [PlanId]_Test_MMDDYYYYHHMMSSFFF.csv

Field Mappings

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

Field	ABG Field Name	Standard 401k Field Name	Details
1	SSN	SSN	###-##-####
2	LastName	LAST NAME	MM/DD/YYYY
3	FirstName	FIRST NAME
4	Middle Name	MIDDLE NAME/INITIAL
5	BirthDate	DOB	MM/DD/YYYY
6	HireDate	HIRE DATE	MM/DD/YYYY
7	TerminationDate	TERMINATION DATE	MM/DD/YYYY
8	RehireDate	REHIRE DATE	MM/DD/YYYY
9	InternetAddress	EMAIL
10	Phone number	PHONE	###-###-####
11	Address 1	ADDRESS LINE 1
12	Address 2	ADDRESS LINE 2
13	City	CITY
14	State Code	STATE
15	Postal Code	ZIP
16	CurrentPeriodHours	CURRENT PAY PERIOD HOURS WORKED
17	CurrentPeriodSalary	CURRENT PAY PERIOD GROSS PAY
18	EERoth	CURRENT PAYROLL EMPLOYEE ROTH CONTRIBUTION
19	EEDeferral	CURRENT PAYROLL EMPLOYEE PRETAX CONTRIBUTION
20	Employer contribution	CURRENT PAYROLL EMPLOYER MATCH CURRENT PAYROLL SAFE HARBOR MATCH
21	SafeHarbor	CURRENT PAYROLL SAFE HARBOR NON ELECTIVE
22	401kLoan	401K LOAN 1 REPAYMENT 401K LOAN 2 REPAYMENT	Sum loans
23	Pay Date	PAYROLL CHECK DATE	MM/DD/YYYY
24	Pay Period Begin	PAY PERIOD START DATE	MM/DD/YYYY
25	Pay Period End	PAY PERIOD END DATE	MM/DD/YYYY
26	Pay Frequency	PAY PERIOD START DATE PAY PERIOD END DATE	B = Biweekly W = Weekly S = Semi-Monthly M = Monthly Q = Quarterly A = Annually
27	Plan ID	PLAN ID

Tags