Standard 401k to Alerus 3(16)

Travis Viall

Apr 16, 2026

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

Source File	Destination file
Standard 401k	Alerus 3(16)

File Specifications

File Type Generated	CSV
Header Row(s) Generated	No
Footer Row(s) Generated	Yes
End of Row Character	CRLF (Carriage Return Line Feed)
File Naming Generated	[PLANID]_[current date in YYYYMMDD]_[current time in HHMMSSSF].csv

Field Mappings

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

BODY

Field	Alerus Field Name	Standard 401k Field Name	Details
1	Social Security Number	SSN	Numeric only
2	Last Name, First Name MI	LAST NAME FIRST NAME
3	Street Address 1	ADDRESS LINE 1
4	Street Address 2	ADDRESS LINE 2
5	City	CITY
6	State	STATE
7	Zip + 4	ZIP	Numeric only
8	Division/Location/Excluded Employees	RESERVED FIELD
9	Date of Birth	DOB	YYYYMMDD
10	Original Date of Hire	HIRE DATE	YYYYMMDD
11	Placeholder		YYYYMMDD
12	Date of Rehire	REHIRE DATE	YYYYMMDD
13	Date of Term	TERMINATION DATE	YYYYMMDD
14	Current Pay Period - Hours	CURRENT PAY PERIOD HOURS WORKED	Round 2 decimals
15	Current Pay Period - Gross Compensation	CURRENT PAY PERIOD GROSS PAY	Round 2 decimals
16	Current Pay Period - Excluded Compensation
17	Current Pay Period - Employee Deferral	CURRENT PAYROLL EMPLOYEE PRETAX CONTRIBUTION	Round 2 decimals
18	Current Pay Period - Employee Roth Deferral	CURRENT PAYROLL EMPLOYEE ROTH CONTRIBUTION	Round 2 decimals
19	Current Pay Period - Employer Match	CURRENT PAYROLL EMPLOYER MATCH CONTRIBUTION	Round 2 decimals
20	Current Pay Period - Employer Discretionary		Round 2 decimals
21	Current Pay Period - Employee After-Tax Deferrals	CURRENT PAYROLL EMPLOYEE POSTTAX CONTRIBUTION	Round 2 decimals
22	Current Pay Period - Safe Harbor Profit Sharing	CURRENT PAYROLL SAFE HARBOR NON ELECTIVE	Round 2 decimals
23	Current Pay Period - Safe Harbor Match	CURRENT PAYROLL SAFE HARBOR EMPLOYER MATCH	Round 2 decimals
24	Current Pay Period - Pension	CURRENT PAYROLL QUALIFIED ELECTIVE CONTRIBUTION	Round 2 decimals
25	Current Pay Period - Loan Payments	401k LOAN 1 REPAYMENT	Round 2 decimals
26	Payroll Frequency	PAY PERIOD START DATE PAY PERIOD END DATE	WEEKLY = 7 BI-WEEKLY = 6 SEMI-MONTHLY=5 MONTHLY = 4
27	Employee Type	RESERVED FIELD	N/A = 0 Full time = 1 Part time = 2 Seasonal = 3 Leased = 4 Union = 5 Non-Resident Alien = 6 Student = 7 Less than Required = 8 Inactive = 9 Expatriate = A
28	Expected Annual Salary
29	Company Email Address
30	Personal Email Address	EMAIL
31	Mobile Phone Number	PHONE	Numeric only

Footer

Field	Alerus Field Name	Standard 401k Field Name	Details
Field	Alerus Field Name	Standard 401k Field Name	Details
1	Placeholder
2	Payroll Date	PAYROLL CHECK DATE	YYYYMMDD
3	Multi ACH Acct ID		moov configuration override if needed
4	Placeholder
5	Placeholder
6	Placeholder
7	Placeholder
8	Placeholder
9	Placeholder
10	Placeholder
11	Placeholder
12	Placeholder
13	Placeholder
14	Placeholder
15	Placeholder
16	Placeholder
17	Total Current Pay Period - Employee Deferral	CURRENT PAYROLL EMPLOYEE PRETAX CONTRIBUTION	Sum of all employees
18	Total Current Pay Period - Employee Roth Deferral	CURRENT PAYROLL EMPLOYEE ROTH CONTRIBUTION	Sum of all employees
19	Total Current Pay Period - Employer Match	CURRENT PAYROLL EMPLOYER MATCH CONTRIBUTION	Sum of all employees
20	Total Current Pay Period - Employer Discretionary		Sum of all employees
21	Total Current Pay Period - Employee After-Tax Deferrals	CURRENT PAYROLL EMPLOYEE POSTTAX CONTRIBUTION	Sum of all employees
22	Total Current Pay Period - Safe Harbor Profit Sharing	CURRENT PAYROLL SAFE HARBOR NON ELECTIVE CONTRIBUTION	Sum of all employees
23	Total Current Pay Period - Safe Harbor Match	CURRENT PAYROLL SAFE HARBOR EMPLOYER MATCH	Sum of all employees
24	Total Current Pay Period - Pension	CURRENT PAYROLL QUALIFIED ELECTIVE CONTRIBUTION	Sum of all employees
25	Total Current Pay Period - Loan Payments	401k LOAN 1 REPAYMENT	Sum of all employees
26	Placeholder
27	Placeholder

Tags