Standard 401k to Ascensus

Travis Viall

Dec 08, 2025

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

Source File	Destination file
Standard 401k	Ascensus

File Specifications

File Type Generated	CSV
Header Row(s) Generated	Yes
Footer Row(s) Generated	No
End of Row Character	CRLF
File Naming Generated	[PlanId]_[CheckDate in YYYYMMDD].csv

Field Mappings

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

Header Record

Ascensus Field Name	Standard 401k Field Name	Details
PLAN NUMBER	PLAN ID
PAYROLL DATE	PAYROLL CHECK DATE	MM/DD/YYYY
SITE		GIVEN TO THE COMPANY FROM THE ASCENSUS SYSTEM. A PLAN WILL HAVE MULTIPLE SITES IF THEY HAVE MULTIPLE PAY FREQUENCIES OR MULTIPLE BANK ACCOUNTS THAT THEY WILL FUND FROM

Body

Ascensus Field Name	Standard 401k Field Name	Details
SOCIAL SECURITY	SSN	###-##-#### or #########
LAST NAME	LAST NAME	No accent or like characters accepted
FIRST NAME	FIRST NAME	No accent or like characters accepted
MI	MIDDLE NAME/INITIAL
DIVISIONAL CODE
TOTAL COMPENSATION	CURRENT PAY PERIOD GROSS PAY
EMPLOYEE 401K	CURRENT PAYROLL PRETAX CONTRIBUTION
ROTH 401K	CURRENT PAYROLL ROTH CONTRIBUTION
LOAN PAYMENT AMOUNT	401K LOAN 1 CONTRIBUTION 401K LOAN 2 CONTRIBUTION	Sum values
MATCH	CURRENT PAYROLL EMPLOYER MATCH CONTRIBUTION
PROFIT SHARING	CURRENT PAYROLL NON ELECTIVE CONTRIBUTION
SAFE HARBOR MATCH	CURRENT PAYROLL SAFE HARBOR EMPLOYER MATCH
SAFE HARBOR NEC	CURRENT PAYROLL SAFE HARBOR NON ELECTIVE
CLIENT SPECIFIC
CLIENT SPECIFIC
CLIENT SPECIFIC
HOURS	CURRENT PAY PERIOD HOURS WORKED
ADDRESS 1	ADDRESS LINE 1
ADDRESS 2	ADDRESS LINE 2
CITY	CITY
STATE	STATE
ZIP	ZIP
DATE OF BIRTH	DOB	MM/DD/YYYY
CURRENT DATE OF HIRE	HIRE DATE OR REHIRE DATE	MM/DD/YYYY Most Recent Date
EMPLOYEE ELIGIBILITY DATE	ELIGIBILITY DATE	MM/DD/YYYY
CURRENT DATE OF TERM	TERMINATION DATE & REHIRE DATE	MM/DD/YYYY If rehire date is null, set to termination date, else leave empty.
PRIOR DATE OF HIRE	HIRE DATE	MM/DD/YYYY Only if a Rehire Date exists
PRIOR DATE OF TERM	TERMINATION DATE & REHIRE DATE	MM/DD/YYYY If rehire date is not null, set to termination date, else leave empty.
ESTIMATE ANNUAL COMPENSATION
EMPLOYMENT STATUS
HCE CODE
KEY EE CODE
ENROLLMENT ELIGIBILITY
UNION STATUE CODE
EMPLOYEE WORK EMAIL	EMAIL

Tags