Standard 401k to American Trust
Jul 25, 2025
This article will describe the file transformation that has been created in detamoov to transform the standard 401k file format to the American Trust file specifications. This transformation is used in a detamoov integration with American Trust.
| Source File | Destination file |
| Standard 401k | American Trust |
File Specifications
| File Type Generated | CSV |
| Header Row(s) Generated | Yes |
| Footer Row(s) Generated | No |
| End of Row Character | CRLF |
| File Naming Generated | [Plan Id]_[Check Date in YYYYMMDD]_[PayFrequencyCode].csv |
Field Mappings
The table below details the specific field mapping and transformation rules applied to ensure the American Trust Payroll Contribution csv format is created correctly from the standard 401k format.
Header Row
| American Trust Field Name | Standard 401k Field Name | Details |
| fileName | ||
| planId | PLAN ID | |
| checkDateActual | PAYROLL CHECK DATE | MM/DD/YYYY |
| checkDateExpected | PAYROLL CHECK DATE | MM/DD/YYYY |
| payFrequencyCode | W = Weekly B = Bi-Weekly S = Semi-Monthly M = Monthly |
|
| divisionId | ||
| offCycleFlag | ||
| fileCount | ||
| payScheduleName | ||
| payPeriodBegin | PAY PERIOD START DATE | MM/DD/YYYY |
| payPeriodEnd | PAY PERIOD END DATE | MM/DD/YYYY |
Body
| American Trust Field Name | Standard 401k Field Name | Details |
| pad_1 | ||
| pad_2 | ||
| pad_3 | ||
| divisionId | ||
| ssn | SSN | ###-##-#### |
| lastName | LAST NAME | |
| firstName | FIRST NAME | |
| gender | GENDER | M = Male F = Female All others blank |
| dateOfBirth | DOB | MM/DD/YYYY |
| dateOfHire | DATE OF HIRE | MM/DD/YYYY |
| dateOfRehire | REHIRE DATE | MM/DD/YYYY |
| dateOfTermination | DATE OF TERMINATION | MM/DD/YYYY |
| addressLine1 | ADDRESS LINE 1 | |
| addressLine2 | ADDRESS LINE 2 | |
| city | CITY | |
| state | STATE | |
| zip | ZIP | ##### or #####-#### |
| eePreTax | CURRENT PAYROLL EMPLOYEE PRETAX | |
| eeRoth | CURRENT PAYROLL EMPLOYEE ROTH | |
| erMatch | CURRENT PAYROLL EMPLOYER MATCH | |
| shMatch | CURRENT PAYROLL SH MATCH | |
| profitSharing | CURRENT PAYROLL NON ELECTIVE | |
| shNonelective | CURRENT PAYROLL SH NON ELECTIVE | |
| currPeriodComp | CURRENT PAY PERIOD GROSS PAY | |
| currPeriodHours | CURRENT PAY PERIOD HOURS WORKED | |
| maritalStatus | ||
| loanPayment | 401k LOAN 1 REPAYMENT 401k LOAN 2 REPAYMENT |
Sum |
| phoneNumber | PHONE |
